Copy/paste information into a cell

Gateway / Mx6436
February 6, 2010 at 08:23:29
Specs: Microsoft Windows XP MCE SP3, 1.794 GHz / 1982 MB
When I am using OpenOffice Calc, and I try to insert a large amount of text, I am getting a "Text Import" pop up window. No matter what the settings I seem to choose from this pop up, I keep getting the information that I am trying to insert into the one cell, into multiple cells. By default, the program chooses to insert "Unicode" as the character set and in the Seperator options, the tab has been selected.

What I need to do is to enter the information into just the one cell, even tho all the infomation can not be seen, I only need the one cell to store the information. Is there a better way to paste this information other than copy and paste from notepad document to the OpenOffice Calc document till all the information is stored in the one cell?

There is a total of aproximately 230 characters from the notepad document that I am copying from, and it doesn't contain any special formatting(is that even possible?) other than a new line after a row of characters.

Is there a way to either copy paste characters into a cell without having to deal with this pop up or a setting that can be changed so that this pop up won't occur?

See More: Copy/paste information into a cell

February 6, 2010 at 14:28:21
I think we need to know a little more about your source document.

I just copied 350 lines from a Notepad document, click on A1 in OOO3 and it pasted each line into it's own cell in column A.

This occurred with the default settings in the wizard.

The original data looks like this...

G-55, Review Question 2

The answer given on G-58 is "A, the width shall 
be less than twice the height."

However, on G-29 it states:
   There will be no restrictions as to the width 
   as long as it fits into the standard jig
     - The jig shall common to all participants 
       and built to the specifications given in 
       section A-44(b)

Report •

February 8, 2010 at 05:04:17

Well, the text is from a web page that I saved to a .txt file. I just noticed that when I saved the page, the encoding selected automatically by Windows is Unicode(UTF8). So I selected "User Defined" and named the page with a .rtf hoping that these changes would make a difference.

But, this only showed the edit commands to create the page instead of just showing the text of the web page, making it not worthwhile to copy and paste using this method.

I have also tried to copy the text from the saved .txt web page document and pasted it into a new, never used OpenOffice Writer document, hoping that whatever edit to the text copied would be lost.

Anywho, I was just trying to figure out a way to make the process of copy/paste from the .txt file created after saving a web page in Unicode(UTF-8) and then being able to insert text from the file into a single cell of the spreadsheet, is possible if I just insert information by copy/paste line by line instead of a whole paragraph from the saved web page .txt file.

Report •

February 8, 2010 at 07:54:06
Have you tried other web pages to see if they exhibit the same behavior?

Any chance you could proivide the link to web page so I could try it with your exact data?

Report •

Related Solutions

February 8, 2010 at 13:53:10
mk, for example, if you were to go to this site and save it as a .txt file

...then copy any few lines of information from the newly created .txt file and try to insert it into one cell in OpenOffice Calc, you would get the "Text Import" pop up

Report •

February 8, 2010 at 19:33:00
Instead of clicking in the cell itself, click in the formula bar and paste it there.

I just pasted that entire web page (33000+ characters) into A1.

Report •

February 9, 2010 at 06:47:40

...and to think I was going back and forth between documents to copy and paste into a cell formula bar for every line.... close, thank you for you help

Report •

Ask Question