source/text/scalc/01/func_aggregate.xhp | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 59f138dd11466e07ac0e615356f4ef36afee6ac2
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Tue May 16 14:44:50 2023 +0200
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed May 17 13:21:24 2023 +0200
Remove bad example
Change-Id: Ic6307c884458c0303f88d42e19b8a4f1c924c05b
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/151777
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/func_aggregate.xhp
b/source/text/scalc/01/func_aggregate.xhp
index a18f0b4765..9e33cf7ded 100644
--- a/source/text/scalc/01/func_aggregate.xhp
+++ b/source/text/scalc/01/func_aggregate.xhp
@@ -421,7 +421,7 @@
</tablerow>
</table>
-<paragraph id="par_id230920152006414" role="paragraph" xml-lang="en-US"><item
type="input">=AGGREGATE(4;2;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>
+<paragraph id="par_id230920152006414" role="paragraph" xml-lang="en-US"><item
type="input">=AGGREGATE(4;2;A2:A9)</item><br/>Returns maximum value for the
range A2:A9 = 34.</paragraph>
<paragraph id="par_id2309201520064180" role="paragraph" xml-lang="en-US"><item
type="input">=AGGREGATE(9;5;A5:C5)</item><br/>Returns sum for the range A5:C5 =
29, even if some of the columns are hidden.</paragraph>
<paragraph id="par_id2309201520064118" role="paragraph" xml-lang="en-US"><item
type="input">=AGGREGATE(9;5;B2:B9)</item><br/>Returns sum of the column B =
115. If any row is hidden, the function omit its value, for example if the 7th
row is hidden, the function returns 95.</paragraph>
<paragraph id="par_id196152404026557" role="paragraph" xml-lang="en-US">If you
need to apply the function with a 3D range, this example shows how to do
it.</paragraph>
