From f412e2dadeeba74aa71293d010d9a6d092d38e64 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Mon, 22 May 2023 12:08:54 -0300 Subject: tdf#140091 Precisions for the (+) button in sheet tabs bar. Change-Id: I6c125b5fa230690f598399b68e1f310f4cbc25d5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/152129 Tested-by: Jenkins Reviewed-by: Olivier Hallot --- source/text/scalc/guide/multi_tables.xhp | 53 +++++++++++++++++--------------- source/text/scalc/guide/multitables.xhp | 44 +++++++++++--------------- 2 files changed, 47 insertions(+), 50 deletions(-) (limited to 'source/text/scalc/guide') diff --git a/source/text/scalc/guide/multi_tables.xhp b/source/text/scalc/guide/multi_tables.xhp index 8639535346..7c00793ef5 100644 --- a/source/text/scalc/guide/multi_tables.xhp +++ b/source/text/scalc/guide/multi_tables.xhp @@ -1,7 +1,4 @@ - - - - - - + -Navigating Through Sheets Tabs +Navigating Through Sheets Tabs /text/scalc/guide/multi_tables.xhp - - - -sheets; showing multiple + + +sheets; showing multiple sheet tabs;using views;multiple sheets +sheet navigation bar +sheets; jump to - Navigating Through Sheet Tabs - - By default $[officename] displays three sheets "Sheet1" to "Sheet3", in each new spreadsheet. You can switch between sheets in a spreadsheet using the sheet tabs at the bottom of the screen. - -Sheet Tabs - +

Navigating Through Sheet Tabs

+By default %PRODUCTNAME displays one sheet "Sheet1" in each new spreadsheet document. You can add sheets using the (+) button at the bottom of the screen and switch between sheets in a spreadsheet using the sheet tabs. +If the sheet tabs are not visible, choose %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Calc - View - Sheet tabs to display them at the bottom of the screen. + +Sheet Tabs - - - -Icon + +Sheet navigation buttons - Use the navigation buttons to display all the sheets belonging to your document. Clicking the button on the far left or the far right displays, respectively, the first or last sheet tab. The middle buttons allow the user to scroll forward and backward through all sheet tabs. To display the sheet itself click on the sheet tab. + The navigation buttons are enabled when the number of sheets in the document is greater that the number of sheets displayed in the sheet navigation bar. + Use the navigation buttons to display all the sheets belonging to your document. Clicking the button on the far left or the far right displays, respectively, the first or last sheet tab. The middle buttons allow the user to scroll forward and backward through all sheet tabs. To display the sheet itself click on the sheet tab.
+ + + + + Icon New Sheet + + + + Left click: Adds a new empty sheet to the right of the current sheet. + Right click: Opens a sub menu with all sheets not marked hidden. Click on a sheet name to jump to it. Hidden sheets are not listed in the sub menu. + + +
- -
diff --git a/source/text/scalc/guide/multitables.xhp b/source/text/scalc/guide/multitables.xhp index 326194ce9a..4bc09eccee 100644 --- a/source/text/scalc/guide/multitables.xhp +++ b/source/text/scalc/guide/multitables.xhp @@ -22,12 +22,12 @@ - Applying Multiple Sheets + Applying Multiple Sheets /text/scalc/guide/multitables.xhp -sheets; inserting +sheets; inserting inserting; sheets sheets; selecting multiple appending sheets @@ -35,39 +35,31 @@ multiple sheets calculating;multiple sheets MW moved "sheets;simultaneous.." to edit_multitables.xhp, transferred 2 entries from there and added "calculating;" -Applying Multiple Sheets - +

Applying Multiple Sheets

Inserting a Sheet

- - - Choose Insert - Sheet to insert a new sheet or an existing sheet from another file. - - + Choose Insert - Sheet to insert a new sheet or an existing sheet from another file. -Sheet Events -Opens a dialog box where you can assign macros to sheet events. +Sheet Events +Opens a dialog box where you can assign macros to sheet events. -Tab Color - -Opens a window where you can assign a color to the sheet tab. +Tab Color + +Opens a window where you can assign a color to the sheet tab. - -Click to select all sheets in the document. - -Click to deselect all sheets in the document, except the current sheet. + +Click to select all sheets in the document. + +Click to deselect all sheets in the document, except the current sheet.

Selecting Multiple Sheets

- The sheet tab of the current sheet is always visible in white in front of the other sheet tabs. The other sheet tabs are gray when they are not selected. By clicking other sheet tabs while pressing CommandCtrl you can select multiple sheets. - You can use Shift+Command -Ctrl+Page Up or Page Down to select multiple sheets using the keyboard. + The sheet tab of the current sheet is always visible in white in front of the other sheet tabs. The other sheet tabs are gray when they are not selected. By clicking other sheet tabs while pressing CommandCtrl you can select multiple sheets. + You can use Shift+CommandCtrl+Page Up or Page Down to select multiple sheets using the keyboard.

Undoing a Selection

- To undo the selection of a sheet, click its sheet tab again while pressing the CommandCtrl key. The sheet that is currently visible cannot be removed from the selection. + To undo the selection of a sheet, click its sheet tab again while pressing the CommandCtrl key. The sheet that is currently visible cannot be removed from the selection.

Calculating Across Multiple Sheets

- You can refer to a range of sheets in a formula by specifying the first and last sheet of the range, for example, =SUM(Sheet1.A1:Sheet3.A1) sums up all A1 cells on Sheet1 through Sheet3. - - + You can refer to a range of sheets in a formula by specifying the first and last sheet of the range, for example, =SUM(Sheet1.A1:Sheet3.A1) sums up all A1 cells on Sheet1 through Sheet3.
- \ No newline at end of file + -- cgit