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

+ Sheet menu for Calc, insert sheets, external links
+ refactoring

Change-Id: I79838e7b1f25240a2a0932138c2cd62e70feea6d
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160656
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
(cherry picked from commit dfd902c240c11e611732f1c26345869354a56ba6)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160637

7 files changed, 114 insertions, 44 deletions

diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 3344595ebb..e599fb8d9b 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -181,6 +181,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
     helpcontent2/source/text/scalc/01/12120100 \
     helpcontent2/source/text/scalc/01/12120200 \
     helpcontent2/source/text/scalc/01/12120300 \
+    helpcontent2/source/text/scalc/01/Add \
     helpcontent2/source/text/scalc/01/calculate \
     helpcontent2/source/text/scalc/01/cell_styles \
     helpcontent2/source/text/scalc/01/calculation_accuracy \
diff --git a/source/text/scalc/00/00000404.xhp b/source/text/scalc/00/00000404.xhp
index e1217da2ea..7473556970 100644
--- a/source/text/scalc/00/00000404.xhp
+++ b/source/text/scalc/00/00000404.xhp
@@ -194,7 +194,27 @@
 </tablerow>
 </table>
 </section>
-<paragraph role="paragraph" id="par_idN1082F"><variable id="eitabfile">Choose <menuitem>Sheet - Insert Sheet from File</menuitem>.</variable></paragraph>
+
+<section id="insertfromfile">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_idN1082F"><variable id="eitabfile">Choose <menuitem>Sheet - Insert Sheet from File</menuitem>.</variable></paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+  <paragraph role="paragraph" id="par_id151702403498564">Choose <menuitem>Insert - Insert Sheet - From File</menuitem>.</paragraph>
+  <paragraph role="paragraph" id="par_id601702404855774">On the <menuitem>Insert</menuitem> menu of the <menuitem>Insert</menuitem> tab, choose <menuitem>Insert Sheet from File</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_sheet_bar"/>
+  <paragraph role="paragraph" id="par_id281702403424406">Choose <menuitem>Insert Sheet - From file</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+  <table id="tab_id281702403654889">
+    <tablerow>
+      <tablecell>
+        <paragraph id="par_id791702403654890" role="paragraph"><image src="cmd/lc_insert.svg" id="img_id131702403654891" width="1cm" height="1cm"><alt id="alt_id501702403654892">Icon Insert Sheet from File</alt></image></paragraph>
+      </tablecell>
+      <tablecell>
+        <paragraph id="par_id481702403654894" role="paragraph">Insert Sheet From File</paragraph>
+      </tablecell>
+    </tablerow>
+  </table>
+</section>
 
 <section id="insert_function">
   <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
@@ -243,7 +263,25 @@
 <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>
-<paragraph role="paragraph" id="par_id3146776"><variable id="eiextdata">Choose <menuitem>Sheet - External Links</menuitem>.</variable></paragraph>
+
+<section id="extlink">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_id3146776"><variable id="eiextdata">Choose <menuitem>Sheet - External Links</menuitem>.</variable></paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+  <paragraph role="paragraph" id="par_id561702405100757">Choose <menuitem>Data - External Links</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+  <table id="tab_id21702405171182">
+    <tablerow>
+      <tablecell>
+        <paragraph id="par_id631702405171183" role="paragraph"><image src="cmd/lc_insertexternaldatasource.svg" id="img_id121702405171184" width="1cm"  height="1cm"><alt id="alt_id151702405171185">Icon External Links</alt></image></paragraph>
+      </tablecell>
+      <tablecell>
+        <paragraph id="par_id411702405171187" role="paragraph">External Links</paragraph>
+      </tablecell>
+    </tablerow>
+  </table>
+</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>
diff --git a/source/text/scalc/00/sheet_menu.xhp b/source/text/scalc/00/sheet_menu.xhp
index 01842a167f..7c3f16c683 100644
--- a/source/text/scalc/00/sheet_menu.xhp
+++ b/source/text/scalc/00/sheet_menu.xhp
@@ -164,7 +164,10 @@
     </tablerow>
     </table>
 </section>
-
+<section id="addsheetatend">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_id231702400095820">Choose <menuitem>Sheet - Insert Sheet at End</menuitem>.</paragraph>
+</section>
 <comment>Insert sheet</comment>
 <section id="insert_sheet">
   <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
diff --git a/source/text/scalc/01/04050100.xhp b/source/text/scalc/01/04050100.xhp
index ea6f804a54..8c641283cc 100644
--- a/source/text/scalc/01/04050100.xhp
+++ b/source/text/scalc/01/04050100.xhp
@@ -1,7 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -19,30 +16,28 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-
-
-		<helpdocument version="1.0">
+<helpdocument version="1.0">
 <meta>
 <topic id="textscalc0104050100xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Sheet from file</title>
+<title id="tit">Sheet from file</title>
 <filename>/text/scalc/01/04050100.xhp</filename>
 </topic>
 </meta>
 <body>
