Examples of org.apache.poi.ss.formula.functions.Function

Package org.apache.poi.ss.formula.functions

Examples of org.apache.poi.ss.formula.functions.Function

org.apache.poi.ss.formula.functions.Function
Common interface for all implementations of Excel built-in functions. @author Amol S. Deshmukh < amolweb at ya hoo dot com >

            fail("expectecd exception");
    } catch (NotImplementedException e) {
      ;
    }


        FunctionEval.registerFunction("FISHER", new Function() {
            public ValueEval evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex) {
                return ErrorEval.NA;
            }
        });

View Full Code Here

        cv = fe.evaluate(cellB);
        assertEquals(ErrorEval.NUM_ERROR.getErrorCode(), cv.getErrorValue());
  }


    public void testExceptions() {
        Function func = new Function() {
            public ValueEval evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex) {
                return ErrorEval.NA;
            }
        };
        try {

View Full Code Here


    @Test
    public void bug54436(){
        Workbook workbook = XSSFTestDataSamples.openSampleWorkbook("54436.xlsx");
        if(!WorkbookEvaluator.getSupportedFunctionNames().contains("GETPIVOTDATA")){
            Function func = new Function() {
                public ValueEval evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex) {
                    return ErrorEval.NA;
                }
            };

View Full Code Here


        retval[362] = MinaMaxa.MAXA;
        retval[363] = MinaMaxa.MINA;


        for (int i = 0; i < retval.length; i++) {
            Function f = retval[i];
            if (f == null) {
                FunctionMetadata fm = FunctionMetadataRegistry.getFunctionByIndex(i);
                if (fm == null) {
                    continue;
                }

View Full Code Here

        case FunctionID.INDIRECT:
        case FunctionID.EXTERNAL_FUNC:
            return null;
        }
        // else - must be plain function
        Function result = functions[functionIndex];
        if (result == null) {
            throw new NotImplementedException("FuncIx=" + functionIndex);
        }
        return result;
    }

View Full Code Here

     * @since 3.8 beta6
     */
    public static Collection<String> getSupportedFunctionNames() {
        Collection<String> lst = new TreeSet<String>();
        for (int i = 0; i < functions.length; i++) {
            Function func = functions[i];
            FunctionMetadata metaData = FunctionMetadataRegistry.getFunctionByIndex(i);
            if (func != null && !(func instanceof NotImplementedFunction)) {
                lst.add(metaData.getName());
            }
        }

View Full Code Here

     * @since 3.8 beta6
     */
    public static Collection<String> getNotSupportedFunctionNames() {
        Collection<String> lst = new TreeSet<String>();
        for (int i = 0; i < functions.length; i++) {
            Function func = functions[i];
            if (func != null && (func instanceof NotImplementedFunction)) {
                FunctionMetadata metaData = FunctionMetadataRegistry.getFunctionByIndex(i);
                lst.add(metaData.getName());
            }
        }

View Full Code Here

0 1

TOP

Related Classes of org.apache.poi.ss.formula.functions.Function

org.apache.poi.ss.formula.eval.FunctionEval

org.apache.poi.ss.formula.OperationEvaluatorFactory

org.apache.poi.ss.formula.TestFunctionRegistry

org.apache.poi.xssf.usermodel.TestXSSFBugs

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.