Product: Spreadsheet
Type: new
Title: INDEX of vector needs just one offset parameter
Posted by: [EMAIL PROTECTED]
Affected: sc
TaskId: i78781
<http://www.openoffice.org/issues/show_bug.cgi?id=78781>
Effective from: cws odff03
CWS:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300/odff03
CWS status: new
*Flags*
-------
API/ BASIC [ ]
Configuration [ ]
File format change [ ]
Help/ Guide [ ]
Performance test [ ]
Translation [ ]
UI relevant [ ]
*Description*
-------------
The INDEX() spreadsheet function now returns an element of a vector
regardless of its orientation if just two parameters were given. The
general syntax for INDEX is:
INDEX( ReferenceList|Array DataSource ; [ Integer Row ] [ ; [ Integer
Column ] ] [ ; Integer AreaNumber = 1 ] )
If called as INDEX( vector; offset) the offset value now is taken as
an offset into vector, regardless of orientation. Vector can be a row
vector as well, so it looks as if the column offset was passed as a
row argument.
This aligns with the behavior of other spreadsheet applications and the
definition given in the OASIS ODFF/OpenFormula specification available at
http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula
Send feedback to [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
