On 9/14/07, Manoj Srivastava wrote:
On Thu, 13 Sep 2007 22:59:52 +0530, osric fernandes said:
On 9/13/07, Rony wrote:
I will repeat the test the way I do it. A test table is created in ODS with one cell given a background colour. Then the top left corner space is clicked to select the entire table. Then the sort buttons in the tool bar are clicked to move the cells up/down. The colour of the cell remains locked to that cell and does not move with the data.
Ok, its a bug. It occurs when the tool bar sort button is used. Using the menu item Data->Sort works fine. This is not an issue with:
- the OS - the bug occurs on both Debian & WinXP (poor Ubuntu gets
blamed for no reason) 2. the file format - the bug occurs with both ods and xls documents.
Thanks for the analysis. Have you filed a bug, with the sampletest case you worked with? If you have, could you please post details of the bug number, so it could be added to the Debian bug report (if you have not already done so)?
manoj
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.
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."