Chetan S wrote:
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.
I have installed OO 2.2. He selects the entire table by clicking the top
left corner and then uses sort. For columns he moves the horizontal
scroll bar right to get the required column in first place on screen and
then sorts. In M$ he can do it in a hierarchical manner and sort rows
accordingly.
As mentioned in the next mail, cell colours don't move with the cell
after a sort.
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.
He is using windows and .xls format.
--
Regards,
Rony.
Knock Knock
Who's There?
Linux
Who Linux?
GNU/Linux
--
http://mm.glug-bom.org/mailman/listinfo/linuxers
