Bug 108087

Summary: EDITING: Inline Array Constants: multi column arrays not possible
Product: LibreOffice Reporter: soulsearchingsun83
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: CLOSED WORKSFORME    
Severity: normal CC: rb.henschel
Priority: medium    
Version: 5.3.3.2 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:

Description soulsearchingsun83 2017-05-25 16:11:56 UTC 
Entering array constants with multiple columns is not possible for me.

The examples from https://help.libreoffice.org/Calc/Array_Functions:

={1;2;3} should result in "An array with one row consisting of the three numbers 1, 2, and 3" but results in an array with one column and three rows with the values 1, 2 and 3 instead.

={1;2;3|4;5;6} should result in "An array with two rows and three values in each row." For me this gets automatically converted to ={1;2;3;4;5;6} without notice and results in a one column six row array.

German localization if that matters.

First noticed on 5.3.3.2 build 3d9a8b on Windows 7 x64
Reproduced on 4.8.2.8 build 420m0(Build:2) on Ubuntu 14.04.2

I can provide more information if needed.
Comment 1 Regina Henschel 2017-05-25 18:50:52 UTC 
(In reply to soulsearchingsun83 from comment #0)
> German localization if that matters.

Yes, that matters. Go to Extras > Optionen > Calc > Formel. Find the delimiters in section "Trennzeichen". You can alter them to your needs there.
Comment 2 soulsearchingsun83 2017-05-25 19:10:08 UTC 
Thank you, that did the job. Seems I didn't read the preface on the german wiki page https://help.libreoffice.org/Calc/Array_Functions/de where this is stated. One could argue about highlighting this important info so that it stands out more.

Anyways, sorry for the noise!
Comment 3 Regina Henschel 2017-05-25 20:04:23 UTC 
I have written bug 1088090 for the request to improve the help to give more information about the separators in inline array. I close this report.