Author: fanningpj
Date: Tue Oct 17 16:05:08 2023
New Revision: 1913068
URL: http://svn.apache.org/viewvc?rev=1913068&view=rev
Log:
[bug-67784] add tests
Added:
poi/trunk/test-data/spreadsheet/bug67784.xlsx (with props)
Modified:
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/extractor/TestXSSFEventBasedExcelExtractor.java
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/extractor/TestXSSFExcelExtractor.java
Modified:
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/extractor/TestXSSFEventBasedExcelExtractor.java
URL:
http://svn.apache.org/viewvc/poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/extractor/TestXSSFEventBasedExcelExtractor.java?rev=1913068&r1=1913067&r2=1913068&view=diff
==============================================================================
---
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/extractor/TestXSSFEventBasedExcelExtractor.java
(original)
+++
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/extractor/TestXSSFEventBasedExcelExtractor.java
Tue Oct 17 16:05:08 2023
@@ -362,4 +362,31 @@ class TestXSSFEventBasedExcelExtractor {
assertContains(text, "Bob\tBob");
}
}
+
+ @Test
+ void test67784() throws Exception {
+ try (XSSFEventBasedExcelExtractor ex =
+ new XSSFEventBasedExcelExtractor(
+
XSSFTestDataSamples.openSamplePackage("bug67784.xlsx"))) {
+ String text = ex.getText().replace("\r", "");
+ String[] lines = text.split("\n");
+ assertEquals("FALSE", lines[2]);
+ assertEquals("TRUE", lines[3]);
+ assertEquals("ERROR:#DIV/0!", lines[4]);
+ }
+ }
+
+ @Test
+ void test67784Formulas() throws Exception {
+ try (XSSFEventBasedExcelExtractor ex =
+ new XSSFEventBasedExcelExtractor(
+
XSSFTestDataSamples.openSamplePackage("bug67784.xlsx"))) {
+ ex.setFormulasNotResults(true);
+ String text = ex.getText().replace("\r", "");
+ String[] lines = text.split("\n");
+ assertEquals("(2 > 5)", lines[2]);
+ assertEquals("(2 < 4)", lines[3]);
+ assertEquals("10/0", lines[4]);
+ }
+ }
}
Modified:
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/extractor/TestXSSFExcelExtractor.java
URL:
http://svn.apache.org/viewvc/poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/extractor/TestXSSFExcelExtractor.java?rev=1913068&r1=1913067&r2=1913068&view=diff
==============================================================================
---
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/extractor/TestXSSFExcelExtractor.java
(original)
+++
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/extractor/TestXSSFExcelExtractor.java
Tue Oct 17 16:05:08 2023
@@ -245,6 +245,17 @@ class TestXSSFExcelExtractor {
//in the extracted text
assertNotContained(text, "\u30CB\u30DB\u30F3");
}
+ }
+ @Test
+ void test67784Formulas() throws Exception {
+ try (XSSFExcelExtractor extractor = getExtractor("bug67784.xlsx")) {
+ extractor.setFormulasNotResults(true);
+ String text = extractor.getText().replace("\r", "");
+ String[] lines = text.split("\n");
+ assertEquals("(2 > 5)", lines[2]);
+ assertEquals("(2 < 4)", lines[3]);
+ assertEquals("10/0", lines[4]);
+ }
}
}
Added: poi/trunk/test-data/spreadsheet/bug67784.xlsx
URL:
http://svn.apache.org/viewvc/poi/trunk/test-data/spreadsheet/bug67784.xlsx?rev=1913068&view=auto
==============================================================================
Binary file - no diff available.
Propchange: poi/trunk/test-data/spreadsheet/bug67784.xlsx
------------------------------------------------------------------------------
--- svn:mime-type (added)
+++ svn:mime-type Tue Oct 17 16:05:08 2023
@@ -0,0 +1 @@
+application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
