On Tue, Oct 17, 2006 at 01:29:14PM -0700, Ralph Shumaker 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. > > > > Formatting the cells to alpha only affects new data. The data already > input as numeric stays numeric, at least with every spreadsheet I've > ever used. >
Hmm. In my experiments, FC4, OOCalc 2.0 Beta, Having any data in the column at all prevents the change from taking, even with new data. However, if the format is applied _before_ data is entered, it behaves as an alpha sort, which is what I want. Thanks for making me go back and try again. -- Lan Barnes Linux Guy, SCM Specialist Tcl/Tk Enthusiast If we did a good act merely from love of God and a belief that it is pleasing to Him, whence arises the morality of the Atheist? ...Their virtue, then, must have had some other foundation than the love of God. - Thomas Jefferson, Letter to Thomas Law, June 13, 1814 -- [email protected] http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
