To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=91049
User fst changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Wed Jun 25 11:41:52 +0000
2008 -------
Hi,
it seems to me that you're comparing Apples and Peas. I suppose the Linux
Version you've checked is from your Distributors repositorys and not the
original one from OpenOffice.org.
But that's not the root cause.
Calc does not calculate with Strings. Your IF Statement in cells F2 and G2
returns Strings as the result. Just remove the quotes covering the numbers and
you get the desired results. You may otherwise consider to make these text
values numeric values by using the VALUE function like
=IF(E2="";"";VALUE(E2)+VALUE(F2)+VALUE(G2))
Frank
---------------------------------------------------------------------
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]
