1 package org.simantics.spreadsheet.solver.formula;
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;
8 class SumFormulaFunction implements CellFormulaFunction<Object> {
11 public Object evaluate(CellValueVisitor visitor, AstArgList args) {
13 for (AstValue value : args.values) {
14 Object result = value.accept(visitor);
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);
26 } else if(result instanceof Number){
27 sum += ((Number)result).doubleValue();
29 sum += Spreadsheets.asNumber(result);