[Issue] Insert Cut Rows/Columns functionality

Discuss the spreadsheet application
Post Reply
bsb
Posts: 3
Joined: Wed Jan 21, 2009 3:00 pm

[Issue] Insert Cut Rows/Columns functionality

Post by bsb »

Hi,
I could not do Insert Cut Rows/ columns in Open Office Calc as we do in MS Office Excel. Can you tell a way to do it.
Thanks.
Last edited by Hagar Delest on Mon Jan 26, 2009 10:33 am, edited 1 time in total.
OOo 3.0.X on Ms Windows XP + Ms Windows Vista
User avatar
squenson
Volunteer
Posts: 1885
Joined: Wed Jan 30, 2008 9:21 pm
Location: Lausanne, Switzerland

Re: Insert Cut Rows/Columns funtionality

Post by squenson »

You are right, OOo is limited in this domain. You can only do basic insertion/deletion: position yourself on the contiguous row(s)/column(s) you want to insert/delete and then right click in the selected area to perform the action.

You cannot insert rows/columns when there are merged cells. You cannot "insert then copy" like in Excel. I think I have seen an add-on that extends the feature, let me do a quick search on this...... Here it is! http://extensions.services.openoffice.org/node/1798
LibreOffice 4.2.3.3. on Ubuntu 14.04
User avatar
Hagar Delest
Moderator
Posts: 32628
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Insert Cut Rows/Columns funtionality

Post by Hagar Delest »

LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
bsb
Posts: 3
Joined: Wed Jan 21, 2009 3:00 pm

Re: [Issue] Insert Cut Rows/Columns funtionality

Post by bsb »

thanks for the information.

i will take care to search for similar topic before adding one.
OOo 3.0.X on Ms Windows XP + Ms Windows Vista
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Issue] Insert Cut Rows/Columns functionality

Post by Villeroy »

You can select a row/column, grab the selected cell range (not row/column header) and drop it holding the Alt key. This will insert the moved range. Ctrl+Alt+Drop will insert a copy.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
squenson
Volunteer
Posts: 1885
Joined: Wed Jan 30, 2008 9:21 pm
Location: Lausanne, Switzerland

Re: [Issue] Insert Cut Rows/Columns functionality

Post by squenson »

And we should see improvement in OOo 3.2.0 (due hopefully mid-December 2009) as it will allow insertion and deletion of rows or columns inside a merged area.
LibreOffice 4.2.3.3. on Ubuntu 14.04
Post Reply