[libreoffice-users] Re: Calc macro to open tab delimited data file?

Am 07.03.2012 22:03, Johnny Rosenberg wrote:
> A Tab delimited text file – what more could we want to know?

4 different lines of tab delimited text each with 4 identical values:

2012/03/08      1,213.59        text    7-8
"2012-03-08"  "1,213.59"    "text"        "7-8"
8.März12        01213,59        text    7-8
03/08/2012      $1213.59        "text"        "7-8"
[...] to be continued with dozends of variants

The import dialog covers all these situations plus dozends of character 
encodings.

If you google for macros to load csv you will find dozends of ready
made solutions and all of them use a different set of FilterOptions. The 
FilterOptions are bundled in a complex string that reflects all the 
settings of the import dialog.
> http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/OfficeDev/Handling_Documents#MediaDescriptor
> http://wiki.services.openoffice.org/wiki/Documentation/BASIC_Guide/StarDesktop
> http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Filter_Options



--
For unsubscribe instructions e-mail to: users+help@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