Re: [libreoffice-users] Calc Major Bug

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