Examples of UDFFinder

Examples of org.apache.poi.ss.formula.udf.UDFFinder

58
59
60
61
62
63
64
65
66
67
68
            fis.close();

            String[] functionNames = { "calculatePayment" } ;
            FreeRefFunction[] functionImpls = { new CalculateMortgage() } ;
           
            UDFFinder udfToolpack = new DefaultUDFFinder( functionNames, functionImpls ) ;

            // register the user-defined function in the workbook
            workbook.addToolPack(udfToolpack);

            FormulaEvaluator evaluator = workbook.getCreationHelper().createFormulaEvaluator();
View Full Code Here

Examples of org.apache.poi.ss.formula.udf.UDFFinder

103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
        };

        /**
         * register the two test UDFs in a UDF finder, to be passed to the evaluator
         */
        UDFFinder udff1 = new DefaultUDFFinder(new String[] { "myFunc", },
                new FreeRefFunction[] { NotImplemented });
        UDFFinder udff2 = new DefaultUDFFinder(new String[] { "myFunc2", },
                new FreeRefFunction[] { NotImplemented });
        UDFFinder udff = new AggregatingUDFFinder(udff1, udff2);
        assertNotNull(wb.getNameXPtg("myFunc", udff));
        assertNotNull(wb.getNameXPtg("myFunc2", udff));

        assertNull(wb.getNameXPtg("myFunc3", udff));  // myFunc3 is unknown
    }
View Full Code Here

Examples of org.apache.poi.ss.formula.udf.UDFFinder

50
51
52
53
54
55
56
57
58
    assertNotNull( fixture ) ;
   
    fixture.addFunction("h2_ZFactor", new CalculateMortgageFunction() ) ;
   
    UDFFinder functions = fixture.getFunctions() ;
   
    assertNotNull( functions ) ;
  }
View Full Code Here

Examples of org.apache.poi.ss.formula.udf.UDFFinder

50
51
52
53
54
55
56
57
58
    assertNotNull( fixture ) ;
   
    fixture.addFunction("h2_ZFactor", new CalculateMortgage() ) ;
   
    UDFFinder functions = fixture.getFunctions() ;
   
    assertNotNull( functions ) ;
  }
View Full Code Here

Examples of org.apache.poi.ss.formula.udf.UDFFinder

102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
        };

        /**
         * register the two test UDFs in a UDF finder, to be passed to the evaluator
         */
        UDFFinder udff1 = new DefaultUDFFinder(new String[] { "myFunc", },
                new FreeRefFunction[] { NotImplemented });
        UDFFinder udff2 = new DefaultUDFFinder(new String[] { "myFunc2", },
                new FreeRefFunction[] { NotImplemented });
        UDFFinder udff = new AggregatingUDFFinder(udff1, udff2);
        assertNotNull(wb.getNameXPtg("myFunc", udff));
        assertNotNull(wb.getNameXPtg("myFunc2", udff));

        assertNull(wb.getNameXPtg("myFunc3", udff));  // myFunc3 is unknown
    }
View Full Code Here

Examples of org.apache.poi.ss.formula.udf.UDFFinder

141
142
143
144
145
146
147
148
149
150
151
            FreeRefFunction function = xlsMacroList.get(name);
            names[x] = name;
            functions[x] = function;
        }

        UDFFinder udff1 = new DefaultUDFFinder(names, functions);
        UDFFinder udff = new AggregatingUDFFinder(udff1);

        return udff;

    }
View Full Code Here

Examples of org.apache.poi.ss.formula.udf.UDFFinder

57
58
59
60
61
62
63
64
65
66
67
            fis.close();

            String[] functionNames = { "calculatePayment" } ;
            FreeRefFunction[] functionImpls = { new CalculateMortgage() } ;
           
            UDFFinder udfToolpack = new DefaultUDFFinder( functionNames, functionImpls ) ;

            // register the user-defined function in the workbook
            workbook.addToolPack(udfToolpack);

            FormulaEvaluator evaluator = workbook.getCreationHelper().createFormulaEvaluator();
View Full Code Here

Examples of org.apache.poi.ss.formula.udf.UDFFinder

68
69
70
71
72
73
74
75
76
    assertNotNull( fixture ) ;
   
    fixture.addFunction("h2_ZFactor", new CalculateMortgageFunction() ) ;
   
    UDFFinder functions = fixture.getFunctions() ;
   
    assertNotNull( functions ) ;
  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.