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

Aspose.Cells Product Family
1

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

2

Hi,

Please try this fix.

3

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

4

Hi,

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

5

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

6

Hi Steve,

We will release it at the end of this week.

7

Great! Thanks

8

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.

9

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

Steve