[EMAIL PROTECTED] wrote:
Hallo OO users,
I have in a spreadsheet a small table. It looks a bit like:
... colN colO colP
... ... ...
rowX Aa 5 1
rowY Bb 2 0
rowZ Cc 5 3
rowQ Dd 1 0
After sorting I would like it to be like:
Cc 5 3
Aa 5 1
Bb 2 0
Dd 1 0
For this I selected the area I want to be sorted, asked to sort
first by colP then by colO.
But colO en colP stay the way they were, only colN gets sorted
to the correct order.
What am I doing wrong?
<<SNIP>>
When I sort your example data by ColO with the radio button set for
Descending and secondly by ColP with the radio button set for Descending
I get the result you are expecting. I suggest you verify that before
you sort you have selected the entire matrix of cells. If you have not
first selected all the columns to included in the sort move, then only
the column containing the cursor will be sorted. This gives you great
flexibility, but can scramble your data if you forget. Undo will
recover the data to the prior sort phase.
Other things to check:
1. Make sure the radio buttons are set the way you want.
2. Check that protection is turned off on the sheet before you sort.
Hope this helps.
Joe Conner, Poulsbo, WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
