poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 57642] New: Worksheet setSheetName() fails when IFERROR function is present
Date Fri, 27 Feb 2015 14:30:15 GMT
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: dev@poi.apache.org
          Reporter: guarale@hotmail.com

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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message