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


Am 23.03.2015 um 17:01 schrieb hw:


Am 16.03.2015 um 18:07 schrieb Andreas Säger:
Am 16.03.2015 um 15:57 schrieb hw:


Creating LO documents directly would be nice and might have the
advantage to be able to specify some formatting --- which I might need
to do sooner or later.

Formatting is a matter of style, cell styles in this case. Linked import
ranges filled with database data can be prepared with cell styles (I use
document templates for this type of database reports). The formatting
expands/shrinks with the imported data range.

How would I do something like this with CSVs?  I guess I'd need some
sort of "overlay spreadsheet" which defines the formatting and is then
being filled with the data from a CSV file.  The fields in the CSV
remain the same while the number of rows will vary.


Exactly like with any other database. For the formatted output of
database data does not matte if your Base document is connected to csv,
dBase, spreadsheets, Oracle server, MySQL, embedde HSQL or any kind of
ODBC data source.

[Example] Loading CSV into preformatted spreadsheets
https://forum.openoffice.org/en/forum/viewtopic.php?f=100&t=23727

File #1 is a csv file.
File #3 is a Base document connected to the csv file, more precisely to
its directory which may contain more csv files.
File #4 is a pre-formatted spreadsheet template with a preformatted
import range.


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

Context


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.