https://bugs.documentfoundation.org/show_bug.cgi?id=99885
Bug ID: 99885
Summary: Wrong example in the AGGREGATE function help
Product: LibreOffice
Version: 5.2.0.0.alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Documentation
Assignee: [email protected]
Reporter: [email protected]
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".
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
