Change group settings (suppress group summary)

[Administrator]

Hi,

How I can change the group settings located in 'Data\Group and Outline\Settings...'?

I need to suppress the 'Summary rows below detail' (see also attachment).

Regards,
Jani

ExcelGroupSettings.zip

[Melba Winshia]

Hi Jani,

Use the following code snippets to suppress the 'Summary rows below'.

[C#]

//Suppress the 'Summary rows below '.
sheet.PageSetup.IsSummaryRowBelow=false;
sheet.PageSetup.IsSummaryColumnRight=false;

Here is the sample for your reference:

summary_row.zip

Please take a look at the sample above and let me know if you have any other questions.

Thanks,
Melba