tdf#155876 UI cmds Calc-Sheet menu (32)

+ Sheet menu for Calc: manage Names
+ untangle manage names and define names
+ refactoring

Change-Id: I27fe448ae251cb98a829e92c307fc31ad3b2c967
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160845
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
(cherry picked from commit 2a305eedde1c9f9e1ba4af534688b4f83ea814d8)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160854

9 files changed, 352 insertions, 247 deletions

diff --git a/source/text/scalc/00/00000404.xhp b/source/text/scalc/00/00000404.xhp
index 7473556970..52a29b8dc8 100644
--- a/source/text/scalc/00/00000404.xhp
+++ b/source/text/scalc/00/00000404.xhp
@@ -262,7 +262,12 @@
 </variable></paragraph>
 <paragraph role="paragraph" id="par_id3154059"><variable id="addinana"><emph>Insert - Function</emph> - Category <emph>Add-In</emph>
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3153250"><variable id="einamen">Choose <menuitem>Insert - Named Range or Expression</menuitem>.</variable></paragraph>
+
+<section id="names">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_id3153250"><variable id="einamen">Choose <menuitem>Insert - Named Range or Expression</menuitem>.</variable></paragraph>
+  <paragraph role="paragraph" id="par_id61702668060030">Choose <menuitem>Sheet - Named Range or Expression</menuitem></paragraph>
+</section>
 
 <section id="extlink">
   <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
@@ -282,9 +287,50 @@
   </table>
 </section>
 
+<section id="manage_names">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_id751702675082804">Choose <menuitem>Sheet - Named Ranges and Expressions - Manage</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+  <paragraph role="paragraph" id="par_id301702675433245">Choose <menuitem>Insert - Manage Names</menuitem>.</paragraph>
+  <paragraph role="paragraph" id="par_id601702675437816">Choose <menuitem>Data - Manage Names</menuitem>.</paragraph>
+  <paragraph role="paragraph" id="par_id641702675445810">On the <menuitem>Insert</menuitem> menu of the <menuitem>Insert</menuitem> tab, choose <menuitem>Manage</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+  <table id="tab_id551702675107129">
+    <tablerow>
+      <tablecell>
+        <paragraph id="par_id661702675107130" role="paragraph"><image src="cmd/lc_definename.svg" id="img_id561702675107131" width="1cm"  height="1cm"><alt id="alt_id721702675107132">Icon Manage Names</alt></image></paragraph>
+      </tablecell>
+      <tablecell>
+        <paragraph id="par_id121702675107134" role="paragraph">Manage Names</paragraph>
+      </tablecell>
+    </tablerow>
+  </table>
+    <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+  <paragraph role="paragraph" id="par_id3149385"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> + F3</paragraph>
+  <h3 id="hd_id201702761733377">Other</h3>
+  <paragraph role="paragraph" id="par_id521702676756048">On the drop-down list in the <link href="text/scalc/02/06010000.xhp"><emph>Name Box</emph></link> of the <emph>Formula Bar</emph>, select <menuitem>Manage Names</menuitem>.</paragraph>
+</section>
+
 <section id="define_name">
-<paragraph role="paragraph" id="par_id3143222">Choose <menuitem>Sheet - Named Ranges and Expressions - Define</menuitem>.</paragraph>
-<paragraph role="paragraph" id="par_id3149385"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F3</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_id3143222">Choose <menuitem>Sheet - Named Ranges and Expressions - Define</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+  <paragraph role="paragraph" id="par_id801702661547552">Choose <menuitem>Insert - Define Name</menuitem>.</paragraph>
+  <paragraph role="paragraph" id="par_id601702661988059">Choose <menuitem>Data - Define Name</menuitem>.</paragraph>
+  <paragraph role="paragraph" id="par_id811702661629800">On the <menuitem>Insert</menuitem> menu of the <menuitem>Insert</menuitem> tab, choose <menuitem>Define</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+  <table id="tab_id11702662103998">
+    <tablerow>
+      <tablecell>
+        <paragraph id="par_id871702662103999" role="paragraph"><image src="cmd/lc_label.svg" id="img_id321702662104000" width="1cm"  height="1cm"><alt id="alt_id281702662104001">Icon Define Name</alt></image></paragraph>
+      </tablecell>
+      <tablecell>
+        <paragraph id="par_id621702662104003" role="paragraph">Define Name</paragraph>
+      </tablecell>
+    </tablerow>
+  </table>
+  <h3 id="hd_id201702661733377">Other</h3>
+  <paragraph role="paragraph" id="par_id321702661807915">On the <link href="text/scalc/02/06010000.xhp"><emph>Name Box</emph></link> of the <emph>Formula Bar</emph>, insert a name for the selected cells range and press <keycode>Enter</keycode>.</paragraph>
 </section>
 
 <section id="insertnames">
@@ -295,7 +341,14 @@
   <paragraph role="paragraph" id="par_id21698845324130">On the <menuitem>Insert</menuitem> menu of the <menuitem>Insert</menuitem> tab, choose <menuitem>Named Ranges and Expressions</menuitem>.</paragraph>
 </section>
 
-<paragraph role="paragraph" id="par_id3153558"><variable id="einaueb">Choose <menuitem>Sheet - Named Ranges and Expressions - Create</menuitem>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3153483"><variable id="einabesch">Choose <menuitem>Sheet - Named Ranges and Expressions - Labels</menuitem>.</variable></paragraph>
+<section id="create_names">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_id3153558"><variable id="einaueb">Choose <menuitem>Sheet - Named Ranges and Expressions - Create</menuitem>.</variable></paragraph>
+</section>
+
+<section id="define_label_range">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_id3153483"><variable id="einabesch">Choose <menuitem>Sheet - Named Ranges and Expressions - Labels</menuitem>.</variable></paragraph>
+</section>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/04070000.xhp b/source/text/scalc/01/04070000.xhp
index af57b50a4d..fc9c04a2e4 100644
--- a/source/text/scalc/01/04070000.xhp
+++ b/source/text/scalc/01/04070000.xhp
@@ -27,21 +27,20 @@
 </history>
 </meta>
 <body>
-<section id="namen">
 <bookmark branch="hid/.uno:NamesMenu" id="bm_id2043214" localize="false"/>
+<section id="namen">
 <h1 id="hd_id3153951"><link href="text/scalc/01/04070000.xhp">Named Ranges and Expressions</link></h1>
 <paragraph role="paragraph" id="par_id3145801"><ahelp hid=".">Allows you to name the different sections of your spreadsheet document.</ahelp> By naming the different sections, you can easily <link href="text/scalc/01/02110000.xhp">navigate</link> through the spreadsheet documents and find specific information.</paragraph>
 </section>
 <section id="howtoget">
-  <embed href="text/scalc/00/00000404.xhp#einamen"/>
+  <embed href="text/scalc/00/00000404.xhp#names"/>
 </section>
-<h2 id="hd_id3153878"><link href="text/scalc/01/04070100.xhp">Define</link></h2>
-<embed href="text/scalc/01/04070100.xhp#namenfestlegentext"/>
-<h2 id="hd_id3146969"><link href="text/scalc/01/04070200.xhp">Insert</link></h2>
-<embed href="text/scalc/01/04070200.xhp#nameneinfuegentext"/>
-<h2 id="hd_id3155764"><link href="text/scalc/01/04070300.xhp">Apply</link></h2>
-<embed href="text/scalc/01/04070300.xhp#namenuebernehmentext"/>
-<h2 id="hd_id3156382"><link href="text/scalc/01/04070400.xhp">Labels</link></h2>
-<embed href="text/scalc/01/04070400.xhp#beschtext"/>
+
+<embed href="text/scalc/01/04070100.xhp#definenames"/>
+<embed href="text/scalc/01/ManageNames.xhp#manage_names"/>
+<embed href="text/scalc/01/04070200.xhp#insertname"/>
+<embed href="text/scalc/01/04070300.xhp#create_names"/>
+<embed href="text/scalc/01/04070400.xhp#define_label_range"/>
+
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/04070100.xhp b/source/text/scalc/01/04070100.xhp
index 03db97a285..5d03d25b26 100644
--- a/source/text/scalc/01/04070100.xhp
+++ b/source/text/scalc/01/04070100.xhp
@@ -22,66 +22,67 @@
 
 <meta>
 <topic id="textscalc0104070100xml" indexer="include">
-<title id="tit" xml-lang="en-US">Define Names</title>
+<title id="tit">Define Names</title>
 <filename>/text/scalc/01/04070100.xhp</filename>
 </topic>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="hid/.uno:DefineName" id="bm_id4757802" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/DefineNameDialog" id="bm_id3155922" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/@@nowidget@@" id="bm_id3155922" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/ManageNamesDialog" id="bm_id3155923" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/@@nowidget@@" id="bm_id3155923" localize="false"/>
