Bug 48165

Summary:	Drag and Drop with move/insert (ALT) does not handle partial column offset
Product:	LibreOffice	Reporter:	dcreid
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	minor	CC:	bfo.bugmail, sasha.libreoffice
Priority:	medium
Version:	3.5.2 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description dcreid 2012-04-01 10:54:15 UTC

Sample scenario:

Select a two by two range of cells.
Click and drag these cells up to a new location while holding the ALT key.
Shift one cell to the left or right and the pointer shifts to a "not allowed" icon.
Shift two cells to the left or right (completely outside of the originally selected columns) and the move/insert is allowed.
Stay within the originally selected columns and the move/insert is allowed.

Note that this does not happen if dragging BELOW the original location, only above.

There is a similar problem with ROWS when moving to the left of the selected cells but not to the right.

Expected behavior is allowing this admittedly odd cross-column shifting.

Comment 1 sasha.libreoffice 2012-06-28 02:07:51 UTC

Thanks for bugreport
Please, verify if in last version of LibreOffice still reproducible

And attach screenshot of this problem if problem still exist

Comment 2 bfoman (inactive) 2012-07-03 05:42:56 UTC

Confirmed with:
LO 3.5.4.2 
Build ID: own W7 debug build
Windows 7 Professional SP1 64 bit

(In reply to comment #0)
> Click and drag these cells up to a new location while holding the ALT key.
> Expected behavior is allowing this admittedly odd cross-column shifting.

Why do you use the ALT key? IMHO it is supposed to be used when moving cells from one sheet to the other.
Apart from that the behavior of this action is way different than Excel 2010 for instance.

Comment 3 dcreid 2012-09-22 23:48:18 UTC

The ALT key drag allows re-sorting in one move rather than copying to an intermediate location, copying the other content to the new location, then moving the other content into place.

It works now (I'm in 3.6.1.2), it is just a little graphically confusing for some move/insert actions, but makes sense after giving it a try usually.

Thank you!  I'm impressed.

Comment 4 sasha.libreoffice 2012-09-24 05:04:51 UTC

Thanks for additional testing
Due to last comment, changing status to WorksForMe

If problem will appear again, please, change status to Reopened