[sc-features] new/cws odff05 : Repeat vectors if used in 2D array

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[sc-features] new/cws odff05 : Repeat vectors if used in 2D array

eike.rathke


       Product: Spreadsheet
          Type: new
         Title: Repeat vectors if used in 2D array
     Posted by: [hidden email]
      Affected: sc
         TaskId: i46681
<http://www.openoffice.org/issues/show_bug.cgi?id=46681>
Effective from: cws odff05
           CWS:
<http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300/odff05>
    CWS status: new


*Flags*
-------
API/ BASIC [ ]
Configuration [ ]
File format change [ ]
Help/ Guide [x]
Performance test [ ]
Translation [ ]
UI relevant [ ]


*Description*
-------------
A column or row vector is now replicated if used in an array formula
such that a 2D matrix is required by an operation but only a vector was
given. For example, the formula

={1;2;3}

entered as a matrix formula in a range selection of 3 columns by 2 rows
results in two rows with values 1 2 3 each.

This works also in not so trivial cases,
http://qa.openoffice.org/issues/show_bug.cgi?id=46681 mentions a few use
cases.

This change 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 [hidden email]



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]