On 9/15/07, Rony wrote: > 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?
That was a part of the comment taken verbatim from the link provided and refers to the file attached with the issue. Modify the procedure according to your problem. -- Regards OSRIC XAVIER FERNANDES Registered Linux User #442219 Debian GNU/Linux 4.0 -- http://mm.glug-bom.org/mailman/listinfo/linuxers
