tdf#155876 UI cmds Calc-Format menu (21)

+ merge cells, print ranges menus
+ refactoring

Change-Id: Idcdd2fb8b986700f624941662a8250bbe6aac753
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/159746
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>

10 files changed, 161 insertions, 90 deletions

diff --git a/source/text/scalc/00/00000405.xhp b/source/text/scalc/00/00000405.xhp
index 2f1dced7af..9b9d33525f 100644
--- a/source/text/scalc/00/00000405.xhp
+++ b/source/text/scalc/00/00000405.xhp
@@ -134,13 +134,96 @@
 
 <paragraph role="paragraph" id="par_idN1077A"><variable id="foste">Choose <emph>Format - Page Style</emph>.</variable></paragraph>
 <paragraph role="paragraph" id="par_id3155508"><variable id="fostel">Choose <emph>Format - Page Style - Sheet</emph> tab.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3150883"><variable id="fodrbe">Choose <emph>Format - Print Ranges</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3156448"><variable id="fodrfe">Choose <emph>Format - Print Ranges - Define</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3156290"><variable id="fodrhin">Choose <emph>Format - Print Ranges - Add</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3155812"><variable id="fodbah">Choose <emph>Format - Print Ranges - Clear</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3153307"><variable id="fodbbe">Choose <emph>Format - Print Ranges - Edit</emph>.</variable></paragraph>
