GrapeCity.Documents.Excel Namespace / IRange Interface / Subtotal Method
The field to group by, as a one-based integer offset.
The subtotal function.
An array of 1-based field offsets, indicating the fields to which the subtotals are added.
True to replace existing subtotals. The default value is True.
True to add page breaks after each group. The default value is False.
Places the summary data relative to the subtotal.
In This Topic
Subtotal Method
In This Topic
Creates subtotals for the range.
Syntax
void Subtotal( 
   System.int groupBy,
   ConsolidationFunction subtotalFunction,
   System.Collections.Generic.IEnumerable<int> totalList,
   System.bool replace,
   System.bool pageBreaks,
   SummaryRow summaryRowLocation
)

Parameters

groupBy
The field to group by, as a one-based integer offset.
subtotalFunction
The subtotal function.
totalList
An array of 1-based field offsets, indicating the fields to which the subtotals are added.
replace
True to replace existing subtotals. The default value is True.
pageBreaks
True to add page breaks after each group. The default value is False.
summaryRowLocation
Places the summary data relative to the subtotal.
See Also