[Libreoffice-bugs] [Bug 89546] Single column Autofilter with "Not empty" shows empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=89546 --- Comment #3 from Kari Salminen --- 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 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 89546] Single column Autofilter with "Not empty" shows empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=89546 Kari Salminen changed: What|Removed |Added Keywords||regression --- Comment #4 from Kari Salminen --- 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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 89546] Single column Autofilter with "Not empty" shows empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=89546 Xisco Faulí changed: What|Removed |Added Keywords||bibisectRequest CC||xiscofa...@libreoffice.org -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 89546] Single column Autofilter with "Not empty" shows empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=89546 Xisco Faulí changed: What|Removed |Added Version|4.3.3.2 release |4.3 all versions --- Comment #5 from Xisco Faulí --- I can reproduce it in Version: 4.2.0.0.alpha1+ Build ID: fc8f44e82de4ebdd50ac5fbb9207cd1a59a927e3 Thus, it can't be bibisected with bibisect-43max -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 89546] Single column Autofilter with "Not empty" shows empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=89546 Markus Mohrhard changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |WORKSFORME --- Comment #6 from Markus Mohrhard --- At least with the test file everything works ok. 302 303 304 305 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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 89546] Single column Autofilter with "Not empty" shows empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=89546 --- Comment #7 from Kari Salminen --- (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 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 89546] Single column Autofilter with "Not empty" shows empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=89546 Kari Salminen changed: What|Removed |Added Attachment #113589|0 |1 is obsolete|| --- Comment #8 from Kari Salminen --- Created attachment 127987 --> https://bugs.documentfoundation.org/attachment.cgi?id=127987&action=edit 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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 89546] Single column Autofilter with "Not empty" shows empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=89546 Kari Salminen changed: What|Removed |Added Status|RESOLVED|NEW Resolution|WORKSFORME |--- --- Comment #9 from Kari Salminen --- (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). -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 89546] Single column Autofilter with "Not empty" shows empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=89546 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |NEW CC||mari...@miguelangel.mobi Ever confirmed|0 |1 --- Comment #1 from m.a.riosv --- 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. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 89546] Single column Autofilter with "Not empty" shows empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=89546 --- Comment #2 from tommy27 --- ** 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 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
