Subtotal

Subtotal(CellArea, int, ConsolidationFunction, int[])

Creates subtotals for the range.

public void Subtotal(CellArea ca, int groupBy, ConsolidationFunction function, int[] totalList)
Parameter Type Description
ca CellArea The range
groupBy Int32 The field to group by, as a zero-based integer offset
function ConsolidationFunction The subtotal function.
totalList Int32[] An array of zero-based field offsets, indicating the fields to which the subtotals are added.

See Also


Subtotal(CellArea, int, ConsolidationFunction, int[], bool, bool, bool)

Creates subtotals for the range.

public void Subtotal(CellArea ca, int groupBy, ConsolidationFunction function, int[] totalList, 
    bool replace, bool pageBreaks, bool summaryBelowData)
Parameter Type Description
ca CellArea The range
groupBy Int32 The field to group by, as a zero-based integer offset
function ConsolidationFunction The subtotal function.
totalList Int32[] An array of zero-based field offsets, indicating the fields to which the subtotals are added.
replace Boolean Indicates whether replace the current subtotals
pageBreaks Boolean Indicates whether add page break between groups
summaryBelowData Boolean Indicates whether add summary below data.

See Also