Re: [libreoffice-users] Re: database2spreadsheet

2015-04-07 Thread hw
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

Re: [libreoffice-users] Re: database2spreadsheet

2015-04-07 Thread Brian Barker
At 16:06 07/04/2015 +0200, Honly Wonly wrote: 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

Re: [libreoffice-users] Re: database2spreadsheet

2015-03-23 Thread 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

Re: [libreoffice-users] Re: database2spreadsheet

2015-03-23 Thread hw
Am 19.03.2015 um 14:07 schrieb Andreas Säger: Am 19.03.2015 um 11:49 schrieb hw: Copying icons? Indeed. In order to copy table or view contents from one DB to another DB you copy the table _icon_ from one database window, select the table icon in the other database window (the DB where

[libreoffice-users] Re: database2spreadsheet

2015-03-23 Thread Andreas Säger
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

Re: [libreoffice-users] Re: database2spreadsheet

2015-03-23 Thread 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.

Re: [libreoffice-users] Re: database2spreadsheet

2015-03-19 Thread hw
Am 17.03.2015 um 21:41 schrieb Andreas Säger: Am 17.03.2015 um 13:36 schrieb hw: Sorry, this is the wrong answer to the right post --- still a question, though. The answer to this post should have been that I would need the images to appear in the spread sheet. Pictures in Calc are no

Re: [libreoffice-users] Re: database2spreadsheet

2015-03-19 Thread hw
Am 17.03.2015 um 21:34 schrieb Andreas Säger: Am 17.03.2015 um 13:22 schrieb hw: 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

[libreoffice-users] Re: database2spreadsheet

2015-03-19 Thread Andreas Säger
Am 19.03.2015 um 11:37 schrieb hw: For a LibreOffice user there is only one built-in tool to do reporting with pictures. It is the report tool. Hm, I'm not too happy with that because the defaults aren't too useful, and when I wanted to make a report to display data from a table, the

[libreoffice-users] Re: database2spreadsheet

2015-03-19 Thread Andreas Säger
Am 19.03.2015 um 11:49 schrieb hw: Copying icons? Indeed. In order to copy table or view contents from one DB to another DB you copy the table _icon_ from one database window, select the table icon in the other database window (the DB where you have write access) and paste. A dialog pops up

Re: [libreoffice-users] Re: database2spreadsheet

2015-03-17 Thread hw
Am 16.03.2015 um 15:57 schrieb hw: Some experimentation is required at this point ... Thank you for all the replies so far! Ok so I made a new spreadsheet and dragged a query from the datasources view into it. Apparently that fills rows in the spreadsheet with the data obtained from the

[libreoffice-users] Re: database2spreadsheet

2015-03-17 Thread Andreas Säger
Am 17.03.2015 um 13:14 schrieb hw: Am 16.03.2015 um 18:04 schrieb Andreas Säger: Am 16.03.2015 um 16:18 schrieb hw: Exactly: What the perl script does is way beyond the capabilities of a query and of formulas in a spread sheet. In which way? You are rather unspecific about your

Re: [libreoffice-users] Re: database2spreadsheet

2015-03-17 Thread Tom Davies
Hi :) Ahh, i thought Writer, Calc etc could only look-up data and could not input or edit data. I thought that was where the Base's internal Forms and Reports were really useful? So normal users could be kept in their safe familiar environment with no fear of accidentally breaking anything much.

[libreoffice-users] Re: database2spreadsheet

2015-03-17 Thread Andreas Säger
Am 17.03.2015 um 16:37 schrieb hw: Am 16.03.2015 um 15:57 schrieb hw: Some experimentation is required at this point ... Thank you for all the replies so far! Ok so I made a new spreadsheet and dragged a query from the datasources view into it. Apparently that fills rows in the

[libreoffice-users] Re: database2spreadsheet

2015-03-17 Thread Andreas Säger
Am 17.03.2015 um 13:36 schrieb hw: Sorry, this is the wrong answer to the right post --- still a question, though. The answer to this post should have been that I would need the images to appear in the spread sheet. Pictures in Calc are no spreadsheet data. Pictures are decorative,

