https://bugs.documentfoundation.org/show_bug.cgi?id=154552
Bug ID: 154552
Summary: The example of the array formula is not appropriate
for Version7.4 or later.
Product: LibreOffice
Version: 7.4.0.3 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Documentation
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Description:
The example of the array formula is not appropriate for Version7.4 or later.
Steps to Reproduce:
1. Open a new Calc.
2. Select cell [A1]
2. Input the formula ={1;2;3} (This is the 1st sample in Help)
3. Push Enter key (or Return key)
Actual Results:
4. Create a matrix (Automatically)
Expected Results:
4. Cell [A1] = 1 (Do not create matrix)
Reproducible: Always
User Profile Reset: No
Additional Info:
In the case of a very simple array formula, in Version7.4 or later, the matrix
is automatically output without the operation of [Ctrl + Shift + ENTER].
Therefore, the example of help has become inappropriate.
To avoid confusion, you need to change the example.
https://help.libreoffice.org/7.5/en-US/text/scalc/01/04060107.html
Using Inline Array Constants in Formulas
Examples:
={1;2;3}
={1;2;3|4;5;6}
={0;1;2|FALSE;TRUE;"two"}
=SIN({1;2;3})
---
Other exsamples of array formula
=ROW(1:3)*TRANSPOSE(ROW(1:3)) -> Automatically
=ROW(1:3)*TRANSPOSE(CURRENT()) -> Automatically
=ROW(1:3)*COLUMN(A:C) -> Need [ Ctrl + Shift + Enter ]
=ROW(1:3)+ROW(1:3) -> Need [ Ctrl + Shift + Enter ]
=ROW(1:3)+CURRENT() -> Need [ Ctrl + Shift + Enter ]
Version: 7.5.2.2 (X86_64) / LibreOffice Community
Build ID: 53bb9681a964705cf672590721dbc85eb4d0c3a2
CPU threads: 4; OS: Windows 10.0 Build 10240; UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
