Package org.apache.poi.ss.formula

Examples of org.apache.poi.ss.formula.WorkbookEvaluator.evaluate()

204
205
206
207
208
209
210
211
212
213
214
      row.createCell(i).setCellFormula(String.valueOf(i));
    }

    EvalCountListener evalListener = new EvalCountListener();
    WorkbookEvaluator evaluator = WorkbookEvaluatorTestHelper.createEvaluator(wb, evalListener);
    ValueEval ve = evaluator.evaluate(HSSFEvaluationTestHelper.wrapCell(cellA1));
    int evalCount = evalListener.getEvalCount();
    if (evalCount == 6) {
      // Without short-circuit-if evaluation, evaluating cell 'A1' takes 3 extra evaluations (for D1,E1,F1)
      throw new AssertionFailedError("Identifed bug 48195 - Formula evaluator should short-circuit IF() calculations.");
    }
View Full Code Here
340
341
342
343
344
345
346
347
348
349
350
   
    // Choose cell A9, so that the failing test case doesn't take too long to execute.
    HSSFCell cell = row.getCell(8);
    EvalListener evalListener = new EvalListener();
    WorkbookEvaluator evaluator = WorkbookEvaluatorTestHelper.createEvaluator(wb, evalListener);
    evaluator.evaluate(HSSFEvaluationTestHelper.wrapCell(cell));
    int evalCount = evalListener.getCountCacheMisses();
    if (evalCount > 10) {
      // Without caching, evaluating cell 'A9' takes 21845 evaluations which consumes
      // much time (~3 sec on Core 2 Duo 2.2GHz)
      System.err.println("Cell A9 took " + evalCount + " intermediate evaluations");
View Full Code Here
160
161
162
163
164
165
166
167
168
169
170
      row.createCell(i).setCellFormula(String.valueOf(i));
    }

    EvalCountListener evalListener = new EvalCountListener();
    WorkbookEvaluator evaluator = WorkbookEvaluatorTestHelper.createEvaluator(wb, evalListener);
    ValueEval ve = evaluator.evaluate(HSSFEvaluationTestHelper.wrapCell(cellA1));
    int evalCount = evalListener.getEvalCount();
    if (evalCount == 6) {
      // Without short-circuit-if evaluation, evaluating cell 'A1' takes 3 extra evaluations (for D1,E1,F1)
      throw new AssertionFailedError("Identifed bug 48195 - Formula evaluator should short-circuit IF() calculations.");
    }
View Full Code Here
160
161
162
163
164
165
166
167
168
169
170
      row.createCell(i).setCellFormula(String.valueOf(i));
    }

    EvalCountListener evalListener = new EvalCountListener();
    WorkbookEvaluator evaluator = WorkbookEvaluatorTestHelper.createEvaluator(wb, evalListener);
    ValueEval ve = evaluator.evaluate(HSSFEvaluationTestHelper.wrapCell(cellA1));
    int evalCount = evalListener.getEvalCount();
    if (evalCount == 6) {
      // Without short-circuit-if evaluation, evaluating cell 'A1' takes 3 extra evaluations (for D1,E1,F1)
      throw new AssertionFailedError("Identifed bug 48195 - Formula evaluator should short-circuit IF() calculations.");
    }
