After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 639444 - (FilterKaput) Advanced filter does not work
(FilterKaput)
Advanced filter does not work
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: General
1.10.x
Other All
: Normal major
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2011-01-13 17:04 UTC by VanillaMozilla
Modified: 2011-01-14 04:06 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
Example spreadsheet (2.34 KB, application/x-gnumeric)
2011-01-13 17:04 UTC, VanillaMozilla 		Details

Description VanillaMozilla 2011-01-13 17:04:17 UTC 
Created attachment 178246 [details]
Example spreadsheet

No matching records are found.  The attachment shows the search record and results.

Steps to duplicate
1. Filter > Advanced Filter
2. Select range and criteria range
3. Press "OK".

I thought that the problem might be blank cells, but I could not find any combination of cells in the list range or criteria range that worked.  As far as I can tell, it always returns no matching records.

Verified for versions 1.10.8 for Linux and 1.10.9 for Windows.
Comment 1 Andreas J. Guelzow 2011-01-13 23:55:45 UTC 
Without looking at the code but just by looking at behaviour of the advanced filter I note that the filter seems to work only if the values in the criteria are all numerical.
Comment 2 Andreas J. Guelzow 2011-01-14 03:53:56 UTC 
I was mistaken. It does not seem to be an issue of numerical versus non-numerical.
Comment 3 Andreas J. Guelzow 2011-01-14 04:02:30 UTC 
Why do we have very similar code in find_rows_that_match and in find_cells_that_match? The latter should use the former.
Comment 4 Andreas J. Guelzow 2011-01-14 04:06:03 UTC 
Te advanced filter was effectively using a conjunction between different rows of the criteria. That of course is basically useless!

This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.