-
-
+<section id="printranges">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_id3150883"><variable id="fodrbe">Choose <emph>Format - Print Ranges</emph>.</variable></paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+  <paragraph role="paragraph" id="par_id661700524225883">Choose <menuitem>Layout</menuitem> tab.</paragraph>
+  <paragraph role="paragraph" id="par_id231700521865773">On the <menuitem>Layout</menuitem> menu of the <menuitem>Layout</menuitem> tab, choose <menuitem>Print Ranges</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+  <table id="tab_id951700524311206">
+    <tablerow>
+      <tablecell>
+        <paragraph id="par_id251700524311207" role="paragraph"><image src="cmd/lc_defineprintarea.svg" id="img_id51700524311208" width="1cm"  height="1cm"><alt id="alt_id231700524311209">Icon Print Ranges</alt></image></paragraph>
+      </tablecell>
+      <tablecell>
+        <paragraph id="par_id561700524311211" role="paragraph">Print Ranges</paragraph>
+      </tablecell>
+    </tablerow>
+  </table>
+</section>
+<section id="defineprintrange">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_id3156448"><variable id="fodrfe">Choose <emph>Format - Print Ranges - Define</emph>.</variable></paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+  <paragraph role="paragraph" id="par_id191700524851592">Choose <menuitem>Layout - Print Area</menuitem> tab.</paragraph>
+  <paragraph role="paragraph" id="par_id881700524946114">On the <menuitem>Layout</menuitem> menu of the <menuitem>Layout</menuitem> tab, choose <menuitem>Print Ranges - Define</menuitem></paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+  <table id="tab_id501700525060552">
+    <tablerow>
+      <tablecell>
+        <paragraph id="par_id211700525060553" role="paragraph"><image src="cmd/lc_defineprintarea.svg" id="img_id881700525060554" width="1cm"  height="1cm"><alt id="alt_id221700525060556">Icon Define Print Area</alt></image></paragraph>
+      </tablecell>
+      <tablecell>
+        <paragraph id="par_id951700525060557" role="paragraph">Define Print Area</paragraph>
+      </tablecell>
+    </tablerow>
+  </table>
+</section>
+<section id="addprintrange">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_id3156290"><variable id="fodrhin">Choose <emph>Format - Print Ranges - Add</emph>.</variable></paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+  <paragraph role="paragraph" id="par_id421700526081438">Choose <menuitem>Layout - Add Print Ranges</menuitem> tab.</paragraph>
+  <paragraph role="paragraph" id="par_id231700526084582">On the <menuitem>Layout</menuitem> menu of the <menuitem>Layout</menuitem> tab, choose <menuitem>Print Ranges - Add</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+  <table id="tab_id691700526048361">
+    <tablerow>
+      <tablecell>
+        <paragraph id="par_id931700526048362" role="paragraph"><image src="cmd/lc_addprintarea.svg" id="img_id371700526048363" width="1cm"  height="1cm"><alt id="alt_id611700526048364">Icon Add Print Area</alt></image></paragraph>
+      </tablecell>
+      <tablecell>
+        <paragraph id="par_id481700526048365" role="paragraph">Add Print Area</paragraph>
+      </tablecell>
+    </tablerow>
+  </table>
+</section>
+<section id="clearprintrange">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_id3155812"><variable id="fodbah">Choose <emph>Format - Print Ranges - Clear</emph>.</variable></paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+  <paragraph role="paragraph" id="par_id991700526162503">Choose <menuitem>Layout - Clear Print Ranges</menuitem> tab.</paragraph>
+  <paragraph role="paragraph" id="par_id931700526168487">On the <menuitem>Layout</menuitem> menu of the <menuitem>Layout</menuitem> tab, choose <menuitem>Print Ranges - Clear</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+  <table id="tab_id451700525434546">
+    <tablerow>
+      <tablecell>
+        <paragraph id="par_id931700525434547" role="paragraph"><image src="cmd/lc_deleteprintarea.svg" id="img_id41700525434548" width="1cm"  height="1cm"><alt id="alt_id891700525434549">Icon Clear Print Ranges  </alt></image></paragraph>
+      </tablecell>
+      <tablecell>
+        <paragraph id="par_id251700525434551" role="paragraph">Clear Print Ranges</paragraph>
+      </tablecell>
+    </tablerow>
+  </table>
+</section>
+<section id="editprintrange">
+<embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_id3153307"><variable id="fodbbe">Choose <emph>Format - Print Ranges - Edit</emph>.</variable></paragraph>
+    <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+  <paragraph role="paragraph" id="par_id161700525483226">Choose <menuitem>Layout - Edit</menuitem> tab.</paragraph>
+  <paragraph role="paragraph" id="par_id381700525487691">On the <menuitem>Layout</menuitem> menu of the <menuitem>Layout</menuitem> tab, choose <menuitem>Print Ranges - Edit</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+  <table id="tab_id161700525855094">
+    <tablerow>
+      <tablecell>
+        <paragraph id="par_id611700525855095" role="paragraph"><image src="cmd/lc_editprintarea.svg" id="img_id231700525855096" width="1cm"  height="1cm"><alt id="alt_id271700525855097">Icon Edit Print Ranges</alt></image></paragraph>
+      </tablecell>
+      <tablecell>
+        <paragraph id="par_id901700525855099" role="paragraph">Edit Print Ranges</paragraph>
+      </tablecell>
+    </tablerow>
+  </table>
+</section>
 <section id="s_conditionalcondition">
   <paragraph role="paragraph" id="par_id3154618"><variable id="bedingte">Choose <menuitem>Format - Conditional - Condition</menuitem>.</variable></paragraph>
   <paragraph role="paragraph" id="par_id141663543112100">On the <emph>Formatting</emph> bar, click</paragraph>
diff --git a/source/text/scalc/01/05080000.xhp b/source/text/scalc/01/05080000.xhp
index 130169ab9e..054a7a7e97 100644
--- a/source/text/scalc/01/05080000.xhp
+++ b/source/text/scalc/01/05080000.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="textscalc0105080000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Print Ranges</title>
+<title id="tit">Print Ranges</title>
 <filename>/text/scalc/01/05080000.xhp</filename>
 </topic>
 <history>
@@ -30,15 +27,15 @@
 </history>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="hid/.uno:PrintRangesMenu" id="bm_id4606769" localize="false"/>
+<bookmark branch="hid/.uno:PrintRangesMenu" id="bm_id4606769" localize="false"/>
 <section id="printranges">
 <h1 id="hd_id3154013"><link href="text/scalc/01/05080000.xhp">Print Ranges</link></h1>
-<paragraph role="paragraph" id="par_id3155855" xml-lang="en-US"><ahelp hid=".">Manages print ranges. Only cells within the print ranges will be printed.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3155855"><ahelp hid=".">Manages print ranges. Only cells within the print ranges will be printed.</ahelp></paragraph>
 </section>
 <section id="howtoget">
