[3.4.4/Windows] How to move cell with mouse?

classic Classic list List threaded Threaded
19 messages Options
Gilles Gilles
Reply | Threaded
Open this post in threaded view
|

[3.4.4/Windows] How to move cell with mouse?

Hello,

I want to move cell A1 to A2 with the mouse:

I select A1, then press Alt, and move the cell with the mouse: Nothing happens

I select A1, then press Ctrl, and move the cell with the mouse: A2 is also selected and nothing happens

Also tried Shift, Ctrl+Shift, Alt+Ctrl, etc.: Doesn't work

How can I drag and drop a cell with the mouse?

As a temporary solution, I just Cut (Ctrl+X) and Paste (Ctrl+V).

I read this, but I can't figure it out.
http://help.libreoffice.org/Calc/Moving_Cells_by_Drag-and-Drop

Thank you.
Jack Jack
Reply | Threaded
Open this post in threaded view
|

Re: [3.4.4/Windows] How to move cell with mouse?

Gilles wrote:
> I want to move cell A1 to A2 with the mouse:

This is easy enough.  You just select the cell, and then
click-and-drag it - you don't need to press any keys on the keyboard.
The trick is to actually *select* the cell.

Try this:
To move A1:A2 to B3:B4, simply select A1:A2 and click-and-drag A1:A2 to B3:B4.

To move A1 to A2 (which was your original question), click on A1
(don't release the mouse button yet).  Then drag the mouse down (or to
the side) to select more than one cell (still don't release the mouse
button).  Then drag the mouse back to A1 (while still holding the
mouse button).  When the mouse is over A1, you can release the mouse
button again.  Now A1 is actually *selected*.  You can now drag A1 to
A2 (or wherever you wanted it).

In the examples above, you could also use the keyboard to select the
cell.  To do this, hold down shift, press down, press up and release
shift.  Now you can drag the cell to wherever you want.

Regards
Stephan

--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Dan Lewis Dan Lewis
Reply | Threaded
Open this post in threaded view
|

Re: [3.4.4/Windows] How to move cell with mouse?

In reply to this post by Gilles
On Wed, 2012-01-11 at 04:45 -0800, Gilles wrote:

> Hello,
>
> I want to move cell A1 to A2 with the mouse:
>
> I select A1, then press Alt, and move the cell with the mouse: Nothing
> happens
>
> I select A1, then press Ctrl, and move the cell with the mouse: A2 is also
> selected and nothing happens
>
> Also tried Shift, Ctrl+Shift, Alt+Ctrl, etc.: Doesn't work
>
> How can I drag and drop a cell with the mouse?
>
> As a temporary solution, I just Cut (Ctrl+X) and Paste (Ctrl+V).
>
> I read this, but I can't figure it out.
> http://help.libreoffice.org/Calc/Moving_Cells_by_Drag-and-Drop
>
> Thank you.
>
> --
> View this message in context: http://nabble.documentfoundation.org/3-4-4-Windows-How-to-move-cell-with-mouse-tp3650473p3650473.html
> Sent from the Users mailing list archive at Nabble.com.
>

     I'm not sure you can move just one cell. Two or more cells can be
moved by clicking on the first cell and then selecting the rest to the
cells. Then this group of cells can be moved in the various ways that
Help describes.
     If there is an empty cell adjacent to the cell you want to move,
then you can move these two cells together. But that obviously has some
draw backs.

--Dan


--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Gilles Gilles
Reply | Threaded
Open this post in threaded view
|

Re: [3.4.4/Windows] How to move cell with mouse?

In reply to this post by Jack
Thanks, but it doesn't work. When I select A1, unclick (ie. remove my finger from the left button on the mouse) then move the mouse to A2, it simply selects A1 and A2, it doesn't move A1 to A2. I also tried keeping the left button clicked while I moved to A2, but it also selects the two cells instead of moving A1 to A2.

Is there a video that shows how to perform such a simple task?

Thank you.
Gilles Gilles
Reply | Threaded
Open this post in threaded view
|

Re: [3.4.4/Windows] How to move cell with mouse?

In reply to this post by Gilles
This thread (from 2007!) explains how to move a single cell

http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=886

It clumsy, counter-intuitive, but it works.

Thank  you.
Jack Jack
Reply | Threaded
Open this post in threaded view
|

