Document Solutions for Excel, Java Edition | Document Solutions
com.grapecity.documents.excel Package / IRange Interface / subtotal Method / subtotal(int,ConsolidationFunction,int[],boolean,boolean,SummaryRow) Method
The field to group by, as a one-based integer offset.
The subtotal function.
An array of 1-based field offsets, indicating the fields to which the subtotals are added.
True to replace existing subtotals. The default value is True.
True to add page breaks after each group. The default value is False.
Places the summary data relative to the subtotal. The default value is Below.
In This Topic
    subtotal(int,ConsolidationFunction,int[],boolean,boolean,SummaryRow) Method
    In This Topic
    Creates subtotals for the range.
    Syntax
    void subtotal( 
   int groupBy,
   ConsolidationFunction subtotalFunction,
   int[] totalList,
   boolean replace,
   boolean pageBreaks,
   SummaryRow summaryRowLocation
)

    Parameters

    groupBy
    The field to group by, as a one-based integer offset.
    subtotalFunction
    The subtotal function.
    totalList
    An array of 1-based field offsets, indicating the fields to which the subtotals are added.
    replace
    True to replace existing subtotals. The default value is True.
    pageBreaks
    True to add page breaks after each group. The default value is False.
    summaryRowLocation
    Places the summary data relative to the subtotal. The default value is Below.
    See Also

    Reference

    IRange Interface
    IRange Members
    Overload List