Free Support Forum - aspose.com

ArrayIndexOutOfBoundsException when saving an Excel file using Aspose.Cells for Java

I have a sheet with 61 rows and 256 columns. The first row contains the column heading and the first column contains time.

I am trying to create a chart using the last 255 columns as individual data series. I get the following error when I call workbook.save. (I actually have 4995 columns of available data but due to the Excel limit I can only use 255)

java.lang.ArrayIndexOutOfBoundsException: 8228

I am use the following call:

workbook.save(out, fileFormatType);

Out is a filename and the type is Excel.

After some experimenting I found I can chart up to 101 series but if I try 102 or higher I get the ArrayIndexOutOfBoundsException error.

Steve

Hi,

Please try this fix.

Hi Warren,

I got the same results as before. ArrayIndexOutOfBoundsException if I try to create a graph with more than 100 data series. (101 columns which includes the first column being time which is charted along X-axis.)

I have attached basic code I am using to create graph.

Steve

Hi,

Please try this fix. If the error still occurs, please send your file to nanjing@aspose.com

Thanks Warren,

That worked great!!

Do you have a date for next release with this fix? We will be starting QA work soon for our release and I would like to use an actual released version.

Steve

Hi Steve,

We will release it at the end of this week.

Great! Thanks

Hi Steve,

Sorry!

We find a bug in saving pivot tables and it will take us a week to fix it.So we have to delay to release new version . We will release new version at the next week.

This fix includes all the fixes since 1.7.3.0,so it is very similar to the next release version.You can use this fix to continue your work.

Thanks Warren for letting me know. Next week should be fine.

Steve