Re: [3.4.4/Windows] How to move cell with mouse?

In reply to this post by Gilles
Gilles wrote:
> Thanks, but it doesn't work. When I select A1, unclick (ie. remove my finger
> from the left button on the mouse) then move the mouse to A2, it simply
> selects A1 and A2, it doesn't move A1 to A2. I also tried keeping the left
> button clicked while I moved to A2, but it also selects the two cells
> instead of moving A1 to A2.

Are you sure you followed the steps I described carefully?  When you
select A1 and A2 (before releasing the button), drag the mouse back to
A1 and then release the button.  Then A1 should be blue.  Then you
drag A1 to A2.

Regards
Stephan

--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Tom Tom
Reply | Threaded
Open this post in threaded view
|

Re: [3.4.4/Windows] How to move cell with mouse?

Hi :)
Sadly you have to "do the LibreOffice shuffle" as one person put it.  You can't move single cells on their own but can move blocks of at least 2 cells.  It's a bit weird but soon you hardly even notice yourself working around the issue. 
Regards from
Tom :)


--- On Wed, 11/1/12, Stephan Zietsman <[hidden email]> wrote:

From: Stephan Zietsman <[hidden email]>
Subject: Re: [libreoffice-users] Re: [3.4.4/Windows] How to move cell with mouse?
To: [hidden email]
Date: Wednesday, 11 January, 2012, 13:51

Gilles wrote:
> Thanks, but it doesn't work. When I select A1, unclick (ie. remove my finger
> from the left button on the mouse) then move the mouse to A2, it simply
> selects A1 and A2, it doesn't move A1 to A2. I also tried keeping the left
> button clicked while I moved to A2, but it also selects the two cells
> instead of moving A1 to A2.

Are you sure you followed the steps I described carefully?  When you
select A1 and A2 (before releasing the button), drag the mouse back to
A1 and then release the button.  Then A1 should be blue.  Then you
drag A1 to A2.

Regards
Stephan

--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Ian Whitfield Ian Whitfield
Reply | Threaded
Open this post in threaded view
|

Re: [3.4.4/Windows] How to move cell with mouse?

On 11/01/2012 17:37, Tom Davies wrote:
> Sadly you have to "do the LibreOffice shuffle" as one person put it.  You can't move single cells on their own......

YES you can Tom!!

Just read the instructions that were given.... Select the cell you want
to move, keep the mouse button down and select a second cell. Still
keeping the mouse button down move back to the original cell. Now let go
of the mouse button, the cell will be highlighted.

Now click on the highlighted cell and drag n' drop it where you want.

IT DOES WORK (I just confirmed it with a test)!!!

Ian Whitfield
Pretoria

--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Alan Boba Alan Boba
Reply | Threaded
Open this post in threaded view
|

Re: [3.4.4/Windows] How to move cell with mouse?

In reply to this post by Gilles
On Wed, Jan 11, 2012 at 7:45 PM, Gilles <[hidden email]> wrote:

> Hello,
>
> I want to move cell A1 to A2 with the mouse:
>
> This stumped me for ages, then I found the solution.

1. Move cell pointer to desired cell
2. Press Ctrl
3. Click on desired cell (note: Click, not Click and hold)
4. Release Ctrl
5. Click and hold to drag highlighted cell to new destination

:-)

--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Bad2theBone Bad2theBone
Reply | Threaded
Open this post in threaded view
|

Re: [3.4.4/Windows] How to move cell with mouse?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 01/11/2012 11:09 AM, Alan Boba wrote:

