[libreoffice-users] Re: Calc Major Bug

Am 19.06.2011 21:35, 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!!!!

Hello,

-- Use the right filter in the open dialog as advised by planas.

-- Use the Windows context menu of the file as advised by Regina.

-- Import into a sheet of a regular spreadsheet document. 
Menu:Insert>Sheet From File...(with the link option). This will also 
store the import settings for this particular file.

-- Text tables are a database exchange format. OOo Base provides a 
configuration storage for all similar text tables so you can access all 
similar text tables from all office documents without repeating the 
import procedure.

-- Open the plain text file in a plain text editor (Notepad), copy, 
paste-special (Ctrl+Shift+V) in Calc.

OK, 5 methods should be enough for now.
Andreas S.


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