Apache OpenOffice (AOO) Bugzilla – Issue 102980
Multiple Operations problem with OFFSET() function
Last modified: 2013-01-29 21:39:02 UTC
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.
Created attachment 63112 [details] Test case
I see the bug in DEV300m50 too. I'll attach another small example. Reading "MULTIPLE.OPERATIONS executes the formula expression pointed to by FormulaCell and all formula expressions it depends on while replacing all references to RowCell with references to RowReplacement respectively all references to ColumnCell with references to ColumnReplacement." in ODF1.2 draft spec, I think that it is an error, when adding a level of reference gives different results.
Created attachment 63115 [details] E11 and E12 should show the same result as B11 and B12 show the same result.
Raji Padmanabhan , 091709
Raji Padmanabhan, 091709 Could reproduce the bug as mentioned in the attachment 63112 [details] and 63115. The multiple operations does not work with the offset function. The offset function has to be removed for the multiple operations to be active as presented in the 2 attachment. Fixing this bug will be crucial, since the whole calculations can wrong, like a chain effect if the offset function produces incorrect results.
Raji Padmanabhan, 091709 Could reproduce the bug as mentioned in the attachment 63112 [details] and 63115 on Windows Vista in build 3.1 The multiple operations does not work with the offset function. The offset function has to be removed for the multiple operations to be active as presented in the 2 attachment. Fixing this bug will be crucial, since the whole calculations can wrong, like a chain effect if the offset function produces incorrect results.