Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


Tom

On Sun, 2011-06-19 at 22:07 +0100, Tom Davies wrote:

Hi :)

Where do you get the tab delimited file from?  Does it offer a Csv (comma 
separated values) option as well?  If so then Csv is the more normal method of 
transferring data.  


Proprietary systems do try to throw a curved ball into the mix to force people 
to go over to their systems for everything but Calc devs are probably able to 
adapt fairly easily to this particular challenge.  It might help to find a 
bug-report or write one
http://wiki.documentfoundation.org/BugReport
Good luck and regards from
Tom :)





________________________________
From: Andrew Foss <shrisource@yahoo.ca>
To: users@global.libreoffice.org
Sent: Sun, 19 June, 2011 20:35:06
Subject: [libreoffice-users] Calc Major Bug

I need to open a tab delimited text file in Calc. I have done this many  times 
in Excel where you have to Open the File from inside Excel.  However, trying to 
open it with Calc launches Writer (ugh!!!). It seems  the programmers have gone 
to great lengths to stop one doing what you  wants and needs to do. Obviously, 
if one is inside Calc, any file one  tries to open should open inside Calc. 
That's a no brainer. 


How can I work around this problem? I tried tyo merge in the file but  that also 

failed. I tried changing the file extension but LO ignored  that. I tried 
caopy/paste into Calc but Calc failed to put each tab  delimited field into a 
separate cell so that failed. Hopeless!

Help!!!!


-- 
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Tab delimited files are often originally from a Word or Writer file
saved for importing into a spreadsheet. You are correct about CSV files
and spreadsheets. CSV files will open in Calc correctly and are the more
standard way of saving a file for a generic spreadsheet program.

-- 
Jay Lozier
jslozier@gmail.com

-- 
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.