Hi,
I am converting the attached XLS file into XLSM format, after conversion the XLSM file is removing the external link which is present for the pivot table.
This link is present at “\xl\pivotCache_rels” path
Could you please do the needful to address this issue.
TemplateFile-PivotTable-ExternalLink-Deleted.zip (15.3 KB)
Thanks for the template XLS file.
I did evaluate your issue a bit. Could you please share some screenshots to compare source (xml) data of input XLS file with output XLSM file @ "\xl\pivotCache_rels” path. This will help us evaluate your issue precisely on our end so we could log it appropriate ticket for it.
Hi Amjad,
Thanks for the quick reply.
As it is xls (binary) file I have converted it into xlsm using MS Excel and verified for the source xml file. I have attached the same xml file here.
But when using Aspose to convert this xls file into xlsm, this external link is not present.
pivotCacheDefinition-XML.zip (31.2 KB)
Thanks for the sample files.
I noticed the issue as you mentioned by converting your template XLS to XLSM file format. I found after conversion, the XLSM file is removing the external link which is present for the pivot table:
e.g.
Sample code:
Workbook workbook = new Workbook("e:\\test2\\TemplateFile-PivotTable-ExternalLink-Deleted.xls");
workbook.Save("e:\\test2\\out1.xlsm", Aspose.Cells.SaveFormat.Xlsm);
I have logged a ticket with an id “CELLSNET-51419” for your issue. We will look into it soon.
Once we have an update on it, we will let you know.
This is to inform you that your issue has been resolved now. The fix will be included in our upcoming release (Aspose.Cells v22.10) which is scheduled in the second week of October 2022. You will also be notified when the next version is released.
The issues you have found earlier (filed as CELLSNET-51419) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi