ig.excel.FormulaConditionalFormat
Exposes properties which control the visual attributes of a WorksheetCell
based on whether the cell's value meets the criteria defined by a formula.
Dependencies
jquery-1.4.4.js
infragistics.util.js
infragistics.ext_collections.js
infragistics.ext_collectionsExtended.js
infragistics.ext_io.js
infragistics.ext_text.js
infragistics.ext_core.js
infragistics.documents.core_core.js
infragistics.ext_ui.js
The current widget has no options.
The current widget has no events.
-
formula
- .formula( );
- Return Type:
- ig.excel.Formula
- Return Type Description:
- Returns a Formula.
Returns the formula which defines the criteria for this condition.
Remarks
This property is not settable; however, the FormulaConditionalFormat.setFormula method can be used to assign the formula.
-
setFormula
- .setFormula( formula:string, [cellReferenceMode:ig.excel.CellReferenceMode] );
Assigns a new Formula to this instance.
- 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.