On 10/16/06, Lan Barnes <[EMAIL PROTECTED]> wrote:
I'm using a spreadsheet to make data sheets for an open-book
certification exam I'm going to be taking. The need is speed of look up.
One of the tables I'm compiling is a list of ISO, IEEE, and European
standards documents by number with a 1-sentence blurb from the text. I
want the standards number field to sort as an alpha, i.e.:
Let me ask a semi-related question: are you able within the
spreadsheet to sort a column and have the rows stay together. i.e.
use one entry as a sort key for all rows. I was unable to do that in
a few minutes of fiddling around. Both Gnumeric and OO Calc. My
workaround was to export the spreadsheet data as a csv file, use
sort(1) to sort on the desired column, and then import the result back
to the spreadsheet.
Oh. Penny drops. Can't you specify that the column in the
spreadsheet is of type alpha, not type numeric?
carl
--
carl lowenstein marine physical lab u.c. san diego
[EMAIL PROTECTED]
--
[email protected]
http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
