Bug 89333 - EDITING: Cannot shift cells (left or up) from a non contiguous selection when deleting
Summary: EDITING: Cannot shift cells (left or up) from a non contiguous selection when...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Management
  Show dependency treegraph
 
Reported: 2015-02-12 11:17 UTC by mloc
Modified: 2023-11-21 11:21 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
screenshot, non-contiguous selection and contextual "Delete" menu (lang: FR) (39.78 KB, image/png)
2015-02-12 11:17 UTC, mloc
Details

Note You need to log in before you can comment on or make changes to this bug.
Description mloc 2015-02-12 11:17:31 UTC
Created attachment 113339 [details]
screenshot, non-contiguous selection and contextual "Delete" menu (lang: FR)

Overview:
When deleting cells, "Shift cells up" and "shift cells left" (translation may vary) options are not available as soon as the selection is more complex than a single rectangle.

Steps to Reproduce:
1. Create new Calc sheet
2. Add content in several columns, eg. A1: "One", B1: "Two",... E1: "Five"
2. Select B1 and D1
3. Right clic > Delete... 

Actual Results:
Options "Shift cells left" and "shift cells up" are disabled (grayed out)

Expected Results:
Options should not be disabled, ie. action "Shift cells left" should leave cells A1: "One", B1: "Three", C1: "Five".

Additional Information:
It should be noted that Microsoft Excel's own "shift cells" works the expected way.
Comment 1 raal 2015-02-12 11:48:00 UTC
I can confirm with LO 4.4
Setting as enhancement
Comment 2 Stéphane Guillou (stragu) 2023-11-21 11:15:11 UTC
Still relevant:

Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: baecfd21797310bb15ab98ca3962445d99e397db
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

Same in OOo 3.3.