Examples with CellValue org.apache.poi.ss.usermodel.CellValue used on opensource projects

Example 31 with CellValue

use of org.apache.poi.ss.usermodel.CellValue in project poi by apache.

the class TestIndirect method confirm.

private static void confirm(FormulaEvaluator fe, Cell cell, String formula, double expectedResult) {
    fe.clearAllCachedResultValues();
    cell.setCellFormula(formula);
    CellValue cv = fe.evaluate(cell);
    if (cv.getCellTypeEnum() != CellType.NUMERIC) {
        fail("expected numeric cell type but got " + cv.formatAsString());
    }
    assertEquals(expectedResult, cv.getNumberValue(), 0.0);
}

Example 32 with CellValue

use of org.apache.poi.ss.usermodel.CellValue in project poi by apache.

the class TestIndirect method confirm.

private static void confirm(FormulaEvaluator fe, Cell cell, String formula, ErrorEval expectedResult) {
    fe.clearAllCachedResultValues();
    cell.setCellFormula(formula);
    CellValue cv = fe.evaluate(cell);
    if (cv.getCellTypeEnum() != CellType.ERROR) {
        fail("expected error cell type but got " + cv.formatAsString());
    }
    int expCode = expectedResult.getErrorCode();
    if (cv.getErrorValue() != expCode) {
        fail("Expected error '" + ErrorEval.getText(expCode) + "' but got '" + cv.formatAsString() + "'.");
    }
}

Example 33 with CellValue

use of org.apache.poi.ss.usermodel.CellValue in project poi by apache.

the class TestFind method confirmError.

private static void confirmError(HSSFFormulaEvaluator fe, HSSFCell cell, String formulaText, FormulaError expectedErrorCode) {
    cell.setCellFormula(formulaText);
    fe.notifyUpdateCell(cell);
    CellValue result = fe.evaluate(cell);
    assertEquals(result.getCellTypeEnum(), CellType.ERROR);
    assertEquals(expectedErrorCode.getCode(), result.getErrorValue());
}

Example 34 with CellValue

use of org.apache.poi.ss.usermodel.CellValue in project poi by apache.

the class TestFixed method confirmValueError.

private void confirmValueError(String formulaText) {
    cell11.setCellFormula(formulaText);
    evaluator.clearAllCachedResultValues();
    CellValue cv = evaluator.evaluate(cell11);
    assertTrue("Wrong result type: " + cv.formatAsString(), cv.getCellTypeEnum() == CellType.ERROR && cv.getErrorValue() == FormulaError.VALUE.getCode());
}

Example 35 with CellValue

use of org.apache.poi.ss.usermodel.CellValue in project poi by apache.

the class TestIsBlank method test3DArea.

public void test3DArea() {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet1 = wb.createSheet();
    wb.setSheetName(0, "Sheet1");
    wb.createSheet();
    wb.setSheetName(1, "Sheet2");
    HSSFRow row = sheet1.createRow(0);
    HSSFCell cell = row.createCell(0);
    cell.setCellFormula("isblank(Sheet2!A1:A1)");
    HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(wb);
    CellValue result = fe.evaluate(cell);
    assertEquals(CellType.BOOLEAN, result.getCellTypeEnum());
    assertEquals(true, result.getBooleanValue());
    cell.setCellFormula("isblank(D7:D7)");
    result = fe.evaluate(cell);
    assertEquals(CellType.BOOLEAN, result.getCellTypeEnum());
    assertEquals(true, result.getBooleanValue());
}