aspose.cells

Class SubtotalSetting

Represents the setting of the subtotal .

Property Getters/Setters Summary
functiongetGroupBy()
The field to group by, as a zero-based integer offset
functiongetSubtotalFunction()
The subtotal function. The value of the property is ConsolidationFunction integer constant.
functiongetSummaryBelowData()
Indicates whether add summary below data.
functiongetTotalList()
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.