Examples of org.apache.poi.ss.formula.functions.Function.evaluate()

org.apache.poi.ss.formula.functions.Function.evaluate()

@param args the evaluated function arguments. Empty values are represented with{@link BlankEval} or {@link MissingArgEval}, never null. @param srcRowIndex row index of the cell containing the formula under evaluation @param srcColumnIndex column index of the cell containing the formula under evaluation @return The evaluated result, possibly an {@link ErrorEval}, never null. Note - Excel uses the error code #NUM! instead of IEEE NaN, so when numeric functions evaluate to {@link Double#NaN} be sure to translate the result to {@link ErrorEval#NUM_ERROR}.

      throw new IllegalArgumentException("ptg must not be null");
    }
    Function result = _instancesByPtgClass.get(ptg);


    if (result != null) {
      return  result.evaluate(args, ec.getRowIndex(), (short) ec.getColumnIndex());
    }


    if (ptg instanceof AbstractFunctionPtg) {
      AbstractFunctionPtg fptg = (AbstractFunctionPtg)ptg;
      int functionIndex = fptg.getFunctionIndex();

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.