how to move a column(s)

Discuss the spreadsheet application

how to move a column(s)

Postby patll » Thu Jun 19, 2008 9:42 pm

how to move a column(s)
with excel you drag-n-drop with various Ctrl-Shft-Alt combinations to move a column(s). Is there an equivalent set of command, keyboard, mouse way of doing it. I just need to move a column(or series of columns) and insert them between two other existing columns.
In excel Drag=move column(s) or cell(s)
In excel Ctrl + Drag=copy move
In excel Ctrl-Shft+ Drag=insert

ALSO, the issue of just moving a cell. You have to select it and while holding the button down select outside to the adjacent cell and then back in. Then Let the button go and then move by drag-n-drop that single cell. Am I missing something or this the only way (awkward, really awkward) of doing it.

I realize that OO doesn't want to be M$ Office, but why can't it implement the base features that work in Office and then improve it. The use-ablity feature like drag-n-drop. It appears that it is non existent in OO.
Last edited by patll on Thu Jun 19, 2008 9:49 pm, edited 1 time in total.
patll
 
Posts: 7
Joined: Fri May 30, 2008 6:54 pm

Re: how to move a column(s)

Postby Villeroy » Thu Jun 19, 2008 9:48 pm

Works for me.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28844
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: how to move a column(s)

Postby patll » Thu Jun 19, 2008 9:51 pm

Villeroy wrote:Works for me.

what work for "me"
drag n drop, What?
patll
 
Posts: 7
Joined: Fri May 30, 2008 6:54 pm

Re: how to move a column(s)

Postby Villeroy » Thu Jun 19, 2008 9:53 pm

Lookup "moving;cells by drag and drop" in the help-index.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28844
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: how to move a column(s)

Postby patll » Thu Jun 19, 2008 10:02 pm

Villeroy wrote:Lookup "moving;cells by drag and drop" in the help-index.

nothing in the help index

Thanks, Let me be more specific
you can drag-n-drop and it will move it, but, it won't insert it between columns, it will only move/copy them leaving a blank cols behind and will put them on top of current cols with data in it.

So if you are moving 2 cols, you'd have to create the 2 cols where you want to move them to. do the drag and drop, then delete the 2 blank cols that the process left behind.
Is this not the only way to do it. with excel you start the drag, hold the appropriate key, depend on Copy-Insert-Move and drop and it, In this case Inserts tween 2 existing cols and removes the cols that it came from.
patll
 
Posts: 7
Joined: Fri May 30, 2008 6:54 pm

Re: how to move a column(s)

Postby Villeroy » Thu Jun 19, 2008 10:06 pm

viewforum.php?f=76
Since you do not tell us the version number, I assume the latest version 2.4.x.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28844
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: how to move a column(s)

Postby patll » Thu Jun 19, 2008 10:18 pm

Villeroy wrote:http://user.services.openoffice.org/en/forum/viewforum.php?f=76
Since you do not tell us the version number, I assume the latest version 2.4.x.

sorry about that.
2.2 I guess i need to update
patll
 
Posts: 7
Joined: Fri May 30, 2008 6:54 pm

Re: how to move a column(s)

Postby patll » Fri Jun 20, 2008 8:28 am

patll wrote:
Villeroy wrote:http://user.services.openoffice.org/en/forum/viewforum.php?f=76
Since you do not tell us the version number, I assume the latest version 2.4.x.

sorry about that.
2.2 I guess i need to update


I updated to 2.4, same thing. Any Ideas
I'm a newbie and maybe I'm missing something
patll
 
Posts: 7
Joined: Fri May 30, 2008 6:54 pm

Re: how to move a column(s)

Postby Villeroy » Fri Jun 20, 2008 9:57 am

Highlight a range, drag and drop with Alt key. A single cell must be highlighted as well (Ctrl+Click) before you can grab it anywhere(in Excel you need to grab the border).
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28844
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: how to move a column(s)

Postby acknak » Fri Jun 20, 2008 3:58 pm

It's a little fiddly to get exactly right.
Select a column, click on the highlighted cells (not the heading!) and drag. Dropping now will replace the column under the mouse cursor; pressing Alt when you drop will insert the column being moved.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3


Return to Calc

Who is online

Users browsing this forum: No registered users and 20 guests