Description: 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 6.4.4.2 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. Actual Results: Field cleared on scroll. Expected Results: Field should not be cleared on scroll. Reproducible: Always User Profile Reset: No Additional Info: Happens in the 6.4.4.2 debs downloaded from TDF's site. The user that found this issue has also reproduced the issue with git commit 058caeef45f9abf12e4e243aafbbb1c2ebcbc057, which is 7.1.0.0.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: https://git.libreoffice.org/core/+/937b780e3f696552fc686bf0c80c3050443b111a author Martin van Zijl <martin.vanzijl@gmail.com> Wed May 27 08:21:39 2020 +1200 committer Heiko Tietze <heiko.tietze@documentfoundation.org> Tue Sep 15 08:40:04 2020 +0200 tdf#76898 standard filter: add buttons to remove conditions
it's ok in Version: 7.2.0.0.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 Calc: threaded