Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Tue Feb 07, 2017 5:46 am

Hello!

In C#,
If I use the below code for grouping rows, the inner groups are not collapsed by default in the final excel. Only the outer group is collapsed.
Code: Select all
//InnerGroup1
sheet.GroupByRows(2,3,true);
//InnerGroup2
sheet.GroupByRows(5,6,true);
//Outer Group
sheet.GroupByRows(2,7,true);


So when I expand the outer group, I want the inner groups to be collapsed by default.
How can I achieve this?

Thanks,
Nitin

nitinsontakke94
 
Posts: 7
Joined: Thu Dec 08, 2016 10:16 am

Tue Feb 07, 2017 6:52 am

Dear Nitin,

Thanks for your inquiry.
I have noticed the issue and posted it to our Dev team, we will inform you once there is any progress.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Tue Feb 28, 2017 6:49 am

Dear Nitin,

Thanks for waiting.
Now the issue is fixed in Spire.XLS Pack Hotfix Version:7.11.59, welcome to test it.
Looking forward to your feedback.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Wed Mar 01, 2017 5:44 am

Thanks for the reply!

This works fine when "sheet.PageSetup.IsSummaryRowBelow" property is not changed. But when we set this as false, the first inner group is not collapsed by default.

So for the below code, the first inner group is not collapsed:
Code: Select all
//Sheet outline property
sheet.PageSetup.IsSummaryRowBelow = false;

//InnerGroup1
sheet.GroupByRows(3,4,true);
//InnerGroup2
sheet.GroupByRows(6,7,true);
//Outer Group
sheet.GroupByRows(2,7,true);


Thanks,
Nitin

nitinsontakke94
 
Posts: 7
Joined: Thu Dec 08, 2016 10:16 am

Wed Mar 01, 2017 6:10 am

Dear Nitin,

Thanks for your feedback.
I am afraid what you want is impossible to achieve, since with the setting the result file generated by Spire.XLS is same as the result generated by MS excel.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Wed Mar 01, 2017 9:14 am

Hi Betsy,

This is how I would get all inner groups collapsed with "IsSummaryRowBelow" property as false in MS Excel,

1. On a new sheet, uncheck the checkbox, Summary row below detail. It's in Data tab, Outline Settings.
2. Group rows 3 to 4.
3. Group rows 6 to 7.
4. Group rows 2 to 7.
5. Collapse inner groups and then the outer group.

Please note that since "Summary row below detail" checkbox is unchecked, I am grouping different rows from my initial post in this topic. Earlier I grouped rows (2,3), (5,6) and (2,7).

So my question is, can I do the same using Spire.Xls?

Thanks,
Nitin

nitinsontakke94
 
Posts: 7
Joined: Thu Dec 08, 2016 10:16 am

Wed Mar 01, 2017 9:26 am

Dear Nitin,

Sorry for my mistake that I tested the rows mentioned in initial post.
Now I have noticed the issue and posted the issue to our Dev team again, we will let you know once there is any progress.
Sorry for inconvenience caused.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Mon Apr 24, 2017 6:09 am

Dear Nitin,

Thanks for waiting.
Now the issue has been fixed in Spire.XLS Pack Version:7.12, welcome to use it.
Looking forward to your feedback.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Fri May 26, 2017 11:20 am

Hi Betsy,

Thanks for the reply!
When using "Spire.XLS Pack Version:7.12", the fix works perfectly.

Just wanted to know if this fix is also available for any Spire.Office version.

Thanks,
Nitin

nitinsontakke94
 
Posts: 7
Joined: Thu Dec 08, 2016 10:16 am

Mon May 29, 2017 2:00 am

Hello,

Thanks for your response. Sorry that it is not available for the current Spire.Office version, and it will be included in the next version, once it is available, we will let you know ASAP.

Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Wed Jun 07, 2017 5:44 am

Dear Nitin,

Sorry for long silence.
The fix is included into Spire.Office, welcome to test the latest Spire.Office Platinum Version:2.16. If there is any question, please let us know.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Return to Spire.XLS