Esempio n. 1
0
 public void AddDependency(FormulaCell cell)
 {
     if (_dependencies == null)
         _dependencies = new List<FormulaCell>();
     if (!_dependencies.Contains(cell))
         _dependencies.Add(cell);
 }
Esempio n. 2
0
        /// <summary>
        /// Currently a fake loader
        /// </summary>
        public void Load()
        {
            // 3 + RC[-2] + RC[-1]
            RpnExpression expr1 = new RpnExpression();
            expr1.Add(new RpnNodeConst(3.0));
            expr1.Add(new RpnNodeCellRef(0, false, -2, false));
            expr1.Add(new RpnNodeCellRef(0, false, -1, false));
            expr1.Add(new RpnNodeAdd());
            expr1.Add(new RpnNodeAdd());
            _expressions.Add(expr1);

            // RC[-2] + RC[-1]
            RpnExpression expr2 = new RpnExpression();
            expr2.Add(new RpnNodeCellRef(0, false, -2, false));
            expr2.Add(new RpnNodeCellRef(0, false, -1, false));
            expr2.Add(new RpnNodeAdd());
            _expressions.Add(expr2);

            for (int row = 0; row < _numRows; row++)
            {
                for (int col = 0; col < _numCols; col++)
                {
                    // current sheet is 5 columns, 0 to 4.
                    switch (col)
                    {
                        case 3:
                        {
                            FormulaCell cell = new FormulaCell();
                            cell.Formula = expr1;
                            Cells[row, col] = cell;
                            break;
                        }

                        case 4:
                        {
                            FormulaCell cell = new FormulaCell();
                            cell.Formula = expr2;
                            Cells[row, col] = cell;
                            break;
                        }

                        default:
                            Cells[row, col] = new ConstantCell();
                            Cells[row, col].Value = row + col;
                            break;
                    }
                }
            }
        }
Esempio n. 3
0
        /// <summary>
        ///	Evaluate the expression relative to cell(row, col)
        /// </summary>
        /// <param name="row"></param>
        /// <param name="col"></param>
        /// <returns></returns>
        public double Evaluate(RpnExpression expr, int row, int col)
        {
            FormulaCell thisCell = (FormulaCell)_sheet.Cells[row, col];

            if (!thisCell.IsDirty)
            {
                return(thisCell.Value);
            }

            RpnStack stack = new RpnStack();

            foreach (RpnNode n in expr.Nodes)
            {
                if (n.IsValueType())
                {
                    stack.Add(n);
                }
                else if (n.GetType() == typeof(RpnNodeCellRef))
                {
                    RpnNodeCellRef n1   = (RpnNodeCellRef)n;
                    int            row1 = row + n1._row;
                    int            col1 = col + n1._col;
                    _sheet.Cells[row1, col1].AddDependency(thisCell);           // TODO - only needs to be done on first evaluate
                    double x = this.Value(row1, col1);                          // here's the magic recursive call to evaluate upstream
                    stack.Add(new RpnNodeConst(x));
                }
                else
                {
                    stack.Add(n.Evaluate(stack));
                }
            }
            Debug.Assert(stack.Count == 1);
            Debug.Assert(stack[0].IsValueType());
            double ret = stack[0].Value();

            thisCell.Value = ret;
            return(ret);
        }