1 package org.simantics.spreadsheet.solver.formula;
3 import org.simantics.spreadsheet.Spreadsheets;
4 import org.simantics.spreadsheet.solver.formula.parser.ast.AstArgList;
6 public class SqrtFormulaFunction implements CellFormulaFunction<Object> {
9 public Object evaluate(CellValueVisitor visitor, AstArgList args) {
10 if (args.values.size() != 1) throw new IllegalStateException();
12 Object number = args.values.get(0).accept(visitor);
13 Double dVal = Spreadsheets.asDoubleWhereEmptyStringIsZero(number);
14 if(dVal==null) return FormulaError2.handleErrorCall(number);
15 if(dVal<0) return FormulaError2.NUM.getString();
17 return Math.sqrt(dVal);