summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2023-12-18 23:47:16 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2023-12-19 03:58:37 +0100
commit07a822f717dc58bf03b542636bc9ef7d77d6066f (patch)
tree5e38104d1fd11a6d241336072ec4e0445adde524
parent33e3184a74dee2ee21c8229965bf19bd487c336d (diff)
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
-rw-r--r--AllLangHelp_scalc.mk3
-rw-r--r--source/text/scalc/00/sheet_menu.xhp16
-rw-r--r--source/text/scalc/01/02220000.xhp17
-rw-r--r--source/text/scalc/01/DeleteAllNotes.xhp7
-rw-r--r--source/text/scalc/01/DeleteNote.xhp5
-rw-r--r--source/text/scalc/01/JumpToNextTable.xhp31
-rw-r--r--source/text/scalc/01/JumpToNextTableSel.xhp2
-rw-r--r--source/text/scalc/01/JumpToPrevTable.xhp31
-rw-r--r--source/text/scalc/01/NavigateMenu.xhp31
-rw-r--r--source/text/scalc/01/events_sheet.xhp1
-rw-r--r--source/text/scalc/01/hide_sheet.xhp4
-rw-r--r--source/text/scalc/main0116.xhp21
-rw-r--r--source/text/shared/01/06140500.xhp1
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"/>