To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52584 Issue #:|52584 Summary:|Logical IF function misinterprets unary minus |operator Component:|Spreadsheet Version:|680m119 Platform:|All URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|ui Assigned to:|spreadsheet Reported by:|wa1ter
------- Additional comments from [EMAIL PROTECTED] Thu Jul 28 09:51:01 -0700 2005 ------- Try this experiment: IF(2=1; 1; -1) The result in 1.9.119 will be 'TRUE' instead of -1. However, if you replace the test 2=1 with the value FALSE, the result will be -1 as intended. This bug is not present in 1.1.4. I have build 119 installed only on Windows -- I haven't tried the linux version. --------------------------------------------------------------------- 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]