GNOME Bugzilla – Bug 311567
Filtering stops when blank cells are reached
Last modified: 2009-12-28 16:23:49 UTC
Distribution: Debian testing/unstable Package: Gnumeric Severity: normal Version: GNOME2.10.1 1.5.x Gnome-Distributor: Debian Synopsis: Gnumeric Crashed when attempting to filter a list in place Bugzilla-Product: Gnumeric Bugzilla-Component: Analytics Bugzilla-Version: 1.5.x BugBuddy-GnomeVersion: 2.0 (2.8.1) Description: Description of the crash: I had a list containing multiple values and empty lines (can send later if necessary). I chose advanced filter of the entire A collumn, and inputed collumn A as the criteria range. I marked the checkbox "use unique items only" and instructed the output to be in a new sheet. Gnumeric crashed. Debugging Information: Backtrace was generated from '/usr/bin/gnumeric' (no debugging symbols found) Using host libthread_db library "/lib/tls/libthread_db.so.1". (no debugging symbols found) `system-supplied DSO at 0xffffe000' has disappeared; keeping its symbols. (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) [Thread debugging using libthread_db enabled] [New Thread -1223697536 (LWP 18195)] (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) 0xb761d53e in __waitpid_nocancel () from /lib/tls/libpthread.so.0
+ Trace 61994
Thread 1 (Thread -1223697536 (LWP 18195))
------- Bug moved to this database by unknown@gnome.bugs 2005-07-26 09:46 UTC -------
line 1738 in value.c tries: t1 = cell->value since cell was obtained from a call to sheet_cell_get it may be NULL, and in this case is.
I added a band-aid to prevent that particular crash.
Gnumeric 1.6 doesn't Crash. However, it doesn't filter correctly. A1 contained data, A2:A3 were blank, A4 contained data. The new sheet contained only the data in A1. It seemed that Gnumeric gave up when it reached the blank cells. I'm leaving it open, since it doesn't work correctly (but doesn't crash).
Retitling - open bugs with crash in the title should preferably be crashers
Uri: that sounds suspiciously like it copied the column header and discarded the remaining data. Can you supply a sample file ?
Created attachment 106557 [details] File demonstrating filtering Hi. I tried it with the current version of Gnumeric (1.8.1), and it didn't happen the way I remembered. This version copied the header, and filtered out the rest correctly (or almost correctly). I see two problems with the way it is currently filtering: 1) It maintains the distinction between header and data. Why is this necessary, or not an option? Not all lists have headers. 2) It sometimes included empty spaces and sometimes didn't. I don't understand the logic, but I'm assuming there is one - if there is, could it be made clearer? I'm attaching a file that includes data (in sheets 1 & 2) and the filtered version (filtered 1 & 2). This file demonstrates the use of header, and the fact that sometimes empty spaces were considered, sometimes not.
IN your last attachment, I see 2 sheets that contain a data column each, one empty sheet and two filtered output sheets. Where is the criteria tht you were using to create the filtered output?
Note regarding (1): the advanced filter is primarily criteria driven, and for criteria headers are required to identify the columns.
*** This bug has been marked as a duplicate of bug 599064 ***