To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108228 Issue #|108228 Summary|conditional has negative sign when used in formula exp |ression Component|Word processor Version|OOo 3.1.1 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|writerneedsconfirm Reported by|jes
------- Additional comments from [email protected] Mon Jan 11 18:13:52 +0000 2010 ------- Formulas in Writer may use conditional expressions, which produce a boolean result. By convention, the true/false result is represented by the numeric values 1 and 0. This is also the case in a Writer if a formula contains a bare conditional expression: 1 eq 1 -> 1 1 eq 0 -> 0 However, if the conditional expression is used as part of a larger formula, and the conditional produces a true result, the conditional result has a negative sign in the larger expression, and causes incorrect results: 1*(1 eq 1) -> -1 (should be 1) 1-(1 eq 1) -> 2 (should be 0) Tested in OOo 3.2rc1, 3.1.1 and 2.4.2 on Fedora Linux 11. --------------------------------------------------------------------- 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]
