Version

ExcelCalcNumberStack Class

Stack of ExcelCalcValue instances used to evaluate formulas.
Syntax
'Declaration
 
Public Class ExcelCalcNumberStack 
public class ExcelCalcNumberStack 
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.

Requirements

Target Platforms: Windows 8.1, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

View on GitHub