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

Am 17.03.2015 um 13:22 schrieb hw:

Am 16.03.2015 um 18:00 schrieb Andreas Säger:
Am 16.03.2015 um 16:21 schrieb hw:

Without any coding it is be possible to create a field of hyperlinks.
Just add a HYPERLINK formula next to the import range. The adjacent
field expands to the size of the import range.

You mean to the size of the image?  It doesn't scale the images to
achieve a reasonable overall layout?

In this case, I could make the images all the same size; in other cases,
I might have images in all different sizes ...

Nope. I mean you can add a hyperlink to the spreadsheet which opens the
picture in your pic viewing program.

Ok, so I want to import data from a CSV file and would like to have some
formatting applied automatically, like specifying a particular width and
conditional formatting for some of the columns when I open the file
which is sent to me by email.

It would be possible to write some extra data into the CSV to achieve this.

How could I do this?

Simply use the database engine of your choice. The one you are already
connected with. It should provide all the capabilities to export, import
and link csv table. In this case you would not need any Office suite at
all. Office users can import csv files in the office GUI. Copying table
icons from a text connected database into a regular database or copying
spreadsheet cells onto the icon of a database table.

For the built-in HSQLDB this is described here:
[Tutorial] Using csv/text files as editable data source.
And it works in the same way with later versions of HSQL.

Since you do not mention your database engine, Google is your friend.
There are thousands of hits about csv and MySQL. All this works without
any office suite and your Perl script can simply issue some SQL command
via the dbi module (I think). I'm 100& sure that an office suite can not
add anything to your project. Operate your database any way you want.
Finally you may or may not load the results into document templates.

[Example] Loading CSV into preformatted spreadsheets

how to maintain prepared Calc templates to be filled with raw data from
csv (or any other kind of data source provided by the Base component).

To unsubscribe 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.