https://bz.apache.org/bugzilla/show_bug.cgi?id=57642
Bug ID: 57642
Summary: Worksheet setSheetName() fails when IFERROR function
is present
Product: POI
Version: 3.11-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Created attachment 32524
--> https://bz.apache.org/bugzilla/attachment.cgi?id=32524&action=edit
A proposed patch (not sure it's the right solution!)
When an IFERROR() function is present into a cell, renaming worksheet via
sheet.setSheetName() leads to a NullPointerException
Here is the stacktrace
java.lang.NullPointerException
at
org.apache.poi.xssf.usermodel.helpers.XSSFFormulaUtils.updatePtg(XSSFFormulaUtils.java:128)
at
org.apache.poi.xssf.usermodel.helpers.XSSFFormulaUtils.updateFormula(XSSFFormulaUtils.java:98)
at
org.apache.poi.xssf.usermodel.helpers.XSSFFormulaUtils.updateSheetName(XSSFFormulaUtils.java:78)
at
org.apache.poi.xssf.usermodel.XSSFWorkbook.setSheetName(XSSFWorkbook.java:1368)
That worked on POI 3.10 release.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
