summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2023-05-22 12:08:54 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2023-05-22 21:26:08 +0200
commitf412e2dadeeba74aa71293d010d9a6d092d38e64 (patch)
tree2a721621300839ddf68aecff79d6bca53f08aceb
parent8322f7d3b512cbd1a548a1b37d07d5614e3bb3c6 (diff)
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 <olivier.hallot@libreoffice.org>
-rw-r--r--source/text/scalc/guide/multi_tables.xhp53
-rw-r--r--source/text/scalc/guide/multitables.xhp44
2 files changed, 47 insertions, 50 deletions
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 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,48 +16,56 @@
* 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="textscalcguidemulti_tablesxml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Navigating Through Sheets Tabs</title>
+<title id="tit">Navigating Through Sheets Tabs</title>
<filename>/text/scalc/guide/multi_tables.xhp</filename>
</topic>
</meta>
<body>
-
-
-
-<bookmark xml-lang="en-US" branch="index" id="bm_id3150769"><bookmark_value>sheets; showing multiple</bookmark_value>
+
+<bookmark branch="index" id="bm_id3150769">
+<bookmark_value>sheets; showing multiple</bookmark_value>
<bookmark_value>sheet tabs;using</bookmark_value>
<bookmark_value>views;multiple sheets</bookmark_value>
+<bookmark_value>sheet navigation bar</bookmark_value>
+<bookmark_value>sheets; jump to</bookmark_value>
</bookmark>
- <paragraph xml-lang="en-US" id="hd_id3150769" role="heading" level="1"><variable id="multi_tables"><link href="text/scalc/guide/multi_tables.xhp">Navigating Through Sheet Tabs</link>
-</variable></paragraph>
- <paragraph xml-lang="en-US" id="par_id3153771" role="paragraph">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.</paragraph>
- <paragraph xml-lang="en-US" id="par_idN106AF" role="paragraph">
-<image id="img_id4829822" src="media/helpimg/sheettabs.png" width="3.3335inch" height="0.7638inch" localize="true"><alt xml-lang="en-US" id="alt_id4829822">Sheet Tabs</alt>
- </image></paragraph>
+ <h1 id="hd_id3150769"><variable id="multi_tables"><link href="text/scalc/guide/multi_tables.xhp">Navigating Through Sheet Tabs</link></variable></h1>
+<paragraph id="par_id3153771" role="paragraph">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.</paragraph>
+<note id="par_id301684765313669">If the sheet tabs are not visible, choose <switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - View - Sheet tabs</menuitem> to display them at the bottom of the screen.</note>
+ <paragraph id="par_idN106AF" role="paragraph">
+<image id="img_id4829822" src="media/helpimg/sheettabs.png" width="3.3335inch" height="0.7638inch" localize="true"><alt id="alt_id4829822">Sheet Tabs</alt></image></paragraph>
<table id="tbl_id3153728">
-
-
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3153144" role="paragraph">
-<image id="img_id3156441" src="media/helpimg/calcnav.png" width="0.6563inch" height="0.1457inch"><alt xml-lang="en-US" id="alt_id3156441">Icon</alt>
+ <paragraph id="par_id3153144" role="paragraph">
+<image id="img_id3156441" src="media/helpimg/calcnav.png" width="0.6563inch" height="0.1457inch"><alt id="alt_id3156441">Sheet navigation buttons</alt>
</image></paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3147396" role="paragraph">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.</paragraph>
+ <paragraph role="paragraph" id="par_id51684763810316">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.</paragraph>
+ <paragraph id="par_id3147396" role="paragraph">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.</paragraph>
</tablecell>
</tablerow>
</table>
+ <table id="tab_id571684763266821">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id61684763266822" role="paragraph">
+ <image src="res/plus.svg" id="img_id11684763266823" width="1cm" height="1cm"><alt xml-lang="en-US" id="alt_id361684763266824">Icon New Sheet</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id551684763266826" role="paragraph" xml-lang="en-US">Left click: Adds a new empty sheet to the right of the current sheet.</paragraph>
+ <paragraph role="paragraph" id="par_id731684763833940">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. </paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
<section id="relatedtopics">
-
<embed href="text/scalc/guide/multitables.xhp#multitables"/>
<embed href="text/scalc/guide/edit_multitables.xhp#edit_multitables"/>
-
</section>
</body>
</helpdocument>
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 @@
<meta>
<topic id="textscalcguidemultitablesxml" indexer="include" status="PUBLISH">
- <title xml-lang="en-US" id="tit">Applying Multiple Sheets</title>
+ <title id="tit">Applying Multiple Sheets</title>
<filename>/text/scalc/guide/multitables.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id3154759"><bookmark_value>sheets; inserting</bookmark_value>
+<bookmark branch="index" id="bm_id3154759"><bookmark_value>sheets; inserting</bookmark_value>
<bookmark_value>inserting; sheets</bookmark_value>
<bookmark_value>sheets; selecting multiple</bookmark_value>
<bookmark_value>appending sheets</bookmark_value>
@@ -35,39 +35,31 @@
<bookmark_value>multiple sheets</bookmark_value>
<bookmark_value>calculating;multiple sheets</bookmark_value>
</bookmark><comment>MW moved "sheets;simultaneous.." to edit_multitables.xhp, transferred 2 entries from there and added "calculating;"</comment>
-<paragraph xml-lang="en-US" id="hd_id3154759" role="heading" level="1"><variable id="multitables"><link href="text/scalc/guide/multitables.xhp">Applying Multiple Sheets</link>
-</variable></paragraph>
+<h1 id="hd_id3154759"><variable id="multitables"><link href="text/scalc/guide/multitables.xhp">Applying Multiple Sheets</link></variable></h1>
<h2 id="hd_id3148576">Inserting a Sheet</h2>
- <list type="ordered">
- <listitem>
- <paragraph xml-lang="en-US" id="par_id3154731" role="paragraph">Choose <item type="menuitem">Insert - Sheet</item> to insert a new sheet or an existing sheet from another file.</paragraph>
- </listitem>
- </list>
+ <paragraph id="par_id3154731" role="paragraph">Choose <item type="menuitem">Insert - Sheet</item> to insert a new sheet or an existing sheet from another file.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/FID_TAB_EVENTS" id="bm_id906582498" localize="false"/><comment>Sheet Events</comment>
-<paragraph xml-lang="en-US" id="par_id05092009140203598" role="paragraph"><ahelp hid="." visibility="hidden">Opens a dialog box where you can assign macros to sheet events.</ahelp></paragraph>
+<bookmark branch="hid/FID_TAB_EVENTS" id="bm_id906582498" localize="false"/><comment>Sheet Events</comment>
+<paragraph id="par_id05092009140203598" role="paragraph"><ahelp hid="." visibility="hidden">Opens a dialog box where you can assign macros to sheet events.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/FID_TAB_MENU_SET_TAB_BG_COLOR" id="bm_id906582434" localize="false"/><comment>Tab Color</comment>
-<bookmark xml-lang="en-US" branch="hid/FID_TAB_SET_TAB_BG_COLOR" id="bm_id9016345434" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id05092009140203523" role="paragraph"><variable id="sheettabcolor"><ahelp hid="." visibility="hidden">Opens a window where you can assign a color to the sheet tab.</ahelp></variable></paragraph>
+<bookmark branch="hid/FID_TAB_MENU_SET_TAB_BG_COLOR" id="bm_id906582434" localize="false"/><comment>Tab Color</comment>
+<bookmark branch="hid/FID_TAB_SET_TAB_BG_COLOR" id="bm_id9016345434" localize="false"/>
+<paragraph id="par_id05092009140203523" role="paragraph"><variable id="sheettabcolor"><ahelp hid="." visibility="hidden">Opens a window where you can assign a color to the sheet tab.</ahelp></variable></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:TableSelectAll" id="bm_id9065824" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id050920091402035" role="paragraph"><ahelp hid="." visibility="hidden">Click to select all sheets in the document.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:TableDeselectAll" id="bm_id9065825" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0509200914020391" role="paragraph"><ahelp hid="." visibility="hidden">Click to deselect all sheets in the document, except the current sheet.</ahelp></paragraph>
+<bookmark branch="hid/.uno:TableSelectAll" id="bm_id9065824" localize="false"/>
+<paragraph id="par_id050920091402035" role="paragraph"><ahelp hid="." visibility="hidden">Click to select all sheets in the document.</ahelp></paragraph>
+<bookmark branch="hid/.uno:TableDeselectAll" id="bm_id9065825" localize="false"/>
+<paragraph id="par_id0509200914020391" role="paragraph"><ahelp hid="." visibility="hidden">Click to deselect all sheets in the document, except the current sheet.</ahelp></paragraph>
<h2 id="hd_id3154491">Selecting Multiple Sheets</h2>
- <paragraph xml-lang="en-US" id="par_id3145251" role="paragraph">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 <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> you can select multiple sheets.</paragraph>
- <paragraph xml-lang="en-US" id="par_idN106B7" role="paragraph">You can use Shift+<switchinline select="sys"><caseinline select="MAC">Command
-</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Page Up or Page Down to select multiple sheets using the keyboard.</paragraph>
+ <paragraph id="par_id3145251" role="paragraph">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 <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> you can select multiple sheets.</paragraph>
+ <paragraph id="par_idN106B7" role="paragraph">You can use Shift+<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Page Up or Page Down to select multiple sheets using the keyboard.</paragraph>
<h2 id="hd_id3155600">Undoing a Selection</h2>
- <paragraph xml-lang="en-US" id="par_id3146969" role="paragraph">To undo the selection of a sheet, click its sheet tab again while pressing the <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> key. The sheet that is currently visible cannot be removed from the selection.</paragraph>
+ <paragraph id="par_id3146969" role="paragraph">To undo the selection of a sheet, click its sheet tab again while pressing the <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> key. The sheet that is currently visible cannot be removed from the selection.</paragraph>
<h2 id="hd_id3156382">Calculating Across Multiple Sheets</h2>
- <paragraph xml-lang="en-US" id="par_id3155333" role="paragraph">You can refer to a range of sheets in a formula by specifying the first and last sheet of the range, for example, <item type="literal">=SUM(Sheet1.A1:Sheet3.A1) </item>sums up all A1 cells on Sheet1 through Sheet3.</paragraph>
-
-
+ <paragraph id="par_id3155333" role="paragraph">You can refer to a range of sheets in a formula by specifying the first and last sheet of the range, for example, <item type="literal">=SUM(Sheet1.A1:Sheet3.A1) </item>sums up all A1 cells on Sheet1 through Sheet3.</paragraph>
<section id="relatedtopics">
<embed href="text/scalc/guide/multi_tables.xhp#multi_tables"/>
<embed href="text/scalc/guide/edit_multitables.xhp#edit_multitables"/>
</section>
</body>
-</helpdocument> \ No newline at end of file
+</helpdocument>