From e8f53b308406dcbca7e4029c7856dc7613411e78 Mon Sep 17 00:00:00 2001 From: PJ Fanning Date: Sun, 14 Aug 2022 09:50:00 +0000 Subject: [PATCH] [bug-66213] hack clone table code to avoid failing with edge cases git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1903410 13f79535-47bb-0310-9956-ffa450edef68 --- .../main/java/org/apache/poi/xssf/usermodel/XSSFSheet.java | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) 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 b2b41ce7f8..8efbfcf557 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 @@ -4948,8 +4948,9 @@ public class XSSFSheet extends POIXMLDocumentPart implements Sheet, OoxmlSheetEx 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); } } -- 2.39.5