The value of an autofiltered column cleared from standard filter when scrolling.
See consistent reproducibility steps and video demonstration.
The issue was produced on both Ubuntu 20.04 and Debian testing with TDF 22.214.171.124 debs.
Steps to Reproduce:
1. Create a spreadsheet with a column of data.
2. Apply autofiltering to the column.
3. Select "standard filter..." from the filter menu.
4. Add a condition (e.g. "Number = 1").
5. Click OK. Data will be filtered as expected.
6. Close the spreadsheet.
7. Open the spreadsheet again.
8. Select "standard filter..." from the filter menu.
9. Scroll down and up again in the filter dialog.
Field cleared on scroll.
Field should not be cleared on scroll.
User Profile Reset: No
Happens in the 126.96.36.199 debs downloaded from TDF's site.
The user that found this issue has also reproduced the issue with git commit 058caeef45f9abf12e4e243aafbbb1c2ebcbc057, which is 188.8.131.52.alpha0+
The original launchpad bug: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1881811
Created attachment 161621 [details]
Video showing the reproducer steps and failure
This problem did not exist in 3.3.0 (tested on Windows).
In 3.5 and 3.6, you don't even have to scroll - the field is blank upon opening the dialog. The current behaviour started with 4.0
I bibisected the change in behaviour with the Linux 43all repository to the range https://git.libreoffice.org/core/+log/d59024b652ccfaf7247da113ec36788fe260de74..4b4ca8030285bd66526ff5bb2b6ea5a75a6c6bc7
The problem seems to be in the document structure somehow: if I open a filter created with 3.3.0 in 3.5.0, I can see the value in the dialog no matter what I do.
This seems to have been fixed in 7.1 since:
author Martin van Zijl <email@example.com> Wed May 27 08:21:39 2020 +1200
committer Heiko Tietze <firstname.lastname@example.org> Tue Sep 15 08:40:04 2020 +0200
tdf#76898 standard filter: add buttons to remove conditions
it's ok in
Version: 184.108.40.206.alpha1+ (x64) / LibreOffice Community
Build ID: 3b57ebb445df8a2bc3d916ea79f8af45e20e4e62
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: ro-RO (ro_RO); UI: en-US