Calc Sorting does not sort the formatting

Discuss the spreadsheet application
Post Reply
kristianwhittick
Posts: 3
Joined: Fri Nov 30, 2007 1:22 pm

Calc Sorting does not sort the formatting

Post by kristianwhittick »

I have a problem sorting rows with formatting.

To reproduce:
1) Open a new calc sheet.
2) Enter cells with data in any order.
3) Mark one of the cells with Bold font. (or date formatting)
4) Sort the data.

Result
The data get sorted but the formatting is not.

Is this a bug?
Is there a setting I am missing ?
kristianwhittick
Posts: 3
Joined: Fri Nov 30, 2007 1:22 pm

Re: Calc Sorting does not sort the formatting

Post by kristianwhittick »

Additional,
This happens from the tool bar.
It sometimes works from the menu.
huw
Volunteer
Posts: 417
Joined: Wed Nov 21, 2007 1:57 pm

Re: Calc Sorting does not sort the formatting

Post by huw »

There is a setting Data > Sort... > Options > Include formats, but your problem is mostly caused by the default toolbar buttons. They cause other problems too and are best removed by customising the toolbar. Then stick to using the menu. Or do I as I do and add a toolbar button that brings up the menu version of Sort.
kristianwhittick
Posts: 3
Joined: Fri Nov 30, 2007 1:22 pm

Re: Calc Sorting does not sort the formatting

Post by kristianwhittick »

Thanks, Then it is a bug.
Post Reply