Author: fanningpj
Date: Fri Apr 8 13:08:10 2022
New Revision: 1899667
URL: http://svn.apache.org/viewvc?rev=1899667&view=rev
Log:
[github-321] add test case
Added:
poi/trunk/test-data/spreadsheet/github-321.xlsx (with props)
Modified:
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFWorkbook.java
Modified:
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFWorkbook.java
URL:
http://svn.apache.org/viewvc/poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFWorkbook.java?rev=1899667&r1=1899666&r2=1899667&view=diff
==============================================================================
---
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFWorkbook.java
(original)
+++
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFWorkbook.java
Fri Apr 8 13:08:10 2022
@@ -43,6 +43,7 @@ import org.apache.poi.ss.usermodel.Comme
import org.apache.poi.ss.usermodel.DataFormatter;
import org.apache.poi.ss.usermodel.Font;
import org.apache.poi.ss.usermodel.FormulaError;
+import org.apache.poi.ss.usermodel.FormulaEvaluator;
import org.apache.poi.ss.usermodel.RichTextString;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Row.MissingCellPolicy;
@@ -1398,6 +1399,21 @@ public final class TestXSSFWorkbook exte
}
}
+ @Test
+ void testGithub321() throws Exception {
+ try (XSSFWorkbook wb = openSampleWorkbook("github-321.xlsx")) {
+ XSSFSheet xssfSheet = wb.getSheetAt(0);
+ DataFormatter dataFormatter = new DataFormatter();
+ FormulaEvaluator formulaEvaluator =
wb.getCreationHelper().createFormulaEvaluator();
+ XSSFCell a3 = xssfSheet.getRow(2).getCell(0);
+ assertEquals("2.05", dataFormatter.formatCellValue(a3));
+ assertEquals("2.05", dataFormatter.formatCellValue(a3,
formulaEvaluator));
+ XSSFCell a4 = xssfSheet.getRow(3).getCell(0);
+ assertEquals("2.1", dataFormatter.formatCellValue(a4));
+ assertEquals("2.1", dataFormatter.formatCellValue(a4,
formulaEvaluator));
+ }
+ }
+
private static void expectFormattedContent(Cell cell, String value) {
assertEquals(value, new DataFormatter().formatCellValue(cell),
"Cell " + ref(cell) + " has wrong formatted content.");
Added: poi/trunk/test-data/spreadsheet/github-321.xlsx
URL:
http://svn.apache.org/viewvc/poi/trunk/test-data/spreadsheet/github-321.xlsx?rev=1899667&view=auto
==============================================================================
Binary file - no diff available.
Propchange: poi/trunk/test-data/spreadsheet/github-321.xlsx
------------------------------------------------------------------------------
--- svn:mime-type (added)
+++ svn:mime-type Fri Apr 8 13:08:10 2022
@@ -0,0 +1 @@
+application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
