ig.excel.ThresholdConditionBase
Base class for the DataBarConditionalFormat, IconSetConditionalFormat,
and ColorScaleConditionalFormat classes.
Dependencies
jquery-1.4.4.js
infragistics.util.js
infragistics.ext_core.js
infragistics.ext_collections.js
infragistics.ext_collectionsExtended.js
infragistics.ext_io.js
infragistics.ext_text.js
infragistics.documents.core_core.js
infragistics.ext_ui.js
The current widget has no options.
The current widget has no events.
-
ig.excel.ThresholdConditionBase
Constructor- new $.ig.excel.ThresholdConditionBase( );
For internal use only
-
formula
- .formula( );
Returns the formula which determines the values to which this condition applies.
Remarks
Note: the formula should return a boolean result. When the formula is applied to cells in the region if the formula returns false then those cells will not be included in the formatting. -
setFormula
- .setFormula( formula:string, [cellReferenceMode:ig.excel.CellReferenceMode] );
Assigns a new Formula to the ThresholdConditionBase.formula property.
- formula
- Type:string
- The string representation of the formula.
- cellReferenceMode
- Type:ig.excel.CellReferenceMode
- Optional
- A CellReferenceMode value which specifies whether the formula parameter should be interpreted as an A1 or R1C1 expression. This parameter is optional and defaults to null, in which case the Workbook.cellReferenceMode property is used.
Remarks
Note: the formula should return a boolean result. When the formula is applied to cells in the region if the formula returns false then those cells will not be included in the formatting.