ClosedXML / ClosedXML/ClosedXML.Report

Inconsistent subtotal rows behavior

Open
#244 1 comment 0 reactions 0 assignees View on GitHub
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

![image](https://user-images.githubusercontent.com/13303069/132036490-c41ccffb-8519-48b8-9a39-2daaf9d4a3c5.png)

But the output I should get should look like this instead

![image](https://user-images.githubusercontent.com/13303069/132037043-4f283a88-6a19-4adc-ab81-50995395a540.png)

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.