Am 23.03.2015 um 18:28 schrieb Brian Barker:
At 17:01 23/03/2015 +0100, Honly Wonly wrote:
Am 16.03.2015 um 18:07 schrieb Andreas Säger:
Am 16.03.2015 um 15:57 schrieb Honly Wonly:
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
As suggested above, if you already had suitable styling configured as
cell styles, it would be very simple to apply these styles to the data
after it was positioned. Alternatively, if you have a document with
space for the data already formatted - which would indeed sensibly be
created from a template - you could add the data without upsetting the
The trick here is to use Edit | Paste Special... (or Ctrl+Shift+V)
instead of ordinary Paste. If you paste from elsewhere in the same or
another spreadsheet document, ensure that "Paste all" and Formats are
both *not* ticked in the Paste Special dialogue; if you paste from
another source, select "Unformatted text" in the Paste Special dialogue.
The data is in a CSV file. Opening the CSV creates a new spreadsheet.
I don't want to apply formatting or copy and paste anything manually.
The formatting should be applied automatically, for example based on the
name of the CSV file, using a regexp, when the CSV file is opened.
To unsubscribe e-mail to: email@example.com
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
- [libreoffice-users] Re: database2spreadsheet (continued)
Impressum (Legal Info)
: 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