To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85328
------- Additional comments from [EMAIL PROTECTED] Fri Nov 7 23:30:28 +0000 2008 ------- Indeed. The cells were probably formatted as text (and therefore would warrant INVALID), but... if it weren't for some inconsistencies I noted below: 1.) 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. 2.) Also, the missing apostrophe at the beginning of the text did mislead me. Changing the cell to a different type, does NOT evaluate the formula. It will still display the content as =..., without the apostrophe in the beginning (see cell A78). This clearly misleads one. 3.) 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 or as number? I would say, it is a number, but then why does Calc NOT also evaluate the formula? A lot of inconsistencies. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
