[Libreoffice-bugs] [Bug 127809] New: Add new dynamic array's functions to Calc for interoperability with Excel

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=127809

            Bug ID: 127809
           Summary: Add new dynamic array's functions to Calc for
                    interoperability with Excel
           Product: LibreOffice
           Version: 6.4.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: 79045_79045 at mail.ru

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:
-

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190927/38ac74d0/attachment-0001.html>