I am trying to convert the attached XLS file to XLSM using Aspose.Cells.
This file is having 1 query and 1 connection, In the converted file the connection details like Connection String, Description, Command text etc all are getting swapped.
I.e. the connection details are showing for the query and query details are showing in connection.
This we can see in Query Properties and Connection Properties dialog.
Please do the needful.
WrongConnectionInfo.zip (104.7 KB)
Thanks for the template file.
Please notice, I am able to reproduce the issue as you mentioned by converting your template XLS file to XLSM file format. I found connection detail is getting changed when converting XLS file to XLSM. I have logged a ticket with an id “CELLSNET-51772” 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 (logged earlier as “CELLSNET-51772”) has been resolved. The fix will be included in our upcoming release (Aspose.Cells v22.9) scheduled in the second week of September 2022. You will also be notified when the next version is released.
The issues you have found earlier (filed as CELLSNET-51772) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi