On Sun, 08 Jun 2008 13:35:09 +0200 [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?
Essentially, rowZ will go to the top regardless of the values in colO or colN because that is the major. Same with roX. Since the values in colP rows Y and Q are equal then the next column is sorted. The value in YO is 2, and that goes higher than QO. There is no further ambiguity, so sorting does not proceed to colN at all. In this example, calc did the correct thing. (As would the Linux sort(1) command). -- -- Jerry Feldman <[EMAIL PROTECTED]> Boston Linux and Unix PGP key id: 537C5846 PGP Key fingerprint: 3D1B 8377 A3C0 A5F2 ECBB CA3B 4607 4319 537C 5846
signature.asc
Description: PGP signature
