Description:
Add new dynamic array's functions to Calc for interoperability with Excel


• FILTER - filters an array of data based on criteria you define.
https://support.office.com/article/f4f7cb66-82eb-4767-8f7c-4877ad80c759
• UNIQUE - returns a list of unique values from a list or range.
https://support.office.com/article/c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e
• SORT - sorts an array of values.
https://support.office.com/article/22f63bd0-ccc8-492f-953d-c20e8e44b86c
• SORTBY - sorts an array based on a corresponding array.
https://support.office.com/article/cd2d7a62-1b93-435c-b561-d6a35134f28f
• SEQUENCE - generates a list of sequential numbers, such as 1, 2, 3, 4.
https://support.office.com/article/57467a98-57e0-4817-9f14-2eb78519ca90
• SINGLE – accepts a range or array and returns a single value using implicit intersection.
https://support.office.com/article/7ca229ca-13ae-420b-928e-2ef52a3805ff
• RANDARRAY - returns an array of random numbers between 0 and 1.
https://support.office.com/article/21261e55-3bec-4885-86a6-8b0a47fd4d33



Steps to Reproduce:
-

Actual Results:
We don't have support for new dynamic array's functions from Excel in Calc

Expected Results:
We have support for new dynamic array's functions from Excel in Calc


Reproducible: Always


User Profile Reset: No



Additional Info:
-