Bug 154552 - The example of the array formula is not appropriate for Version7.4 or later.
Summary: The example of the array formula is not appropriate for Version7.4 or later.
Status: CLOSED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
7.4.0.3 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-04-02 00:21 UTC by nobu
Modified: 2024-04-27 06:19 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description nobu 2023-04-02 00:21:24 UTC
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
Comment 1 fpy 2024-03-11 21:56:02 UTC
- your report addresses *Constant* arrays, right ?

- is '|' still supposed to work ?
(no diffrence with ';' on my 7.6.5.2 linux)

- what is "selecting/marking a single cell"

Automatic cell matrix expansion for formula expressions that return an array/matrix. For formula expressions entered into a cell that obviously return an array/matrix, the result cell range is expanded as if ⇧ Shift + Ctrl + ↵ Enter was used to close an array formula. The previous behaviour of only one cell being used to display only the top left element can still be forced by selecting/marking a single cell prior to input. tdf#149378 (Eike Rathke, Red Hat)

For reference :
https://wiki.documentfoundation.org/ReleaseNotes/7.4#Calc