GNOME Bugzilla – Bug 554206
Formatting stays attached to cell location not contents when sorting
Last modified: 2008-09-29 23:11:00 UTC
To reproduce create three rows with the following: =rand() , first =rand() , second =rand() , third Select B2 with the word "second" and click CTRL + B to bold the field. Highlight columns A & B and click the sort button to randomly sort the table. The bold formatting will stay with B2 rather than following the word "second" around. You may have to do this a few times before the word "third" pops in there since it assumes the first row is a header row. The bold formatting should follow the word "second" wherever it goes. Note: CTRL + C, CTRL + V copy/paste keeps the formatting intact, so I know the formatting should follow the text, plus this is how Excel handles it.
Thanks for the bug report. This particular bug has already been reported into our bug tracking system, but please feel free to report any further bugs you find. *** This bug has been marked as a duplicate of 303408 ***
Mark: please note that you can toggle the "sorting preserves format" checkbox in the tools->Sorting tab of the preference dialog if you would like to change the behaviour you observe. Bug 303408 is simply about you not having enough fine brained control about which format aspects to preserve.