Osric Fernandes wrote:-
Oops, its not a bug. Its a feature ;-) Comment from OpenOffice.org's Issue 28296: (http://www.openoffice.org/issues/show_bug.cgi?id=28296)
"this is not a bug of OOo Calc.
If you use the buttons in the toolbar to sort your data, these buttons are not capable to do what you want. They are designed to do a quick Sort from A-Z, 0-9 and vice versa.
(RB) Even if it does a quick sort, the cell data and cell colour should be attached to each other. I did the same in M$ Office at HBCSE and there cell colour moved with cell data.
To solve your problem, mark the cell range A5:N55 and select Sort from the data menu. Make sure 'include formats' is tagged on the Options tabpage. The problem with the document supplied is that cells with formats can't be sorted if the range contains merged cells."
(RB) In the figure A5:N55 what does :N55 mean?