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 - Help pasting table in NeoOffice Writer
Help pasting table in NeoOffice Writer
 
   NeoOffice Forum Index -> NeoOffice Releases
View previous topic :: View next topic  
Author Message
alanterra
Agent


Joined: Jul 03, 2006
Posts: 10

PostPosted: Thu Mar 29, 2007 11:54 am    Post subject: Help pasting table in NeoOffice Writer

I have some data I want to get out of a FileMaker database into an existing table, and I can't figure out how to do it. (I don't want to "link" the data, just get it into a text document)

I can save the data as an excel file or a text (tab delimited) file (among other formats).

If I save it as an excel, I can open it in the spreadsheet module of NeoOffice, but I can't figure out how to get that data transferred as a table into the Writer module.

If I save it as text delimited, open it in a text editor, and try to paste it, it pastes all in the same cell, with all sorts of random sharps and other symbols. If I select multiple cells in the existing table, it pastes the same data into each cell, and then NeoOffice locks up and I have to force-quit it.

Two solutions present themselves: 1) Paste the text into the document with tabs, use convert to table, and then hand-edit to reconstruct the rest of the cells in the table, or 2) save the NeoOffice as ".doc", open in MS Word, paste (which just works!) and then open in NeoOffice.

Is there something I am missing?

PS--perhaps this has been an OpenOffice issue for a while? See http://www.macupdate.com/reviews.php?id=15797&pid=97922
Back to top
revsmitty
Keymaker


Joined: May 15, 2005
Posts: 94
Location: Iowa, USA

PostPosted: Thu Mar 29, 2007 1:03 pm    Post subject:

I haven't found a nice easy solution to this dilemma either.

Your 1st solution seems to be on the right path but once you have used the convert to table function you can then copy the cells of that table and paste them into another table.

The only caveat is to make sure you have enough empty cells so that it doesn't paste over top of something else.

Galen
Back to top
amayze
The Merovingian


Joined: Oct 24, 2005
Posts: 561
Location: Edinburgh, Scotland

PostPosted: Fri Mar 30, 2007 5:37 am    Post subject:

If you copy cells from a spreadsheet and paste them in to a writer document, the default is for a spreadsheet frame to be created, so provided you can format the spreadsheet to look as you require then that's all you need to do.

If you'd rather have the text in a Writer table then do one of the following:

Choose Edit -> Paste Special
Select Unformatted Text and click OK
Select the (tab delimited) text that is pasted
Choose Table -> Convert -> Text to Table
Make your choices in the dialogue that appears and click OK.
Viola!

Alternatively:

Choose Edit -> Paste Special
Select Formatted text [RTF] and click OK
Your spreadsheet data will be pasted as a table.

HtH

Andy.
Back to top
sardisson
Town Crier
Town Crier


Joined: Feb 01, 2004
Posts: 4588

PostPosted: Fri Mar 30, 2007 1:22 pm    Post subject:

