Set Summary Row

Spread.Services Documentation
Set Summary Row
Collapse All Expand All

Spread.Services Documentation > Developer's Guide > Customize User Interaction > Apply Grouping > Set Summary Row

When grouping is performed in a spreadsheet, a summary row is automatically created corresponding to each group. Summary rows are group header rows that display the group name with the information about the group that is being created.

While working with Spread.Services, you modify and customize the summary row as per the requirement using the SummaryRow property of the IOutline interface.

Refer to the following example code to set summary row.

C# | Copy Code
--- | ---

    //summary
    worksheet.Outline.SummaryRow = SummaryRow.Above;

    //Summary row will be row 4.
    worksheet.Range["5:20"].Group();
    //Summary row will be row 14.
    worksheet.Range["15:20"].Group();

Copyright © GrapeCity, inc. All rights reserved.