ig.excel.IExcelCalcFormula

Interface implemented by the formula object.

Dependencies

jquery-1.4.4.js
infragistics.util.js
The current widget has no options.
The current widget has no events.
  • addDynamicReferenceI

    .addDynamicReferenceI( reference:ig.excel.IExcelCalcReference );

    Adds a reference created during the evaluation of the formula to the references of the formula.

    • reference
    • Type:ig.excel.IExcelCalcReference
    • The reference to add to the formula's dynamic references collection.

    Remarks

    If the reference is already in the references or dynamic references collection of the formula, this will have no effect.

  • baseReference

    .baseReference( );

    Base reference associated with the formula.

    Remarks

    Base reference associated with the formula. For example, in the case of a column formula, BaseReference would be the column reference.

  • dynamicReferences

    .dynamicReferences( );

    Gets the collection of reference created during the last evaluation of the formula.

  • evaluate

    .evaluate( reference:ig.excel.IExcelCalcReference );
    Return Type:
    ig.excel.ExcelCalcValue
    Return Type Description:
    Retuns an ExcelCalcValue containing result of formula evaluation

    Evaluate the compiled expression against the given base reference

    • reference
    • Type:ig.excel.IExcelCalcReference
    • Base reference used to resolve relative references into absolute references
  • formulaString

    .formulaString( );

    Formula string.

  • hasAlwaysDirty

    .hasAlwaysDirty( );

    Returns whether the formula contains an always dirty function.

  • staticReferences

    .staticReferences( );
    Return Type:
    ig.excel.IExcelCalcReferenceCollection
    Return Type Description:
    Collection of IExcelCalcReferences

    Retuns a collection of references contained in the formula token string

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