Created attachment 113589 [details] Two sheets - single column autofilter and two columns autofilter Two column autofilter works as expected, when selected "Not empty". Single column autofilter with "Not empty" *seems* to filter away only the empty cells *before* the first non-empty cell. Added an attachment that demonstrates behaviour.
Hi @Teraslilja, thanks for reporting. Redoing the one column autofilter, seems to work better, "empty" selection works now, but in any case the last empty cell is showed with "no-empty" selection.
** Please read this message in its entirety before responding ** 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 on a currently supported version of LibreOffice (5.0.5 or 5.1.2 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System 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) http://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: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2016-04-16
Bug still occurs in a slightly changed form at least on LibreOffice 5.2.1.2 (x64), Build ID: 31dd62db80d4e60af04904455ec9c9219178d620, OS: Windows 7 64-bit. Two column AutoFilter works as expected, single column AutoFilter doesn't. Behaviour has changed from previously described behaviour. Currently "Single-Column-AutoFilter-BAD"-tab after opening file and clicking on Label-field's AutoFilter-box and in it on "Not Empty": # Label 3 A 4 B 6 C 8 X 10 0 11 12 1 13 So rows with #-value of 1, 2, 5, 7 and 9 were correctly filtered away having empty Label-value but rows 11 and 13 were incorrectly left unfiltered. If I redo the one column AutoFilter (i.e. remove it completely, add it back and select "Not Empty" in it) then I get the same behaviour as m.a.riosv on 2015-02-22 01:12:39 UTC i.e. all but the last empty field is filtered correctly, resulting in: # Label 3 A 4 B 6 C 8 X 10 0 12 1 13
Bug doesn't occur on LibreOffice 3.3.0 / OOO330m19 (Build:6) / tag libreoffice-3.3.0.4 on Windows 7 64-bit. I installed the old version from http://downloadarchive.documentfoundation.org/libreoffice/old/3.3.0.4/win/x86/BrOffice_3.3.0_Win_x86_install_all_lang.exe Because bug didn't occur on LibreOffice 3.3 I added "regression" to the keywords.
I can reproduce it in Version: 4.2.0.0.alpha1+ Build ID: fc8f44e82de4ebdd50ac5fbb9207cd1a59a927e3 Thus, it can't be bibisected with bibisect-43max
At least with the test file everything works ok. 302 <table:database-ranges> 303 <table:database-range table:name="__Anonymous_Sheet_DB__0" table:target-range-address="'Multi-Column-AutoFilter-Ok'.C4:'Multi-Column-AutoFilter-Ok'.D17" table:display-filter-buttons="true"/> 304 <table:database-range table:name="__Anonymous_Sheet_DB__1" table:target-range-address="'Single-Column-AutoFilter-BAD'.D4:'Single-Column-AutoFilter-BAD'.D14" table:display-filter-buttons="true"/> 305 </table:database-ranges> So the autofilter range on the "BAD" sheet only covers the range until D14. ANd that part seems to work fine with the "Not empty" flag.
(In reply to Markus Mohrhard from comment #6) > At least with the test file everything works ok. > > So the autofilter range on the "BAD" sheet only covers the range until D14. > ANd that part seems to work fine with the "Not empty" flag. Ah, so that explains part of this bug. But what about the part where the filtering doesn't work even after redoing the autofilter completely from scratch so that its range does encompass all the rows? (Mentioned in comments 1 and 3) That results in this erroneous output: # Label 3 A 4 B 6 C 8 X 10 0 12 1 13
Created attachment 127987 [details] Two sheets - single column autofilter and two columns autofilter, now with correct filter ranges. The same as the "113589: Two sheets - single column autofilter and two columns autofilter"-attachment but with the AutoFilter range of the second sheet corrected (i.e. D4-D17 now) and saved using LibreOffice 5.2.1.2 (x64), Build ID: 31dd62db80d4e60af04904455ec9c9219178d620 on Windows 7 64-bit.
(In reply to Kari Salminen from comment #8) > Created attachment 127987 [details] > Two sheets - single column autofilter and two columns autofilter, now with > correct filter ranges. > > The same as the "113589: Two sheets - single column autofilter and two > columns autofilter"-attachment but with the AutoFilter range of the second > sheet corrected (i.e. D4-D17 now) and saved using LibreOffice 5.2.1.2 (x64), > Build ID: 31dd62db80d4e60af04904455ec9c9219178d620 on Windows 7 64-bit. Now opening the attachment and clicking on the second sheet's AutoFilter and selecting "Not Empty" results erroneously in: # Label 3 A 4 B 6 C 8 X 10 0 12 1 13 And I'm using LibreOffice 5.2.1.2 (x64), Build ID: 31dd62db80d4e60af04904455ec9c9219178d620 on Windows 7 64-bit. Thus I'm changing this back to the status this bug was before (i.e. NEW) this got closed as RESOLVED / WORKSFORME (Hopefully I'm not treading on any etiquette here by doing this. If I am then please correct the bug status as is appropriate, thank you).
Maybe resolved as fixed by mistake. I can reproduce the issue with the last row (empty) selected with 'Not Empty', on the sample file. Version: 5.4.0.0.alpha0+ Build ID: 5a345f714f67594bb9e3f8914e89975a937872cf CPU threads: 4; OS: Windows 6.19; UI render: GL; TinderBox: Win-x86@42, Branch:master, Time: 2017-04-09_02:25:47 Locale: es-ES (es_ES); Calc: CL Version: 5.3.2.2 (x64) Build ID: 6cd4f1ef626f15116896b1d8e1398b56da0d0ee1 CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; Layout Engine: new; Locale: es-ES (es_ES); Calc: group
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=eefe13c77d01be37c911e75af191717a944fedb3 shrinking the DB area just causes problems, tdf#89546 It will be available in 5.4.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.