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

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. 

---

Amjad Sahi
Support Developer,
Aspose Nanjing Team
Contact Us

Hi Steve,

Please try the fix in http://www.aspose.com/community/forums/thread/147363/insertcolumns-does-not-update-named-ranges.aspx.

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.

---

Simon Zhao
Developer
Aspose Nanjing Team
Contact Us

This looks good now .. thanks!