CellsSubtotal Method (CellArea, Int32, ConsolidationFunction, Int32, Boolean, Boolean, Boolean)

Creates subtotals for the range.

Namespace:  Aspose.Cells
Assembly:  Aspose.Cells (in Aspose.Cells.dll) Version: 20.9.0.0 (20.9)
Syntax
public void Subtotal(
	CellArea ca,
	int groupBy,
	ConsolidationFunction function,
	int[] totalList,
	bool replace,
	bool pageBreaks,
	bool summaryBelowData
)

Parameters

ca
Type: Aspose.CellsCellArea
The range
groupBy
Type: SystemInt32
The field to group by, as a zero-based integer offset
function
Type: Aspose.CellsConsolidationFunction
The subtotal function.
totalList
Type: SystemInt32
An array of zero-based field offsets, indicating the fields to which the subtotals are added.
replace
Type: SystemBoolean
Indicates whether replace the current subtotals
pageBreaks
Type: SystemBoolean
Indicates whether add page break between groups
summaryBelowData
Type: SystemBoolean
Indicates whether add summarry below data.
See Also