Adopt spreadsheet changes made in Balas development

[simantics/platform.git] / bundles / org.simantics.spreadsheet / src / org / simantics / spreadsheet / solver / formula / SqrtFormulaFunction.java

diff --git a/bundles/org.simantics.spreadsheet/src/org/simantics/spreadsheet/solver/formula/SqrtFormulaFunction.java b/bundles/org.simantics.spreadsheet/src/org/simantics/spreadsheet/solver/formula/SqrtFormulaFunction.java
new file mode 100644 (file)
index 0000000..a5bccaa
--- /dev/null
+++ b/bundles/org.simantics.spreadsheet/src/org/simantics/spreadsheet/solver/formula/SqrtFormulaFunction.java
@@ -0,0 +1,19 @@
+package org.simantics.spreadsheet.solver.formula;
+
+import org.simantics.spreadsheet.Spreadsheets;
+import org.simantics.spreadsheet.solver.formula.parser.ast.AstArgList;
+
+public class SqrtFormulaFunction implements CellFormulaFunction<Object> {
+
+    @Override
+    public Object evaluate(CellValueVisitor visitor, AstArgList args) {
+        if (args.values.size() != 1) throw new IllegalStateException();
+
+        Object number = args.values.get(0).accept(visitor);
+        Double dVal = Spreadsheets.asDoubleWhereEmptyStringIsZero(number);
+        if(dVal==null) return FormulaError2.handleErrorCall(number);
+        if(dVal<0) return FormulaError2.NUM.getString();
+
+        return Math.sqrt(dVal);
+    }
+}