AllLangHelp_scalc.mk | 3 ++ source/text/scalc/00/sheet_menu.xhp | 16 ++++++++++++++ source/text/scalc/01/02220000.xhp | 17 ++++++++------- source/text/scalc/01/DeleteAllNotes.xhp | 7 ++---- source/text/scalc/01/DeleteNote.xhp | 5 +--- source/text/scalc/01/JumpToNextTable.xhp | 31 ++++++++++++++++++++++++++++ source/text/scalc/01/JumpToNextTableSel.xhp | 2 - source/text/scalc/01/JumpToPrevTable.xhp | 31 ++++++++++++++++++++++++++++ source/text/scalc/01/NavigateMenu.xhp | 31 ++++++++++++++++++++++++++++ source/text/scalc/01/events_sheet.xhp | 1 source/text/scalc/01/hide_sheet.xhp | 4 +-- source/text/scalc/main0116.xhp | 21 ++++++------------ source/text/shared/01/06140500.xhp | 1 13 files changed, 137 insertions(+), 33 deletions(-)
New commits: commit 07a822f717dc58bf03b542636bc9ef7d77d6066f Author: Olivier Hallot <[email protected]> AuthorDate: Mon Dec 18 23:47:16 2023 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Tue Dec 19 03:58:37 2023 +0100 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 <[email protected]> (cherry picked from commit 0565c612d43abbbd3ad454843d59770349b82487) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160937 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"/>
