Re: [libreoffice-users] How to convert tab-separated file to XLS from the command line

2013-02-14 Thread Tom Davies
Hi :)
I think the MS 95 format is still .xls and can be read and used by subsequent 
versions of both MSO and all versions of LO.  So i think just don't worry about 
your 2nd point.  

LibreOffice can read/write tsv as well as csv but it's just not the default.  
I'm not sure how to force it to change from csv to tsv on the command-line.

Apols and regards from
Tom :)  





>
> From: Brian Cottingham 
>To: users@global.libreoffice.org 
>Sent: Wednesday, 13 February 2013, 18:41
>Subject: [libreoffice-users] How to convert tab-separated file to XLS from the 
>command line
> 
>I have a tab-separated file that I'm trying to convert to XLS from the
>command line. This is the command I'm using:
>
>    sudo libreoffice --headless --convert-to xls filename.tsv
>
>This has two problems:
>
>   1. LibreOffice does not use a tab separator; it assumes a comma
>   separator, so my columns aren't detected correctly
>   2. LibreOffice reports converting to MS Excel 5.0/95 format. How can I
>   instruct it to convert to Excel 2003 format?
>
>-- 
>For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
>Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>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
>
>
>
>
-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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



[libreoffice-users] How to convert tab-separated file to XLS from the command line

2013-02-13 Thread Brian Cottingham
I have a tab-separated file that I'm trying to convert to XLS from the
command line. This is the command I'm using:

sudo libreoffice --headless --convert-to xls filename.tsv

This has two problems:

   1. LibreOffice does not use a tab separator; it assumes a comma
   separator, so my columns aren't detected correctly
   2. LibreOffice reports converting to MS Excel 5.0/95 format. How can I
   instruct it to convert to Excel 2003 format?

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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