https://issues.apache.org/ooo/show_bug.cgi?id=118213
risch <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #76637|0 |1 is obsolete| | --- Comment #7 from risch <[email protected]> --- Created attachment 80201 --> https://issues.apache.org/ooo/attachment.cgi?id=80201&action=edit further simplified example I tested with OOo v3.4 but the issue remains: When capsulating more than two "IF" clauses in a matrix formula, the outer "IF" clauses are not interpreted. Task: The rox should return empty if the corresponding E3:E425 row is empty. Example with two capsulated IF-clauses: G3:G425 (matrix) behaves like F3:F425 (non-matrix). -> no problem Example with three capsulated IF-clauses: I3:I425 (matrix) assumes all IF-clauses to be false and always returns the false part of the inner IF clause -> this is a matrix bug as if does not happen with normal formula (H3:H425) or in a matrix with only two capsulated IF claused (G3:G425) -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug.
