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 - pasting tab-delimiated data into Calc
pasting tab-delimiated data into Calc
 
   NeoOffice Forum Index -> OpenOffice.org MacOS X X11 Support
View previous topic :: View next topic  
Author Message
tjsulli73
Blue Pill


Joined: Mar 13, 2006
Posts: 1

PostPosted: Mon Mar 13, 2006 11:57 am    Post subject: pasting tab-delimiated data into Calc

I have a mailing list I am making into labels for a friend. I took the names, addresses, etc out of her word doc and made it into a text file tab-delimiated with a CR at the end of each entry. When I copy/pasted it into a calc file(2.0) on her machine it placed each entry between the tabs into a seperate cell and each line in the text file got a new row, just like I wanted. When I tried it on My Mac (oo2.0.0) it placed each line in one cell.

I looked in the options and such, but did not see a place to change how paste acts. Is this a known issue or is there a way to turn it on in OO on my Mac?

TIA.
Regards,
TJ
Back to top
yoxi
Cipher


Joined: Sep 07, 2004
Posts: 1799
Location: Dawlish, Devon

PostPosted: Tue Mar 14, 2006 12:36 am    Post subject:

Istead of pasting it, try saving it as a text file with the extension .csv, and then get OOo to open the file - it should bring up a dialogue that asks what delimiters you are using (I think it defaults to commas, so you need to de-select commas and choose tab instead) and then it'll import the data correctly. I don't know of any way to make tab the default delimiter.

- yoxi
Back to top
Display posts from previous:   
   NeoOffice Forum Index -> OpenOffice.org MacOS X X11 Support 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.