Re: [libreoffice-users] Re: database2spreadsheet

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.

I trust this helps.

Brian Barker


--
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