Lan Barnes wrote:
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.
Well, that's only part what I was trying to tell you. But let me put a
finer point on it.
Let's say you have a column which has a few numbers already entered in
general numeric format (behaves like numbers). Then you select the
entire column and change the numeric format to text. The numbers
already there continue to behave like numbers. But if you go to one of
those cells and re-enter the number, when you hit enter, the contents of
that cell (although it appears no different) will now behave like text.
What I said was that numeric text formatting does NOT affect data
already there, but IS applied to any new entry, even the same ascii entry.
--
[email protected]
http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
