1 package org.simantics.spreadsheet.solver.formula;
3 import org.simantics.spreadsheet.SpreadsheetMatrix;
4 import org.simantics.spreadsheet.Spreadsheets;
5 import org.simantics.spreadsheet.solver.formula.parser.ast.AstArgList;
6 import org.simantics.spreadsheet.solver.formula.parser.ast.AstValue;
8 public class GeomeanFormulaFunction implements CellFormulaFunction<Object> {
11 public Object evaluate(CellValueVisitor visitor, AstArgList args) {
12 if (args.values.size() == 0)
13 throw new IllegalStateException();
16 for (AstValue value : args.values){
17 Object r = value.accept(visitor);
18 if (r instanceof SpreadsheetMatrix) {
19 Object v = ((SpreadsheetMatrix) r).productWithFormulaError();
20 if(v instanceof String) return v;
21 double dval = ((Number)v).doubleValue();
24 count += ((SpreadsheetMatrix) r).countOfActualDoubleValues();
27 FormulaError2 error = FormulaError2.forObject(r);
28 if(error!=null) return error.getString();
30 Number vNum = Spreadsheets.asValidNumber(r);
32 if(vNum!=null) v = vNum.doubleValue();
35 if(v<=0) return FormulaError2.NUM.getString();
41 if(result==0.0 || count==0.0) return FormulaError2.NUM.getString();
42 return Double.valueOf(Math.pow(result, (1.0/count)));