Problem with calculated field in a pivot table

I am having issue with my excel file that has a pivot table with a calculated field where a column whose name starts with a numerical value is used

When aspose encounters this, it save the file as corrupted
Please find the test file attached
Any feedback will be highly appreciated.
Thank you

Hi Chanida,


Thank you for contacting Aspose support.

We have evaluated your presented scenario while using the latest version of Aspose.Cells for .NET 8.2.1.3, and we are able to replicate the problem of “unreadable contents” when resultant file is loaded with MS Excel. Please note, we have tested the case by loading your provided spreadsheet in an instance of Workbook, and re-saved it without any further processing.

Please spare us little time to properly analyze the problem on our end that we have logged as CELLSNET-43064 for further investigation. Once we have isolated the problem cause, we will be in a better position to estimate the schedule for the fix. In the meanwhile, we will keep you posted with updates in this regard.

Hi,

Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.2.1.5 and let us know your feedback.

The fix worked. Thank you so much!

Hi,

Thanks for your feedback.

Good to know that your issue is resolved by the new fix/version. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you.

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


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