https://bugs.documentfoundation.org/show_bug.cgi?id=160804
Bug ID: 160804
Summary: If the separator is different from the standard
locale, stretching the determinant with the fill
handle will change the separator and result in a
different formula
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
If the separator is different from the standard locale, stretching the
determinant with the fill handle will change the separator and result in a
different formula.
Steps to Reproduce:
1. Open new calc
2. Input "={1|2|3}" in [A1]
("={1;2;3}" in Japan-Locale)
3. [A1, A2, A3] -> [1, 2, 3]
4. Select Matrix [ Ctrl + / ]
5. Expand Matrix to Row-5 with Fill-Handle (small icon in Help Page).
Actual Results:
in Japan Locale
6. [A1 ... A5] are All [ 1 ]
(Array Formula is Changed to "={1,2,3}" in Japan-Locale)
Expected Results:
in English Locale
6. [A1 ... A5] are [ 1, 2, 3, #N/A, #N/A ]
Reproducible: Always
User Profile Reset: No
Additional Info:
[Help pages related to this]
Adjusting an Array Range
https://help.libreoffice.org/latest/en-US/text/scalc/01/04060107.html?#hd_id3154834
Reproducible with
Version: 7.3.7.2 (x64) / LibreOffice Community
Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f
CPU threads: 4; OS: Windows 10.0 Build 10240; UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: CL
Reproducible with
Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: d76f1877f699c91f5e4a020641c6d65064bfb997
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
--
You are receiving this mail because:
You are the assignee for the bug.
