Package org.apache.poi.hssf.usermodel

Examples of org.apache.poi.hssf.usermodel.HSSFEvaluationWorkbook

137
138
139
140
141
142
143
144
145
146
147
  }

  public void testMacroFunction() {
    // testNames.xls contains a VB function called 'myFunc'
    HSSFWorkbook w = HSSFTestDataSamples.openSampleWorkbook("testNames.xls");
    HSSFEvaluationWorkbook book = HSSFEvaluationWorkbook.create(w);

    Ptg[] ptg = HSSFFormulaParser.parse("myFunc()", w);
    // myFunc() actually takes 1 parameter.  Don't know if POI will ever be able to detect this problem

    // the name gets encoded as the first arg
View Full Code Here
113
114
115
116
117
118
119
120
121
122
123
        Ptg[] ptgs = fRecs[0].getParsedExpression();
        assertEquals(1, ptgs.length);
        assertTrue(ptgs[0] instanceof Ref3DPtg);

        Ref3DPtg ptg = (Ref3DPtg)ptgs[0];
        HSSFEvaluationWorkbook book = HSSFEvaluationWorkbook.create(stubHSSF);
        assertEquals("Sheet1!A1", ptg.toFormulaString(book));


        // Now check we get the right formula back for
        //  a few sample ones
View Full Code Here
141
142
143
144
145
146
147
148
149
150
151
  }

  public void testMacroFunction() {
    // testNames.xls contains a VB function called 'myFunc'
    HSSFWorkbook w = HSSFTestDataSamples.openSampleWorkbook("testNames.xls");
    HSSFEvaluationWorkbook book = HSSFEvaluationWorkbook.create(w);

    Ptg[] ptg = HSSFFormulaParser.parse("myFunc()", w);
    // myFunc() actually takes 1 parameter.  Don't know if POI will ever be able to detect this problem

    // the name gets encoded as the first arg
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
    Ptg[] ptgs = fRecs[0].getParsedExpression();
    assertEquals(1, ptgs.length);
    assertTrue(ptgs[0] instanceof Ref3DPtg);

    Ref3DPtg ptg = (Ref3DPtg)ptgs[0];
    HSSFEvaluationWorkbook book = HSSFEvaluationWorkbook.create(stubHSSF);
    assertEquals("Sheet1!A1", ptg.toFormulaString(book));


    // Now check we get the right formula back for
    //  a few sample ones
View Full Code Here
193
194
195
196
197
198
199
200
201
202
203
    public void testDiscontinousReference() throws Exception {
        InputStream is = HSSFTestDataSamples.openSampleFileStream("44167.xls");
        HSSFWB wb = new HSSFWB(is);
        Workbook workbook = wb.getWorkbook();
        HSSFEvaluationWorkbook eb = HSSFEvaluationWorkbook.create(wb);

        assertEquals(1, wb.getNumberOfNames());
        String sheetName = "Tabelle1";
        String rawRefA = "$C$10:$C$14";
        String rawRefB = "$C$16:$C$18";
View Full Code Here
139
140
141
142
143
144
145
146
147
148
149
  }

  public void testMacroFunction() {
    // testNames.xls contains a VB function called 'myFunc'
    HSSFWorkbook w = HSSFTestDataSamples.openSampleWorkbook("testNames.xls");
    HSSFEvaluationWorkbook book = HSSFEvaluationWorkbook.create(w);

    Ptg[] ptg = HSSFFormulaParser.parse("myFunc()", w);
    // myFunc() actually takes 1 parameter.  Don't know if POI will ever be able to detect this problem

    // the name gets encoded as the first arg
View Full Code Here
193
194
195
196
197
198
199
200
201
202
203
    public void testDiscontinousReference() throws Exception {
        InputStream is = HSSFTestDataSamples.openSampleFileStream("44167.xls");
        HSSFWB wb = new HSSFWB(is);
        Workbook workbook = wb.getWorkbook();
        HSSFEvaluationWorkbook eb = HSSFEvaluationWorkbook.create(wb);

        assertEquals(1, wb.getNumberOfNames());
        String sheetName = "Tabelle1";
        String rawRefA = "$C$10:$C$14";
        String rawRefB = "$C$16:$C$18";
View Full Code Here
145
146
147
148
149
150
151
152
153
154
155
  }

  public void testMacroFunction() {
    // testNames.xls contains a VB function called 'myFunc'
    HSSFWorkbook w = HSSFTestDataSamples.openSampleWorkbook("testNames.xls");
    HSSFEvaluationWorkbook book = HSSFEvaluationWorkbook.create(w);

    Ptg[] ptg = HSSFFormulaParser.parse("myFunc()", w);
    // myFunc() actually takes 1 parameter.  Don't know if POI will ever be able to detect this problem

    // the name gets encoded as the first arg
View Full Code Here
189
190
191
192
193
194
195
196
197
198
199
    public void testDiscontinousReference() throws Exception {
        InputStream is = HSSFTestDataSamples.openSampleFileStream("44167.xls");
        HSSFWorkbook wb = new HSSFWorkbook(is);
        InternalWorkbook workbook = TestHSSFWorkbook.getInternalWorkbook(wb);
        HSSFEvaluationWorkbook eb = HSSFEvaluationWorkbook.create(wb);

        assertEquals(1, wb.getNumberOfNames());
        String sheetName = "Tabelle1";
        String rawRefA = "$C$10:$C$14";
        String rawRefB = "$C$16:$C$18";
View Full Code Here
189
190
191
192
193
194
195
196
197
198
199
    public void testDiscontinousReference() throws Exception {
        InputStream is = HSSFTestDataSamples.openSampleFileStream("44167.xls");
        HSSFWorkbook wb = new HSSFWorkbook(is);
        InternalWorkbook workbook = TestHSSFWorkbook.getInternalWorkbook(wb);
        HSSFEvaluationWorkbook eb = HSSFEvaluationWorkbook.create(wb);

        assertEquals(1, wb.getNumberOfNames());
        String sheetName = "Tabelle1";
        String rawRefA = "$C$10:$C$14";
        String rawRefB = "$C$16:$C$18";
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.usermodel.HSSFEvaluationWorkbook

  • org.apache.poi.hssf.eventusermodel.TestEventWorkbookBuilder
  • org.apache.poi.hssf.model.TestFormulaParser
  • org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate
  • org.apache.poi.hssf.record.formula.NamePtg
  • org.apache.poi.hssf.record.formula.TestArea3DPtg
  • org.apache.poi.hssf.record.formula.TestRef3DPtg
  • org.apache.poi.hssf.record.FormulaRecord
  • org.apache.poi.hssf.record.NameRecord
  • org.apache.poi.hssf.util.TestAreaReference
  • org.apache.poi.ss.formula.ptg.Area3DPtg
    • 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.