Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

Am 14.09.2012 12:25, Richard Quadling wrote:

I'm new to using a Mac and some of the things I can do in Windows I'm
unable to even work out the question for on a Mac, so please bear with me.

The files are generated from an automated system, several hundred a day and
have a .tsv extension (can't change it for every file). The files are UTF-8
encoded text files with TAB separated content.

I need to be able to double click the file and have it open in Libre Office
Calc. Even if it has to ask me to choose the delimiter to process it with.

You can have it much easier.
Collect them all in one directory.
[X] Connect to existing database
Type: Text
Specify the directory of the collection, the .tsv suffix, the delimiter etc.
[X] Register the database.
Save the database file. It is just a configuration file without data. The data are only in your file collection.

Usage: In Writer or Calc hit F4 and drag into your document what you need.

Dragging a table icon from the left pane into Calc creates an import range linked to the file. The data view on the right pane can easily be filtered and sorted. YOu can drag (copy) selected rows into a spreadsheet. In Writer you can also drag column headers into the document which generates mail merge fields (place holders for one field value per print out).

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.