Migrated source code from Simantics SVN

[simantics/platform.git] / bundles / org.simantics.spreadsheet.graph / src / org / simantics / spreadsheet / graph / formula / SumFormulaFunction.java

diff --git a/bundles/org.simantics.spreadsheet.graph/src/org/simantics/spreadsheet/graph/formula/SumFormulaFunction.java b/bundles/org.simantics.spreadsheet.graph/src/org/simantics/spreadsheet/graph/formula/SumFormulaFunction.java
new file mode 100644 (file)
index 0000000..2163094
--- /dev/null
+++ b/bundles/org.simantics.spreadsheet.graph/src/org/simantics/spreadsheet/graph/formula/SumFormulaFunction.java
@@ -0,0 +1,36 @@
+package org.simantics.spreadsheet.graph.formula;\r
+\r
+import org.simantics.spreadsheet.graph.CellFormulaFunction;\r
+import org.simantics.spreadsheet.graph.CellValueVisitor;\r
+import org.simantics.spreadsheet.graph.SpreadsheetGraphUtils;\r
+import org.simantics.spreadsheet.graph.SpreadsheetMatrix;\r
+import org.simantics.spreadsheet.graph.parser.ast.AstArgList;\r
+import org.simantics.spreadsheet.graph.parser.ast.AstValue;\r
+\r
+class SumFormulaFunction implements CellFormulaFunction<Object> {\r
+\r
+    @Override\r
+    public Object evaluate(CellValueVisitor visitor, AstArgList args) {\r
+        Double sum = 0.0;\r
+        for (AstValue value : args.values) {\r
+            Object result = value.accept(visitor);\r
+            \r
+            if (result instanceof SpreadsheetMatrix) {\r
+                Object value2 = ((SpreadsheetMatrix) result).sumWithFormulaError();\r
+                if(value2 instanceof String) return value2; //means sumWithFormulaError returned an Error message.\r
+                sum += ((Number)value2).doubleValue();\r
+            } else if(result instanceof String && !result.equals("")){\r
+               FormulaError2 error = FormulaError2.forString(result.toString());\r
+               if(error!=null) return error.getString();\r
+               Double v = SpreadsheetGraphUtils.asDoubleWhereEmptyStringIsZero(result);\r
+               if(v!=null)\r
+                       sum += v;\r
+            } else if(result instanceof Number){\r
+                sum += ((Number)result).doubleValue();\r
+            } else {\r
+                sum += SpreadsheetGraphUtils.asNumber(result);\r
+            }\r
+        }\r
+        return sum;\r
+    }\r
+}
\ No newline at end of file