Bug 142231 - Lose of autofilter items list when save and reread a Calc document
Summary: Lose of autofilter items list when save and reread a Calc document
Status: VERIFIED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.5.2 release
Hardware: All All
: medium normal
Assignee: Szabolcs Toth
URL:
Whiteboard: target:7.2.0
Keywords:
Depends on:
Blocks: AutoFilter
  Show dependency treegraph
 
Reported: 2021-05-12 09:03 UTC by Marc ROZIER
Modified: 2021-06-10 09:37 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
An example of a saved document with filters. (10.34 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-05-12 09:11 UTC, Marc ROZIER
Details
The example file after filtering, saving, reloading in 7.2master (58.46 KB, image/png)
2021-05-12 11:55 UTC, NISZ LibreOffice Team
Details
video of the bug (1.49 MB, video/mp4)
2021-06-04 18:56 UTC, BogdanB
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Marc ROZIER 2021-05-12 09:03:16 UTC
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
Comment 1 Marc ROZIER 2021-05-12 09:11:26 UTC
Created attachment 171913 [details]
An example of a saved document with filters.
Comment 2 NISZ LibreOffice Team 2021-05-12 11:51:29 UTC
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
Comment 3 NISZ LibreOffice Team 2021-05-12 11:55:04 UTC
Created attachment 171915 [details]
The example file after filtering, saving, reloading in 7.2master
Comment 4 Commit Notification 2021-05-26 07:12:38 UTC
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.
Comment 5 BogdanB 2021-06-04 18:56:05 UTC
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
Comment 6 BogdanB 2021-06-04 18:56:29 UTC
Created attachment 172632 [details]
video of the bug
Comment 7 NISZ LibreOffice Team 2021-06-10 09:37:11 UTC
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