Bug 89333

Summary: EDITING: Cannot shift cells (left or up) from a non contiguous selection when deleting
Product: LibreOffice Reporter: mloc <info>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: raal, stephane.guillou
Priority: medium    
Version: Inherited From OOo   
Hardware: All   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=55963
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108364    
Attachments: screenshot, non-contiguous selection and contextual "Delete" menu (lang: FR)

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.