-<h1 id="hd_id3156330">Define Names</h1>
-<paragraph role="paragraph" id="par_id3154366" xml-lang="en-US"><variable id="namenfestlegentext"><ahelp hid=".uno:DefineName">Opens a dialog where you can specify a name for a selected area or a name for a formula expression.</ahelp>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_id3154123" xml-lang="en-US">Use the mouse to define ranges or type the reference into the <emph>Define Name </emph>dialog fields.</paragraph>
+<bookmark branch="hid/.uno:AddName" id="bm_id721702666245648" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/definename/DefineNameDialog" id="bm_id3155922" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/definename/@@nowidget@@" id="bm_id3155922" localize="false"/>
+
+<section id="definenames">
+    <h1 id="hd_id3156330"><link href="text/scalc/01/04070100.xhp">Define Names</link></h1>
+    <paragraph role="paragraph" id="par_id3154366"><variable id="namenfestlegentext"><ahelp hid=".uno:DefineName">Opens a dialog where you can specify a name for a selected area or a name for a formula expression.</ahelp></variable></paragraph>
+</section>
+
+<paragraph role="paragraph" id="par_id3154123">Use the mouse to define ranges or type the reference into the <emph>Define Name </emph>dialog fields.</paragraph>
 <section id="howtoget">
 <embed href="text/scalc/00/00000404.xhp#define_name"/>
 </section>
-<paragraph role="paragraph" id="par_id3155131" xml-lang="en-US">The <emph>Sheet Area</emph> box on the Formula bar contains a list of defined names for the ranges or formula expressions and their scope between parenthesis. Click a name from this box to highlight the corresponding reference on the spreadsheet. Names given formulas or parts of a formula are not listed here.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/edit" id="bm_id3151114" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/name" id="bm_id3151115" localize="false"/>
-<h2 id="hd_id3151118">Name</h2>
-<paragraph role="paragraph" id="par_id3163712" xml-lang="en-US"><ahelp hid=".">Enter the name of the area for which you want to define a reference or a formula expression.</ahelp> All area names already defined in the spreadsheet are listed in the text field above. If you click a name on the list, the corresponding reference in the document will be shown with a blue frame. If multiple cell ranges belong to the same area name, they are displayed with different colored frames.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/range" id="bm_id3145750" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/range" id="bm_id3145751" localize="false"/>
-<h2 id="hd_id3153728">Range or formula expression</h2>
-<paragraph role="paragraph" id="par_id3147435" xml-lang="en-US"><ahelp hid=".">The reference of the selected area name is shown here as an absolute value.</ahelp></paragraph>
-<paragraph role="paragraph" id="par_id3146986" xml-lang="en-US">To insert a new area reference, place the cursor in this field and use your mouse to select the desired area in any sheet of your spreadsheet document. To insert a new named formula, type the formula expression.</paragraph>
-<embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/scope" id="bm_id3148455" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/scope" id="bm_id3148456" localize="false"/>
-<h2 id="hd_id31547290">Scope</h2>
-<paragraph role="paragraph" id="hd_id31547291" xml-lang="en-US" level="2"><ahelp hid=".">Select the scope of the named range or named formula. Document (Global) means the name is valid for the whole document.</ahelp> Any other sheet name selected will restrict the scope of the named range or formula expression to that sheet. </paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/more" id="bm_id3148457" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/more" id="bm_id3148458" localize="false"/>
-<h2 id="hd_id3154729">Range options</h2>
-<paragraph role="paragraph" id="par_id3149958" xml-lang="en-US"><ahelp hid=".">Allows you to specify the <emph>Area type</emph> (optional) for the reference.</ahelp></paragraph>
-<paragraph role="paragraph" id="par_id3155416" xml-lang="en-US">Defines additional options related to the type of reference area.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/printarea" id="bm_id3146972" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/printrange" id="bm_id3146973" localize="false"/>
-<h4 id="hd_id3150716">Print range</h4>
-<paragraph role="paragraph" id="par_id3150751" xml-lang="en-US"><ahelp hid=".">Defines the area as a print range.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/filter" id="bm_id3155446" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/filter" id="bm_id3155447" localize="false"/>
-<h4 id="hd_id3153764">Filter</h4>
-<paragraph role="paragraph" id="par_id3155766" xml-lang="en-US"><ahelp hid=".">Defines the selected area to be used in an <link href="text/scalc/01/12040300.xhp">advanced filter</link>.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/colheader" id="bm_id3147344" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/colheader" id="bm_id3147345" localize="false"/>
-<h4 id="hd_id3159267">Repeat column</h4>
-<paragraph role="paragraph" id="par_id3149565" xml-lang="en-US"><ahelp hid=".">Defines the area as a repeating column.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/rowheader" id="bm_id3154021" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/rowheader" id="bm_id3154022" localize="false"/>
-<h4 id="hd_id3153966">Repeat row</h4>
-<paragraph role="paragraph" id="par_id3150300" xml-lang="en-US"><ahelp hid=".">Defines the area as a repeating row.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/add" id="bm_id3150207" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/add" id="bm_id3150208" localize="false"/>
-<h2 id="hd_id3155112">Add</h2>
-<paragraph role="paragraph" id="par_id3159236" xml-lang="en-US"><ahelp hid=".">Click the <emph>Add</emph> button to add a new defined name.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/delete" id="bm_id3150209" localize="false"/>
-<embed href="text/shared/00/00000001.xhp#delete"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/names" id="bm_id3150210" localize="false"/>
-<paragraph role="paragraph" id="par_id3150301" xml-lang="en-US"><ahelp hid="modules/scalc/ui/managenamesdialog/names" visibility="hidden">Select a named range or named formula from the list to modify its properties.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3155131">The <emph>Sheet Area</emph> box on the Formula bar contains a list of defined names for the ranges or formula expressions and their scope between parenthesis. Click a name from this box to highlight the corresponding reference on the spreadsheet. Names given formulas or parts of a formula are not listed here.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/definename/edit" id="bm_id3151114" localize="false"/>
+<section id="h2name">
+    <h2 id="hd_id3151118">Name</h2>
+    <paragraph role="paragraph" id="par_id3163712"><ahelp hid=".">Enter the name of the area for which you want to define a reference or a formula expression.</ahelp> All area names already defined in the spreadsheet are listed in the text field above. If you click a name on the list, the corresponding reference in the document will be shown with a blue frame. If multiple cell ranges belong to the same area name, they are displayed with different colored frames.</paragraph>
+</section>
+
+<bookmark branch="hid/modules/scalc/ui/definename/range" id="bm_id3145750" localize="false"/>
+<section id="h2range">
+    <h2 id="hd_id3153728">Range or formula expression</h2>
+    <paragraph role="paragraph" id="par_id3147435"><ahelp hid=".">The reference of the selected area name is shown here as an absolute value.</ahelp></paragraph>
+    <paragraph role="paragraph" id="par_id3146986">To insert a new area reference, place the cursor in this field and use your mouse to select the desired area in any sheet of your spreadsheet document. To insert a new named formula, type the formula expression.</paragraph>
+    <embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
+</section>
+
+<bookmark branch="hid/modules/scalc/ui/definename/scope" id="bm_id3148455" localize="false"/>
+<section id="h2scope">
+    <h2 id="hd_id31547290">Scope</h2>
+    <paragraph role="paragraph" id="hd_id31547291"><ahelp hid=".">Select the scope of the named range or named formula. Document (Global) means the name is valid for the whole document.</ahelp> Any other sheet name selected will restrict the scope of the named range or formula expression to that sheet. </paragraph>
+</section>
+
+<bookmark branch="hid/modules/scalc/ui/definename/more" id="bm_id3148457" localize="false"/>
+
+<section id="h2options">
+    <h2 id="hd_id3154729">Range options</h2>
+    <paragraph role="paragraph" id="par_id3149958"><ahelp hid=".">Allows you to specify the <emph>Area type</emph> (optional) for the reference.</ahelp></paragraph>
+    <paragraph role="paragraph" id="par_id3155416">Defines additional options related to the type of reference area.</paragraph>
+    <bookmark branch="hid/modules/scalc/ui/definename/printarea" id="bm_id3146972" localize="false"/>
+    <h3 id="hd_id3150716">Print range</h3>
+    <paragraph role="paragraph" id="par_id3150751"><ahelp hid=".">Defines the area as a print range.</ahelp></paragraph>
+    <bookmark branch="hid/modules/scalc/ui/definename/filter" id="bm_id3155446" localize="false"/>
+    <h3 id="hd_id3153764">Filter</h3>
+    <paragraph role="paragraph" id="par_id3155766"><ahelp hid=".">Defines the selected area to be used in an <link href="text/scalc/01/12040300.xhp">advanced filter</link>.</ahelp></paragraph>
+    <bookmark branch="hid/modules/scalc/ui/definename/colheader" id="bm_id3147344" localize="false"/>
+    <h3 id="hd_id3159267">Repeat column</h3>
+    <paragraph role="paragraph" id="par_id3149565"><ahelp hid=".">Defines the area as a repeating column.</ahelp></paragraph>
+    <bookmark branch="hid/modules/scalc/ui/definename/rowheader" id="bm_id3154021" localize="false"/>
+    <h3 id="hd_id3153966">Repeat row</h3>
+    <paragraph role="paragraph" id="par_id3150300"><ahelp hid=".">Defines the area as a repeating row.</ahelp></paragraph>
+    <bookmark branch="hid/modules/scalc/ui/definename/add" id="bm_id3150207" localize="false"/>
+    <h2 id="hd_id3155112">Add</h2>
+    <paragraph role="paragraph" id="par_id3159236"><ahelp hid=".">Click the <emph>Add</emph> button to add a new defined name.</ahelp></paragraph>
+</section>
+
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/04070200.xhp b/source/text/scalc/01/04070200.xhp
index d634bae21a..761a9c5ed9 100644
--- a/source/text/scalc/01/04070200.xhp
+++ b/source/text/scalc/01/04070200.xhp
@@ -35,7 +35,7 @@
 <bookmark branch="hid/modules/scalc/ui/insertname/@@nowidget@@" id="bm_id3154910" localize="false"/>
 
 <section id="insertname">
