diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2018-02-20 17:44:18 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2018-02-20 21:46:35 +0100 |
| commit | 810e6f87237633190dd9a674abe8a1177025cf1f (patch) | |
| tree | 7f54e762d5fe86788d065b4235d0c172a5737550 /source/text/scalc/01/func_aggregate.xhp | |
| parent | tdf#115440 Help page for ROUNDSIG function in Calc (diff) | |
| download | help-810e6f87237633190dd9a674abe8a1177025cf1f.tar.gz help-810e6f87237633190dd9a674abe8a1177025cf1f.zip | |
Normalize heading in selected help pages
Change-Id: I42aa8fb12247645d40e29f61f235b4a22a197385
Reviewed-on: https://gerrit.libreoffice.org/50062
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/01/func_aggregate.xhp')
| -rw-r--r-- | source/text/scalc/01/func_aggregate.xhp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/source/text/scalc/01/func_aggregate.xhp b/source/text/scalc/01/func_aggregate.xhp index 9fba2167b2..2c68be5ab2 100644 --- a/source/text/scalc/01/func_aggregate.xhp +++ b/source/text/scalc/01/func_aggregate.xhp @@ -25,7 +25,7 @@ </bookmark> -<paragraph id="hd_id3154073" role="heading" level="2" xml-lang="en-US"><variable id="aggregate_head"><link href="text/scalc/01/func_aggregate.xhp">AGGREGATE</link></variable> function</paragraph> +<paragraph id="hd_id3154073" role="heading" level="1" xml-lang="en-US"><variable id="aggregate_head"><link href="text/scalc/01/func_aggregate.xhp">AGGREGATE</link></variable> function</paragraph> <paragraph id="par_id2209201514174373" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="aggregate_des">This function returns an aggregate result of the calculations in the range. You can use different aggregate functions listed below. The Aggregate function enables you to omit hidden rows, errors, SUBTOTAL and other AGGREGATE function results in the calculation.</variable></ahelp></paragraph> </section> <paragraph id="par_id2209201514174453" role="note" xml-lang="en-US">AGGREGATE function is applied to vertical ranges of data with activated AutoFilter. If AutoFilter is not activated, automatic recalculation of the function result does not work for newly hidden rows. It is not supposed to work with horizontal ranges, however it can be applied to them as well, but with limitations. In particular, the AGGREGATE function applied to a horizontal data range does not recognize hiding columns, however correctly omits errors and results of SUBTOTAL and other AGGREGATE functions embedded into the row. </paragraph> |