Author: fanningpj
Date: Sun Sep 17 14:49:16 2023
New Revision: 1912366
URL: http://svn.apache.org/viewvc?rev=1912366&view=rev
Log:
[bug-67442] add test
Added:
poi/trunk/test-data/spreadsheet/testSharedFormulasRangeSetBlankBug.xlsx
(with props)
Modified:
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFSheet.java
Modified:
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFSheet.java
URL:
http://svn.apache.org/viewvc/poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFSheet.java?rev=1912366&r1=1912365&r2=1912366&view=diff
==============================================================================
---
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFSheet.java
(original)
+++
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFSheet.java
Sun Sep 17 14:49:16 2023
@@ -35,6 +35,7 @@ import java.util.Arrays;
import java.util.Calendar;
import java.util.Date;
import java.util.HashSet;
+import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Set;
@@ -2386,4 +2387,31 @@ public final class TestXSSFSheet extends
sheet.addHyperlink(hyperlink);
return wb;
}
+
+ @Test
+ void testSetBlankOnNestedSharedFormulas() throws IOException {
+ try (XSSFWorkbook wb1 =
XSSFTestDataSamples.openSampleWorkbook("testSharedFormulasSetBlank.xlsx")) {
+ XSSFSheet s1 = wb1.getSheetAt(0);
+ assertNotNull(s1);
+ Iterator<Row> rowIterator = s1.rowIterator();
+ int count = 0;
+ StringBuilder sb = new StringBuilder();
+ while (rowIterator.hasNext()) {
+ Row row = rowIterator.next();
+ Iterator<Cell> cellIterator = row.cellIterator();
+ while (cellIterator.hasNext()) {
+ Cell cell = cellIterator.next();
+
+ // the toString is needed to exhibit the broken state
+ sb.append(cell.toString()).append(",");
+ count++;
+
+ // breaks the sheet state
+ cell.setBlank();
+ }
+ }
+ assertEquals(10, count);
+ assertEquals("2-1,2-1,1+2,2-1,2-1,3+3,3+3,3+3,2-1,2-1,",
sb.toString());
+ }
+ }
}
Added: poi/trunk/test-data/spreadsheet/testSharedFormulasRangeSetBlankBug.xlsx
URL:
http://svn.apache.org/viewvc/poi/trunk/test-data/spreadsheet/testSharedFormulasRangeSetBlankBug.xlsx?rev=1912366&view=auto
==============================================================================
Binary file - no diff available.
Propchange:
poi/trunk/test-data/spreadsheet/testSharedFormulasRangeSetBlankBug.xlsx
------------------------------------------------------------------------------
--- svn:mime-type (added)
+++ svn:mime-type Sun Sep 17 14:49:16 2023
@@ -0,0 +1 @@
+application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
