DO NOT REPLY [Bug 51998] New: XSSF error when removing and re-creating worksheets

[bu...@apache.org]

https://issues.apache.org/bugzilla/show_bug.cgi?id=51998

             Bug #: 51998
           Summary: XSSF error when removing and re-creating worksheets
           Product: POI
           Version: 3.8-dev
          Platform: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: mrogghe@blazent.com
    Classification: Unclassified


Created attachment 27741
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=27741
Java class and workbook to re-create error

POI-3.8-beta4.
XSSF usermodel using SS usermodel interfaces.

Original motivation is to clear the contents of worksheets and then repopulate
the worksheet with other data.

1.  After some other experiments, method I opted for was to delete the sheet
and then recreate it (same name and same index).  This resulted in POI errors
indicating the sheet index it was trying to use was out of range.  Stack trace:
Exception in thread "main" java.lang.IllegalArgumentException: Sheet index (-1)
is out of range (0..8)
    at
org.apache.poi.xssf.usermodel.XSSFWorkbook.validateSheetIndex(XSSFWorkbook.java:945)
    at
org.apache.poi.xssf.usermodel.XSSFWorkbook.getSheetName(XSSFWorkbook.java:792)
    at
org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getSheetNameByExternSheet(XSSFEvaluationWorkbook.java:137)
    at
org.apache.poi.xssf.usermodel.helpers.XSSFFormulaUtils$1.getSheetNameByExternSheet(XSSFFormulaUtils.java:81)
    at
org.apache.poi.ss.formula.ptg.ExternSheetNameResolver.prependSheetName(ExternSheetNameResolver.java:42)
    at org.apache.poi.ss.formula.ptg.Ref3DPtg.toFormulaString(Ref3DPtg.java:91)
    at
org.apache.poi.ss.formula.FormulaRenderer.toFormulaString(FormulaRenderer.java:92)
    at
org.apache.poi.xssf.usermodel.helpers.XSSFFormulaUtils.updateFormula(XSSFFormulaUtils.java:126)
    at
org.apache.poi.xssf.usermodel.helpers.XSSFFormulaUtils.updateSheetName(XSSFFormulaUtils.java:106)
    at
org.apache.poi.xssf.usermodel.XSSFWorkbook.setSheetName(XSSFWorkbook.java:1177)
    at TestCreateSheet.main(TestCreateSheet.java:33)

Workaround:  At first I was using Workbook.createSheet() without passing a
sheet name argument to it to create my new sheets.  When I switched that to the
form passing in a sheet name this method works.  I recreated this error with
the attached code and by creating a workbook with formulas that span sheets and
are linked.  Sheet2 has a formula that depends on a formula from Sheet7 which
in turn depends on a value on Sheet8.  This error did not occur when I had the
same linked formula situation but on consecutive sheets (Sheet1 to Sheet2 to
Sheet3).  This seems to be similar to Bug 46028.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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