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

Class org.apache.poi.ss.usermodel.FormulaEvaluator

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

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)

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


       // For 51875

View Full Code Here

       assertEquals("SUM(\n1,2\n)", c.getCellFormula());
       assertEquals(3.0, c.getNumericCellValue(), 0);


       // For 51875
       Cell b3 = s.getRow(2).getCell(1);
       formulaEvaluator.evaluateFormulaCell(b3);
       assertEquals("B1+B2", b3.getCellFormula()); // The newline is lost for shared formulas
       assertEquals(3.0, b3.getNumericCellValue(), 0);
    }
    
    /**

View Full Code Here

          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

          
          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

       
       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

    c2.setCellFormula("10/2");
        assertEquals(0.0, c2.getNumericCellValue() );


    FormulaEvaluator fe = new XSSFFormulaEvaluator(wb);
    
    fe.evaluateFormulaCell(c1);
    fe.evaluateFormulaCell(c2);
    
    assertEquals(6.0, c1.getNumericCellValue(), 0.0001);
    assertEquals(5.0, c2.getNumericCellValue(), 0.0001);
  }

View Full Code Here

        assertEquals(0.0, c2.getNumericCellValue() );


    FormulaEvaluator fe = new XSSFFormulaEvaluator(wb);
    
    fe.evaluateFormulaCell(c1);
    fe.evaluateFormulaCell(c2);
    
    assertEquals(6.0, c1.getNumericCellValue(), 0.0001);
    assertEquals(5.0, c2.getNumericCellValue(), 0.0001);
  }

View Full Code Here




    // Evaluate and test
    FormulaEvaluator fe = new XSSFFormulaEvaluator(wb);
    
    fe.evaluateFormulaCell(c1);
    fe.evaluateFormulaCell(c2);
    fe.evaluateFormulaCell(c3);
    fe.evaluateFormulaCell(c4);
    
    assertEquals(3.6, c1.getNumericCellValue(), 0.0001);

View Full Code Here


    // Evaluate and test
    FormulaEvaluator fe = new XSSFFormulaEvaluator(wb);
    
    fe.evaluateFormulaCell(c1);
    fe.evaluateFormulaCell(c2);
    fe.evaluateFormulaCell(c3);
    fe.evaluateFormulaCell(c4);
    
    assertEquals(3.6, c1.getNumericCellValue(), 0.0001);
    assertEquals(17.5, c2.getNumericCellValue(), 0.0001);

View Full Code Here

    // Evaluate and test
    FormulaEvaluator fe = new XSSFFormulaEvaluator(wb);
    
    fe.evaluateFormulaCell(c1);
    fe.evaluateFormulaCell(c2);
    fe.evaluateFormulaCell(c3);
    fe.evaluateFormulaCell(c4);
    
    assertEquals(3.6, c1.getNumericCellValue(), 0.0001);
    assertEquals(17.5, c2.getNumericCellValue(), 0.0001);
    assertEquals(1, c3.getNumericCellValue(), 0.0001);

View Full Code Here

0 1 2 3 4 5 6 7

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.