View Full Code Here
340
341
342
343
344
345
346
347
348
349
350
    // Choose cell A9, so that the failing test case doesn't take too long to execute.
    HSSFCell cell = row.getCell(8);
    EvalListener evalListener = new EvalListener();
    WorkbookEvaluator evaluator = WorkbookEvaluatorTestHelper.createEvaluator(wb, evalListener);
    evaluator.evaluate(HSSFEvaluationTestHelper.wrapCell(cell));
    int evalCount = evalListener.getCountCacheMisses();
    if (evalCount > 10) {
      // Without caching, evaluating cell 'A9' takes 21845 evaluations which consumes
      // much time (~3 sec on Core 2 Duo 2.2GHz)
      System.err.println("Cell A9 took " + evalCount + " intermediate evaluations");
View Full Code Here
159
160
161
162
163
164
165
166
167
168
169
      row.createCell(i).setCellFormula(String.valueOf(i));
    }

    EvalCountListener evalListener = new EvalCountListener();
    WorkbookEvaluator evaluator = WorkbookEvaluatorTestHelper.createEvaluator(wb, evalListener);
    ValueEval ve = evaluator.evaluate(HSSFEvaluationTestHelper.wrapCell(cellA1));
    int evalCount = evalListener.getEvalCount();
    if (evalCount == 6) {
      // Without short-circuit-if evaluation, evaluating cell 'A1' takes 3 extra evaluations (for D1,E1,F1)
      throw new AssertionFailedError("Identifed bug 48195 - Formula evaluator should short-circuit IF() calculations.");
    }
View Full Code Here
158
159
160
161
162
163
164
165
166
167
168
      row.createCell(i).setCellFormula(String.valueOf(i));
    }

    EvalCountListener evalListener = new EvalCountListener();
    WorkbookEvaluator evaluator = WorkbookEvaluatorTestHelper.createEvaluator(wb, evalListener);
    ValueEval ve = evaluator.evaluate(HSSFEvaluationTestHelper.wrapCell(cellA1));
    int evalCount = evalListener.getEvalCount();
    if (evalCount == 6) {
      // Without short-circuit-if evaluation, evaluating cell 'A1' takes 3 extra evaluations (for D1,E1,F1)
      throw new AssertionFailedError("Identifed bug 48195 - Formula evaluator should short-circuit IF() calculations.");
    }
View Full Code Here
345
346
347
348
349
350
351
352
353
354
355
    // Choose cell A9 instead of A10, so that the failing test case doesn't take too long to execute.
    HSSFCell cell = row.getCell(8);
    EvalListener evalListener = new EvalListener();
    WorkbookEvaluator evaluator = WorkbookEvaluatorTestHelper.createEvaluator(wb, evalListener);
    ValueEval ve = evaluator.evaluate(HSSFEvaluationTestHelper.wrapCell(cell));
    int evalCount = evalListener.getCountCacheMisses();
    if (evalCount > 10) {
      // Without caching, evaluating cell 'A9' takes 21845 evaluations which consumes
      // much time (~3 sec on Core 2 Duo 2.2GHz)
      // short-circuit-if optimisation cuts this down to 255 evaluations which is still too high
View Full Code Here
346
347
348
349
350
351
352
353
354
355
356
   
    // Choose cell A9, so that the failing test case doesn't take too long to execute.
    HSSFCell cell = row.getCell(8);
    EvalListener evalListener = new EvalListener();
    WorkbookEvaluator evaluator = WorkbookEvaluatorTestHelper.createEvaluator(wb, evalListener);
    evaluator.evaluate(HSSFEvaluationTestHelper.wrapCell(cell));
    int evalCount = evalListener.getCountCacheMisses();
    if (evalCount > 10) {
      // Without caching, evaluating cell 'A9' takes 21845 evaluations which consumes
      // much time (~3 sec on Core 2 Duo 2.2GHz)
      System.err.println("Cell A9 took " + evalCount + " intermediate evaluations");
View Full Code Here
204
205
206
207
208
209
210
211
212
213
214
      row.createCell(i).setCellFormula(String.valueOf(i));
    }

    EvalCountListener evalListener = new EvalCountListener();
    WorkbookEvaluator evaluator = WorkbookEvaluatorTestHelper.createEvaluator(wb, evalListener);
    ValueEval ve = evaluator.evaluate(HSSFEvaluationTestHelper.wrapCell(cellA1));
    int evalCount = evalListener.getEvalCount();
    if (evalCount == 6) {
      // Without short-circuit-if evaluation, evaluating cell 'A1' takes 3 extra evaluations (for D1,E1,F1)
      throw new AssertionFailedError("Identifed bug 48195 - Formula evaluator should short-circuit IF() calculations.");
    }
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.