https://bugs.documentfoundation.org/show_bug.cgi?id=165419
Bug ID: 165419
Summary: Options to shift cells are disabled while deleting a
multiple-range selection
Product: LibreOffice
Version: 25.2.0.0 alpha0+
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Only options to "Delete entire row(s)" and "Delete entire column(s)" are
enabled in the context menu for deleting a multiple-range selection. This is
unsuitable when there are multiple independent tables in the same sheet.
Of course there are workarounds - put tables in separate sheets, or delete
ranges one at a time.
Steps to Reproduce:
1. On one sheet, create a list of 10 items in column A and an independent list
of 5 items in column C, starting in row 1 for each list.
2. Multiple-select cells in row 2 and row 4 of column C, by holding down the
CONTROL key while left-clicking in each cell.
3. Bring up the context menu by right-clicking one of the selected cells.
Actual Results:
The option to "Shift cells up" is disabled. The user can only delete entire
rows or entire columns. Neither action is suitable because it either deletes
the entire list in column C, or unintentionally deletes rows from column A.
Expected Results:
Option to "Shift cells up" is enabled so that only cells in the selected column
are deleted.
Reproducible: Always
User Profile Reset: No
Additional Info:
This should work when ranges span multiple columns and multiple rows, provided
that every selected range occupies the same set of columns or rows, for "shift
cells up" or "shift cells left", respectively.
This is a convenience item - the user should be able to delete multiple ranges
with one context menu operation rather than repetitively open the context menu.
--
You are receiving this mail because:
You are the assignee for the bug.
