:: com :: sun :: star :: sheet ::

interface XSubTotalCalculatable
Description
contains methods to handle a subtotal descriptor.

The subtotal descriptor provides properties to set up the subtotal function.

See also
SheetCellRange, SubTotalDescriptor
Developers Guide
9.3.5 Spreadsheet Documents - Working with Spreadsheet Documents - Database Operations - Subtotals

Methods' Summary
createSubTotalDescriptor creates a subtotal descriptor.  
applySubTotals creates subtotals using the settings of the passed descriptor.  
removeSubTotals removes the subtotals from the current object.  
Methods' Details
createSubTotalDescriptor
XSubTotalDescriptor
createSubTotalDescriptor( [in] boolean  bEmpty );

Description
creates a subtotal descriptor.
Parameter bEmpty
if set to true , creates an empty descriptor. If set to false , fills the descriptor with previous settings of the current object (i.e. a database range).
applySubTotals
void
applySubTotals( [in] XSubTotalDescriptor  xDescriptor,
[in] boolean  bReplace );

Description
creates subtotals using the settings of the passed descriptor.
Parameter xDescriptor
the subtotal descriptor with the settings used for the subtotal operation.
Parameter bReplace
if set to true , replaces previous subtotal results.
removeSubTotals
void
removeSubTotals();

Description
removes the subtotals from the current object.
Top of Page