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

How to do grouping inside nested range?

Open fingers10 opened this issue 6 years ago • 5 comments

Hi

Grouping works inside nested range? Any sample template for that? Please assist.

I checked grouping works inside nested range. but <<group MergeLabels placetocolumn=n>><<Delete>> not working. Please assist

Thanks, Abdul

fingers10 avatar Aug 22 '19 14:08 fingers10

Send what you want to get. I’ll think about how to help.

b0bi79 avatar Aug 24 '19 07:08 b0bi79

Example in the attached excel, Category values is placed in both column B and C NestedGrouping Test.xlsx

fingers10 avatar Aug 24 '19 18:08 fingers10

Any ideas/hints for this? Right now I made a grouping in code as per my need using linq and pass that simple collection to excel. But why this didn't work the normal way? Is this a bug?

fingers10 avatar Aug 27 '19 18:08 fingers10

Sorry for the long reply. I studied your template and thought for a long time how to make it work. We can add support for groups in nested regions, but this is difficult to implement. It takes a lot of time. I will leave this task for the future.

b0bi79 avatar Aug 29 '19 06:08 b0bi79

Yeah No problem. Thanks for the reply. Right now the workaround is to do necessary grouping using LINQ in code and we can get the results as per our requirements. I'm happy that I can atleast contribute by finding issues.

Cheers, Abdul

fingers10 avatar Aug 29 '19 07:08 fingers10