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();
}

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.