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

+ Sheet menu for Calc + refactoring Change-Id: I227b221aa3093dd352a8801ea83b4558f35755ab Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160525 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> (cherry picked from commit 4fd56ae1b229043b9fbcaf035cd19b0a4b5950af) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160630
author: Olivier Hallot <olivier.hallot@libreoffice.org> 2023-12-09 12:10:23 -0300
committer: Olivier Hallot <olivier.hallot@libreoffice.org> 2023-12-12 17:29:49 +0100
commit: 36c80a346ab34eea56e63022356e02ae3724086b (patch)
tree: a02e445c6f4dc5443d8963587dc4488612618613
parent: ae0249b17e52f85980254cde7348bb4caf16867e (diff)
5 files changed, 60 insertions, 46 deletions
diff --git a/source/text/scalc/00/00000404.xhp b/source/text/scalc/00/00000404.xhp
index bff79614a1..e1217da2ea 100644
--- a/source/text/scalc/00/00000404.xhp
+++ b/source/text/scalc/00/00000404.xhp
@@ -116,23 +116,29 @@
 </section>
 
 <section id="insert_cells">
-<paragraph role="paragraph" id="par_id3149784">Choose <menuitem>Sheet - Insert Cells</menuitem>.</paragraph>
-<paragraph role="paragraph" id="par_id3154514">Choose <menuitem>View - Toolbars</menuitem> and select the <emph>Insert Cells</emph> toolbar:</paragraph>
-<section id="syinsert_cells">
-<table id="tbl_id3148550">
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3149656">
-<image id="img_id3154365" src="cmd/sc_inscellsctrl.png" width="1cm" height="1cm"><alt id="alt_id3154365">Icon</alt></image></paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="paragraph" id="par_id3151041">Insert Cells</paragraph>
-</tablecell>
-</tablerow>
-</table>
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_id3149784">Choose <menuitem>Sheet - Insert Cells</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+  <paragraph role="paragraph" id="par_id721702126497511">Choose <menuitem>Insert - Insert Cells</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+  <section id="syinsert_cells">
+    <table id="tbl_id3148550">
+      <tablerow>
+        <tablecell>
+          <paragraph role="paragraph" id="par_id3149656">
+            <image id="img_id3154365" src="cmd/lc_inscellsctrl.svg" width="1cm" height="1cm"><alt id="alt_id3154365">Icon Insert Cells</alt></image></paragraph>
+        </tablecell>
+        <tablecell>
+          <paragraph role="paragraph" id="par_id3151041">Insert Cells</paragraph>
+        </tablecell>
+      </tablerow>
+    </table>
 
+  </section>
+  <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+  <paragraph role="paragraph" id="par_id681702126442763"><switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode> + "+"</keycode></paragraph>
 </section>
-</section>
+
 <section id="syinsert_cells_down">
 <table id="tbl_id3159486">
 <tablerow>
diff --git a/source/text/scalc/00/sheet_menu.xhp b/source/text/scalc/00/sheet_menu.xhp
index 328c893d4d..866a20541d 100644
--- a/source/text/scalc/00/sheet_menu.xhp
+++ b/source/text/scalc/00/sheet_menu.xhp
@@ -27,6 +27,12 @@
 <body>
 <h1 id="hd_id160220162108024368">Sheet Menu</h1>
 
+<comment>Main sheet menu</comment>
+<section id="sheetmenu">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_id491702125833846">Choose <menuitem>Sheet</menuitem>.</paragraph>
+</section>
+
 <comment>Hide sheet</comment>
 <section id="hidesheet">
   <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
diff --git a/source/text/scalc/01/04020000.xhp b/source/text/scalc/01/04020000.xhp
index f4fb05b919..3664649954 100644
--- a/source/text/scalc/01/04020000.xhp
+++ b/source/text/scalc/01/04020000.xhp
@@ -1,7 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -19,50 +16,48 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-
-
-		<helpdocument version="1.0">
+<helpdocument version="1.0">
 <meta>
 <topic id="textscalc0104020000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Insert Cells</title>
+<title id="tit">Insert Cells</title>
 <filename>/text/scalc/01/04020000.xhp</filename>
 </topic>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id3156023"><bookmark_value>spreadsheets; inserting cells</bookmark_value>
+<bookmark branch="index" id="bm_id3156023"><bookmark_value>spreadsheets; inserting cells</bookmark_value>
 <bookmark_value>cells; inserting</bookmark_value>
 <bookmark_value>inserting; cells</bookmark_value>
 </bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertCell" id="bm_id6503296" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertcells/InsertCellsDialog" id="bm_id3147264" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertcells/@@nowidget@@" id="bm_id3147264" localize="false"/>
+<bookmark branch="hid/.uno:InsertCell" id="bm_id6503296" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/insertcells/InsertCellsDialog" id="bm_id3147264" localize="false"/>
 <h1 id="hd_id3156023"> Insert Cells</h1>
