bundles/org.simantics.spreadsheet.graph/src/org/simantics/spreadsheet/graph/formula/RoundupFormulaFunction.java

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