-
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 i-th row and j-th column.
The consequence of this transposed approach to well-established 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 matrix-related functions prone to confusion and misunderstanding.