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:Data>Refresh. >> 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: [email protected] 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