-<paragraph role="paragraph" id="par_id3150542" xml-lang="en-US"><variable id="zelleneinfuegentext"><ahelp hid=".uno:InsertCell">Opens the<emph> Insert Cells </emph>dialog, in which you can insert new cells according to the options that you specify.</ahelp>
+<paragraph role="paragraph" id="par_id3150542"><variable id="zelleneinfuegentext"><ahelp hid=".uno:InsertCell">Opens the <emph>Insert Cells</emph> dialog, in which you can insert new cells according to the options that you specify.</ahelp>
 </variable> You can delete cells by choosing <link href="text/scalc/01/02160000.xhp"><emph>Edit - Delete Cells</emph></link>.</paragraph>
 <section id="howtoget">
   <embed href="text/scalc/00/00000404.xhp#insert_cells"/>
 </section>
 <h2 id="hd_id3153768">Selection</h2>
-<paragraph role="paragraph" id="par_id3149262" xml-lang="en-US">This area contains the options available for inserting cells into a sheet. The cell quantity and position is defined by selecting a cell range in the sheet beforehand.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertCellsDown" id="bm_id6210706" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertcells/down" id="bm_id3152578" localize="false"/>
+<paragraph role="paragraph" id="par_id3149262">This area contains the options available for inserting cells into a sheet. The cell quantity and position is defined by selecting a cell range in the sheet beforehand.</paragraph>
+
+<bookmark branch="hid/.uno:InsertCellsDown" id="bm_id6210706" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/insertcells/down" id="bm_id3152578" localize="false"/>
 <h3 id="hd_id3146120">Shift cells down</h3>
-<paragraph role="paragraph" id="par_id3152596" xml-lang="en-US"><variable id="zellenuntentext"><ahelp hid="modules/scalc/ui/insertcells/down">Moves the contents of the selected range downward when cells are inserted.</ahelp>
+<paragraph role="paragraph" id="par_id3152596"><variable id="zellenuntentext"><ahelp hid="modules/scalc/ui/insertcells/down">Inserts cells and moves the contents of the selected range downward.</ahelp>
 </variable></paragraph>
-<embed href="text/scalc/00/00000404.xhp#syinsert_cells_down"/>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertCellsRight" id="bm_id7689959" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertcells/right" id="bm_id3147348" localize="false"/>
+
+<bookmark branch="hid/.uno:InsertCellsRight" id="bm_id7689959" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/insertcells/right" id="bm_id3147348" localize="false"/>
 <h3 id="hd_id3147434">Shift cells right</h3>
-<paragraph role="paragraph" id="par_id3144764" xml-lang="en-US"><variable id="zellenrechtstext"><ahelp hid="modules/scalc/ui/insertcells/right">Moves the contents of the selected range to the right when cells are inserted.</ahelp>
+<paragraph role="paragraph" id="par_id3144764"><variable id="zellenrechtstext"><ahelp hid="modules/scalc/ui/insertcells/right">Inserts cells and moves the contents of the selected range to the right.</ahelp>
 </variable></paragraph>
-<embed href="text/scalc/00/00000404.xhp#syinsert_cells_right"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertcells/rows" id="bm_id3154731" localize="false"/><h3 id="hd_id3153877">Entire row</h3>
-<paragraph role="paragraph" id="par_id3155417" xml-lang="en-US"><variable id="zeilenganzetext"><ahelp hid="modules/scalc/ui/insertcells/rows">Inserts an entire row. The position of the row is determined by the selection on the sheet.</ahelp>
+
+<bookmark branch="hid/modules/scalc/ui/insertcells/rows" id="bm_id3154731" localize="false"/><h3 id="hd_id3153877">Entire row</h3>
+<paragraph role="paragraph" id="par_id3155417"><variable id="zeilenganzetext"><ahelp hid="modules/scalc/ui/insertcells/rows">Inserts an entire row. The position of the row is determined by the selection on the sheet.</ahelp>
 </variable> The number of rows inserted depends on how many rows are selected. The contents of the original rows are moved downward.</paragraph>
-<embed href="text/scalc/00/00000404.xhp#syinsert_rows"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertcells/cols" id="bm_id3150750" localize="false"/><h3 id="hd_id3146971">Entire column</h3>
-<paragraph role="paragraph" id="par_id3155068" xml-lang="en-US"><variable id="spaltenganzetext"><ahelp hid="modules/scalc/ui/insertcells/cols">Inserts an entire column. The number of columns to be inserted is determined by the selected number of columns.</ahelp>
-</variable> The contents of the original columns are shifted to the right.</paragraph>
-<embed href="text/scalc/00/00000404.xhp#syinsert_columns"/>
+<tip id="par_id581702131982105">This command is equivalent to <embedvar href="text/shared/01/InsertRowsBefore.xhp#h1" markup="ignore"/>.</tip>
+
+<bookmark branch="hid/modules/scalc/ui/insertcells/cols" id="bm_id3150750" localize="false"/><h3 id="hd_id3146971">Entire column</h3>
+<paragraph role="paragraph" id="par_id3155068"><variable id="spaltenganzetext"><ahelp hid="modules/scalc/ui/insertcells/cols">Inserts an entire column. The number of columns to be inserted is determined by the selected number of columns.</ahelp></variable> The contents of the original columns are shifted to the right.</paragraph>
+<tip id="par_id311702131990711">This command is equivalent to <embedvar href="text/shared/01/InsertColumnsBefore.xhp#h1" markup="ignore"/>.</tip>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/main0116.xhp b/source/text/scalc/main0116.xhp
index cfcfc4f61c..8429f13583 100644
--- a/source/text/scalc/main0116.xhp
+++ b/source/text/scalc/main0116.xhp
@@ -20,7 +20,7 @@
 
 <meta>
   <topic id="textscalcmain0116xml" indexer="include" status="PUBLISH">
