Bug 126159 - Arguments' names of AGGREGATE function can be simpler
Summary: Arguments' names of AGGREGATE function can be simpler
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.5.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
 
Reported: 2019-06-29 12:34 UTC by So
Modified: 2020-08-13 19:30 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description So 2019-06-29 12:34:24 UTC
The fourth and latter arguments of AGGREGATE() have the same summary:
the cells of the range which are to be taken into account or mandatory 2nd argument for certain functions.
And, m-th (m>=4) argument is named "Reference 2..n or k (m-3)."

But what might be "mandatory 2nd argument" is only the fourth.

So, the fourth argument can be "Reference 2 or k".
The m-th (m>=5) can be "Reference (m-2)" or "Reference 3..n (m-4)."
Comment 1 Xisco Faulí 2019-11-15 11:33:29 UTC
@Eike, I thought you might be interested in this...
Comment 2 Eike Rathke 2019-11-15 13:01:14 UTC
The problem is, the argument of the 4th, 6th, ... parameter depends on the function selected with the 1st argument. While for AVERAGE(), COUNT(), ... each argument is an independent cell range reference or array, for the LARGE(), SMALL(), ... functions every second argument is a number or array (or reference of course) that determines the operation of the function on the previous argument and for those functions is mandatory.

However, I agree the wording "Reference 2..n or k3" and so on is slightly confusing (fwiw, I don't see any "(m-3)" or such there), but I don't have any better atm. Further problem is, the numbers are generated and there is no distinction whether it should be "Reference 2, Reference 3, ..." or "Reference 2, k2, Reference 3, k3, ...", the dialog does not know, it has to be a string that can be applied to all parameters.
Comment 3 So 2020-02-20 06:45:00 UTC
(In reply to Eike Rathke from comment #2)
> for the
> LARGE(), SMALL(), ... functions every second argument is a number or array
> (or reference of course) that determines the operation of the function on
> the previous argument and for those functions is mandatory.
These functions accept only a single pair.
Two types of usages are;
AGGREGATE(Function, Option, Reference 1, Reference 2, Reference 3,...) and
AGGREGATE(Function, Option, Array, k).
Combining them,
AGGREGATE(Function, Option, Reference 1 or array, Reference 2 or k, Reference 3..n 1, Reference 3..n 2,...) should be fine.