To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102980 Issue #|102980 Summary|Multiple Operations problem with OFFSET() function Component|Spreadsheet Version|OOo 3.1 Platform|PC URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|ui Assigned to|spreadsheet Reported by|bhut_ooto
------- Additional comments from bhut_o...@openoffice.org Sun Jun 21 12:23:15 +0000 2009 ------- Attached is a spreadsheet that shows the following issue: * B11 := -(B7 - 0*OFFSET(B3;0;0;1)) * B15 := MULTIPLE.OPERATIONS(B11; $B$1; $C$1) * F11 := B11 * F15 := MULTIPLE.OPERATIONS(F11; $B$1; $C$1) One would expect that both B15 and F15 should have exactly the same value, but they don't. The value F15 matches F11, as if the MULTIPLE.OPERATIONS() function gave up. If you replace the value of B11 with the following: * B11 := -(B7 - 0) then the values of B15 and F15 will match again. One wouldn't expect there to be a difference because 0*OFFSET(...) should still resolve to 0. It appears that the presence of the OFFSET() function confuses MULTIPLE.OPERATIONS(). [This testcase may seem rather brain-dead, but it is a very stripped-down version of a real-case that is stopping my forward progress. In my version, I don't multiply OFFSET() by 0.] Although this was found on a PC under Vista, there is no reason to believe this bug will be restricted to that platform. --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
