More Array Formulas

[BrianHung]

Hi, I'm considering useArrayArithmetic: true and one of the things I noticed is that there aren't that many array formulas: https://hyperformula.handsontable.com/guide/built-in-functions.html#array-manipulation

I looked up a list of array formulas that excel has

UNIQUE - extracts unique items from a range of cells.
FILTER - filters data based in the criteria you define.
SORT - sorts a range of cells by a specified column.
SORTBY - sorts a range of cells by another range or array.
RANDARRAY - generates an array of random numbers.
SEQUENCE - generates a list of sequential numbers.
TEXTSPLIT - splits strings by a specified delimiter across columns or/and rows.
TOCOL - convert an array or range to a single column.
TOROW - transform a range or array into a single row.
WRAPCOLS - converts a row or column into a 2D array based on the specified number of values per row.
WRAPROWS - re-shapes a row or column into a 2D array based on the specified number of values per column.
TAKE - extracts a specified number of contiguous rows or columns from the start or end of an array.
DROP - removes a certain number of rows or columns from an array.
EXPAND - grow an array to the specified number of rows and columns.
CHOOSECOLS - returns the specified columns from an array.
CHOOSEROWS - extracts the specified rows from an array.

Are there any plans on implementing these in the near term? If not, I might try to implement them as custom plugins and then submit a PR. Thanks!

[adrianszymanski89]

Hi @BrianHung

Currently, we don't have plans on implementing those formulas, but if you would like to prepare a PR, that would be great.