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.