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.
164290: (WIP) tdf#158857: Keep Power Query when saving XLSX | https://gerrit.libreoffice.org/c/core/+/164290
Bayram Çiçek committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/045ebdb369ab21a3be7a32dc1c85ad2243eb9129 tdf#158857: [Power Query] export connections.xml It will be available in 25.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Bayram Çiçek committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/f91d74da5571b877126f4f753c4134054fa606bb tdf#158857: [Power Query] export xl/drawings/drawing*.xml It will be available in 25.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Created attachment 200695 [details] LO retains connections.xml but modified (In reply to Commit Notification from comment #5) > Bayram Çiçek committed a patch related to this issue. > It has been pushed to "master": > > https://git.libreoffice.org/core/commit/ > 045ebdb369ab21a3be7a32dc1c85ad2243eb9129 > > tdf#158857: [Power Query] export connections.xml > > It will be available in 25.2.0. Confimr, now LO handles (saves) connections.xml Verified in: Version: 25.2.3.2 (X86_64) / LibreOffice Community Build ID: bbb074479178df812d175f709636b368952c2ce3 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win Locale: pl-PL (pl_PL); UI: en-US Calc: CL threaded But is this "a right behavior" to modify content of this file, since as now LibreOffice does not have any Pover Query equivalent?
Created attachment 200696 [details] LO don't handle 'queryTable*.xml' Follow-up: LO can't handle /xl/queryTables/queryTable1.xml ... files. This folder is not saved into OOXML. Checked in: Version: 25.2.3.2 (X86_64) / LibreOffice Community Build ID: bbb074479178df812d175f709636b368952c2ce3 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win Locale: pl-PL (pl_PL); UI: en-US Calc: CL threaded Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: ba521b1d33f629fb448086a3ac052d8a633d6cbf CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: pl-PL (pl_PL); UI: en-US Calc: CL threaded
Created attachment 200697 [details] XLSX examples, 'connections.xml' and 'queryTables' Source files relating to situations in: comment 7 and comment 8