diff options
| author | Tünde Tóth <toth.tunde@nisz.hu> | 2021-02-18 09:35:17 +0100 |
|---|---|---|
| committer | László Németh <nemeth@numbertext.org> | 2021-02-25 16:49:33 +0100 |
| commit | 6ab08b3b1026a582352ea018b9d59e91d3e86d92 (patch) | |
| tree | 2cfe282812fcba8522b58fadb7c407fd0f4a47b3 /sc/sdi | |
| parent | ca7855c24af858f52a11a593761ee9e6b9d6ba79 (diff) | |
tdf#36466 sc UI: add new options to deselect hidden cells
Implement "Select Visible Rows Only" option to deselect
the cells of the hidden rows in the actual selection.
Implement "Select Visible Columns Only" option to deselect
the cells of the hidden columns in the actual selection.
Test e.g. on some data on A1:C1:
1) hide column B (don't try to test with autofilter,
because copying of the filtered cells has already
worked this way).
2) Select A1:C1 (2 visible cells)
3) Choose Edit->Select->Select Visible Columns Only
(no visual feedback)
4) Copy the selection.
5) Paste it e.g. in D2: only A1 and C1 are copied,
but not B1.
Change-Id: I354ebdf6be6bddae4440f3e9b4929c6e82abc1df
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/111100
Tested-by: László Németh <nemeth@numbertext.org>
Reviewed-by: László Németh <nemeth@numbertext.org>
Diffstat (limited to 'sc/sdi')
| -rw-r--r-- | sc/sdi/cellsh.sdi | 3 | ||||
| -rw-r--r-- | sc/sdi/scalc.sdi | 19 |
2 files changed, 20 insertions, 2 deletions
diff --git a/sc/sdi/cellsh.sdi b/sc/sdi/cellsh.sdi index cbc20f2f8959..e75d9b3fcc11 100644 --- a/sc/sdi/cellsh.sdi +++ b/sc/sdi/cellsh.sdi @@ -230,7 +230,8 @@ interface CellSelection SID_DEC_INDENT [ ExecMethod = ExecuteEdit; StateMethod = GetState; ] SID_INC_INDENT [ ExecMethod = ExecuteEdit; StateMethod = GetState; ] SID_SELECT_UNPROTECTED_CELLS [ ExecMethod = ExecuteEdit;] - SID_SELECT_VISIBLE_CELLS [ ExecMethod = ExecuteEdit;] + SID_SELECT_VISIBLE_ROWS [ ExecMethod = ExecuteEdit;] + SID_SELECT_VISIBLE_COLUMNS [ ExecMethod = ExecuteEdit;] SID_CURRENT_FORMULA_RANGE [ ExecMethod = ExecuteEdit;] SID_THESAURUS [ ExecMethod = ExecuteEdit; StateMethod = GetCellState; ] diff --git a/sc/sdi/scalc.sdi b/sc/sdi/scalc.sdi index fae369fa24a8..fbbbe1809873 100644 --- a/sc/sdi/scalc.sdi +++ b/sc/sdi/scalc.sdi @@ -4453,7 +4453,24 @@ SfxVoidItem SelectUnprotectedCells SID_SELECT_UNPROTECTED_CELLS GroupId = SfxGroupId::Edit; ] -SfxVoidItem SelectVisibleCells SID_SELECT_VISIBLE_CELLS +SfxVoidItem SelectVisibleRows SID_SELECT_VISIBLE_ROWS +() +[ + AutoUpdate = FALSE, + FastCall = FALSE, + ReadOnlyDoc = TRUE, + Toggle = FALSE, + Container = FALSE, + RecordAbsolute = FALSE, + RecordPerSet; + + AccelConfig = FALSE, + MenuConfig = TRUE, + ToolBoxConfig = FALSE, + GroupId = SfxGroupId::Edit; +] + +SfxVoidItem SelectVisibleColumns SID_SELECT_VISIBLE_COLUMNS () [ AutoUpdate = FALSE, |