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: 1. 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.