IXlsPredefinedCondition

COM interface ( getting help with interfaces )

interface IXlsPredefinedCondition : IDispatch
{
  [id(1)] HRESULT AlternateRows([in]int alternateRow);
  [id(2)] HRESULT AlternateColumns([in]int alternateColumn);
  [id(3)] HRESULT TopValues([in]int tops);
  [id(4)] HRESULT BottomValues([in]int bottoms);
  [id(5)] HRESULT HideErrors();
  [id(6)] HRESULT IsNumber();
  [id(7)] HRESULT IsFormula();
  [id(8)] HRESULT GroupBy([in]int column);

}

HRESULT AlternateRows([in]int alternateRow);
creates alternate rows. The parameter defines the i-th row where it applies modulo 2. Pass 0 so that it applies to rows 0, 2, 4, ...Pass 1 so that it applies to rows 1, 3, 5, ...

HRESULT AlternateColumns([in]int alternateColumn);
creates alternate columns. The parameter defines the i-th column where it applies modulo 2. Pass 0 so that it applies to columns 0, 2, 4, ...Pass 1 so that it applies to columns 1, 3, 5, ...

HRESULT TopValues([in]int tops);
creates a top rank of the top values. The parameter defines how many top values you need.

HRESULT BottomValues([in]int bottoms);
creates a bottom rank of the bottom values. The parameter defines how many bottom values you need.

HRESULT HideErrors();
hides the calculation errors such as #N/A, #DIV/0!, ... This works ideally if the font color and background color of the associated formatting style are the same.

HRESULT IsNumber();
highlights cells storing numbers.

HRESULT IsFormula();
highlights cells storing formulas.

HRESULT GroupBy([in]int column);
groups rows by the i-th column (begins at 1), using the font color in the style and a bottom border in each group.