Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

This website is an archive and is no longer active
NeoOffice announcements have moved to the NeoOffice News website


Support
· Forums
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


  
NeoOffice :: View topic - copy and paste from web into columns
copy and paste from web into columns
 
   NeoOffice Forum Index -> NeoOffice Releases
View previous topic :: View next topic  
Author Message
Arvada
Blue Pill


Joined: Feb 19, 2007
Posts: 1

PostPosted: Mon Feb 19, 2007 1:09 pm    Post subject: copy and paste from web into columns

When I copy a table from the web and paste it into a spreadsheet, instead of pasting rows and columns, like excel, all data is pasted into a single column.
How do I get it to past as rows and columns?
Back to top
OPENSTEP
The One
The One


Joined: May 25, 2003
Posts: 4752
Location: Santa Barbara, CA

PostPosted: Mon Feb 19, 2007 1:33 pm    Post subject:

Hmm. You may need to save it to a text file and use CSV importing. There is an Edit > Paste Special option, but I don't think it does exactly what you're looking for.

ed
Back to top
sardisson
Town Crier
Town Crier


Joined: Feb 01, 2004
Posts: 4588

PostPosted: Mon Feb 19, 2007 2:15 pm    Post subject:

What browser are you copying from? I typically don't have problems with this using Camino....

There's a more convoluted way that should also work. If the page is publicly accessible (no logins, etc.), you can load it directly in NeoWriter/Web (add the "Load URL" item to your toolbar, and paste in the path to the web page); if it's not, save the page as HTML/HTML source from your browser and open the saved file in Neo. Then copy from the table into Calc.

Smokey

_________________
"[...] whether the duck drinks hot chocolate or coffee is irrelevant." -- ovvldc and sardisson in the NeoWiki
Back to top
kmorris
Sentinel


Joined: Dec 19, 2004
Posts: 23

PostPosted: Mon Feb 19, 2007 3:00 pm    Post subject:

Try Edit -> Paste Special. Sometimes one of the options there helps.

An alternative is to save the webpage to your local drive and make an external link to it.

1. Click Insert -> Link to External Data
2. Click the "..." button to view a file dialog where you can select the html file you just saved (you can also type in the URL directly, if it's publicly accessible, as Sardisson said).
3. In the text area called "Available tables/ranges", you'll see entries for HTML_all, HTML_tables, and perhaps others. Select the table you want to import then click "ok". I usually try this in a blank sheet, select everything, then just cut'n'paste the table I want.
4. You then "Edit -> Links" and break the link, otherwise it will update any time the page updates

It's intended for keeping your spreadsheet in sync with a web page - but perhaps that's what you wanted in the first place?

-K
Back to top
valterb
The Anomaly
(earlier version)


Joined: Sep 23, 2005
Posts: 463
Location: San Giuliano Terme, Pisa, Italy

PostPosted: Mon Feb 19, 2007 3:13 pm    Post subject:

I use Firefox as web browser and I have no problems in pasting tables, as Smokey said fot Camino.
The few time I had problems I use "paste special" -> "no formatted text" (I guess this is the english translaton for "testo non formattato" of my italian UI) as -K said.

Valter
Back to top
sardisson
Town Crier
Town Crier


Joined: Feb 01, 2004
Posts: 4588

PostPosted: Mon Feb 19, 2007 4:03 pm    Post subject:

kmorris wrote:
It's intended for keeping your spreadsheet in sync with a web page - but perhaps that's what you wanted in the first place?

That's a cool tip Smile

I feel a wiki page coming on getting data from HTML tables into NeoCalc Wink

Smokey
/if only I had the time to write it right now Sad

_________________
"[...] whether the duck drinks hot chocolate or coffee is irrelevant." -- ovvldc and sardisson in the NeoWiki
Back to top
Display posts from previous:   
   NeoOffice Forum Index -> NeoOffice Releases All times are GMT - 7 Hours
Page 1 of 1

 
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
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.