source/text/scalc/00/00000402.xhp | 9 -
source/text/scalc/00/00000404.xhp | 2
source/text/scalc/00/00000405.xhp | 4
source/text/scalc/00/sheet_menu.xhp | 205 ++++++++++++++++++++++++++++++-
source/text/scalc/01/02170000.xhp | 10 -
source/text/scalc/01/02180000.xhp | 2
source/text/scalc/01/04050000.xhp | 2
source/text/scalc/01/05050100.xhp | 5
source/text/scalc/01/05050300.xhp | 7 -
source/text/scalc/01/06060100.xhp | 48 +++----
source/text/scalc/01/duplicate_sheet.xhp | 5
source/text/scalc/01/hide_sheet.xhp | 2
source/text/scalc/01/sheet_tab_color.xhp | 2
source/text/shared/00/00000004.xhp | 7 +
14 files changed, 252 insertions(+), 58 deletions(-)
New commits:
commit 31fe3777cb0dc69a3badc026f4de55c096af48d9
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Wed May 24 18:20:56 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Thu May 25 16:47:12 2023 +0200
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.hal...@libreoffice.org>
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>
commit c26935e97327fd87907d41dd07f60bdf71ef8067
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Wed May 24 13:27:40 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Thu May 25 16:46:58 2023 +0200
tdf#154996 Tabbed Interface command in Help pages
+ review the Hide / Show sheet command
Change-Id: I5dd3e9fe40f06c006282c1b62de38daadd01d2a6
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/152248
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/00/00000405.xhp
b/source/text/scalc/00/00000405.xhp
index 9b1333caae..127c8be0c9 100644
--- a/source/text/scalc/00/00000405.xhp
+++ b/source/text/scalc/00/00000405.xhp
@@ -52,7 +52,7 @@
</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_id3155333" xml-lang="en-US"><variable
id="fotenb">Choose <emph>Sheet - Show 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>
<paragraph role="paragraph" id="par_id3150883" xml-lang="en-US"><variable
id="fodrbe">Choose <emph>Format - Print Ranges</emph>.</variable></paragraph>
diff --git a/source/text/scalc/00/sheet_menu.xhp
b/source/text/scalc/00/sheet_menu.xhp
index 6541dcec90..a658acffda 100644
--- a/source/text/scalc/00/sheet_menu.xhp
+++ b/source/text/scalc/00/sheet_menu.xhp
@@ -26,10 +26,56 @@
</meta>
<body>
<h1 id="hd_id160220162108024368">Sheet Menu</h1>
+
+<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_sheet_bar"/>
+ <paragraph role="paragraph" id="par_id301684935381277">Choose <menuitem>Hide
Sheet</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id731684936323401">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id751684936323402" role="paragraph">
+ <image src="cmd/lc_hide.svg" id="img_id811684936323403" width="1cm"
height="1cm"><alt id="alt_id991684936323404">Icon Hide Sheet</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id21684936323406" role="paragraph">Hide
Sheet</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+
+<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_sheet_bar"/>
+ <paragraph role="paragraph" id="par_id305684935381277">Choose <menuitem>Show
Sheet</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id151684944751986">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id131684944751987" role="paragraph">
+ <image src="cmd/lc_show.svg" id="img_id611684944751988" width="1cm"
height="1cm"><alt id="alt_id131684944751989">Icon Show Sheet</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id391684944751991" role="paragraph">Show
Sheet</paragraph>
+ </tablecell>
+ </tablerow>
+ </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>
-<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>
diff --git a/source/text/scalc/01/05050300.xhp
b/source/text/scalc/01/05050300.xhp
index 252d59c32d..217a31846d 100644
--- a/source/text/scalc/01/05050300.xhp
+++ b/source/text/scalc/01/05050300.xhp
@@ -31,15 +31,16 @@
<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_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>
+<h1 id="hd_id3148946"><variable id="showsheet"><link
href="text/scalc/01/05050300.xhp">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"/>
+ <embed href="text/scalc/00/sheet_menu.xhp#showsheet"/>
</section>
<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"/>
diff --git a/source/text/scalc/01/hide_sheet.xhp
b/source/text/scalc/01/hide_sheet.xhp
index 1d1a734b0f..2c8737b0f4 100644
--- a/source/text/scalc/01/hide_sheet.xhp
+++ b/source/text/scalc/01/hide_sheet.xhp
@@ -25,11 +25,13 @@
<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>
+ <note id="par_id531684935240299">At least one sheet remains visible. You
cannot hide all the sheets in the document.</note>
<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>
diff --git a/source/text/shared/00/00000004.xhp
b/source/text/shared/00/00000004.xhp
index 2c05e9f4b8..e7ad8bb6ff 100644
--- a/source/text/shared/00/00000004.xhp
+++ b/source/text/shared/00/00000004.xhp
@@ -28,6 +28,13 @@
</meta>
<body>
<h1 id="hd_id3160447"><variable id="wie">To access this
command...</variable></h1>
+
+<section id="from_menu_bar"><h3 id="par_id441684934473786">From the Menu
bar:</h3></section>
+<section id="from_sheet_bar"><h3 id="par_id681684934479758">From the Sheet
Navigation bar:</h3></section>
+<section id="from_tabUI"><h3 id="par_id711684934483926">From the Tabbed
interface:</h3></section>
+<section id="from_toolbars"><h3 id="par_id101684936253402">From
toolbars:</h3></section>
+<section id="from_keyboard"><h3 id="par_id101544936253402">From the keyboard,
press:</h3></section>
+
<section id="related">
<paragraph role="related" id="par_id3147212" xml-lang="en-US"><variable
id="related"><emph>Related Topics</emph>
</variable></paragraph>
