summaryrefslogtreecommitdiff
path: root/source
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2023-04-14 12:39:20 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2023-04-15 10:00:51 +0200
commitf4d872408d2e6b69807eb47f2a9d9e2d5f00548a (patch)
tree8f381c82ed9e00b0fa3cc51670444f879de2fd39 /source
parentc811d25cb446be27fd99363c08b7e2e406082391 (diff)
tdf#132465 "Trim input range..." option on Calc's Moving Average dialog
Refers to tdf#99938 Change-Id: Ia8bac690c0090c7fedf635cdf6987cfc1e3c8cb2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/150424 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source')
-rw-r--r--source/text/scalc/01/statistics_movingavg.xhp6
1 files changed, 5 insertions, 1 deletions
diff --git a/source/text/scalc/01/statistics_movingavg.xhp b/source/text/scalc/01/statistics_movingavg.xhp
index 90f76adb18..76f9ee6eef 100644
--- a/source/text/scalc/01/statistics_movingavg.xhp
+++ b/source/text/scalc/01/statistics_movingavg.xhp
@@ -30,7 +30,11 @@
<section id="howtoget">
<paragraph id="par_id1002510" role="paragraph"><variable id="sam01">Choose <menuitem>Data - Statistics - Moving Average</menuitem></variable></paragraph>
</section>
-<note id="par_id1002520">For more information on the moving average, refer to the <link href="https://en.wikipedia.org/wiki/Moving_average">corresponding Wikipedia article</link>.</note><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/>
+<note id="par_id1002520">For more information on the moving average, refer to the <link href="https://en.wikipedia.org/wiki/Moving_average">corresponding Wikipedia article</link>.</note>
+<embed href="text/scalc/01/stat_data.xhp#data"/>
+<h2 id="hd_id251681484186482">Trim input range to actual data content</h2>
+<paragraph role="paragraph" id="par_id141681485134081">Check this box to allow trimming of the input range to the actual data content before computing moving-average. Trimming data ignores unused or empty cells after the last non-empty cell in the input range, thus reducing the computing load of the moving average to the actual data. This checkbox is enabled by default.</paragraph>
+<embed href="text/scalc/01/stat_data.xhp#grouped"/>
<h2 id="hd_id1000140">Parameters</h2>
<paragraph id="par_id1002530" role="paragraph"><emph>Interval</emph>: The number of samples used in the moving average calculation.</paragraph><embed href="text/scalc/01/stat_data.xhp#timeseries01"/>
<h2 id="hd_id1000171">Results of the moving average:</h2>