-  <h1 id="hd_id3153195"><variable id="h1"><link href="text/scalc/01/04070200.xhp">Named Range or Expression</link></variable></h1>
+  <h1 id="hd_id3153195"><variable id="h1"><link href="text/scalc/01/04070200.xhp">Insert Name</link></variable></h1>
   <paragraph role="paragraph" id="par_id3150011"><variable id="nameneinfuegentext"><ahelp hid=".uno:InsertName">Inserts a defined named cell range at the current cursor's position with the <emph>Paste Names</emph> dialog.</ahelp></variable></paragraph>
 </section>
 <note id="par_id3149412">You can only insert a cell area after having defined a name for the area.</note>
diff --git a/source/text/scalc/01/04070300.xhp b/source/text/scalc/01/04070300.xhp
index 76fa81909f..95ddb6c055 100644
--- a/source/text/scalc/01/04070300.xhp
+++ b/source/text/scalc/01/04070300.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="textscalc0104070300xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Creating Names</title>
+<title id="tit">Creating Names</title>
 <filename>/text/scalc/01/04070300.xhp</filename>
 </topic>
 <history>
@@ -30,32 +27,35 @@
 </history>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id3147264"><bookmark_value>cell ranges;creating names automatically</bookmark_value>
+<bookmark branch="index" id="bm_id3147264"><bookmark_value>cell ranges;creating names automatically</bookmark_value>
 <bookmark_value>names; for cell ranges</bookmark_value>
 </bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:CreateNames" id="bm_id8912439" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/createnamesdialog/CreateNamesDialog" id="bm_id3150398" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/createnamesdialog/@@nowidget@@" id="bm_id3150398" localize="false"/>
-<h1 id="hd_id3147264">Creating Names</h1>
-<paragraph role="paragraph" id="par_id3153969" xml-lang="en-US"><variable id="namenuebernehmentext"><ahelp hid=".uno:CreateNames">Allows you to automatically name multiple cell ranges.</ahelp>
-</variable></paragraph>
+<bookmark branch="hid/.uno:CreateNames" id="bm_id8912439" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/createnamesdialog/CreateNamesDialog" id="bm_id3150398" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/createnamesdialog/@@nowidget@@" id="bm_id3150398" localize="false"/>
+
+<section id="create_names">
+  <h1 id="hd_id3147264"><link href="text/scalc/01/04070300.xhp">Create Names</link></h1>
+<paragraph role="paragraph" id="par_id3153969"><variable id="namenuebernehmentext"><ahelp hid=".uno:CreateNames">Allows you to automatically name multiple cell ranges.</ahelp></variable></paragraph>
+</section>
+
 <section id="howtoget">
-  <embed href="text/scalc/00/00000404.xhp#einaueb"/>
+  <embed href="text/scalc/00/00000404.xhp#create_names"/>
 </section>
-<paragraph role="paragraph" id="par_id3156280" xml-lang="en-US">Select the area containing all the ranges that you want to name. Then choose <emph>Sheet - Named Ranges and Expressions - Create</emph>. This opens the <emph>Create Names</emph> dialog, from which you can select the naming options that you want.</paragraph>
+<paragraph role="paragraph" id="par_id3156280">Select the area containing all the ranges that you want to name. Then choose <emph>Sheet - Named Ranges and Expressions - Create</emph>. This opens the <emph>Create Names</emph> dialog, from which you can select the naming options that you want.</paragraph>
 <h2 id="hd_id3151116">Create names from</h2>
-<paragraph role="paragraph" id="par_id3152597" xml-lang="en-US">Defines which part of the spreadsheet is to be used for creating the name.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/createnamesdialog/top" id="bm_id3156444" localize="false"/>
+<paragraph role="paragraph" id="par_id3152597">Defines which part of the spreadsheet is to be used for creating the name.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/createnamesdialog/top" id="bm_id3156444" localize="false"/>
 <h3 id="hd_id3153729">Top row</h3>
-<paragraph role="paragraph" id="par_id3149263" xml-lang="en-US"><ahelp hid="modules/scalc/ui/createnamesdialog/top">Creates the range names from the header row of the selected range.</ahelp> Each column receives a separated name and cell reference.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/createnamesdialog/left" id="bm_id3145749" localize="false"/>
+<paragraph role="paragraph" id="par_id3149263"><ahelp hid="modules/scalc/ui/createnamesdialog/top">Creates the range names from the header row of the selected range.</ahelp> Each column receives a separated name and cell reference.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/createnamesdialog/left" id="bm_id3145749" localize="false"/>
 <h3 id="hd_id3146984">Left Column</h3>
-<paragraph role="paragraph" id="par_id3153190" xml-lang="en-US"><ahelp hid="modules/scalc/ui/createnamesdialog/left">Creates the range names from the entries in the first column of the selected sheet range.</ahelp> Each row receives a separated name and cell reference.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/createnamesdialog/bottom" id="bm_id3145645" localize="false"/>
+<paragraph role="paragraph" id="par_id3153190"><ahelp hid="modules/scalc/ui/createnamesdialog/left">Creates the range names from the entries in the first column of the selected sheet range.</ahelp> Each row receives a separated name and cell reference.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/createnamesdialog/bottom" id="bm_id3145645" localize="false"/>
 <h3 id="hd_id3156284">Bottom row</h3>
-<paragraph role="paragraph" id="par_id3147124" xml-lang="en-US"><ahelp hid="modules/scalc/ui/createnamesdialog/bottom">Creates the range names from the entries in the last row of the selected sheet range.</ahelp> Each column receives a separated name and cell reference.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/createnamesdialog/right" id="bm_id3145253" localize="false"/>
+<paragraph role="paragraph" id="par_id3147124"><ahelp hid="modules/scalc/ui/createnamesdialog/bottom">Creates the range names from the entries in the last row of the selected sheet range.</ahelp> Each column receives a separated name and cell reference.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/createnamesdialog/right" id="bm_id3145253" localize="false"/>
 <h3 id="hd_id3154731">Right Column</h3>
-<paragraph role="paragraph" id="par_id3153158" xml-lang="en-US"><ahelp hid="modules/scalc/ui/createnamesdialog/right">Creates the range names from the entries in the last column of the selected sheet range.</ahelp> Each row receives a separated name and cell reference.</paragraph>
+<paragraph role="paragraph" id="par_id3153158"><ahelp hid="modules/scalc/ui/createnamesdialog/right">Creates the range names from the entries in the last column of the selected sheet range.</ahelp> Each row receives a separated name and cell reference.</paragraph>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/04070400.xhp b/source/text/scalc/01/04070400.xhp
index 6ed548c49d..60fef5b4a8 100644
--- a/source/text/scalc/01/04070400.xhp
+++ b/source/text/scalc/01/04070400.xhp
@@ -22,45 +22,47 @@
 
 <meta>
 <topic id="textscalc0104070400xml" indexer="include">
-<title id="tit" xml-lang="en-US">Define Label Range</title>
+<title id="tit">Define Label Range</title>
 <filename>/text/scalc/01/04070400.xhp</filename>
 </topic>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id3150791"><bookmark_value>sheets; defining label ranges</bookmark_value>
+<bookmark branch="index" id="bm_id3150791"><bookmark_value>sheets; defining label ranges</bookmark_value>
 <bookmark_value>label ranges in sheets</bookmark_value>
 </bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:DefineLabelRange" id="bm_id9319643" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/NameRangesDialog" id="bm_id3150447" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/@@nowidget@@" id="bm_id3150447" localize="false"/>
-<paragraph role="heading" id="hd_id3150791" xml-lang="en-US" level="1"><variable id="define_label_range"><link href="text/scalc/01/04070400.xhp">Define Label Range</link>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_id3150868" xml-lang="en-US"><variable id="beschtext"><ahelp hid=".uno:DefineLabelRange">Opens a dialog in which you can define a label range.</ahelp>
-</variable></paragraph>
+<bookmark branch="hid/.uno:DefineLabelRange" id="bm_id9319643" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/NameRangesDialog" id="bm_id3150447" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/@@nowidget@@" id="bm_id3150447" localize="false"/>
+
+<section id="define_label_range">
+    <h1 id="hd_id3150791"><link href="text/scalc/01/04070400.xhp">Define Label Range</link></h1>
+    <paragraph role="paragraph" id="par_id3150868"><variable id="beschtext"><ahelp hid=".uno:DefineLabelRange">Opens a dialog in which you can define a label range.</ahelp></variable></paragraph>
+</section>
+
 <section id="howtoget">
