https://bugs.documentfoundation.org/show_bug.cgi?id=173668
Bug ID: 173668
Summary: New Calc function ARRAYTOTEXT uses delimiter that is
decimal point in some languages
Product: LibreOffice
Version: 27.2.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
LibreOffice 27.2 implements several new Calc functions (which already exist in
M$ Excel), among them ARRAYTOTEXT. This function takes as input an array / a
range from a spreadsheet, and converts it to a text string.
This is fine, except that ARRAYTOTEXT uses comma (,) to separate columns. In
languages like Danish and German, comma is the decimal point. For instance, the
number pi is written as 3,1415..., not as 3.1415... This makes the division
ambiguous. In fact, M$ Excel does not use comma, but semicolon as separator
(and \ as separator between rows when the strict format is used).
The help system description can be found here:
https://help.libreoffice.org/27.2/en-US/text/scalc/01/func_array2text.html
Steps to Reproduce:
1. Install the LibreOffice at least 27.2, at time of writing this is the Master
version. See https://www.libreoffice.org/download-other/ for download
possibilities.
2. Open file from the following comment in LO at least 27.2. The file contains
the example matrix from the help system and uses of ARRAYTOTEXT with both
possibilities for the format parameter.
3. Note use of comma to separate entries.
4. Close Calc
5. Change your system setup for number format to a location where comma (,) is
the decimal sign, e.g. German number format and Germany as location (or Danish
and Denmark).
6. Open the file again.
Actual Results:
With German or Danish (or similar) setup, comma in the result can be delimiter
or it can be decimal point, i.e., the meaning is ambiguous.
Expected Results:
The result should be unambiguous, especially in strict format. For example by
using semicolon (;) as delimiter, and \ as row delimiter (strict format).
Reproducible: Always
User Profile Reset: No
Additional Info:
Tested with this version:
Version: 27.2.0.0.alpha0+ (X86_64)
Build ID: caa93e03abb4966d072af53208e81c41f2e3cb77
CPU threads: 20; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster;
VCL: win
Locale: da-DK (da_DK); UI: da-DK
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
