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.:
91
900
sorts to
900
91
This facilitates look up.
Using Open Office Calc, I can't find out how to do this.
Qs:
1. Does Gnumeric do this?
2. Does OOC but I just don't know how?
I have the workaround of adding the same alpha to the front of each
numeric value, as in:
x91
x900
sorts to
x900
x91.
TIA,
~Lan
--
Lan Barnes
Linux Guy, SCM Specialist
Tcl/Tk Enthusiast
The problem with OO code is really that you have to make a lot of it
before you can test it.
- Donal K. Fellows
--
[email protected]
http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
