source/text/scalc/00/00000404.xhp | 36 ++++++++------ source/text/scalc/00/sheet_menu.xhp | 91 +++++++++++++++++++++++++++++++++--- source/text/scalc/01/04010000.xhp | 13 +---- source/text/scalc/01/04020000.xhp | 51 +++++++++----------- source/text/scalc/01/04030000.xhp | 27 ++-------- source/text/scalc/01/04040000.xhp | 23 ++------- source/text/scalc/main0116.xhp | 9 ++- source/text/shared/00/00000404.xhp | 4 + 8 files changed, 157 insertions(+), 97 deletions(-)
New commits: commit 56d67dfd7ef0df8768ad2f4975333ad633cde27f Author: Olivier Hallot <[email protected]> AuthorDate: Sat Dec 9 15:37:05 2023 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Sun Dec 10 12:21:35 2023 +0100 tdf#155876 UI cmds Calc-Sheet menu (27) + Sheet menu for Calc, insert row/column/breaks + refactoring Change-Id: Ie8ecd21877f960206616489e9113144bd37dd96a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160526 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/scalc/00/sheet_menu.xhp b/source/text/scalc/00/sheet_menu.xhp index 866a20541d..e83ae3cf06 100644 --- a/source/text/scalc/00/sheet_menu.xhp +++ b/source/text/scalc/00/sheet_menu.xhp @@ -256,13 +256,84 @@ </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> -<paragraph id="par_id160220162107055028" role="paragraph"><variable id="insert_columns_left">Choose <emph>Sheet - Insert Columns - Columns Before</emph>.</variable></paragraph> -<paragraph id="par_id160220162109126013" role="paragraph"><variable id="insert_columns_right">Choose <emph>Sheet - Insert Columns - Columns After</emph>.</variable></paragraph> -<paragraph role="paragraph" id="par_id3149095"><variable id="insert_page_break">Choose <emph>Sheet - Insert Page Break</emph>.</variable></paragraph> -<paragraph role="paragraph" id="par_id3149398"><variable id="insert_page_break_row">Choose <emph>Sheet - Insert Page Break - Row Break</emph>.</variable></paragraph> -<paragraph role="paragraph" id="par_id3150084"><variable id="insert_page_break_column">Choose <emph>Sheet - Insert Page Break - Column Break</emph>.</variable></paragraph> + +<section id="insert_rows"> + <embed href="text/shared/00/00000004.xhp#from_menu_bar"/> + <paragraph role="paragraph" id="par_id981702136310437">Choose <menuitem>Sheet - Insert Rows</menuitem>.</paragraph> + <embed href="text/shared/00/00000004.xhp#from_tabUI"/> + <paragraph role="paragraph" id="par_id631702136321436">Choose <menuitem>Home - Row</menuitem>.</paragraph> + <paragraph role="paragraph" id="par_id451702136327775">Choose <menuitem>Layout - Row</menuitem>.</paragraph> + <embed href="text/shared/00/00000004.xhp#from_toolbars"/> + <table id="tab_id581702136089556"> + <tablerow> + <tablecell> + <paragraph id="par_id731702136089557" role="paragraph"><image src="cmd/lc_entirerow.svg" id="img_id1001702136089558" width="1cm" height="1cm"><alt id="alt_id371702136089559">Icon Insert Row</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id741702136089561" role="paragraph">Insert Row</paragraph> + </tablecell> + </tablerow> + </table> +</section> + +<section id="insert_columns"> + <embed href="text/shared/00/00000004.xhp#from_menu_bar"/> + <paragraph role="paragraph" id="par_id171702137212952">Choose <menuitem>Sheet - Insert Columns</menuitem>.</paragraph> + <embed href="text/shared/00/00000004.xhp#from_tabUI"/> + <paragraph role="paragraph" id="par_id481702137217464">Choose <menuitem>Home - Column</menuitem>.</paragraph> + <paragraph role="paragraph" id="par_id631702137221935">Choose <menuitem>Layout - Column</menuitem>.</paragraph> + <embed href="text/shared/00/00000004.xhp#from_toolbars"/> + <table id="tab_id461702137173243"> + <tablerow> + <tablecell> + <paragraph id="par_id921702137173244" role="paragraph"><image src="cmd/lc_entirecolumn.svg" id="img_id611702137173245" width="1cm" height="1cm"><alt id="alt_id661702137173246">Icon Insert Column</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id881702137173248" role="paragraph">Insert Columns</paragraph> + </tablecell> + </tablerow> + </table> +</section> + +<section id="insert_page_break"> + <embed href="text/shared/00/00000004.xhp#from_menu_bar"/> + <paragraph role="paragraph" id="par_id3149095">Choose <menuitem>Sheet - Insert Page Break</menuitem>.</paragraph> +</section> +<section id="insert_page_break_row"> + <embed href="text/shared/00/00000004.xhp#from_menu_bar"/> + <paragraph role="paragraph" id="par_id3149398">Choose <menuitem>Sheet - Insert Page Break - Row Break</menuitem>.</paragraph> + <embed href="text/shared/00/00000004.xhp#from_tabUI"/> + <paragraph role="paragraph" id="par_id381702145053612">On the <menuitem>Layout</menuitem> menu of the <menuitem>Layout</menuitem> tab, choose <menuitem>Row Break</menuitem>.</paragraph> + <embed href="text/shared/00/00000004.xhp#from_toolbars"/> + <table id="tab_id201702144996562"> + <tablerow> + <tablecell> + <paragraph id="par_id561702144996563" role="paragraph"><image src="cmd/lc_insertrowbreak.svg" id="img_id751702144996564" width="1cm" height="1cm"><alt id="alt_id551702144996565">Icon Insert Row Break</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id481702144996567" role="paragraph">Insert Row Break</paragraph> + </tablecell> + </tablerow> + </table> +</section> +<section id="insert_page_break_column"> + <embed href="text/shared/00/00000004.xhp#from_menu_bar"/> + <paragraph role="paragraph" id="par_id3150084">Choose <menuitem>Sheet - Insert Page Break - Column Break</menuitem>.</paragraph> + <embed href="text/shared/00/00000004.xhp#from_tabUI"/> + <paragraph role="paragraph" id="par_id741702145047953">On the <menuitem>Layout</menuitem> menu of the <menuitem>Layout</menuitem> tab, choose <menuitem>Column Break</menuitem>.</paragraph> + <embed href="text/shared/00/00000004.xhp#from_toolbars"/> + <table id="tab_id581702145183777"> + <tablerow> + <tablecell> + <paragraph id="par_id211702145183778" role="paragraph"><image src="cmd/lc_insertcolumnbreak.svg" id="img_id681702145183779" width="1cm" height="1cm"><alt id="alt_id561702145183780">Icon Insert Column Break</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id821702145183781" role="paragraph">Insert Column Break</paragraph> + </tablecell> + </tablerow> + </table> +</section> + <paragraph id="par_id3153093" role="paragraph"><variable id="delete_page_break">Choose <emph>Sheet - Delete Page Break</emph>.</variable></paragraph> <paragraph id="par_id3153191" role="paragraph"><variable id="delete_page_break_row">Choose <emph>Sheet - Delete Page Break - Row Break</emph>.</variable></paragraph> <paragraph id="par_id3145645" role="paragraph"><variable id="delete_page_break_column">Choose <emph>Sheet - Delete Page Break - Column Break</emph>.</variable></paragraph> diff --git a/source/text/scalc/01/04010000.xhp b/source/text/scalc/01/04010000.xhp index 548818206f..089dca4006 100644 --- a/source/text/scalc/01/04010000.xhp +++ b/source/text/scalc/01/04010000.xhp @@ -1,6 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - <!-- * This file is part of the LibreOffice project. * @@ -18,11 +16,10 @@ * 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"> <meta> <topic id="textscalc0104010000xml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Insert Page Break</title> +<title id="tit">Insert Page Break</title> <filename>/text/scalc/01/04010000.xhp</filename> </topic> <history> @@ -31,15 +28,15 @@ </meta> <body> <section id="ins_page_break"> -<bookmark xml-lang="en-US" branch="index" id="bm_id3153192"><bookmark_value>spreadsheets; inserting breaks in</bookmark_value> +<bookmark branch="index" id="bm_id3153192"><bookmark_value>spreadsheets; inserting breaks in</bookmark_value> <bookmark_value>inserting; breaks</bookmark_value> <bookmark_value>page breaks; inserting in spreadsheets</bookmark_value> </bookmark><comment>mw changed "page breaks;..."</comment> -<bookmark xml-lang="en-US" branch="hid/.uno:InsertBreakMenu" id="bm_id2778710" localize="false"/> +<bookmark branch="hid/.uno:InsertBreakMenu" id="bm_id2778710" localize="false"/> <h1 id="hd_id3153192"><link href="text/scalc/01/04010000.xhp">Insert Page Break</link></h1> -<paragraph role="paragraph" id="par_id3125864" xml-lang="en-US"><ahelp hid=".">This command inserts manual row or column breaks to ensure that your data prints properly. You can insert a horizontal page break above, or a vertical page break to the left of, the active cell.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3125864"><ahelp hid=".">This command inserts manual row or column breaks to ensure that your data prints properly. You can insert a horizontal page break above, or a vertical page break to the left of, the active cell.</ahelp></paragraph> </section> -<paragraph role="paragraph" id="par_id3155133" xml-lang="en-US">Choose <link href="text/scalc/01/02190000.xhp">Sheet - Delete Page Break</link> to remove breaks created manually.</paragraph> +<paragraph role="paragraph" id="par_id3155133">Choose <link href="text/scalc/01/02190000.xhp">Sheet - Delete Page Break</link> to remove breaks created manually.</paragraph> <section id="howtoget"> <embed href="text/scalc/00/sheet_menu.xhp#insert_page_break"/> </section> diff --git a/source/text/scalc/01/04030000.xhp b/source/text/scalc/01/04030000.xhp index c4d8c658d6..649578f9a2 100644 --- a/source/text/scalc/01/04030000.xhp +++ b/source/text/scalc/01/04030000.xhp @@ -20,7 +20,7 @@ <meta> <topic id="textscalc0104030000xml" indexer="include" status="PUBLISH"> - <title id="tit" xml-lang="en-US">Insert Rows</title> + <title id="tit">Insert Rows</title> <filename>/text/scalc/01/04030000.xhp</filename> </topic> </meta> @@ -28,31 +28,18 @@ <body> <comment>Marked for deletion later. reworked in shared/ OH</comment> -<bookmark xml-lang="en-US" branch="index" id="bm_id3150541"> +<bookmark branch="index" id="bm_id3150541"> <bookmark_value>spreadsheets; inserting rows</bookmark_value> <bookmark_value>rows; inserting</bookmark_value> <bookmark_value>inserting; rows</bookmark_value> </bookmark> - - - +<bookmark branch="hid/.uno:InsertRowsMenu" id="bm_id51702134833791" localize="false"/> <h1 id="hd_id3150541"><link href="text/scalc/01/04030000.xhp">Insert Rows</link></h1> -<paragraph id="par_id160220162210581072" role="paragraph" xml-lang="en-US"><variable id="sheet_insert_rows">Insert rows above or below the active cell.</variable> The number of rows inserted corresponds to the number of rows selected. If no row is selected, one row is inserted. The existing rows are moved downward.</paragraph> - -<h2 id="hd_id160220162131439740">Rows Above</h2> -<paragraph id="par_id3150767" role="paragraph" xml-lang="en-US"><ahelp hid=".uno:InsertRowsBefore">Inserts a new row above the active cell.</ahelp></paragraph> - +<paragraph id="par_id160220162210581072" role="paragraph"><variable id="sheet_insert_rows">Insert rows above or below the active cell.</variable> The number of rows inserted corresponds to the number of rows selected. If no row is selected, one row is inserted. The existing rows are moved downward.</paragraph> <section id="howtoget"> -<embed href="text/scalc/00/sheet_menu.xhp#insert_rows_above"/> -</section> - - -<h2 id="hd_id160220162133372726">Rows Below</h2> -<paragraph id="par_id3150768" role="paragraph" xml-lang="en-US"><ahelp hid=".uno:InsertRowsAfter">Inserts a new row below the active cell.</ahelp></paragraph> - -<section id="howtoget"> -<embed href="text/scalc/00/sheet_menu.xhp#insert_rows_below"/> +<embed href="text/scalc/00/sheet_menu.xhp#insert_rows"/> </section> +<embed href="text/shared/01/InsertRowsBefore.xhp#insert_rows_above"/> +<embed href="text/shared/01/InsertRowsAfter.xhp#insert_rows_below"/> </body> - </helpdocument> diff --git a/source/text/scalc/01/04040000.xhp b/source/text/scalc/01/04040000.xhp index 13536fe2fc..c5ad8d00e8 100644 --- a/source/text/scalc/01/04040000.xhp +++ b/source/text/scalc/01/04040000.xhp @@ -20,7 +20,7 @@ <meta> <topic id="textscalc0104040000xml" indexer="include"> - <title id="tit" xml-lang="en-US">Insert Columns</title> + <title id="tit">Insert Columns</title> <filename>/text/scalc/01/04040000.xhp</filename> </topic> </meta> @@ -28,31 +28,22 @@ <body> <comment>Marked for deletion later. reworked in shared/ OH</comment> -<bookmark xml-lang="en-US" branch="index" id="bm_id3155628"> +<bookmark branch="index" id="bm_id3155628"> <bookmark_value>spreadsheets; inserting columns</bookmark_value> <bookmark_value>inserting; columns</bookmark_value> <bookmark_value>columns; inserting</bookmark_value> </bookmark> - -<bookmark xml-lang="en-US" branch="hid/.uno:InsertColumnsBefore" id="bm_id601010" localize="false"/> +<bookmark branch="hid/.uno:InsertColumnsMenu" id="bm_id871702136786681" localize="false"/> <h1 id="hd_id3155628"><link href="text/scalc/01/04040000.xhp">Insert Columns</link></h1> -<paragraph id="par_id160220162214111932" role="paragraph" xml-lang="en-US"><variable id="sheet_insert_columns">Inserts columns to the left or to the right of the active cell.</variable> The number of columns inserted corresponds to the number of columns selected. If no column is selected, one column is inserted. The existing columns are moved to the right.</paragraph> - -<h2 id="hd_id160220162139258865">Columns Before</h2> -<paragraph id="par_id3150791" role="paragraph" xml-lang="en-US"><ahelp hid=".uno:InsertColumnsBefore">Inserts a new column before the active cell.</ahelp></paragraph> - +<paragraph id="par_id160220162214111932" role="paragraph"><variable id="sheet_insert_columns">Inserts columns to the left or to the right of the active cell.</variable> The number of columns inserted corresponds to the number of columns selected. If no column is selected, one column is inserted. The existing columns are moved to the right.</paragraph> <section id="howtoget"> -<embed href="text/scalc/00/sheet_menu.xhp#insert_columns_left"/> +<embed href="text/scalc/00/sheet_menu.xhp#insert_columns"/> </section> +<embed href="text/shared/01/InsertColumnsBefore.xhp#insert_columns_before"/> +<embed href="text/shared/01/InsertColumnsAfter.xhp#insert_columns_after"/> -<h2 id="hd_id160220162139252941">Columns After</h2> -<paragraph id="par_id160220162138041164" role="paragraph" xml-lang="en-US"><ahelp hid=".uno:InsertColumnsAfter">Inserts a new column after the active cell.</ahelp></paragraph> - -<section id="howtoget"> -<embed href="text/scalc/00/sheet_menu.xhp#insert_columns_right"/> -</section> </body> </helpdocument> commit 4fd56ae1b229043b9fbcaf035cd19b0a4b5950af Author: Olivier Hallot <[email protected]> AuthorDate: Sat Dec 9 12:10:23 2023 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Sun Dec 10 12:21:21 2023 +0100 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 <[email protected]> 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>
