Package org.apache.poi.ss.formula.udf

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

104
105
106
107
108
109
110
111
112
113
114
115
    _sheetIndexesByName = new IdentityHashMap<String, Integer>();
    _collaboratingWorkbookEnvironment = CollaboratingWorkbooksEnvironment.EMPTY;
    _workbookIx = 0;
    _stabilityClassifier = stabilityClassifier;

        AggregatingUDFFinder defaultToolkit = // workbook can be null in unit tests
                workbook == null ? null : (AggregatingUDFFinder)workbook.getUDFFinder();
        if(defaultToolkit != null && udfFinder != null) {
            defaultToolkit.add(udfFinder);
        }
        _udfFinder = defaultToolkit;
  }
View Full Code Here
1764
1765
1766
1767
1768
1769
1770
1771
     * Register a new toolpack in this workbook.
     *
     * @param toopack the toolpack to register
     */
    public void addToolPack(UDFFinder toopack){
        AggregatingUDFFinder udfs = (AggregatingUDFFinder)_udfFinder;
        udfs.add(toopack);
    }
View Full Code Here
105
106
107
108
109
110
111
112
113
114
115
116
    _sheetIndexesByName = new IdentityHashMap<String, Integer>();
    _collaboratingWorkbookEnvironment = CollaboratingWorkbooksEnvironment.EMPTY;
    _workbookIx = 0;
    _stabilityClassifier = stabilityClassifier;

        AggregatingUDFFinder defaultToolkit = // workbook can be null in unit tests
                workbook == null ? null : (AggregatingUDFFinder)workbook.getUDFFinder();
        if(defaultToolkit != null && udfFinder != null) {
            defaultToolkit.add(udfFinder);
        }
        _udfFinder = defaultToolkit;
  }
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
     */
    UDFFinder udff1 = new DefaultUDFFinder(new String[] { "myFunc", },
        new FreeRefFunction[] { new MyFunc(), });
    UDFFinder udff2 = new DefaultUDFFinder(new String[] { "myFunc2", },
        new FreeRefFunction[] { new MyFunc2(), });
    UDFFinder udff = new AggregatingUDFFinder(udff1, udff2);


    HSSFRow row = sheet.getRow(0);
    HSSFCell myFuncCell = row.getCell(1); // =myFunc("_")

View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
         */
        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
108
109
110
111
112
113
114
115
116
117
118
119
    _sheetIndexesByName = new IdentityHashMap<String, Integer>();
    _collaboratingWorkbookEnvironment = CollaboratingWorkbooksEnvironment.EMPTY;
    _workbookIx = 0;
    _stabilityClassifier = stabilityClassifier;

        AggregatingUDFFinder defaultToolkit = // workbook can be null in unit tests
                workbook == null ? null : (AggregatingUDFFinder)workbook.getUDFFinder();
        if(defaultToolkit != null && udfFinder != null) {
            defaultToolkit.add(udfFinder);
        }
        _udfFinder = defaultToolkit;
  }
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
         */
        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
1737
1738
1739
1740
1741
1742
1743
1744
     * Register a new toolpack in this workbook.
     *
     * @param toopack the toolpack to register
     */
    public void addToolPack(UDFFinder toopack){
        AggregatingUDFFinder udfs = (AggregatingUDFFinder)_udfFinder;
        udfs.add(toopack);
    }
View Full Code Here
1744
1745
1746
1747
1748
1749
1750
1751
     * Register a new toolpack in this workbook.
     *
     * @param toopack the toolpack to register
     */
    public void addToolPack(UDFFinder toopack){
        AggregatingUDFFinder udfs = (AggregatingUDFFinder)_udfFinder;
        udfs.add(toopack);
    }
View Full Code Here
142
143
144
145
146
147
148
149
150
151
            names[x] = name;
            functions[x] = function;
        }

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

        return udff;

    }
View Full Code Here
TOP

Related Classes of org.apache.poi.ss.formula.udf.AggregatingUDFFinder

  • org.apache.poi.hssf.model.TestWorkbook
  • org.apache.poi.hssf.usermodel.HSSFWorkbook
  • org.apache.poi.ss.excelant.util.ExcelAntWorkbookUtil
  • org.apache.poi.ss.formula.eval.TestExternalFunction
  • org.apache.poi.ss.formula.functions.FreeRefFunction
  • org.apache.poi.ss.formula.WorkbookEvaluator
    • 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.