Bug 99885 - Wrong example in the AGGREGATE function help
Summary: Wrong example in the AGGREGATE function help
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
5.2.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: target:5.3.0
Keywords:
Depends on:
Blocks:
 
Reported: 2016-05-16 16:15 UTC by Gabor Kelemen (allotropia)
Modified: 2016-09-17 15:22 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (allotropia) 2016-05-16 16:15:57 UTC 
in source/text/scalc/01/func_aggregate.xhp the example in this line has a mistake:

<paragraph id="par_id230920152006414" role="paragraph" xml-lang="en-US"><item type="input">=AGGREGATE(4;1;A2:A9)</item><br/>Returns maximum value for the range A2:A9 =34, whereas <item type="input">=MAX(A2:A9)</item> returns the error Err:511.</paragraph>

The second argument should be 2 instead of 1, as the option table above says 1 means "Ignore only hidden rows, nested SUBTOTAL and AGGREGATE functions". 
The example dataset does have errors, so one needs to use 2 as the second argument, meaning "Ignore only errors, nested SUBTOTAL and AGGREGATE functions".
Comment 1 Buovjaga 2016-05-18 07:19:42 UTC 
I believe you, so I set to NEW.
Comment 2 Commit Notification 2016-09-17 07:12:52 UTC 
Gabor Kelemen committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/help/commit/?id=f8d42fe73a9a27a17ee421ef63340ac41eeb2539

tdf#99885 Fix example on using the AGGREGATE function