-<embed href="text/scalc/00/00000404.xhp#einabesch"/>
+<embed href="text/scalc/00/00000404.xhp#define_label_range"/>
 </section>
 <embed href="text/scalc/guide/address_auto.xhp#address_auto"/>
-<paragraph role="paragraph" id="par_id3155411" xml-lang="en-US">The cell contents of a label range can be used like names in formulas - $[officename] recognizes these names in the same manner that it does the predefined names of the weekdays and months. These names are automatically completed when typed into a formula. In addition, the names defined by label ranges will have priority over names defined by automatically generated ranges.</paragraph>
-<paragraph role="note" id="par_id3147435" xml-lang="en-US">You can set label ranges that contain the same labels on different sheets. $[officename] first searches the label ranges of the current sheet and, following a failed search, the ranges of other sheets.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/range" id="bm_id3149958" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/edassign" id="bm_id3148457" localize="false"/>
+<paragraph role="paragraph" id="par_id3155411">The cell contents of a label range can be used like names in formulas - $[officename] recognizes these names in the same manner that it does the predefined names of the weekdays and months. These names are automatically completed when typed into a formula. In addition, the names defined by label ranges will have priority over names defined by automatically generated ranges.</paragraph>
+<note id="par_id3147435">You can set label ranges that contain the same labels on different sheets. $[officename] first searches the label ranges of the current sheet and, following a failed search, the ranges of other sheets.</note>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/range" id="bm_id3149958" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/edassign" id="bm_id3148457" localize="false"/>
 <h2 id="hd_id3145801">Range</h2>
-<paragraph role="paragraph" id="par_id3154731" xml-lang="en-US"><ahelp hid="modules/scalc/ui/namerangesdialog/edassign">Displays the cell reference of each label range.</ahelp> In order to remove a label range from the list box, select it and then click <emph>Delete</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3154731"><ahelp hid="modules/scalc/ui/namerangesdialog/edassign">Displays the cell reference of each label range.</ahelp> In order to remove a label range from the list box, select it and then click <emph>Delete</emph>.</paragraph>
 <embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/colhead" id="bm_id3155064" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/colhead" id="bm_id3155064" localize="false"/>
 <h3 id="hd_id3149121">Contains column labels</h3>
-<paragraph role="paragraph" id="par_id3150330" xml-lang="en-US"><ahelp hid="modules/scalc/ui/namerangesdialog/colhead">Includes column labels in the current label range.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/rowhead" id="bm_id3145642" localize="false"/>
+<paragraph role="paragraph" id="par_id3150330"><ahelp hid="modules/scalc/ui/namerangesdialog/colhead">Includes column labels in the current label range.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/rowhead" id="bm_id3145642" localize="false"/>
 <h3 id="hd_id3149020">Contains row labels</h3>
-<paragraph role="paragraph" id="par_id3154754" xml-lang="en-US"><ahelp hid="modules/scalc/ui/namerangesdialog/rowhead">Includes row labels in the current label range.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/edassign2" id="bm_id3146919" localize="false"/>
+<paragraph role="paragraph" id="par_id3154754"><ahelp hid="modules/scalc/ui/namerangesdialog/rowhead">Includes row labels in the current label range.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/edassign2" id="bm_id3146919" localize="false"/>
 <h3 id="hd_id3159264">For data range</h3>
-<paragraph role="paragraph" id="par_id3154703" xml-lang="en-US"><ahelp hid="modules/scalc/ui/namerangesdialog/edassign2">Sets the data range for which the selected label range is valid. To modify it, click in the sheet and select another range with the mouse.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3154703"><ahelp hid="modules/scalc/ui/namerangesdialog/edassign2">Sets the data range for which the selected label range is valid. To modify it, click in the sheet and select another range with the mouse.</ahelp></paragraph>
 <embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/add" id="bm_id3150299" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/add" id="bm_id3150299" localize="false"/>
 <h2 id="hd_id3145789">Add</h2>
-<paragraph role="paragraph" id="par_id3147005" xml-lang="en-US"><ahelp hid="modules/scalc/ui/namerangesdialog/add">Adds the current label range to the list.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3147005"><ahelp hid="modules/scalc/ui/namerangesdialog/add">Adds the current label range to the list.</ahelp></paragraph>
 <embed href="text/shared/00/00000001.xhp#delete"/>
 <section id="relatedtopics">
 <embed href="text/scalc/guide/address_auto.xhp#address_auto"/>
diff --git a/source/text/scalc/01/ManageNames.xhp b/source/text/scalc/01/ManageNames.xhp
new file mode 100644
index 0000000000..c2b14007d0
--- /dev/null
+++ b/source/text/scalc/01/ManageNames.xhp
@@ -0,0 +1,49 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+    <!--
+    * This file is part of the LibreOffice project.
+    *
+    * This Source Code Form is subject to the terms of the Mozilla Public
+    * License, v. 2.0. If a copy of the MPL was not distributed with this
+    * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+    *
+    -->
+
+    <meta>
+        <topic id="textscalc01ManageNamesxhp" indexer="include" status="PUBLISH">
+            <title id="tit">Manage Names</title>
+            <filename>/text/scalc/01/ManageNames.xhp</filename>
+        </topic>
+    </meta>
+    <body>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/ManageNamesDialog" id="bm_id3155923" localize="false"/>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/@@nowidget@@" id="bm_id3155923" localize="false"/>
+    <bookmark branch="hid/.uno:DefineName" id="bm_id4757802" localize="false"/>
+    <section id="manage_names">
+        <h1 id="hd_id511702671562154"><variable id="h1"><link href="text/scalc/01/ManageNames.xhp">Manage Names</link></variable></h1>
+        <paragraph id="par_id971702671562156" role="paragraph">Opens a dialog where you can manage names in the spreadsheet.</paragraph>
+    </section>
+
+    <section id="howtoget">
+        <embed href="text/scalc/00/00000404.xhp#manage_names"/>
+    </section>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/names" id="bm_id3150210" localize="false"/>
+    <h2 id="hd_id421702675891023">Names area</h2>
+    <paragraph role="paragraph" id="par_id3150301"><ahelp hid="modules/scalc/ui/managenamesdialog/names">Select a named range or named formula from the list to modify its properties.</ahelp></paragraph>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/name" id="bm_id3151115" localize="false"/>
+    <embed href="text/scalc/01/04070100.xhp#h2name"/>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/range" id="bm_id3145751" localize="false"/>
+    <embed href="text/scalc/01/04070100.xhp#h2range"/>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/scope" id="bm_id3148456" localize="false"/>
+    <embed href="text/scalc/01/04070100.xhp#h2scope"/>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/more" id="bm_id3148458" localize="false"/>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/printrange" id="bm_id3146973" localize="false"/>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/filter" id="bm_id3155447" localize="false"/>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/colheader" id="bm_id3147345" localize="false"/>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/rowheader" id="bm_id3154022" localize="false"/>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/add" id="bm_id3150208" localize="false"/>
+    <embed href="text/scalc/01/04070100.xhp#h2options"/>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/delete" id="bm_id3150209" localize="false"/>
+    <embed href="text/shared/00/00000001.xhp#delete"/>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/main0116.xhp b/source/text/scalc/main0116.xhp
index 9e525c979e..4afdc0506d 100644
--- a/source/text/scalc/main0116.xhp
+++ b/source/text/scalc/main0116.xhp
@@ -49,10 +49,11 @@
 <embed href="text/scalc/01/04050100.xhp#sheetfromfile"/>
 <embed href="text/scalc/01/04090000.xhp#extdata"/>
 <embed href="text/scalc/01/02170000.xhp#deletesheet"/>
+<embed href="text/scalc/01/02150000.xhp#del_contents"/>
 <embed href="text/scalc/01/ToggleRelative.xhp#cycle_types"/>
 <embed href="text/scalc/01/02140000.xhp#fill"/>
+<embed href="text/scalc/01/04070000.xhp#namen"/>
 
-<embed href="text/scalc/01/02150000.xhp#del_contents"/>
 
 <h2 id="hd_id3150792"><link href="text/scalc/01/02180000.xhp">Move or Copy Sheet</link></h2>
 <embed href="text/scalc/01/02180000.xhp#tabelleverschiebenkopierentext"/>
diff --git a/source/text/shared/00/00000001.xhp b/source/text/shared/00/00000001.xhp
index caac6a48fa..b1f508f692 100644
--- a/source/text/shared/00/00000001.xhp
+++ b/source/text/shared/00/00000001.xhp
@@ -20,223 +20,223 @@
 
 <meta>
   <topic id="textshared0000000001xml" indexer="exclude">
-    <title xml-lang="en-US" id="tit">Frequently-Used Buttons</title>
+    <title id="tit">Frequently-Used Buttons</title>
     <filename>/text/shared/00/00000001.xhp</filename>
   </topic>
 </meta>
 <body>
 <h1 id="hd_id3152952">Frequently-Used Buttons</h1>
 <section id="help">
