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 327278 - Sort range has a header - always
Sort range has a header - always
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: GUI
unspecified
Other Linux
: Normal enhancement
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2006-01-17 04:32 UTC by Bryce Nesbitt
Modified: 2006-01-27 22:42 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Bryce Nesbitt 2006-01-17 04:32:41 UTC
The "Sort range has a header" checkbox in Excel is always a bit annoying.  It always defaults to unchecked.

Here's a place where Gnumeric can do better.  The moment I check "Sort range has a header", chances are my spreadsheet will continue to have a header, all through the session.  Really!  I promise I won't delete the header, then get annoyed the default is wrong.

This field should be sticky at minimum, and perhaps even be saved as part of the file format.

                        -Bryce
Comment 1 Andreas J. Guelzow 2006-01-17 06:13:03 UTC
this is sort of related to 100541
Comment 2 Bryce Nesbitt 2006-01-17 15:56:02 UTC
I'll agree that 100541 is a superset of this one.
Though header rows are more constant - a spreadsheet has 'em or not in most cases.  Desired sort parameters could be different per session.
Comment 3 Bryce Nesbitt 2006-01-18 19:59:03 UTC
This same issue is endemic to the current Gnome series.

For example every time I load a file, I must click many times: first to find a directory, then to set filetype to "all" not "spreadsheet", then to set the import format to "textfile".

Gnumeric does not remember any of that.  Next time I have to do it all over from scratch.
Comment 4 Andreas J. Guelzow 2006-01-23 23:22:22 UTC
Bryce,

what kind of text files are you typically loading? I assume the automatic file type recognition does not work for you.
Comment 5 Bryce Nesbitt 2006-01-23 23:30:28 UTC
I'm loading some wacky QuickBooks .iif files, and Helix Dumps, which are standard tab-separated files, but with TWO header lines defining TWO types of records to come.
Comment 6 Andreas J. Guelzow 2006-01-27 22:42:59 UTC
This is not what you are asking for but should help partailly regarding the sort header issue. I have added a sort preference so that you can have the has-header checkbox checked by default. This is globally and not on a per file basis. The latter issue should be addressed as part of  100541.

You may want to file separate enghancement requests for the filetype "all" vs "spreadsheet" and possibly the import type issue (personally I think that the automatically detect file type should remain the default)