-  <embed href="text/scalc/00/00000405.xhp#fodrbe"/>
+  <embed href="text/scalc/00/00000405.xhp#printranges"/>
 </section>
-<paragraph role="note" id="par_id3146119" xml-lang="en-US">If you do not define any print range manually, Calc assigns an automatic print range to include all the cells that are not empty.</paragraph>
+<note id="par_id3146119">If you do not define any print range manually, Calc assigns an automatic print range to include all the cells that are not empty.</note>
 <embed href="text/scalc/01/05080100.xhp#define"/>
 <embed href="text/scalc/01/05080400.xhp#add"/>
 <embed href="text/scalc/01/05080200.xhp#clear"/>
diff --git a/source/text/scalc/01/05080100.xhp b/source/text/scalc/01/05080100.xhp
index 0759c4634a..3ff7260907 100644
--- a/source/text/scalc/01/05080100.xhp
+++ b/source/text/scalc/01/05080100.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="textscalc0105080100xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Define</title>
+<title id="tit">Define</title>
 <filename>/text/scalc/01/05080100.xhp</filename>
 </topic>
 <history>
@@ -31,12 +28,12 @@
 </meta>
 <body>
 <section id="define">
-<bookmark xml-lang="en-US" branch="hid/.uno:DefinePrintArea" id="bm_id3153561" localize="false"/>
+<bookmark branch="hid/.uno:DefinePrintArea" id="bm_id3153561" localize="false"/>
 <h1 id="hd_id3145673"><link href="text/scalc/01/05080100.xhp">Define</link></h1>
-<paragraph role="paragraph" id="par_id3153896" xml-lang="en-US"><ahelp hid=".uno:DefinePrintArea">Defines an active cell or selected cell area as the print range.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3153896"><ahelp hid=".uno:DefinePrintArea">Defines an active cell or selected cell area as the print range.</ahelp></paragraph>
 </section>
 <section id="howtoget">
-  <embed href="text/scalc/00/00000405.xhp#fodrfe"/>
+  <embed href="text/scalc/00/00000405.xhp#defineprintrange"/>
 </section>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/05080200.xhp b/source/text/scalc/01/05080200.xhp
index c260f0ff46..9861ff23b5 100644
--- a/source/text/scalc/01/05080200.xhp
+++ b/source/text/scalc/01/05080200.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="textscalc0105080200xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Clear</title>
+<title id="tit">Clear</title>
 <filename>/text/scalc/01/05080200.xhp</filename>
 </topic>
 <history>
@@ -31,12 +28,12 @@
 </meta>
 <body>
 <section id="clear">
-<bookmark xml-lang="en-US" branch="hid/.uno:DeletePrintArea" id="bm_id3150275" localize="false"/>
+<bookmark branch="hid/.uno:DeletePrintArea" id="bm_id3150275" localize="false"/>
 <h1 id="hd_id3153562"><link href="text/scalc/01/05080200.xhp">Clear</link></h1>
-<paragraph role="paragraph" id="par_id3148550" xml-lang="en-US"><ahelp hid=".uno:DeletePrintArea">Removes the defined print area.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3148550"><ahelp hid=".uno:DeletePrintArea">Removes the defined print area.</ahelp></paragraph>
 </section>
 <section id="howtoget">
-  <embed href="text/scalc/00/00000405.xhp#fodbah"/>
+  <embed href="text/scalc/00/00000405.xhp#clearprintrange"/>
 </section>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/05080300.xhp b/source/text/scalc/01/05080300.xhp
index fdf284ff7d..73ee1dd610 100644
--- a/source/text/scalc/01/05080300.xhp
+++ b/source/text/scalc/01/05080300.xhp
@@ -22,42 +22,42 @@
 
 <meta>
 <topic id="textscalc0105080300xml" indexer="include">
-<title id="tit" xml-lang="en-US">Edit Print Ranges</title>
+<title id="tit">Edit Print Ranges</title>
 <filename>/text/scalc/01/05080300.xhp</filename>
 </topic>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="hid/.uno:EditPrintArea" id="bm_id2248794" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/printareasdialog/PrintAreasDialog" id="bm_id3145673" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/printareasdialog/@@nowidget@@" id="bm_id3145673" localize="false"/>
