Package org.apache.poi.ss.usermodel

Examples of org.apache.poi.ss.usermodel.CellValue.formatAsString()

1850
1851
1852
1853
1854
1855
1856
1857
        evaluator.evaluateAll();
       
        XSSFCell cell = excel.getSheetAt(0).getRow(1).getCell(1);
        CellValue value = evaluator.evaluate(cell);
       
        assertEquals(expect, value.formatAsString());
    }
}
View Full Code Here
392
393
394
395
396
397
398
399
400
401
402
    // numeric criteria
        for (int i = 0; i < 8; i++) {
      CellValue expected = evaluator.evaluate(sheet.getRow(i).getCell(REF_COL));
      CellValue actual = evaluator.evaluate(sheet.getRow(i).getCell(EVAL_COL));
      assertEquals(expected.formatAsString(), actual.formatAsString());
    }

        // boolean criteria
        for (int i = 0; i < 8; i++) {
            HSSFCell cellFmla = sheet.getRow(i).getCell(8);
View Full Code Here
102
103
104
105
106
107
108
109
110
111
112
    private void confirm(String formulaText, double expectedResult) {
        cell11.setCellFormula(formulaText);
        evaluator.clearAllCachedResultValues();
        CellValue cv = evaluator.evaluate(cell11);
        if (cv.getCellType() != Cell.CELL_TYPE_NUMERIC) {
            throw new AssertionFailedError("Wrong result type: " + cv.formatAsString());
        }
        double actualValue = cv.getNumberValue();
        assertEquals(expectedResult, actualValue, 0);
    }
}
View Full Code Here
1920
1921
1922
1923
1924
1925
1926
1927
        evaluator.evaluateAll();
       
        XSSFCell cell = excel.getSheetAt(0).getRow(1).getCell(1);
        CellValue value = evaluator.evaluate(cell);
       
        assertEquals(expect, value.formatAsString());
    }
}
View Full Code Here
159
160
161
162
163
164
165
166
167
168
169
      double expectedResult) {
    fe.clearAllCachedResultValues();
    cell.setCellFormula(formula);
    CellValue cv = fe.evaluate(cell);
    if (cv.getCellType() != Cell.CELL_TYPE_NUMERIC) {
      throw new AssertionFailedError("expected numeric cell type but got " + cv.formatAsString());
    }
    assertEquals(expectedResult, cv.getNumberValue(), 0.0);
  }
  private static void confirm(FormulaEvaluator fe, Cell cell, String formula,
      ErrorEval expectedResult) {
View Full Code Here
169
170
171
172
173
174
175
176
177
178
179
      ErrorEval expectedResult) {
    fe.clearAllCachedResultValues();
    cell.setCellFormula(formula);
    CellValue cv = fe.evaluate(cell);
    if (cv.getCellType() != Cell.CELL_TYPE_ERROR) {
      throw new AssertionFailedError("expected error cell type but got " + cv.formatAsString());
    }
    int expCode = expectedResult.getErrorCode();
    if (cv.getErrorValue() != expCode) {
      throw new AssertionFailedError("Expected error '" + EE.getText(expCode)
          + "' but got '" + cv.formatAsString() + "'.");
View Full Code Here
174
175
176
177
178
179
180
181
182
      throw new AssertionFailedError("expected error cell type but got " + cv.formatAsString());
    }
    int expCode = expectedResult.getErrorCode();
    if (cv.getErrorValue() != expCode) {
      throw new AssertionFailedError("Expected error '" + EE.getText(expCode)
          + "' but got '" + cv.formatAsString() + "'.");
    }
  }
}
View Full Code Here
395
396
397
398
399
400
401
402
403
404
405
    // numeric criteria
        for (int i = 0; i < 8; i++) {
      CellValue expected = evaluator.evaluate(sheet.getRow(i).getCell(REF_COL));
      CellValue actual = evaluator.evaluate(sheet.getRow(i).getCell(EVAL_COL));
      assertEquals(expected.formatAsString(), actual.formatAsString());
    }

        // boolean criteria
        for (int i = 0; i < 8; i++) {
            HSSFCell cellFmla = sheet.getRow(i).getCell(8);
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
    private void confirm(String formulaText, double expectedResult) {
        cell11.setCellFormula(formulaText);
        evaluator.clearAllCachedResultValues();
        CellValue cv = evaluator.evaluate(cell11);
        if (cv.getCellType() != Cell.CELL_TYPE_NUMERIC) {
            throw new AssertionFailedError("Wrong result type: " + cv.formatAsString());
        }
        double actualValue = cv.getNumberValue();
        assertEquals(expectedResult, actualValue, 0);
    }
}
View Full Code Here
170
171
172
173
174
175
176
177
178
179
180
      double expectedResult) {
    fe.clearAllCachedResultValues();
    cell.setCellFormula(formula);
    CellValue cv = fe.evaluate(cell);
    if (cv.getCellType() != Cell.CELL_TYPE_NUMERIC) {
      throw new AssertionFailedError("expected numeric cell type but got " + cv.formatAsString());
    }
    assertEquals(expectedResult, cv.getNumberValue(), 0.0);
  }
  private static void confirm(FormulaEvaluator fe, Cell cell, String formula,
      ErrorEval expectedResult) {
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.