Hi Leonard,
Leonard Mada schrieb:
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.
No, it has been a design decision, that if the cell has got a special
format, this format will be used for entered or altered content. I use
this for example, when I paste English written numbers into a German
spreadsheet. I format the cell to English and after that paste the
English number.
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.
Enable View > Value Highlighting. Now text is shown black, numbers are
blue and formulas are green. The apostrophe is only needed to tread a
number or formula as text in cells, which ave not got a "text"-format
before you enter the content.
And that is the other design decision, that if the cell format is
changed from text to some number format or the other way round from a
number format to text, then existing content will not be changed.
And this makes Calc very inconsistent: SUM() will evaluate these
text-numbers!!!
No, they are real numbers, what you see under value highlighting.
But it doesn't evaluate numbers entered as '1.
Therefore, is the 1 entered as text now text or number?
If you first format the cell to "text" and then enter a 1, it will
become text. But if you first enter a number 1 into a cell with
"Standard"-format, it will become a number. And it will stay to be a
number if you afterwards format the cell to "text". But if you reenter
the cell and change something, for example adjoin a 2 for to get a 12,
then it will be converted to text.
I only describe how Calc currently works, I do not say that this is the
best way to handle data types. Perhaps an additional option "convert to
number" or "convert to text" or "convert existing content to the
determined format" is needed.
kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
