Re: [libreoffice-users] Calc Major Bug

On 2011-06-20 09:19, planas wrote:
> 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.
>
>   
Tab delimited files are quite common. they were .tsv once. I use them
for some of my exports where the data contains commas.
The commas could be in the text of text fields or if you are using a
comma as a decimal separator you probably want a .tsv file for import.
Calc handles import of text data well in my opinion, fixed width is
usefull for undelimeted text.
steve

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