tdf#155876 UI cmds Calc-Sheet menu (34)

+ Sheet menu for Calc, end + refactoring Change-Id: Iddbd6f37722ea6eb020431cecf42966ffee703ba Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160959 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> (cherry picked from commit 0565c612d43abbbd3ad454843d59770349b82487) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160937
author: Olivier Hallot <olivier.hallot@libreoffice.org> 2023-12-18 23:47:16 -0300
committer: Olivier Hallot <olivier.hallot@libreoffice.org> 2023-12-19 03:58:37 +0100
commit: 07a822f717dc58bf03b542636bc9ef7d77d6066f (patch)
tree: 5e38104d1fd11a6d241336072ec4e0445adde524
parent: 33e3184a74dee2ee21c8229965bf19bd487c336d (diff)
13 files changed, 137 insertions, 33 deletions
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 968c68ce67..1b7d10db70 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -292,10 +292,13 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
     helpcontent2/source/text/scalc/01/InsertCurrentDate \
     helpcontent2/source/text/scalc/01/InsertCurrentTime \
     helpcontent2/source/text/scalc/01/JumpToNextTableSel \
+    helpcontent2/source/text/scalc/01/JumpToNextTable \
     helpcontent2/source/text/scalc/01/JumpToPrevTableSel \
+    helpcontent2/source/text/scalc/01/JumpToPrevTable \
     helpcontent2/source/text/scalc/01/live_data_stream \
     helpcontent2/source/text/scalc/01/ManageNames \
     helpcontent2/source/text/scalc/01/MergeCellsMenu \
+    helpcontent2/source/text/scalc/01/NavigateMenu \
     helpcontent2/source/text/scalc/01/NormalViewMode \
     helpcontent2/source/text/scalc/01/recalculate_hard \
     helpcontent2/source/text/scalc/01/SelectColumn \
diff --git a/source/text/scalc/00/sheet_menu.xhp b/source/text/scalc/00/sheet_menu.xhp
index 7cd27e75cc..d7ef89f44c 100644
--- a/source/text/scalc/00/sheet_menu.xhp
+++ b/source/text/scalc/00/sheet_menu.xhp
@@ -441,5 +441,21 @@
     </tablerow>
   </table>
 </section>
+<section id="navigate_menu">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_id591702950637039">Choose <menuitem>Sheet - Navigate</menuitem>.</paragraph>
+</section>
+<section id="jump_next">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_id131702951930928">Choose <menuitem>Sheet - Navigate - To Next Sheet</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+  <paragraph role="paragraph" id="par_id601702952027454"><switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode> + Tab</keycode></paragraph>
+</section>
+<section id="jump_previous">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_id471702952143358">Choose <menuitem>Sheet - Navigate - To Previous Sheet</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+  <paragraph role="paragraph" id="par_id551702952160062"><switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode> + Shift +Tab</keycode></paragraph>
+</section>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/02220000.xhp b/source/text/scalc/01/02220000.xhp
index cba783f834..2dc0c3abfd 100644
--- a/source/text/scalc/01/02220000.xhp
+++ b/source/text/scalc/01/02220000.xhp
@@ -10,7 +10,7 @@
 <helpdocument version="1.0">
   <meta>
     <topic id="textscalc0102220000xml" indexer="include" status="PUBLISH">
-      <title xml-lang="en-US" id="tit">Go to Sheet</title>
+      <title id="tit">Go to Sheet</title>
       <filename>/text/scalc/01/02220000.xhp</filename>
     </topic>
     <history>
@@ -18,9 +18,9 @@
     </history>
   </meta>
   <body>
-  <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/gotosheetdialog/@@nowidget@@" id="bm_id561655657926168" localize="false"/>
-  <bookmark branch="hid/.uno:JumpToTable" xml-lang="en-US" id="bm_id3154761" localize="false"/>
-  <bookmark xml-lang="en-US" branch="index" id="bm_id781654171314500">
+  <bookmark branch="hid/modules/scalc/ui/gotosheetdialog/@@nowidget@@" id="bm_id561655657926168" localize="false"/>
+  <bookmark branch="hid/.uno:JumpToTable" id="bm_id3154761" localize="false"/>
+  <bookmark branch="index" id="bm_id781654171314500">
     <bookmark_value>Go to sheet</bookmark_value>
     <bookmark_value>jump; to given sheet</bookmark_value>
     <bookmark_value>sheet; go to directly</bookmark_value>
@@ -28,15 +28,16 @@
   </bookmark>
   <section id="sectiongotosheet">
     <h1 id="hd_id3156025"><variable id="GotoSheeth1"><link href="text/scalc/01/02220000.xhp">Go to Sheet</link></variable></h1>
