File got corrupted and External Link changed to DDE link when converting a XLS file to XLSM

Aspose.Cells Product Family
1

Hi,
I am trying to convert the attached xls file to XLSM,

  1. The converted XLSM file is corrupted.
  2. When inspected the xlsm file at “\xl\externalLinks\externalLink1.xml” the link is showing as DDE link, where as it is actually a normal link to other excel file (we can see it by opening the file using Excel)

Template-FileCorruption-ExternalLinkChangedToDDE.zip (8.6 KB)

Edit-1:
Attaching another file below, which is also got corrupted and few links got deleted and few are changed to DDE.
FileCorruptedLinksGotDeletedAndChanged.zip (8.8 KB)

2

@vedavyas.velaga,

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 and external link changed to DDE link when converting XLS files to XLSM:
e.g.
Sample code:

//Workbook workbook = new Workbook("e:\\test2\\Template-FileCorruption-ExternalLinkChangedToDDE.xls");
Workbook workbook = new Workbook("e:\\test2\\FileCorruptedLinksGotDeletedAndChanged.xls");
workbook.Save("e:\\test2\\out1.xlsm", Aspose.Cells.SaveFormat.Xlsm);

I have logged a ticket with an id “CELLSNET-51551” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

3

@vedavyas.velaga
The template file is Excel 95/5.0 file.The records of the external link are not clear for us and they are different from Excel 97-2003. We can not fix it soon, please resave it as Excel 97-2003 or advance version now.

4

@vedavyas.velaga,

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.

5

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