On 08-Sep-07, at 1:10 PM, Rony wrote:
Problem 1: His file consists of many rows and columns. Cells in each row are related to each other. Now in Excel he can sort columns individually and during each sorting, entire rows get sorted. So after every sort, the cells in each row are the same. It is the entire row that gets sorted. In OO he can sort columns but it sorts cells in that column only and this breaks the row and ultimately the table cells get cross connected.
Another problem is that if a cell is given a colour, after sorting, the cell shifts but the colour is stationary in the older cell location irrespective of sort changes.
have you ever tried koffice? much faster than open office - and in my opinion, much better