Bug 101101 - Drag and Drop of single cell in Calc does not work
Summary: Drag and Drop of single cell in Calc does not work
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.4.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-07-24 17:42 UTC by Richard A Blaine
Modified: 2016-11-27 17:32 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Richard A Blaine 2016-07-24 17:42:43 UTC
User-Agent:       Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36
Build Identifier: LibreOffice 5.1.4.2

Drag and drop of single cell does not work.  If two or more cells are selected - works ok.  Happens moving to new column or row.

Reproducible: Always

Steps to Reproduce:
1.select a single cell in calc
2.drag and drop on new location
3.original and new cell location are highlighted but content of original cell is not moved
Actual Results:  
see above

Expected Results:  
content of original cell should appear in new location

[Information automatically included from LibreOffice]
Locale: en-US
Module: StartModule
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Running Windows 10 - 64 bit.
This problem has appeared in past few releases 


Reset User Profile?No
Comment 1 m_a_riosv 2016-07-24 21:49:53 UTC
I can't reproduce.
Win10x64
Version: 5.1.5.1 (x64)
Build ID: bb431b2be5fb7772067efc27a3cc98b6927c7b4c
CPU Threads: 1; OS Version: Windows 6.19; UI Render: default; 
Locale: es-ES (es_ES); Calc: CL
Comment 2 Buovjaga 2016-07-29 07:20:25 UTC
Not reproduced.

Richard: do you have OpenGL enabled? It becomes apparent, if you copy and paste the contents of Help - About LibreOffice.

64-bit, KDE Plasma 5
Build ID: 5.1.4.2 Arch Linux build-1
CPU Threads: 8; OS Version: Linux 4.6; UI Render: default; 
Locale: fi-FI (fi_FI.UTF-8)
Comment 3 Jean-Baptiste Faure 2016-09-18 16:11:22 UTC
Not reproducible for me with Version: 5.2.3.0.0+
Build ID: 8c20df32c8278bc4a076cef285db7788627f4c07
Threads CPU : 4; Version de l'OS :Linux 4.4; UI Render : par défaut; 
Ubuntu_16.04_x86-64
Locale : fr-FR (fr_FR.UTF-8); Calc: single

Please, could you answer the question in comment #2 ?

Set status to NEEDINFO, please set it back to UNCONFIRMED once requested
informations are provided.

Best regards. JBF
Comment 4 Richard A Blaine 2016-09-18 17:34:22 UTC
I have not specifically enabled OpenGL.
Following is the text I copied from About LibreOffice as per comment 3 request:

Version: 5.1.4.2
Build ID: f99d75f39f1c57ebdd7ffc5f42867c12031db97a
CPU Threads: 8; OS Version: Windows 6.2; UI Render: default; 
Locale: en-US (en_US)
                  5
LibreOffice is a modern, easy-to use, open source 
productivity suite for word processing, spreadsheets,
presentations and more.

This release was supplied by the Document Foundation
Copyright c 2000-2016 LibreOffice contributors.
LibreOffice was based on OpenOffice.org

CREDITS   WEBSITE                     CLOSE
Comment 5 Carlo 2016-09-18 17:45:17 UTC
Not reproducible with LO 5.2.2.1 (x64) under Windows 10.
Comment 6 Buovjaga 2016-09-18 18:25:48 UTC
Thanks, Richard. It might be some glitch. You can try this: https://wiki.documentfoundation.org/UserProfile#Resolving_corruption_in_the_user_profile
Comment 7 m_a_riosv 2016-11-20 23:19:56 UTC
Please, how do you exactly select the cell?
Comment 8 Richard A Blaine 2016-11-21 01:56:38 UTC
I select the cell by left clicking on it.  I then click again in an effort to drag it to another location and all that happens is that both the cell I clicked and the cell to which I am attempting to move the original cell are both highlighted and selected.

I have also tried selecting the cell by using the arrow keys with the same result

On the other hand if I select two or more cells both are selected and highlighted and I am able to drag these to another location.
Comment 9 m_a_riosv 2016-11-26 23:45:13 UTC
I think you are no selecting the cell, but positioned on it.

Please take a look on how to do it.

https://help.libreoffice.org/Calc/Selecting_Multiple_Cells#Mark_a_single_cell
Comment 10 Richard A Blaine 2016-11-27 17:13:14 UTC
You are quite correct.
I used Excel from Office 2003 for many years and the behavior is quite different.
In my case clicking on a cell creates a bold, black border. That is what I had been doing and found that the contents of the cell did not drag and drop. Ctrl-click or Shift-click highlights the cell in light blue then pressing the left mouse button does move the content of that cell.

It is interesting that if two or more cells are selected then it is not necessary to ctrl-click or shift-click in order to drag and drop.  Inconcistancy?

Many thanks for your persistence and resolution to my issue.