-    <paragraph role="paragraph" id="par_id3147266" xml-lang="en-US"><variable id="gototable"><ahelp hid=".uno:JumpToTable" visibility="visible">Go to a specified sheet.</ahelp></variable></paragraph>
+    <paragraph role="paragraph" id="par_id3147266"><variable id="gototable"><ahelp hid=".uno:JumpToTable" visibility="visible">Go to a specified sheet.</ahelp></variable></paragraph>
   </section>
   <section id="howtoget">
+    <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
     <paragraph role="paragraph" id="par_id231655657630178">Choose <menuitem>Sheet - Navigate - Go To Sheet</menuitem>.</paragraph>
   </section>
-  <bookmark branch="hid/SC_HID_GOTOTABLE" xml-lang="en-US" id="bm_id3154128" localize="false"/>
+  <bookmark branch="hid/SC_HID_GOTOTABLE" id="bm_id3154128" localize="false"/>
   <h2 id="hd_id3125862">Type a sheet name</h2>
-  <paragraph role="paragraph" id="par_id3153975" xml-lang="en-US"><ahelp hid="SC_HID_GOTOTABLEMASK">Type some characters contained in the searched sheet name. List of sheets will be limited to the sheet names containing these characters. Search is case-sensitive. If empty, all visible sheets are listed.</ahelp></paragraph>
+  <paragraph role="paragraph" id="par_id3153975"><ahelp hid="SC_HID_GOTOTABLEMASK">Type some characters contained in the searched sheet name. List of sheets will be limited to the sheet names containing these characters. Search is case-sensitive. If empty, all visible sheets are listed.</ahelp></paragraph>
   <h2 id="hd_id3125866">Sheets</h2>
-  <paragraph role="paragraph" id="par_id3153971" xml-lang="en-US"><ahelp hid="SC_HID_GOTOTABLE">Lists the sheets in the current document. Hidden sheets are not listed. To select a sheet, press the up or down arrow keys to move to a sheet in the list. Double-clicking on a name will directly jump to this sheet.</ahelp></paragraph>
+  <paragraph role="paragraph" id="par_id3153971"><ahelp hid="SC_HID_GOTOTABLE">Lists the sheets in the current document. Hidden sheets are not listed. To select a sheet, press the up or down arrow keys to move to a sheet in the list. Double-clicking on a name will directly jump to this sheet.</ahelp></paragraph>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/DeleteAllNotes.xhp b/source/text/scalc/01/DeleteAllNotes.xhp
index 9285224807..5b7844a441 100644
--- a/source/text/scalc/01/DeleteAllNotes.xhp
+++ b/source/text/scalc/01/DeleteAllNotes.xhp
@@ -15,9 +15,8 @@
             <filename>/text/scalc/01/DeleteAllNotes.xhp</filename>
         </topic>
     </meta>
-    <body>
-
-<bookmark branch="hid/.uno:DeleteAllNotes" id="bm_id841702947646882" localize="false"/>
+<body>
+    <bookmark branch="hid/.uno:DeleteAllNotes" id="bm_id841702947646882" localize="false"/>
     <section id="delete_all_notes">
         <h1 id="hd_id361702947725743"><variable id="h1"><link href="text/scalc/01/DeleteAllNotes.xhp">Delete All Comments</link></variable></h1>
         <paragraph id="par_id731702947725744" role="paragraph">Deletes all cell notes of the current sheet.</paragraph>
@@ -25,7 +24,7 @@
     <section id="howtoget">
         <embed href="text/scalc/00/sheet_menu.xhp#delete_all_comments"/>
     </section>
-        <section id="relatedtopics">
+    <section id="relatedtopics">
         <paragraph role="paragraph" id="par_id321702948452216" localize="false"><embedvar href="text/scalc/01/SheetCommentMenu.xhp#h1" markup="ignore"/></paragraph>
     </section>
 </body>
diff --git a/source/text/scalc/01/DeleteNote.xhp b/source/text/scalc/01/DeleteNote.xhp
index 979de1d3e5..39e610c5b8 100644
--- a/source/text/scalc/01/DeleteNote.xhp
+++ b/source/text/scalc/01/DeleteNote.xhp
@@ -15,9 +15,8 @@
             <filename>/text/scalc/01/DeleteNote.xhp</filename>
         </topic>
     </meta>
-    <body>
-
-<bookmark branch="hid/.uno:DeleteNote" id="bm_id921702946751041" localize="false"/>
+<body>
+    <bookmark branch="hid/.uno:DeleteNote" id="bm_id921702946751041" localize="false"/>
     <section id="delete_note">
         <h1 id="hd_id801702946820149"><variable id="h1"><link href="text/scalc/01/DeleteNote.xhp">Delete Comment</link></variable></h1>
         <paragraph id="par_id501702946820151" role="paragraph">Deletes the comment of the cell.</paragraph>
