X-Git-Url: https://gerrit.simantics.org/r/gitweb?a=blobdiff_plain;f=bundles%2Forg.simantics.spreadsheet%2Fsrc%2Forg%2Fsimantics%2Fspreadsheet%2Fsolver%2Fformula%2FRoundupFormulaFunction.java;fp=bundles%2Forg.simantics.spreadsheet%2Fsrc%2Forg%2Fsimantics%2Fspreadsheet%2Fsolver%2Fformula%2FRoundupFormulaFunction.java;h=7ba59d7e49b59b0ed528b8b67a20663f0fd0ec79;hb=5c67a96d34fe904b8c4b0375cd08ff1d543bf369;hp=0000000000000000000000000000000000000000;hpb=9a37dabc6c0212ed3e14499c88df3208cd06f9b0;p=simantics%2Fplatform.git

diff --git a/bundles/org.simantics.spreadsheet/src/org/simantics/spreadsheet/solver/formula/RoundupFormulaFunction.java b/bundles/org.simantics.spreadsheet/src/org/simantics/spreadsheet/solver/formula/RoundupFormulaFunction.java
new file mode 100644
index 000000000..7ba59d7e4
--- /dev/null
+++ b/bundles/org.simantics.spreadsheet/src/org/simantics/spreadsheet/solver/formula/RoundupFormulaFunction.java
@@ -0,0 +1,29 @@
+package org.simantics.spreadsheet.solver.formula;
+
+import org.simantics.spreadsheet.Spreadsheets;
+import org.simantics.spreadsheet.solver.formula.parser.ast.AstArgList;
+
+public class RoundupFormulaFunction implements CellFormulaFunction<Object> {
+
+    @Override
+    public Object evaluate(CellValueVisitor visitor, AstArgList args) {
+        if (args.values.size() != 2) throw new IllegalStateException();
+
+        Object number = args.values.get(0).accept(visitor);
+        Object digits = args.values.get(1).accept(visitor);
+
+        FormulaError2 err1 = FormulaError2.forObject(number);
+        if(err1!=null) return err1.getString();
+        FormulaError2 err2 = FormulaError2.forObject(digits);
+        if(err2!=null) return err2.getString();
+
+        double n = Spreadsheets.asNumber(number);
+        double n2 = Spreadsheets.asNumber(digits);
+
+        Double scale = Math.pow(10, n2);
+
+        double l = Math.ceil(scale * n);
+        Double d = Double.valueOf(l / scale);
+        return d;
+    }
+}