-  <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DBWIZ_HELP" id="bm_id911668777580235" localize="false"/>
+  <bookmark branch="hid/DBACCESS_HID_DBWIZ_HELP" id="bm_id911668777580235" localize="false"/>
   <h2 id="hd_id211668777619062">Help</h2>
   <paragraph role="paragraph" id="par_id761668777629023">Click the <menuitem>Help</menuitem> button to open the help page associated with the currently open dialog.</paragraph>
 </section>
 
 <section id="cancel">
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_CMDCANCEL" id="bm_id4245124" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_QUERYWIZARD_CANCEL" id="bm_id7074800" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGIMPORT_0_CMDCANCEL" id="bm_id3147653" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_FAXWIZARD_CANCEL" id="bm_id833765" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID0_CANCEL" id="bm_id7899105" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_GROUPWIZARD_CANCEL" id="bm_id3149183" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGFORM_CMDCANCEL" id="bm_id3149177" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGREPORT_0_CMDCANCEL" id="bm_id3154142" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_LISTWIZARD_CANCEL" id="bm_id3145416" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DBWIZ_CANCEL" id="bm_id1058076" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_DLGTABLE_CMDCANCEL" id="bm_id4245124" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_QUERYWIZARD_CANCEL" id="bm_id7074800" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_DLGIMPORT_0_CMDCANCEL" id="bm_id3147653" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_FAXWIZARD_CANCEL" id="bm_id833765" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID0_CANCEL" id="bm_id7899105" localize="false"/>
+<bookmark branch="hid/EXTENSIONS_HID_GROUPWIZARD_CANCEL" id="bm_id3149183" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_DLGFORM_CMDCANCEL" id="bm_id3149177" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_DLGREPORT_0_CMDCANCEL" id="bm_id3154142" localize="false"/>
+<bookmark branch="hid/EXTENSIONS_HID_LISTWIZARD_CANCEL" id="bm_id3145416" localize="false"/>
+<bookmark branch="hid/DBACCESS_HID_DBWIZ_CANCEL" id="bm_id1058076" localize="false"/>
 <h2 id="hd_id3147617">Cancel</h2>
-  <paragraph xml-lang="en-US" id="par_id3155913" role="paragraph"><ahelp hid=".">Clicking <emph>Cancel</emph> closes a dialog without saving any changes made.</ahelp></paragraph>
+  <paragraph id="par_id3155913" role="paragraph"><ahelp hid=".">Clicking <emph>Cancel</emph> closes a dialog without saving any changes made.</ahelp></paragraph>
 </section>
 
 <section id="finish">
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_CMDFINISH" id="bm_id3211157" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_QUERYWIZARD_CREATE" id="bm_id189519" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DBWIZ_FINISH" id="bm_id1058076" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_DLGTABLE_CMDFINISH" id="bm_id3211157" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_QUERYWIZARD_CREATE" id="bm_id189519" localize="false"/>
+<bookmark branch="hid/DBACCESS_HID_DBWIZ_FINISH" id="bm_id1058076" localize="false"/>
 <h2 id="hd_id2341685">Finish</h2>
-  <paragraph xml-lang="en-US" id="par_id6909390" role="paragraph"><ahelp hid=".">Applies all changes and closes the wizard.</ahelp></paragraph>
+  <paragraph id="par_id6909390" role="paragraph"><ahelp hid=".">Applies all changes and closes the wizard.</ahelp></paragraph>
 </section>
 
 <section id="toolbars">
 <h2 id="hd_id3147477">Toolbars</h2>
-  <paragraph xml-lang="en-US" id="par_id3149783" role="paragraph">By clicking the arrow next to some icons you open a toolbar. To move a toolbar, drag the title bar. As soon as you release the mouse button, the toolbar remains at the new position. Drag the title bar to another position, or drag to an edge of the window, where the toolbar will dock. Close a toolbar by clicking the <emph>Close Window</emph> icon. Make the toolbar visible again by choosing <emph>View - Toolbars - (toolbar name)</emph>.</paragraph>
+  <paragraph id="par_id3149783" role="paragraph">By clicking the arrow next to some icons you open a toolbar. To move a toolbar, drag the title bar. As soon as you release the mouse button, the toolbar remains at the new position. Drag the title bar to another position, or drag to an edge of the window, where the toolbar will dock. Close a toolbar by clicking the <emph>Close Window</emph> icon. Make the toolbar visible again by choosing <emph>View - Toolbars - (toolbar name)</emph>.</paragraph>
 </section>
 <section id="spin_button">
 <h2 id="hd_id3152414">Spin button</h2>
   <section id="spinbutton">
 <list type="ordered">
    <listitem>
-     <paragraph xml-lang="en-US" id="par_id1094088" role="paragraph">In form controls, a spin button is a property of a numerical field, currency field, date field, or time field. If the property "Spin button" is enabled, the field shows a pair of symbols with arrows pointing to opposing directions, either vertically or horizontally.</paragraph>
+     <paragraph id="par_id1094088" role="paragraph">In form controls, a spin button is a property of a numerical field, currency field, date field, or time field. If the property "Spin button" is enabled, the field shows a pair of symbols with arrows pointing to opposing directions, either vertically or horizontally.</paragraph>
    </listitem>
    <listitem>
-     <paragraph xml-lang="en-US" id="par_id7493209" role="paragraph">In the <emph>Basic IDE</emph>, a spin button is the name used for the numerical field together with the two arrow symbols.</paragraph>
+     <paragraph id="par_id7493209" role="paragraph">In the <emph>Basic IDE</emph>, a spin button is the name used for the numerical field together with the two arrow symbols.</paragraph>
    </listitem>
 </list>
-<paragraph xml-lang="en-US" id="par_id3155599" role="paragraph">You can type a numerical value into the field next to the spin button, or select the value with the <emph>Up Arrow</emph> or <emph>Down Arrow</emph> symbols on the spin button. On the keyboard you can press the <item type="keycode">Up Arrow</item> and <item type="keycode">Down Arrow</item> keys to increase or reduce the value. You can press the <item type="keycode">Page Up</item> and <item type="keycode">Page Down</item> keys to set the maximum and minimum value.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150264" role="paragraph">If the field next to the spin button defines numerical values, you can also define a <link href="text/shared/00/00000003.xhp#measurement_units">measurement unit</link>, for example, <emph>1 cm or 5 mm, 12 pt or 2"</emph>.</paragraph>
+<paragraph id="par_id3155599" role="paragraph">You can type a numerical value into the field next to the spin button, or select the value with the <emph>Up Arrow</emph> or <emph>Down Arrow</emph> symbols on the spin button. On the keyboard you can press the <item type="keycode">Up Arrow</item> and <item type="keycode">Down Arrow</item> keys to increase or reduce the value. You can press the <item type="keycode">Page Up</item> and <item type="keycode">Page Down</item> keys to set the maximum and minimum value.</paragraph>
+<paragraph id="par_id3150264" role="paragraph">If the field next to the spin button defines numerical values, you can also define a <link href="text/shared/00/00000003.xhp#measurement_units">measurement unit</link>, for example, <emph>1 cm or 5 mm, 12 pt or 2"</emph>.</paragraph>
   </section>
 </section>
 <section id="import">
 <h2 id="hd_id3154232">Convert</h2>
-  <paragraph xml-lang="en-US" id="par_id3148983" role="paragraph"><ahelp hid=".">If you click forward through the dialog, this button is called <emph>Next</emph>. On the last page the button has the name <emph>Convert</emph>. The conversion is then performed by clicking the button.</ahelp></paragraph>
+  <paragraph id="par_id3148983" role="paragraph"><ahelp hid=".">If you click forward through the dialog, this button is called <emph>Next</emph>. On the last page the button has the name <emph>Convert</emph>. The conversion is then performed by clicking the button.</ahelp></paragraph>
 </section>
 <section id="contextmenu">
 <h2 id="hd_id3145129">Context Menu</h2>
