Bug 162992 - FILESAVE : Cell filtering (list) not saved in XLSX format
Summary: FILESAVE : Cell filtering (list) not saved in XLSX format
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.0.3 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, filter:xlsx, regression
Depends on:
Blocks: XLSX-Autofilter
  Show dependency treegraph
 
Reported: 2024-09-16 12:40 UTC by Hurri39
Modified: 2024-09-22 14:51 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Calc spreasheet with List selection (15.25 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-09-16 12:40 UTC, Hurri39
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Hurri39 2024-09-16 12:40:16 UTC
Created attachment 196477 [details]
Calc spreasheet with List selection

Tested on MacOS 10.15.7 (19H2026) with LO 24.2.6 and LO 24.8.1.2 
And on Windows 10 with LO 7.6.2.1

See example.
If using ODS format, selection List is saved, and correctly opened. You can open the combo and filter lines with selected values.
If saving the same calc document in XLSX format, selection List is lost. The combo won't display again.
Comment 1 m_a_riosv 2024-09-16 21:16:26 UTC
Show the filter active is missing, but activating it again shows the saved selection. The same happens opening with Excel.

Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 47a348bb0fd6dfdd93c1975d216daadc4f6b9b6f
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded


Latest version that works on the ones I have installed.
Version: 6.4.7.2 (x64)
Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: GL; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US
Calc: CL
Comment 2 raal 2024-09-17 19:41:03 UTC
This seems to have begun at the below commit in bibisect repository/OS linux-64-7.5$.
Adding Cc: to Paris Oplopoios ; Could you possibly take a look at this one?
Thanks
 b0e85697690d29d8c5cffbc2abff364f5c6de0c7 is the first bad commit
commit b0e85697690d29d8c5cffbc2abff364f5c6de0c7
Author: Jenkins Build User <tdf@pollux.tdf>
Date:   Thu Dec 1 13:13:59 2022 +0100

    source 2942fdc8dbda375622d0add8c36df2d6679e321a


143300: tdf#144786 Implement XML_hiddenButton functionality | https://gerrit.libreoffice.org/c/core/+/143300