IXlsTableBreaks

COM interface ( getting help with interfaces )

interface IXlsTableBreaks : IDispatch
{

  [id(1)        ] HRESULT DistinctValues();
  [id(2)        ] HRESULT Apply();
  [id(3),propget] HRESULT Formula([out, retval] BSTR* breakFormula);
  [id(3),propput] HRESULT Formula([in] BSTR breakFormula);
  [id(4),propget] HRESULT Subtotals([out, retval]IXlsTableSubtotals** subtotals);

}

HRESULT DistinctValues();
defines breaks on distinct column values to the table.

HRESULT Apply();
applies the breaks to the table and computes the sub-totals.

HRESULT Formula([out, retval] BSTR* breakFormula);
returns the formula used to compute breaks. Can use one or more columns. Example : breaking on hours over a time column would be : =HOUR([TIME])

HRESULT Formula([in] BSTR breakFormula);
sets the formula used to compute breaks. Can use one or more columns. Example : breaking on hours over a time column would be : =HOUR([TIME])

HRESULT Subtotals([out, retval]IXlsTableSubtotals** subtotals);
returns the subtotals object.