+<bookmark branch="hid/.uno:InsertSheetFromFile" id="bm_id1850337" localize="false"/>
 <section id="sheetfromfile">
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertSheetFromFile" id="bm_id1850337" localize="false"/>
-<h1 id="par_idN105C1"><link href="text/scalc/01/04050100.xhp">Sheet from file</link></h1>
-<paragraph role="paragraph" id="par_idN105D1" xml-lang="en-US"><ahelp hid=".">Inserts a sheet from a different spreadsheet file.</ahelp></paragraph>
+<h1 id="par_idN105C1"><link href="text/scalc/01/04050100.xhp">Insert Sheet from file</link></h1>
+<paragraph role="paragraph" id="par_idN105D1"><ahelp hid=".">Inserts a sheet from a different spreadsheet file.</ahelp></paragraph>
 </section>
 <section id="howtoget">
-  <embed href="text/scalc/00/00000404.xhp#eitabfile"/>
+  <embed href="text/scalc/00/00000404.xhp#insertfromfile"/>
 </section>
 <list type="ordered">
 <listitem>
-<paragraph role="paragraph" id="par_idN105F7" xml-lang="en-US">Use the <link href="text/shared/01/01020000.xhp">File - Open</link> dialog to locate the spreadsheet.</paragraph>
+<paragraph role="paragraph" id="par_idN105F7">Use the <link href="text/shared/01/01020000.xhp">File - Open</link> dialog to locate the spreadsheet.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="paragraph" id="par_idN10609" xml-lang="en-US">In the <link href="text/scalc/01/04050000.xhp">Insert Sheet</link> dialog, select the sheet that you want to insert.</paragraph>
+<paragraph role="paragraph" id="par_idN10609">In the <link href="text/scalc/01/04050000.xhp">Insert Sheet</link> dialog, select the sheet that you want to insert.</paragraph>
 </listitem>
 </list>
 </body>
diff --git a/source/text/scalc/01/04090000.xhp b/source/text/scalc/01/04090000.xhp
index 5e85c8fe30..126d9e6282 100644
--- a/source/text/scalc/01/04090000.xhp
+++ b/source/text/scalc/01/04090000.xhp
@@ -22,37 +22,37 @@
 
 <meta>
       <topic id="textscalc0104090000xml" indexer="include" status="PUBLISH">
-         <title xml-lang="en-US" id="tit">External Links</title>
+         <title id="tit">External Links</title>
          <filename>/text/scalc/01/04090000.xhp</filename>
       </topic>
-   </meta>
-   <body>
-      <section id="extdata">
-         <paragraph xml-lang="en-US" id="par_id3153361" role="paragraph" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/browse" id="bm_id3151041" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id3153192" role="paragraph"><ahelp hid="modules/scalc/ui/externaldata/browse" visibility="hidden">Open a file dialog to locate the file containing the data you want to insert.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertExternalDataSource" id="bm_id3748965" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/ExternalDataDialog" id="bm_id3150441" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/@@nowidget@@" id="bm_id3150441" localize="false"/>
-<h1 id="hd_id3145785"><link href="text/scalc/01/04090000.xhp">External Links</link></h1>
-         <paragraph xml-lang="en-US" id="par_id3149262" role="paragraph"><ahelp hid=".uno:InsertExternalDataSourc">Inserts data from an HTML, Calc, CSV or Excel file into the current sheet as a link. The data must be located within a named range.</ahelp></paragraph>
-      </section>
-      <section id="howtoget">
-         <embed href="text/scalc/00/00000404.xhp#eiextdata"/>
-      </section>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/url" id="bm_id3148577" localize="false"/>
+</meta>
+<body>
+   <paragraph id="par_id3153361" role="paragraph" localize="false"/>
+   <bookmark branch="hid/modules/scalc/ui/externaldata/browse" id="bm_id3151041" localize="false"/>
+   <bookmark branch="hid/.uno:InsertExternalDataSource" id="bm_id3748965" localize="false"/>
+   <bookmark branch="hid/modules/scalc/ui/externaldata/ExternalDataDialog" id="bm_id3150441" localize="false"/>
+   <bookmark branch="hid/modules/scalc/ui/externaldata/@@nowidget@@" id="bm_id3150441" localize="false"/>
+<section id="extdata">
+   <h1 id="hd_id3145785"><link href="text/scalc/01/04090000.xhp">External Links</link></h1>
+   <paragraph id="par_id3149262" role="paragraph"><ahelp hid=".uno:InsertExternalDataSourc">Inserts data from an HTML, Calc, CSV or Excel file into the current sheet as a link. The data must be located within a named range.</ahelp></paragraph>
+</section>
+   <paragraph id="par_id3153192" role="paragraph"><ahelp hid="modules/scalc/ui/externaldata/browse" visibility="hidden">Open a file dialog to locate the file containing the data you want to insert.</ahelp></paragraph>
+<section id="howtoget">
+   <embed href="text/scalc/00/00000404.xhp#extlink"/>
+</section>
+<bookmark branch="hid/modules/scalc/ui/externaldata/url" id="bm_id3148577" localize="false"/>
 <h2 id="hd_id3146984">URL of external data source.</h2>
