diff options
| author | Gabor Kelemen <kelemeng@gnome.hu> | 2016-09-15 22:13:44 +0200 |
|---|---|---|
| committer | jan iversen <jani@documentfoundation.org> | 2016-09-17 07:12:15 +0000 |
| commit | f8d42fe73a9a27a17ee421ef63340ac41eeb2539 (patch) | |
| tree | a490c21de25832785ce3cf9ef7848608e9aaf3bf /source/text/scalc/01/func_aggregate.xhp | |
| parent | rename "Graphics cache" to "Image cache" (diff) | |
| download | help-f8d42fe73a9a27a17ee421ef63340ac41eeb2539.tar.gz help-f8d42fe73a9a27a17ee421ef63340ac41eeb2539.zip | |
tdf#99885 Fix example on using the AGGREGATE function
Change-Id: I27b783c937c7ad44839803f3fd7810a4d03a3d87
Reviewed-on: https://gerrit.libreoffice.org/28936
Reviewed-by: jan iversen <jani@documentfoundation.org>
Tested-by: jan iversen <jani@documentfoundation.org>
Diffstat (limited to 'source/text/scalc/01/func_aggregate.xhp')
| -rw-r--r-- | source/text/scalc/01/func_aggregate.xhp | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/source/text/scalc/01/func_aggregate.xhp b/source/text/scalc/01/func_aggregate.xhp index a846bee0d7..25206075fb 100644 --- a/source/text/scalc/01/func_aggregate.xhp +++ b/source/text/scalc/01/func_aggregate.xhp @@ -427,7 +427,7 @@ </tablerow> </table> -<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> +<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_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 3-D range, this example shows how to do it.</paragraph> @@ -441,4 +441,4 @@ </section> </body> -</helpdocument>
\ No newline at end of file +</helpdocument> |