diff --git a/source/text/scalc/01/JumpToNextTable.xhp b/source/text/scalc/01/JumpToNextTable.xhp
new file mode 100644
index 0000000000..4d28c1aece
--- /dev/null
+++ b/source/text/scalc/01/JumpToNextTable.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="textscalc01JumpToNextTablexhp" indexer="include" status="PUBLISH">
+            <title id="tit">Jump to Next Sheet</title>
+            <filename>/text/scalc/01/JumpToNextTable.xhp</filename>
+        </topic>
+    </meta>
+    <body>
+<bookmark branch="hid/.uno:JumpToNextTable" id="bm_id351697504966666" localize="false"/>
+<bookmark branch="index" id="bm_id801697546069561">
+    <bookmark_value>jump;to the next sheet</bookmark_value>
+</bookmark>
+    <section id="JumpToNextTable">
+        <h1 id="hd_id841697505362733"><variable id="h1"><link href="text/scalc/01/JumpToNextTable.xhp">Jump to Next Sheet</link></variable></h1>
+        <paragraph id="par_id291697505362735" role="paragraph">Jump to next sheet in the document.</paragraph>
+    </section>
+    <section id="howtoget">
+        <embed href="text/scalc/00/sheet_menu.xhp#jump_next"/>
+    </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/JumpToNextTableSel.xhp b/source/text/scalc/01/JumpToNextTableSel.xhp
index 146b8f6a6b..16a44ceb27 100644
--- a/source/text/scalc/01/JumpToNextTableSel.xhp
+++ b/source/text/scalc/01/JumpToNextTableSel.xhp
@@ -10,7 +10,7 @@
     -->
 
     <meta>
-        <topic id="text/scalc/01/JumpToNextTableSel.xhp" indexer="include" status="PUBLISH">
+        <topic id="textscalc01JumpToNextTableSelxhp" indexer="include" status="PUBLISH">
             <title id="tit">Select to Next Sheet</title>
             <filename>/text/scalc/01/JumpToNextTableSel.xhp</filename>
         </topic>
diff --git a/source/text/scalc/01/JumpToPrevTable.xhp b/source/text/scalc/01/JumpToPrevTable.xhp
new file mode 100644
index 0000000000..8849614efd
--- /dev/null
+++ b/source/text/scalc/01/JumpToPrevTable.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="textscalc01JumpToPrevTablexhp" indexer="include" status="PUBLISH">
+            <title id="tit">Jump to Previous Sheet</title>
+            <filename>/text/scalc/01/JumpToPrevTable.xhp</filename>
+        </topic>
+    </meta>
+    <body>
+<bookmark branch="hid/.uno:JumpToPrevTable" id="bm_id351697504966666" localize="false"/>
+<bookmark branch="index" id="bm_id801697546069561">
+    <bookmark_value>jump;to previous sheet</bookmark_value>
+</bookmark>
+    <section id="JumpToPrevTable">
+        <h1 id="hd_id841697505362733"><variable id="h1"><link href="text/scalc/01/JumpToPrevTable.xhp">To Previous Sheet</link></variable></h1>
+        <paragraph id="par_id291697505362735" role="paragraph">Jump to previous sheet in the document.</paragraph>
+    </section>
+    <section id="howtoget">
+        <embed href="text/scalc/00/sheet_menu.xhp#jump_previous"/>
+    </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/NavigateMenu.xhp b/source/text/scalc/01/NavigateMenu.xhp
new file mode 100644
index 0000000000..9352d9f945
--- /dev/null
+++ b/source/text/scalc/01/NavigateMenu.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="textscalc01NavigateMenuxhp" indexer="include" status="PUBLISH">
+            <title id="tit">Navigate Menu</title>
+            <filename>/text/scalc/01/NavigateMenu.xhp</filename>
+        </topic>
+    </meta>
+<body>
+    <bookmark branch="hid/.uno:NavigateMenu" id="bm_id621702949687837" localize="false"/>
+    <section id="navigate_menu">
+        <h1 id="hd_id521702949741744"><variable id="h1"><link href="text/scalc/01/NavigateMenu.xhp">Navigate Menu</link></variable></h1>
+        <paragraph id="par_id181702949741747" role="paragraph">Opens a submenu to navigate between sheets.</paragraph>
+    </section>
+    <section id="howtoget">
+        <embed href="text/scalc/00/sheet_menu.xhp#navigate_menu"/>
+    </section>
+    <embed href="text/scalc/01/02220000.xhp#sectiongotosheet"/>
+    <embed href="text/scalc/01/JumpToPrevTable.xhp#JumpToPrevTable"/>
+    <embed href="text/scalc/01/JumpToNextTable.xhp#JumpToNextTable"/>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/events_sheet.xhp b/source/text/scalc/01/events_sheet.xhp
index 0624409b8d..cac26d38ae 100644
--- a/source/text/scalc/01/events_sheet.xhp
+++ b/source/text/scalc/01/events_sheet.xhp
@@ -20,6 +20,7 @@
     <bookmark_value>sheet;events</bookmark_value>
     <bookmark_value>events;sheet only</bookmark_value>
 </bookmark>
