Converting a xlsb file with DDE link to xlsm file is changing the DDE application position in link

Aspose.Cells Product Family
1

Hi,
I tried to convert an XLSB file into XLSM file where as the file contains a DDE link.
The DDE link in XLSB is “=Excel|[TP_UDA_SourceDDE.xlsx]Sheet1!‘R3C’” but on converting this into XLSM it is changing to “=[TP_UDA_SourceDDE.xlsx]Sheet1|Excel!‘R3C’”
Could you please help me in understanding the reason for this change.
Attached a sample file.
DDELink_TestFile.zip (14.8 KB)

2

@vedavyas.velaga,

Please notice, I am able to reproduce the issue as you mentioned by saving your XLSB file as XLSM file format. I found by converting the XLSB file with DDE link to XLSM file is changing the DDE application position in link
e.g.
Sample code:

Workbook workbook = new Workbook("e:\\test2\\DDELink_TestFile.xlsb");
workbook.Save("e:\\test2\\out1.xlsm", Aspose.Cells.SaveFormat.Xlsm);

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

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

3

@vedavyas.velaga,

This is to inform you that your issue has been resolved. The fix will be included in the next release (Aspose.Cells for .NET v22.7) which is scheduled in the second week of July 2022. You will also be notified when the next version is released.

4

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