commit 6f6e1c41656c2f7282bae1ce9dae21f7458c3631
author PJ Fanning <fanningpj@apache.org> Sat Aug 13 20:05:34 2022 +0000
committer PJ Fanning <fanningpj@apache.org> Sat Aug 13 20:05:34 2022 +0000
tree 01fa3f464905133b3d4576212cab34bcfd5b0b8d
parent 6d2853d9bd5041b2e2938d5bc4cf4657cb33e86e

further issue with clone

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1903400 13f79535-47bb-0310-9956-ffa450edef68

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

diff --git a/poi-ooxml/src/main/java/org/apache/poi/xssf/usermodel/XSSFSheet.java b/poi-ooxml/src/main/java/org/apache/poi/xssf/usermodel/XSSFSheet.java
index f3a9156..c62183a 100644
--- a/poi-ooxml/src/main/java/org/apache/poi/xssf/usermodel/XSSFSheet.java
+++ b/poi-ooxml/src/main/java/org/apache/poi/xssf/usermodel/XSSFSheet.java
@@ -4938,7 +4938,12 @@
                         int c = clonedTable.getStartCellReference().getCol() + i;
                         sheet.getWorkbook().setCellFormulaValidation(false);
                         for (int r = rFirst; r <= rLast; r++) {
-                            sheet.getRow(r).getCell(c).setCellFormula(clonedFormula);
+                            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);
                         }
                     }
                 }