+  <bookmark branch="hid/.uno:TableEvents" id="bm_id1163922275" localize="false"/>
 <section id="sheetevents">
     <h1 id="hd_id841685031890653"><variable id="h1"><link href="text/scalc/01/events_sheet.xhp">Sheet Events</link></variable></h1>
     <paragraph id="par_id671685031890655" role="paragraph">%PRODUCTNAME Calc specific sheet events. You can assign a macro to each sheet event.</paragraph>
diff --git a/source/text/scalc/01/hide_sheet.xhp b/source/text/scalc/01/hide_sheet.xhp
index 3424ed6f0e..107979dde9 100644
--- a/source/text/scalc/01/hide_sheet.xhp
+++ b/source/text/scalc/01/hide_sheet.xhp
@@ -16,12 +16,12 @@
     </topic>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id571684781225345">
+<bookmark branch="index" id="bm_id571684781225345">
 <bookmark_value>sheet;hiding</bookmark_value>
 <bookmark_value>hidden;sheet</bookmark_value>
 </bookmark>
-<section id="hide_sheet">
     <bookmark id="bm_id801684779805304" branch="hid/.uno:Hide" localize="false"/>
+<section id="hide_sheet">
     <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>
diff --git a/source/text/scalc/main0116.xhp b/source/text/scalc/main0116.xhp
index 4afdc0506d..3038e16e03 100644
--- a/source/text/scalc/main0116.xhp
+++ b/source/text/scalc/main0116.xhp
@@ -53,21 +53,14 @@
 <embed href="text/scalc/01/ToggleRelative.xhp#cycle_types"/>
 <embed href="text/scalc/01/02140000.xhp#fill"/>
 <embed href="text/scalc/01/04070000.xhp#namen"/>
-
-
-<h2 id="hd_id3150792"><link href="text/scalc/01/02180000.xhp">Move or Copy Sheet</link></h2>
-<embed href="text/scalc/01/02180000.xhp#tabelleverschiebenkopierentext"/>
-
-<h2 id="hd_id3153968"><link href="text/scalc/01/05050300.xhp">Show Sheet</link></h2>
-<embed href="text/scalc/01/05050300.xhp#tabeintext"/>
-
-<h2 id="hd_id3163708"><link href="text/scalc/01/02170000.xhp">Delete Sheet</link></h2>
-<embed href="text/scalc/01/02170000.xhp#tabelleloeschentext"/>
-
+<embed href="text/scalc/01/04070000.xhp#namen"/>
+<embed href="text/scalc/01/SheetCommentMenu.xhp#comment_menu"/>
+<embed href="text/scalc/01/05050100.xhp#renamesheet"/>
+<embed href="text/scalc/01/hide_sheet.xhp#hide_sheet"/>
+<embed href="text/scalc/01/05050300.xhp#show_sheet"/>
+<embed href="text/scalc/01/NavigateMenu.xhp#navigate_menu"/>
 <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"/>
+<embed href="text/scalc/01/events_sheet.xhp#sheetevents"/>
 </body>
 
 </helpdocument>
diff --git a/source/text/shared/01/06140500.xhp b/source/text/shared/01/06140500.xhp
index c94993700b..63b05a3f51 100644
--- a/source/text/shared/01/06140500.xhp
+++ b/source/text/shared/01/06140500.xhp
@@ -29,7 +29,6 @@
     <bookmark_value>events; customizing</bookmark_value>
   </bookmark>
   <bookmark branch="hid/cui/ui/eventsconfigpage/EventsConfigPage" id="bm_id1163922274" localize="false"/>
-  <bookmark branch="hid/.uno:TableEvents" id="bm_id1163922275" localize="false"/>
   <bookmark branch="hid/cui/ui/macroassignpage/MacroAssignPage" id="bm_id1163922276" localize="false"/>
   <bookmark branch="hid/cui/ui/macroassignpage/@@nowidget@@" id="bm_id1163922276" localize="false"/>
   <bookmark branch="hid/cui/ui/macroassigndialog/MacroAssignDialog" id="bm_id1163922277" localize="false"/>
author	Olivier Hallot <olivier.hallot@libreoffice.org>	2023-12-18 23:47:16 -0300
committer	Olivier Hallot <olivier.hallot@libreoffice.org>	2023-12-19 03:58:37 +0100
commit	07a822f717dc58bf03b542636bc9ef7d77d6066f (patch)
tree	5e38104d1fd11a6d241336072ec4e0445adde524
parent	33e3184a74dee2ee21c8229965bf19bd487c336d (diff)