https://bugs.documentfoundation.org/show_bug.cgi?id=172003
--- Comment #5 from ady <[email protected]> --- I am not sure I understand the problem. The functions CHOOSECOLS() and FILTER() take an array (aka "matrix") as argument, so they are array functions. Therefore, in Calc (which, at the time I am writing, does not support so-called "dynamic formulas"), it would be natural to have the curly brackets in the formula bar input window for these functions. If there is anything not working as expected with these functions, the first suggestion would be to actually use [CTRL]+[SHIFT]+[ENTER], instead of just [ENTER]. As for pasting these functions, I would suggest reviewing the arguments used, and that the specific area that is needed for the functions to show the resulting array would not be occupied, so the resulting array (whichever its size) can be completely shown. I guess that I don't really understand the "expected result" vs the "actual result" of this report. -- You are receiving this mail because: You are the assignee for the bug.
