List of evaluateFormulaCell() Examples

Examples of evaluateFormulaCell()

org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCell()
If cell contains formula, it evaluates the formula, and saves the result of the formula. The cell remains as a formula cell. If the cell does not contain formula, this method returns -1 and leaves the cell unchanged. Note that the type of the formula result is returned, so you know what kind of cached formula result is also stored with the formula.
```
 int evaluatedCellType = evaluator.evaluateFormulaCell(cell); 
```
Be aware that your cell will hold both the formula, and the result. If you want the cell replaced with the result of the formula, use {@link #evaluateInCell(org.apache.poi.ss.usermodel.Cell)} @param cell The cell to evaluate @return -1 for non-formula cells, or the type of the formula result
org.apache.poi.ss.usermodel.FormulaEvaluator.evaluateFormulaCell()
If cell contains formula, it evaluates the formula, and saves the result of the formula. The cell remains as a formula cell. Else if cell does not contain formula, this method leaves the cell unchanged. Note that the type of the formula result is returned, so you know what kind of value is also stored with the formula.
```
 int evaluatedCellType = evaluator.evaluateFormulaCell(cell); 
```
Be aware that your cell will hold both the formula, and the result. If you want the cell replaced with the result of the formula, use {@link #evaluateInCell(Cell)} @param cell The cell to evaluate @return The type of the formula result (the cell's type remains as Cell.CELL_TYPE_FORMULA however)

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

    assertEquals("NPER(12,4500,100000,100000)", cell.getCellFormula());
    assertEquals(HSSFCell.CELL_TYPE_NUMERIC, cell.getCachedFormulaResultType());
    assertEquals(15.0, cell.getNumericCellValue(), 0.0);


    HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(wb);
    fe.evaluateFormulaCell(cell);
    assertEquals(HSSFCell.CELL_TYPE_ERROR, cell.getCachedFormulaResultType());
    assertEquals(HSSFErrorConstants.ERROR_NUM, cell.getErrorCellValue());
  }
}

View Full Code Here

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

        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);
    }


    public void testMirrFromSpreadsheet() {

View Full Code Here

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

        }
        final int cellValueType;
        if (cell.getCellType() == HSSFCell.CELL_TYPE_FORMULA) {
             final HSSFFormulaEvaluator evaluator = new HSSFFormulaEvaluator(sheet, workbook);
             evaluator.setCurrentRow(row);
             cellValueType = evaluator.evaluateFormulaCell(cell);
        }
        else {
          cellValueType = cell.getCellType();
        }

View Full Code Here

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

    assertEquals("NPER(12,4500,100000,100000)", cell.getCellFormula());
    assertEquals(HSSFCell.CELL_TYPE_NUMERIC, cell.getCachedFormulaResultType());
    assertEquals(15.0, cell.getNumericCellValue(), 0.0);


    HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(wb);
    fe.evaluateFormulaCell(cell);
    assertEquals(HSSFCell.CELL_TYPE_ERROR, cell.getCachedFormulaResultType());
    assertEquals(HSSFErrorConstants.ERROR_NUM, cell.getErrorCellValue());
  }
}

View Full Code Here

Examples of org.apache.poi.ss.usermodel.FormulaEvaluator.evaluateFormulaCell()

       
       assertEquals("SUM(\n1,2\n)", c.getCellFormula());
       assertEquals(3.0, c.getNumericCellValue());
       
       FormulaEvaluator formulaEvaluator = wb.getCreationHelper().createFormulaEvaluator();
       formulaEvaluator.evaluateFormulaCell(c);
       
       assertEquals("SUM(\n1,2\n)", c.getCellFormula());
       assertEquals(3.0, c.getNumericCellValue());
    }

View Full Code Here

Examples of org.apache.poi.ss.usermodel.FormulaEvaluator.evaluateFormulaCell()

          cfs.setCellFormula("B1");
          
          FormulaEvaluator fe = wb.getCreationHelper().createFormulaEvaluator();
          assertEquals(Cell.CELL_TYPE_NUMERIC, fe.evaluate(cfn).getCellType());
          assertEquals(Cell.CELL_TYPE_STRING, fe.evaluate(cfs).getCellType());
          fe.evaluateFormulaCell(cfn);
          fe.evaluateFormulaCell(cfs);
          
          // Now test
          assertEquals(Cell.CELL_TYPE_NUMERIC, cn.getCellType());
          assertEquals(Cell.CELL_TYPE_STRING, cs.getCellType());

View Full Code Here

Examples of org.apache.poi.ss.usermodel.FormulaEvaluator.evaluateFormulaCell()

          
          FormulaEvaluator fe = wb.getCreationHelper().createFormulaEvaluator();
          assertEquals(Cell.CELL_TYPE_NUMERIC, fe.evaluate(cfn).getCellType());
          assertEquals(Cell.CELL_TYPE_STRING, fe.evaluate(cfs).getCellType());
          fe.evaluateFormulaCell(cfn);
          fe.evaluateFormulaCell(cfs);
          
          // Now test
          assertEquals(Cell.CELL_TYPE_NUMERIC, cn.getCellType());
          assertEquals(Cell.CELL_TYPE_STRING, cs.getCellType());
          assertEquals(Cell.CELL_TYPE_FORMULA, cfn.getCellType());

View Full Code Here

Examples of org.apache.poi.ss.usermodel.FormulaEvaluator.evaluateFormulaCell()

    for(int sheetNum = 0; sheetNum < wb.getNumberOfSheets(); sheetNum++) {
        Sheet sheet = wb.getSheetAt(sheetNum);
        for(Row r : sheet) {
            for(Cell c : r) {
                if(c.getCellType() == Cell.CELL_TYPE_FORMULA) {
                    evaluator.evaluateFormulaCell(c);
                }
            }
        }
    }
  }

View Full Code Here

Examples of org.apache.poi.ss.usermodel.FormulaEvaluator.evaluateFormulaCell()

    Row lARow = lSheet.getRow(0);
    Cell lA1Cell = lARow.getCell(0);
    
    assertEquals(Cell.CELL_TYPE_FORMULA, lA1Cell.getCellType());
    try {
      evaluator.evaluateFormulaCell(lA1Cell);
      fail("Missing external workbook reference exception expected!");
    }catch(RuntimeException re) {
      assertTrue("Unexpected exception: " + re, re.getMessage().indexOf(SOURCE_DUMMY_WORKBOOK_FILENAME) != -1);
    }
  }

View Full Code Here

Examples of org.apache.poi.ss.usermodel.FormulaEvaluator.evaluateFormulaCell()

    
        // Evaluate
    FormulaEvaluator evaluator = mainWorkbook.getCreationHelper().createFormulaEvaluator();
        evaluator.setIgnoreMissingWorkbooks(true);


    assertEquals(Cell.CELL_TYPE_NUMERIC, evaluator.evaluateFormulaCell(lA1Cell));
    assertEquals(Cell.CELL_TYPE_STRING,  evaluator.evaluateFormulaCell(lB1Cell));
    assertEquals(Cell.CELL_TYPE_BOOLEAN, evaluator.evaluateFormulaCell(lC1Cell));


    assertEquals(10.0d, lA1Cell.getNumericCellValue(), 0.00001d);
    assertEquals("POI rocks!", lB1Cell.getStringCellValue());

View Full Code Here

0 1 2 3 4 5

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.