Bug 130212 - Improve help for working with Inline Array Constants in Formulas
Summary: Improve help for working with Inline Array Constants in Formulas
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: HelpGaps-NewFeatures
  Show dependency treegraph
Reported: 2020-01-27 04:50 UTC by Ernesto Bosch
Modified: 2020-07-16 13:34 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Ernesto Bosch 2020-01-27 04:50:59 UTC
When inserting ={1;2|3;4} instead of getting a 2x2 matrix a column vector of 4x1 as ={1;2;3;4} is obtained.

In different words: if working as in https://help.libreoffice.org/Calc/Array_Functions#Using_Inline_Array_Constants_in_Formulas is explained wrong answer is obtained.
Comment 1 Regina Henschel 2020-01-27 15:44:15 UTC
Please have a look at the settings in Tools > Options > Calc > Formula, section "Separators".
To enter it as ={1;2|3;4} you need the settings
Array column ;
Array row    |

The help has the text
The column separator (separating elements in one row) and the row separator are language and locale dependent. But in this help content, the ';' semicolon and '|' pipe symbol are used to indicate the column and row separators, respectively. For example, in the English locale, the ',' comma is used as the column separator, while the ';' semicolon is used as the row separator.

The help misses the above mentioned settings. Therefore I put this as bug in documentation. The feature itself works without problem.
Comment 2 Ernesto Bosch 2020-03-05 21:10:34 UTC
Thanks Regina. Bst Rds.