> On Wed, Jan 11, 2012 at 7:45 PM, Gilles <[hidden email]>
> wrote:
>
>> Hello,
>>
>> I want to move cell A1 to A2 with the mouse:
>>
>> This stumped me for ages, then I found the solution.
>
> 1. Move cell pointer to desired cell 2. Press Ctrl 3. Click on
> desired cell (note: Click, not Click and hold) 4. Release Ctrl 5.
> Click and hold to drag highlighted cell to new destination
>
> :-)
>
Using these instructions work for me as well. Fedora 16, LXDE, LO 3.4.4
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQIcBAEBAgAGBQJPDcHhAAoJEIefqZ0kni1dzQoP/idiBn7r8SKdr7EltudRoiYP
m/Lt1+aLX1YiD14LQXN/wwvND+JKpceRgp4AnZyWWwM/iIqLbU7a8M8hAx1yj0n4
3j6uB2ntW5xzmymNaOTP8ReTn2LtHLYdVYD6RbvPadXUWCvAWl+S+JRHG6jT/FEn
QksLDtIUwCHzRqhHeueXxk7zFL4gMQ1b+9Nzkq3Q0qPayyKAUVdE2ewR84soA7lG
vkf7awmJV4vRzh+1VhpyLMdIEOYKljiEKVAqTK5sFgbZub17s3RqMVKOP0zL9hoB
OFFqI9M9Po927D2DcdaxIbdNYF0vTdXJvV6PwLQil1oqRvFrPLQ2vSnX034DVK/J
k/DJyhKz2EPEB6xXTt3JVoGVJzRI38zeqezuxP/kECDUU8Sq3fFnuWsMg/I0oMC9
W/1elUdOUeMcJV/qxc1C8qJZt2I4Z3SQHvyiTo60s585wRn2UO1h6mGkXhvUsFuE
AUy5a72KffLzxAeETqMJWYHD09ytpUv7fvhgHNE1u1cHOi35hlugMgwQ8cphceYd
jVchmkxg2VqaWcpyU+RPrFmbuEC58XRKT3CHE1/AtmNg6yhNuuXtHFd1zb2nKWIX
imEelpqJlxYqdlbeV8UD3dIKXw9mcdtX9z23DLBMcR0ZJUz0EICJMXLz0zIVQuWy
xuBmQ1HMEIvqrak0YmeE
=nYY1
-----END PGP SIGNATURE-----

--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Hey! I was born confused, what's your excuse?
Pedro Pedro
Reply | Threaded
Open this post in threaded view
|

Re: [3.4.4/Windows] How to move cell with mouse?

In reply to this post by Gilles
This is a know limitation since the OpenOffice days.

The good news is that an *enhancement request* is already on the Bugzilla tracker
https://bugs.freedesktop.org/show_bug.cgi?id=38994

and it has been assigned to Kohei Yoshida (Calc's guru) and included in the "LibreOffice 3.4 most annoying bugs"
https://bugs.freedesktop.org/show_bug.cgi?id=35673

So, it's not fixed yet but it will be soon(ish) ;)
Gérard Fargeot Gérard Fargeot
Reply | Threaded
Open this post in threaded view
|

Re: [3.4.4/Windows] How to move cell with mouse?

Hi,


> Message du 11/01/12 18:16
> De : "Pedro"
> A : [hidden email]
> Copie à :
> Objet : [libreoffice-users] Re: [3.4.4/Windows] How to move cell with mouse?
>
> This is a know limitation since the OpenOffice days.
>
> The good news is that an *enhancement request* is already on the Bugzilla
> tracker
> https://bugs.freedesktop.org/show_bug.cgi?id=38994
>

IMHO, it is not a good news.
Drag cells by clic on a tiny border instead of anywhere in the cell is *not* an improvement :(

Gérard
--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Tractor Tractor
Reply | Threaded
Open this post in threaded view
|

Re: [3.4.4/Windows] How to move cell with mouse?

In reply to this post by Ian Whitfield


On 01/11/2012 10:54 AM, Ian Whitfield wrote:

> On 11/01/2012 17:37, Tom Davies wrote:
>> Sadly you have to "do the LibreOffice shuffle" as one person put it.  
>> You can't move single cells on their own......
>
> YES you can Tom!!
>
> Just read the instructions that were given.... Select the cell you
> want to move, keep the mouse button down and select a second cell.
> Still keeping the mouse button down move back to the original cell.
> Now let go of the mouse button, the cell will be highlighted.
>
> Now click on the highlighted cell and drag n' drop it where you want.
>
> IT DOES WORK (I just confirmed it with a test)!!!
>
> Ian Whitfield
> Pretoria
>
Hi,

I never knew you could do that either. In OpenOffice, and then in
LibreOffice, I always had to highlight two to move them. But this method
of moving just one does work!!!!! I jut tested it.

Don

--



**


--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Tractor Tractor
Reply | Threaded
Open this post in threaded view
|

Re: [3.4.4/Windows] How to move cell with mouse?

In reply to this post by Alan Boba


On 01/11/2012 11:09 AM, Alan Boba wrote:

> On Wed, Jan 11, 2012 at 7:45 PM, Gilles<[hidden email]>  wrote:
>
>> Hello,
>>
>> I want to move cell A1 to A2 with the mouse:
>>
>> This stumped me for ages, then I found the solution.
> 1. Move cell pointer to desired cell
> 2. Press Ctrl
> 3. Click on desired cell (note: Click, not Click and hold)
> 4. Release Ctrl
> 5. Click and hold to drag highlighted cell to new destination
>
> :-)
>
Hi,

Works very well for me also. Now I've learned two new ways today!!!!!! :)

Don
--


**


--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Tom Tom
Reply | Threaded
Open this post in threaded view
|

Re: [3.4.4/Windows] How to move cell with mouse?

Hi :)
Superb!  2 new ways for me too :)
Many thanks and regards from
Tom :)



