Grouping Function's Problem

Question

Hello,

I am having problems with the row grouping function.When we have, for example, a level 6 with N elements of level 7 below, and then again level 6 with other elements of level 7 below, when grouping them manually, and also through code, I have the following problem, I only get the grouping of the level 7 of the first subgroup, but for the second one I don't get the corresponding +/- symbol. Is this a known error in excel? Is there any way to solve this problem?

Answer 1

The behaviour was alright for the version 2412 Build 16.0.18324.20092, the same software, with the same data, works different for each Excel version. The newer one (Version 2501 Build 16.0.18429.20132), does not work with grouping, and that throws an exception when I try to call the next code :

try { xlworksheet.Outline.SummaryRow = XlSummaryRow.xlSummaryAbove; } catch { } 

I thought it should work exactly the same, but that's not the case. Another thing is that in sheet.xml File, extrated from xlsl transformed to zip, has not the correspondig field for the agroupation.

Answer 2

The behavior is normal and by design, you must have at min. one row between the groups.

Andreas.