Examples of XSSFEvaluationWorkbook

Examples of org.zkoss.poi.xssf.usermodel.XSSFEvaluationWorkbook

136
137
138
139
140
141
142
143
144
145
    assertEquals(head+hlinkA6.getType()+href+hlinkA6.getAddress()+mid+textA6+tail, stringA6);
    assertEquals(head+hlinkA7.getType()+href+hlinkA7.getAddress()+mid+textA7+tail, stringA7);
  }
 
  private void testToFormulaString(Cell cell, String expect) {
    XSSFEvaluationWorkbook evalbook = XSSFEvaluationWorkbook.create((XSSFWorkbook)_workbook);
    Ptg[] ptgs = BookHelper.getCellPtgs(cell);
    final String formula = FormulaRenderer.toFormulaString(evalbook, ptgs);
    assertEquals(expect, formula);
  }
View Full Code Here

Examples of org.zkoss.poi.xssf.usermodel.XSSFEvaluationWorkbook

202
203
204
205
206
207
208
209
210
211
    assertEquals(Cell.CELL_TYPE_ERROR, valueIV3.getCellType());
    testToFormulaString(cellXFD3, "SUM(#REF!)");
  }
 
  private void testToFormulaString(Cell cell, String expect) {
    XSSFEvaluationWorkbook evalbook = XSSFEvaluationWorkbook.create((XSSFWorkbook)_workbook);
    Ptg[] ptgs = BookHelper.getCellPtgs(cell);
    final String formula = FormulaRenderer.toFormulaString(evalbook, ptgs);
    assertEquals(expect, formula);
  }
View Full Code Here

Examples of org.zkoss.poi.xssf.usermodel.XSSFEvaluationWorkbook

282
283
284
285
286
287
288
289
290
291
    assertEquals(Cell.CELL_TYPE_STRING, valueM17.getCellType());
    testToFormulaString(cellM17, "L16");
  }
 
  private void testToFormulaString(Cell cell, String expect) {
    XSSFEvaluationWorkbook evalbook = XSSFEvaluationWorkbook.create((XSSFWorkbook)_workbook);
    Ptg[] ptgs = BookHelper.getCellPtgs(cell);
    final String formula = FormulaRenderer.toFormulaString(evalbook, ptgs);
    assertEquals(expect, formula);
  }
View Full Code Here

Examples of org.zkoss.poi.xssf.usermodel.XSSFEvaluationWorkbook

174
175
176
177
178
179
180
181
182
183
    assertEquals(ErrorConstants.ERROR_REF, valueA11.getErrorValue());

  }
 
  private void testToFormulaString(Cell cell, String expect) {
    XSSFEvaluationWorkbook evalbook = XSSFEvaluationWorkbook.create((XSSFWorkbook)_workbook);
    Ptg[] ptgs = BookHelper.getCellPtgs(cell);
    final String formula = FormulaRenderer.toFormulaString(evalbook, ptgs);
    assertEquals(expect, formula);
  }
View Full Code Here

Examples of org.zkoss.poi.xssf.usermodel.XSSFEvaluationWorkbook

259
260
261
262
263
264
265
266
267
268
    testToFormulaString(cellD11, "D1");

  }
 
  private void testToFormulaString(Cell cell, String expect) {
    XSSFEvaluationWorkbook evalbook = XSSFEvaluationWorkbook.create((XSSFWorkbook)_workbook);
    Ptg[] ptgs = BookHelper.getCellPtgs(cell);
    final String formula = FormulaRenderer.toFormulaString(evalbook, ptgs);
    assertEquals(expect, formula);
  }
View Full Code Here

Examples of org.zkoss.poi.xssf.usermodel.XSSFEvaluationWorkbook

1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
    assertEquals(Cell.CELL_TYPE_NUMERIC, valueA1.getCellType());
    testToFormulaString(cellA1, "SUM(C4:F7)");
  }
 
  private void testToFormulaString(Cell cell, String expect) {
    XSSFEvaluationWorkbook evalbook = XSSFEvaluationWorkbook.create((XSSFWorkbook)_workbook);
    Ptg[] ptgs = BookHelper.getCellPtgs(cell);
    final String formula = FormulaRenderer.toFormulaString(evalbook, ptgs);
    assertEquals(expect, formula);
  }
View Full Code Here

Examples of org.zkoss.poi.xssf.usermodel.XSSFEvaluationWorkbook

1116
1117
1118
1119
1120
1121
1122
1123
1124
    private static String getFormulaString(XSSFCell cell){
      String formula = cell.getCellFormula();
        final XSSFSheet sheet = cell.getSheet();

        int sheetIndex = sheet.getWorkbook().getSheetIndex(sheet);
        XSSFEvaluationWorkbook fpb = XSSFEvaluationWorkbook.create(sheet.getWorkbook());
        Ptg[] ptgs = FormulaParser.parse(formula, fpb, FormulaType.CELL, sheetIndex);
        return FormulaRenderer.toFormulaString(fpb, ptgs);
    }
View Full Code Here

Examples of org.zkoss.poi.xssf.usermodel.XSSFEvaluationWorkbook

1808
1809
1810
1811
1812
1813
1814
1815
1816
1817
1818
      }
      agg.setParsedExpression(ptgs);
  }
  private static void setXSSFCellPtgs(XSSFCell cell, Ptg[] ptgs) {
    XSSFWorkbook book = (XSSFWorkbook) cell.getSheet().getWorkbook();
        XSSFEvaluationWorkbook fpb = XSSFEvaluationWorkbook.create(book);
        final String formula = FormulaRenderer.toFormulaString(fpb, ptgs);
        if (formula != null && formula.length() > 0) {
          cell.setCellFormula(formula);
        }
  }
View Full Code Here

Examples of org.zkoss.poi.xssf.usermodel.XSSFEvaluationWorkbook

2436
2437
2438
2439
2440
2441
2442
2443
2444
2445
2446
            }
        }
  }

  private static String shiftXSSFFormula(XSSFWorkbook book, int sheetIndex, String formula, PtgShifter shifter) {
        XSSFEvaluationWorkbook fpb = XSSFEvaluationWorkbook.create(book);
        Ptg[] ptgs = FormulaParser.parse(formula, fpb, FormulaType.CELL, sheetIndex);
        String shiftedFmla = null;
        if (shifter.adjustFormula(ptgs, sheetIndex)) {
            shiftedFmla = FormulaRenderer.toFormulaString(fpb, ptgs);
        }
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.