bundles/org.simantics.spreadsheet/src/org/simantics/spreadsheet/solver/formula/SumFormulaFunction.java

   1 package org.simantics.spreadsheet.solver.formula;
   2
   3 import org.simantics.spreadsheet.SpreadsheetMatrix;
   4 import org.simantics.spreadsheet.Spreadsheets;
   5 import org.simantics.spreadsheet.solver.formula.parser.ast.AstArgList;
   6 import org.simantics.spreadsheet.solver.formula.parser.ast.AstValue;
   7
   8 class SumFormulaFunction implements CellFormulaFunction<Object> {
   9
  10     @Override
  11     public Object evaluate(CellValueVisitor visitor, AstArgList args) {
  12         Double sum = 0.0;
  13         for (AstValue value : args.values) {
  14             Object result = value.accept(visitor);
  15
  16             if (result instanceof SpreadsheetMatrix) {
  17                 Object value2 = ((SpreadsheetMatrix) result).sumWithFormulaError();
  18                 if(value2 instanceof String) return value2; //means sumWithFormulaError returned an Error message.
  19                 sum += ((Number)value2).doubleValue();
  20             } else if(result instanceof String && !result.equals("")){
  21                 FormulaError2 error = FormulaError2.forString(result.toString());
  22                 if(error!=null) return error.getString();
  23                 Double v = Spreadsheets.asDoubleWhereEmptyStringIsZero(result);
  24                 if(v!=null)
  25                     sum += v;
  26             } else if(result instanceof Number){
  27                 sum += ((Number)result).doubleValue();
  28             } else {
  29                 sum += Spreadsheets.asNumber(result);
  30             }
  31         }
  32         return sum;
  33     }
  34 }