Re: [libreoffice-users] Re: database2spreadsheet

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
> formatting.
>
> 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: 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