[libreoffice-users] Re: database2spreadsheet

2015-03-17 Thread Andreas Säger
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

Re: [libreoffice-users] Re: database2spreadsheet

2015-03-17 Thread 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

Re: [libreoffice-users] Re: database2spreadsheet

2015-03-17 Thread hw
Am 16.03.2015 um 18:04 schrieb Andreas Säger: Am 16.03.2015 um 16:18 schrieb hw: Exactly: What the perl script does is way beyond the capabilities of a query and of formulas in a spread sheet. In which way? You are rather unspecific about your requirements. That's partly because the

Re: [libreoffice-users] Re: database2spreadsheet

2015-03-17 Thread hw
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

[libreoffice-users] Re: database2spreadsheet

2015-03-16 Thread 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

Re: [libreoffice-users] Re: database2spreadsheet

2015-03-16 Thread hw
Am 06.03.2015 um 09:08 schrieb Alex Thurgood: Le 04/03/2015 10:59, hw a écrit : Hi, In a future step, I would like to integrate graphics into the spreadsheet which could be created by a perl script with gnuplot from data in the database; the images could reside in a directory and rows in

Re: [libreoffice-users] Re: database2spreadsheet

2015-03-16 Thread hw
Am 06.03.2015 um 15:44 schrieb Alexander Thurgood: Le 06/03/2015 10:18, Andreas Säger a écrit : Hi Andreas, In a future step, I would like to integrate graphics into the spreadsheet which could be created by a perl script with gnuplot from data in the database; the images could reside in

Re: [libreoffice-users] Re: database2spreadsheet

2015-03-16 Thread hw
Am 06.03.2015 um 22:31 schrieb Andreas Säger: Am 04.03.2015 um 10:59 schrieb hw: In a future step, I would like to integrate graphics into the spreadsheet which could be created by a perl script with gnuplot from data in the database; the images could reside in a directory and rows in the

[libreoffice-users] Re: database2spreadsheet

2015-03-16 Thread Andreas Säger
Am 16.03.2015 um 16:18 schrieb hw: Exactly: What the perl script does is way beyond the capabilities of a query and of formulas in a spread sheet. In which way? You are rather unspecific about your requirements. Even letting aside that using the BASIC dialect of LO is very awkward (just

[libreoffice-users] Re: database2spreadsheet

2015-03-16 Thread 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

[libreoffice-users] Re: database2spreadsheet

2015-03-06 Thread Alexander Thurgood
Le 06/03/2015 10:18, Andreas Säger a écrit : Hi Andreas, In a future step, I would like to integrate graphics into the spreadsheet which could be created by a perl script with gnuplot from data in the database; the images could reside in a directory and rows in the database would have a

[libreoffice-users] Re: database2spreadsheet

2015-03-06 Thread Andreas Säger
Am 06.03.2015 um 09:08 schrieb Alex Thurgood: Le 04/03/2015 10:59, hw a écrit : Hi, In a future step, I would like to integrate graphics into the spreadsheet which could be created by a perl script with gnuplot from data in the database; the images could reside in a directory and rows in

[libreoffice-users] Re: database2spreadsheet

2015-03-06 Thread Andreas Säger
Am 04.03.2015 um 10:59 schrieb hw: In a future step, I would like to integrate graphics into the spreadsheet which could be created by a perl script with gnuplot from data in the database; the images could reside in a directory and rows in the database would have a field referring to the file

[libreoffice-users] Re: database2spreadsheet

2015-03-06 Thread Alex Thurgood
Le 04/03/2015 10:59, hw a écrit : Hi, In a future step, I would like to integrate graphics into the spreadsheet which could be created by a perl script with gnuplot from data in the database; the images could reside in a directory and rows in the database would have a field referring to the

[libreoffice-users] Re: database2spreadsheet

2015-03-04 Thread Andreas Säger
Am 04.03.2015 um 10:59 schrieb hw: Hi, how would I create a spreadsheet from a table in a database? [Tutorial] Using registered datasources in Calc https://forum.openoffice.org/en/forum/viewtopic.php?f=75t=18511 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org