| Summary: | Improve help for working with Inline Array Constants in Formulas | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Ernesto Bosch <ernesto.bosch> |
| Component: | Documentation | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | olivier.hallot, rb.henschel |
| Priority: | medium | ||
| Version: | 6.3.3.2 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 80430 | ||
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.
Thanks Regina. Bst Rds. |
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.