ig.excel.ExcelCalcNumberStack

Stack of ExcelCalcValue instances used to evaluate formulas.

Remarks

The number stack is used for evaluating formulas. When formulas are compiled, the formula tokens are placed in a collection in post-fix, or Reverse Polish Notation (RPN) format. RPN format arranges the formula token list so each sub-expressions's terms are placed before their operator, and sub-expressions are ordered to enforce correct operator precedence. This format allows the formula evaluate method to loop through the formula token collection front to back pushing an operator's terms onto the number stack until an operator is reached. Each time an operator is reached, it's subexpression is computed and resulting value pushed onto the number stack. Once the end of the end of the formula collection is reached, the formulas calculated value is at the top of the number stack.

Dependencies

jquery-1.4.4.js
infragistics.util.js
The current widget has no options.
The current widget has no events.
  • ig.excel.ExcelCalcNumberStack
    Constructor

    new $.ig.excel.ExcelCalcNumberStack( );

    Initializes a new ExcelCalcNumberStack

  • clear

    .clear( );

    Remove all values from number stack.

  • count

    .count( );
    Return Type:
    number
    Return Type Description:
    Number of stack values

    Return the number of values on number stack

  • owningCell

    .owningCell( );

    Gets the WorksheetCell instance whose formula is currently being solved.

  • peek

    .peek( );
    Return Type:
    ig.excel.ExcelCalcValue
    Return Type Description:
    ExcelCalcValue that is at the top of the number stack.

    Return value off top of the number stack.

  • pop

    .pop( );
    Return Type:
    ig.excel.ExcelCalcValue
    Return Type Description:
    ExcelCalcValue that was at the top of the number stack.

    Pop value off top of the number stack.

  • push

    .push( value:ig.excel.ExcelCalcValue );

    Push a value onto number stack.

    • value
    • Type:ig.excel.ExcelCalcValue
    • Value to push onto the number stack
  • reset

    .reset( elements:number );

    Clear elements off top of number stack until it contains given number of elements

    • elements
    • Type:number
    • Denotes the desired stack level

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