From a6cc5ed7078762d8856b766a56cfef74e6b1ebf5 Mon Sep 17 00:00:00 2001 From: Nick Burch Date: Thu, 4 Nov 2010 16:55:36 +0000 Subject: [PATCH] Add a few more little bits of formula unit tests git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1031077 13f79535-47bb-0310-9956-ffa450edef68 --- .../testcases/org/apache/poi/xssf/usermodel/TestXSSFCell.java | 2 ++ 1 file changed, 2 insertions(+) diff --git a/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFCell.java b/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFCell.java index bd7319e5f3..0691363566 100644 --- a/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFCell.java +++ b/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFCell.java @@ -114,6 +114,7 @@ public final class TestXSSFCell extends BaseTestCell { cell.setCellFormula("A2"); assertEquals(XSSFCell.CELL_TYPE_FORMULA, cell.getCellType()); + assertEquals("A2", cell.getCellFormula()); //the value is not set and cell's type='N' which means blank assertEquals(STCellType.N, ctCell.getT()); @@ -121,6 +122,7 @@ public final class TestXSSFCell extends BaseTestCell { cell.setCellValue("t='str'"); //we are still of 'formula' type assertEquals(XSSFCell.CELL_TYPE_FORMULA, cell.getCellType()); + assertEquals("A2", cell.getCellFormula()); //cached formula value is set and cell's type='STR' assertEquals(STCellType.STR, ctCell.getT()); assertEquals("t='str'", cell.getStringCellValue()); -- 2.39.5