From 564667de83a40fa53b6dfdbfe3d4e02b81f76d83 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Sat, 9 Dec 2023 21:21:15 -0300 Subject: tdf#155876 UI cmds Calc-Sheet menu (28) + Sheet menu for Calc, delete row/column/breaks + refactoring Change-Id: I0905cfc84ccb9c2e914b4fdd65d4897e6f6f62f6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160527 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit c487633e84637e8b71bb92001f16a2ff4051c11c) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160632 --- source/text/scalc/00/00000402.xhp | 55 ++++++++++++++++++--------- source/text/scalc/00/sheet_menu.xhp | 21 +++++++++-- source/text/scalc/01/02160000.xhp | 60 ++++++++++++++---------------- source/text/scalc/01/02190000.xhp | 3 +- source/text/scalc/01/04020000.xhp | 9 +++-- source/text/scalc/01/04030000.xhp | 10 +++-- source/text/scalc/01/04040000.xhp | 8 ++-- source/text/scalc/main0116.xhp | 11 +++--- source/text/shared/01/DeleteColumns.xhp | 8 ++-- source/text/shared/01/DeleteRows.xhp | 2 +- source/text/swriter/00/00000405.xhp | 66 +++++++++++++++++++++++++-------- 11 files changed, 161 insertions(+), 92 deletions(-) (limited to 'source/text') diff --git a/source/text/scalc/00/00000402.xhp b/source/text/scalc/00/00000402.xhp index 0f09d1dbbe..3c71881376 100644 --- a/source/text/scalc/00/00000402.xhp +++ b/source/text/scalc/00/00000402.xhp @@ -20,7 +20,7 @@ - Edit Menu + Edit Menu /text/scalc/00/00000402.xhp @@ -33,7 +33,7 @@ - Icon Select + Icon Select Select @@ -50,7 +50,7 @@
- Icon Select all Sheets + Icon Select all Sheets Select all Sheets @@ -66,7 +66,7 @@
- Icon Select Sheets + Icon Select Sheets Select Sheets @@ -93,7 +93,7 @@
- Icon Select Row + Icon Select Row Select Row @@ -113,7 +113,7 @@
- Icon Select Column + Icon Select Column Select Column @@ -132,7 +132,7 @@
- Icon Select Data Area + Icon Select Data Area Select Data Area @@ -161,19 +161,40 @@ F2 -Choose Sheet - Fill Cells. -Choose Sheet - Fill Cells - Down. -Choose Sheet - Fill Cells - Right. -Choose Sheet - Fill Cells - Up. -Choose Sheet - Fill Cells - Left. -Choose Sheet - Fill Cells - Sheets. -Choose Sheet - Fill Cells - Series. +Choose Sheet - Fill Cells. +Choose Sheet - Fill Cells - Down. +Choose Sheet - Fill Cells - Right. +Choose Sheet - Fill Cells - Up. +Choose Sheet - Fill Cells - Left. +Choose Sheet - Fill Cells - Sheets. +Choose Sheet - Fill Cells - Series.
-Choose Sheet - Clear Cells. -Backspace +Choose Sheet - Clear Cells. +Backspace +
+ +
+ + Choose Sheet - Delete Cells. + + Choose Delete Cells. + + On the Layout menu of the Layout tab, choose Delete. + +
+ + + Icon Delete Cells + + + Delete Cells + + +
+ + CommandCtrl + "-" -Choose Sheet - Delete Cells.
Choose Edit - Cell Protection to activate sheet protection with current cell protection settings. diff --git a/source/text/scalc/00/sheet_menu.xhp b/source/text/scalc/00/sheet_menu.xhp index e83ae3cf06..01842a167f 100644 --- a/source/text/scalc/00/sheet_menu.xhp +++ b/source/text/scalc/00/sheet_menu.xhp @@ -334,9 +334,24 @@
-Choose Sheet - Delete Page Break. -Choose Sheet - Delete Page Break - Row Break. -Choose Sheet - Delete Page Break - Column Break. +
+ + Choose Sheet - Delete Page Break. +
+ +
+ + Choose Sheet - Delete Page Break - Row Break. + + On the Layout menu of the Layout tab, choose Row Break. +
+ +
+ + Choose Sheet - Delete Page Break - Column Break. + + On the Layout menu of the Layout tab, choose Column Break. +
Choose Sheet - Cell Comments - Edit Comment Choose Sheet - Cell Comments - Hide Comment diff --git a/source/text/scalc/01/02160000.xhp b/source/text/scalc/01/02160000.xhp index f5e9ddbc84..9a3ca08878 100644 --- a/source/text/scalc/01/02160000.xhp +++ b/source/text/scalc/01/02160000.xhp @@ -1,7 +1,4 @@ - - - - - - + -Delete Cells +Delete Cells /text/scalc/01/02160000.xhp -
-cells; deleting cells +cells; deleting cells columns; deleting rows; deleting spreadsheets; deleting cells @@ -40,42 +34,42 @@ MW made one "deleting;" entry out of 3 - - - -

Delete Cells

- Completely deletes selected cells, columns or rows. The cells below or to the right of the deleted cells will fill the space. - Note that the selected delete option is stored and reloaded when the dialog is next called. -
+ + + +
+

Delete Cells

+ Completely deletes selected cells, columns or rows. The cells below or to the right of the deleted cells will fill the space. Note that the selected delete option is stored and reloaded when the dialog is next called. +
- - - +
- Delete cells dialog +

Selection

- This area contains options for specifying how sheets are displayed after deleting cells. + This area contains options for specifying how sheets are displayed after deleting cells. - +

Shift cells up