+<bookmark branch="hid/.uno:EditPrintArea" id="bm_id2248794" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/printareasdialog/PrintAreasDialog" id="bm_id3145673" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/printareasdialog/@@nowidget@@" id="bm_id3145673" localize="false"/>
 <h1 id="hd_id3153088">Edit Print Ranges</h1>
-<paragraph role="paragraph" id="par_id3159488" xml-lang="en-US"><variable id="printrangestext"><ahelp hid=".uno:EditPrintArea">Opens a dialog where you can specify the print range.</ahelp>
+<paragraph role="paragraph" id="par_id3159488"><variable id="printrangestext"><ahelp hid=".uno:EditPrintArea">Opens a dialog where you can specify the print range.</ahelp>
 </variable> You can also set the rows or columns which are to be repeated in every page.</paragraph>
 <section id="howtoget">
-<embed href="text/scalc/00/00000405.xhp#fodbbe"/>
+<embed href="text/scalc/00/00000405.xhp#editprintrange"/>
 </section>
 <embed href="text/scalc/guide/print_title_row.xhp#print_title_row"/>
-<paragraph role="paragraph" id="par_idN105AE" xml-lang="en-US" localize="false">
+<paragraph role="paragraph" id="par_idN105AE" localize="false">
 	<embedvar href="text/scalc/guide/printranges.xhp#printranges"/>
 </paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/printareasdialog/lbprintarea" id="bm_id3154910" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/printareasdialog/edprintarea" id="bm_id3150447" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/printareasdialog/lbprintarea" id="bm_id3154910" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/printareasdialog/edprintarea" id="bm_id3150447" localize="false"/>
 <h2 id="hd_id3156281">Print range</h2>
-<paragraph role="paragraph" id="par_id3147228" xml-lang="en-US"><ahelp hid="modules/scalc/ui/printareasdialog/edprintarea">Allows you to modify a defined print range.</ahelp></paragraph>
-<paragraph role="paragraph" id="par_id3145174" xml-lang="en-US">Select <emph>-none-</emph> to remove a print range definition for the current spreadsheet. Select <emph>-entire sheet-</emph> to set the current sheet as a print range. Select <emph>-selection-</emph> to define the selected area of a spreadsheet as the print range. By selecting <emph>-user-defined-</emph>, you can define a print range that you have already defined using the <emph>Format - Print Ranges - Define</emph> command. If you have given a name to a range using the <emph>Sheet - Named Ranges and Expressions - Define</emph> command, this name will be displayed and can be selected from the list box.</paragraph>
-<paragraph role="paragraph" id="par_id3145272" xml-lang="en-US">In the right-hand text box, you can enter a print range by reference or by name. If the cursor is in the <emph>Print range</emph> text box, you can also select the print range in the spreadsheet with your mouse.</paragraph>
+<paragraph role="paragraph" id="par_id3147228"><ahelp hid="modules/scalc/ui/printareasdialog/edprintarea">Allows you to modify a defined print range.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3145174">Select <emph>-none-</emph> to remove a print range definition for the current spreadsheet. Select <emph>-entire sheet-</emph> to set the current sheet as a print range. Select <emph>-selection-</emph> to define the selected area of a spreadsheet as the print range. By selecting <emph>-user-defined-</emph>, you can define a print range that you have already defined using the <emph>Format - Print Ranges - Define</emph> command. If you have given a name to a range using the <emph>Sheet - Named Ranges and Expressions - Define</emph> command, this name will be displayed and can be selected from the list box.</paragraph>
+<paragraph role="paragraph" id="par_id3145272">In the right-hand text box, you can enter a print range by reference or by name. If the cursor is in the <emph>Print range</emph> text box, you can also select the print range in the spreadsheet with your mouse.</paragraph>
 <embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/printareasdialog/lbrepeatrow" id="bm_id3147435" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/printareasdialog/edrepeatrow" id="bm_id3153190" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/printareasdialog/lbrepeatrow" id="bm_id3147435" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/printareasdialog/edrepeatrow" id="bm_id3153190" localize="false"/>
 <h2 id="hd_id3149260">Rows to repeat</h2>
