To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105161 Issue #|105161 Summary|reference operators ~ and ! have wrong precedence Component|Spreadsheet Version|DEV300m55 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|regina
------- Additional comments from [email protected] Thu Sep 17 22:08:40 +0000 2009 ------- According to spec ODF1.2 chapter 5.5 the intersection has a higher precedence than union. Therefore an expression like a~b!c should be calculated as a~(b!c) but it is calculated as (a~b)!c. According to chapter 6.3.12 the latter equals (a!c)~(b!c). The attached spreadsheet uses the INDEX function in array context to show which ranges are contained in the final multiple range result. _a, _b, _c are named ranges. --------------------------------------------------------------------- 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]