--- On Wed, 11/1/12, Don C. Myers <[hidden email]> wrote:

From: Don C. Myers <[hidden email]>
Subject: Re: [libreoffice-users] [3.4.4/Windows] How to move cell with mouse?
To: [hidden email]
Date: Wednesday, 11 January, 2012, 18:09



On 01/11/2012 11:09 AM, Alan Boba wrote:

> On Wed, Jan 11, 2012 at 7:45 PM, Gilles<[hidden email]>  wrote:
>
>> Hello,
>>
>> I want to move cell A1 to A2 with the mouse:
>>
>> This stumped me for ages, then I found the solution.
> 1. Move cell pointer to desired cell
> 2. Press Ctrl
> 3. Click on desired cell (note: Click, not Click and hold)
> 4. Release Ctrl
> 5. Click and hold to drag highlighted cell to new destination
>
> :-)
>
Hi,

Works very well for me also. Now I've learned two new ways today!!!!!! :)

Don
--


**


--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Pedro Pedro
Reply | Threaded
Open this post in threaded view
|

Re: [3.4.4/Windows] How to move cell with mouse?

In reply to this post by Gérard Fargeot
Gérard Fargeot wrote
IMHO, it is not a good news.
Drag cells by clic on a tiny border instead of anywhere in the cell is *not* an improvement :(
This is the way all spreadsheets work. Clicking on the center of the cell is supposed to enter Edit mode.

In any case the "clickable" area is defined by the programmers (in Excel it's around 5 pixels wide, which is plenty) so even if you have a very thin border, you have a larger area to click on.

A small correction to my previous post: this "enhancement" is NOT on the "LibreOffice 3.4 most annoying bugs" :( It should be though ;)
Gilles Gilles
Reply | Threaded
Open this post in threaded view
|

Re: [3.4.4/Windows] How to move cell with mouse?

In reply to this post by Jack
Jack wrote
Are you sure you followed the steps I described carefully?  When you select A1 and A2 (before releasing the button), drag the mouse back to A1 and then release the button.  Then A1 should be blue.  Then you
drag A1 to A2.
Ok, I got it. I find it very counter-intuitive (selecting two cells to move one cell?), but it worked. Thank you.
Jack Jack
Reply | Threaded
Open this post in threaded view
|

Re: [3.4.4/Windows] How to move cell with mouse?

In reply to this post by Alan Boba
Alan Boba wrote:
> 1. Move cell pointer to desired cell
> 2. Press Ctrl
> 3. Click on desired cell (note: Click, not Click and hold)
> 4. Release Ctrl
> 5. Click and hold to drag highlighted cell to new destination

I think this method is better than the one I described.  Thanks for
pointing it out.  Just make sure not to skip step 1.

Regards
Stephan

--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Jack Jack
Reply | Threaded
Open this post in threaded view
|

Re: [3.4.4/Windows] How to move cell with mouse?

In reply to this post by Alan Boba
Alan Boba wrote:
> 1. Move cell pointer to desired cell
> 2. Press Ctrl
> 3. Click on desired cell (note: Click, not Click and hold)
> 4. Release Ctrl
> 5. Click and hold to drag highlighted cell to new destination

For the sake of completeness, let me add that you could also use the
Shift key instead of the Ctrl key.  So then it would look like this:
1. Click on the cell you want to move
2. Shift+click on the same cell (hold shift, click on the cell, release shift)
3. Click and drag the cell to where you want it

--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted