Created attachment 191591 [details] Power query XLSX MSO supports Power Query [1]. Example of XLSX with Power Query set is attached, taken from [2]. When such XLSX is resaved in LO, MSO does not recognize query. So it is data loss. If data od query is not changed, LO should keep it so that MSO opens it. https://support.microsoft.com/en-us/office/about-power-query-in-excel-7104fbee-9e62-4cb9-a02e-5bfb1a6c536a https://www.ablebits.com/office-addins-blog/how-to-use-power-query-excel/
As Calc does not have it implemented, it is probably not even imported. But you are right that it would be nice if it was preserved when opening/saving. It seems to me more like a request for enhancement than a bug. +1
Created attachment 192173 [details] xlsx file original (excel) original file with power query on Win10 / Excel.
Created attachment 192174 [details] xlsx file saved in calc xlsx file that saved in calc then opened in excel. Power query is not recognized. There is nothing under the 'Queries & Connections' tab.