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.hallot@libreoffice.org>

11 files changed, 235 insertions, 196 deletions

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">&lt;160000</paragraph>
+     <paragraph id="par_id3155957" role="paragraph" localize="false">&lt;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>