Package org.apache.poi.hssf.record.formula.functions

Examples of org.apache.poi.hssf.record.formula.functions.FreeRefFunction

150
151
152
153
154
155
156
157
   
    return m;
  }

  private static void r(Map<String, FreeRefFunction> m, String functionName, FreeRefFunction pFunc) {
    FreeRefFunction func = pFunc == null ? new NotImplemented(functionName) : pFunc;
    m.put(functionName, func);
  }
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
    if(nIncomingArgs < 1) {
      throw new RuntimeException("function name argument missing");
    }
   
    Eval nameArg = args[0];
    FreeRefFunction targetFunc;
    if (nameArg instanceof NameEval) {
      targetFunc = findInternalUserDefinedFunction((NameEval) nameArg);
    } else if (nameArg instanceof NameXEval) {
      targetFunc = findExternalUserDefinedFunction(workbook, (NameXEval) nameArg);
    } else {
      throw new RuntimeException("First argument should be a NameEval, but got ("
          + nameArg.getClass().getName() + ")");
    }
    int nOutGoingArgs = nIncomingArgs -1;
    Eval[] outGoingArgs = new Eval[nOutGoingArgs];
    System.arraycopy(args, 1, outGoingArgs, 0, nOutGoingArgs);
    return targetFunc.evaluate(outGoingArgs, workbook, srcCellSheet, srcCellRow, srcCellCol);
  }
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
    if(false) {
      System.out.println("received call to external user defined function (" + functionName + ")");
    }
    // currently only looking for functions from the 'Analysis TookPak'  e.g. "YEARFRAC" or "ISEVEN"
    // not sure how much this logic would need to change to support other or multiple add-ins.
    FreeRefFunction result = AnalysisToolPak.findFunction(functionName);
    if (result != null) {
      return result;
    }
    throw new NotImplementedException(functionName);
  }
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
55
56
57
   
    int nOutGoingArgs = nIncomingArgs -1;
    Eval[] outGoingArgs = new Eval[nOutGoingArgs];
    System.arraycopy(args, 1, outGoingArgs, 0, nOutGoingArgs);
   
    FreeRefFunction targetFunc;
    try {
      targetFunc = findTargetFunction(workbook, functionNameEval);
    } catch (EvaluationException e) {
      return e.getErrorEval();
    }
   
    return targetFunc.evaluate(outGoingArgs, srcCellRow, srcCellCol, workbook, sheet);
  }
View Full Code Here
156
157
158
159
160
161
162
163
    return m;
  }

  private static void r(Map<String, FreeRefFunction> m, String functionName, FreeRefFunction pFunc) {
    FreeRefFunction func = pFunc == null ? new NotImplemented(functionName) : pFunc;
    m.put(functionName, func);
  }
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
61
62
63
      functionName = ec.getWorkbook().resolveNameXText(((NameXEval) nameArg).getPtg());
    } else {
      throw new RuntimeException("First argument should be a NameEval, but got ("
          + nameArg.getClass().getName() + ")");
    }
    FreeRefFunction targetFunc = ec.findUserDefinedFunction(functionName);
    if (targetFunc == null) {
      throw new NotImplementedException(functionName);
    }
    int nOutGoingArgs = nIncomingArgs -1;
    ValueEval[] outGoingArgs = new ValueEval[nOutGoingArgs];
    System.arraycopy(args, 1, outGoingArgs, 0, nOutGoingArgs);
    return targetFunc.evaluate(outGoingArgs, ec);
  }
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
   *
   * @param name Name of function.
   * @return Function executor. <code>null</code> if not found
   */
  public FreeRefFunction findFunction(String name) {
    FreeRefFunction evaluatorForFunction;
    for (UDFFinder pack : _usedToolPacks) {
      evaluatorForFunction = pack.findFunction(name);
      if (evaluatorForFunction != null) {
        return evaluatorForFunction;
      }
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
55
56
57
   
    int nOutGoingArgs = nIncomingArgs -1;
    Eval[] outGoingArgs = new Eval[nOutGoingArgs];
    System.arraycopy(args, 1, outGoingArgs, 0, nOutGoingArgs);
   
    FreeRefFunction targetFunc;
    try {
      targetFunc = findTargetFunction(workbook, functionNameEval);
    } catch (EvaluationException e) {
      return e.getErrorEval();
    }
   
    return targetFunc.evaluate(outGoingArgs, srcCellRow, srcCellCol, workbook, sheet);
  }
View Full Code Here
156
157
158
159
160
161
162
163
    return m;
  }

  private static void r(Map<String, FreeRefFunction> m, String functionName, FreeRefFunction pFunc) {
    FreeRefFunction func = pFunc == null ? new NotImplemented(functionName) : pFunc;
    m.put(functionName, func);
  }
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
64
65
66
      functionName = ec.getWorkbook().resolveNameXText(((NameXEval) nameArg).getPtg());
    } else {
      throw new RuntimeException("First argument should be a NameEval, but got ("
          + nameArg.getClass().getName() + ")");
    }
    FreeRefFunction targetFunc = ec.findUserDefinedFunction(functionName);
    if (targetFunc == null) {
      throw new NotImplementedException(functionName);
    }
    int nOutGoingArgs = nIncomingArgs -1;
    ValueEval[] outGoingArgs = new ValueEval[nOutGoingArgs];
    System.arraycopy(args, 1, outGoingArgs, 0, nOutGoingArgs);
    return targetFunc.evaluate(outGoingArgs, ec);
  }
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.record.formula.functions.FreeRefFunction

  • org.apache.poi.hssf.record.formula.atp.AnalysisToolPak
  • org.apache.poi.hssf.record.formula.eval.ExternalFunction
  • org.apache.poi.hssf.record.formula.eval.UserDefinedFunction
  • org.apache.poi.hssf.record.formula.udf.AggregatingUDFFinder
  • org.apache.poi.ss.formula.UserDefinedFunction
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.