| Summary: | FILTER: (Standard Filter) Empty cells at the bottom of a column match a non-empty Value | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Jonathan Ryshpan <jonrysh> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | CC: | jmadero.dev, miguelangelrv, pje335-lo |
| Priority: | medium | ||
| Version: | 4.1.1.2 release | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Linux (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | The spreadsheet in the example | ||
Hi Jonathan, thanks for reporting. I can not reproduce the issue with: Win7x64Ult. Version: 4.1.2.0.0+ Build ID: aa9bef8271ed50a397c959ed53c91ee44b3dcb1 TinderBox: Win-x86@6-debug, Branch:libreoffice-4-1, Time: 2013-09-03_11:55:14. I was trying with several calc options but nothing change. I have rebuilt libreoffice from source in koji in the hope that the bug was fixed in your newer version, using libreoffice-4.1.2.1-1.fc20.src.rpm (which took 5 hours on my 4 processor x86_64 system) and have installed the resulting objects, which appear to run. Unfortunately the bug persists. I also cannot confirm this with either 4.0.4 nor with 4.2 built just today. marking as WFM Suggestions: Test latest master (don't have to build) just go here: http://dev-builds.libreoffice.org/daily/master/Linux-x86-64@8-SLED11/ also reset your user profile: https://wiki.documentfoundation.org/UserProfile If you can confirm the problem with latest master after resetting your profile mark as UNCONFIRMED and we will try again. Thanks! I have just downloaded http://dev-builds.libreoffice.org/daily/master/Linux-x86-64@8-SLED11/current/master~2013-08-30_00.08.45_LibreOfficeDev_4.2.0.0.alpha0_Linux_x86-64_rpm.tar.gz and untarred it. It doesn't look very easy to install, since the rpm names are completely different from those in the Fedora-19 distribution, which is what I'm using. In particular nothing on my system is named lodevbasis4.2-*. What's the best way to install? Changing the user profile doesn't cause any improvement. I haven't worked with RPM packages in a long long time but I believe this will work: cd into the untarred directory where the rpm packages are su - enter password rpm -ivh *.rpm After it installs you'll actually have a second version of LibreOffice installed (lodev). Usually my recommendation is to purge your current version completely before installing LoDev but if you don't want to do this, I think you should be okay just installing the 2nd version parallel to your stable install. I have installed Lodev along with LibreOffice, pretty mush as Joel Madero recommends. The installation produced these messages: # rpm --install *.rpm /bin/update-desktop-database /bin/update-mime-database Unknown media type in type 'all/all' Unknown media type in type 'all/allfiles' Unknown media type in type 'uri/mms' Unknown media type in type 'uri/mmst' Unknown media type in type 'uri/mmsu' Unknown media type in type 'uri/pnm' Unknown media type in type 'uri/rtspt' Unknown media type in type 'uri/rtspu' mkdir: cannot create directory ‘/usr/share/icons/hicolor/icon-theme.cache’: Not a directory mkdir: cannot create directory ‘/usr/share/icons/hicolor/index.theme’: Not a directory /bin/gtk-update-icon-cache /bin/gtk-update-icon-cache /bin/update-desktop-database /bin/update-desktop-database Just to be sure that there are no interactions, I erased the current version of LibreOffice from the system. The installed version appears to run OK when invoked as libreofficedev4.2. (BTW: I like the new slightly different user interface) Unfortunately the bug I reported persists. Maybe I don't understand something about LibreOffice filters. Or maybe I haven't made the bug clear. Perfect, thanks for additional info. Going to ping another QA member to test. Thank you for your bug report, I CAN'T reproduce this bug running Version: 4.1.2.1 Build ID: bf15ac65c2167fb1ef3daf3710609d4a4c369a9 on Mac osx 10.8.4. Very perplexing. Nobody else sees this problem, while I am unable to make it go away. Grasping at another straw, I logged in as another user on the same system; the problem persists. Next thing is to try on another system. jon Indeed - very strange. If it doesn't appear on another system I'm tempted to close this as NOTOURBUG as it seems like it's environment specific. But report back with your findings and we'll go from there Okay I have to close this as WFM as I have tested on multiple machines now and it's working. If you still see this with 4.1 (completely purge libreoffice and remove your user profile) and can reproduce this from a fresh sheet go ahead and reopen this as UNCONFIRMED and we'll try to figure it out - also I suggest emailing the user list to see if someone else has ever faced this problem. Thanks for your patience and understanding Just to be clear I put on auto filters and just selected Fred - worked perfect. |
Created attachment 85295 [details] The spreadsheet in the example Take this sheet: ID Data 1 2 3 Fred 4 Fred 5 Fred 6 7 Charlie 8 Charlie 9 10 Filtering for "Fred" in the Data column produces ID Data 3 Fred 4 Fred 5 Fred 9 10 which has two unexpected rows at the bottom. On the other hand, adding an additional (phoney) row: ID Data 1 2 3 Fred 4 Fred 5 Fred 6 7 Charlie 8 Charlie 9 10 11 --- works as expected. Similar weird things happen when filter for "Charlie" or Not Empty.