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.
When you reopen it, the items filter list is empty, when you click on the filter on the title cell.
When you reopen it, the items filter list must be present and accurate.
User Profile Reset: No
Version: 18.104.22.168 (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
Created attachment 171913 [details]
An example of a saved document with filters.
Version: 22.214.171.124.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
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":
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:
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: 126.96.36.199.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
Created attachment 172632 [details]
video of the bug
Version: 188.8.131.52.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