<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Add array functions in Calc: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126573">bug 126573</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr>
<tr>
<td style="text-align:right;">Version</td>
<td>6.2.5.2 release
</td>
<td>unspecified
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEW
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Add array functions in Calc: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126573#c1">Comment # 1</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Add array functions in Calc: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126573">bug 126573</a>
from <span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span></b>
<pre>Note that those functions aren't fully specified yet, for example
<a href="https://support.office.com/en-us/article/RANDARRAY-function-21261e55-3bec-4885-86a6-8b0a47fd4d33">https://support.office.com/en-us/article/RANDARRAY-function-21261e55-3bec-4885-86a6-8b0a47fd4d33</a>
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>