From 6146de52abfcda67cb466fea0b88627a15b8b5f3 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Tue, 12 Dec 2023 18:36:27 -0300 Subject: 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 (cherry picked from commit dfd902c240c11e611732f1c26345869354a56ba6) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160637 --- source/text/scalc/00/00000404.xhp | 42 ++++++++++++++++++++++++++-- source/text/scalc/00/sheet_menu.xhp | 5 +++- source/text/scalc/01/04050100.xhp | 21 ++++++-------- source/text/scalc/01/04090000.xhp | 56 ++++++++++++++++++------------------- source/text/scalc/01/Add.xhp | 29 +++++++++++++++++++ source/text/scalc/main0116.xhp | 4 +++ 6 files changed, 113 insertions(+), 44 deletions(-) create mode 100644 source/text/scalc/01/Add.xhp (limited to 'source/text') 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 @@ -Choose Sheet - Insert Sheet from File. + +
+ + Choose Sheet - Insert Sheet from File. + + Choose Insert - Insert Sheet - From File. + On the Insert menu of the Insert tab, choose Insert Sheet from File. + + Choose Insert Sheet - From file. + + + + + Icon Insert Sheet from File + + + Insert Sheet From File + + +
+
@@ -243,7 +263,25 @@ Insert - Function - Category Add-In Choose Insert - Named Range or Expression. -Choose Sheet - External Links. + + +
Choose Sheet - Named Ranges and Expressions - Define. CommandCtrl+F3 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 @@
- +
+ + Choose Sheet - Insert Sheet at End. +
Insert sheet
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 @@ - - - - - - + -Sheet from file +Sheet from file /text/scalc/01/04050100.xhp +
- -

Sheet from file

-Inserts a sheet from a different spreadsheet file. +

Insert Sheet from file

+Inserts a sheet from a different spreadsheet file.
- +
-Use the File - Open dialog to locate the spreadsheet. +Use the File - Open dialog to locate the spreadsheet. -In the Insert Sheet dialog, select the sheet that you want to insert. +In the Insert Sheet dialog, select the sheet that you want to insert. 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 @@ - External Links + External Links /text/scalc/01/04090000.xhp - - -
- - -Open a file dialog to locate the file containing the data you want to insert. - - - -

External Links

- 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. -
-
- -
- + + + + + + + +
+

External Links

+ 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. +
+ Open a file dialog to locate the file containing the data you want to insert. +
+ +
+

URL of external data source.

-Enter the URL or the file name that contains the data that you want to insert, and then press Enter. Alternatively, click Browse 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. -A dialog for CSV data import appears when linking to external CSV file. - +Enter the URL or the file name that contains the data that you want to insert, and then press Enter. Alternatively, click Browse 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. +A dialog for CSV data import appears when linking to external CSV file. +

Available tables/ranges

- Select the table or the data range that you want to insert. If the selected Calc or Excel document contains no named range, spreadsheet data cannot be inserted and OK button will remain inactive - - +Select the table or the data range that you want to insert. If the selected Calc or Excel document contains no named range, spreadsheet data cannot be inserted and OK button will remain inactive + +

Update every

- Enter the number of seconds to wait before the external data are reloaded into the current document. -
- -
- +Enter the number of seconds to wait before the external data are reloaded into the current document. +
+ +
+ 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 @@ + + + + + + + Insert Sheet at End + /text/scalc/01/Add.xhp + + + + + +
+

Insert Sheet at End

+ Adds a new sheet at end of the spreadsheet document. +
+
+ +
+ + 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 @@ + + + + -- cgit