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. > https://forum.openoffice.org/en/forum/viewtopic.php?f=83&t=23260 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 > https://forum.openoffice.org/en/forum/viewtopic.php?f=100&t=23727 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: [email protected] 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