-<paragraph role="paragraph" id="par_id3147426" xml-lang="en-US"><ahelp hid="modules/scalc/ui/printareasdialog/edrepeatrow">Choose one or more rows to print on every page. In the right text box enter the row reference, for example, "1" or "$1" or "$2:$3".</ahelp> The list box displays <emph>-user defined-</emph>. You can also select <emph>-none-</emph> to remove a defined repeating row.</paragraph>
-<paragraph role="paragraph" id="par_id3155418" xml-lang="en-US">You can also define repeating rows by dragging the mouse in the spreadsheet, if the cursor is in the <emph>Rows to repeat</emph> text field in the dialog.</paragraph>
+<paragraph role="paragraph" id="par_id3147426"><ahelp hid="modules/scalc/ui/printareasdialog/edrepeatrow">Choose one or more rows to print on every page. In the right text box enter the row reference, for example, "1" or "$1" or "$2:$3".</ahelp> The list box displays <emph>-user defined-</emph>. You can also select <emph>-none-</emph> to remove a defined repeating row.</paragraph>
+<paragraph role="paragraph" id="par_id3155418">You can also define repeating rows by dragging the mouse in the spreadsheet, if the cursor is in the <emph>Rows to repeat</emph> text field in the dialog.</paragraph>
 <embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/printareasdialog/lbrepeatcol" id="bm_id3153876" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/printareasdialog/edrepeatcol" id="bm_id3147396" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/printareasdialog/lbrepeatcol" id="bm_id3153876" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/printareasdialog/edrepeatcol" id="bm_id3147396" localize="false"/>
 <h2 id="hd_id3149581">Columns to repeat</h2>
-<paragraph role="paragraph" id="par_id3155602" xml-lang="en-US"><ahelp hid="modules/scalc/ui/printareasdialog/edrepeatcol">Choose one or more columns to print on every page. In the right text box enter the column reference, for example, "A" or "AB" or "$C:$E".</ahelp> The list box then displays <emph>-user defined-</emph>. You can also select <emph>-none-</emph> to remove a defined repeating column.</paragraph>
-<paragraph role="paragraph" id="par_id3150749" xml-lang="en-US">You can also define repeating columns by dragging the mouse in the spreadsheet, if the cursor is in the <emph>Columns to repeat</emph> text field in the dialog.</paragraph>
+<paragraph role="paragraph" id="par_id3155602"><ahelp hid="modules/scalc/ui/printareasdialog/edrepeatcol">Choose one or more columns to print on every page. In the right text box enter the column reference, for example, "A" or "AB" or "$C:$E".</ahelp> The list box then displays <emph>-user defined-</emph>. You can also select <emph>-none-</emph> to remove a defined repeating column.</paragraph>
+<paragraph role="paragraph" id="par_id3150749">You can also define repeating columns by dragging the mouse in the spreadsheet, if the cursor is in the <emph>Columns to repeat</emph> text field in the dialog.</paragraph>
 <embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/05080400.xhp b/source/text/scalc/01/05080400.xhp
index b0b9413bc8..bc733c45e9 100644
--- a/source/text/scalc/01/05080400.xhp
+++ b/source/text/scalc/01/05080400.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="textscalc0105080400xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Add</title>
+<title id="tit">Add</title>
 <filename>/text/scalc/01/05080400.xhp</filename>
 </topic>
 <history>
@@ -31,12 +28,12 @@
 </meta>
 <body>
 <section id="add">
-<bookmark xml-lang="en-US" branch="hid/.uno:AddPrintArea" id="bm_id3150543" localize="false"/>
+<bookmark branch="hid/.uno:AddPrintArea" id="bm_id3150543" localize="false"/>
 <h1 id="hd_id3149457"><link href="text/scalc/01/05080400.xhp">Add</link></h1>
-<paragraph role="paragraph" id="par_id3156423" xml-lang="en-US"><ahelp hid=".uno:AddPrintArea">Adds the current selection to the defined print areas.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3156423"><ahelp hid=".uno:AddPrintArea">Adds the current selection to the defined print areas.</ahelp></paragraph>
 </section>
 <section id="howtoget">
-  <embed href="text/scalc/00/00000405.xhp#fodrhin"/>
+  <embed href="text/scalc/00/00000405.xhp#addprintrange"/>
 </section>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/guide/table_cellmerge.xhp b/source/text/scalc/guide/table_cellmerge.xhp