-<paragraph xml-lang="en-US" id="par_id3156553" role="paragraph"><variable id="context">To activate the context menu of an object, first click the object with the <switchinline select="sys"><caseinline select="MAC">
+<paragraph id="par_id3156553" role="paragraph"><variable id="context">To activate the context menu of an object, first click the object with the <switchinline select="sys"><caseinline select="MAC">
 </caseinline><defaultinline>left</defaultinline></switchinline> mouse button to select it, and then, <switchinline select="sys"><caseinline select="MAC">while holding down the <emph>Ctrl</emph> key or the <emph>Command</emph> and <emph>Option</emph> keys, click the mouse button again
 </caseinline><defaultinline> click the right mouse button</defaultinline></switchinline>. Some context menus can be called even if the object has not been selected. Context menus are found just about everywhere in $[officename].</variable></paragraph>
 </section>
 <section id="delete">
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/remove" id="bm_id3153766" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/delete" id="bm_id3153839" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/delete" id="bm_id3150089" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definedatabaserangedialog/delete" id="bm_id3146120" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/SW_HID_MD_GLOS_DELETE" id="bm_id3148722" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optsortslist/delete" id="bm_id3152577" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/colorpage/delete" id="bm_id3156382" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/hatchpage/delete" id="bm_id3148943" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/imagetabpage/BTN_DELETE" id="bm_id3149762" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/gradientpage/delete" id="bm_id3148924" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/lineendstabpage/BTN_DELETE" id="bm_id3153717" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/paratabspage/buttonBTN_DEL" id="bm_id3156007" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/BasicIDE/ui/macropage/delete" id="bm_id3143232" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/BasicIDE/ui/dialogpage/library" id="bm_id3214514" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/BasicIDE/ui/libpage/delete" id="bm_id3145749" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/linestyletabpage/BTN_DELETE" id="bm_id3150443" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/autoformattable/remove" id="bm_id3153766" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/delete" id="bm_id3153839" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/managenamesdialog/delete" id="bm_id3150089" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/definedatabaserangedialog/delete" id="bm_id3146120" localize="false"/>
+<bookmark branch="hid/SW_HID_MD_GLOS_DELETE" id="bm_id3148722" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/optsortslist/delete" id="bm_id3152577" localize="false"/>
+<bookmark branch="hid/cui/ui/colorpage/delete" id="bm_id3156382" localize="false"/>
+<bookmark branch="hid/cui/ui/hatchpage/delete" id="bm_id3148943" localize="false"/>
+<bookmark branch="hid/cui/ui/imagetabpage/BTN_DELETE" id="bm_id3149762" localize="false"/>
+<bookmark branch="hid/cui/ui/gradientpage/delete" id="bm_id3148924" localize="false"/>
+<bookmark branch="hid/cui/ui/lineendstabpage/BTN_DELETE" id="bm_id3153717" localize="false"/>
+<bookmark branch="hid/cui/ui/paratabspage/buttonBTN_DEL" id="bm_id3156007" localize="false"/>
+<bookmark branch="hid/modules/BasicIDE/ui/macropage/delete" id="bm_id3143232" localize="false"/>
+<bookmark branch="hid/modules/BasicIDE/ui/dialogpage/library" id="bm_id3214514" localize="false"/>
+<bookmark branch="hid/modules/BasicIDE/ui/libpage/delete" id="bm_id3145749" localize="false"/>
+<bookmark branch="hid/cui/ui/linestyletabpage/BTN_DELETE" id="bm_id3150443" localize="false"/>
 <h2 id="hd_id3149180">Delete</h2>
-  <paragraph xml-lang="en-US" id="par_id3153750" role="paragraph"><ahelp hid=".">Deletes the selected element or elements after confirmation.</ahelp></paragraph>
+  <paragraph id="par_id3153750" role="paragraph"><ahelp hid=".">Deletes the selected element or elements after confirmation.</ahelp></paragraph>
 </section>
 <section id="delete2">
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/consolidatedialog/delete" id="bm_id3146916" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/simpress/ui/customslideshows/delete" id="bm_id3147296" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/sw:PushButton:DLG_BIB_BASE:PB_DELETE" id="bm_id6168401" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/selectpathdialog/delete" id="bm_id3154687" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/multipathdialog/delete" id="bm_id3154686" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/acorreplacepage/delete" id="bm_id7878353" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/acorexceptpage/delabbrev" id="bm_id5413373" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/acorexceptpage/deldouble" id="bm_id2580950" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/consolidatedialog/delete" id="bm_id3146916" localize="false"/>
+<bookmark branch="hid/modules/simpress/ui/customslideshows/delete" id="bm_id3147296" localize="false"/>
+<bookmark branch="hid/sw:PushButton:DLG_BIB_BASE:PB_DELETE" id="bm_id6168401" localize="false"/>
+<bookmark branch="hid/cui/ui/selectpathdialog/delete" id="bm_id3154687" localize="false"/>
+<bookmark branch="hid/cui/ui/multipathdialog/delete" id="bm_id3154686" localize="false"/>
+<bookmark branch="hid/cui/ui/acorreplacepage/delete" id="bm_id7878353" localize="false"/>
+<bookmark branch="hid/cui/ui/acorexceptpage/delabbrev" id="bm_id5413373" localize="false"/>
+<bookmark branch="hid/cui/ui/acorexceptpage/deldouble" id="bm_id2580950" localize="false"/>
 <h2 id="hd_id3147557">Delete</h2>
-  <paragraph xml-lang="en-US" id="par_id3155338" role="paragraph"><ahelp hid=".">Deletes the selected element or elements without requiring confirmation.</ahelp></paragraph>
+  <paragraph id="par_id3155338" role="paragraph"><ahelp hid=".">Deletes the selected element or elements without requiring confirmation.</ahelp></paragraph>
 </section>
 <h2 id="hd_id3148620">Metrics</h2>
-  <paragraph xml-lang="en-US" id="par_id3145345" role="paragraph">You can enter values in the input fields in different <link href="text/shared/00/00000003.xhp#measurement_units">units of measurement</link>. The default unit is inches. However, if you want a space of exactly 1 cm, then type "1cm". Additional units are available according to the context, for example, 12 pt for a 12 point spacing. If the value of the new unit is unrealistic, the program uses a predefined maximum or minimum value.</paragraph>
+  <paragraph id="par_id3145345" role="paragraph">You can enter values in the input fields in different <link href="text/shared/00/00000003.xhp#measurement_units">units of measurement</link>. The default unit is inches. However, if you want a space of exactly 1 cm, then type "1cm". Additional units are available according to the context, for example, 12 pt for a 12 point spacing. If the value of the new unit is unrealistic, the program uses a predefined maximum or minimum value.</paragraph>
 <section id="close">
 <h2 id="hd_id3155535">Close</h2>
-  <paragraph xml-lang="en-US" id="par_id3147008" role="paragraph"><ahelp hid=".">Closes the dialog and saves all changes.</ahelp></paragraph>
+  <paragraph id="par_id3147008" role="paragraph"><ahelp hid=".">Closes the dialog and saves all changes.</ahelp></paragraph>
 </section>
 <section id="close2">
 <h2 id="hd_id3147275">Close</h2>
-  <paragraph xml-lang="en-US" id="par_id3153031" role="paragraph"><ahelp hid=".">Closes the dialog.</ahelp></paragraph>
+  <paragraph id="par_id3153031" role="paragraph"><ahelp hid=".">Closes the dialog.</ahelp></paragraph>
 </section>
 <section id="apply">
-<bookmark xml-lang="en-US" branch="hid/modules/smath/ui/catalogdialog/insert" id="bm_id3149053" localize="false"/>
+<bookmark branch="hid/modules/smath/ui/catalogdialog/insert" id="bm_id3149053" localize="false"/>
 <h2 id="hd_id3156113">Apply</h2>
-  <paragraph xml-lang="en-US" id="par_id3155341" role="paragraph"><ahelp hid=".">Applies the modified or selected values without closing the dialog.</ahelp></paragraph>
+  <paragraph id="par_id3155341" role="paragraph"><ahelp hid=".">Applies the modified or selected values without closing the dialog.</ahelp></paragraph>
 </section>
 <section id="only_ParaFramePage_style">
-<paragraph role="paragraph" xml-lang="en-US" id="par_id131583023155214">This option appears only for Paragraph Style, Frame Style, and Page Style.</paragraph>
+<paragraph role="paragraph" id="par_id131583023155214">This option appears only for Paragraph Style, Frame Style, and Page Style.</paragraph>
 </section>
 <section id="only_ParaChar_style">
-<paragraph role="paragraph" xml-lang="en-US" id="par_id131583023155356">This option appears only for Paragraph Style and Character Style.</paragraph>
+<paragraph role="paragraph" id="par_id131583023155356">This option appears only for Paragraph Style and Character Style.</paragraph>
 </section>
 <section id="shrink_maximize">
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/pivottablelayoutdialog/destination-button" id="bm_id3155067" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/multipleoperationsdialog/formulasref" id="bm_id3149785" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/multipleoperationsdialog/rowref" id="bm_id3149019" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/multipleoperationsdialog/colref" id="bm_id3153712" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/goalseekdlg/formulabutton" id="bm_id3153364" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/goalseekdlg/varbutton" id="bm_id3153363" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/rbassign" id="bm_id3149400" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/rbassign2" id="bm_id3155962" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/consolidatedialog/rbdataarea" id="bm_id3145640" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/consolidatedialog/rbdestarea" id="bm_id3153713" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/printareasdialog/rbprintarea" id="bm_id3152596" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/printareasdialog/rbrepeatrow" id="bm_id3146975" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/printareasdialog/rbrepeatcol" id="bm_id3154321" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/rbassign" id="bm_id3155532" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/assign" id="bm_id3159155" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definedatabaserangedialog/assignrb" id="bm_id3149262" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/advancedfilterdialog/rbfilterarea" id="bm_id3153190" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/standardfilterdialog/rbcopyarea" id="bm_id3150010" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/advancedfilterdialog/rbcopyarea" id="bm_id3146985" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/pivottablelayoutdialog/destination-button" id="bm_id3155067" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/multipleoperationsdialog/formulasref" id="bm_id3149785" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/multipleoperationsdialog/rowref" id="bm_id3149019" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/multipleoperationsdialog/colref" id="bm_id3153712" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/goalseekdlg/formulabutton" id="bm_id3153364" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/goalseekdlg/varbutton" id="bm_id3153363" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/rbassign" id="bm_id3149400" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/rbassign2" id="bm_id3155962" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/consolidatedialog/rbdataarea" id="bm_id3145640" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/consolidatedialog/rbdestarea" id="bm_id3153713" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/printareasdialog/rbprintarea" id="bm_id3152596" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/printareasdialog/rbrepeatrow" id="bm_id3146975" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/printareasdialog/rbrepeatcol" id="bm_id3154321" localize="false"/>
+<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 xml-lang="en-US" 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 xml-lang="en-US" 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>
+  <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>
 <table id="tbl_id3148473">
   <tablerow>
     <tablecell>
