Hi,
We have recently downloaded the latest version of Aspose.Cells 7.5.0.5 to update our application from using 7.5.0.4. 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 7.5.0.5 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()”.
Hi,
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.