index e107b9144a..f799806651 100644
--- a/source/text/scalc/guide/table_cellmerge.xhp
+++ b/source/text/scalc/guide/table_cellmerge.xhp
@@ -20,44 +20,45 @@
 
 <meta>
   <topic id="textscalcguidetable_cellmergexml" indexer="include" status="PUBLISH">
-    <title xml-lang="en-US" id="tit">Merge and Unmerge Cells</title>
+    <title id="tit">Merge and Unmerge Cells</title>
     <filename>/text/scalc/guide/table_cellmerge.xhp</filename>
   </topic>
 </meta>
 <body>
-  <bookmark xml-lang="en-US" branch="index" id="bm_id501632012952361">
+  <bookmark branch="index" id="bm_id501632012952361">
     <bookmark_value>merge/merging cells</bookmark_value>
     <bookmark_value>unmerge/unmerging cells</bookmark_value>
     <bookmark_value>split/splitting cells</bookmark_value>
   </bookmark>
   <section id="merge_unmerge_cells">
     <h1 id="hd_id8005005"><variable id="table_cellmerge"><link href="text/scalc/guide/table_cellmerge.xhp">Merge and Unmerge Cells</link></variable></h1>
-    <paragraph xml-lang="en-US" id="par_id8049867" role="paragraph">You can select a range of cells, then merge them into a single cell. Conversely, you can take a previously merged cell and divide it back into individual cells.</paragraph>
+    <paragraph id="par_id8049867" role="paragraph">You can select a range of cells, then merge them into a single cell. Conversely, you can take a previously merged cell and divide it back into individual cells.</paragraph>
   </section>
-  <paragraph xml-lang="en-US" id="par_id0509200913480176" role="note">When you copy cells into a target range containing merged cells, the target range gets unmerged first, then the copied cells are pasted in. If the copied cells are merged cells, they retain their merge state.</paragraph>
+  <note id="par_id0509200913480176">When you copy cells into a target range containing merged cells, the target range gets unmerged first, then the copied cells are pasted in. If the copied cells are merged cells, they retain their merge state.</note>
   <h2 id="hd_id235602">Merge Cells</h2>
   <embed href="/text/scalc/01/05060000.xhp#mergecells_warning"/>
 
   <section id="howtoget">
-      <paragraph xml-lang="en-US" id="par_id1272927" role="paragraph">Click and drag to select the cells to be merged then do one of the following:</paragraph>
-      <paragraph role="paragraph" id="par_id221632803290526" xml-lang="en-US">In the Formatting toolbar click:</paragraph>
+      <paragraph id="par_id1272927" role="paragraph">Click and drag to select the cells to be merged then do one of the following:</paragraph>
+      <paragraph role="paragraph" id="par_id221632803290526">In the Formatting toolbar click:</paragraph>
       <embed href="text/swriter/00/00000405.xhp#symerge_cells"/>
-      <paragraph role="paragraph" id="par_id3154351" xml-lang="en-US">Or, right click the selection to open the context menu and choose <menuitem>Merge Cells</menuitem>.<br/>If <menuitem>Unmerge Cells</menuitem> is present instead then the cell selection contains merged cells and cannot be merged further.</paragraph>
-      <paragraph role="paragraph" id="par_id931632803442925" xml-lang="en-US">Or, in the <emph>Properties</emph> sidebar mark the <emph>Merge Cells</emph> checkbox.</paragraph>
-      <paragraph role="paragraph" id="par_id3154020" xml-lang="en-US">Or, choose <menuitem>Format - Merge and Unmerge Cells - Merge Cells</menuitem></paragraph>
-      <paragraph xml-lang="en-US" id="par_id6424146" role="listitem">Or, choose <menuitem>Format - Merge and Unmerge Cells - Merge and Center Cells</menuitem></paragraph>
-      <paragraph xml-lang="en-US" id="par_id961632012538771" role="listitem">The cells will be merged and the content will be centered in the merged cell.</paragraph>
-      </section>
+      <paragraph role="paragraph" id="par_id3154351">Or, right click the selection to open the context menu and choose <menuitem>Merge Cells</menuitem>.<br/>If <menuitem>Unmerge Cells</menuitem> is present instead then the cell selection contains merged cells and cannot be merged further.</paragraph>
+      <paragraph role="paragraph" id="par_id931632803442925">Or, in the <emph>Properties</emph> sidebar mark the <emph>Merge Cells</emph> checkbox.</paragraph>
+      <paragraph role="paragraph" id="par_id3154020">Or, choose <menuitem>Format - Merge and Unmerge Cells - Merge Cells</menuitem></paragraph>
+      <paragraph id="par_id6424146" role="listitem">Or, choose <menuitem>Format - Merge and Unmerge Cells - Merge and Center Cells</menuitem></paragraph>
+      <paragraph id="par_id961632012538771" role="listitem">The cells will be merged and the content will be centered in the merged cell.</paragraph>
+  </section>
+
       <embed href="text/scalc/01/05060000.xhp#mergenotes"/>
