Issue 118213

There seems to be something wrong in the attached spreadsheet. I get no values in column K and L, and E as well, and errors in column J.

It is not clear to me, what you try to calculate and why you need the formulas in array-version. Please try to provide a spreadsheet, where you explain your formulas. The German labels are not helpful for an international audience.

Created attachment 76637 [details]
Simplified example

for a row of payments, I try to calculate a period index and the corresponding date - depending on parameters (start date, duration, payment terms and due date).
1) the periode calculates well with a matrix formula in E3:E245
2) a normal formula calculates the date in F3:F245
3) I try to do the same with a matrix formula in G3:G245
   -> G3 and G35:G245 are calculated wrong
4) Tracking down the issue I simplify the normal formula in H3:H245
5) Now I do the same with a matrix formula in I3:I245
   -> the inner "IF" seems to override the rest of the formula
6) Nor I replace the inner "IF" with a "..." string in K3:K245
   -> it works, maybe only two IFs can be capsulated in a matrix formula
7) Doing the same with a normal formula in I3:I245
   -> instead of "..." it shows 0

7) error was usage of single instead of double quotes...
however, the matrix formula issues remain

I know array formulas are rather a question of taste - in this case I could use normal formulas, too. However, I prefer arrays to mark, which cells use the same formula and thus make calculations in the sheet more transparent and easier to maintain.

.

getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.

This Issue requires more information ('needmoreinfo'), but has not been updated
within the last year. Please provide feedback as requested and re-test with the the latest version of OpenOffice - the problem(s) may already be addressed. 

You can download Apache OpenOffice 3.4.1 from http://www.openoffice.org/download

Please report back the outcome of your testing, so this Issue may be closed or
progressed as necessary - otherwise the issue may be Resolved as Invalid in the
future.

Created attachment 80201 [details]
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)

Can not confirm comment 7

AOO410m1(Build:9750)  -  Rev. 1555399
2014-01-06_04:13:46 - Rev. 1555657
Debian

Created attachment 82278 [details]
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