Re: [libreoffice-users] Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns

Some time ago I created bug 39936 asking asking for an enhancement that 
would work the way Excel does.  Maybe some more encouragement on that 
issue might move it up in terms of priority.

-- Tim
===========================

On 2/26/2014 9:28 AM, Tanstaafl wrote:
> Ok, Ive messed with this in the past, never been able to figure it 
> out, but something always stopped me from pursuing it until now.
>
> I'm just looking for the quickest/easiest way to MOVE rows/columns.
>
> Is this even possible? I've NEVER been able to get it to work, even in 
> Excel...
>
> If not, then what is the shortest route to MOVE a row/column using 
> CUT+INSERT?
>
> In Excel it takes just 4 clicks/steps:
>
> 1. Right-click a row/column header,
>
> 2. Click CUT,
>
> 3. Right-click the row/column header above/to-the-right-of the
>    row/column you want the one you CUT to go, and last
>
> 4. Click 'Insert cut cells'
>
> which moves the row/column you cut and place it before or above the 
> one you right-clicked on.
>
> In Calc it takes 6:
>
> 1. Right-click a row/column header,
>
> 2. Click CUT,
>
> 3. Right-click the row/column header above/to-the-right-of the
>    row/column you want the one you CUT to go,
>
> 4. Click 'Paste Special',
>
> 5. Change 'Shift cells' to either 'Right' (for columns) or 'Down'
>    (for rows), and last
>
> 6. Click 'OK'


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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