An example: 1. Start with an empty spreadsheet. 2. In column A, enter the following on the first few rows: MyHeader A B C A A C B 3. Select column A and click Data→AutoFilter 4. Click the auto-filter drop-down. 5. Tick or untick as follows, then click OK: ☒ (empty) ☒ A ☐ B ☒ C 6. All rows in which the column A cell contains B are hidden. 7. Enter B somewhere in the A column, at one or more rows. 8. Click the autofilter drop-down again. All selections are already what we want, so just click OK. 9. Nothing changed. Expected result (at step 9): The same as in step 6. One workaround is to just select something else, hit OK, then click the drop-down and do step 5 again, but that's annoying if you have to do it often. I think this bug has always been there, but I'm not sure. I run LibreOffice 6.4.4.2 on Manjaro Linux 20.0.3 at home and a slightly older version of LibreOffice on Windows 10 at work, not sure exactly which one (and I can't check since I'm on vacation, but it's 6.4.something). Both have the same problem.
I have found that if you follow steps 1 through 8 and a cell is left empty between the original entries and extra entries, then a bug occurs, ie. step 9 I can confirm that this is present in the following builds: Version: 6.4.5.2 (x64) Build ID: a726b36747cf2001e06b58ad5db1aa3a9a1872d6 CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: GL; VCL: win; Locale: en-AU (en_US); UI-Language: en-GB Calc: CL Version: 7.1.0.0.alpha0+ (x64) Build ID: <buildversion> CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win Locale: en-AU (en_US); UI: en-GB Calc: CL However, if the cell is not left empty between entries, then this WORKSFORME
I actually realized that while it doesn't work for rows placed after the initial set, it does work with the ones between the initial set's contents. I'm using version 7.1.0.0, so I have no idea if this works for any other version. As SteveDee says, it varies: it WORKSFORME in some areas but the error is still there in others
Of course this isn't assuming it doesn't work in other columns. We need extra testing if that's the case
Repro. Let's assume that we want the empty row taken into account. Arch Linux 64-bit Version: 7.2.0.0.alpha0+ / LibreOffice Community Build ID: dec32864a61104001cb6ff63c218ea5fb2a7ab1e CPU threads: 8; OS: Linux 5.10; UI render: default; VCL: kf5 Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 22 February 2021
Dear Johnny Rosenberg, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
It seems to work better now, but if I, in my example, add one or more B at least two rows below the rest of the used rows, those are not hidden by the AutoFilter, so it seems like even if I selected the whole column before creating the AutoFilter, it doesn't care about the rows below the first empty row after the last entry. So as I said, it works better now, but I'm not sure if I would say it works perfectly. I guess running into the problem now is much less likely now than before, at least.