Cells.Subtotal
Contents
[
Hide
]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
- struct CellArea
- enum ConsolidationFunction
- class Cells
- namespace Aspose.Cells
- assembly Aspose.Cells
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
- struct CellArea
- enum ConsolidationFunction
- class Cells
- namespace Aspose.Cells
- assembly Aspose.Cells