aspose.cells

Classes

Constants

Class SubtotalSetting

Represents the setting of the subtotal .

Property Getters/Setters Summary
`function`	`getGroupBy()`
	The field to group by, as a zero-based integer offset
`function`	`getSubtotalFunction()`
	The subtotal function. The value of the property is ConsolidationFunction integer constant.
`function`	`getSummaryBelowData()`
	Indicates whether add summary below data.
`function`	`getTotalList()`
	An array of zero-based field offsets, indicating the fields to which the subtotals are added.

- Property Getters/Setters Detail
  - getGroupBy : Number
```
function getGroupBy()
```
    The field to group by, as a zero-based integer offset
  - getSubtotalFunction : Number
```
function getSubtotalFunction()
```
    The subtotal function. The value of the property is ConsolidationFunction integer constant.
  - getTotalList : int[]
```
function getTotalList()
```
    An array of zero-based field offsets, indicating the fields to which the subtotals are added.
  - getSummaryBelowData : boolean
```
function getSummaryBelowData()
```
    Indicates whether add summary below data.