Examples of evaluateFormulaCell()


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
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.