 |
| IXlsConditionalFormatting |
|
COM interface ( getting help with interfaces )
interface IXlsConditionalFormatting : IDispatch
{
[id(1),propget] HRESULT CellCondition([out, retval]IXlsCellCondition** cc);
[id(2),propget] HRESULT FormulaCondition([out, retval]IXlsFormulaCondition** fc);
[id(3),propput] HRESULT Style([in]IXlsStyle* style);
[id(4) ] HRESULT AdditionalCondition([out, retval]IXlsConditionalFormatting** ac);
[id(5) ] HRESULT Delete();
[id(6) ] HRESULT DeleteAll();
[id(7),propget] HRESULT Areas([out,retval]BSTR* cellrange);
[id(7),propput] HRESULT Areas([in]BSTR cellrange);
[id(8),propget] HRESULT PredefinedCondition([out, retval]IXlsPredefinedCondition** pc);
[id(9),propget] HRESULT DatabarCondition([out, retval]IXlsDatabarCondition** dbc);
[id(10),propget] HRESULT ColorScaleCondition([out, retval]IXlsColorScaleCondition** csc);
[id(11),propget] HRESULT IconSetCondition([out, retval]IXlsIconSetCondition** isc);
[id(12),propget] HRESULT StopIfTrue([out, retval]BOOL* bStopIfTrue);
[id(12),propput] HRESULT StopIfTrue([in]BOOL bStopIfTrue);
}
HRESULT CellCondition([out, retval]IXlsCellCondition** cc);
creates a cell-based condition.
HRESULT FormulaCondition([out, retval]IXlsFormulaCondition** fc);
creates a formula-based condition.
HRESULT Style([in]IXlsStyle* style);
sets the formatting changes when the condition is valid.
HRESULT AdditionalCondition([out, retval]IXlsConditionalFormatting** ac);
adds another condition. Conditions are logically linked with an OR operator.
HRESULT Delete();
deletes the condition.
HRESULT DeleteAll();
deletes all the conditions.
HRESULT Areas([out,retval]BSTR* cellrange);
returns the areas where the conditional formattings apply. The returned range is semi-colon separated, of the form RxCxx:RyCyy.
HRESULT Areas([in]BSTR cellrange);
sets the areas where the conditional formattings apply. The returned range is semi-colon separated, of the form RxCxx:RyCyy.
HRESULT PredefinedCondition([out, retval]IXlsPredefinedCondition** pc);
picks a predefined conditional formatting.
HRESULT DatabarCondition([out, retval]IXlsDatabarCondition** dbc);
creates a databar-based condition. Enabled only with XLSX files.
HRESULT DatabarCondition([out, retval]IXlsDatabarCondition** dbc);
creates a color scale-based condition. Enabled only with XLSX files.
HRESULT DatabarCondition([out, retval]IXlsDatabarCondition** dbc);
creates a icon-based condition. Enabled only with XLSX files.
HRESULT StopIfTrue([out, retval]BOOL* bStopIfTrue);
returns whether conditional formatting rules after the current one should NOT be evaluated. Default value is false.
HRESULT StopIfTrue([in]BOOL bStopIfTrue);
sets whether conditional formatting rules after the current one should NOT be evaluated. Default value is false.