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

+ Data menu for Calc, DD ranges.
+ refactoring

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

4 files changed, 76 insertions, 20 deletions

diff --git a/source/text/scalc/00/00000412.xhp b/source/text/scalc/00/00000412.xhp
index fe209cb6dd..0fb0988003 100644
--- a/source/text/scalc/00/00000412.xhp
+++ b/source/text/scalc/00/00000412.xhp
@@ -28,8 +28,44 @@
     <h1 id="hd_id3145136">Data Menu</h1>
 
     <paragraph role="paragraph" id="par_id8366954"><variable id="text2columns">Choose <emph>Data - Text to Columns</emph>.</variable></paragraph>
-    <paragraph role="paragraph" id="par_id3147399"><variable id="dbrbf">Choose <emph>Data - Define Range</emph>.</variable></paragraph>
-    <paragraph role="paragraph" id="par_id3145345"><variable id="dbrba">Choose <emph>Data - Select Range</emph>.</variable></paragraph>
+
+    <section id="definerange">
+        <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+        <paragraph role="paragraph" id="par_id3147399"><variable id="dbrbf">Choose <emph>Data - Define Range</emph>.</variable></paragraph>
+        <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+        <paragraph role="paragraph" id="par_id491703673711439">Choose <menuitem>Data</menuitem> - <menuitem>Define Range</menuitem>.</paragraph>
+        <paragraph role="paragraph" id="par_id321703673716748">On the <menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose <menuitem>Define Range</menuitem>.</paragraph>
+        <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+        <table id="tab_id651703673736936">
+            <tablerow>
+                <tablecell>
+                    <paragraph id="par_id691703673736937" role="paragraph"><image src="cmd/lc_definedbname.svg" id="img_id841703673736938" width="1cm"  height="1cm"><alt id="alt_id221703673736939">Icon Define Range</alt></image></paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id131703673736941" role="paragraph">Define Range</paragraph>
+                </tablecell>
+            </tablerow>
+        </table>
+    </section>
+
+    <section id="selectrange">
+        <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+        <paragraph role="paragraph" id="par_id3145345"><variable id="dbrba">Choose <emph>Data - Select Range</emph>.</variable></paragraph>
+        <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+        <paragraph role="paragraph" id="par_id621703673870509">Choose <menuitem>Data</menuitem> - <menuitem>Define Range</menuitem>.</paragraph>
+        <paragraph role="paragraph" id="par_id261703673873605">On the <menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose <menuitem>Define Range</menuitem>.</paragraph>
+        <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+        <table id="tab_id671703673891812">
+            <tablerow>
+                <tablecell>
+                    <paragraph id="par_id651703673891813" role="paragraph"><image src="cmd/lc_selectdb.svg" id="img_id1001703673891814" width="1cm"  height="1cm"><alt id="alt_id291703673891815">Icon Select Range</alt></image></paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id71703673891816" role="paragraph">Select Range</paragraph>
+                </tablecell>
+            </tablerow>
+        </table>
+    </section>
 
     <section id="sort">
         <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
@@ -282,7 +318,26 @@
     </section>
     <paragraph role="paragraph" id="par_id3153294"><variable id="dndpak">Choose <emph>Data - Pivot Table - Refresh</emph>.</variable></paragraph>
     <paragraph role="paragraph" id="par_id3151344"><variable id="dndploe">Choose <emph>Data - Pivot Table - Delete</emph>.</variable></paragraph>
-    <paragraph role="paragraph" id="par_id3150397"><variable id="dndakt">Choose <emph>Data - Refresh Range</emph>.</variable></paragraph>
+
+    <section id="refreshrange">
+        <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+        <paragraph role="paragraph" id="par_id3150397"><variable id="dndakt">Choose <emph>Data - Refresh Range</emph>.</variable></paragraph>
+        <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+        <paragraph role="paragraph" id="par_id101703676224446">Choose <menuitem>Data - Refresh Range</menuitem>.</paragraph>
+        <paragraph role="paragraph" id="par_id151703676230661">On the <menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose <menuitem>Refresh Range</menuitem>.</paragraph>
+        <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+        <table id="tab_id801703676243671">
+            <tablerow>
+                <tablecell>
+                    <paragraph id="par_id121703676243672" role="paragraph"><image src="cmd/lc_dataarearefresh.svg" id="img_id321703676243673" width="1cm"  height="1cm"><alt id="alt_id371703676243674">Icon Refresh Range</alt></image></paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id11703676243676" role="paragraph">Refresh Range</paragraph>
+                </tablecell>
+            </tablerow>
+        </table>
+    </section>
+
     <paragraph role="paragraph" id="par_idN10B8F"><variable id="grouping">Choose <emph>Data - Group and Outline - Group</emph>.</variable></paragraph>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/12010000.xhp b/source/text/scalc/01/12010000.xhp
index 4c934c2799..5c8e76d85b 100644
--- a/source/text/scalc/01/12010000.xhp
+++ b/source/text/scalc/01/12010000.xhp
@@ -30,6 +30,7 @@
 <bookmark branch="hid/.uno:DefineDBName" id="bm_id6632476" localize="false"/>
 <bookmark branch="hid/modules/scalc/ui/definedatabaserangedialog/DefineDatabaseRangeDialog" id="bm_id3147335" localize="false"/>
 <bookmark branch="hid/modules/scalc/ui/definedatabaserangedialog/@@nowidget@@" id="bm_id3147335" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuData-DefineDBName" id="bm_id631703673605853" localize="false"/>
 <section id="defineDBrangeheader">
 <h1 id="hd_id3157909"><link href="text/scalc/01/12010000.xhp">Define Range</link></h1>
 <paragraph role="paragraph" id="par_id3155922"><variable id="bereichtext"><ahelp hid=".uno:DefineDBName">Defines a database range based on the selected cells in your sheet.</ahelp></variable></paragraph>
