On 9/8/07, Rony <[EMAIL PROTECTED]> wrote: > 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. > > I don't know which version you are using however I do regularly sort set of columns by selecting the set. If you select only one column OO assumes you need to sort just that.
Similarly let him define a range for the given data and then he should be able to select it very quickly and do multiple operations on it. OO < 2.2 is slow in some things, 2.3 holds promise in terms of speed and is far more full featured than any other opensource office solutions. Comes as a part of gutsy right now. regards, C -- http://mm.glug-bom.org/mailman/listinfo/linuxers
