To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=5658
------- Additional comments from [EMAIL PROTECTED] Fri May 23 10:26:15 +0000
2008 -------
Just to put in my two pennies worth.
I use excel and I expect the Add formula to treat text as "0". I achieve this by
using the "Options > Transition > Transition Formula Evaluation" option in
Excel. This is not supported in OpenOffice. So now when I open an excel sheet in
OO it just says ERR 529 everywhere. Now I repeat, I use excel, I cannot view my
Excel sheets in OO, so I cannot use OO. Shame. The argument about whether text
should be treated as "0" or an error is a real dilemma, so the Excel method of
allowing the user to choose is quite a good one. One reason for my liking the
text as "0" method is that I can put comments into cells instead of using the
comment feature, the other is that a complex formula can also be treated as an
error e.g. "=IF('Sheet1'!R5<0,'Sheet1'!R5,"")".
At present I am using Gnumeric, which seems to handle this better, which is a
shame.
---------------------------------------------------------------------
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]
