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


Andrew,

On Sun, 2011-06-19 at 12:35 -0700, Andrew Foss wrote:

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!!!!



The default behavior can be irritating, it sometimes gets in the way. 

One option is to right click on the document, select open with and the
select Calc. It should show an import wizard asking you what the
delimiter is. Make the appropriate choices and click OK. It may take a
couple of minutes for it open but it should be in Calc.

Hope this helps.

-- 
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.