summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2023-12-12 18:36:27 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2023-12-13 01:31:17 +0100
commit6146de52abfcda67cb466fea0b88627a15b8b5f3 (patch)
tree7d0227745201032c8498d543542d2e1af7ca6ae5
parent9f9629999542a607ae8cf7beddae2e4eb8db0a7e (diff)
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
-rw-r--r--AllLangHelp_scalc.mk1
-rw-r--r--source/text/scalc/00/00000404.xhp42
-rw-r--r--source/text/scalc/00/sheet_menu.xhp5
-rw-r--r--source/text/scalc/01/04050100.xhp21
-rw-r--r--source/text/scalc/01/04090000.xhp56
-rw-r--r--source/text/scalc/01/Add.xhp29
-rw-r--r--source/text/scalc/main0116.xhp4
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"/>