-    <title id="tit" xml-lang="en-US">Sheet</title>
+    <title id="tit">Sheet</title>
     <filename>/text/scalc/main0116.xhp</filename>
   </topic>
 </meta>
@@ -28,10 +28,13 @@
 <body>
 
 <section id="sheet">
-<bookmark xml-lang="en-US" branch="hid/.uno:SheetMenu" id="bm_id0906201507425254" localize="false"/>
+<bookmark branch="hid/.uno:SheetMenu" id="bm_id0906201507425254" localize="false"/>
 
 <h1 id="hd_id0906201507390173"><link href="text/scalc/main0116.xhp">Sheet</link></h1>
-<paragraph id="par_id0906201507414091" role="paragraph" xml-lang="en-US"><ahelp hid=".">This menu contains commands to modify and manage a sheet and its elements.</ahelp></paragraph>
+<paragraph id="par_id0906201507414091" role="paragraph"><ahelp hid=".">This menu contains commands to modify and manage a sheet and its elements.</ahelp></paragraph>
+</section>
+<section id="howtoget">
+  <embed href="text/scalc/00/sheet_menu.xhp#sheetmenu"/>
 </section>
 <h2 id="par_id0906201507414191"><link href="text/scalc/01/04030000.xhp">Insert Rows</link></h2>
 <embed href="text/scalc/01/04030000.xhp#sheet_insert_rows"/>
diff --git a/source/text/shared/00/00000404.xhp b/source/text/shared/00/00000404.xhp
index cd10736f8f..9c1883f316 100644
--- a/source/text/shared/00/00000404.xhp
+++ b/source/text/shared/00/00000404.xhp
@@ -56,6 +56,7 @@
         <case select="CALC">
             <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
             <paragraph role="paragraph" id="par_id281693664844219">Choose <menuitem>Sheet - Insert Rows - Rows Above</menuitem>.</paragraph>
+            <paragraph role="paragraph" id="par_id721702132891571">Choose <menuitem>Sheet - Insert Cells - Entire Row</menuitem>.</paragraph>
         </case>
     </switch>
     <embed href="text/shared/00/00000004.xhp#from_context"/>
@@ -65,6 +66,7 @@
         </case>
         <case select="CALC">
             <paragraph role="paragraph" id="par_id941693665025455">Select one or more rows, choose <menuitem>Insert Rows Above</menuitem>.</paragraph>
+            <paragraph role="paragraph" id="par_id621702132993942">Select one or more cells, choose <menuitem>Insert Cells - Entire Row</menuitem>.</paragraph>
         </case>
         <default>
             <paragraph role="paragraph" id="par_id381693665134720">Choose <menuitem>Insert - Insert Row Above</menuitem>.</paragraph>
@@ -110,6 +112,7 @@
         <case select="CALC">
             <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
             <paragraph role="paragraph" id="par_id91693670645006">Choose <menuitem>Sheet - Insert Columns - Columns Before</menuitem>.</paragraph>
+            <paragraph role="paragraph" id="par_id491702133119921">Choose <menuitem>Sheet - Insert Cells - Entire column</menuitem>.</paragraph>
         </case>
     </switch>
     <embed href="text/shared/00/00000004.xhp#from_context"/>
@@ -119,6 +122,7 @@
         </case>
         <case select="CALC">
             <paragraph role="paragraph" id="par_id391693670651093">Select one or more columns, choose <menuitem>Insert Columns Before</menuitem>.</paragraph>
+            <paragraph role="paragraph" id="par_id241702133110586">Select one or more columns, choose <menuitem>Insert Cells - Entire column</menuitem>.</paragraph>
         </case>
         <default>
             <paragraph role="paragraph" id="par_id781693670653910">Choose <menuitem>Insert - Insert Column Before</menuitem>.</paragraph>
author	Olivier Hallot <olivier.hallot@libreoffice.org>	2023-12-09 12:10:23 -0300
committer	Olivier Hallot <olivier.hallot@libreoffice.org>	2023-12-12 17:29:49 +0100
commit	36c80a346ab34eea56e63022356e02ae3724086b (patch)
tree	a02e445c6f4dc5443d8963587dc4488612618613
parent	ae0249b17e52f85980254cde7348bb4caf16867e (diff)