@@ -37,7 +38,7 @@
 
 <note id="par_id3149456">You can only select a rectangular cell range.</note>
 <section id="howtoget">
-<embed href="text/scalc/00/00000412.xhp#dbrbf"/>
+<embed href="text/scalc/00/00000412.xhp#definerange"/>
 </section>
 <bookmark branch="hid/modules/scalc/ui/definedatabaserangedialog/entry" id="bm_id3150868" localize="false"/>
 <h2 id="hd_id3156422">Name</h2>
diff --git a/source/text/scalc/01/12020000.xhp b/source/text/scalc/01/12020000.xhp
index 3449b2992a..5c3c243cde 100644
--- a/source/text/scalc/01/12020000.xhp
+++ b/source/text/scalc/01/12020000.xhp
@@ -19,7 +19,7 @@
 <helpdocument version="1.0">
 <meta>
 <topic id="textscalc0112020000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Select Database Range</title>
+<title id="tit">Select Database Range</title>
 <filename>/text/scalc/01/12020000.xhp</filename>
 </topic>
 <history>
@@ -27,22 +27,22 @@
 </history>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id3145068"><bookmark_value>databases; selecting (Calc)</bookmark_value>
+<bookmark branch="index" id="bm_id3145068"><bookmark_value>databases; selecting (Calc)</bookmark_value>
 </bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:SelectDB" id="bm_id2131630" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectrange/SelectRangeDialog" id="bm_id3148946" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectrange/@@nowidget@@" id="bm_id3148946" localize="false"/>
-
+<bookmark branch="hid/.uno:SelectDB" id="bm_id2131630" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/selectrange/SelectRangeDialog" id="bm_id3148946" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/selectrange/@@nowidget@@" id="bm_id3148946" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuData-Select" id="bm_id801703674098588" localize="false"/>
 <section id="selectDBheader">
 <h1 id="hd_id3145068"><link href="text/scalc/01/12020000.xhp">Select Range</link></h1>
-<paragraph role="paragraph" id="par_id3149655" xml-lang="en-US"><variable id="bereichwaehlen"><ahelp hid=".uno:SelectDB">Selects a database range that you defined under <link href="text/scalc/01/12010000.xhp">Data - Define Range</link>.</ahelp></variable></paragraph>
+<paragraph role="paragraph" id="par_id3149655"><variable id="bereichwaehlen"><ahelp hid=".uno:SelectDB">Selects a database range that you defined under <link href="text/scalc/01/12010000.xhp">Data - Define Range</link>.</ahelp></variable></paragraph>
 </section>
 
 <section id="howtoget">
-  <embed href="text/scalc/00/00000412.xhp#dbrba"/>
+  <embed href="text/scalc/00/00000412.xhp#selectrange"/>
 </section>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectrange/treeview" id="bm_id3125865" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/selectrange/treeview" id="bm_id3125865" localize="false"/>
 <h2 id="hd_id3153192">Ranges</h2>
-<paragraph role="paragraph" id="par_id3154684" xml-lang="en-US"><ahelp hid="modules/scalc/ui/selectrange/treeview">Lists the available database ranges. To select a database range, click its name, and then click <emph>OK</emph>.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3154684"><ahelp hid="modules/scalc/ui/selectrange/treeview">Lists the available database ranges. To select a database range, click its name, and then click <emph>OK</emph>.</ahelp></paragraph>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/12100000.xhp b/source/text/scalc/01/12100000.xhp
index 3865aaedfe..8cbc267695 100644
--- a/source/text/scalc/01/12100000.xhp
+++ b/source/text/scalc/01/12100000.xhp
@@ -19,7 +19,7 @@
 <helpdocument version="1.0">
 <meta>
 <topic id="textscalc0112100000xml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Refresh Range</title>
+<title id="tit">Refresh Range</title>
 <filename>/text/scalc/01/12100000.xhp</filename>
 </topic>
 <history>
@@ -27,15 +27,15 @@
 </history>
 </meta>
 <body>
-  <bookmark xml-lang="en-US" branch="index" id="bm_id3153662"><bookmark_value>database ranges; refreshing</bookmark_value></bookmark>
-<bookmark branch="hid/.uno:DataReImport" xml-lang="en-US" id="bm_id3153880" localize="false"/>
-<bookmark branch="hid/.uno:DataAreaRefresh" xml-lang="en-US" id="bm_id3149166" localize="false"/>
+  <bookmark branch="index" id="bm_id3153662"><bookmark_value>database ranges; refreshing</bookmark_value></bookmark>
+<bookmark branch="hid/.uno:DataReImport" id="bm_id3153880" localize="false"/>
+<bookmark branch="hid/.uno:DataAreaRefresh" id="bm_id3149166" localize="false"/>
 <section id="refreshrangehead">
 <h1 id="hd_id3153662"><link href="text/scalc/01/12100000.xhp">Refresh Range</link></h1>
-  <paragraph role="paragraph" id="par_id3153088" xml-lang="en-US"><variable id="aktualisieren"><ahelp hid=".">Updates a data range that was inserted from an external database. The data in the sheet is updated to match the data in the external database.</ahelp></variable></paragraph>
+  <paragraph role="paragraph" id="par_id3153088"><variable id="aktualisieren"><ahelp hid=".">Updates a data range that was inserted from an external database. The data in the sheet is updated to match the data in the external database.</ahelp></variable></paragraph>
 </section>
   <section id="howtoget">
-  <embed href="text/scalc/00/00000412.xhp#dndakt"/>
+  <embed href="text/scalc/00/00000412.xhp#refreshrange"/>
 </section>
  </body>
 </helpdocument>