https://bugs.documentfoundation.org/show_bug.cgi?id=160804
--- Comment #2 from ady <[email protected]> --- 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. -- You are receiving this mail because: You are the assignee for the bug.
