summaryrefslogtreecommitdiff
path: root/source/text/scalc
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2023-05-24 18:20:56 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2023-05-25 16:47:12 +0200
commit31fe3777cb0dc69a3badc026f4de55c096af48d9 (patch)
tree848e4990610268dcbf30f73f9da28fdf422a1846 /source/text/scalc
parentc26935e97327fd87907d41dd07f60bdf71ef8067 (diff)
tdf#154996 Add tabbed UI commands in Help page
+ refactoring Change-Id: I404321de45f8d4c4621a64d2f30a48421f65f86e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/152249 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc')
-rw-r--r--source/text/scalc/00/00000402.xhp9
-rw-r--r--source/text/scalc/00/00000404.xhp2
-rw-r--r--source/text/scalc/00/00000405.xhp2
-rw-r--r--source/text/scalc/00/sheet_menu.xhp163
-rw-r--r--source/text/scalc/01/02170000.xhp10
-rw-r--r--source/text/scalc/01/02180000.xhp2
-rw-r--r--source/text/scalc/01/04050000.xhp2
-rw-r--r--source/text/scalc/01/05050100.xhp5
-rw-r--r--source/text/scalc/01/06060100.xhp48
-rw-r--r--source/text/scalc/01/duplicate_sheet.xhp5
-rw-r--r--source/text/scalc/01/sheet_tab_color.xhp2
11 files changed, 194 insertions, 56 deletions
diff --git a/source/text/scalc/00/00000402.xhp b/source/text/scalc/00/00000402.xhp
index dba59f6f34..302ee6a74e 100644
--- a/source/text/scalc/00/00000402.xhp
+++ b/source/text/scalc/00/00000402.xhp
@@ -42,15 +42,6 @@
</section>
<paragraph id="par_id3150011" role="paragraph" xml-lang="en-US"><variable id="bzelo">Choose <emph>Sheet - Delete Cells</emph>.</variable></paragraph>
-<section id="delete_sheet">
-<paragraph id="par_id3153951" role="paragraph" xml-lang="en-US">Choose <emph>Sheet - Delete Sheet</emph>.</paragraph>
-<paragraph id="par_id3155306" role="paragraph" xml-lang="en-US">Open context menu for a sheet tab.</paragraph>
-</section>
-
-<section id="move_or_copy_sheet">
-<paragraph id="par_id3146119" role="paragraph" xml-lang="en-US">Choose <emph>Sheet - Move or Copy Sheet</emph>.</paragraph>
-<paragraph id="par_id3148645" role="paragraph" xml-lang="en-US">Open context menu for a sheet tab.</paragraph>
-</section>
<section id="cellprotection">
<paragraph role="paragraph" id="par_id831619443265443">Choose <menuitem>Edit - Cell Protection</menuitem> to activate sheet protection with current cell protection settings.</paragraph>
</section>
diff --git a/source/text/scalc/00/00000404.xhp b/source/text/scalc/00/00000404.xhp
index d9873d31cc..acb8018706 100644
--- a/source/text/scalc/00/00000404.xhp
+++ b/source/text/scalc/00/00000404.xhp
@@ -101,9 +101,7 @@
</tablecell>
</tablerow>
</table>
-
</section>
-<paragraph role="paragraph" id="par_id3149033" xml-lang="en-US"><variable id="eitab">Choose <menuitem>Sheet - Insert Sheet</menuitem>.</variable></paragraph>
<paragraph role="paragraph" id="par_idN1082F" xml-lang="en-US"><variable id="eitabfile">Choose <menuitem>Sheet - Insert Sheet from File</menuitem>.</variable></paragraph>
<section id="insert_function">
<paragraph role="paragraph" id="par_id3155115" xml-lang="en-US">Choose <menuitem>Insert - Function</menuitem>.</paragraph>
diff --git a/source/text/scalc/00/00000405.xhp b/source/text/scalc/00/00000405.xhp
index 127c8be0c9..cf3956717f 100644
--- a/source/text/scalc/00/00000405.xhp
+++ b/source/text/scalc/00/00000405.xhp
@@ -51,7 +51,7 @@
<paragraph role="paragraph" id="par_id3146971" xml-lang="en-US">Double-click right column separator in column headers.</paragraph>
</section>
<paragraph role="paragraph" id="par_id3147362" xml-lang="en-US"><variable id="fot">Choose <emph>Sheet</emph>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3163805" xml-lang="en-US"><variable id="fotu">Choose <emph>Sheet - Rename Sheet</emph>.</variable></paragraph>
+
<paragraph role="paragraph" id="par_idN1077A" xml-lang="en-US"><variable id="foste">Choose <emph>Format - Page Style</emph>.</variable></paragraph>
<paragraph role="paragraph" id="par_id3155508" xml-lang="en-US"><variable id="fostel">Choose <emph>Format - Page Style - Sheet</emph> tab.</variable></paragraph>
diff --git a/source/text/scalc/00/sheet_menu.xhp b/source/text/scalc/00/sheet_menu.xhp
index a658acffda..baafdb1132 100644
--- a/source/text/scalc/00/sheet_menu.xhp
+++ b/source/text/scalc/00/sheet_menu.xhp
@@ -29,10 +29,10 @@
<comment>Hide sheet</comment>
<section id="hidesheet">
- <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
- <paragraph role="paragraph" id="par_id131684935639912">Choose <menuitem>Layout - Hide Sheet</menuitem>.</paragraph>
<embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
<paragraph role="paragraph" id="par_id261634778277541">Choose <menuitem>Sheet - Hide Sheet</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id131684935639912">Choose <menuitem>Layout - Hide Sheet</menuitem>.</paragraph>
<embed href="text/shared/00/00000004.xhp#from_sheet_bar"/>
<paragraph role="paragraph" id="par_id301684935381277">Choose <menuitem>Hide Sheet</menuitem>.</paragraph>
<embed href="text/shared/00/00000004.xhp#from_toolbars"/>
@@ -52,10 +52,10 @@
<comment>Show sheet</comment>
<section id="showsheet">
- <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
- <paragraph role="paragraph" id="par_id411684944573183">Choose <menuitem>Layout - Show Sheet</menuitem>.</paragraph>
<embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
<paragraph role="paragraph" id="par_id451634778277541">Choose <menuitem>Sheet - Show Sheet</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id411684944573183">Choose <menuitem>Layout - Show Sheet</menuitem>.</paragraph>
<embed href="text/shared/00/00000004.xhp#from_sheet_bar"/>
<paragraph role="paragraph" id="par_id305684935381277">Choose <menuitem>Show Sheet</menuitem>.</paragraph>
<embed href="text/shared/00/00000004.xhp#from_toolbars"/>
@@ -73,8 +73,159 @@
</table>
</section>
-<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>
+<comment>Duplicate sheet</comment>
+<section id="duplicatesheet">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id541684770785578">Choose <menuitem>Sheet - Duplicate Sheet</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_sheet_bar"/>
+ <paragraph role="paragraph" id="par_id211684946107120">Choose <menuitem>Duplicate Sheet</menuitem></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id821684946262278">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id961684946262279" role="paragraph">
+ <image src="cmd/lc_duplicatesheet.svg" id="img_id881684946262280" width="1cm" height="1cm"><alt id="alt_id271684946262282">Icon Duplicate Sheet</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id201684946262283" role="paragraph">Duplicate Sheet</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+
+<comment>Sheet Tab Color</comment>
+<section id="sheettabcolor">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id261684778277541">Choose <menuitem>Sheet - Sheet Tab Color</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_sheet_bar"/>
+ <paragraph role="paragraph" id="par_id111684946822769">Choose <menuitem>Tab Color</menuitem></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id511684946976191">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id21684946976192" role="paragraph">
+ <image src="cmd/lc_backgroundcolor.svg" id="img_id441684946976193" width="1cm" height="1cm"><alt id="alt_id191684946976194">Icon Sheet Tab Color</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id191684946976196" role="paragraph">Sheet Tab Color</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+
+<comment>Rename sheet</comment>
+<section id="renamesheet">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3163805">Choose <emph>Sheet - Rename Sheet</emph>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id911684944573183">Choose <menuitem>Layout - Rename Sheet</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_sheet_bar"/>
+ <paragraph role="paragraph" id="par_id911684946107120">Choose <menuitem>Rename Sheet</menuitem></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id491684949102500">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id661684949102501" role="paragraph">
+ <image src="cmd/lc_name.svg" id="img_id71684949102502" width="1cm" height="1cm"><alt id="alt_id11684949102503">Icon Rename Sheet</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id931684949102505" role="paragraph">Rename Sheet</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+
+<comment>Delete sheet</comment>
+<section id="delete_sheet">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id3153951" role="paragraph">Choose <menuitem>Sheet - Delete Sheet</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_sheet_bar"/>
+ <paragraph id="par_id3155306" role="paragraph">Choose <menuitem>Delete Sheet</menuitem></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id281684956263161">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id41684956263162" role="paragraph">
+ <image src="cmd/lc_remove.svg" id="img_id191684956263163" width="1cm" height="1cm"><alt id="alt_id931684956263164">Icon Delete Sheet</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id491684956263166" role="paragraph">Delete Sheet</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+
+<comment>Insert sheet</comment>
+<section id="insert_sheet">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3149033">Choose <menuitem>Sheet - Insert Sheet</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id691684958427498">Choose <menuitem>Layout - Insert Sheet</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id691684958427400">Choose <menuitem>Insert - Insert Sheet</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_sheet_bar"/>
+ <paragraph role="paragraph" id="par_id501684958243009">Choose <menuitem>Insert Sheet</menuitem></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id301684958301647">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id691684958301648" role="paragraph">
+ <image src="cmd/lc_insert.svg" id="img_id61684958301649" width="1cm" height="1cm"><alt id="alt_id961684958301649">Icon Insert Sheet</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id131684958301651" role="paragraph">Insert Sheet</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+<comment>Move or copy sheet</comment>
+
+<section id="move_or_copy_sheet">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+<paragraph id="par_id3146119" role="paragraph">Choose <emph>Sheet - Move or Copy Sheet</emph>.</paragraph>
+<embed href="text/shared/00/00000004.xhp#from_sheet_bar"/>
+<paragraph id="par_id3148645" role="paragraph">Choose <menuitem>Move or Copy Sheet</menuitem>.</paragraph>
+<embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+<table id="tab_id231684960629380">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id481684960629381" role="paragraph">
+ <image src="cmd/lc_move.svg" id="img_id641684960629382" width="1cm" height="1cm"><alt id="alt_id481684960629383">Icon Move or Copy Sheet</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id191684960629385" role="paragraph">Move or Copy Sheet</paragraph>
+ </tablecell>
+ </tablerow>
+</table>
+</section>
+
+<comment>cell protection</comment>
+<section id="protect_sheet">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id3149020" role="paragraph">Choose <menuitem>Tools - Protect Sheet</menuitem>.</paragraph>
+<embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+<paragraph role="paragraph" id="par_id561684962038778">Choose <menuitem>Review - Cell Protection</menuitem></paragraph>
+<embed href="text/shared/00/00000004.xhp#from_sheet_bar"/>
+<paragraph role="paragraph" id="par_id191684962104122">Choose <menuitem>Protect Sheet</menuitem>.</paragraph>
+<embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+<table id="tab_id551684962135184">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id461684962135185" role="paragraph">
+ <image src="cmd/lc_protect.svg" id="img_id891684962135186" width="1cm" height="1cm"><alt id="alt_id291684962135187">Icon Protect Sheet</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id611684962135188" role="paragraph">Protect Sheet</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
<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>
diff --git a/source/text/scalc/01/02170000.xhp b/source/text/scalc/01/02170000.xhp
index 229c85636d..97269fd6c0 100644
--- a/source/text/scalc/01/02170000.xhp
+++ b/source/text/scalc/01/02170000.xhp
@@ -34,15 +34,13 @@
<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>
+<paragraph role="paragraph" id="par_id3153193"><variable id="tabelleloeschentext"><ahelp hid=".uno:Remove">Deletes the current sheet or selected sheets.</ahelp></variable></paragraph>
</section>
<section id="howtoget">
- <embed href="text/scalc/00/00000402.xhp#delete_sheet"/>
+ <embed href="text/scalc/00/sheet_menu.xhp#delete_sheet"/>
</section>
<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">Deletes the current sheet.</paragraph>
-<h2 id="hd_id3149412">No</h2>
-<paragraph role="paragraph" id="par_id3154510">Cancels the dialog. No delete is performed.</paragraph>
+<paragraph role="paragraph" id="par_id921684957633412">You cannot delete all the sheets of the document. The document must have at least one sheet.</paragraph>
+<paragraph role="paragraph" id="par_id691684957638352">A dialog prompts to confirm deletion.</paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/02180000.xhp b/source/text/scalc/01/02180000.xhp
index 50f0ce8b54..231fabe2c2 100644
--- a/source/text/scalc/01/02180000.xhp
+++ b/source/text/scalc/01/02180000.xhp
@@ -43,7 +43,7 @@
<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"/>
+ <embed href="text/scalc/00/sheet_menu.xhp#move_or_copy_sheet"/>
</section>
<paragraph role="warning" id="par_id2282479" xml-lang="en-US">When you copy and paste cells containing <link href="text/scalc/01/04060102.xhp">date values</link> between different spreadsheets, both spreadsheet documents must be set to the same date base. If date bases differ, the displayed date values will change!</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/movecopysheet/toDocument" id="bm_id3146119" localize="false"/>
diff --git a/source/text/scalc/01/04050000.xhp b/source/text/scalc/01/04050000.xhp
index e6fb273fdb..6d7cdc4a36 100644
--- a/source/text/scalc/01/04050000.xhp
+++ b/source/text/scalc/01/04050000.xhp
@@ -39,7 +39,7 @@
<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"/>
+<embed href="text/scalc/00/sheet_menu.xhp#insert_sheet"/>
</section>
<h2 id="hd_id3154684">Position</h2>
<paragraph role="paragraph" id="par_id3156281">Specifies where the new sheet is to be inserted into your document.</paragraph>
diff --git a/source/text/scalc/01/05050100.xhp b/source/text/scalc/01/05050100.xhp
index 52f4d04c20..a5ca79f12d 100644
--- a/source/text/scalc/01/05050100.xhp
+++ b/source/text/scalc/01/05050100.xhp
@@ -27,7 +27,8 @@
</topic>
</meta>
<body>
-<bookmark 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>
@@ -40,7 +41,7 @@
<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"/>
+<embed href="text/scalc/00/sheet_menu.xhp#renamesheet"/>
</section>
<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"/>
diff --git a/source/text/scalc/01/06060100.xhp b/source/text/scalc/01/06060100.xhp
index ab6607eea2..0e39d0d27e 100644
--- a/source/text/scalc/01/06060100.xhp
+++ b/source/text/scalc/01/06060100.xhp
@@ -19,15 +19,15 @@
<helpdocument version="1.0">
<meta>
<topic id="textscalc0106060100xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Protecting Sheet</title>
+<title id="tit">Protecting Sheet</title>
<filename>/text/scalc/01/06060100.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/protectsheetdlg/ProtectSheetDialog" id="bm_id3148919" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/protectsheetdlg/@@nowidget@@" id="bm_id3148919" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/.uno:Protect" id="bm_id3156326" localize="false"/>
-<bookmark xml-lang="en-US" branch="index" id="bm_id141619439455954">
+<bookmark branch="hid/modules/scalc/ui/protectsheetdlg/ProtectSheetDialog" id="bm_id3148919" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/protectsheetdlg/@@nowidget@@" id="bm_id3148919" localize="false"/>
+<bookmark branch="hid/.uno:Protect" id="bm_id3156326" localize="false"/>
+<bookmark branch="index" id="bm_id141619439455954">
<bookmark_value>insert rows;protected sheet</bookmark_value>
<bookmark_value>insert columns;protected sheet</bookmark_value>
<bookmark_value>delete columns;protected sheet</bookmark_value>
@@ -41,11 +41,11 @@
</bookmark>
<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>
+<paragraph role="paragraph" id="par_id3148664"><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"/>
+ <embed href="text/scalc/00/sheet_menu.xhp#protect_sheet"/>
<embed href="text/scalc/00/00000402.xhp#cellprotection"/>
</section>
<warning id="par_id3149664">To protect cells from further editing, the <emph>Protected</emph> check box must be checked on the <link href="text/scalc/01/05020600.xhp"><emph>Format - Cells - Cell Protection</emph></link> tab page or on the <emph>Format Cells</emph> context menu.</warning>
@@ -58,54 +58,54 @@
<paragraph role="paragraph" id="par_id41619431361278">Select the elements to protect from user actions:</paragraph>
<list type="unordered">
<listitem>
- <paragraph id="par_id661619430257262" role="listitem"><emph>Select protected cells</emph>: mark this checkbox to allow you to select protected cells. When the checkbox is unmarked, you cannot select protected cells, the cursor cannot enter in a protected range.</paragraph>
+ <paragraph id="par_id661619430257262" role="listitem"><emph>Select protected cells</emph>: mark this checkbox to allow you to select protected cells. When the checkbox is unmarked, you cannot select protected cells, the cursor cannot enter in a protected range.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id921619430295947" role="listitem"><emph>Select unprotected cells</emph>: mark this checkbox to allow user to select unprotected cells. When the checkbox is unmarked, user cannot select unprotected cells, the cursor cannot enter in a unprotected cell or range.</paragraph>
+ <paragraph id="par_id921619430295947" role="listitem"><emph>Select unprotected cells</emph>: mark this checkbox to allow user to select unprotected cells. When the checkbox is unmarked, user cannot select unprotected cells, the cursor cannot enter in a unprotected cell or range.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id101619430333784" role="listitem"><emph>Insert columns</emph>: Allow column insertions even when the sheet is protected. Note that when column insertions is enabled, you can insert columns even when the range to insert the new columns into contains protected cells which will get shifted after the insertion. Cells of the newly inserted columns inherit the Protection property of the range it belongs: when the new cell is inside a protected range, the cell is protected, and when it is in an unprotected range, the cell is unprotected.</paragraph>
+ <paragraph id="par_id101619430333784" role="listitem"><emph>Insert columns</emph>: Allow column insertions even when the sheet is protected. Note that when column insertions is enabled, you can insert columns even when the range to insert the new columns into contains protected cells which will get shifted after the insertion. Cells of the newly inserted columns inherit the Protection property of the range it belongs: when the new cell is inside a protected range, the cell is protected, and when it is in an unprotected range, the cell is unprotected.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id891619430338809" role="listitem"><emph>Insert rows</emph>: Allow row insertions even when the sheet is protected. Note that when row insertions is enabled, you can insert rows even when the range to insert the new rows into contains protected cells which will get shifted after the insertion. Cells of the newly inserted rows inherit the Protection property of the range it belongs: when the new cell is inside a protected range it is protected, and when it is in an unprotected range, the cell is unprotected.</paragraph>
+ <paragraph id="par_id891619430338809" role="listitem"><emph>Insert rows</emph>: Allow row insertions even when the sheet is protected. Note that when row insertions is enabled, you can insert rows even when the range to insert the new rows into contains protected cells which will get shifted after the insertion. Cells of the newly inserted rows inherit the Protection property of the range it belongs: when the new cell is inside a protected range it is protected, and when it is in an unprotected range, the cell is unprotected.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id311619430374686" role="listitem"><emph>Delete columns</emph>: Allow column deletions. Note that column deletions are only allowed on unprotected cells.
+ <paragraph id="par_id311619430374686" role="listitem"><emph>Delete columns</emph>: Allow column deletions. Note that column deletions are only allowed on unprotected cells.
</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id561619430376854" role="listitem"><emph>Delete rows</emph>: Allow row deletions. Note that row deletions are only allowed on unprotected cells.
+ <paragraph id="par_id561619430376854" role="listitem"><emph>Delete rows</emph>: Allow row deletions. Note that row deletions are only allowed on unprotected cells.
</paragraph>
</listitem>
</list>
<paragraph role="paragraph" id="par_id3154490">Unprotected cells or cell ranges can be set up on a protected sheet by using the <emph>Tools - Protect Sheet</emph> and <emph>Format - Cells - Cell Protection</emph> menus: </paragraph>
<list type="ordered">
<listitem>
-<paragraph role="paragraph" id="par_id3149123" xml-lang="en-US">Select the cells that will be unprotected</paragraph>
+<paragraph role="paragraph" id="par_id3149123">Select the cells that will be unprotected</paragraph>
</listitem>
<listitem>
-<paragraph role="paragraph" id="par_id3150329" xml-lang="en-US">Select <emph>Format - Cells - Cell Protection</emph>. Unmark the <emph>Protected</emph> box and click <emph>OK</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3150329">Select <emph>Format - Cells - Cell Protection</emph>. Unmark the <emph>Protected</emph> box and click <emph>OK</emph>.</paragraph>
</listitem>
<listitem>
- <paragraph role="paragraph" id="par_id3156384" xml-lang="en-US">On the <emph>Tools - Protect Sheet</emph> menu, activate protection for the sheet. Effective immediately, only the cell range you selected in step 1 can be edited.</paragraph>
+ <paragraph role="paragraph" id="par_id3156384">On the <emph>Tools - Protect Sheet</emph> menu, activate protection for the sheet. Effective immediately, only the cell range you selected in step 1 can be edited.</paragraph>
</listitem>
</list>
-<paragraph role="paragraph" id="par_id3149566" xml-lang="en-US">To later change an unprotected area to a protected area:</paragraph>
+<paragraph role="paragraph" id="par_id3149566">To later change an unprotected area to a protected area:</paragraph>
<list type="ordered">
<listitem>
- <paragraph id="par_id101619439013221" role="listitem">Select the range of cells that will be protected.</paragraph>
+ <paragraph id="par_id101619439013221" role="listitem">Select the range of cells that will be protected.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id601619439028536" role="listitem">On the <menuitem>Format - Cells - Cell Protection</menuitem> tab page, check the <emph>Protected</emph> box. </paragraph>
+ <paragraph id="par_id601619439028536" role="listitem">On the <menuitem>Format - Cells - Cell Protection</menuitem> tab page, check the <emph>Protected</emph> box. </paragraph>
</listitem>
<listitem>
- <paragraph id="par_id641619439061892" role="listitem">Choose the <menuitem>Tools - Protect Sheet</menuitem> menu. The previously editable range is now protected.</paragraph>
+ <paragraph id="par_id641619439061892" role="listitem">Choose the <menuitem>Tools - Protect Sheet</menuitem> menu. The previously editable range is now protected.</paragraph>
</listitem>
</list>
-<paragraph role="paragraph" id="par_id3153964" xml-lang="en-US">Sheet protection also affects the context menu of the sheet tabs at the bottom of the screen. The <emph>Delete</emph> and <emph>Rename</emph> commands cannot be selected.</paragraph>
-<paragraph role="paragraph" id="par_id3150301" xml-lang="en-US">If a sheet is protected, you will not be able to modify or delete any Cell Styles.</paragraph>
-<paragraph role="paragraph" id="par_id3154656" xml-lang="en-US">A protected sheet or cell range can no longer be modified until this protection is disabled, with the exceptions of the settings for columns and row of the <menuitem>Tools - Protect Sheet</menuitem> dialog. To disable the protection, choose the <menuitem>Tools - Protect Sheet</menuitem> command. If no password was set, the sheet protection is immediately disabled. If the sheet was password protected, the <emph>Remove Protection</emph> dialog opens, where you must enter the password.</paragraph>
-<paragraph role="paragraph" id="par_id3149815" xml-lang="en-US">Once saved, protected sheets can only be saved again by using the <emph>File - Save As</emph> command.</paragraph>
+<paragraph role="paragraph" id="par_id3153964">Sheet protection also affects the context menu of the sheet tabs at the bottom of the screen. The <emph>Delete</emph> and <emph>Rename</emph> commands cannot be selected.</paragraph>
+<paragraph role="paragraph" id="par_id3150301">If a sheet is protected, you will not be able to modify or delete any Cell Styles.</paragraph>
+<paragraph role="paragraph" id="par_id3154656">A protected sheet or cell range can no longer be modified until this protection is disabled, with the exceptions of the settings for columns and row of the <menuitem>Tools - Protect Sheet</menuitem> dialog. To disable the protection, choose the <menuitem>Tools - Protect Sheet</menuitem> command. If no password was set, the sheet protection is immediately disabled. If the sheet was password protected, the <emph>Remove Protection</emph> dialog opens, where you must enter the password.</paragraph>
+<paragraph role="paragraph" id="par_id3149815">Once saved, protected sheets can only be saved again by using the <emph>File - Save As</emph> command.</paragraph>
<note id="par_id3148700">Complete protection of your work can be achieved by combining the options <emph>Tools - Protect Sheet</emph> and <emph>Tools - Protect Spreadsheet Structure</emph>, including password protection. To prohibit opening the document altogether, in the <emph>Save</emph> dialog mark the <emph>Save with password</emph> box before you click the <emph>Save</emph> button.</note>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/duplicate_sheet.xhp b/source/text/scalc/01/duplicate_sheet.xhp
index 2119a52a58..5150d19835 100644
--- a/source/text/scalc/01/duplicate_sheet.xhp
+++ b/source/text/scalc/01/duplicate_sheet.xhp
@@ -16,7 +16,7 @@
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id781684770157606">
+<bookmark branch="index" id="bm_id781684770157606">
<bookmark_value>sheet;duplicate</bookmark_value>
<bookmark_value>duplicate;sheet</bookmark_value>
</bookmark>
@@ -26,8 +26,7 @@
<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>
+ <embed href="text/scalc/00/sheet_menu.xhp#duplicatesheet"/>
</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>
diff --git a/source/text/scalc/01/sheet_tab_color.xhp b/source/text/scalc/01/sheet_tab_color.xhp
index 32afbe9eea..5d00e2f081 100644
--- a/source/text/scalc/01/sheet_tab_color.xhp
+++ b/source/text/scalc/01/sheet_tab_color.xhp
@@ -18,6 +18,7 @@
<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 branch="hid/.uno:TabBgColor" id="bm_id241684947541204" 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>
@@ -25,7 +26,6 @@
</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>