-      <paragraph xml-lang="en-US" id="par_id3157808" role="paragraph"><image id="img_id3148685" src="formula/res/refinp1.png" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id3148685">Icon shrink</alt></image></paragraph>
+      <paragraph id="par_id3157808" role="paragraph"><image id="img_id3148685" src="formula/res/refinp1.svg" width="1cm" height="1cm"><alt id="alt_id3148685">Icon shrink</alt></image></paragraph>
     </tablecell>
     <tablecell>
-      <paragraph xml-lang="en-US" id="par_id3153321" role="paragraph">Shrink</paragraph>
+      <paragraph id="par_id3153321" role="paragraph">Shrink</paragraph>
     </tablecell>
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph xml-lang="en-US" id="par_id3153349" role="paragraph"><image id="img_id3149784" src="formula/res/refinp2.png" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id3149784">Icon Expand</alt></image></paragraph>
+      <paragraph id="par_id3153349" role="paragraph"><image id="img_id3149784" src="formula/res/refinp2.svg" width="1cm" height="1cm"><alt id="alt_id3149784">Icon Expand</alt></image></paragraph>
     </tablecell>
     <tablecell>
-      <paragraph xml-lang="en-US" id="par_id3155628" role="paragraph">Expand</paragraph>
+      <paragraph id="par_id3155628" role="paragraph">Expand</paragraph>
     </tablecell>
   </tablerow>
 </table>
 </section>
 <section id="preview_field">
-<bookmark xml-lang="en-US" branch="hid/CUI_HID_MEASURE_CTL_PREVIEW" id="bm_id3157970" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/SVX_HID_GALLERY_PREVIEW" id="bm_id3153896" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/preview" id="bm_id3155601" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/autoformattable/preview" id="bm_id3147175" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inserttable/previewinstable" id="bm_id3147227" localize="false"/>
+<bookmark branch="hid/CUI_HID_MEASURE_CTL_PREVIEW" id="bm_id3157970" localize="false"/>
+<bookmark branch="hid/SVX_HID_GALLERY_PREVIEW" id="bm_id3153896" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/autoformattable/preview" id="bm_id3155601" localize="false"/>
+<bookmark branch="hid/modules/swriter/ui/autoformattable/preview" id="bm_id3147175" localize="false"/>
+<bookmark branch="hid/modules/swriter/ui/inserttable/previewinstable" id="bm_id3147227" localize="false"/>
 <h2 id="hd_id3156192">Preview Field</h2>
-  <paragraph xml-lang="en-US" id="par_id3154046" role="paragraph"><variable id="previewhelp"><ahelp hid=".">Displays a preview of the current selection.</ahelp></variable></paragraph>
+  <paragraph id="par_id3154046" role="paragraph"><variable id="previewhelp"><ahelp hid=".">Displays a preview of the current selection.</ahelp></variable></paragraph>
 </section>
 <section id="preview">
 <h2 id="hd_id3156193">Preview</h2>
 <embed href="text/shared/00/00000001.xhp#previewhelp"/>
 </section>
 <section id="next">
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_CMDNEXT" id="bm_id8281197" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGFORM_CMDNEXT" id="bm_id3147576" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_QUERYWIZARD_NEXT" id="bm_id4154179" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DBWIZ_NEXT" id="bm_id1058076" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID0_NEXT" id="bm_id480666" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_GROUPWIZARD_NEXT" id="bm_id3149095" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGFORM_CMDNEXT" id="bm_id31475761" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_DLGTABLE_CMDNEXT" id="bm_id8281197" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_DLGFORM_CMDNEXT" id="bm_id3147576" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_QUERYWIZARD_NEXT" id="bm_id4154179" localize="false"/>
+<bookmark branch="hid/DBACCESS_HID_DBWIZ_NEXT" id="bm_id1058076" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID0_NEXT" id="bm_id480666" localize="false"/>
+<bookmark branch="hid/EXTENSIONS_HID_GROUPWIZARD_NEXT" id="bm_id3149095" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_DLGFORM_CMDNEXT" id="bm_id31475761" localize="false"/>
 <!-- removed HID HID_DLGREPORT_0_CMDNEXTORREADY -->
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_LISTWIZARD_NEXT" id="bm_id3155135" localize="false"/>
+<bookmark branch="hid/EXTENSIONS_HID_LISTWIZARD_NEXT" id="bm_id3155135" localize="false"/>
 <h2 id="hd_id3145609">Next</h2>
-  <paragraph xml-lang="en-US" id="par_id3152473" role="paragraph"><ahelp hid=".">Click the <emph>Next</emph> button, and the wizard uses the current dialog settings and proceeds to the next step. If you are on the last step, this button becomes <emph>Create</emph>.</ahelp></paragraph>
+  <paragraph id="par_id3152473" role="paragraph"><ahelp hid=".">Click the <emph>Next</emph> button, and the wizard uses the current dialog settings and proceeds to the next step. If you are on the last step, this button becomes <emph>Create</emph>.</ahelp></paragraph>
 </section>
 <section id="AutocorrectButtons">
-<bookmark xml-lang="en-US" branch="hid/cui/ui/autocorrectdialog/reset" id="bm_id4539934" localize="false"/>
+<bookmark branch="hid/cui/ui/autocorrectdialog/reset" id="bm_id4539934" localize="false"/>
 <h2 id="hd_id3149671">Dialog Buttons</h2>
 <h3 id="par_id3145069">Reset</h3>
-  <paragraph xml-lang="en-US" id="par_id3145169" role="paragraph"><ahelp hid="cui/ui/autocorrectdialog/reset">Resets modified values back to the tab page previous values.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/autocorrectdialog/cancel" id="bm_id4539935" localize="false"/>
+  <paragraph id="par_id3145169" role="paragraph"><ahelp hid="cui/ui/autocorrectdialog/reset">Resets modified values back to the tab page previous values.</ahelp></paragraph>
+<bookmark branch="hid/cui/ui/autocorrectdialog/cancel" id="bm_id4539935" localize="false"/>
 <section id="cancel_autocorr">
 <h3 id="par_id3145070">Cancel</h3>
-  <paragraph xml-lang="en-US" id="par_id3145269" role="paragraph"><ahelp hid="cui/ui/autocorrectdialog/cancel">Closes dialog and discards all changes.</ahelp></paragraph>
+  <paragraph id="par_id3145269" role="paragraph"><ahelp hid="cui/ui/autocorrectdialog/cancel">Closes dialog and discards all changes.</ahelp></paragraph>
 </section>
-<bookmark xml-lang="en-US" branch="hid/cui/ui/autocorrectdialog/ok" id="bm_id4539936" localize="false"/>
+<bookmark branch="hid/cui/ui/autocorrectdialog/ok" id="bm_id4539936" localize="false"/>
 <section id="ok">
 <h3 id="par_id3145071">OK</h3>
-  <paragraph xml-lang="en-US" id="par_id3145369" role="paragraph"><ahelp hid="cui/ui/autocorrectdialog/ok">Saves all changes and closes dialog.</ahelp></paragraph>
+  <paragraph id="par_id3145369" role="paragraph"><ahelp hid="cui/ui/autocorrectdialog/ok">Saves all changes and closes dialog.</ahelp></paragraph>
 </section>
 </section>
 <section id="reset">
-<bookmark xml-lang="en-US" branch="hid/cui/ui/optionsdialog/revert" id="bm_id4539933" localize="false"/>
+<bookmark branch="hid/cui/ui/optionsdialog/revert" id="bm_id4539933" localize="false"/>
 <h2 id="hd_id3149670">Reset<comment>in Tools - Options</comment></h2>
-  <paragraph xml-lang="en-US" id="par_id3145068" role="paragraph"><ahelp hid="cui/ui/optionsdialog/revert">Resets changes made to the current tab to those applicable when this dialog was opened.</ahelp></paragraph>
+  <paragraph id="par_id3145068" role="paragraph"><ahelp hid="cui/ui/optionsdialog/revert">Resets changes made to the current tab to those applicable when this dialog was opened.</ahelp></paragraph>
 </section>
 <section id="reset2">
-<bookmark xml-lang="en-US" branch="hid/SFX2_HID_TABDLG_RESET_BTN" id="bm_id3151054" localize="false"/>
+<bookmark branch="hid/SFX2_HID_TABDLG_RESET_BTN" id="bm_id3151054" localize="false"/>
 <h2 id="hd_id3148755">Reset<comment>all tab dialogs</comment></h2>
-  <paragraph xml-lang="en-US" id="par_id3149651" role="paragraph"><ahelp hid=".">Resets changes made to the current tab to those applicable when this dialog was opened. A confirmation query does not appear when you close the dialog.</ahelp></paragraph>
+  <paragraph id="par_id3149651" role="paragraph"><ahelp hid=".">Resets changes made to the current tab to those applicable when this dialog was opened. A confirmation query does not appear when you close the dialog.</ahelp></paragraph>
 </section>
 <section id="standard">