Is this in the wiki? If not (and I don't think it is), can someone please add it?

Smokey

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


Joined: Sep 23, 2006
Posts: 218
Location: Rome, Italy

PostPosted: Sat Mar 31, 2007 3:08 am    Post subject:

Jacqueline did it...
Valter and I translate...
and now it is in wiki!!

Thanks, Sardisson.
Back to top
Lorinda
Captain Mifune


Joined: Jun 20, 2006
Posts: 2051
Location: Midwest, USA

PostPosted: Sat Mar 31, 2007 5:17 am    Post subject:

I probably won't be able to get to the English version until after Easter, but I'll put it at the top of my list then, unless someone beats me to it.
Back to top
OPENSTEP
The One
The One


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

PostPosted: Sat Mar 31, 2007 5:26 am    Post subject:

OT, I know, but have a great holiday!! I wish all the joy of the season for you. And the same for all who are Christian/Catholic. Apologies if I missed any of the holidays all grouped around this time for everyone else, as well.

ed
Back to top
Lorinda
Captain Mifune


Joined: Jun 20, 2006
Posts: 2051
Location: Midwest, USA

PostPosted: Sat Mar 31, 2007 5:45 am    Post subject:

Thanks, Ed. According to my calendar, it's Passover next week, too. I can't speak to any of the other religious traditions.

I serve such a small congregation that it's not as much extra work as it could be, and the extra work that I do have is of the type I enjoy. But the school decided to hold Kindergarten round up, a book fair, and the first soccer practices during Holy Week (the week leading up to Easter); so my family schedule is pretty packed, too.


Last edited by Lorinda on Sun Apr 01, 2007 5:27 am; edited 1 time in total
Back to top
OPENSTEP
The One
The One


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

PostPosted: Sat Mar 31, 2007 5:51 am    Post subject:

Yeah was aware of Passover but some folk I know take it differnet ways...unlike purim which is usually pretty happy all around Smile

I hope it is a great time for you and everyone else whom you help!

ed
Back to top
LemonAid
The Anomaly


Joined: Nov 21, 2005
Posts: 1285
Location: Witless Protection Program

PostPosted: Sat Mar 31, 2007 10:53 pm    Post subject:

and don't forget Spring Equinox. Shocked
Can't forget our Sun, and Moon events.

Philip ( celebrates Equinoxes and Solstices Cool )

\. even got married on the spring Equinox - Equal parts Sun and Moon!
Back to top
RoyFocker
Oracle


Joined: Sep 23, 2006
Posts: 218
Location: Rome, Italy

PostPosted: Sun Apr 01, 2007 2:20 am    Post subject:

Maybe I can do some translations into english but I'm afraid that will give more work to Lorinda Embarassed

Off-topic: I didn't mention that first here, but I am a seminarist, catholic seminarist and I hope I will be ordained priest on 2008... (with the help of your prayers Wink ).
Back to top
jgd
Agent Smith


Joined: Feb 27, 2005
Posts: 1531
Location: France

PostPosted: Sun Apr 01, 2007 2:55 am    Post subject:

RoyFocker wrote:
Maybe I can do some translations into english but I'm afraid that will give more work to Lorinda Embarassed

I translated several articles from French after having asked Smokey if it can be useful or not. Smokey told me that it's always faster and easier to "polish" than to translate the whole article. Very Happy

So maybe our "foreign English" is better than nothing at all.
Quote:

Off-topic: I didn't mention that first here, but I am a seminarist, catholic seminarist and I hope I will be ordained priest on 2008... (with the help of your prayers Wink ).

So many different religions on this forum, and so much tolerance. If it could be the same in the whole world…

Jacqueline
Back to top
Guest
Guest





PostPosted: Sun Apr 01, 2007 6:54 am    Post subject:

Or as a famous bug once sung,

"Imagine no religion, I wonder if you can..."

IOW***eliminate the source of intolerance***[/i]
Back to top
alanterra
Agent


Joined: Jul 03, 2006
Posts: 10

PostPosted: Sun Apr 01, 2007 9:11 am    Post subject:

amayze wrote:
If you copy cells from a spreadsheet and paste them in to a writer document...


Thank you very much
Back to top
LemonAid
The Anomaly


Joined: Nov 21, 2005
Posts: 1285
Location: Witless Protection Program

PostPosted: Sun Apr 01, 2007 12:33 pm    Post subject:

alanterra wrote:
amayze wrote:
If you copy cells from a spreadsheet and paste them in to a writer document...

Thank you very much
Oh, Back on topic Smile

Welcome to NeoOffice alanterra, glad you could find some useful information here.
Even better that some of it was related to your question! Laughing

Philip ( Trinity Forums - we are a mixed lot, but happy! Wink )
Back to top
Display posts from previous:   
   NeoOffice Forum Index -> NeoOffice Releases All times are GMT - 7 Hours
Goto page 1, 2  Next
Page 1 of 2

 
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.