- Fills the space produced by the deleted cells with the cells underneath it. + Fills the space produced by the deleted cells with the cells underneath it. - +

Shift cells left

- Fills the resulting space by the cells to the right of the deleted cells. + Fills the resulting space by the cells to the right of the deleted cells. - - -

Delete entire row(s)

- After selecting at least one cell, deletes the entire row from the sheet. - - + + +

Delete entire row(s)

+ After selecting at least one cell, deletes the entire row from the sheet. +This command is equivalent to . + +

Delete entire column(s)

- After selecting at least one cell, deletes the entire column from the sheet. + After selecting at least one cell, deletes the entire column from the sheet. + This command is equivalent to .
- Deleting Contents + Deleting Contents
diff --git a/source/text/scalc/01/02190000.xhp b/source/text/scalc/01/02190000.xhp index 20f3be084e..18e04f8c87 100644 --- a/source/text/scalc/01/02190000.xhp +++ b/source/text/scalc/01/02190000.xhp @@ -27,9 +27,8 @@ -
- +

Delete Page Break

Choose the type of page break that you want to delete.
diff --git a/source/text/scalc/01/04020000.xhp b/source/text/scalc/01/04020000.xhp index 3664649954..05766c6ff7 100644 --- a/source/text/scalc/01/04020000.xhp +++ b/source/text/scalc/01/04020000.xhp @@ -30,9 +30,12 @@ -

Insert Cells

-Opens the Insert Cells dialog, in which you can insert new cells according to the options that you specify. - You can delete cells by choosing Edit - Delete Cells. + +
+

Insert Cells

+ Opens the Insert Cells dialog, in which you can insert new cells according to the options that you specify. +
+You can delete cells by choosing Edit - Delete Cells.
diff --git a/source/text/scalc/01/04030000.xhp b/source/text/scalc/01/04030000.xhp index 649578f9a2..270c1f933a 100644 --- a/source/text/scalc/01/04030000.xhp +++ b/source/text/scalc/01/04030000.xhp @@ -26,16 +26,18 @@ -Marked for deletion later. reworked in shared/ OH - spreadsheets; inserting rows rows; inserting inserting; rows -

Insert Rows

-Insert rows above or below the active cell. 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. + +
+

Insert Rows

+ Insert rows above or below the active cell. 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. +
+
diff --git a/source/text/scalc/01/04040000.xhp b/source/text/scalc/01/04040000.xhp index c5ad8d00e8..2ebdc59881 100644 --- a/source/text/scalc/01/04040000.xhp +++ b/source/text/scalc/01/04040000.xhp @@ -26,8 +26,6 @@ -Marked for deletion later. reworked in shared/ OH - spreadsheets; inserting columns inserting; columns @@ -35,8 +33,10 @@ -

Insert Columns

-Inserts columns to the left or to the right of the active cell. 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. +
+

Insert Columns

+ Inserts columns to the left or to the right of the active cell. 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. +
diff --git a/source/text/scalc/main0116.xhp b/source/text/scalc/main0116.xhp index 8429f13583..a009981faf 100644 --- a/source/text/scalc/main0116.xhp +++ b/source/text/scalc/main0116.xhp @@ -36,14 +36,15 @@
-

Insert Rows

- -

Insert Columns

- + + + - + + + diff --git a/source/text/shared/01/DeleteColumns.xhp b/source/text/shared/01/DeleteColumns.xhp index 03c0950981..f28a7f4f73 100644 --- a/source/text/shared/01/DeleteColumns.xhp +++ b/source/text/shared/01/DeleteColumns.xhp @@ -17,10 +17,10 @@ -
-

Columns

- Deletes the selected columns. -
+
+

ColumnsDelete Columns

+ Deletes the selected columns. +
diff --git a/source/text/shared/01/DeleteRows.xhp b/source/text/shared/01/DeleteRows.xhp index 68bdc090e0..2075f8e195 100644 --- a/source/text/shared/01/DeleteRows.xhp +++ b/source/text/shared/01/DeleteRows.xhp @@ -18,7 +18,7 @@
-

Rows

+

RowsDelete Rows

Deletes the selected rows.
diff --git a/source/text/swriter/00/00000405.xhp b/source/text/swriter/00/00000405.xhp index 5ba0c91c2c..0a10a3ad8e 100644 --- a/source/text/swriter/00/00000405.xhp +++ b/source/text/swriter/00/00000405.xhp @@ -337,12 +337,31 @@ Choose Table - Select - Row.
- - Choose Table - Delete - Rows. - - Choose Delete - Rows. - - Choose Table - Delete Rows. + + + + Choose Table - Delete - Rows. + + Choose Delete - Rows. + + Choose Table - Delete Rows. + + Choose Properties - Table - Delete Rows. + + + + Choose Sheet - Delete Rows. + + Choose Home - Row - Delete Rows. + Choose Layout - Row - Delete Rows. + + + + + + + +
@@ -356,8 +375,6 @@
- - Choose Properties - Table - Delete Rows.
In the context menu of a cell, choose Column. @@ -377,12 +394,31 @@
- - Choose Table - Delete - Columns. - - choose Delete - Columns. - - Choose Table - Delete Columns. + + + + Choose Table - Delete - Columns. + + choose Delete - Columns. + + Choose Table - Delete Columns. + + Choose Properties - Table - Delete Columns. + + + + Choose Sheet - Delete Columns. + + Choose Home - Column - Delete Columns. + Choose Layout - Column - Delete Columns. + + + + + + + +
@@ -396,8 +432,6 @@
- - Choose Properties - Table - Delete Columns.
-- cgit