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.

Copyright © 1996 - 2024 Infragistics, Inc. All rights reserved.