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 529269 - formats (colors) not sorted when a column is sorted by value
formats (colors) not sorted when a column is sorted by value
Status: RESOLVED DUPLICATE of bug 303408
Product: Gnumeric
Classification: Applications
Component: Sheet Objects
1.7.x
Other Linux
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2008-04-21 20:05 UTC by oscar
Modified: 2008-04-21 22:33 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description oscar 2008-04-21 20:05:48 UTC 
When sorting a column where cells have different foreground/background format colors (e.g. as a cue of the significance of a cell's value), the ordering of the colors is not altered, resulting in an inconsistent color-to-value association in the sorted contents.
Comment 1 Andreas J. Guelzow 2008-04-21 20:38:43 UTC 
This depends on the selection of the "preserve format" check box in the sort dialog (or for the button in the toolbar) in the preference dialog.

*** This bug has been marked as a duplicate of 303408 ***
Comment 2 oscar 2008-04-21 21:31:16 UTC 
Is it possible to have this "preserve format" as the default, just like in Excel?
Comment 3 Andreas J. Guelzow 2008-04-21 21:39:22 UTC 
I don't know whether "just like in Excel", but  you can set up the default in the tools->sorting tab of the preference dialog.
Comment 4 oscar 2008-04-21 22:33:01 UTC 
I've done what you said and it works fine, thank you.

I use MS Excel at the Office and Gnumeric (Ubuntu) at home. I was confused by the different default sorting behaviour, which I mistook for a bug.

It would be so nice if Gnumeric had this option "off" by default, as it would help potential new users do the transition more smoothly without these little confusions.

Anyway, Gnumeric is doing an excellent job at maintaining compatibility with Excel  , which was one of the arguments that helped me take the final leap towards GNU-Linux.