
Type: Bug

Status: Applied

Priority: Major

Resolution: Fixed

Affects Version/s: ODF 1.2 Part 2 CD 1, ODF 1.2 Part 2 CD 2

Fix Version/s: ODF 1.2 CD 06

Component/s: OpenFormula

Labels:None

Proposal:

Resolution:
In Section 5.5.1, the use of array dimensions is reversed from the conventional order. That is, M x N is defined to mean, in OpenFormula, M columns and N rows, where the established notation is the reverse (M x N signifies M rows and N columns). Similarly, the subscripts a[i,j] (using subscript formatting) are taken to mean the element of matrix A at column i and row j. This is the reverse of the convention as well, where a[i,j] signifies the element in the ith row and jth column.
The consequence of this transposed approach to wellestablished matrix notation is that the definitions of common operations such as matrix multiplication in MMULT are clumsy and difficult to understand. There seems to be no useful purpose in this change of notation and it will just make the understanding, review, and correct implementation of matrixrelated functions prone to confusion and misunderstanding.