XmlImport corrupts file when trying to refresh Pivot Tables with calculated column

Aspose.Cells Product Family
1

I am importing xml into a template spreadsheet with an xml map. The template spreadsheet includes a pivot table with a calculated column added.

When I import xml with Aspose the spreadsheet becomes corrupted and the pivot table structure is lost.

Please refer to the uploaded sample application. There is a data folder containing a template.xlsx and the xml.xml file to be imported.
PoseyPivot.zip (60.2 KB)

2

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-52671

You can obtain Paid Support services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-52675

You can obtain Paid Support services if you need support on a priority basis, along with the direct access to our Paid Support management team.

4

@mackers78
dest.zip (26.5 KB)
Please check the result generated by inner hot fix.
Both issues are fixed.

5

The results look good. :+1:

6

@mackers78,

Thanks for your feedback.

The fix will be included in our upcoming release (Aspose.Cells v23.2) which is scheduled in the second week of February 2023. You will be notified once the next release is published.

7

The issues you have found earlier (filed as CELLSNET-52671,CELLSNET-52675) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi