I have observed that when I am converting any XLS file which is having link of type xlAlternateStartup to XLSM, the output XLSM file is corrupted.
When I checked the links files in “\xl\externalLinks_rels” path, It is observed that link relationship type is “http://schemas.microsoft.com/office/2006/relationships/xlExternalLinkPath/xlAltStartup” where as ideally it should be “http://schemas.microsoft.com/office/2006/relationships/xlExternalLinkPath/xlAlternateStartup”.
If I convert the XLS to XLSM using MS Excel, the relationship type is having “xlAlternateStartup” as expected.
I am attaching two sample files below for your reference.
Please do the needful.
TemplateFileWithStartupLinks.zip (47.8 KB)
TemplateSourceFileWithxlAlternateStartupLink.zip (84.1 KB)
Thanks for the template files.
Please notice, I am able to reproduce the issue as you mentioned by converting your template files to XLSM file format. I found the files got corrupted when converting XLS file with xlAlternateStartup type link to XLSM:
Workbook workbook = new Workbook("e:\\test2\\TemplateFileWithStartupLinks.xls"); //Workbook workbook = new Workbook("e:\\test2\\TemplateSourceFileWithxlAlternateStartupLink.xls"); workbook.Save("e:\\test2\\out1.xlsm", Aspose.Cells.SaveFormat.Xlsm);
I have logged a ticket with an id “CELLSNET-51558” 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 the next release (Aspose.Cells v22.8) which is scheduled in the second week of August 2022. You will also be notified when the next version is released.
The issues you have found earlier (filed as CELLSNET-51558) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi