Re: Calc: Sort double columns

On Mon, Oct 3, 2011 at 20:08, Dennis E. Hamilton
<[email protected]> wrote:
>  I think it can all be handled.  First, eliminate the merged cell
>  that has the number in it.  Just have the top of the two have the
>  number and make the border between the empty cell underneath invisible.
>
>  Secondly, make a column that has the actual sorting sequence in it.
>  To match the intended number, use something like 1.0, 1.1, etc.
>  (It should be possible to use some formula magic to populate this
>  row-key column with values derived from the cells that actually
>  have the visible numbers.
>
>  Use the row-key column to sort the entries into the proper sequence.
>  The column can be made invisible and it should still be usable in sorting.
>
>  Note: If there are other keys that are to be sorted by, and they only
>  appear in one row or another, these need to be expanded into (hidden)
>  keys on each row so they work too.  There are ways to do this so sorting
>  by different keys that still keeps the grouping of the paired rows
>  together.

Thanks, I will try that idea. Maybe if the key is in column A then I
could sort on a column with a value like this (psuedocode):
floor( columnA/2 ) *2


-- 
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