-      <h2 id="hd_id451368">Unmerge Cells</h2>
+  <h2 id="hd_id451368">Unmerge Cells</h2>
       <section id="howtoget">
-      <paragraph xml-lang="en-US" id="par_id7116611" role="paragraph">Select the cell to be unmerged, or a selection that includes the cells to be unmerged then do one of the following:</paragraph>
-      <paragraph role="listitem" id="par_id581632820903635" xml-lang="en-US">In the Formatting toolbar, click:</paragraph>
+      <paragraph id="par_id7116611" role="paragraph">Select the cell to be unmerged, or a selection that includes the cells to be unmerged then do one of the following:</paragraph>
+      <paragraph role="listitem" id="par_id581632820903635">In the Formatting toolbar, click:</paragraph>
       <embed href="text/swriter/00/00000405.xhp#sysplit_cells"/>
-      <paragraph xml-lang="en-US" id="par_id431632277778130" role="paragraph">Or, right click the selection to open the context menu and choose <menuitem>Unmerge Cells</menuitem>.<br/>If <menuitem>Merge Cells</menuitem> is present instead then the selection does not contain any merged cells.</paragraph>
-      <paragraph xml-lang="en-US" id="par_id261632277824041" role="paragraph">Or, in the <emph>Properties</emph> sidebar clear the <emph>Merge Cells</emph> checkbox.</paragraph>
-      <paragraph xml-lang="en-US" id="par_id9493087" role="listitem">Or, choose <menuitem>Format - Merge and Unmerge Cells - Unmerge Cells</menuitem>.</paragraph>
-      <paragraph xml-lang="en-US" id="par_id561632820960500" role="paragraph">Or, toggle <menuitem>Format - Merge and Unmerge Cells - Merge and Center Cells</menuitem></paragraph>
+      <paragraph id="par_id431632277778130" role="paragraph">Or, right click the selection to open the context menu and choose <menuitem>Unmerge Cells</menuitem>.<br/>If <menuitem>Merge Cells</menuitem> is present instead then the selection does not contain any merged cells.</paragraph>
+      <paragraph id="par_id261632277824041" role="paragraph">Or, in the <emph>Properties</emph> sidebar clear the <emph>Merge Cells</emph> checkbox.</paragraph>
+      <paragraph id="par_id9493087" role="listitem">Or, choose <menuitem>Format - Merge and Unmerge Cells - Unmerge Cells</menuitem>.</paragraph>
+      <paragraph id="par_id561632820960500" role="paragraph">Or, toggle <menuitem>Format - Merge and Unmerge Cells - Merge and Center Cells</menuitem></paragraph>
   </section>
 
   <section id="relatedtopics">
diff --git a/source/text/scalc/main0105.xhp b/source/text/scalc/main0105.xhp
index 59df51261a..9c22a7f0e0 100644
--- a/source/text/scalc/main0105.xhp
+++ b/source/text/scalc/main0105.xhp
@@ -34,26 +34,18 @@
 <embed href="text/shared/menu/submenu_text.xhp#submenu_text"/>
 <embed href="text/shared/01/05080000.xhp#alignment"/>
 <embed href="text/scalc/01/default_number_formats.xhp#numberformatmenu"/>
