Group rows with collapse/expand option above collapsed rows

[nitinsontakke94]

I have gone through the tutorial "Create Excel Group in C#, VB.NET" to create excel groups in c# but couldn't find an option to have the collapse/expand option above collapsed rows.

I know this can be done manually in excel sheet. In excel 2013, data tab, Outline settings, after unchecking "Summary rows below detail" the collapse/expand icon moves above the details.
My question is, how can we do this through code?

[Betsy.jiang]

Dear nitinsontakke94,

Thanks for your inquiry.
Sorry that at present Spire.XLS doesn't support that setting. But we have added it as new feature into our schedule, once there is any progress, we will notify you soon.

Sincerely,
Betsy
E-iceblue support team

[Betsy.jiang]

Dear nitinsontakke94,

By further investigation, we found there are some properties can set that setting.
Here is sample code for your reference.

Code: Select all

            sheet.PageSetup.IsSummaryColumnRight = false;
            sheet.PageSetup.IsSummaryRowBelow = false;

Sorry for my mistake. If there is any question, welcome to get it back to us.

Sincerely,
Betsy
E-iceblue support team

[nitinsontakke94]

Used this line from your code for my task.

Code: Select all

sheet.PageSetup.IsSummaryRowBelow = false;

Thanks for the reply!

[Betsy.jiang]

Dear nitinsontakke94,

Thanks for your feedback.
Please feel free to contact us if there is any question. We are here for help.

Sincerely,
Betsy
E-iceblue support team