ClosedXML.Report icon indicating copy to clipboard operation
ClosedXML.Report copied to clipboard

Inconsistent subtotal rows behavior

Open ThunderCls opened this issue 3 years ago • 1 comments

ClosedXML.Report version used: 0.2.4

Correct me if I'm wrong but the expected behavior when disabling subtotals in a grouped column should be to skip the subtotal rows creation altogether, right? Why would you want an empty subtotal row?. In my case I'm using grouping on two columns but I only want the subtotal on the outermost column and not on the "children" groups. My expressions look like this:

ColumnA: <<group DisableOutline MergeLabels=Merge2>>
ColumnB: <<group DisableOutline DisableSubtotals MergeLabels=Merge2>>

The output I'm getting looks like this

image

But the output I should get should look like this instead

image

On a side note the "DisableOutline" flag doesn't look like is doing anything since an outline is still created on the left hand side of the sheet anyways.

ThunderCls avatar Sep 03 '21 16:09 ThunderCls

Currently the DisableSubtotals and DisableOutline options are not supported for MergeLabels=Merge2 mode.

b0bi79 avatar Sep 04 '21 18:09 b0bi79