[Libreoffice-bugs] [Bug 126573] Add array functions in Calc: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
            Version|6.2.5.2 release             |unspecified
             Status|UNCONFIRMED                 |NEW

--- Comment #1 from Eike Rathke <erack at redhat.com> ---
Note that those functions aren't fully specified yet, for example
https://support.office.com/en-us/article/RANDARRAY-function-21261e55-3bec-4885-86a6-8b0a47fd4d33
says:

Note: January 14, 2019: The RANDARRAY function is one of several beta features,
and currently only available to a portion of Office Insiders at this time.
We'll continue to optimize these features over the next several months. When
they're ready, we'll release them to all Office Insiders, and Office 365
subscribers.


Also, it needs to be investigated how the spilling situations are actually
handled and what happens if due to recalculation the return array size varies.
This is not just new spreadsheet functions but a new behaviour that calculating
a function can change spreadsheet content.

Also restrictions like such formula can be edited only at the top left of its
array need to be implemented, though we maybe could handle that differently as
long as the edited formula affects the range as if it was edited at the top
left. Our current array formula display/edit behaviour already is somewhat
similar.

-- 
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/20190805/badae817/attachment.html>