# OpenFormula 5.5.1 Array Notation flaunts convention

XMLWordPrintable

#### Details

• 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:
• Component/s:
• Labels:
None
• Proposal:
Hide

Use the widely-adopted and routinely-understood notation for matrices when speaking of dimensionality (M x N) and when identifying elements of matrices by subscripts. Also, use the conventional 1-origin numbering for subscript values in agreement with mathematical practice.

Show
Use the widely-adopted and routinely-understood notation for matrices when speaking of dimensionality (M x N) and when identifying elements of matrices by subscripts. Also, use the conventional 1-origin numbering for subscript values in agreement with mathematical practice.
• Resolution:
Show
Make the changes as highlighted in the attachment to http://www.oasis-open.org/apps/org/workgroup/office/email/archives/201009/msg00132.html

#### Description

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.

#### People

• Assignee:
Andreas Guelzow (Inactive)
Reporter:
Dennis Hamilton (Inactive)
• Watchers:
0 Start watching this issue

#### Dates

• Created:
Updated:
Resolved: