OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Copying and filling new information into cells

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
ooo2user
Newbie
Newbie


Joined: 31 May 2006
Posts: 2

PostPosted: Wed May 31, 2006 1:51 pm    Post subject: Copying and filling new information into cells Reply with quote

Hi Calc Users,

I've been working on a rather large spreadsheet that requires a lot of editing including adding new data. My problem is everytime I would copy and paste new data in a blank cell that new data would replace existing information that follows. And I want that old data to come after the new data without replacing it.

For example, let's say I'm working on A1-20 and A1-20 has 1-20 filled and I want to add A-B-C-D starting in cell A6 so I insert a new cell between A6 and 7 and copy and paste A-B-C-D in the new cell between A6 and A7.

What happens is A-B-C-D replaces 6-7-8-9 so it's 1-2-3-4-5-A-B-C-D-10-11-etc when i want it to be 1-2-3-4-5-A-B-C-D-6-7-8-9-10 etc (these are cells going down).

The only way I found a way around this is to add a bunch of new cells (down), paste the new data then delete extra cells in between. But that's too time consuming. I just want to copy and paste new data without it replacing the existing information.

Does anyone have a solution where pasting new data will not replace existing information?


Last edited by ooo2user on Wed May 31, 2006 3:24 pm; edited 1 time in total
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Wed May 31, 2006 2:43 pm    Post subject: Reply with quote

Use Edit>Paste Special (shortcut: Insert-key on most systems).
Select the cell flags you need or "All" and choose one of the "Insert"-options.
Your selection in this dialog is saved for the current session. So you just need to hit "Insert" and "Enter" next time.
As far as I know this works with spreadsheet cells copied from Calc only.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
ooo2user
Newbie
Newbie


Joined: 31 May 2006
Posts: 2

PostPosted: Wed May 31, 2006 3:02 pm    Post subject: Reply with quote

Thanks a lot. This is what I did in case there are others with the same problem. So far, it only works with cells copied from Calc only. Sad

Copy the information from Writer or notepad or wherever and paste into an empty cell
Go to cell where you want to paste the data. DON'T INSERT NEW CELL
Paste special - Operations: None - Shift Cells: DOWN

This is for text only not calculations. Having to copy from Writer to a empty Calc cell and then to the cell you want is a bit tedious though but it works. Rolling Eyes


Last edited by ooo2user on Wed May 31, 2006 3:22 pm; edited 1 time in total
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Wed May 31, 2006 3:18 pm    Post subject: Re: Copying and filling new information into cells Reply with quote

Possibly? ....

Do paste it, but into another column. Then concatenate to get your result where you want it. You can easily hide columns not needed afterwards. To concatenate readily, set up a formula for as many columns as you would likely be using. If blank, nothing will be added, but when something is pasted there, it will show up in the cell with the formula. Data to be concatenated can even be in another sheet.

There might be some thinking on how to deal with concatenated hyphens in between characters if not pasted along with the rest of the data,

David.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group