Re: Calc: Sort double columns

On Sun, Oct 9, 2011 at 19:00, Brian Barker <[email protected]> wrote:
> That error is a trivial problem: when you sort, just go to the Options tab
> in the Sort dialogue and remove the tick from "Include formats".
>
>> Example document here:
>> http://dotancohen.com/images/examples/sort-example.ods
>
> At 12:15 07/10/2011 +0200, Dotan Cohen wrote:
>>
>> The issue is more of a mess than I thought!  Not only does the user need
>> to sort on double rows, but the number that he is sorting on is not unique!
>> Therefore, simply creating a second cell with a derived sort number will not
>> work.
>
> That's not true.  Try this:
> o  Choose a column for your sort key; I used column G.
> o  In G2, enter: =IF(A2=0;G1;A2+ROW(A2)/1000)
> o  Fill that formula up to G1 and down the rest of the relevant part of
> column G - or just copy it, select the relevant part of column G, and paste.
> o  Select all the material to be sorted, and sort on column G (with "Include
> formats" unticked).
>
> Your double rows with identical keys in column A will be sorted properly and
> will stay - as between themselves - in the same order as they were before
> the sort.  I'm assuming that you don't have more then 1000 rows of this
> data; otherwise you'd have to increase the divisor in the formula.  You can
> either delete or hide column G afterwards if you prefer.  You'll want to
> keep it if you'll need to sort additional data later.
>
> Why did I start with G2 instead of G1?  Well, the formula in G1 makes
> reference to G0, but that is no problem if you start with G2.  If your table
> started anywhere other than in row 1, you could compose the formula in the
> first row of the table without problem.
>
>> It looks like the real choice here is to either stay with his current
>> solution, or to move to a real database (as it was in the very beginning).
>
> Or use Calc ...
>
> I trust this helps.
>
> Brian Barker
>

Thank you Brian, I will play with it a bit this weekend. Your
assistance is very much appreciated! Have a peaceful weekend.


-- 
Dotan Cohen

http://gibberish.co.il
http://what-is-what.com
-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help