Hello,
Regina Henschel wrote:
Hi Leonard,
Leonard Mada schrieb:
Dear develoeprs,
Please have a look at iisue 85328:
http://www.openoffice.org/issues/show_bug.cgi?id=85328
Formulas entered into column A will be interpreted as text. This is a
very strange behaviour. I do not have the underlying file that
started the problem and I did not encounter this problem any more,
BUT it might point to some Calc underlying problem. Please note that
the problem persists after resaving. So, I would like to have a
developer look into the troubled file to exclude any serious flaw/error.
People tend to hastily close the issue as WONTFIX.
The whole column A is set to cell format "text".
Indeed. Though I was sure that Auto-number recognition and Auto-formula
recognition has always precedence. Strange. Also, the formula
autocompletion is activated, although the resulting entry is a text
string. Even entering a function using the fx button keeps the resulting
entry as a text string, and doesn't evaluate to a function. I would say
that this last "feature" is definitely a bug.
Also, the missing apostrophe at the beginning of the text did mislead
me. Also, changing the cell to a different type, does NOT evaluate the
formula. It will be still displayed as =..., without the apostrophe in
the beginning (see cell A78). This clearly misleads one.
And this makes Calc very inconsistent: SUM() will evaluate these
text-numbers!!! But it doesn't evaluate numbers entered as '1.
Therefore, is the 1 entered as text now text or number?
Sincerely,
Leonard
Therefore, when you enter or alter cell content it will be treated as
text. Only cell content that was already inside the cells when you
have changed the format of the column, while preserve its own format -
as long as you do not alter it.
For me it is a "worksforme".
Kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
