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
Created attachment 193834 [details] sample file
Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: ea43cbbb7371a743f470d949762a0e92f196e652 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (es_AR); UI: en-US Calc: CL threaded _My_ settings are probably not typical: * Array Row separator: semicolon (";") * Array Column separator: vertical bar ("|" hex 7c, dec 124) 1. A1: ={1;2;3} [ENTER] 1.1. Array result: A1: 1 A2: 2 A3: 3 2. Select A1:A3 (the whole array). 3. Expand the array to add one row, A1:A4. 3.1. Array result: A1: 1 A2: 1 A3: 1 A4: 1 4. Expand the array to add one row, A1:A5. 4.1. Array result: A1: 1 A2: 2 A3: 3 A4: #N/A A5: #N/A 5. Expand the array to add _two_ rows, A1:A7. 5.1. Array result: A1: 1 A2: 1 A3: 1 A4: 1 A5: 1 A6: 1 A7: 1 6. Expand the array to add one row, A1:A8 4.1. Array result: A1: 1 A2: 2 A3: 3 A4: #N/A A5: #N/A A6: #N/A A7: #N/A A8: #N/A I can even reduce the size of the array; the amount of rows (plus or minus) are not a factor. The factor is: one time I get "ones", the next time I get the original array plus #N/A (as much as needed to fulfill the new size of the array), and then the cycle repeats. I can also replicate this cycle when expanding the array from rows to multiple columns. The difference is that the "ones" are expanded to "twos", and so on (according to number of columns) and then #N/A's and then the cycle repeats.
(In reply to ady from comment #2) > _My_ settings are probably not typical: > > * Array Row separator: semicolon (";") > * Array Column separator: vertical bar ("|" hex 7c, dec 124) > > > 1. A1: ={1;2;3} [ENTER] Of course that for older versions, the introduction of the array (formula) needs to be performed by [CTRL]+[SHIFT]+[ENTER] (instead of the sole [ENTER]). In newer versions, Calc automatically recognizes this as an array even when only using [ENTER]. When using CSE, I can reproduce the same behavior I described in comment 2 with LO 3.3 too. Before setting this report to "inherited", I would rather have confirmation that what I described in comment 2 is indeed the same problem that is (apparently) reported in comment 0 (because I am not sure, considering the differences in my results).