You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by bmekewar <b_...@yahoo.com> on 2011/02/10 08:14:13 UTC

java.lang.ArrayIndexOutOfBoundsException: -32718 with autoSizeColumn(int) method

java.lang.ArrayIndexOutOfBoundsException: -32718
	at java.util.ArrayList.get(Unknown Source)
	at
org.apache.poi.hssf.model.WorkbookRecordList.get(WorkbookRecordList.java:50)
	at
org.apache.poi.hssf.model.InternalWorkbook.getExFormatAt(InternalWorkbook.java:826)
	at org.apache.poi.hssf.usermodel.HSSFCell.getCellStyle(HSSFCell.java:923)
	at
org.apache.poi.hssf.usermodel.HSSFSheet.autoSizeColumn(HSSFSheet.java:1793)
	at
org.apache.poi.hssf.usermodel.HSSFSheet.autoSizeColumn(HSSFSheet.java:1727)
	at com.crpm.excelreport.ExcelReport.generateReport(ExcelReport.java:113)
...

I am getting the above exception for 1000 rows with 8 columns on
autoSizeColumn
since MS Excel size supports 65536 rows and 257 columns 
why formating in not happening on lesse records.

Why cant Apcahe POI provide methods for long range with
autoSizeColumn(long)?

Please help me to resolve this issue ...
-- 
View this message in context: http://apache-poi.1045710.n5.nabble.com/java-lang-ArrayIndexOutOfBoundsException-32718-with-autoSizeColumn-int-method-tp3378861p3378861.html
Sent from the POI - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Re: java.lang.ArrayIndexOutOfBoundsException: -32718 with autoSizeColumn(int) method

Posted by Nick Burch <ni...@alfresco.com>.
On Wed, 9 Feb 2011, bmekewar wrote:
> java.lang.ArrayIndexOutOfBoundsException: -32718
> 	at java.util.ArrayList.get(Unknown Source)
>
> I am getting the above exception for 1000 rows with 8 columns on 
> autoSizeColumn since MS Excel size supports 65536 rows and 257 columns 
> why formating in not happening on lesse records.

What version of POI are you using? I know that there have been some fixes 
in the not too distant past to the autosize, so if you've not tried a 
recent svn nightly build / checkout then you probably ought to

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org