-
 <embed href="text/shared/01/05010000.xhp#standard"/>
 
 <h2 id="hd_id3154732"><link href="text/scalc/01/05020000.xhp">Cells</link></h2>
 <embed href="text/scalc/01/05020000.xhp#zellattributetext"/>
 <embed href="text/scalc/01/05030000.xhp#row"/>
 <embed href="text/scalc/01/05040000.xhp#column"/>
-<embed href="text/scalc/01/05050000.xhp#sheet"/>
-<embed href="/text/scalc/guide/table_cellmerge.xhp#merge_unmerge_cells"/>
-
+<embed href="text/scalc/01/MergeCellsMenu.xhp#merge_cells_menu"/>
+<embed href="text/shared/01/05020000.xhp#charater"/>
+<embed href="text/shared/01/05030000.xhp#paragraph"/>
 <embed href="text/scalc/01/05070000.xhp#pagestyle"/>
-
 <embed href="text/scalc/01/05080000.xhp#printranges"/>
 
-<h2 id="hd_id3145748"><link href="text/shared/01/05020000.xhp">Character</link></h2>
-<embed href="text/shared/01/05020000.xhp#zeichentext"/>
-
-<h2 id="hd_id3154485"><link href="text/shared/01/05030000.xhp">Paragraph</link></h2>
-<embed href="text/shared/01/05030000.xhp#absatztext"/>
-
 <h2 id="hd_id3157980"><link href="text/shared/01/AutoFormat.xhp">AutoFormat</link></h2>
 <embed href="text/shared/01/AutoFormat.xhp#autoformattext"/>
 
diff --git a/source/text/shared/01/05020000.xhp b/source/text/shared/01/05020000.xhp
index 44279dec13..a8c88639b7 100644
--- a/source/text/shared/01/05020000.xhp
+++ b/source/text/shared/01/05020000.xhp
@@ -30,8 +30,11 @@
 <body>
 <bookmark branch="hid/.uno:FontDialog" id="bm_id7592030" localize="false"/>
 <bookmark branch="hid/.uno:FormatAllNotes" id="bm_id7592031" localize="false"/>
-<h1 id="hd_id3150347">Character</h1>
+<section id="charater">
+  <h1 id="hd_id3150347"><variable id="h1"><link href="text/shared/01/05020000.xhp#character">Character</link></variable></h1>
   <paragraph role="paragraph" id="par_id3153272"><variable id="zeichentext"><ahelp hid=".uno:FontDialog">Changes the font and the font formatting for the selected characters.</ahelp></variable></paragraph>
+</section>
+
 <section id="howtoget">
   <embed href="text/shared/00/00040500.xhp#character"/>
 </section>
diff --git a/source/text/shared/01/05030000.xhp b/source/text/shared/01/05030000.xhp
index e6b195bb93..167cd7f112 100644
--- a/source/text/shared/01/05030000.xhp
+++ b/source/text/shared/01/05030000.xhp
@@ -28,9 +28,13 @@
 </meta>
 <body>
 <bookmark branch="hid/.uno:ParagraphDialog" id="bm_id1815464" localize="false"/>
-<h1 id="hd_id3150467">Paragraph</h1>
-<paragraph role="paragraph" id="par_id3148668"><variable id="absatztext"><ahelp hid=".">Modifies the format of the current paragraph, such as indents and alignment.</ahelp>
-</variable> To modify the font of the current paragraph, select the entire paragraph, choose Format - Character, and then click on the Font tab.</paragraph>
+
+<section id="paragraph">
+  <h1 id="hd_id3150467"><variable id="h1"><link href="text/shared/01/05030000.xhp#paragraph">Paragraph</link></variable></h1>
+  <paragraph role="paragraph" id="par_id3148668"><variable id="absatztext"><ahelp hid=".">Modifies the format of the current paragraph, such as indents and alignment.</ahelp></variable></paragraph>
+</section>
+<paragraph role="paragraph" id="par_id871700518278884">To modify the font of the current paragraph, select the entire paragraph, choose <menuitem>Format - Character</menuitem>, and then click on the <menuitem>Font</menuitem> tab.</paragraph>
+
 <section id="howtoget">
   <embed href="text/shared/00/00040500.xhp#paragraph"/>
 </section>