https://bugs.documentfoundation.org/show_bug.cgi?id=170154
--- Comment #5 from george <[email protected]> --- (In reply to m_a_riosv from comment #4) > No issue for me. > Version: 25.8.4.2 (X86_64) > Build ID: 290daaa01b999472f0c7a3890eb6a550fd74c6df > CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; > VCL: win > Locale: es-ES (es_ES); UI: en-US > Calc: CL threaded > > Go to C1 > [Ctrl]+/ to select the whole array. > [F2] or Click on formula bar. > Modify the formula, e.g. change the range. > [Ctrl+Shift+Enter] to introduce the array again. OK.... I see... the [Ctrl+Shift+Enter] was the missing piece for me. However, this process is far from intuitive. Modern software like Google Sheets or Excel allows you to simply edit the top-left cell and press Enter to see the array update automatically via "spilling." Given that it is now 2025, maintaining this Legacy Array requirement feels like a significant usability barrier for the average user. We should prioritize moving toward Dynamic Array behavior to ensure Calc remains competitive and intuitive. -- You are receiving this mail because: You are the assignee for the bug.
