Copy,Paste & sort data

Discuss the spreadsheet application

Copy,Paste & sort data

Postby JaneO » Wed Dec 12, 2007 2:30 pm

Hi all, is there a way to copy more than one cell/column/row at a time?

also is there any way to configure the F4 button to repeat last action as in excel?
JaneO
 
Posts: 9
Joined: Wed Dec 12, 2007 12:24 pm

Re: Copy,Paste & sort data

Postby acknak » Wed Dec 12, 2007 7:09 pm

... is there a way to copy more than one cell/column/row at a time?

Yes. Just select them and Edit > Copy (Ctrl+C).

Perhaps you could be a little more specific about what you want to do and what isn't working.

... is there any way to configure the F4 button to repeat last action as in excel?

Repeat is bound to Ctrl+Shift+Y by default. It is not terribly useful, as many operations are not repeatable.
F4 is bound to View > Data Sources.

You can change the key binding from Tools > Customize > Keyboard

Unless you have to switch back and forth between Calc and Excel frequently, I would say stick with the default settings. If you do have to switch back and forth, this is likely to be the least of your worries.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Copy & Paste

Postby JaneO » Thu Dec 13, 2007 10:57 am

re: Copy & paste, used when preparing reports, need to collect data from various sources & paste them into new sheet/workbook................. when highlight selected cells/rows & column >> edit , cut copy & paste are greyed out.... ctrl + c, error box advises this function cannot be used with multiple selections. am running OO 2.2

any idea's would be much appreciated
JaneO
 
Posts: 9
Joined: Wed Dec 12, 2007 12:24 pm

Re: Copy,Paste & sort data

Postby acknak » Thu Dec 13, 2007 5:57 pm

Ok, I see now. Unfortunately, it is just a limitation of Calc. There is no limit on how many cells you can copy, but they must all lie within a single rectangular selection.

The only options I can think of are to copy the items one at a time, or select them all in one big rectangle, copy to a temporary sheet and remove the unwanted items.

I'm curious: if you could copy several cells that are not all together, what would happen when you paste them? Would they all appear in the same (relative) positions? Or would they all be collected in a single column? Or something else?

It seems like no matter what happened, you would still need to rearrange them one at a time.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Copy,Paste & sort data

Postby JaneO » Thu Dec 13, 2007 6:28 pm

Thanks for that...... just for your info excel was very good what ever you picked up on the copy it would collate into relevant cells next to each other & in order

ho hum will need to work around this one, thanks again for your help :D
JaneO
 
Posts: 9
Joined: Wed Dec 12, 2007 12:24 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 23 guests