Author: fanningpj
Date: Sat Aug 13 20:05:34 2022
New Revision: 1903400
URL: http://svn.apache.org/viewvc?rev=1903400&view=rev
Log:
further issue with clone
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=1903400&r1=1903399&r2=1903400&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
Sat Aug 13 20:05:34 2022
@@ -4938,7 +4938,12 @@ public class XSSFSheet extends POIXMLDoc
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);
}
}
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
