You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2008/11/30 00:39:23 UTC
DO NOT REPLY [Bug 46312] New: Specified rowIndex 30 is outside the
allowable range (0..30)
https://issues.apache.org/bugzilla/show_bug.cgi?id=46312
Summary: Specified rowIndex 30 is outside the allowable range
(0..30)
Product: POI
Version: 3.2-FINAL
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: blocker
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: emilio.dolce@gmail.com
Created an attachment (id=22964)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=22964)
excel template I start on
Trying to create an outlined excel spreadsheet I got the following exception.
With the 3.1-FINAL everything work fine.
Consider that:
1) I start from an existing template (attached);
2) I need to report sum on top, then I used sheet.setRowSumsBelow(false) and
sheet.setAlternativeExpression(false), but, by comment those lines the problem
still occurs.
Caused by: java.lang.IllegalArgumentException: Specified rowIndex 30 is outside
the allowable range (0..30)
at
org.apache.poi.hssf.record.aggregates.ValueRecordsAggregate.removeAllCellsValuesForRow(ValueRecordsAggregate.java:111)
at
org.apache.poi.hssf.record.aggregates.RowRecordsAggregate.removeRow(RowRecordsAggregate.java:120)
at org.apache.poi.hssf.model.Sheet.addRow(Sheet.java:677)
at org.apache.poi.hssf.usermodel.HSSFSheet.addRow(HSSFSheet.java:303)
at
org.apache.poi.hssf.usermodel.HSSFSheet.createRow(HSSFSheet.java:206)
at
it.mef.scai.shared.poiutils.ExcelUtil.inserisciValore(ExcelUtil.java:393)
at
it.mef.scai.paf.service.printexport.impl.GestioneFabbisogniExcelRenderServiceImpl.renderElement(GestioneFabbisogniExcelRenderServiceImpl.java:116)
at
it.mef.scai.paf.service.printexport.impl.GestioneFabbisogniExcelRenderServiceImpl.renderElement(GestioneFabbisogniExcelRenderServiceImpl.java:133)
at
it.mef.scai.paf.service.printexport.impl.GestioneFabbisogniExcelRenderServiceImpl.renderElement(GestioneFabbisogniExcelRenderServiceImpl.java:133)
at
it.mef.scai.paf.service.printexport.impl.GestioneFabbisogniExcelRenderServiceImpl.renderElement(GestioneFabbisogniExcelRenderServiceImpl.java:133)
at
it.mef.scai.paf.service.printexport.impl.GestioneFabbisogniExcelRenderServiceImpl.renderElement(GestioneFabbisogniExcelRenderServiceImpl.java:133)
at
it.mef.scai.paf.service.printexport.impl.ExcelTreeViewRenderServiceImpl.renderExcelTreeView(ExcelTreeViewRenderServiceImpl.java:58)
... 78 more
--
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
DO NOT REPLY [Bug 46312] Specified rowIndex 30 is outside the
allowable range (0..30)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46312
--- Comment #3 from zzy9v4 <em...@gmail.com> 2008-11-29 15:42:45 PST ---
Created an attachment (id=22967)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=22967)
General purpose utilities.
--
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
DO NOT REPLY [Bug 46312] Specified rowIndex 30 is outside the
allowable range (0..30)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46312
--- Comment #1 from zzy9v4 <em...@gmail.com> 2008-11-29 15:40:41 PST ---
Created an attachment (id=22965)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=22965)
abstract base excel render service impl
--
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
DO NOT REPLY [Bug 46312] Specified rowIndex 30 is outside the
allowable range (0..30)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46312
--- Comment #2 from zzy9v4 <em...@gmail.com> 2008-11-29 15:41:12 PST ---
Created an attachment (id=22966)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=22966)
concrete excel export class
--
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
DO NOT REPLY [Bug 46312] Specified rowIndex 30 is outside the
allowable range (0..30)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46312
Josh Micich <jo...@gildedtree.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #4 from Josh Micich <jo...@gildedtree.com> 2008-12-01 12:06:10 PST ---
Fixed in svn r722206 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=722206 ).
Next time can you try to simplify your example code that you upload. This bug
can actually be shown with just 4 lines of code:
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet();
HSSFRow row = sheet.createRow(30);
row = sheet.createRow(30); // << throws IllegalArgumentException
--
Adding a cell to the row before the second call to createRow() makes the bug go
away. So your code must have been creating rows multiple times before adding
cells. In any case, POI supports this usage now.
--
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