Author: fanningpj
Date: Sun Aug 14 09:50:00 2022
New Revision: 1903410

URL: http://svn.apache.org/viewvc?rev=1903410&view=rev
Log:
[bug-66213] hack clone table code to avoid failing with edge cases

Modified:
    
poi/trunk/poi-ooxml/src/main/java/org/apache/poi/xssf/usermodel/XSSFSheet.java

Modified: 
poi/trunk/poi-ooxml/src/main/java/org/apache/poi/xssf/usermodel/XSSFSheet.java
URL: 
http://svn.apache.org/viewvc/poi/trunk/poi-ooxml/src/main/java/org/apache/poi/xssf/usermodel/XSSFSheet.java?rev=1903410&r1=1903409&r2=1903410&view=diff
==============================================================================
--- 
poi/trunk/poi-ooxml/src/main/java/org/apache/poi/xssf/usermodel/XSSFSheet.java 
(original)
+++ 
poi/trunk/poi-ooxml/src/main/java/org/apache/poi/xssf/usermodel/XSSFSheet.java 
Sun Aug 14 09:50:00 2022
@@ -4948,8 +4948,9 @@ public class XSSFSheet extends POIXMLDoc
                             int c = 
clonedTable.getStartCellReference().getCol() + i;
                             
sheet.getWorkbook().setCellFormulaValidation(false);
                             for (int r = rFirst; r <= rLast; r++) {
-                                XSSFRow row = sheet.getRow(r); if (row == 
null) row = sheet.createRow(r);
-                                XSSFCell cell = row.getCell(c); if (cell == 
null) cell = row.createCell(c);
+                                XSSFRow row = sheet.getRow(r);
+                                if (row == null) row = sheet.createRow(r);
+                                XSSFCell cell = row.getCell(c, 
Row.MissingCellPolicy.CREATE_NULL_AS_BLANK);
                                 cell.setCellFormula(clonedFormula);
                             }
                         }



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to