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: [email protected]
ReportedBy: [email protected]
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: [email protected]
For additional commands, e-mail: [email protected]
