Hi
I was not succsessfull to get rid of the marker #### in my document
and I was not able to see your example
Thanks for the tips
Jan-Eric
-----Ursprungligt meddelande-----
From: Dotan Cohen
Sent: Friday, October 14, 2011 10:26 PM
To: [email protected]
Subject: [users] 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
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
