Bruce & Frances Ardern wrote:
I have a spread sheet with data in columns A to M (except for J) and rows 6
to 25. I want to sort on columns K then L then M (in one sort) shifting the
data in columns A to I with the original numbers in K to L
I have used Excel to do this before without any problems but can't get Calc
to do it. I have been highlighting the area A6 to M25 and then going Data,
Sort, and in the dialogue box selecting the columns in sort order and
whether Ascending or Descending. After I hit OK no matter what I change the
Ascending or Descending to in the different columns there is no change to
the order of data.
Can anyone pinpoint what I am doing wrong here. Running Oo 2.0.3 on Win XP
Can't suggest anything, but I set up a simple table similar to the one
you describe, using OOo 2.0.3 and sorted as you describe also and it
appears to work fine. I got all the selected rows sorted in the order
that I expected. I tried changing the sort direction on the different
sort columns and the results were correct again. The only option I
changed was to use "Case Sensitive" sorting.
I assume you've tried just creating a simplified table in a new
spreadsheet to see if that works any better. I'm running OOo2.0.3 on
Linux, but I don't believe the system should affect anything.
Ross
Also the spreadsheet was created using Oo 1.4 and now keeps crashing using
Oo2.03
Bruce
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
