Hé Alex,

Seems to work for me if I wait a little longer before releasing the mouse.
Does that work for you too?
(5.3.1.2 and a recent daily both on 64 bits Linux)

ciao - Cor

Created attachment 132064 [details]
moving with alt with empty line between

It doesn't seem to... I mean can you do such thing, that empty line is kept between two when moving with alt?

I see no problem in doing what the attachment shows.

pls give details of your LibreOffice / OS

Both attachment are recorded on KDE Neon with LO 5.3.1.2.
Forgive me, I'm not sure if you get me right, my fault that I haven't described idea properly.
Original feature (moving with alt) is working fine. My suggestion was to add feature to swap fields with alt+shift+drag so field where I move another one is moved to former location not just moved down or right.

Works as expected. You select cells, drag them around, and before dropping you press alt. That swaps target and origin.

There was a ticket some weeks ago talking about the same topic but I don't remember if that was a request to implement this existing feature, to improve it as it is quite hidden, or if there are bugs.

Version: 5.3.1.2
Build ID: 5.3.1-1
CPU Threads: 8; OS Version: Linux 4.10; UI Render: default; VCL: kde4; Layout Engine: new; 
Locale: en-US (en_US.UTF-8); Calc: group

Created attachment 132203 [details]
tried to swap fields with alt

As you can see it doesn't seem to work for me. When moving vertically horizontally it moves destination fields lower (as stated in docs), when moving diagonally when I press alt I've got "unavailable" icon.

Here is version I've got:
Wersja: 5.3.1.2
Build ID: 1:5.3.1-0ubuntu1~xenial0
Wątki CPU: 8; Wersja OS: Linux 4.4; UI Render: domyślny; VCL: gtk2; Układ silnika:nowy; 
Ustawienia regionalne: pl-PL (pl_PL.UTF-8); Calc: group

(In reply to Alex from comment #7)
> As you can see it doesn't seem to work for me. When moving vertically
> horizontally it moves destination fields lower (as stated in docs), when
> moving diagonally when I press alt I've got "unavailable" icon.

True, you cannot swap diagonally. But you can enter 123456 in sequential columns and swap the first three with the last. The same works in vertical order for rows. Makes sense to me that you cannot manipulate diagonal or unrelated cells as it isn't possible to copy/cut those: "This function cannot be used with multiple selection".

Created attachment 132205 [details]
swapping exactly half of fields

Oh, sure, when moving 3 by 3 of 6 fields will be swapped (as on attachment). This is IHMO special case, because we move exactly half of fields.
But idea was to add shift to alt (or maybe change way alt works) to be able to swap 1 and 6 without doing copy-pasta mess.

(In reply to Alex from comment #9)
> Created attachment 132205 [details]
> swapping exactly half of fields
> 
> Oh, sure, when moving 3 by 3 of 6 fields will be swapped (as on attachment).
> This is IHMO special case, because we move exactly half of fields.
> But idea was to add shift to alt (or maybe change way alt works) to be able
> to swap 1 and 6 without doing copy-pasta mess.

Just drop 1-3 onto 4-6. Works like a charm.

Created attachment 132218 [details]
swapping 1 and 6 with help of copy pasta

Currently I'm doing this by:
- select destination field
- ctrl+c
- select source field, drag to destination (without alt)
- select source field again, ctrl+v

Created attachment 132219 [details]
Screencast

It works well, at least from right to left.

From left to right same, but you need to move beyond these 3 fields you move. That seems not-so-intuitive first time but is logical, as fields will be pushed to the left.
But still, when you want to swap (not move) fields that have other fields between it's not doable with alt+drag (doable with drag+copy_pasta as in previous attachment), or I'm missing something...