At 08:23 08/06/2008 -0700, JOE Conner wrote:
Hans Noname wrote:
I have in a spreadsheet a small table.
[...]
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.
This is, of course, true - and well worth saying: that Calc appears
normally to serve the enquirer in just the way he wants. It's not
just that Calc cannot sort properly in this case. But we can test
your other suggestions and find them wanting, I believe.
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.
If the enquirer had not managed to get Sort to handle the entire
block, he would not have reported the problem as he did. If he had
selected a single cell somewhere, then Data | Sort... would have
expanded the selection - probably to the entire block of data or
possibly more. And if he had selected just the first column - the
one that did, in fact get sorted - he would not have been given the
option to sort by the other columns, which he evidently was.
Other things to check:
1. Make sure the radio buttons are set the way you want.
Again, he described the nature of the sort and confirmed that the one
column which was sorted was sorted correctly. So we know that Calc
was taking notice of the values in columns O and P and sorting in
descending order.
2. Check that protection is turned off on the sheet before you sort.
I thought of that as a possibility, too: did he have columns O and P
(but not N) protected? But testing that possibility shows that the
sort fails if that is the case, since the sort process does require
to move the values in those cells, albeit that it gives the
appearance of not doing so in this case.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
