Description: When you set an autofilter in a 2 columns data document (with date and text), then you filter it, save it and close it. When you reopen it, the filters are applied correctly, but the items filter list used to filter again is empty. You can filter it again, the items filter list reappears. Steps to Reproduce: 1. Create a two columns data document. 2. Fill a title and 2 kinds of text in the first column A (ie. "Calc" and "Writer") randomly on 10 lines for instance. 3. Fill a title and 2 kinds of date in the second column B (ie. the today date and yesterday date) randomly on 10 lines for instance. 4. Set an autofilter on the title 5. Filter on column B on one specific date, then on column A on one specific text. 5. Save and close the document in a classic ODS document. 6. Re-open that saved document. Actual Results: When you reopen it, the items filter list is empty, when you click on the filter on the title cell. Expected Results: When you reopen it, the items filter list must be present and accurate. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.0.5.2 (x64) Build ID: 64390860c6cd0aca4beafafcfd84613dd9dfb63a CPU threads: 4; OS: Windows 10.0 Build 15063; UI render: Skia/Raster; VCL: win Locale: fr-FR (fr_FR); Langue IHM : fr-FR Calc: threaded
Created attachment 171913 [details] An example of a saved document with filters.
Confirming with Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 5d7251c7121cee8885fa9f2387c4a0625dd4ecee CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL
Created attachment 171915 [details] The example file after filtering, saving, reloading in 7.2master
Szabolcs Toth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/f2c9da1ef662d10726a2dc709b46722ec7d4a016 tdf#142231 sc odf: fix export of single date filter value It will be available in 7.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.
i think is not working well yet. See my video. I open the file, close it. And in the video I reopen it and you can see the info are not checked. Version: 7.2.0.0.alpha1+ / LibreOffice Community Build ID: e96554b67b17f9d3d91b0bb1f29ab0b9cdc43dcb CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
Created attachment 172632 [details] video of the bug
Verified in: Version: 7.2.0.0.alpha1+ (x64) / LibreOffice Community Build ID: aa9cb8e14749e7fb7a83b55a2bb095501f731a18 CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: default; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: threaded