https://bugs.documentfoundation.org/show_bug.cgi?id=127808
--- Comment #17 from [email protected] --- (Sadly) not working in development. Just learned about dynamic arrays, spill and these functions today. Tested them in a Collabora/Nextcloud environment. Version: 26.04.2.4 (git hash: 2229109277 (E)) Served by: unknown Server ID: 8490F6CE WOPI host: nextcloud 34.0.2.1 - richdocuments 11.1.0 This what I found out: Dynamic array functions such as SEQUENCE(), UNIQUE() and FILTER(), HSTACK(), VSTACK() do exist (although I could not find any documentation exept in the function wizard) and they spill correctly compared to MS. However, the newer functional array functions MAP() and MAKEARRAY() behave differently: - entered normally, they return only the first element of the expected array - entered as a legacy array formula (Ctrl+Shift+Enter), they correctly populate the selected array range BUT they do not dynamically spill This suggests that Collabora/LibreOffice currently has three distinct behaviours: Native dynamic-array functions, e.g.: - SEQUENCE - FILTER - UNIQUE These spill automatically. Functional array functions e.g. - MAP - MAKEARRAY These compute arrays but require Ctrl-Shift-Enter to expose them and are NOT dynamic arrays e.g. something like this: {=MAKEARRAY(5;4;LAMBDA(x;y;x&" - "&y))} (braces through Ctrl-Shift-Enter) produces 1 - 1 1 - 2 1 - 3 1 - 4 2 - 1 2 - 2 2 - 3 2 - 4 3 - 1 3 - 2 3 - 3 3 - 4 4 - 1 4 - 2 4 - 3 4 - 4 5 - 1 5 - 2 5 - 3 5 - 4 but does not dynamically reshape the array if changing the 5;4 parameter The spill operator (e.g. =A1#) returns Err:509 - vs. Excel returning the (dynamic) array. Would be nice to have dynamic arrays also for MAP etc. and to have references to dynamic arrays.. Thanks Wolf -- You are receiving this mail because: You are the assignee for the bug.
