[Issue] Insert Cut Rows/Columns functionality

Discuss the spreadsheet application

[Issue] Insert Cut Rows/Columns functionality

Postby bsb » Sat Jan 24, 2009 9:03 am

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
bsb
 
Posts: 3
Joined: Wed Jan 21, 2009 3:00 pm

Re: Insert Cut Rows/Columns funtionality

Postby squenson » Sat Jan 24, 2009 9:13 am

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.1.3.2. on Ubuntu 13.10
User avatar
squenson
Volunteer
 
Posts: 1878
Joined: Wed Jan 30, 2008 9:21 pm
Location: Lausanne, Switzerland

Re: Insert Cut Rows/Columns funtionality

Postby Hagar Delest » Mon Jan 26, 2009 10:31 am

AOO 4.0.1 on Windows 7 and Xubuntu 13.10 (Saucy Salamander)
User avatar
Hagar Delest
Moderator
 
Posts: 25087
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: [Issue] Insert Cut Rows/Columns funtionality

Postby bsb » Tue Jan 27, 2009 4:03 pm

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
bsb
 
Posts: 3
Joined: Wed Jan 21, 2009 3:00 pm

Re: [Issue] Insert Cut Rows/Columns functionality

Postby Villeroy » Fri Nov 06, 2009 10:41 am

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 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17258
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Issue] Insert Cut Rows/Columns functionality

Postby squenson » Fri Nov 06, 2009 7:06 pm

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.1.3.2. on Ubuntu 13.10
User avatar
squenson
Volunteer
 
Posts: 1878
Joined: Wed Jan 30, 2008 9:21 pm
Location: Lausanne, Switzerland


Return to Calc

Who is online

Users browsing this forum: No registered users and 32 guests