Bug 158857 - Keep Power Query when saving XLSX
Summary: Keep Power Query when saving XLSX
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.0.0 alpha0+
Hardware: All All
: medium normal
Assignee: Bayram Çiçek
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: Cell-Formula
  Show dependency treegraph
 
Reported: 2023-12-25 15:10 UTC by Timur
Modified: 2024-06-13 18:03 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Power query XLSX (118.73 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2023-12-25 15:10 UTC, Timur
Details
xlsx file original (excel) (447.71 KB, image/png)
2024-01-25 23:26 UTC, Bayram Çiçek
Details
xlsx file saved in calc (454.63 KB, image/png)
2024-01-25 23:33 UTC, Bayram Çiçek
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Timur 2023-12-25 15:10:21 UTC
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/
Comment 1 m_a_riosv 2023-12-25 17:35:10 UTC
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
Comment 2 Bayram Çiçek 2024-01-25 23:26:15 UTC
Created attachment 192173 [details]
xlsx file original (excel)

original file with power query on Win10 / Excel.
Comment 3 Bayram Çiçek 2024-01-25 23:33:20 UTC
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.
Comment 4 Bayram Çiçek 2024-06-06 10:36:17 UTC
164290: (WIP) tdf#158857: Keep Power Query when saving XLSX | https://gerrit.libreoffice.org/c/core/+/164290