https://bugs.documentfoundation.org/show_bug.cgi?id=127808
--- Comment #22 from [email protected] --- (In reply to ady from comment #20) > (In reply to wolf from comment #17) > > > 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. > > What happens when you modify the array (size) after the first run of those > functions in LO Calc? > > I mean, some functions have been added to Calc, but that does not mean that > all the features related to "dynamic arrays" are already supported for those > functions. Just to be clear - not using LO "native" but via Collabora.. e.g. =SEQUENCE(3;5;17;5) changing the any of the first two arguments will properly adapt to the newly specified size - i.e. if necessary cells that have been filled before clear out, new cells are filled. Having this in M1:N15 A 1 A 2 B 3 B 4 C 2 C 4 C 6 D 4 E 2 F 5 F 6 F 4 G 3 H 2 I 1 then =UNIQUE(M1:M15) will show A - I in the cells, when changing the formula such that the reference doesn't include the "I" to =UNIQUE(M1:M14) then only A - H will show (the cell that previously showed "I" is cleared. =FILTER(N1:N15;M1:M15="C";"-") shows 2 4 6 if I change the first "C" in the base table M1:N15 to "B" then the reuslt automatically changes to 4 6 and the third cell is cleared. Non-dynamic (as expected when entered with CSE): {=MAKEARRAY(5;6;LAMBDA(x;y;x&" - "&y))} when changing the dismension parameter and submitting via CSE then I get an Information pop-up "You cannot change only part of an array" and nothing changes - edits are gone. Hope this does answer your question! regards Wolf -- You are receiving this mail because: You are the assignee for the bug.
