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.
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
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
This is now fixed by commit b4b3949da1aad091b9f8d0f301f9f7031d6ce295 [log] author Gülşah Köse <gulsah.kose@collabora.com> Thu Nov 14 10:44:47 2024 +0300 committer Szymon Kłos <szymon.klos@collabora.com> Tue Nov 19 05:38:59 2024 +0100 tree bd253ddfe0c8ff3831e511e2874ea0b63cc47cd4 parent 3e9658a201f60dee95bd1bd8421b18bf8905c308 [diff] Fix the wrong detection of hidden autofilter button
Thanks, I was about to check if that commit fixes this bug. :-)
Gülşah Köse committed a patch related to this issue. It has been pushed to "libreoffice-24-8": https://git.libreoffice.org/core/commit/af59826d64a2e2552d4d8c41e5a319da359badac tdf#162992: Fix the wrong detection of hidden autofilter button It will be available in 24.8.4. 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.