Hello,
Hi,
Thanks for your posting and using Aspose.Cells.
Please download and try the latest version: Aspose.Cells
for .NET v8.4.1.2 and see if it makes any difference and fixes this issue.
If your issue still occurs, then please provide us your sample code and source excel file that we could use to replicate this issue at our end. We will look into it and help you asap.
Unfortunately, the issue persists along with the issue posted here:
Hi Nate,
Sorry about that. I’ve included each item separately, though the main program has had extension changed to .txt to ensure I could upload it here.
Thanks again for the help!
Hi,
Thanks for your posting and using Aspose.Cells.
We were able to observe this exception after executing your sample code with your source excel file using the latest version: Aspose.Cells
for .NET v8.4.1.3. Refreshing the pivot table causes invalid string cast exception as you mentioned.
We have logged this issue in our database for investigation. We will look into it and fix 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-43629 - PivotTable.RefreshData() - Unable to cast object of type ‘System.DateTime’ to type ‘System.String’
Great! Thank You.
Hi,
Thanks for your posting and using Aspose.Cells.
Please submit your post, code and files in that thread i.e
( Chart.RefreshPivotData() - Incorrect Labels/Legend )
The code which you have submitted in this thread generates the exception, please submit the code that we could run successfully and replicate the issue in that thread.
Thank for your cooperation.
The issues you have found earlier (filed as CELLSNET-43629) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by Aspose Notifier.