source/text/scalc/guide/autofilter.xhp | 57 ++++++++++++++++-----------------
1 file changed, 29 insertions(+), 28 deletions(-)
New commits:
commit b26998fa3bfa082fd9f921926b174125f419bd4e
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Wed Jul 16 13:47:02 2025 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Jul 16 18:52:32 2025 +0200
tdfg#126447 Precisions on ranges for AutoFilter
Change-Id: I3eb2cb64eebb9d232a279d9bddafa4f50cb9e886
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/187970
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/guide/autofilter.xhp
b/source/text/scalc/guide/autofilter.xhp
index a7579447d1..edd67f2203 100644
--- a/source/text/scalc/guide/autofilter.xhp
+++ b/source/text/scalc/guide/autofilter.xhp
@@ -25,7 +25,7 @@
<filename>/text/scalc/guide/autofilter.xhp</filename>
</topic>
</meta>
- <body>
+<body>
<bookmark branch="index" id="bm_id3156423"><bookmark_value>filters, see also
AutoFilter function</bookmark_value>
<bookmark_value>AutoFilter function;applying</bookmark_value>
<bookmark_value>sheets; filter values</bookmark_value>
@@ -33,38 +33,39 @@
<bookmark_value>columns; AutoFilter function</bookmark_value>
<bookmark_value>drop-down menus in sheet columns</bookmark_value>
<bookmark_value>database ranges; AutoFilter function</bookmark_value>
-</bookmark><comment>mw made "drop-down..." a one level entry and added a "see
also" reference</comment>
-<h1 id="hd_id3156423"><variable id="autofilter"><link
href="text/scalc/guide/autofilter.xhp">Applying AutoFilter</link>
-</variable></h1>
- <paragraph id="par_id3147427" role="paragraph">The
<emph>AutoFilter</emph> function inserts a combo box on one or more data
columns that lets you select the records (rows) to be displayed.</paragraph>
- <section id="autofiltertext">
- <list type="ordered">
+ </bookmark><comment>mw made "drop-down..." a one level entry and added a
"see also" reference</comment>
+<h1 id="hd_id3156423"><variable id="autofilter"><link
href="text/scalc/guide/autofilter.xhp">Applying
AutoFilter</link></variable></h1>
+<paragraph id="par_id3147427" role="paragraph">The <emph>AutoFilter</emph>
function inserts a combo box on one or more data columns that lets you select
the records (rows) to be displayed.</paragraph>
+<section id="autofiltertext">
+ <list type="ordered">
<listitem>
- <paragraph id="par_id3152576" role="listitem">Select the
columns you want to use AutoFilter on.</paragraph>
+ <paragraph id="par_id3152576" role="listitem">Select the
columns you want to use AutoFilter on.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id3153157" role="listitem">Choose <emph>Data
- Filter - AutoFilter</emph>. The combo box arrows are visible in the first row
of the range selected.</paragraph>
+ <paragraph id="par_id3153157" role="listitem">Choose
<emph>Data - Filter - AutoFilter</emph>. The combo box arrows are visible in
the first row of the range selected.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id3154510" role="listitem">Run the filter by
clicking the drop-down arrow in the column heading and choosing an
item.</paragraph>
- <paragraph id="par_id3155064" role="listitem">Only those rows
whose contents meet the filter criteria are displayed. The other rows are
filtered<comment>UFI: we must distinguish manually hidden cells from filtered
cells, because they behave differently. So don't use the word "hidden" when a
filter is applied.</comment>. You can see if rows have been filtered from the
discontinuous row numbers. The column that has been used for the filter is
identified by a different color for the arrow button.</paragraph>
+ <paragraph id="par_id3154510" role="listitem">Run the filter
by clicking the drop-down arrow in the column heading and choosing an
item.</paragraph>
</listitem>
- </list>
- <paragraph id="par_id9216589" role="paragraph">When you apply an
additional AutoFilter on another column of a filtered data range, then the
other combo boxes list only the filtered data.</paragraph>
- <paragraph id="par_id3153714" role="paragraph">To display all records
again, select the <emph>all</emph> entry in the AutoFilter combo box. If you
choose <emph>Standard</emph>, the <item type="menuitem">Standard Filter</item>
dialog appears, allowing you to set up a standard filter. Choose "Top 10" to
display the highest 10 values only. </paragraph>
- <paragraph id="par_id3147340" role="paragraph">To stop using
AutoFilter, reselect all cells selected in step 1 and once again choose
<emph>Data - Filter - AutoFilter</emph>.</paragraph>
- <section id="autofiltertip">
- <tip id="par_id4303415">To assign different AutoFilters to different
sheets, you must first define a database range on each sheet.</tip>
- </section>
- <warning id="par_id3159236">The arithmetic functions also take
account of the cells that are not visible due to an applied filter. For
example, a sum of an entire column will also total the values in the filtered
cells. Apply the <link href="text/scalc/01/04060106.xhp">SUBTOTAL</link>
function if only the cells visible after the application of a filter are to be
taken into account.</warning>
+ </list>
+ <paragraph id="par_id3155064" role="listitem">Only those rows whose
contents meet the filter criteria are displayed. The other rows are
filtered<comment>UFI: we must distinguish manually hidden cells from filtered
cells, because they behave differently. So don't use the word "hidden" when a
filter is applied.</comment>. You can see if rows have been filtered from the
discontinuous row numbers. The column that has been used for the filter is
identified by a different color for the arrow button.</paragraph>
+ <paragraph role="paragraph" id="par_id931752683152912">When no cell
range is selected, the AutoFilter will apply to the column up to the first
empty cell. Please ensure that you select the appropriate range before applying
the AutoFilter.</paragraph>
+ <paragraph role="paragraph" id="par_id301752683274133">When the cell
range is expanded to include additional non-empty cells, the AutoFilter
automatically adjusts the filter range to encompass these new cells.</paragraph>
+ <paragraph id="par_id9216589" role="paragraph">When you apply an
additional AutoFilter on another column of a filtered data range, then the
other combo boxes list only the filtered data.</paragraph>
+ <paragraph id="par_id3153714" role="paragraph">To display all records
again, select the <emph>all</emph> entry in the AutoFilter combo box. If you
choose <emph>Standard</emph>, the <item type="menuitem">Standard Filter</item>
dialog appears, allowing you to set up a standard filter. Choose "Top 10" to
display the highest 10 values only. </paragraph>
+ <paragraph id="par_id3147340" role="paragraph">To stop using AutoFilter,
reselect all cells selected in step 1 and once again choose <emph>Data - Filter
- AutoFilter</emph>.</paragraph>
+ <section id="autofiltertip">
+ <tip id="par_id4303415">To assign different AutoFilters to
different sheets, you must first define a database range on each sheet.</tip>
</section>
- <section id="relatedtopics">
- <embed href="text/scalc/01/12040100.xhp#autofilterh1"/>
- <embed href="text/scalc/guide/filters.xhp#filters"/>
- <embed href="text/scalc/guide/specialfilter.xhp#specialfilter"/>
- <embed href="text/scalc/guide/cellcopy.xhp#cellcopy"/>
- <paragraph id="par_id3152985" role="paragraph"><link
href="text/scalc/01/12040100.xhp">Data - Filter - AutoFilter</link></paragraph>
- <paragraph id="par_id3154484" role="paragraph"><link
href="text/scalc/01/04060106.xhp">SUBTOTAL</link></paragraph>
- </section>
- </body>
+ <warning id="par_id3159236">The arithmetic functions also take account
of the cells that are not visible due to an applied filter. For example, a sum
of an entire column will also total the values in the filtered cells. Apply the
<link href="text/scalc/01/04060106.xhp">SUBTOTAL</link> function if only the
cells visible after the application of a filter are to be taken into
account.</warning>
+</section>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/12040100.xhp#autofilterh1"/>
+ <embed href="text/scalc/guide/filters.xhp#filters"/>
+ <embed href="text/scalc/guide/specialfilter.xhp#specialfilter"/>
+ <embed href="text/scalc/guide/cellcopy.xhp#cellcopy"/>
+ <paragraph id="par_id3152985" role="paragraph"><link
href="text/scalc/01/12040100.xhp">Data - Filter - AutoFilter</link></paragraph>
+ <paragraph id="par_id3154484" role="paragraph"><link
href="text/scalc/01/04060106.xhp">SUBTOTAL</link></paragraph>
+</section>
+</body>
</helpdocument>
