Throw Exception when save pivot table

I create the pivot table with 2 row field, and 2 data fields then add another row field.
I save file by workbook.SaveToStream(), the process throw exception:
System.IndexOutOfRangeException: Index was outside the bounds of the array
Debug, when i add 2 data fields, i see field row automatic create one item, then i add another field row, finally, total is four items.
I realize number of data columns in sheetdata is 3, when i add one more column, exception not throw.
Please consider.


Hi Huynh,

Thank you for reporting this issue to us.

We are able to replicate the IndexOutOfRangeException on our end while using the latest version of Aspose.Cells for .NET 7.6.1 and your provided source code snippet. In order to investigate the said problem in more detail, a ticket has been logged in our bug tracking system under Id CELLSNET-42168. Please spare us little time to properly analyze the problem cause and to provide a fix at earliest. In meanwhile, we will keep you posted with updates.

Please accept our apologies for your inconvenience.



This is to inform you that we have fixed your issue. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.



Please try our latest version/fix: Aspose.Cells for .NET v19.6.1 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells19.6.1 For .Net2_AuthenticodeSigned.Zip (4.9 MB)
Aspose.Cells19.6.1 For .Net4.0.Zip (4.9 MB)


The issues you have found earlier (filed as CELLSNET-42168) have been fixed in Aspose.Cells for .NET v19.7. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi