Bug 108087 - EDITING: Inline Array Constants: multi column arrays not possible
Summary: EDITING: Inline Array Constants: multi column arrays not possible
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2017-05-25 16:11 UTC by soulsearchingsun83
Modified: 2017-05-25 20:04 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
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 build 3d9a8b on Windows 7 x64
Reproduced on 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.