https://issues.apache.org/ooo/show_bug.cgi?id=118213
Prosper Uniger <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #9 from Prosper Uniger <[email protected]> --- Created attachment 82278 --> https://issues.apache.org/ooo/attachment.cgi?id=82278&action=edit matrix formulas with encapsulated matrix and plain formulas I recreated the test case from risch with simple data the structure of the matrix formula in column F has the same structure as risch's test case there is an underlying problem which is shown in column D the whole case is a bit dubious because there is a mix of matrix and plain formulas { =IF(matrixA=X; A; B) } works - column B { =IF(valueA=X; A; B) } works - column C { =IF(matrixA=X; A; IF(matrixB=Y; B; C)) } works - column E { =IF(matrixA=X; A; IF(valueA=Y; B; C)) } doesn't work - column D - value depends on the result of the last comparison in matrixA (try changing A12 to 2 or 3) column F is a mix of both cases with a whole different result maybe warn users if they mix matrix with plain formulas might be a good idea because this logical error is easily overlooked -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
