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?
dear roni, why do you tend to take comments wrongly? I did not say any thing rood. rather I am stressing on the point that you did face the problem and time and time again I did say that you faced it and that it is not true that this did not happen. you can read my previous few emails to confirm this. but the fact is that without telling or instructing any one, every one did the thing in exactly the way open office had kept it. this is a big proof that open office guys anticipated some human interaction with their software and kept the function in a place where most people would come searching. that is why it took so much time to find out the problem. that's why I say that it was not that you are a fool or you did not face a problem, it is just that you did it in a different way which only very few might have done it. and research would be generaly based on what most people do and not very few. so open office guys knew that such things are searched in a menu and the fact that most people did it normally proves this. talking about the comments from sun about feature or bug. I think what they have done is good enough. toolbar button might be just a quick sort and does not need to be feature rich. what it means is that only use that button for a usual task of normal sorting of data. the kind of sorting where even the colour needed to be moved was there in the menu. so sun is clearly making it appear to be different. and I don't think that JTD said any thing extreme. you seam to fail to realise that most people using m$ software just say "oh, buggs and crashes? computer hang? all this is the part of it and we have no choice ". so people do face daily problems and my experience matches with JTD and many others. I will even add that all those professional clients of mine who r now switched to gnu/linux, they all bless me for putting them out of all daily rubbish of windows. regards, Krishnakant.
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.