Ask Your Question
0

Problem with moving columns (calc, LO version 4.3.7.2)

asked 2017-10-11 10:24:44 +0200

appreciatethehelp gravatar image

Hello people, just want to talk about an issue I'm having moving columns in calc.

I am using the following method provided by "bburns" from this discussion on the topic: https://ask.libreoffice.org/en/questi...

"Yeah, it's a bit of a hidden feature, and I couldn't find anything searching the help for 'calc move column'. So to move columns or rows, click on the header(s) to select them, then hold down Alt and drag one of the cells in the region to the new location. To make a copy hold down Alt+Ctrl. To just obliterate the destination don't hold down any keys."

Here are the results I am getting:

1) If I "click on the header(s) to select them, then hold down Alt and drag one of the cells in the region to the new location", and keep holding down Alt whilst I release the mouse click: The column is copied by creating a new column and moving all the original columns contents into it, with the original still staying where it is.

2) If I "click on the header(s) to select them, then hold down Alt and drag one of the cells in the region to the new location", and keep holding down Alt then press and hold Ctrl whilst I release the mouse click:
The same result as 1).

3) If I "click on the header(s) to select them, then hold down Alt and drag one of the cells in the region to the new location", and release Alt before releasing the mouse click: The column is copied by moving the original column's contents into the location it was dragged to, with the original still staying where it is. No extra column is created.

So, how do I truly "move" a column? Not copy it; but move the column so that it is no longer in it's original position- the column and it's contents are now in the new position? I know I could use any of the previous methods then delete the original column but this seems unnecessary, I must be able to "truly" move a column as previously described?

Thanks all.

edit retag flag offensive close merge delete

Comments

@appreciatethehelp, Because I was still stumbling with this myself, I just added another answer where you linked to above to try to further clarify how to easily do this. See if that works for you.

EasyTrieve gravatar imageEasyTrieve ( 2017-11-17 04:57:25 +0200 )edit

Thanks EasyTrieve! Unfortunately the method you described didn't yield the desired result for me; what happened is that a new column was created in the position I dragged the original column too, with the same width and row spacing, but none of the contents of the original column. The original column remained where it was, with all of the original information still there.

appreciatethehelp gravatar imageappreciatethehelp ( 2017-11-21 13:35:31 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2017-12-11 08:54:21 +0200

EasyTrieve gravatar image

@appreciatethehelp, I suppose this might be due to the older LO you are running. LO 5.x has been around for quite a while now, and they have just released LO 6! So I think it's time for you to upgrade before you get caught where you can't easily upgrade. I imagine this will improve many, many things in LO for you.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-10-11 10:24:44 +0200

Seen: 72 times

Last updated: Dec 11 '17