ClosedXML / ClosedXML/ClosedXML.Report
Inconsistent subtotal rows behavior
- Dominant language
- C#
- Stars
- 647
- Forks
- 122
- PR merge metrics
- No merged PRs in 30d
Description
**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: <>
ColumnB: <>
```
The output I'm getting looks like this

But the output I should get should look like this instead

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.
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by reproducing the report with the two grouped columns and the shown expressions, comparing the generated sheet with the expected image. Investigate how DisableSubtotals and DisableOutline affect grouped output. Done means child groups produce no empty subtotal rows and the outline setting matches its documented behavior.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- csharp
- Domain
- tooling
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100