drag and drop cells in calc

[elyod_72]

I am a newbie to NeoOffice and have a really silly question. How do you drag and drop from cell to cell in the calc section?

I can't find anything in the help section about drag and drop inside a spreadsheet.

Any advice is appreciated.

[mickeyinlalaland]

Chapter 4 of the NeoOffice User Guide discusses drag and drop in Calc

It can be found on the left of this page; 4th box down in: 'Download NeoOffice' box; 4th item 'User Guide'

[jgd]

If I well remember, it concerned the Data Pilot. Maybe it's not what elyod_72 is looking for.

There is a way to drag and drop a cell range. I don't remember if it's mentioned in the NUG.

Select the range you want to drag/drop.
Go to Data > Define Range…
Give the range a name, e.g. test, click Add, click OK.

Open the Navigator: Edit > Navigator. Expand Database Ranges. Control-click on test. In the contextual menu, select Drag Mode > Insert as Copy.

When you want drag and drop the range, go to Data > Select Range… select test, click OK.
The range is selected, you can drag and drop it.

A bit tricky, but it works. You see, it's not a silly question . Maybe someone else knows a better way to do that?

Jacqueline

[elyod_72]

Thanks for the quick reply.

I took a look at the manual and I found drag and drop from a database into a spreadsheet, but not how to move text from one cell to another by drag and drop.

I have found how in navigator to copy or link base on using the little square at the bottom right of the cell. Bug again no move.

[jgd]

Just have a look at my previous post. We've posted at the same time

Jacqueline

[elyod_72]

Thanks Jacqueline for your post.

If that is the case I will stick to standard copy and paste functions. I was just looking for a quick way to move cells via drag and drop.
But it sounds like NeoOffice currently does not have that capacity.

[yoxi]

Maybe I'm missing something here, but if I select a range of cells and then click-and-drag with my mouse, they move to wherever I drop them. This is NO 2.2.2 patch 11 with 10.5.2 intel. Is this not working for you?

If you're trying to move just one cell at a time, you just need to shift-click on it to select it before dragging it.

- padmavyuha

[elyod_72]

Sorry I probibally should have given my specs earlier. I am running 2.2.2 patch 11 on a PPC.



No soup for me?

[yoxi]

What happens when you select a few cells and then try to drag them (i.e. click-and-hold the mouse button, and then begin to drag)? When I do it, the cursor changes to a hand - do you not get that when you do it? It won't work for an individual cell unless you select it first by shift-clicking, as I described.

What do you see when you try to do this?

[elyod_72]

That did it. I was not shift clicking on an individual cell. It worked when I did that.

Thanks for the help!

[yoxi]

Whew! Mazeltov...

[pfb3d]

[jgd]

[yoxi]

Good idea - I'm using a fast macbook, so the lag is minimal, but it may be more significant on slower macs. Certainly there appears to be a built-in delay between clicking on selected cells and the cursor changing to a hand - I suppose this is to prevent accidental dragging.

[jgd]

It's not my iMac which is slooooow, it's me .

And I just rediscovered America
When you select a cell range, release the mouse (a breath again), press the Opt key, click on a cell (empty or not), the range is copied without being deleted, just added.
The note will be a bit longer

Jacqueline