-<paragraph xml-lang="en-US" id="par_id3145366" role="paragraph"><ahelp hid="modules/scalc/ui/externaldata/url">Enter the URL or the file name that contains the data that you want to insert, and then press Enter.</ahelp> Alternatively, click <emph>Browse</emph> button to select the file name from a file dialog that opens. Only then will the URL be requested from the network or file system.</paragraph>
-<paragraph xml-lang="en-US" id="par_id621519313666202" role="note"><link href="text/shared/00/00000208.xhp">A dialog for CSV data import</link> appears when linking to external CSV file.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/ranges" id="bm_id3153876" localize="false"/>
+<paragraph id="par_id3145366" role="paragraph"><ahelp hid="modules/scalc/ui/externaldata/url">Enter the URL or the file name that contains the data that you want to insert, and then press Enter.</ahelp> Alternatively, click <emph>Browse</emph> button to select the file name from a file dialog that opens. Only then will the URL be requested from the network or file system.</paragraph>
+<note id="par_id621519313666202"><link href="text/shared/00/00000208.xhp">A dialog for CSV data import</link> appears when linking to external CSV file.</note>
+<bookmark branch="hid/modules/scalc/ui/externaldata/ranges" id="bm_id3153876" localize="false"/>
 <h2 id="hd_id3145251">Available tables/ranges</h2>
-      <paragraph xml-lang="en-US" id="par_id3147397" role="paragraph"><ahelp hid="modules/scalc/ui/externaldata/ranges">Select the table or the data range that you want to insert.</ahelp> If the selected Calc or Excel document contains no named range, spreadsheet data cannot be inserted and <emph>OK</emph> button will remain inactive </paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/reload" id="bm_id3153418" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/delay" id="bm_id3150718" localize="false"/>
+<paragraph id="par_id3147397" role="paragraph"><ahelp hid="modules/scalc/ui/externaldata/ranges">Select the table or the data range that you want to insert.</ahelp> If the selected Calc or Excel document contains no named range, spreadsheet data cannot be inserted and <emph>OK</emph> button will remain inactive </paragraph>
+<bookmark branch="hid/modules/scalc/ui/externaldata/reload" id="bm_id3153418" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/externaldata/delay" id="bm_id3150718" localize="false"/>
 <h2 id="hd_id3154492">Update every</h2>
-      <paragraph xml-lang="en-US" id="par_id3154017" role="paragraph"><ahelp hid="modules/scalc/ui/externaldata/delay">Enter the number of seconds to wait before the external data are reloaded into the current document.</ahelp></paragraph>
-      <section id="relatedtopics">
-          <embed href="text/scalc/guide/webquery.xhp#webquery"/>
-      </section>
-   </body>
+<paragraph id="par_id3154017" role="paragraph"><ahelp hid="modules/scalc/ui/externaldata/delay">Enter the number of seconds to wait before the external data are reloaded into the current document.</ahelp></paragraph>
+<section id="relatedtopics">
+   <embed href="text/scalc/guide/webquery.xhp#webquery"/>
+</section>
+</body>
 </helpdocument>
diff --git a/source/text/scalc/01/Add.xhp b/source/text/scalc/01/Add.xhp
new file mode 100644
index 0000000000..1c5c3f4427
--- /dev/null
+++ b/source/text/scalc/01/Add.xhp
@@ -0,0 +1,29 @@
+<?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="text/scalc/01/Add.xhp" indexer="include" status="PUBLISH">
+            <title id="tit">Insert Sheet at End</title>
+            <filename>/text/scalc/01/Add.xhp</filename>
+        </topic>
+    </meta>
+    <body>
+
+<bookmark branch="hid/.uno:Add" id="bm_id991702399745390" localize="false"/>
+    <section id="addatend">
+        <h1 id="hd_id611702399875408"><variable id="h1"><link href="text/scalc/01/Add.xhp">Insert Sheet at End</link></variable></h1>
+        <paragraph id="par_id701702399875410" role="paragraph">Adds a new sheet at end of the spreadsheet document.</paragraph>
+    </section>
+    <section id="howtoget">
+        <embed href="text/scalc/00/sheet_menu.xhp#addsheetatend"/>
+    </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/main0116.xhp b/source/text/scalc/main0116.xhp
index a009981faf..e2f9f1815a 100644
--- a/source/text/scalc/main0116.xhp
+++ b/source/text/scalc/main0116.xhp
@@ -44,6 +44,10 @@
 <embed href="text/shared/01/DeleteRows.xhp#delete_rows"/>
 <embed href="text/shared/01/DeleteColumns.xhp#delete_columns"/>
 <embed href="text/scalc/01/02190000.xhp#del_page_break"/>
+<embed href="text/scalc/01/04050000.xhp#insertsheet"/>
+<embed href="text/scalc/01/Add.xhp#addatend"/>
+<embed href="text/scalc/01/04050100.xhp#sheetfromfile"/>
+<embed href="text/scalc/01/04090000.xhp#extdata"/>
 
 <embed href="text/scalc/01/02140000.xhp#fill"/>
 <embed href="text/scalc/01/02150000.xhp#del_contents"/>