Rony wrote:
Carry out a simple exercise. Create a simple table of 5 rows and 4 columns in OO Spreadsheet in ODS format. Add random data to the cells. Colour one cell with some colour. sort the table such that the cell data moves to a new location. Check if the colour of the cell moves too. It does in M$ Office.
I did. I am using OpenOffice 2.2.1. And the colour of cell moves along with the cell after sort.
Secondly, the problem regarding "column sorting does not move other cells in the row..." is applicable only if you deliberately select full column (by clicking on "A" or "B" .... etc.), and this behaviour is seen even in Microsoft Excel. In Excel when I select a column by clicking "A" for example, and then select sort, then Excel gives a dialogue box saying that there is data in other columns too, should they be included in sort? If you say no then Excel will also sort *only* the selected column, cells in the other columns remaining in tact (tried this with Office XP). If you say yes, then Excel will select *all* the columns for sorting and sort on the column that you requested so that respective cells of row move together after sort. This same feature is there on Open Office too (Read my next para). So what you were complaining about Open Office calc is not a bug but a feature... because there would be scenario where one would *want* to sort only a given column.
And regarding "Sorting on column and respective cell rows moving...." is also the also available with OpenOffice. To achieve that all you need to do is place your cursor anywhere on the sheet where there is data and select sort, you will see that Calc automatically selects all the columns and asks you which column to sort on. After sorting is finished you will find sorted columns with respective rows moved. The *very same* behaviour I found with Excel too. When I select sort in Excel by placing the cursor on any cell containing data, then Excel also automatically selects all the columns containing data (exactly what Calc also does). Hence after sort you get respective rows moved with sorted column with both Calc and Excel.
So what is the problem?
Rajen.