[prev in list] [next in list] [prev in thread] [next in thread] 

List:       koffice
Subject:    Re: KSpread cell format = text
From:       Marc Heyvaert <marc_heyvaert () yahoo ! com>
Date:       2004-02-04 9:06:19
Message-ID: 20040204090619.87137.qmail () web41507 ! mail ! yahoo ! com
[Download RAW message or body]

Hello Jeffrey,

I tried to recreate the bug on my system (suse 8.2
with kde and qt upgraded to 3.1.4 and 3.2).

In the kspread from my distro (probably 1.2-I'm not in
front of that PC for the moment) the behaviour is as
you describe. So clearly a bug. I think it is in de
bugs database as n°62730

http://bugs.kde.org/show_bug.cgi?id=62730

But in a newer version that I installed 2 weeks ago
(1.2.95) the bug is clearly resolved. You can change
the format of a number to text and back. And when you
enter numbers that are supposed to be interpreted as
text, you can use the old lotus 1-2-3 trick of
preceding the number by a "'".

So my advice would be to upgrade your KDE/Koffice
setup.

Regards

Marc

--- Jeffrey Barish <jeffbarish@starband.net> wrote:
> I am trying to enter the number 123456789 as text so
> that it displays as
> I just wrote it.  If I enter the number in a blank
> cell, I get
> 123,456,789.  If I then go to Format|Cell Format, I
> see that the Format
> is Number, so the reformatting I observe makes
> sense.  I select Text. 
> Nothing happens (I still see 123,456,789).  If
> KSpread is not treating
> the contents of that cell as a number anymore, it
> should remove the
> commas.
> 
> I go to another blank cell and select Format|Cell
> Format|Text before
> putting anything in it.  Now I enter 123456789 in
> the cell.  I see a
> blank cell.  However, when I select the cell, I see
> 123456789 in the
> content window above.  That's clearly wrong as the
> cell should not be
> blank if something is in it.
> 
> I'm using KSpread 1.2.94 on KDE 3.1.4.
> 
> I've never reported a bug before.  Should I report
> this as a bug?  I
> searched the bug database but didn't find such a
> report.
> -- 
> Jeffrey Barish
> 
> ____________________________________
> koffice mailing list
> koffice@mail.kde.org
> To unsubscribe please visit:
> https://mail.kde.org/mailman/listinfo/koffice


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
____________________________________
koffice mailing list
koffice@mail.kde.org
To unsubscribe please visit:
https://mail.kde.org/mailman/listinfo/koffice
[prev in list] [next in list] [prev in thread] [next in thread]