To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82980
User er changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Mon Nov 19 11:23:48 +0000
2007 -------
This is a misunderstanding of the CURRENT() function. CURRENT() returns the
value of the formula at the position where CURRENT() is used. Each and every
calculation step changes this value. In the case of the first formula
(CURRENT()<60)*(CURRENT()>=50) the first CURRENT() returns 50 so the comparison
result is 1 (TRUE). The second CURRENT() returns the result of this operation
and the expression evaluates (1>=50) that never yields TRUE.
---------------------------------------------------------------------
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]