-<bookmark xml-lang="en-US" branch="hid/sw:PushButton:TP_STD_FONT:PB_STANDARD" id="bm_id481887" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/SFX2_HID_TABDLG_STANDARD_BTN" id="bm_id3157322" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/sdraw/ui/copydlg/default" id="bm_id3083280" localize="false"/>
+<bookmark branch="hid/sw:PushButton:TP_STD_FONT:PB_STANDARD" id="bm_id481887" localize="false"/>
+<bookmark branch="hid/SFX2_HID_TABDLG_STANDARD_BTN" id="bm_id3157322" localize="false"/>
+<bookmark branch="hid/modules/sdraw/ui/copydlg/default" id="bm_id3083280" localize="false"/>
 <h2 id="hd_id3145173">Standard<comment>UFI: Name is Default on Tools-Options-Writer-Basic Fonts</comment></h2>
-  <paragraph xml-lang="en-US" id="par_id3154153" role="paragraph"><ahelp hid=".">Resets the values visible in the dialog back to the default installation values.</ahelp></paragraph>
+  <paragraph id="par_id3154153" role="paragraph"><ahelp hid=".">Resets the values visible in the dialog back to the default installation values.</ahelp></paragraph>
   <warning id="par_id3154299">A confirmation does not appear before the defaults are reloaded.</warning>
 </section>
 <section id="cancel_for_styles">
@@ -256,42 +256,42 @@
 <paragraph role="paragraph" id="par_id581616061494132">Values for the current tab are set to those found in the corresponding tab of the style specified in “Inherit from” in Organizer. In all cases, also when “Inherit from” is “- None -”, current tab values specified in “Contains” are removed.</paragraph>
 </section>
 <section id="only_ParaCharFrame_style">
-<paragraph role="paragraph" xml-lang="en-US" id="par_id131583023830621">This option appears only for Paragraph Style, Character Style, and Frame Style.</paragraph>
+<paragraph role="paragraph" id="par_id131583023830621">This option appears only for Paragraph Style, Character Style, and Frame Style.</paragraph>
 </section>
 <section id="back">
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_CMDPREV" id="bm_id1064180" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_QUERYWIZARD_BACK" id="bm_id3681447" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DBWIZ_PREVIOUS" id="bm_id5176244" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID0_PREV" id="bm_id1207617" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_GROUPWIZARD_PREVIOUS" id="bm_id3154318" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGFORM_CMDPREV" id="bm_id3145346" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGREPORT_0_CMDPREV" id="bm_id3150984" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_LISTWIZARD_PREVIOUS" id="bm_id3156155" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_DLGTABLE_CMDPREV" id="bm_id1064180" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_QUERYWIZARD_BACK" id="bm_id3681447" localize="false"/>
+<bookmark branch="hid/DBACCESS_HID_DBWIZ_PREVIOUS" id="bm_id5176244" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID0_PREV" id="bm_id1207617" localize="false"/>
+<bookmark branch="hid/EXTENSIONS_HID_GROUPWIZARD_PREVIOUS" id="bm_id3154318" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_DLGFORM_CMDPREV" id="bm_id3145346" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_DLGREPORT_0_CMDPREV" id="bm_id3150984" localize="false"/>
+<bookmark branch="hid/EXTENSIONS_HID_LISTWIZARD_PREVIOUS" id="bm_id3156155" localize="false"/>
 <h2 id="hd_id3147502">Back</h2>
-  <paragraph xml-lang="en-US" id="par_id3150439" role="paragraph"><ahelp hid=".">View the selections in the dialog made in the previous step. The current settings remain unchanged.</ahelp> This button can only be activated from page two on.</paragraph>
+  <paragraph id="par_id3150439" role="paragraph"><ahelp hid=".">View the selections in the dialog made in the previous step. The current settings remain unchanged.</ahelp> This button can only be activated from page two on.</paragraph>
 </section>
 <section id="options">
-<bookmark xml-lang="en-US" branch="hid/SFX2_HID_MOREOPTIONS_BTN" id="bm_id3157322" localize="false"/>
+<bookmark branch="hid/SFX2_HID_MOREOPTIONS_BTN" id="bm_id3157322" localize="false"/>
 <h2 id="hd_id3147353">Options</h2>
-  <paragraph xml-lang="en-US" id="par_id3155314" role="paragraph"><ahelp hid=".">Click the <emph>Options</emph> label to expand the dialog to show further options. Click again to restore the dialog.</ahelp></paragraph>
+  <paragraph id="par_id3155314" role="paragraph"><ahelp hid=".">Click the <emph>Options</emph> label to expand the dialog to show further options. Click again to restore the dialog.</ahelp></paragraph>
 </section>
-<paragraph xml-lang="en-US" id="par_id3161659" role="paragraph"><variable id="siehe">See also the following functions:</variable></paragraph>
+<paragraph id="par_id3161659" role="paragraph"><variable id="siehe">See also the following functions:</variable></paragraph>
 <section id="regex">
-    <paragraph xml-lang="en-US" id="par_id3147418" role="paragraph">The search supports wildcards or <link href="text/shared/01/02100001.xhp">regular expressions</link>. With regular expressions enabled, you can enter "all.*", for example to find the first location of "all" followed by any characters. If you want to search for a text that is also a regular expression, you must either precede every regular expression metacharacter or operator with a "\" character, or enclose the text into \Q...\E. You can switch the automatic evaluation of wildcards or regular expression on and off in <link href="text/shared/optionen/01060500.xhp"><switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link>.</paragraph>
+    <paragraph id="par_id3147418" role="paragraph">The search supports wildcards or <link href="text/shared/01/02100001.xhp">regular expressions</link>. With regular expressions enabled, you can enter "all.*", for example to find the first location of "all" followed by any characters. If you want to search for a text that is also a regular expression, you must either precede every regular expression metacharacter or operator with a "\" character, or enclose the text into \Q...\E. You can switch the automatic evaluation of wildcards or regular expression on and off in <link href="text/shared/optionen/01060500.xhp"><switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link>.</paragraph>
     <section id="regexnumex">
         <warning id="par_id651572973288601">When using functions where one or more arguments are search criteria strings that represents a regular expression, the first attempt is to convert the string criteria to numbers. For example, ".0" will convert to 0.0 and so on. If successful, the match will not be a regular expression match but a numeric match. However, when switching to a locale where the decimal separator is not the dot makes the regular expression conversion work. To force the evaluation of the regular expression instead of a numeric expression, use some expression that can not be misread as numeric, such as ".[0]" or ".\0" or "(?i).0". </warning>
     </section>
 </section>
-<paragraph xml-lang="en-US" id="par_id3163714" role="paragraph"><variable id="wahr">If an error occurs, the function returns a logical or numerical value.</variable></paragraph>
-<paragraph xml-lang="en-US" id="par_id3154145" role="paragraph"><variable id="kontext">(This command is only accessible through the <link href="text/shared/00/00000005.xhp#contextmenu">context menu</link>).</variable></paragraph>
-<paragraph xml-lang="en-US" id="par_id3152791" role="paragraph"><variable id="wiederholen">By double-clicking a tool, you can use it for multiple tasks. If you call the tool with a single-click, it reverts back to the last selection after completing the task.</variable></paragraph>
-<paragraph xml-lang="en-US" id="par_id9345377" role="paragraph"><variable id="ShiftF1">Press <emph>Shift+F1</emph> and point to a control to learn more about that control.</variable></paragraph>
+<paragraph id="par_id3163714" role="paragraph"><variable id="wahr">If an error occurs, the function returns a logical or numerical value.</variable></paragraph>
+<paragraph id="par_id3154145" role="paragraph"><variable id="kontext">(This command is only accessible through the <link href="text/shared/00/00000005.xhp#contextmenu">context menu</link>).</variable></paragraph>
+<paragraph id="par_id3152791" role="paragraph"><variable id="wiederholen">By double-clicking a tool, you can use it for multiple tasks. If you call the tool with a single-click, it reverts back to the last selection after completing the task.</variable></paragraph>
+<paragraph id="par_id9345377" role="paragraph"><variable id="ShiftF1">Press <emph>Shift+F1</emph> and point to a control to learn more about that control.</variable></paragraph>
 <section id="optionsbuttons">
 <h2 id="hd_id631527692833772">Options dialog buttons</h2>
 <h3 id="hd_id831527692839432">OK</h3>
-<paragraph role="paragraph" id="par_id471527692844934" xml-lang="en-US">Save the changes in the page and close the Options dialog.</paragraph>
+<paragraph role="paragraph" id="par_id471527692844934">Save the changes in the page and close the Options dialog.</paragraph>
 <h3 id="hd_id261527692850720">Cancel</h3>
-<paragraph role="paragraph" id="par_id571527692855533" xml-lang="en-US">Close the Options dialog and discard all changes done.</paragraph>
+<paragraph role="paragraph" id="par_id571527692855533">Close the Options dialog and discard all changes done.</paragraph>
 <h3 id="hd_id321597440555403">Apply</h3>
 <paragraph role="paragraph" id="par_id51597440622057">Applies the modified or selected values without closing the Options dialog.</paragraph>
 <embed href="text/shared/00/00000001.xhp#reset"/>