source/text/scalc/00/00000412.xhp | 60 +++++++++++---
source/text/scalc/01/12040000.xhp | 16 +--
source/text/scalc/01/12040100.xhp | 21 ++---
source/text/scalc/01/12040300.xhp | 28 +++---
source/text/scalc/01/12040400.xhp | 14 +--
source/text/scalc/01/12040500.xhp | 26 ++----
source/text/scalc/guide/autofilter.xhp | 24 ++---
source/text/scalc/guide/specialfilter.xhp | 126 +++++++++++++++---------------
source/text/shared/00/00000001.xhp | 3
source/text/shared/00/00000409.xhp | 34 ++++----
source/text/shared/02/12090100.xhp | 79 +++++++++---------
11 files changed, 235 insertions(+), 196 deletions(-)
New commits:
commit 2a670f53d8c90aca037007b931c7237658d3f3f6
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Tue Dec 26 18:01:58 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Dec 27 09:32:04 2023 +0100
tdf#155876 UI cmds Calc-Sheet menu (36)
+ Data menu for Calc, Filters.
+ refactoring
Change-Id: I5bb6d7a8b9b5a60c81d680786b6de372d7815807
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/161336
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/00/00000412.xhp
b/source/text/scalc/00/00000412.xhp
index 86032b9ae2..fe209cb6dd 100644
--- a/source/text/scalc/00/00000412.xhp
+++ b/source/text/scalc/00/00000412.xhp
@@ -123,16 +123,25 @@
</section>
</section>
<paragraph role="paragraph" id="par_id3146984"><variable
id="dnstot">Choose <emph>Data - Sort - Options</emph>
tab.</variable></paragraph>
- <paragraph role="paragraph" id="par_id3155308"><variable id="dnftr">Choose
<emph>Data - More Filters</emph>.</variable></paragraph>
+
+ <section id="filtermenu">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3155308"><variable
id="dnftr">Choose <emph>Data - More Filters</emph>.</variable></paragraph>
+ </section>
+
<section id="autofilter">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
<paragraph role="paragraph" id="par_id3148646">Choose <emph>Data -
AutoFilter</emph>.</paragraph>
- <paragraph role="paragraph" id="par_id3151113">On <emph>Tools</emph>
bar or <emph>Table Data</emph> bar, click</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id541703617143126">Choose
<menuitem>Data - AutoFilter</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id751703617148566">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>AutoFilter</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
<section id="syautofilter">
<table id="tbl_id3155418">
<tablerow>
<tablecell>
<paragraph role="paragraph" id="par_id3145799">
- <image id="img_id3149413"
src="cmd/sc_datafilterautofilter.png" width="0.222inch" height="0.222inch"><alt
id="alt_id3149413">Icon</alt></image></paragraph>
+ <image id="img_id3149413"
src="cmd/lc_datafilterautofilter.svg" width="1cm" height="1cm"><alt
id="alt_id3149413">Icon Autofilter</alt></image></paragraph>
</tablecell>
<tablecell>
<paragraph role="paragraph"
id="par_id3149401">AutoFilter</paragraph>
@@ -140,28 +149,59 @@
</tablerow>
</table>
</section>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph role="paragraph" id="par_id61703617236607"><switchinline
select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>
+ Shift + L</keycode></paragraph>
+ </section>
+
+ <section id="advancedfilter">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3156278"><variable
id="dnfspz">Choose <emph>Data - More Filters - Advanced Filter...</emph>
.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id231703619502524">Choose
<menuitem>Data - Advanced Filter</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id611703619507923">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Advanced Filter</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id41703619531301">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id491703619531302"
role="paragraph"><image src="cmd/lc_datafilterspecialfilter.svg"
id="img_id41703619531303" width="1cm" height="1cm"><alt
id="alt_id451703619531304">Icon Advanced Filter</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id771703619531306"
role="paragraph">Advanced Filter</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
</section>
- <paragraph role="paragraph" id="par_id3156278"><variable
id="dnfspz">Choose <emph>Data - More Filters - Advanced Filter...</emph>
.</variable></paragraph>
+
<section id="filter_options">
<paragraph role="paragraph" id="par_id3153764">Choose <emph>Data -
More Filters - Standard Filter... - Options</emph> label.</paragraph>
<paragraph role="paragraph" id="par_id3155444">Choose <emph>Data -
More Filters - Advanced Filter... - Options</emph> label.</paragraph>
</section>
<section id="reset_filter">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
<paragraph role="paragraph" id="par_id3156382">Choose <emph>Data -
More Filters - Reset Filter</emph>.</paragraph>
- <paragraph role="paragraph" id="par_id3155961">On <emph>Table
Data</emph> bar, click <emph>Reset Filter/Sort</emph>.</paragraph>
- <table id="tbl_id3146919">
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id661703622352347">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Reset Filter</menuitem>.</paragraph>
+ </section>
+
+ <section id="hideautofilter">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3152778"><variable
id="dnaftas">Choose <menuitem>Data - More Filters - Hide
AutoFilter</menuitem>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id541703623051905">Choose
<menuitem>Data - Hide AutoFilter</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id121703622992207">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Hide AutoFilter</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id91703623095338">
<tablerow>
<tablecell>
- <paragraph role="paragraph" id="par_id3148485">
- <image id="img_id3145792"
src="cmd/sc_removefilter.png" width="0.222inch" height="0.222inch"><alt
id="alt_id3145792">Icon</alt></image></paragraph>
+ <paragraph id="par_id631703623095339"
role="paragraph"><image src="cmd/lc_removefiltersort.svg"
id="img_id981703623095340" width="1cm" height="1cm"><alt
id="alt_id261703623095341">Icon Hide AutoFilter</alt></image></paragraph>
</tablecell>
<tablecell>
- <paragraph role="paragraph" id="par_id3149207">Reset
Filter/Sort</paragraph>
+ <paragraph id="par_id351703623095343"
role="paragraph">Hide AutoFilter</paragraph>
</tablecell>
</tablerow>
</table>
</section>
- <paragraph role="paragraph" id="par_id3152778"><variable
id="dnaftas">Choose <emph>Data - More Filter - Hide
AutoFilter</emph>.</variable></paragraph>
+
<paragraph role="paragraph" id="par_id3166424"><variable
id="dntegs">Choose <emph>Data - Subtotals</emph>.</variable></paragraph>
<paragraph role="paragraph" id="par_id3154574"><variable
id="dntezd">Choose <emph>Data - Subtotals - 1st, 2nd, 3rd Group</emph>
tabs.</variable></paragraph>
<paragraph role="paragraph" id="par_id3151277"><variable
id="dntopi">Choose <emph>Data - Subtotals - Options</emph>
tab.</variable></paragraph>
diff --git a/source/text/scalc/01/12040000.xhp
b/source/text/scalc/01/12040000.xhp
index 83d5552615..4754a16abc 100644
--- a/source/text/scalc/01/12040000.xhp
+++ b/source/text/scalc/01/12040000.xhp
@@ -19,25 +19,23 @@
-->
<meta>
<topic id="textscalc0112040000xml" indexer="include">
- <title id="tit" xml-lang="en-US">More Filters</title>
+ <title id="tit">More Filters</title>
<filename>/text/scalc/01/12040000.xhp</filename>
</topic>
</meta>
<body>
+ <bookmark branch="hid/.uno:FilterMenu" id="bm_id102920080228246"
localize="false"/>
<section id="filter">
- <bookmark xml-lang="en-US" branch="hid/.uno:FilterMenu"
id="bm_id102920080228246" localize="false"/>
<h1 id="hd_id3150767"><link href="text/scalc/01/12040000.xhp">More
Filters</link></h1>
- <paragraph role="paragraph" id="par_id3155131" xml-lang="en-US"><ahelp
hid=".">Shows commands to filter your data.</ahelp></paragraph>
+ <paragraph role="paragraph" id="par_id3155131"><ahelp hid=".">Shows
commands to filter your data.</ahelp></paragraph>
</section>
<section id="howtoget">
- <embed href="text/scalc/00/00000412.xhp#dnftr"/>
+ <embed href="text/scalc/00/00000412.xhp#filtermenu"/>
</section>
<tip id="par_id911633127394220">%PRODUCTNAME automatically recognizes
predefined database ranges.</tip>
- <paragraph role="paragraph" id="par_id3153363" xml-lang="en-US">The
following filtering options are available:</paragraph>
- <h2 id="hd_id3153728"><link href="text/shared/02/12090000.xhp">Standard
filter</link></h2>
- <embed href="text/shared/02/12090000.xhp#standardfilter"/>
- <h2 id="hd_id3159153"><link href="text/scalc/01/12040300.xhp">Advanced
filter</link></h2>
- <embed href="text/scalc/01/12040300.xhp#spezialfilter"/>
+ <paragraph role="paragraph" id="par_id3153363">The following filtering
options are available:</paragraph>
+ <embed href="text/shared/02/12090100.xhp#standardfilter"/>
+ <embed href="text/scalc/01/12040300.xhp#advancedfilter"/>
<embed href="text/scalc/01/12040400.xhp#reset_filter"/>
<embed href="text/scalc/01/12040500.xhp#hide_autofilter"/>
</body>
diff --git a/source/text/scalc/01/12040100.xhp
b/source/text/scalc/01/12040100.xhp
index 585994104c..ae90a75643 100644
--- a/source/text/scalc/01/12040100.xhp
+++ b/source/text/scalc/01/12040100.xhp
@@ -19,17 +19,20 @@
<helpdocument version="1.0">
<meta>
<topic id="textscalc0112040100xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">AutoFilter</title>
+<title id="tit">AutoFilter</title>
<filename>/text/scalc/01/12040100.xhp</filename>
</topic>
</meta>
<body>
+<bookmark branch="hid/.uno:DataFilterAutoFilter" id="bm_id5427750"
localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/filterdropdown/FilterDropDown"
id="bm_id361621531206029" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/filterdropdown/@@nowidget@@"
id="bm_id151621531292577" localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/notebookbar/MenuData-DataFilterAutoFilter"
id="bm_id911703623744366" localize="false"/>
+
+
<section id="autofilter">
-<bookmark xml-lang="en-US" branch="hid/.uno:DataFilterAutoFilter"
id="bm_id5427750" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/filterdropdown/FilterDropDown"
id="bm_id361621531206029" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/filterdropdown/@@nowidget@@"
id="bm_id151621531292577" localize="false"/>
<h1 id="hd_id3153541"><variable id="autofilterh1"><link
href="text/scalc/01/12040100.xhp">AutoFilter</link></variable></h1>
-<paragraph role="paragraph" id="par_id3148550" xml-lang="en-US"><ahelp
hid=".uno:DataFilterAutoFilter">Automatically filters the selected cell range,
and creates one-row list boxes where you can choose the items that you want to
display.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3148550"><ahelp
hid=".uno:DataFilterAutoFilter">Automatically filters the selected cell range,
and creates one-row list boxes where you can choose the items that you want to
display.</ahelp></paragraph>
</section>
<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#autofilter"/>
@@ -40,12 +43,12 @@
<paragraph role="paragraph" id="par_id31621544435954">Displays the rows of the
cell range in ascending order, based on the values in the cells of the current
column.</paragraph>
<h2 id="hd_id561621534101425">Sort Descending</h2>
<paragraph role="paragraph" id="par_id861621544431393">Displays the rows of
the cell range in descending order, based on the values in the cells of the
current column.</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/filtersubdropdown/menu" id="bm_id101674925465966"
localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/filtersubdropdown/menu"
id="bm_id101674925465966" localize="false"/>
<h2 id="hd_id391674926239837">Filter by Color</h2>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/filtersubdropdown/textcolor"
id="bm_id331674925567744" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/filtersubdropdown/textcolor"
id="bm_id331674925567744" localize="false"/>
<h3 id="hd_id271621534120995">Text color</h3>
<paragraph role="paragraph" id="par_id691621544414646">Displays only the rows
of the cell range for which the text color of the cell in the current column
matches the color selected.</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/filtersubdropdown/background"
id="bm_id341674925655898" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/filtersubdropdown/background"
id="bm_id341674925655898" localize="false"/>
<h3 id="hd_id151621534125831">Background color</h3>
<paragraph role="paragraph" id="par_id491621544410605">Displays only the rows
of the cell range for which the background color of the cell in the current
column matches the color selected.</paragraph>
<h2 id="hd_id771674926517261">Filter by Condition</h2>
@@ -71,7 +74,7 @@
<paragraph role="paragraph" id="par_id331621544378745">List of unique values
found in the current column.</paragraph>
<section id="relatedtopics">
<embed href="text/scalc/guide/autofilter.xhp#autofilter"/>
-<paragraph role="paragraph" id="par_id3145171" xml-lang="en-US"><link
href="text/shared/02/12090000.xhp">Default filter</link></paragraph>
+<paragraph role="paragraph" id="par_id3145171"><link
href="text/shared/02/12090000.xhp">Default filter</link></paragraph>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/12040300.xhp
b/source/text/scalc/01/12040300.xhp
index f75075f71b..c250a58df8 100644
--- a/source/text/scalc/01/12040300.xhp
+++ b/source/text/scalc/01/12040300.xhp
@@ -21,34 +21,38 @@
<meta>
<topic id="textscalc0112040300xml" indexer="include">
- <title id="tit" xml-lang="en-US">Advanced Filter</title>
+ <title id="tit">Advanced Filter</title>
<filename>/text/scalc/01/12040300.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="hid/.uno:DataFilterSpecialFilter"
id="bm_id4998774" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/advancedfilterdialog/AdvancedFilterDialog"
id="bm_id3154366" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/advancedfilterdialog/@@nowidget@@"
id="bm_id3154366" localize="false"/>
-<h1 id="hd_id3158394">Advanced Filter</h1>
-<paragraph role="paragraph" id="par_id3156281" xml-lang="en-US"><variable
id="spezialfilter"><ahelp hid=".uno:DataFilterSpecialFilter">Defines an
advanced filter.</ahelp>
-</variable></paragraph>
+<bookmark branch="hid/.uno:DataFilterSpecialFilter" id="bm_id4998774"
localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/advancedfilterdialog/AdvancedFilterDialog"
id="bm_id3154366" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/advancedfilterdialog/@@nowidget@@"
id="bm_id3154366" localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/notebookbar/MenuData-DataFilterSpecialFilter"
id="bm_id941703623897781" localize="false"/>
+<section id="advancedfilter">
+ <h1 id="hd_id3158394"><variable id="h1"><link
href="text/scalc/01/12040300.xhp#advanced filter">Advanced
Filter</link></variable></h1>
+<paragraph role="paragraph" id="par_id3156281"><variable
id="spezialfilter"><ahelp hid=".uno:DataFilterSpecialFilter">Defines an
advanced filter.</ahelp></variable></paragraph>
+</section>
<section id="howtoget">
- <embed href="text/scalc/00/00000412.xhp#dnfspz"/>
+ <embed href="text/scalc/00/00000412.xhp#advancedfilter"/>
</section>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/advancedfilterdialog/lbfilterarea"
id="bm_id3149664" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/advancedfilterdialog/edfilterarea"
id="bm_id3151113" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/advancedfilterdialog/lbfilterarea"
id="bm_id3149664" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/advancedfilterdialog/edfilterarea"
id="bm_id3151113" localize="false"/>
<h2 id="hd_id3153771">Read filter criteria from</h2>
-<paragraph role="paragraph" id="par_id3147426" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/advancedfilterdialog/edfilterarea">Select the named
range, or enter the cell range that contains the filter criteria that you want
to use.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3147426"><ahelp
hid="modules/scalc/ui/advancedfilterdialog/edfilterarea">Select the named
range, or enter the cell range that contains the filter criteria that you want
to use.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/advancedfilterdialog/rbcopyarea"
id="bm_id3146985" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/advancedfilterdialog/rbfilterarea"
id="bm_id3153190" localize="false"/>
<embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
<h2 id="hd_id331625165680452">Options</h2>
<embed href="text/scalc/01/12040201.xhp#zusaetzetext"/>
<embed href="text/scalc/01/12040201.xhp#FilterOptions_Pt1"/>
<embed href="text/scalc/01/12040201.xhp#FilterOptions_Pt2"/>
-<embed href="text/scalc/guide/specialfilter.xhp#AdvancedFilter"/>
<section id="relatedtopics">
<embed href="text/scalc/guide/filters.xhp#filters"/>
<embed href="text/scalc/guide/autofilter.xhp#autofilter"/>
+ <paragraph role="paragraph" id="par_id271703621952982"
localize="false"><embedvar
href="text/scalc/guide/specialfilter.xhp#specialfilter"/></paragraph>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/12040400.xhp
b/source/text/scalc/01/12040400.xhp
index 2e6e3b1843..93ffa1bb8b 100644
--- a/source/text/scalc/01/12040400.xhp
+++ b/source/text/scalc/01/12040400.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,20 +16,19 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
-
- <helpdocument version="1.0">
+<helpdocument version="1.0">
<meta>
<topic id="textscalc0112040400xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Reset Filter</title>
+<title id="tit">Reset Filter</title>
<filename>/text/scalc/01/12040400.xhp</filename>
</topic>
</meta>
<body>
+<bookmark branch="hid/.uno:DataFilterRemoveFilter" id="bm_id2352791"
localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/notebookbar/MenuData-DataFilterRemoveFilter"
id="bm_id771703623943281" localize="false"/>
<section id="reset_filter">
-<bookmark xml-lang="en-US" branch="hid/.uno:DataFilterRemoveFilter"
id="bm_id2352791" localize="false"/>
<h1 id="hd_id3153087"><link href="text/scalc/01/12040400.xhp">Reset
Filter</link></h1>
-<paragraph role="paragraph" id="par_id3154760" xml-lang="en-US"><ahelp
hid=".uno:DataFilterRemoveFilter">Removes the filter from the selected cell
range. To enable this command, click inside the cell area where the filter was
applied.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3154760"><ahelp
hid=".uno:DataFilterRemoveFilter">Removes the filter from the selected cell
range. To enable this command, click inside the cell area where the filter was
applied.</ahelp></paragraph>
</section>
<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#reset_filter"/>
diff --git a/source/text/scalc/01/12040500.xhp
b/source/text/scalc/01/12040500.xhp
index e31b0cc285..407c531ca1 100644
--- a/source/text/scalc/01/12040500.xhp
+++ b/source/text/scalc/01/12040500.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,11 +16,10 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
<helpdocument version="1.0">
<meta>
<topic id="textscalc0112040500xml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Hide AutoFilter</title>
+<title id="tit">Hide AutoFilter</title>
<filename>/text/scalc/01/12040500.xhp</filename>
</topic>
<history>
@@ -30,16 +27,15 @@
</history>
</meta>
<body>
-
-
- <section id="hide_autofilter">
- <bookmark xml-lang="en-US" branch="index"
id="bm_id3150276"><bookmark_value>database ranges; hiding
AutoFilter</bookmark_value></bookmark>
-<bookmark branch="hid/.uno:DataFilterHideAutoFilter" xml-lang="en-US"
id="bm_id3145674" localize="false"/>
-<h1 id="hd_id3150276"><link href="text/scalc/01/12040500.xhp">Hide
AutoFilter</link></h1>
- <paragraph role="paragraph" id="par_id3156326" xml-lang="en-US"><ahelp
hid=".uno:DataFilterHideAutoFilter" visibility="visible">Hides the AutoFilter
buttons in the selected cell range.</ahelp></paragraph>
- </section>
- <section id="howtoget">
- <embed href="text/scalc/00/00000412.xhp#dnaftas"/>
+<bookmark branch="index" id="bm_id3150276"><bookmark_value>database ranges;
hiding AutoFilter</bookmark_value></bookmark>
+<bookmark branch="hid/.uno:DataFilterHideAutoFilter" id="bm_id3145674"
localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/notebookbar/MenuData-DataFilterHideAutoFilter"
id="bm_id441703623521734" localize="false"/>
+<section id="hide_autofilter">
+ <h1 id="hd_id3150276"><link href="text/scalc/01/12040500.xhp">Hide
AutoFilter</link></h1>
+ <paragraph role="paragraph" id="par_id3156326"><ahelp
hid=".uno:DataFilterHideAutoFilter" visibility="visible">Hides the AutoFilter
buttons in the selected cell range.</ahelp></paragraph>
</section>
- </body>
+<section id="howtoget">
+ <embed href="text/scalc/00/00000412.xhp#hideautofilter"/>
+</section>
+</body>
</helpdocument>
diff --git a/source/text/scalc/guide/autofilter.xhp
b/source/text/scalc/guide/autofilter.xhp
index c17cbc0d8a..a7579447d1 100644
--- a/source/text/scalc/guide/autofilter.xhp
+++ b/source/text/scalc/guide/autofilter.xhp
@@ -21,12 +21,12 @@
<meta>
<topic id="textscalcguideautofilterxml" indexer="include"
status="PUBLISH">
- <title xml-lang="en-US" id="tit">Applying AutoFilter</title>
+ <title id="tit">Applying AutoFilter</title>
<filename>/text/scalc/guide/autofilter.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3156423"><bookmark_value>filters, see also AutoFilter
function</bookmark_value>
+<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>
<bookmark_value>numbers; filter sheets</bookmark_value>
@@ -36,23 +36,23 @@
</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 xml-lang="en-US" 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>
+ <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 xml-lang="en-US" 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 xml-lang="en-US" 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 xml-lang="en-US" id="par_id3154510"
role="listitem">Run the filter by clicking the drop-down arrow in the column
heading and choosing an item.</paragraph>
- <paragraph xml-lang="en-US" 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>
+ <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>
</listitem>
</list>
- <paragraph xml-lang="en-US" 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 xml-lang="en-US" 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 xml-lang="en-US" 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>
+ <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>
@@ -63,8 +63,8 @@
<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 xml-lang="en-US" id="par_id3152985" role="paragraph"><link
href="text/scalc/01/12040100.xhp">Data - Filter - AutoFilter</link></paragraph>
- <paragraph xml-lang="en-US" id="par_id3154484" role="paragraph"><link
href="text/scalc/01/04060106.xhp">SUBTOTAL</link></paragraph>
+ <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>
diff --git a/source/text/scalc/guide/specialfilter.xhp
b/source/text/scalc/guide/specialfilter.xhp
index b8803391f2..bd7229d00b 100644
--- a/source/text/scalc/guide/specialfilter.xhp
+++ b/source/text/scalc/guide/specialfilter.xhp
@@ -21,13 +21,13 @@
<meta>
<topic id="textscalcguidespecialfilterxml" indexer="include"
status="PUBLISH">
- <title xml-lang="en-US" id="tit">Applying Advanced Filters</title>
+ <title id="tit">Applying Advanced Filters</title>
<filename>/text/scalc/guide/specialfilter.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3148798"><bookmark_value>filters;defining advanced filters
</bookmark_value>
+<bookmark branch="index" id="bm_id3148798"><bookmark_value>filters;defining
advanced filters </bookmark_value>
<bookmark_value>advanced filters</bookmark_value>
<bookmark_value>defining; advanced filters</bookmark_value>
<bookmark_value>database ranges; advanced filters</bookmark_value>
@@ -38,180 +38,180 @@
</variable></h1>
<list type="ordered">
<listitem>
- <paragraph xml-lang="en-US" id="par_id3145785" role="listitem">Copy the
column headers of the sheet ranges to be filtered into an empty area of the
sheet, and then enter the criteria for the filter in a row beneath the headers.
Horizontally arranged data in a row will always be logically connected with
AND, and vertically arranged data in a column will always be logically
connected with OR.</paragraph>
+ <paragraph id="par_id3145785" role="listitem">Copy the column headers of
the sheet ranges to be filtered into an empty area of the sheet, and then enter
the criteria for the filter in a row beneath the headers. Horizontally arranged
data in a row will always be logically connected with AND, and vertically
arranged data in a column will always be logically connected with
OR.</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id3153142" role="listitem">Once you
have created a filter matrix, select the sheet ranges to be filtered. Open the
<emph>Advanced Filter</emph> dialog by choosing <menuitem>Data - More Filters -
Advanced Filter</menuitem>, and define the filter conditions.</paragraph>
+ <paragraph id="par_id3153142" role="listitem">Once you have created a
filter matrix, select the sheet ranges to be filtered. Open the <emph>Advanced
Filter</emph> dialog by choosing <menuitem>Data - More Filters - Advanced
Filter</menuitem>, and define the filter conditions.</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id3153726" role="listitem">Then
click OK, and you will see that only the rows from the original sheet whose
contents have met the search criteria are still visible. All other rows are
temporarily hidden and can be made to reappear with the <menuitem>Format - Rows
- Show</menuitem> command.</paragraph>
+ <paragraph id="par_id3153726" role="listitem">Then click OK, and you
will see that only the rows from the original sheet whose contents have met the
search criteria are still visible. All other rows are temporarily hidden and
can be made to reappear with the <menuitem>Format - Rows - Show</menuitem>
command.</paragraph>
</listitem>
</list>
<h2 id="par_id3149664">Example</h2>
- <paragraph xml-lang="en-US" id="par_id3147427" role="paragraph">Load a
spreadsheet with a large number of records. We are using a fictional
<emph>Turnover</emph> document, but you can just as easily use any other
document. The document has the following layout:</paragraph>
+ <paragraph id="par_id3147427" role="paragraph">Load a spreadsheet with a
large number of records. We are using a fictional <emph>Turnover</emph>
document, but you can just as easily use any other document. The document has
the following layout:</paragraph>
<table id="tbl_id3149377">
<tablerow>
- <tablecell></tablecell>
+ <tablecell/>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3154510" role="tablehead"
localize="false"> <emph>A</emph> </paragraph>
+ <paragraph id="par_id3154510" role="tablehead" localize="false">
<emph>A</emph> </paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3150327" role="tablehead"
localize="false"> <emph>B</emph> </paragraph>
+ <paragraph id="par_id3150327" role="tablehead" localize="false">
<emph>B</emph> </paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3154756" role="tablehead"
localize="false"> <emph>C</emph> </paragraph>
+ <paragraph id="par_id3154756" role="tablehead" localize="false">
<emph>C</emph> </paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3155335" role="tablehead"
localize="false"> <emph>D</emph> </paragraph>
+ <paragraph id="par_id3155335" role="tablehead" localize="false">
<emph>D</emph> </paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3146315" role="tablehead"
localize="false"> <emph>E</emph> </paragraph>
+ <paragraph id="par_id3146315" role="tablehead" localize="false">
<emph>E</emph> </paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3145790" role="tablehead"
localize="false"> <emph>1</emph> </paragraph>
+ <paragraph id="par_id3145790" role="tablehead" localize="false">
<emph>1</emph> </paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3159239"
role="paragraph">Month</paragraph>
+ <paragraph id="par_id3159239" role="paragraph">Month</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3150086"
role="paragraph">Standard</paragraph>
+ <paragraph id="par_id3150086" role="paragraph">Standard</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3150202"
role="paragraph">Business</paragraph>
+ <paragraph id="par_id3150202" role="paragraph">Business</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3150883"
role="paragraph">Luxury</paragraph>
+ <paragraph id="par_id3150883" role="paragraph">Luxury</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3152987"
role="paragraph">Suite</paragraph>
+ <paragraph id="par_id3152987" role="paragraph">Suite</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3154486" role="tablehead"
localize="false"> <emph>2</emph> </paragraph>
+ <paragraph id="par_id3154486" role="tablehead" localize="false">
<emph>2</emph> </paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3148839"
role="paragraph">January</paragraph>
+ <paragraph id="par_id3148839" role="paragraph">January</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3153816" role="paragraph"
localize="false">125600</paragraph>
+ <paragraph id="par_id3153816" role="paragraph"
localize="false">125600</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3157978" role="paragraph"
localize="false">200500</paragraph>
+ <paragraph id="par_id3157978" role="paragraph"
localize="false">200500</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3155268" role="paragraph"
localize="false">240000</paragraph>
+ <paragraph id="par_id3155268" role="paragraph"
localize="false">240000</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3153286" role="paragraph"
localize="false">170000</paragraph>
+ <paragraph id="par_id3153286" role="paragraph"
localize="false">170000</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3146782" role="tablehead"
localize="false"> <emph>3</emph> </paragraph>
+ <paragraph id="par_id3146782" role="tablehead" localize="false">
<emph>3</emph> </paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3149900"
role="paragraph">February</paragraph>
+ <paragraph id="par_id3149900" role="paragraph">February</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3154763" role="paragraph"
localize="false">160000</paragraph>
+ <paragraph id="par_id3154763" role="paragraph"
localize="false">160000</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3150050" role="paragraph"
localize="false">180300</paragraph>
+ <paragraph id="par_id3150050" role="paragraph"
localize="false">180300</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3153801" role="paragraph"
localize="false">362000</paragraph>
+ <paragraph id="par_id3153801" role="paragraph"
localize="false">362000</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3154708" role="paragraph"
localize="false">220000</paragraph>
+ <paragraph id="par_id3154708" role="paragraph"
localize="false">220000</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3151191" role="tablehead"
localize="false"> <emph>4</emph> </paragraph>
+ <paragraph id="par_id3151191" role="tablehead" localize="false">
<emph>4</emph> </paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3147250"
role="paragraph">March</paragraph>
+ <paragraph id="par_id3147250" role="paragraph">March</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3153334" role="paragraph"
localize="false">170000</paragraph>
+ <paragraph id="par_id3153334" role="paragraph"
localize="false">170000</paragraph>
</tablecell>
- <tablecell></tablecell>
- <tablecell></tablecell>
+ <tablecell/>
+ <tablecell/>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3151391" role="paragraph">and so
on...</paragraph>
+ <paragraph id="par_id3151391" role="paragraph">and so on...</paragraph>
</tablecell>
</tablerow>
</table>
- <paragraph xml-lang="en-US" id="par_id3147300" role="paragraph">Copy row 1
with the row headers (field names), to row 20, for example. Enter the filter
conditions linked with OR in rows 21, 22, and so on.</paragraph>
+ <paragraph id="par_id3147300" role="paragraph">Copy row 1 with the row
headers (field names), to row 20, for example. Enter the filter conditions
linked with OR in rows 21, 22, and so on.</paragraph>
<table id="tbl_id3166462">
<tablerow>
- <tablecell></tablecell>
+ <tablecell/>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3159115" role="tablehead"
localize="false"> <emph>A</emph> </paragraph>
+ <paragraph id="par_id3159115" role="tablehead" localize="false">
<emph>A</emph> </paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3146886" role="tablehead"
localize="false"> <emph>B</emph> </paragraph>
+ <paragraph id="par_id3146886" role="tablehead" localize="false">
<emph>B</emph> </paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3153124" role="tablehead"
localize="false"> <emph>C</emph> </paragraph>
+ <paragraph id="par_id3153124" role="tablehead" localize="false">
<emph>C</emph> </paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3152979" role="tablehead"
localize="false"> <emph>D</emph> </paragraph>
+ <paragraph id="par_id3152979" role="tablehead" localize="false">
<emph>D</emph> </paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3145827" role="tablehead"
localize="false"> <emph>E</emph> </paragraph>
+ <paragraph id="par_id3145827" role="tablehead" localize="false">
<emph>E</emph> </paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3149892" role="tablehead"
localize="false"> <emph>20</emph> </paragraph>
+ <paragraph id="par_id3149892" role="tablehead" localize="false">
<emph>20</emph> </paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3150693"
role="paragraph">Month</paragraph>
+ <paragraph id="par_id3150693" role="paragraph">Month</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3147475"
role="paragraph">Standard</paragraph>
+ <paragraph id="par_id3147475" role="paragraph">Standard</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3154846"
role="paragraph">Business</paragraph>
+ <paragraph id="par_id3154846" role="paragraph">Business</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3153082"
role="paragraph">Luxury</paragraph>
+ <paragraph id="par_id3153082" role="paragraph">Luxury</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3149506"
role="paragraph">Suite</paragraph>
+ <paragraph id="par_id3149506" role="paragraph">Suite</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3149188" role="tablehead"
localize="false"> <emph>21</emph> </paragraph>
+ <paragraph id="par_id3149188" role="tablehead" localize="false">
<emph>21</emph> </paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3149956"
role="paragraph">January</paragraph>
+ <paragraph id="par_id3149956" role="paragraph">January</paragraph>
</tablecell>
- <tablecell></tablecell>
- <tablecell></tablecell>
- <tablecell></tablecell>
- <tablecell></tablecell>
+ <tablecell/>
+ <tablecell/>
+ <tablecell/>
+ <tablecell/>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3150865" role="tablehead"
localize="false"> <emph>22</emph> </paragraph>
+ <paragraph id="par_id3150865" role="tablehead" localize="false">
<emph>22</emph> </paragraph>
</tablecell>
- <tablecell></tablecell>
+ <tablecell/>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3155957" role="paragraph"
localize="false"><160000</paragraph>
+ <paragraph id="par_id3155957" role="paragraph"
localize="false"><160000</paragraph>
</tablecell>
- <tablecell></tablecell>
- <tablecell></tablecell>
- <tablecell></tablecell>
+ <tablecell/>
+ <tablecell/>
+ <tablecell/>
</tablerow>
</table>
- <paragraph xml-lang="en-US" id="par_id3153566" role="paragraph">Specify that
only rows which either have the value <literal>January</literal> in the
<emph>Month</emph> cells OR a value of under 160000 in the
<emph>Standard</emph><comment>standard not default, look at U59!!!</comment>
cells will be displayed.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3147372" role="paragraph">Choose
<menuitem>Data - More Filters - Advanced Filter</menuitem>, and then select the
range A20:E22. After you click OK, only the filtered rows will be displayed.
The other rows will be hidden from view.</paragraph>
+ <paragraph id="par_id3153566" role="paragraph">Specify that only rows which
either have the value <literal>January</literal> in the <emph>Month</emph>
cells OR a value of under 160000 in the <emph>Standard</emph><comment>standard
not default, look at U59!!!</comment> cells will be displayed.</paragraph>
+ <paragraph id="par_id3147372" role="paragraph">Choose <menuitem>Data - More
Filters - Advanced Filter</menuitem>, and then select the range A20:E22. After
you click OK, only the filtered rows will be displayed. The other rows will be
hidden from view.</paragraph>
</section>
<section id="relatedtopics">
diff --git a/source/text/shared/00/00000001.xhp
b/source/text/shared/00/00000001.xhp
index b1f508f692..9688e8bdfa 100644
--- a/source/text/shared/00/00000001.xhp
+++ b/source/text/shared/00/00000001.xhp
@@ -154,9 +154,8 @@
<bookmark branch="hid/modules/scalc/ui/conditionalformatdialog/rbassign"
id="bm_id3155532" localize="false"/>
<bookmark branch="hid/modules/scalc/ui/managenamesdialog/assign"
id="bm_id3159155" localize="false"/>
<bookmark branch="hid/modules/scalc/ui/definedatabaserangedialog/assignrb"
id="bm_id3149262" localize="false"/>
-<bookmark branch="hid/modules/scalc/ui/advancedfilterdialog/rbfilterarea"
id="bm_id3153190" localize="false"/>
<bookmark branch="hid/modules/scalc/ui/standardfilterdialog/rbcopyarea"
id="bm_id3150010" localize="false"/>
-<bookmark branch="hid/modules/scalc/ui/advancedfilterdialog/rbcopyarea"
id="bm_id3146985" localize="false"/>
+
<h2 id="hd_id3153760">Shrink / Expand</h2>
<paragraph id="par_id3153087" role="paragraph"><ahelp hid=".">Click the
<emph>Shrink</emph> icon to reduce the dialog to the size of the input field.
It is then easier to mark the required reference in the sheet. The icons then
automatically convert to the <emph>Expand</emph> icon. Click it to restore the
dialog to its original size.</ahelp></paragraph>
<paragraph id="par_id3155062" role="paragraph">The dialog is automatically
minimized when you click into a sheet with the mouse. As soon as you release
the mouse button, the dialog is restored and the reference range defined with
the mouse is highlighted in the document by a blue frame.</paragraph>
diff --git a/source/text/shared/00/00000409.xhp
b/source/text/shared/00/00000409.xhp
index c72f152bdc..b24278c94e 100644
--- a/source/text/shared/00/00000409.xhp
+++ b/source/text/shared/00/00000409.xhp
@@ -19,7 +19,7 @@
<helpdocument version="1.0">
<meta>
<topic id="textshared0000000409xml" indexer="exclude" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Toolbars</title>
+<title id="tit">Toolbars</title>
<filename>/text/shared/00/00000409.xhp</filename>
</topic>
<history>
@@ -28,24 +28,24 @@
</meta>
<body>
-
<h1 id="hd_id3149517">Toolbars</h1>
<section id="standard_filter">
- <paragraph role="paragraph" id="par_id3156053" xml-lang="en-US">Choose
<emph>Data - More Filters - Standard Filter</emph>.</paragraph>
- <paragraph xml-lang="en-US" role="paragraph" id="par_id3154350">Database
table view: <emph>Standard Filter</emph> icon in the <emph>Database</emph>
toolbar.</paragraph>
- <paragraph xml-lang="en-US" role="paragraph" id="par_id3154183">Form view:
<emph>Standard Filter</emph> icon in the <emph>Form</emph> bar.</paragraph>
- <table id="tbl_id3149976">
-
- <tablerow>
- <tablecell>
- <paragraph role="paragraph" id="par_id3155619" xml-lang="en-US"><image
src="cmd/sc_formfiltered.png" id="img_id3147588" width="1cm" height="1cm"><alt
xml-lang="en-US" id="alt_id3147588">Icon Standard
Filter</alt></image></paragraph>
- </tablecell>
- <tablecell>
- <paragraph role="paragraph" id="par_id3148731" xml-lang="en-US">Standard
Filter</paragraph>
- </tablecell>
- </tablerow>
-
- </table>
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3156053">Choose <emph>Data - More
Filters - Standard Filter</emph>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id381703618952856">Choose
<menuitem>Data - Standard Filter</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id881703618957531">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Standard Filter</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tbl_id3149976">
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3155619"><image
src="cmd/lc_formfiltered.svg" id="img_id3147588" width="1cm" height="1cm"><alt
id="alt_id3147588">Icon Standard Filter</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3148731">Standard
Filter</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
</section>
</body>
diff --git a/source/text/shared/02/12090100.xhp
b/source/text/shared/02/12090100.xhp
index f41f6b1b39..fcab8c52a0 100644
--- a/source/text/shared/02/12090100.xhp
+++ b/source/text/shared/02/12090100.xhp
@@ -22,62 +22,65 @@
<meta>
<topic id="textshared0212090100xml" indexer="include" status="PUBLISH">
- <title xml-lang="en-US" id="tit">Standard Filter</title>
+ <title id="tit">Standard Filter</title>
<filename>/text/shared/02/12090100.xhp</filename>
</topic>
</meta>
<body>
- <bookmark xml-lang="en-US" branch="hid/.uno:DataFilterStandardFilter"
id="bm_id9065823" localize="false"/>
- <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/standardfilterdialog/StandardFilterDialog"
id="bm_id3154232" localize="false"/>
- <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/standardfilterdialog/@@nowidget@@"
id="bm_id3154232" localize="false"/>
- <bookmark xml-lang="en-US"
branch="hid/dbaccess/ui/queryfilterdialog/QueryFilterDialog" id="bm_id3155888"
localize="false"/>
- <bookmark xml-lang="en-US"
branch="hid/dbaccess/ui/queryfilterdialog/@@nowidget@@" id="bm_id3155888"
localize="false"/>
- <h1 id="hd_id3151097"><variable id="StandardFilter_h1"><link
href="text/shared/02/12090100.xhp">Standard Filter</link></variable></h1>
- <paragraph xml-lang="en-US" id="par_id3149716" role="paragraph"><ahelp
hid=".">Specifies the logical conditions to filter your table data.</ahelp>
This dialog is available for spreadsheet documents, database tables and
database forms. The dialog for databases does not contain the <emph>More
Options</emph> button.</paragraph>
+ <bookmark branch="hid/.uno:DataFilterStandardFilter" id="bm_id9065823"
localize="false"/>
+ <bookmark
branch="hid/modules/scalc/ui/standardfilterdialog/StandardFilterDialog"
id="bm_id3154232" localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/standardfilterdialog/@@nowidget@@"
id="bm_id3154232" localize="false"/>
+ <bookmark branch="hid/dbaccess/ui/queryfilterdialog/QueryFilterDialog"
id="bm_id3155888" localize="false"/>
+ <bookmark branch="hid/dbaccess/ui/queryfilterdialog/@@nowidget@@"
id="bm_id3155888" localize="false"/>
+ <bookmark
branch="hid/modules/scalc/ui/notebookbar/MenuData-DataFilterStandardFilter"
id="bm_id181703623852269" localize="false"/>
+ <section id="standardfilter">
+ <h1 id="hd_id3151097"><variable id="StandardFilter_h1"><link
href="text/shared/02/12090100.xhp">Standard Filter</link></variable></h1>
+ <paragraph id="par_id3149716" role="paragraph"><ahelp hid=".">Specifies
the logical conditions to filter your table data.</ahelp> This dialog is
available for spreadsheet documents, database tables and database forms. The
dialog for databases does not contain the <emph>More Options</emph>
button.</paragraph>
+ </section>
<section id="howtoget">
<embed href="text/shared/00/00000409.xhp#standard_filter"/>
</section>
<switch select="appl">
<case select="CALC">
-<paragraph xml-lang="en-US" id="par_idN105EE" role="paragraph"
localize="false">
+<paragraph id="par_idN105EE" role="paragraph" localize="false">
<embedvar href="text/scalc/guide/filters.xhp#filters"/>
</paragraph>
</case>
</switch>
<h2 id="hd_id3155555">Filter criteria</h2>
- <paragraph xml-lang="en-US" id="par_id3147834" role="paragraph">You can
define a filter by indicating the type of line, the name of the field, a
logical condition and a value or a combination of arguments.</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/standardfilterdialog/connect1" id="bm_id3153683"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/standardfilterdialog/connect2" id="bm_id3147577"
localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/queryfilterdialog/op2"
id="bm_id3155892" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/queryfilterdialog/op3"
id="bm_id3150774" localize="false"/>
+ <paragraph id="par_id3147834" role="paragraph">You can define a filter
by indicating the type of line, the name of the field, a logical condition and
a value or a combination of arguments.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/standardfilterdialog/connect1"
id="bm_id3153683" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/standardfilterdialog/connect2"
id="bm_id3147577" localize="false"/>
+<bookmark branch="hid/dbaccess/ui/queryfilterdialog/op2" id="bm_id3155892"
localize="false"/>
+<bookmark branch="hid/dbaccess/ui/queryfilterdialog/op3" id="bm_id3150774"
localize="false"/>
<h2 id="hd_id3149751">Operator</h2>
- <paragraph xml-lang="en-US" id="par_id3149177" role="paragraph"><ahelp
hid=".">For the following arguments, you can choose between the logical
operators AND / OR.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/standardfilterdialog/field1" id="bm_id3153682"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/standardfilterdialog/field2" id="bm_id3155942"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/standardfilterdialog/field3" id="bm_id3150693"
localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/queryfilterdialog/field1"
id="bm_id3153345" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/queryfilterdialog/field2"
id="bm_id3155535" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/queryfilterdialog/field3"
id="bm_id3148538" localize="false"/>
+ <paragraph id="par_id3149177" role="paragraph"><ahelp hid=".">For the
following arguments, you can choose between the logical operators AND /
OR.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/standardfilterdialog/field1"
id="bm_id3153682" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/standardfilterdialog/field2"
id="bm_id3155942" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/standardfilterdialog/field3"
id="bm_id3150693" localize="false"/>
+<bookmark branch="hid/dbaccess/ui/queryfilterdialog/field1" id="bm_id3153345"
localize="false"/>
+<bookmark branch="hid/dbaccess/ui/queryfilterdialog/field2" id="bm_id3155535"
localize="false"/>
+<bookmark branch="hid/dbaccess/ui/queryfilterdialog/field3" id="bm_id3148538"
localize="false"/>
<h2 id="hd_id3149182">Field name</h2>
- <paragraph xml-lang="en-US" id="par_id3149398" role="paragraph"><ahelp
hid=".">Specifies the field names from the current table to set them in the
argument.</ahelp> You will see the column identifiers if no text is available
for the field names.</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/standardfilterdialog/cond1" id="bm_id3149811"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/standardfilterdialog/cond2" id="bm_id3153760"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/standardfilterdialog/cond3" id="bm_id3153126"
localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/queryfilterdialog/cond1"
id="bm_id3159270" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/queryfilterdialog/cond2"
id="bm_id3148990" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/queryfilterdialog/cond3"
id="bm_id3153252" localize="false"/>
+ <paragraph id="par_id3149398" role="paragraph"><ahelp hid=".">Specifies
the field names from the current table to set them in the argument.</ahelp> You
will see the column identifiers if no text is available for the field
names.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/standardfilterdialog/cond1"
id="bm_id3149811" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/standardfilterdialog/cond2"
id="bm_id3153760" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/standardfilterdialog/cond3"
id="bm_id3153126" localize="false"/>
+<bookmark branch="hid/dbaccess/ui/queryfilterdialog/cond1" id="bm_id3159270"
localize="false"/>
+<bookmark branch="hid/dbaccess/ui/queryfilterdialog/cond2" id="bm_id3148990"
localize="false"/>
+<bookmark branch="hid/dbaccess/ui/queryfilterdialog/cond3" id="bm_id3153252"
localize="false"/>
<h2 id="hd_id3147653">Condition</h2>
- <paragraph xml-lang="en-US" id="par_id3150254" role="paragraph"><ahelp
hid=".">Specifies the <link href="text/shared/02/12090101.xhp">comparative
operators</link> through which the entries in the <emph>Field name</emph> and
<emph>Value</emph> fields can be linked.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/standardfilterdialog/val1" id="bm_id3155136"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/standardfilterdialog/val2" id="bm_id3148492"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/standardfilterdialog/val3" id="bm_id3150276"
localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/queryfilterdialog/value1"
id="bm_id3146949" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/queryfilterdialog/value2"
id="bm_id3153700" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/queryfilterdialog/value3"
id="bm_id3159400" localize="false"/>
+ <paragraph id="par_id3150254" role="paragraph"><ahelp hid=".">Specifies
the <link href="text/shared/02/12090101.xhp">comparative operators</link>
through which the entries in the <emph>Field name</emph> and <emph>Value</emph>
fields can be linked.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/standardfilterdialog/val1"
id="bm_id3155136" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/standardfilterdialog/val2"
id="bm_id3148492" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/standardfilterdialog/val3"
id="bm_id3150276" localize="false"/>
+<bookmark branch="hid/dbaccess/ui/queryfilterdialog/value1" id="bm_id3146949"
localize="false"/>
+<bookmark branch="hid/dbaccess/ui/queryfilterdialog/value2" id="bm_id3153700"
localize="false"/>
+<bookmark branch="hid/dbaccess/ui/queryfilterdialog/value3" id="bm_id3159400"
localize="false"/>
<h2 id="hd_id3149166">Value</h2>
- <paragraph xml-lang="en-US" id="par_id3149795" role="paragraph"><ahelp
hid=".">Specifies a value to filter the field.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="par_id3150976"
role="paragraph">The<emph> Value </emph>list box contains all possible values
for the specified <emph>Field name</emph> . Choose the value to be used in the
filter. You can also choose the <emph>- empty -</emph> or <emph>-not empty
-</emph> entries..</paragraph>
- <paragraph xml-lang="en-US" id="par_id3156118" role="paragraph">If you
use the filter function in database tables or forms, then type the value in the
<emph>Value </emph>text box to be used for filtering.</paragraph>
+ <paragraph id="par_id3149795" role="paragraph"><ahelp hid=".">Specifies
a value to filter the field.</ahelp></paragraph>
+ <paragraph id="par_id3150976" role="paragraph">The<emph> Value
</emph>list box contains all possible values for the specified <emph>Field
name</emph> . Choose the value to be used in the filter. You can also choose
the <emph>- empty -</emph> or <emph>-not empty -</emph> entries..</paragraph>
+ <paragraph id="par_id3156118" role="paragraph">If you use the filter
function in database tables or forms, then type the value in the <emph>Value
</emph>text box to be used for filtering.</paragraph>
<switch select="appl">
<case select="CALC">
<h2 id="hd_id3153061"><link
href="text/scalc/01/12040201.xhp">Options</link></h2>
