Bug 107215 - REPORTBUILDER: Page headers & footers are not visible in report documents
Summary: REPORTBUILDER: Page headers & footers are not visible in report documents
Status: RESOLVED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
5.2.6.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 107468 (view as bug list)
Depends on:
Blocks:
 
Reported: 2017-04-16 22:33 UTC by branestawm
Modified: 2018-02-18 11:29 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Base database which demonstrates invisible page header & footer in text reports (7.88 KB, application/vnd.oasis.opendocument.database)
2017-04-16 22:38 UTC, branestawm
Details

Note You need to log in before you can comment on or make changes to this bug.
Description branestawm 2017-04-16 22:33:57 UTC
Description:
After upgrade from LO v5.1.3 to v5.2.6.2 Build 20m0(Build:2) on OpenSuse 13.2, release supplied by SUSE, page headers & footers are not visible in report documents.

Page headers & footers are created but they are not visible in the report document. You need to edit each report document, to set Format -> Page -> Header/Footer -> Autofit height, whereupon the headers & footers appear.


Steps to Reproduce:
1.Create text report for Writer in Report Builder, from simple query on built-in or other database. Put some text in report page header and/or footer.
2.Execute report.


Actual Results:  
1.No page header/footer shown in report document
2.Edit report document, to set Format -> Page -> Header/Footer -> Autofit height, to make page header & footer visible.

Expected Results:
1.Page header/footer shown in report document without editing.


Reproducible: Always

User Profile Reset: No

Additional Info:
headertest.odb attached which demonstrates this issue.


User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0
Comment 1 branestawm 2017-04-16 22:38:41 UTC
Created attachment 132622 [details]
Base database which demonstrates invisible page header & footer in text reports
Comment 2 Alex Thurgood 2017-04-24 10:43:54 UTC
When I open the report in the provided ODB file with 

Version: 5.3.2.2
Build ID: 6cd4f1ef626f15116896b1d8e1398b56da0d0ee1
Threads CPU : 2; Version de l'OS :Mac OS X 10.12.4; UI Render : par défaut; Moteur de mise en page : nouveau; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group

I see Page Header text and Page Footer text at the top and bottom of the report, so this would appear to be working normally on OSX. Perhaps the problem is Suse-package specific ?

No repro
Comment 3 Alex Thurgood 2017-04-24 10:47:15 UTC
@Branestawm : you should test with a TDF nightly build, or else a parallel install with TDF packages to compare - if the problem is Suse package specific, then it needs to be reported to Suse and not here.
Comment 4 branestawm 2017-04-24 19:20:01 UTC
Thanks for your test result. I'm getting some interest on AskLO where the issue has been raised by another SuSe user. Depending how that goes, I'll report on SuSe bugzilla - and will comment here when I do.
Comment 5 branestawm 2017-04-28 17:05:52 UTC
Reported to SuSe as a distro issue today.
Comment 6 branestawm 2017-04-28 17:08:35 UTC
Newer bug 107468 from another OpenSuse user may be a duplicate of this one.
Comment 7 B Mikowski 2017-04-29 19:40:30 UTC
*** Bug 107468 has been marked as a duplicate of this bug. ***
Comment 8 B Mikowski 2017-04-29 19:45:55 UTC
I can confirm that the problem exists and is the same as the bug I submitted.  However, I amd using LO 5.2.5.1 (not v5.3.x) and I am running on OpenSuse LEAP 42.2--not v13.2. Editing the report (after it displays) using the method supplied above, does display the header.  There is currently no way to fix this with the LO Base reportwriter as it does not have the same formatting options, and you can't save the report back to the ODB file.   :-(
Comment 9 B Mikowski 2017-04-29 20:10:02 UTC
I just tested in LO Base 5.3.2.2 on LEAP 42.2.  The page header problem still exists.  In fact, it also moved the report footer to the next page--even though there are not enough lines to warrant placing the report footer on the next page (another regression?)
Comment 10 Robert Großkopf 2017-04-30 06:46:07 UTC
Could not reproduce with LO 5.3.2.2 on OpenSUSE 42.1 64bit rpm Linux.
Opening the report of the attachment shows header and footer.
Creating a new report shows header and footer.

You use the version supported by OpenSUSE (Build-Number shows this)? I only use the versions of libreoffice.org, LO 5.3.2.2 has Build-ID: 6cd4f1ef626f15116896b1d8e1398b56da0d0ee1

Must be a special bug of the version supported by OpenSUSE.
Comment 11 Robert Großkopf 2017-04-30 06:50:33 UTC
I forgot: There is no possibility to set 
Format -> Page -> Header/Footer -> Autofit height
in the versions supported from libreoffice.org.
Comment 12 Buovjaga 2017-04-30 07:31:36 UTC
Ok, you SUSE users can verify this is SUSE-only by installing TDF releases in parallel: https://wiki.documentfoundation.org/Installing_in_parallel/Linux

Then we can close this as NOTOURBUG and you can take it to SUSE.
Comment 13 branestawm 2017-04-30 16:06:50 UTC
As advised, I've now replaced the OpenSuse distro edition of LO with same version downloaded directly from TDF  - this has resolved the issue for me.

This has also thrown up a different bug in Report Builder that I will report elsewhere. Evidently it's important to realise that distro editions can be significantly different from master editions, eg install and config subfolders are different for each edition.

OpenSuse users doing the same may want to restore the soft link to 'soffice' (ln -s /usr/bin/soffice /opt/libreoffice5.2/program/soffice)

Thanks to all for your interest & help.
Comment 14 Luzius Auer 2017-11-03 15:19:33 UTC
confirmed for Fedora 26
Version: 5.3.7.2.0+
Build ID: 5.3.7.2-1.fc26
Threads CPU : 8; Version de l'OS :Linux 4.13; UI Render : par défaut; VCL : gtk3; Moteur de mise en page : nouveau; 
Locale : fr-CH (fr_CH.UTF-8); Calc: group

But it works flawlessly on Win7:

Version: 5.3.6.1 (x64)
Build ID: 686f202eff87ef707079aeb7f485847613344eb7
Threads CPU : 4; Version de l'OS :Windows 6.1;
Comment 15 Robert Großkopf 2017-11-03 17:28:26 UTC
(In reply to Luzius Auer from comment #14)
> confirmed for Fedora 26
> Version: 5.3.7.2.0+
> Build ID: 5.3.7.2-1.fc26

This Build ID isn't a Build ID of libreoffice.org. Must be a special build from Fedora.
> 
> But it works flawlessly on Win7:
> 
> Version: 5.3.6.1 (x64)
> Build ID: 686f202eff87ef707079aeb7f485847613344eb7

This Build ID shows the format of a Build ID of libreoffice.org.