Examples of FreeRefFunction

org.apache.poi.hssf.record.formula.functions.FreeRefFunction
For most Excel functions, involving references ((cell, area), (2d, 3d)), the references are passed in as arguments, and the exact location remains fixed. However, a select few Excel functions have the ability to access cells that were not part of any reference passed as an argument.
Two important functions with this feature are INDIRECT and OFFSET
In POI, the HSSFFormulaEvaluator evaluates every cell in each reference argument before calling the function. This means that functions using fixed references do not need access to the rest of the workbook to execute. Hence the evaluate() method on the common interface Function does not take a workbook parameter.
This interface recognises the requirement of some functions to freely create and evaluate references beyond those passed in as arguments. @author Josh Micich
org.apache.poi.ss.formula.functions.FreeRefFunction
For most Excel functions, involving references ((cell, area), (2d, 3d)), the references are passed in as arguments, and the exact location remains fixed. However, a select few Excel functions have the ability to access cells that were not part of any reference passed as an argument.
Two important functions with this feature are INDIRECT and OFFSET
When POI evaluates formulas, each reference argument is capable of evaluating any cell inside its range. Actually, even cells outside the reference range but on the same sheet can be evaluated. This allows OFFSET to be implemented like most other functions - taking only the arguments, and source cell coordinates. For the moment this interface only exists to serve the INDIRECT which can decode arbitrary text into cell references, and evaluate them.. @author Josh Micich

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

    
    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

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

    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

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

    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

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

    
    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

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


    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

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

      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

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

   *
   * @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

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

    
    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

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


    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

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

      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

0 1 2 3 4

TOP

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.