We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Converting XLS to XLSM is changing the "Save password" data connection definition property

Hi,
The “Save password” checkbox property of data connection definition is getting unchecked when an XLS workbook is converted to XLSM.
I have attached the template file and the screenshots below.
Please do the needful.
DataConnection-SavePasswordIssue.zip (46.9 KB)

@vedavyas.velaga,

Thanks for the template file and screenshots.

Please notice, I am able to reproduce the issue as you mentioned by converting your template XLS file to XLSM file format. I found the “Save password” checkbox property of data connection definition is getting unchecked when the XLS workbook is converted to XLSM.
e.g.
Sample code:

Workbook workbook = new Workbook("e:\\test2\\DataConnection-SavePasswordIssue.xls"); 
workbook.Save("e:\\test2\\out1.xlsm", SaveFormat.Xlsm);

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

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

@vedavyas.velaga,

We are pleased to inform you that the issue has been resolved. This fix will be included in the next official release (Aspose.Cells v22.8), which will be released 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-51696) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi