We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Some of the files we are generating through Aspose.Cells are erroring after updating to


We have recently downloaded the latest version of Aspose.Cells to update our application from using This updated has fixed our issue with sorting tables with Array formulas, however we are no having issue with creating excel files with pivot tables (not all files with pivot tables). We are getting an “Index was out of range. Must be non-negative and less than the size of the collection. Parameter: index” error when refreshing the pivot table and the step to create the file fails.

I have attached a small application that uses Aspose.Cells to demonstrate the issue. The project’s code simply opens a workbook for the “input file input for pivot table issue with dates.xlsx”, followed by refreshing the pivot tables before finally saving the workbook as a pdf and xlsx files called “generated file”.

The error occurs during the call on “PivotTable.CalculateData()”.


Thanks for your posting and using Aspose.Cells for .NET.

We were able to observe the exception generated by your code with the source file. We have logged this issue in our database. We will look into it and resolve this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-41823.

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

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.