Adopt spreadsheet changes made in Balas development

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

diff --git a/bundles/org.simantics.spreadsheet.graph/src/org/simantics/spreadsheet/graph/formula/SumifFormulaFunction.java b/bundles/org.simantics.spreadsheet.graph/src/org/simantics/spreadsheet/graph/formula/SumifFormulaFunction.java
deleted file mode 100644 (file)
index 8826a38..0000000
--- a/bundles/org.simantics.spreadsheet.graph/src/org/simantics/spreadsheet/graph/formula/SumifFormulaFunction.java
+++ /dev/null
@@ -1,74 +0,0 @@
-package org.simantics.spreadsheet.graph.formula;
-
-import org.simantics.spreadsheet.graph.CellFormulaFunction;
-import org.simantics.spreadsheet.graph.CellValueVisitor;
-import org.simantics.spreadsheet.graph.SpreadsheetGraphUtils;
-import org.simantics.spreadsheet.graph.SpreadsheetMatrix;
-import org.simantics.spreadsheet.graph.parser.ast.AstArgList;
-
-class SumifFormulaFunction implements CellFormulaFunction<Object> {
-
-    @Override
-    public Object evaluate(CellValueVisitor visitor, AstArgList args) {
-        if (args.values.size() == 2) {
-            Object test = args.values.get(0).accept(visitor);
-            Object criteria = null;
-            try {
-               criteria = args.values.get(1).accept(visitor);
-            } catch (IllegalStateException e){
-               return 0;
-            }
-            FormulaError2 error = FormulaError2.forObject(criteria);
-            if(error!=null) return error.getString();
-            
-            if (test instanceof SpreadsheetMatrix) {
-                double sum = 0.0;
-                SpreadsheetMatrix tm = (SpreadsheetMatrix) test;
-                for (int i = 0; i < tm.values.length; i++) {
-                    if (SpreadsheetGraphUtils.matchCriteria(tm.values[i], criteria)) {
-                        double d = SpreadsheetGraphUtils.asNumber(tm.values[i]);
-                        if (Double.isFinite(d))
-                            sum += d;
-                    }
-                }
-                return sum;
-            } else {
-                Double d = SpreadsheetGraphUtils.asNumber(test);
-                return d;
-            }
-        }
-
-        if (args.values.size() == 3) {
-            Object test = args.values.get(0).accept(visitor);
-            Object criteria = null;
-            try {
-               criteria = args.values.get(1).accept(visitor);
-            } catch (IllegalStateException e){
-               return 0;
-            }
-            FormulaError2 error = FormulaError2.forObject(criteria);
-            if(error!=null) return error.getString();
-            
-            Object range = args.values.get(2).accept(visitor);
-
-            if (test instanceof SpreadsheetMatrix) {
-                Double sum = 0.0;
-                SpreadsheetMatrix tm = (SpreadsheetMatrix) test;
-                SpreadsheetMatrix rm = (SpreadsheetMatrix) range;
-                for (int i = 0; i < tm.values.length; i++) {
-                    if (SpreadsheetGraphUtils.matchCriteria(tm.values[i], criteria)) {
-                        double d = SpreadsheetGraphUtils.asNumber(rm.values[i]);
-                        if (Double.isFinite(d))
-                            sum += d;
-                    }
-                }
-                return sum;
-            } else {
-                Double d = SpreadsheetGraphUtils.asNumber(test);
-                return d;
-            }
-
-        }
-        throw new IllegalStateException();
-    }
-}
\ No newline at end of file