On Mon, Oct 16, 2006 at 02:52:50PM -0700, James G. Sack (jim) wrote:
> Lan Barnes wrote:
> > On Mon, Oct 16, 2006 at 01:01:59PM -0700, Carl Lowenstein wrote:
> >> Oh. Penny drops. Can't you specify that the column in the
> >> spreadsheet is of type alpha, not type numeric?
> >>
> >
> > That is what I'm asking.
> >
>
> I think you have to force interpretation as text rather than numeric.
> There may be a conversion function you can call by executing some macro?
>
> If you are typing the data in, you can type '901, '88, etc
> (prefix=single-quote) to force text. If importing from a file, you have
> to help the import wizard for that column, by specifying text.
That doesn't work in OOCalc. The field gets the "'91" value and sorts as
a numeric.
As said before, x91 x9000 does sort as an alpha.
Guess I'll just stick to that. It's just for me anyway.
--
Lan Barnes
Linux Guy, SCM Specialist
Tcl/Tk Enthusiast
Sometimes the public needs to hear unpleasant truths, even if those
truths make them feel worse about their country.
- Paul Krugman
--
[email protected]
http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
