bundles/org.simantics.spreadsheet/src/org/simantics/spreadsheet/solver/formula/RoundFormulaFunction.java

   1 package org.simantics.spreadsheet.solver.formula;
   2
   3 import org.simantics.spreadsheet.Spreadsheets;
   4 import org.simantics.spreadsheet.solver.formula.parser.ast.AstArgList;
   5
   6 public class RoundFormulaFunction implements CellFormulaFunction<Object> {
   7
   8     @Override
   9     public Object evaluate(CellValueVisitor visitor, AstArgList args) {
  10         if (args.values.size() != 2) throw new IllegalStateException();
  11
  12         Object number = args.values.get(0).accept(visitor);
  13         Object digits = args.values.get(1).accept(visitor);
  14
  15         FormulaError2 err1 = FormulaError2.forObject(number);
  16         if(err1!=null) return err1.getString();
  17         FormulaError2 err2 = FormulaError2.forObject(digits);
  18         if(err2!=null) return err2.getString();
  19
  20         double n = Spreadsheets.asNumber(number);
  21         double n2 = Spreadsheets.asNumber(digits);
  22         Double scale = Math.pow(10, n2);
  23
  24         long l = Math.round(scale * n);
  25         Double d = Double.valueOf(((double) l) / scale);
  26         return d;
  27     }
  28 }