summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2023-05-22 16:24:23 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2023-05-22 21:28:30 +0200
commit033dc1a727a6cb48419a08990a2b737058afd99f (patch)
treea962f19844dbc5a01909d2519b904ec26cc76ddc
parentf412e2dadeeba74aa71293d010d9a6d092d38e64 (diff)
Calc Sheet Tab Navigator help page
Change-Id: Ie79a7e1b6e3383d52660e48d145bec5ca7ca89af Reviewed-on: https://gerrit.libreoffice.org/c/help/+/152130 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
-rw-r--r--AllLangHelp_scalc.mk4
-rw-r--r--source/text/scalc/00/sheet_menu.xhp26
-rw-r--r--source/text/scalc/01/02170000.xhp22
-rw-r--r--source/text/scalc/01/02180000.xhp7
-rw-r--r--source/text/scalc/01/02210000.xhp16
-rw-r--r--source/text/scalc/01/04050000.xhp61
-rw-r--r--source/text/scalc/01/05050100.xhp33
-rw-r--r--source/text/scalc/01/05050300.xhp30
-rw-r--r--source/text/scalc/01/06060100.xhp4
-rw-r--r--source/text/scalc/01/duplicate_sheet.xhp34
-rw-r--r--source/text/scalc/01/hide_sheet.xhp37
-rw-r--r--source/text/scalc/01/sheet_tab_color.xhp31
-rw-r--r--source/text/scalc/guide/multitables.xhp19
-rw-r--r--source/text/scalc/main0103.xhp3
-rw-r--r--source/text/scalc/main0116.xhp6
-rw-r--r--source/text/shared/01/02090000.xhp2
16 files changed, 223 insertions, 112 deletions
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 0019a72dce..87956ac0c1 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -192,6 +192,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/data_provider \
helpcontent2/source/text/scalc/01/databar_more_options \
helpcontent2/source/text/scalc/01/default_number_formats \
+ helpcontent2/source/text/scalc/01/duplicate_sheet \
helpcontent2/source/text/scalc/01/ex_data_stat_func \
helpcontent2/source/text/scalc/01/format_graphic \
helpcontent2/source/text/scalc/01/formula2value \
@@ -283,9 +284,11 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/func_workday \
helpcontent2/source/text/scalc/01/func_year \
helpcontent2/source/text/scalc/01/func_yearfrac \
+ helpcontent2/source/text/scalc/01/hide_sheet \
helpcontent2/source/text/scalc/01/live_data_stream \
helpcontent2/source/text/scalc/01/recalculate_hard \
helpcontent2/source/text/scalc/01/shared_spreadsheet \
+ helpcontent2/source/text/scalc/01/sheet_tab_color \
helpcontent2/source/text/scalc/01/solver \
helpcontent2/source/text/scalc/01/solver_options \
helpcontent2/source/text/scalc/01/solver_options_algo \
@@ -423,6 +426,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/guide/webquery \
helpcontent2/source/text/scalc/guide/wildcards \
helpcontent2/source/text/scalc/guide/year2000 \
+ helpcontent2/source/text/scalc/menu/sheet_tab_menu \
helpcontent2/source/text/scalc/main0000 \
helpcontent2/source/text/scalc/main0100 \
helpcontent2/source/text/scalc/main0101 \
diff --git a/source/text/scalc/00/sheet_menu.xhp b/source/text/scalc/00/sheet_menu.xhp
index 875b1b2c6b..6541dcec90 100644
--- a/source/text/scalc/00/sheet_menu.xhp
+++ b/source/text/scalc/00/sheet_menu.xhp
@@ -20,22 +20,26 @@
<meta>
<topic id="textscalc0000000404xml" indexer="exclude" status="PUBLISH">
- <title id="tit" xml-lang="en-US">Sheet Menu</title>
+ <title id="tit">Sheet Menu</title>
<filename>/text/scalc/00/sheet_menu.xhp</filename>
</topic>
</meta>
<body>
<h1 id="hd_id160220162108024368">Sheet Menu</h1>
-<paragraph id="par_id160220162106567373" role="paragraph" xml-lang="en-US"><variable id="insert_rows_above">Choose <emph>Sheet - Insert Rows - Rows Above</emph>.</variable></paragraph>
-<paragraph id="par_id160220162109048207" role="paragraph" xml-lang="en-US"><variable id="insert_rows_below">Choose <emph>Sheet - Insert Rows - Rows Below</emph>.</variable></paragraph>
-<paragraph id="par_id160220162107055028" role="paragraph" xml-lang="en-US"><variable id="insert_columns_left">Choose <emph>Sheet - Insert Columns - Columns Before</emph>.</variable></paragraph>
-<paragraph id="par_id160220162109126013" role="paragraph" xml-lang="en-US"><variable id="insert_columns_right">Choose <emph>Sheet - Insert Columns - Columns After</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3149095" xml-lang="en-US"><variable id="insert_page_break">Choose <emph>Sheet - Insert Page Break</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3149398" xml-lang="en-US"><variable id="insert_page_break_row">Choose <emph>Sheet - Insert Page Break - Row Break</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3150084" xml-lang="en-US"><variable id="insert_page_break_column">Choose <emph>Sheet - Insert Page Break - Column Break</emph>.</variable></paragraph>
-<paragraph id="par_id3153093" role="paragraph" xml-lang="en-US"><variable id="delete_page_break">Choose <emph>Sheet - Delete Page Break</emph>.</variable></paragraph>
-<paragraph id="par_id3153191" role="paragraph" xml-lang="en-US"><variable id="delete_page_break_row">Choose <emph>Sheet - Delete Page Break - Row Break</emph>.</variable></paragraph>
-<paragraph id="par_id3145645" role="paragraph" xml-lang="en-US"><variable id="delete_page_break_column">Choose <emph>Sheet - Delete Page Break - Column Break</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id541684770785578"><variable id="duplicate_sheet">Choose <menuitem>Sheet - Duplicate Sheet</menuitem>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id261684778277541"><variable id="sheettabcolor">Choose <menuitem>Sheet - Sheet Tab Color</menuitem>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id261634778277541"><variable id="hidesheet">Choose <menuitem>Sheet - Hide Sheet</menuitem>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id451634778277541"><variable id="showsheet">Choose <menuitem>Sheet - Show Sheet</menuitem>.</variable></paragraph>
+<paragraph id="par_id160220162106567373" role="paragraph"><variable id="insert_rows_above">Choose <emph>Sheet - Insert Rows - Rows Above</emph>.</variable></paragraph>
+<paragraph id="par_id160220162109048207" role="paragraph"><variable id="insert_rows_below">Choose <emph>Sheet - Insert Rows - Rows Below</emph>.</variable></paragraph>
+<paragraph id="par_id160220162107055028" role="paragraph"><variable id="insert_columns_left">Choose <emph>Sheet - Insert Columns - Columns Before</emph>.</variable></paragraph>
+<paragraph id="par_id160220162109126013" role="paragraph"><variable id="insert_columns_right">Choose <emph>Sheet - Insert Columns - Columns After</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3149095"><variable id="insert_page_break">Choose <emph>Sheet - Insert Page Break</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3149398"><variable id="insert_page_break_row">Choose <emph>Sheet - Insert Page Break - Row Break</emph>.</variable></paragraph>
+<paragraph role="paragraph" id="par_id3150084"><variable id="insert_page_break_column">Choose <emph>Sheet - Insert Page Break - Column Break</emph>.</variable></paragraph>
+<paragraph id="par_id3153093" role="paragraph"><variable id="delete_page_break">Choose <emph>Sheet - Delete Page Break</emph>.</variable></paragraph>
+<paragraph id="par_id3153191" role="paragraph"><variable id="delete_page_break_row">Choose <emph>Sheet - Delete Page Break - Row Break</emph>.</variable></paragraph>
+<paragraph id="par_id3145645" role="paragraph"><variable id="delete_page_break_column">Choose <emph>Sheet - Delete Page Break - Column Break</emph>.</variable></paragraph>
<paragraph role="paragraph" id="par_id281631903136031"><variable id="edit_comment">Choose <menuitem>Sheet - Cell Comments - Edit Comment</menuitem></variable></paragraph>
<paragraph role="paragraph" id="par_id641631903140705"><variable id="hide_comment">Choose <menuitem>Sheet - Cell Comments - Hide Comment</menuitem></variable></paragraph>
diff --git a/source/text/scalc/01/02170000.xhp b/source/text/scalc/01/02170000.xhp
index 77c0fbacf2..229c85636d 100644
--- a/source/text/scalc/01/02170000.xhp
+++ b/source/text/scalc/01/02170000.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,11 +16,10 @@
* 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">
<meta>
<topic id="textscalc0102170000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Delete Sheet</title>
+<title id="tit">Delete Sheet</title>
<filename>/text/scalc/01/02170000.xhp</filename>
</topic>
<history>
@@ -30,21 +27,22 @@
</history>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id3156424"><bookmark_value>spreadsheets; deleting</bookmark_value>
+<bookmark branch="index" id="bm_id3156424"><bookmark_value>spreadsheets; deleting</bookmark_value>
<bookmark_value>sheets; deleting</bookmark_value>
<bookmark_value>deleting; spreadsheets</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:Remove" id="bm_id3150769" localize="false"/>
-<h1 id="hd_id3156424"> Delete Sheet</h1>
-<paragraph role="paragraph" id="par_id3153193" xml-lang="en-US"><variable id="tabelleloeschentext"><ahelp hid=".uno:Remove">Deletes the current sheet after query confirmation.</ahelp>
-</variable></paragraph>
+<bookmark branch="hid/.uno:Remove" id="bm_id3150769" localize="false"/>
+<section id="deletesheet">
+<h1 id="hd_id3156424"><variable id="delete_sheet"><link href="text/scalc/01/02170000.xhp#deletesheet">Delete Sheet</link></variable></h1>
+<paragraph role="paragraph" id="par_id3153193"><variable id="tabelleloeschentext"><ahelp hid=".uno:Remove">Deletes the current sheet after query confirmation.</ahelp></variable></paragraph>
+</section>
<section id="howtoget">
<embed href="text/scalc/00/00000402.xhp#delete_sheet"/>
</section>
-<paragraph role="note" id="par_id3145801" xml-lang="en-US">You cannot delete a sheet while <emph>Edit - Track Changes - Record</emph> is activated.</paragraph>
+<note id="par_id3145801">You cannot delete a sheet while <emph>Edit - Track Changes - Record</emph> is activated.</note>
<h2 id="hd_id3147124">Yes</h2>
-<paragraph role="paragraph" id="par_id3154943" xml-lang="en-US">Deletes the current sheet.</paragraph>
+<paragraph role="paragraph" id="par_id3154943">Deletes the current sheet.</paragraph>
<h2 id="hd_id3149412">No</h2>
-<paragraph role="paragraph" id="par_id3154510" xml-lang="en-US">Cancels the dialog. No delete is performed.</paragraph>
+<paragraph role="paragraph" id="par_id3154510">Cancels the dialog. No delete is performed.</paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/02180000.xhp b/source/text/scalc/01/02180000.xhp
index 57287363f6..50f0ce8b54 100644
--- a/source/text/scalc/01/02180000.xhp
+++ b/source/text/scalc/01/02180000.xhp
@@ -38,9 +38,10 @@
<bookmark xml-lang="en-US" branch="hid/.uno:Move" id="bm_id9622978" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/movecopysheet/MoveCopySheetDialog" id="bm_id3149657" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/movecopysheet/@@nowidget@@" id="bm_id3149657" localize="false"/>
-<h1 id="hd_id3153360">Move or Copy a Sheet</h1>
-<paragraph role="paragraph" id="par_id3154686" xml-lang="en-US"><variable id="tabelleverschiebenkopierentext"><ahelp hid=".uno:Move">Moves or copies a sheet to a new location in the document or to a different document.</ahelp>
-</variable></paragraph>
+<section id="movecopysheet">
+ <h1 id="hd_id3153360"><variable id="movecopy_sheet"><link href="text/scalc/01/02180000.xhp#movecopysheet">Move or Copy a Sheet</link></variable></h1>
+<paragraph role="paragraph" id="par_id3154686" xml-lang="en-US"><variable id="tabelleverschiebenkopierentext"><ahelp hid=".uno:Move">Moves or copies a sheet to a new location in the document or to a different document.</ahelp></variable></paragraph>
+</section>
<section id="howtoget">
<embed href="text/scalc/00/00000402.xhp#move_or_copy_sheet"/>
</section>
diff --git a/source/text/scalc/01/02210000.xhp b/source/text/scalc/01/02210000.xhp
index a31d3ae288..9a36f37102 100644
--- a/source/text/scalc/01/02210000.xhp
+++ b/source/text/scalc/01/02210000.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,11 +16,10 @@
* 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">
<meta>
<topic id="textscalc0102210000xml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Selecting Sheets</title>
+<title id="tit">Selecting Sheets</title>
<filename>/text/scalc/01/02210000.xhp</filename>
</topic>
<history>
@@ -30,13 +27,12 @@
</history>
</meta>
<body>
-
-
-<bookmark branch="hid/.uno:SelectTables" xml-lang="en-US" id="bm_id3154758" localize="false"/>
+
+<bookmark branch="hid/.uno:SelectTables" id="bm_id3154758" localize="false"/>
<h1 id="hd_id3156023">Selecting Sheets</h1>
- <paragraph role="paragraph" id="par_id3147265" xml-lang="en-US"><variable id="tabellenauswaehlen"><ahelp hid=".uno:SelectTables" visibility="visible">Selects multiple sheets.</ahelp></variable></paragraph>
- <bookmark branch="hid/SC_HID_SELECTTABLES" xml-lang="en-US" id="bm_id3154126" localize="false"/>
+ <paragraph role="paragraph" id="par_id3147265"><variable id="tabellenauswaehlen"><ahelp hid=".uno:SelectTables" visibility="visible">Selects multiple sheets.</ahelp></variable></paragraph>
+ <bookmark branch="hid/SC_HID_SELECTTABLES" id="bm_id3154126" localize="false"/>
<h2 id="hd_id3125863">Selected Sheets</h2>
- <paragraph role="paragraph" id="par_id3153969" xml-lang="en-US"><ahelp hid="SC_HID_SELECTTABLES">Lists the sheets in the current document. To select a sheet, press the up or down arrow keys to move to a sheet in the list. To add a sheet to the selection, hold down <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> while pressing the arrow keys and then press Spacebar. To select a range of sheets, hold down Shift and press the arrow keys. </ahelp></paragraph>
+ <paragraph role="paragraph" id="par_id3153969"><ahelp hid="SC_HID_SELECTTABLES">Lists the sheets in the current document. To select a sheet, press the up or down arrow keys to move to a sheet in the list. To add a sheet to the selection, hold down <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> while pressing the arrow keys and then press Spacebar. To select a range of sheets, hold down Shift and press the arrow keys. </ahelp></paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/04050000.xhp b/source/text/scalc/01/04050000.xhp
index e1c7556f93..e6fb273fdb 100644
--- a/source/text/scalc/01/04050000.xhp
+++ b/source/text/scalc/01/04050000.xhp
@@ -19,56 +19,59 @@
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
<meta>
<topic id="textscalc0104050000xml" indexer="include">
-<title id="tit" xml-lang="en-US">Insert Sheet</title>
+<title id="tit">Insert Sheet</title>
<filename>/text/scalc/01/04050000.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id4522232"><bookmark_value>sheets;creating</bookmark_value>
+<bookmark branch="index" id="bm_id4522232">
+<bookmark_value>sheets;creating</bookmark_value>
+<bookmark_value>sheets; inserting</bookmark_value>
+<bookmark_value>inserting; sheets</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertsheet/InsertSheetDialog" id="bm_id3151384" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertsheet/@@nowidget@@" id="bm_id3151384" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/.uno:Insert" id="bm_id1669896" localize="false"/>
-<h1 id="hd_id3155629">Insert Sheet</h1>
-<paragraph role="paragraph" id="par_id3147264" xml-lang="en-US"><variable id="tabelleeinfuegentext"><ahelp hid=".uno:Insert">Defines the options to be used to insert a new sheet.</ahelp> You can create a new sheet, or insert an existing sheet from a file.
-</variable></paragraph>
+<bookmark branch="hid/modules/scalc/ui/insertsheet/InsertSheetDialog" id="bm_id3151384" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/insertsheet/@@nowidget@@" id="bm_id3151384" localize="false"/>
+<bookmark branch="hid/.uno:Insert" id="bm_id1669896" localize="false"/>
+<section id="insertsheet">
+<h1 id="hd_id3155629"><variable id="insert_sheet"><link href="text/scalc/01/04050000.xhp#insertsheet">Insert Sheet</link></variable></h1>
+<paragraph role="paragraph" id="par_id3147264"><variable id="tabelleeinfuegentext"><ahelp hid=".uno:Insert">Defines the options to be used to insert a new sheet.</ahelp> You can create a new sheet, or insert an existing sheet from a file.</variable></paragraph>
+</section>
<section id="howtoget">
<embed href="text/scalc/00/00000404.xhp#eitab"/>
</section>
<h2 id="hd_id3154684">Position</h2>
-<paragraph role="paragraph" id="par_id3156281" xml-lang="en-US">Specifies where the new sheet is to be inserted into your document.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertsheet/before" id="bm_id3155131" localize="false"/>
+<paragraph role="paragraph" id="par_id3156281">Specifies where the new sheet is to be inserted into your document.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/insertsheet/before" id="bm_id3155131" localize="false"/>
<h3 id="hd_id3154123">Before current sheet</h3>
-<paragraph role="paragraph" id="par_id3145787" xml-lang="en-US"><ahelp hid="modules/scalc/ui/insertsheet/before">Inserts a new sheet directly before the current sheet.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertsheet/after" id="bm_id3147434" localize="false"/>
+<paragraph role="paragraph" id="par_id3145787"><ahelp hid="modules/scalc/ui/insertsheet/before">Inserts a new sheet directly before the current sheet.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/insertsheet/after" id="bm_id3147434" localize="false"/>
<h3 id="hd_id3155414">After current sheet</h3>
-<paragraph role="paragraph" id="par_id3145271" xml-lang="en-US"><ahelp hid="modules/scalc/ui/insertsheet/after">Inserts a new sheet directly after the current sheet.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3145271"><ahelp hid="modules/scalc/ui/insertsheet/after">Inserts a new sheet directly after the current sheet.</ahelp></paragraph>
<h2 id="hd_id3147428">Sheet</h2>
-<paragraph role="paragraph" id="par_id3154012" xml-lang="en-US">Specifies whether a new sheet or an existing sheet is inserted into the document.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertsheet/new" id="bm_id3145750" localize="false"/>
+<paragraph role="paragraph" id="par_id3154012">Specifies whether a new sheet or an existing sheet is inserted into the document.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/insertsheet/new" id="bm_id3145750" localize="false"/>
<h2 id="hd_id3147350">New sheet</h2>
-<paragraph role="paragraph" id="par_id3149262" xml-lang="en-US"><ahelp hid="modules/scalc/ui/insertsheet/new">Creates a new sheet. Enter a sheet name in the <emph>Name</emph> field. Allowed characters are letters, numbers, spaces, and the underline character.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertsheet/countnf" id="bm_id3153157" localize="false"/>
+<paragraph role="paragraph" id="par_id3149262"><ahelp hid="modules/scalc/ui/insertsheet/new">Creates a new sheet. Enter a sheet name in the <emph>Name</emph> field. Allowed characters are letters, numbers, spaces, and the underline character.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/insertsheet/countnf" id="bm_id3153157" localize="false"/>
<h3 id="hd_id3155418">No. of sheets</h3>
-<paragraph role="paragraph" id="par_id3148457" xml-lang="en-US"><ahelp hid="modules/scalc/ui/insertsheet/countnf">Specifies the number of sheets to be created.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertsheet/nameed" id="bm_id3154510" localize="false"/>
+<paragraph role="paragraph" id="par_id3148457"><ahelp hid="modules/scalc/ui/insertsheet/countnf">Specifies the number of sheets to be created.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/insertsheet/nameed" id="bm_id3154510" localize="false"/>
<h3 id="hd_id3149379">Name</h3>
-<paragraph role="paragraph" id="par_id3150718" xml-lang="en-US"><ahelp hid="modules/scalc/ui/insertsheet/nameed">Specifies the name of the new sheet.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3150718"><ahelp hid="modules/scalc/ui/insertsheet/nameed">Specifies the name of the new sheet.</ahelp></paragraph>
<embed href="text/scalc/guide/rename_table.xhp#rename_table"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertsheet/fromfile" id="bm_id3150328" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/insertsheet/fromfile" id="bm_id3150328" localize="false"/>
<h2 id="hd_id3155066">From File</h2>
-<paragraph role="paragraph" id="par_id3153714" xml-lang="en-US"><ahelp hid="modules/scalc/ui/insertsheet/fromfile">Inserts a sheet from an existing file into the current document.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertsheet/browse" id="bm_id3150044" localize="false"/>
+<paragraph role="paragraph" id="par_id3153714"><ahelp hid="modules/scalc/ui/insertsheet/fromfile">Inserts a sheet from an existing file into the current document.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/insertsheet/browse" id="bm_id3150044" localize="false"/>
<h3 id="hd_id3149020">Browse</h3>
-<paragraph role="paragraph" id="par_id3159267" xml-lang="en-US"><ahelp hid="modules/scalc/ui/insertsheet/browse">Opens a dialog for selecting a file.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertsheet/tables" id="bm_id3146314" localize="false"/>
+<paragraph role="paragraph" id="par_id3159267"><ahelp hid="modules/scalc/ui/insertsheet/browse">Opens a dialog for selecting a file.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/insertsheet/tables" id="bm_id3146314" localize="false"/>
<h3 id="hd_id3149255">Available Sheets</h3>
-<paragraph role="paragraph" id="par_id3155336" xml-lang="en-US"><ahelp hid="modules/scalc/ui/insertsheet/tables">If you selected a file by using the <emph>Browse</emph> button, the sheets contained in it are displayed in the list box. The file path is displayed below this box. Select the sheet to be inserted from the list box.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertsheet/link" id="bm_id3149814" localize="false"/>
+<paragraph role="paragraph" id="par_id3155336"><ahelp hid="modules/scalc/ui/insertsheet/tables">If you selected a file by using the <emph>Browse</emph> button, the sheets contained in it are displayed in the list box. The file path is displayed below this box. Select the sheet to be inserted from the list box.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/insertsheet/link" id="bm_id3149814" localize="false"/>
<h3 id="hd_id3145791">Link</h3>
-<paragraph role="paragraph" id="par_id3152580" xml-lang="en-US"><ahelp hid="modules/scalc/ui/insertsheet/link">Select to insert the sheet as a link instead as a copy. The links can be updated to show the current contents.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3152580"><ahelp hid="modules/scalc/ui/insertsheet/link">Select to insert the sheet as a link instead as a copy. The links can be updated to show the current contents.</ahelp></paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/05050100.xhp b/source/text/scalc/01/05050100.xhp
index 66f0f14503..52f4d04c20 100644
--- a/source/text/scalc/01/05050100.xhp
+++ b/source/text/scalc/01/05050100.xhp
@@ -22,33 +22,34 @@
<meta>
<topic id="textscalc0105050100xml" indexer="include">
-<title id="tit" xml-lang="en-US">Rename Sheet</title>
+<title id="tit">Rename Sheet</title>
<filename>/text/scalc/01/05050100.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id3147336"><bookmark_value>worksheet names</bookmark_value>
+<bookmark branch="index" id="bm_id3147336"><bookmark_value>worksheet names</bookmark_value>
<bookmark_value>changing; sheet names</bookmark_value>
<bookmark_value>sheets; renaming</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/inputstringdialog/InputStringDialog" id="bm_id3149166" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/inputstringdialog/@@nowidget@@" id="bm_id3149166" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/.uno:Name" id="bm_id3153252" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/.uno:RenameTable" id="bm_id9504501" localize="false"/>
-<h1 id="hd_id3147336">Rename Sheet</h1>
-<paragraph role="paragraph" id="par_id3150792" xml-lang="en-US"><variable id="umbenennentext"><ahelp hid=".uno:RenameTable">This command opens a dialog where you can assign a different name to the current sheet.</ahelp>
-</variable></paragraph>
+<bookmark branch="hid/modules/scalc/ui/inputstringdialog/InputStringDialog" id="bm_id3149166" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/inputstringdialog/@@nowidget@@" id="bm_id3149166" localize="false"/>
+<bookmark branch="hid/.uno:Name" id="bm_id3153252" localize="false"/>
+<bookmark branch="hid/.uno:RenameTable" id="bm_id9504501" localize="false"/>
+<section id="renamesheet">
+<h1 id="hd_id3147336"><variable id="rename_sheet"><link href="text/scalc/01/05050100.xhp#renamesheet">Rename Sheet</link></variable></h1>
+<paragraph role="paragraph" id="par_id3150792"><variable id="umbenennentext"><ahelp hid=".uno:RenameTable">This command opens a dialog where you can assign a different name to the current sheet.</ahelp></variable></paragraph>
+</section>
<section id="howtoget">
<embed href="text/scalc/00/00000405.xhp#fotu"/>
</section>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_SC_RENAME_NAME" id="bm_id3156280" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/inputstringdialog/name_entry" id="bm_id3154908" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_SC_APPEND_NAME" id="bm_id3151041" localize="false"/>
+<bookmark branch="hid/SC_HID_SC_RENAME_NAME" id="bm_id3156280" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/inputstringdialog/name_entry" id="bm_id3154908" localize="false"/>
+<bookmark branch="hid/SC_HID_SC_APPEND_NAME" id="bm_id3151041" localize="false"/>
<h2 id="hd_id3153968">Name</h2>
-<paragraph role="paragraph" id="par_id3155131" xml-lang="en-US"><ahelp hid="HID_SC_APPEND_NAME">Enter a new name for the sheet here.</ahelp></paragraph>
-<paragraph role="tip" id="par_id3153092" xml-lang="en-US">You can also open the<emph> Rename Sheet </emph>dialog through the context menu by positioning the mouse pointer over a sheet tab at the bottom of the window and <switchinline select="sys"><caseinline select="MAC">clicking while pressing Control</caseinline><defaultinline>clicking the right mouse button</defaultinline></switchinline>.</paragraph>
-<paragraph role="tip" id="par_id3147396" xml-lang="en-US">Alternatively, click the sheet tab while pressing the <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Alt</defaultinline></switchinline> key. Now you can change the name directly. <switchinline select="sys"><caseinline select="UNIX"><embedvar href="text/shared/00/00000099.xhp#winmanager"/>
-</caseinline></switchinline></paragraph>
+<paragraph role="paragraph" id="par_id3155131"><ahelp hid="HID_SC_APPEND_NAME">Enter a new name for the sheet here.</ahelp></paragraph>
+<tip id="par_id3153092">You can also open the<emph> Rename Sheet </emph>dialog through the context menu by positioning the mouse pointer over a sheet tab at the bottom of the window and <switchinline select="sys"><caseinline select="MAC">clicking while pressing Control</caseinline><defaultinline>clicking the right mouse button</defaultinline></switchinline>.</tip>
+<tip id="par_id3147396">Alternatively, click the sheet tab while pressing the <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Alt</defaultinline></switchinline> key. Now you can change the name directly. <switchinline select="sys"><caseinline select="UNIX"><embedvar href="text/shared/00/00000099.xhp#winmanager"/>
+</caseinline></switchinline></tip>
<section id="relatedtopics">
<embed href="text/scalc/guide/rename_table.xhp#rename_table"/>
</section>
diff --git a/source/text/scalc/01/05050300.xhp b/source/text/scalc/01/05050300.xhp
index 5f7ba889f7..252d59c32d 100644
--- a/source/text/scalc/01/05050300.xhp
+++ b/source/text/scalc/01/05050300.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,11 +16,10 @@
* 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">
<meta>
<topic id="textscalc0105050300xml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Show Sheet</title>
+<title id="tit">Show Sheet</title>
<filename>/text/scalc/01/05050300.xhp</filename>
</topic>
<history>
@@ -31,17 +28,26 @@
</meta>
<body>
-
- <bookmark branch="index" xml-lang="en-US" id="bm_id3148946"><bookmark_value>sheets; displaying</bookmark_value><bookmark_value>displaying; sheets</bookmark_value></bookmark>
-<bookmark branch="hid/.uno:Show" xml-lang="en-US" id="bm_id3150542" localize="false"/>
-<h1 id="hd_id3148946">Show Sheet</h1>
- <paragraph xml-lang="en-US" role="paragraph" id="par_id3148799"><variable id="tabeintext"><ahelp visibility="visible" hid=".uno:Show">Displays sheets that were previously hidden with the <emph>Hide Sheets</emph> command.</ahelp></variable> Select one sheet only to call the command. The current sheet is always selected. If a sheet other than the current sheet is selected, you can deselect it by pressing <switchinline select="sys"> <caseinline select="MAC">Command</caseinline> <defaultinline>Ctrl</defaultinline> </switchinline> while clicking the corresponding sheet tab at the bottom of the window.</paragraph>
+<bookmark branch="index" id="bm_id3148946">
+<bookmark_value>sheets; displaying</bookmark_value>
+<bookmark_value>displaying; sheets</bookmark_value>
+<bookmark_value>show; hidden sheets</bookmark_value></bookmark>
+<bookmark branch="hid/.uno:Show" id="bm_id3150542" localize="false"/>
+<section id="show_sheet">
+<h1 id="hd_id3148946"><variable id="showsheet"><link href="text/scalc/01/05050300.xhp#show_sheet">Show Sheet</link></variable></h1>
+<paragraph role="paragraph" id="par_id3148799"><variable id="tabeintext"><ahelp visibility="visible" hid=".uno:Show">Displays sheets that were previously hidden with the <emph>Hide Sheets</emph> command.</ahelp></variable></paragraph>
+</section>
+<paragraph role="paragraph" id="par_id261684779287732">Select one sheet only to call the command. The current sheet is always selected. If a sheet other than the current sheet is selected, you can deselect it by pressing <switchinline select="sys"> <caseinline select="MAC"><keycode>Command</keycode></caseinline> <defaultinline><keycode>Ctrl</keycode></defaultinline> </switchinline> while clicking the corresponding sheet tab at the bottom of the window.</paragraph>
<section id="howtoget">
<embed href="text/scalc/00/00000405.xhp#fotenb"/>
</section>
- <bookmark branch="hid/modules/scalc/ui/showsheetdialog/ShowSheetDialog" xml-lang="en-US" id="bm_id3149260" localize="false"/>
- <bookmark branch="hid/modules/scalc/ui/showsheetdialog/@@nowidget@@" xml-lang="en-US" id="bm_id3149260" localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/showsheetdialog/ShowSheetDialog" id="bm_id3149260" localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/showsheetdialog/@@nowidget@@" id="bm_id3149260" localize="false"/>
<h2 id="hd_id3151112">Hidden sheets</h2>
- <paragraph role="paragraph" id="par_id3145273" xml-lang="en-US"><ahelp hid="modules/scalc/ui/showsheetdialog/ShowSheetDialog" visibility="visible">Displays a list of all hidden sheets in your spreadsheet document.</ahelp> To show a certain sheet, click the corresponding entry on the list and confirm with OK.</paragraph>
+ <paragraph role="paragraph" id="par_id3145273"><ahelp hid="modules/scalc/ui/showsheetdialog/ShowSheetDialog" visibility="visible">Displays a list of all hidden sheets in your spreadsheet document.</ahelp> To show a certain sheet, click the corresponding entry on the list and confirm with OK.</paragraph>
+
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id241684781496470" localize="false"><embedvar href="text/scalc/01/hide_sheet.xhp#h1" markup="ignore"/></paragraph>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/06060100.xhp b/source/text/scalc/01/06060100.xhp
index ef01d741be..ab6607eea2 100644
--- a/source/text/scalc/01/06060100.xhp
+++ b/source/text/scalc/01/06060100.xhp
@@ -39,8 +39,10 @@
<bookmark_value>protect;sheet</bookmark_value>
<bookmark_value>selection;in protected cells</bookmark_value>
</bookmark>
-<h1 id="hd_id3153087"><variable id="ProtectingSheeth1"><link href="text/scalc/01/06060100.xhp">Protecting Sheet</link></variable></h1>
+<section id="protect_sheet">
+ <h1 id="hd_id3153087"><variable id="ProtectingSheeth1"><link href="text/scalc/01/06060100.xhp">Protect Sheet</link></variable></h1>
<paragraph role="paragraph" id="par_id3148664" xml-lang="en-US"><variable id="tabelletext"><ahelp hid=".uno:Protect">Protects the cells in the current sheet from being modified.</ahelp></variable></paragraph>
+</section>
<paragraph role="paragraph" id="par_id701619429750616">Choose <emph>Tools - Protect Sheet</emph> to open the <emph>Protect Sheet</emph> dialog in which you then specify sheet protection with or without a password, and select the elements of the sheet to protect.</paragraph>
<section id="howtoget">
<embed href="text/scalc/00/00000406.xhp#protect_sheet"/>
diff --git a/source/text/scalc/01/duplicate_sheet.xhp b/source/text/scalc/01/duplicate_sheet.xhp
new file mode 100644
index 0000000000..2119a52a58
--- /dev/null
+++ b/source/text/scalc/01/duplicate_sheet.xhp
@@ -0,0 +1,34 @@
+<?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="duplicatesheet" indexer="include" status="PUBLISH">
+ <title id="tit">Duplicate sheet</title>
+ <filename>/text/scalc/01/duplicate_sheet.xhp</filename>
+ </topic>
+</meta>
+<body>
+<bookmark xml-lang="en-US" branch="index" id="bm_id781684770157606">
+<bookmark_value>sheet;duplicate</bookmark_value>
+<bookmark_value>duplicate;sheet</bookmark_value>
+</bookmark>
+<section id="duplicatesheet">
+ <bookmark id="bm_id51684769648614" branch="hid/.uno:DuplicateSheet" localize="false"/>
+ <h1 id="hd_id441684769648615"><variable id="h1"><link href="text/scalc/01/duplicate_sheet.xhp">Duplicate Sheet</link></variable></h1>
+ <paragraph id="par_id211684769648616" role="paragraph">Duplicates the selected sheet assigning a new name.</paragraph>
+</section>
+<section id="howtoget">
+ <embed href="text/scalc/00/sheet_menu.xhp#duplicate_sheet"/>
+ <paragraph role="paragraph" id="par_id331684771749534">Open the context menu of the sheet tab, choose <menuitem>Duplicate Sheet</menuitem>.</paragraph>
+</section>
+<paragraph role="paragraph" id="par_id871684769820620">The duplicated sheet inherits the name of the source sheet followed by an underscore character (_) and a number. The new name is unique within the spreadsheet document.</paragraph>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/hide_sheet.xhp b/source/text/scalc/01/hide_sheet.xhp
new file mode 100644
index 0000000000..59cda24f8a
--- /dev/null
+++ b/source/text/scalc/01/hide_sheet.xhp
@@ -0,0 +1,37 @@
+<?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="hidesheet" indexer="include" status="PUBLISH">
+ <title id="tit">Hide Sheet</title>
+ <filename>/text/scalc/01/hide_sheet.xhp</filename>
+ </topic>
+</meta>
+<body>
+<bookmark xml-lang="en-US" branch="index" id="bm_id571684781225345">
+<bookmark_value>sheet;hidding</bookmark_value>
+<bookmark_value>hidden;sheet</bookmark_value>
+</bookmark>
+<section id="hide_sheet">
+ <bookmark id="bm_id801684779805304" branch="hid/.uno:Hide" localize="false"/>
+ <h1 id="hd_id71684779805305"><variable id="h1"><link href="text/scalc/01/hide_sheet.xhp">Hide Sheet</link></variable></h1>
+ <paragraph id="par_id911684779805308" role="paragraph">Hides the sheet.</paragraph>
+ </section>
+ <section id="howtoget">
+ <embed href="text/scalc/00/sheet_menu.xhp#hidesheet"/>
+ </section>
+ <paragraph role="paragraph" id="par_id651684780971395">The sheet is not visible in the workspace but it is still in the document. All references to hidden sheet contents are valid.</paragraph>
+ <paragraph role="paragraph" id="par_id781684780979739">The hidden sheet does not show in the sheet navigation bar on the bottom of the screen. However the hidden sheets are listed in the Navigator sidebar under <emph>Sheets</emph> category. Double clicking on a hidden sheet from the Navigator sidebar position the viewing on the first sheet visible on the right.</paragraph>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id881684781435572" localize="false"><embedvar href="text/scalc/01/05050300.xhp#showsheet" markup="ignore"/></paragraph>
+ </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/sheet_tab_color.xhp b/source/text/scalc/01/sheet_tab_color.xhp
new file mode 100644
index 0000000000..32afbe9eea
--- /dev/null
+++ b/source/text/scalc/01/sheet_tab_color.xhp
@@ -0,0 +1,31 @@
+<?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="sheettabcolor" indexer="include" status="PUBLISH">
+ <title id="tit">Sheet Tab Color</title>
+ <filename>/text/scalc/01/sheet_tab_color.xhp</filename>
+ </topic>
+</meta>
+<body>
+<bookmark branch="hid/FID_TAB_MENU_SET_TAB_BG_COLOR" id="bm_id906582434" localize="false"/>
+<bookmark branch="hid/FID_TAB_SET_TAB_BG_COLOR" id="bm_id9016345434" localize="false"/>
+<bookmark id="bm_id651684777219481" branch="hid/.uno:SetTabBgColor" localize="false"/>
+<section id="sheet_tab_color">
+ <h1 id="hd_id481684777219483"><variable id="h1"><link href="text/scalc/01/sheet_tab_color.xhp">Sheet Tab Color</link></variable></h1>
+ <paragraph id="par_id05092009140203523" role="paragraph">Opens a color selector window where you can assign a color to the sheet tab.</paragraph>
+</section>
+ <section id="howtoget">
+ <embed href="text/scalc/00/sheet_menu.xhp#sheettabcolor"/>
+ <paragraph role="paragraph" id="par_id471684778391051">Open the context menu of the sheet tab, choose <menuitem>Tab Color</menuitem>.</paragraph>
+ </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/guide/multitables.xhp b/source/text/scalc/guide/multitables.xhp
index 4bc09eccee..50a2b58238 100644
--- a/source/text/scalc/guide/multitables.xhp
+++ b/source/text/scalc/guide/multitables.xhp
@@ -27,25 +27,18 @@
</topic>
</meta>
<body>
-<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>
- <bookmark_value>selecting;multiple sheets</bookmark_value>
- <bookmark_value>multiple sheets</bookmark_value>
- <bookmark_value>calculating;multiple sheets</bookmark_value>
+<bookmark branch="index" id="bm_id3154759">
+<bookmark_value>sheets; selecting multiple</bookmark_value>
+<bookmark_value>appending sheets</bookmark_value>
+<bookmark_value>selecting;multiple sheets</bookmark_value>
+<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>
<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>
- <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 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 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 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"/>
diff --git a/source/text/scalc/main0103.xhp b/source/text/scalc/main0103.xhp
index ab460a9992..3d0093ca4f 100644
--- a/source/text/scalc/main0103.xhp
+++ b/source/text/scalc/main0103.xhp
@@ -43,8 +43,11 @@
<embed href="text/shared/01/03060000.xhp#status_bar"/>
<embed href="text/scalc/01/03070000.xhp#column_and_row_headers"/>
+<section id="view_grid_lines">
<h2 id="hd_id10272015110909623">View Grid lines</h2>
<paragraph id="par_id102720151147483554" role="paragraph" xml-lang="en-US">Toggle the visibility of grid lines for the current sheet.</paragraph>
+</section>
+
<embed href="text/shared/01/grid_and_helplines.xhp#grid_and_help_lines"/>
<embed href="text/scalc/01/03080000.xhp#value_highlighting"/>
diff --git a/source/text/scalc/main0116.xhp b/source/text/scalc/main0116.xhp
index 8a886a0da7..cfcfc4f61c 100644
--- a/source/text/scalc/main0116.xhp
+++ b/source/text/scalc/main0116.xhp
@@ -19,7 +19,7 @@
-->
<meta>
- <topic id="textscalcmain0116xml">
+ <topic id="textscalcmain0116xml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Sheet</title>
<filename>/text/scalc/main0116.xhp</filename>
</topic>
@@ -27,7 +27,6 @@
<body>
-
<section id="sheet">
<bookmark xml-lang="en-US" branch="hid/.uno:SheetMenu" id="bm_id0906201507425254" localize="false"/>
@@ -54,8 +53,7 @@
<h2 id="hd_id3163708"><link href="text/scalc/01/02170000.xhp">Delete Sheet</link></h2>
<embed href="text/scalc/01/02170000.xhp#tabelleloeschentext"/>
-<h2 id="hd_id3163735308">Sheet Tab Color</h2>
-<embed href="text/scalc/guide/multitables.xhp#sheettabcolor"/>
+<embed href="text/scalc/01/sheet_tab_color.xhp#sheet_tab_color"/>
<h2 id="hd_id3163733308"><link href="text/shared/01/06140500.xhp">Sheet Events</link></h2>
<embed href="text/shared/01/06140500.xhp#assignaction"/>
diff --git a/source/text/shared/01/02090000.xhp b/source/text/shared/01/02090000.xhp
index c513013440..f00f3e14e1 100644
--- a/source/text/shared/01/02090000.xhp
+++ b/source/text/shared/01/02090000.xhp
@@ -39,6 +39,6 @@
<embed href="text/shared/00/edit_menu.xhp#select_all"/>
</section>
<bookmark xml-lang="en-US" branch="hid/.uno:TableSelectAll" id="bm_id4889160" localize="false"/>
-<paragraph role="paragraph" id="par_id3154046" xml-lang="en-US"><switchinline select="appl"><caseinline select="CALC">To select all of the sheets in a spreadsheet file, right-click the name tab of a sheet, and then choose <emph>Select All Sheets</emph>. <ahelp hid=".uno:TableSelectAll" visibility="hidden">Selects all of the sheets in the current spreadsheet.</ahelp></caseinline><defaultinline></defaultinline></switchinline></paragraph>
+<paragraph role="paragraph" id="par_id3154046" xml-lang="en-US"><switchinline select="appl"><caseinline select="CALC">To select all of the sheets in a spreadsheet file, right-click the name tab of a sheet, and then choose <emph>Select All Sheets</emph>.</caseinline><defaultinline></defaultinline></switchinline></paragraph>
</body>
</helpdocument>