IndexOutOfRangeException is thrown on Save() to SpreadsheetML after InsertColumns()

Aspose.Cells Product Family
1

Hi,



Save() throws an exception on a spreadsheet (attached) only after InsertColumns() is being called and the save format is SpreadsheetML.



What is the reason that this exception is being thrown?



var workbook = new Workbook();

workbook.Open(“c:\InsertColumns_InsertManyColumns.xls”,

FileFormatType.Default);



var grid = workbook.Worksheets[0];



grid.Cells.InsertColumns(5, 5);



grid.Workbook.Save(“c:\InsertColumns_InsertManyColumns.xls”, FileFormatType.SpreadsheetML);



======================



System.IndexOutOfRangeException: Index was outside the bounds of the array.



======================



-Steve

2

Hi Steve,

Thanks for providing us the template file.

Yes, we found the issue (as you have described) after an initial test, we will figure it out soon.

Thank you.

3

Hi Steve,

Please try the fix in <A href="https://forum.aspose.com/t/85476</A>.</P> <P>This bug is caused by there are more than 256 columns after inserting columns.We have cleared them if we save it as SpreadML file.</P>

4

This looks good now … thanks!

5

The issues you have found earlier (filed as 6782) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Laurence.