Hi,
I received the following Exception: caused by:
java.lang.ArrayIndexOutOfBoundsException: -1
at java.util.ArrayList.get(ArrayList.java:324)
at com.aspose.cells.NameCollection.get(Unknown Source)
[...]
at com.aspose.cells.Workbook.save(Unknown Source)
We are attempting to write a large .xlsx file with many formulas. I tracked the root cause of the problem to the fact that I tracked the root cause of the problem to be that there are too many Names being added to the spreadsheet (>256*256).
However we are not trying to create that many Names since all our formulas only contain basic cell references using CellsHelper.cellIndexToName().
The problem is that any Cell references that reference a column after column 255 that are included in formulas get added to the spreadsheet as names. Please see the attached code to reproduce.
We are using the latest version of Aspose Cells (7.3.2.0).
Thanks for your help in this matter.
Simon Kelly
Agentrics UK ltd