Issue 98232 - Calc Help: Repeat vectors if used in 2D array
Summary: Calc Help: Repeat vectors if used in 2D array
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: documentation
Classification: Unclassified
Component: Online help (show other issues)
Version: current
Hardware: All All
: P3 Trivial (vote)
Target Milestone: AOO PleaseHelp
Assignee: Uwe Fischer
QA Contact: issues@documentation
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-01-19 11:01 UTC by Uwe Fischer
Modified: 2009-02-11 09:07 UTC (History)
1 user (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Uwe Fischer 2009-01-19 11:01:33 UTC 
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
Comment 1 Uwe Fischer 2009-02-11 09:07:15 UTC 
The feature aligns Calc with other spreadsheet applications to work as
intuitively expected by the user. As we did not document the former Calc
pecularities, we don't need to document that they are no longer existent.
The behavior is quite complex to explain (needs extended example data with some
video guidance of actions, without example this is not understandable for a
normal human being).
Would suggest to document this with media on the OOo Wiki later.
Comment 2 Uwe Fischer 2009-02-11 09:07:38 UTC 
closed