Bug 137373

Summary: Editing: Cannot drag selected spreadsheet cell
Product: LibreOffice Reporter: wallington136
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal    
Priority: medium    
Version: 6.4.6.2 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Move Single Cell in LibreOffice 6.4.6.2

Description wallington136 2020-10-09 12:03:27 UTC 
Description:
Cannot select and and drag single cells in spreadsheets. Selecting two or more cells and dragging them to a new location works fine. 
at.

Steps to Reproduce:
1.Select single cell
2. Click on cell and try to drag it to another location within the speadsheet.
3.

Actual Results:
Cannot move cell

Expected Results:
Contents of cell should move to new selected location


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Saving files in XLS format.

Libre Office:
Version 6.4.6.2 (x64)
Build: 0ce51a4fd21bff07a5c061082cc82c5ed232f115
Windows 10, Build 18363
Comment 1 [REDACTED] 2020-10-09 14:18:02 UTC 
No repro using

Version: 6.4.6.2; Build ID: 0ce51a4fd21bff07a5c061082cc82c5ed232f115
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US; Calc: threaded

However this looks like a usage problem. To select a single cell for being dragged, user needs to 

- click the cell
- move mouse pointer to a neighboring cell (while left mouse key pressed) 
- move back to original cell (still left mouse key pressed) 

=> Cell to be moved turns its color to same color like a selection of a whole range and can be moved.
Comment 2 wallington136 2020-10-09 21:23:56 UTC 
Hi,

Thanks for the feedback, but i believe is it a bug or a short coming. 

I agree your action works for a range of cells, but it involves a minimum of 2 cells. I often want to move/drag a single cell (including it's data content) not a range, typically when developing a new spreadsheet model. For me (at least)  the process you describe does not work as you have to select at least 2 cells (original + adjacent) which then both move when dragged to another part of the spreadsheet. Other spreadsheets i have used support the ability to move a single cell.

Hope this helps clarify my point.
Comment 3 [REDACTED] 2020-10-09 22:07:32 UTC 
(In reply to wallington136 from comment #2)
> Hi,
> 

> I agree your action works for a range of cells, but it involves a minimum of
> 2 cells. 

No I'm not talking about a range of more than one cells, the procedure described in my comment is about a single cell. Keep left mouse  pressed and move one step down and one step up and the *single* cell turn its color. and you can move it. Essentially clicking to a cell doesn't select it. You need to perform a mouse move right - left, up - down, down - up or left - right (which one doesn't matter) and then the *single* cell is selected and can be moved. If this procedure doesn't work, it might be a bug (likely not tested on same LibreOffice version like you).
Comment 4 [REDACTED] 2020-10-09 22:17:00 UTC 
Created attachment 166248 [details]
Move Single Cell in LibreOffice 6.4.6.2

Please see also the attachment demonstrating my last comment.
Comment 5 [REDACTED] 2020-10-09 22:26:04 UTC 
You could also use: Click the cell, Press CTRL key and click once more into the cell.
Comment 6 wallington136 2020-10-10 14:00:43 UTC 
Ok, i now understand and can move a cell using both methods you describe. Many thanks for your patience and guidance.

I use spreadsheets a lot, just fairly new to LibreOffice. I hope to be able to usefully (as opposed to this first attempt) contribute to its development over time through use and testing and providing feedback accordingly.