Bug 126159

Summary: Arguments' names of AGGREGATE function can be simpler
Product: LibreOffice Reporter: So <sou>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: erack, xiscofauli
Priority: medium    
Version: 6.1.5.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108827    

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.