Re: Calc: Sort double columns
Dale Erwin <[email protected]>
| Newsgroups | gmane.comp.openoffice.questions |
|---|---|
| Organization | Casa Erwin |
| Message-ID | <[email protected]> |
On 10/3/2011 4:29 PM, Dotan Cohen wrote: > 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 > > What about making the 1st column discreet for each row and then making the 2nd row of each record have the same content as for 1st row plus, say, an "A" or something similar. This would make the second row of each record follow the 1st row of the same record in a sort. Using the previous example: ------------------------------- 1 | Some Info ------------------------------- 1A | More Info ------------------------------- 3 | Yet some more info ------------------------------- 3A | And more info ------------------------------- 2 | Some important info ------------------------------- 2A | More important info ------------------------------- -- Dale Erwin Lurigancho, Lima 15 PERU http://leather.casaerwin.org ======= Email scanned by PC Tools - No viruses or spyware found. (Email Guard: 7.0.0.26, Virus/Spyware Database: 6.18431) http://www.pctools.com/ ======= -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help