diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2019-04-25 17:53:14 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2019-04-27 13:59:57 +0200 |
| commit | 0a874cee4a5d694b6c055b896d4dc64f7151b001 (patch) | |
| tree | 271886a28c592a2bdb2ab6f024de974bb2e29cfd /source/text/scalc/01/func_aggregate.xhp | |
| parent | tdf#124198 Impress & Draw ImageMap menu entry was moved to Tools (diff) | |
| download | help-0a874cee4a5d694b6c055b896d4dc64f7151b001.tar.gz help-0a874cee4a5d694b6c055b896d4dc64f7151b001.zip | |
tdf#123803 Add release info in Calc functions
Change-Id: I0476c79fe5407c3e7252ef16da4110a026b29fa8
Note: some Calc functions still lack help pages.
Reviewed-on: https://gerrit.libreoffice.org/71331
Tested-by: Jenkins
Reviewed-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 18e00aa4d7..ba8ce64ec0 100644 --- a/source/text/scalc/01/func_aggregate.xhp +++ b/source/text/scalc/01/func_aggregate.xhp @@ -29,7 +29,7 @@ <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> - +<embed href="text/scalc/00/avail_release.xhp#4.4"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id200801176228491" role="code" xml-lang="en-US">AGGREGATE(Function; Option; Ref1 [; Ref2 [; …]])</paragraph> <paragraph id="par_id2309201516102726" role="paragraph" xml-lang="en-US">or</paragraph> |