[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


       Product: Spreadsheet
          Type: new
         Title: Repeat vectors if used in 2D array
     Posted by: [hidden email]
      Affected: sc
         TaskId: i46681
Effective from: cws odff05
    CWS status: new

Configuration [ ]
File format change [ ]
Help/ Guide [x]
Performance test [ ]
Translation [ ]
UI relevant [ ]

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


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

This change aligns with the behavior of other spreadsheet applications and
the definition given in the OASIS ODFF/OpenFormula specification available at

Send feedback to [hidden email]

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