[libreoffice-users] Re: [Base] Can we connect a macro to a report?
Am 14.11.2014 um 23:58 schrieb Jean-Francois Nifenecker: Le 14/11/2014 21:22, Andreas Säger a écrit : It is possible to use Calc as reporting engine. Hit F4 and drag your query onto a spreadsheet cell. When the database content changed, click any cell in that import range and call menu:DataRefresh. The page layout is a bit tricky but with Calc's page preview you can build amazing cell grid reports with sufficient formatting options, calculations, conditional formattings, simple interactive filters, sort orders and charts. Thank Andreas, I know of that feature but I fail to see how, using Calc data range, I can impose (random) page breaks when the group column value changes. Having the group field in A, column labels in first row. Remove all manual page breaks Add a calculated field outside the print area. X3: =$A3=$A4 Search and select all 0 results in column X. Insert page breaks. And yes, you can write a simple Calc macro and add it to this Calc document or template. -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Re: [Base] Can we connect a macro to a report?
Am 14.11.2014 um 16:03 schrieb Jean-Francois Nifenecker: Hi, I've got a working report in Base (connected to a Query, the data source being a Calc sheet). This is an accounting report that groups data according to some code in a column. A subtotal amount is accumulated for each group. I'm being asked to add this subtotal in letters as well. I've also got a macro that does just that, translating numbers into letters. But, to date, I haven't found any mean to connect a report field to a macro. I've looked at custom functions and can't find any option anywhere. So my question is: is this possible? And, if it is, how? Thanks in advance, It is possible to use Calc as reporting engine. Hit F4 and drag your query onto a spreadsheet cell. When the database content changed, click any cell in that import range and call menu:DataRefresh. The page layout is a bit tricky but with Calc's page preview you can build amazing cell grid reports with sufficient formatting options, calculations, conditional formattings, simple interactive filters, sort orders and charts. -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Re: [Base] Can we connect a macro to a report?
Le 14/11/2014 21:22, Andreas Säger a écrit : It is possible to use Calc as reporting engine. Hit F4 and drag your query onto a spreadsheet cell. When the database content changed, click any cell in that import range and call menu:DataRefresh. The page layout is a bit tricky but with Calc's page preview you can build amazing cell grid reports with sufficient formatting options, calculations, conditional formattings, simple interactive filters, sort orders and charts. Thank Andreas, I know of that feature but I fail to see how, using Calc data range, I can impose (random) page breaks when the group column value changes. -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@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