<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:winfrieddonkers@libreoffice.org" title="Winfried Donkers <winfrieddonkers@libreoffice.org>"> <span class="fn">Winfried Donkers</span></a>
</span> changed
<a class="bz_bug_link
bz_status_ASSIGNED "
title="ASSIGNED - CALC doesn’t detect an invalid entry for references in AGGREGATE and SUBTOTAL functions"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125272">bug 125272</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;">Assignee</td>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
<td>winfrieddonkers@libreoffice.org
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>REOPENED
</td>
<td>ASSIGNED
</td>
</tr>
<tr>
<td style="text-align:right;">Summary</td>
<td>CALC doesn’t detect an invalid entry for references in the aggregate function
</td>
<td>CALC doesn’t detect an invalid entry for references in AGGREGATE and SUBTOTAL functions
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_ASSIGNED "
title="ASSIGNED - CALC doesn’t detect an invalid entry for references in AGGREGATE and SUBTOTAL functions"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125272#c4">Comment # 4</a>
on <a class="bz_bug_link
bz_status_ASSIGNED "
title="ASSIGNED - CALC doesn’t detect an invalid entry for references in AGGREGATE and SUBTOTAL functions"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125272">bug 125272</a>
from <span class="vcard"><a class="email" href="mailto:winfrieddonkers@libreoffice.org" title="Winfried Donkers <winfrieddonkers@libreoffice.org>"> <span class="fn">Winfried Donkers</span></a>
</span></b>
<pre>(In reply to Djaafar Benchikh from <a href="show_bug.cgi?id=125272#c3">comment #3</a>)
<span class="quote">> the correct format of references is like A1, A2, B1, B2. while in CALC the
> aggregate function gives a result for an incorrect format of references
>
> aggregate(2,4,A1,A5) correcte format
> aggregate(2,4,1,1) incorrect format</span >
Ok, I wrongly interpreted the description of the function in Excel, which says
that argument 3...n represents a numerical value and only the name of the
argument (ref1...refx) suggests that the argument ought to be a reference and
not a numerical value.
I managed to use a computer with Excel and indeed, Excel does not accept
numerical values as arguments.
And as Calc's AGGREGATE is to be fully interoperable with Excel, it will be
necessary to reduce the functionality of AGGREGATE in Calc. Always a pity if
functionality is to be reduced.
The same applies for SUBTOTAL, I changed the bug report's title to reflect
this.
I'll start 'fixing'.</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>