List of clearAllCachedResultValues() Examples

Examples of clearAllCachedResultValues()

org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.clearAllCachedResultValues()
Should be called whenever there are major changes (e.g. moving sheets) to input cells in the evaluated workbook. If performance is not critical, a single call to this method may be used instead of many specific calls to the notify~ methods. Failure to call this method after changing cell values will cause incorrect behaviour of the evaluate~ methods of this class
org.apache.poi.ss.usermodel.FormulaEvaluator.clearAllCachedResultValues()
Should be called whenever there are changes to input cells in the evaluated workbook. Failure to call this method after changing cell values will cause incorrect behaviour of the evaluate~ methods of this class

Examples of org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.clearAllCachedResultValues()

    cv = fe.evaluate(cellB1); // no circ-ref-error because A1 result is cached
    assertEquals(Cell.CELL_TYPE_NUMERIC, cv.getCellType());
    assertEquals(46.0, cv.getNumberValue(), 0.0);
    
    // Show the bug - evaluate another cell from the loop first
    fe.clearAllCachedResultValues();
    cv = fe.evaluate(cellB1);
    if (cv.getCellType() == ErrorEval.CIRCULAR_REF_ERROR.getErrorCode()) {
      throw new AssertionFailedError("Identified bug 46898");
    }
    assertEquals(Cell.CELL_TYPE_NUMERIC, cv.getCellType());

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.clearAllCachedResultValues()

    }
    assertEquals(Cell.CELL_TYPE_NUMERIC, cv.getCellType());
    assertEquals(46.0, cv.getNumberValue(), 0.0);


    // start evaluation on another cell
    fe.clearAllCachedResultValues();
    cv = fe.evaluate(cellE1);
    assertEquals(Cell.CELL_TYPE_NUMERIC, cv.getCellType());
    assertEquals(43.0, cv.getNumberValue(), 0.0);

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.clearAllCachedResultValues()


        HSSFCell cell = row.createCell(7);
        cell.setCellFormula("MIRR(A1:E1, F1, G1)");


        HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(wb);
        fe.clearAllCachedResultValues();
        fe.evaluateFormulaCell(cell);
        double res = cell.getNumericCellValue();
        assertEquals(0.18736225093, res, 0.00000001);
    }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.clearAllCachedResultValues()

    HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(wb);
    HSSFSheet sheet = wb.createSheet("Sheet1");
    HSSFCell cell = sheet.createRow(0).createCell(0);
    
    cell.setCellFormula("if(true,)"); 
    fe.clearAllCachedResultValues();
    CellValue cv;
    try {
      cv = fe.evaluate(cell);
    } catch (EmptyStackException e) {
      throw new AssertionFailedError("Missing args evaluation not implemented (bug 43354");

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.clearAllCachedResultValues()

    // MissingArg -> BlankEval -> zero (as formula result)
    assertEquals(0.0, cv.getNumberValue(), 0.0);
    
    // MissingArg -> BlankEval -> empty string (in concatenation)
    cell.setCellFormula("\"abc\"&if(true,)"); 
    fe.clearAllCachedResultValues();
    assertEquals("abc", fe.evaluate(cell).getStringValue());
  }
  
  public void testCountFuncs() {
    HSSFWorkbook wb = new HSSFWorkbook();

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.clearAllCachedResultValues()

    
    cell.setCellFormula("COUNT(C5,,,,)"); // 4 missing args, C5 is blank 
    assertEquals(4.0, fe.evaluate(cell).getNumberValue(), 0.0);


    cell.setCellFormula("COUNTA(C5,,)"); // 2 missing args, C5 is blank 
    fe.clearAllCachedResultValues();
    assertEquals(2.0, fe.evaluate(cell).getNumberValue(), 0.0);
  }
}

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.clearAllCachedResultValues()

    cv = fe.evaluate(cellB1); // no circ-ref-error because A1 result is cached
    assertEquals(Cell.CELL_TYPE_NUMERIC, cv.getCellType());
    assertEquals(46.0, cv.getNumberValue(), 0.0);


    // Show the bug - evaluate another cell from the loop first
    fe.clearAllCachedResultValues();
    cv = fe.evaluate(cellB1);
    if (cv.getCellType() == ErrorEval.CIRCULAR_REF_ERROR.getErrorCode()) {
      throw new AssertionFailedError("Identified bug 46898");
    }
    assertEquals(Cell.CELL_TYPE_NUMERIC, cv.getCellType());

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.clearAllCachedResultValues()

    }
    assertEquals(Cell.CELL_TYPE_NUMERIC, cv.getCellType());
    assertEquals(46.0, cv.getNumberValue(), 0.0);


    // start evaluation on another cell
    fe.clearAllCachedResultValues();
    cv = fe.evaluate(cellE1);
    assertEquals(Cell.CELL_TYPE_NUMERIC, cv.getCellType());
    assertEquals(43.0, cv.getNumberValue(), 0.0);

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.clearAllCachedResultValues()

    HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(wb);
    HSSFSheet sheet = wb.createSheet("Sheet1");
    HSSFCell cell = sheet.createRow(0).createCell(0);
    
    cell.setCellFormula("if(true,)"); 
    fe.clearAllCachedResultValues();
    CellValue cv;
    try {
      cv = fe.evaluate(cell);
    } catch (EmptyStackException e) {
      throw new AssertionFailedError("Missing args evaluation not implemented (bug 43354");

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.clearAllCachedResultValues()

    // MissingArg -> BlankEval -> zero (as formula result)
    assertEquals(0.0, cv.getNumberValue(), 0.0);
    
    // MissingArg -> BlankEval -> empty string (in concatenation)
    cell.setCellFormula("\"abc\"&if(true,)"); 
    fe.clearAllCachedResultValues();
    assertEquals("abc", fe.evaluate(cell).getStringValue());
  }
  
  public void testCountFuncs() {
    HSSFWorkbook wb = new HSSFWorkbook();

View Full Code Here

0 1

TOP

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.