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
- 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