Bug 132978 - LO Base: Print Form made from query, can't see the records in result.pdf
Summary: LO Base: Print Form made from query, can't see the records in result.pdf
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.3.0.0.alpha0+
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
: 132977 (view as bug list)
Depends on:
Blocks: Database-Forms
  Show dependency treegraph
 
Reported: 2020-05-12 12:20 UTC by Vera Blagoveschenskaya
Modified: 2022-07-17 01:15 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
audio.odb (39.22 KB, application/vnd.oasis.opendocument.database)
2020-05-12 12:23 UTC, Vera Blagoveschenskaya
Details
print-screenshot (212.25 KB, image/png)
2020-05-12 12:23 UTC, Vera Blagoveschenskaya
Details
result.pdf (15.11 KB, application/pdf)
2020-05-12 12:24 UTC, Vera Blagoveschenskaya
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Vera Blagoveschenskaya 2020-05-12 12:20:58 UTC
Description:
Print Form made from query, can;'t see the records in result.pdf

Steps to Reproduce:
1. Open audio.odb test-file from the attachment.
2. Go to Forms and open Query1.
3. Print this Form (I print to PDF-file, see screen)

Actual Results:
In result PDF-file I can not see records in the query.
See result.pdf

Expected Results:
Records are visible


Reproducible: Always


User Profile Reset: No



Additional Info:
Tested with
Version: 7.0.0.0.alpha1+
Build ID: 572c9db0440d9aba4945fb1761ec7f83e717c2f0
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: kf5; 
Locale: ru-RU (ru_RU.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2020-05-11_09:34:08
Calc: threaded
Comment 1 Vera Blagoveschenskaya 2020-05-12 12:23:20 UTC
Created attachment 160721 [details]
audio.odb
Comment 2 Vera Blagoveschenskaya 2020-05-12 12:23:48 UTC
Created attachment 160722 [details]
print-screenshot
Comment 3 Vera Blagoveschenskaya 2020-05-12 12:24:21 UTC
Created attachment 160723 [details]
result.pdf
Comment 4 Vera Blagoveschenskaya 2020-05-12 16:18:15 UTC
*** Bug 132977 has been marked as a duplicate of this bug. ***
Comment 5 Alex Thurgood 2020-05-13 07:16:22 UTC
Print to PDF of the Query1 Form works with

Apache OpenOffice
AOO417m1(Build:9800)  -  Rev. 46059c9192
2019-09-05 10:18:25 (Thu, 05 Sep 2019) - Darwin x86_64


Also works for me with LibreOffice :
Version : 6.4.3.2
Build ID : 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8
Threads CPU : 8; OS : Mac OS X 10.15.4; UI Render : par défaut; VCL: osx; 
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded


Haven't yet tried with a developer build.
Comment 6 Alex Thurgood 2020-05-13 07:22:13 UTC
Unfortunately, testing a print to PDF with

Version: 7.0.0.0.alpha0+
Build ID: a7b9cbbdd4b56b2f64b023f25de185353a6f01d9
CPU threads: 8; OS: Mac OS X 10.15.4; UI render: GL; VCL: osx; 
Locale: fr-FR (fr_FR.UTF-8); UI-Language: en-US
Calc: threaded

fails to produce any output for me whatsoever. This is different behaviour to the presently described bug and is specific to macOS.
Comment 7 Vera Blagoveschenskaya 2020-05-13 07:47:18 UTC
(In reply to Alex Thurgood from comment #5)
> Print to PDF of the Query1 Form works with

Thank you, Alex.
I see records while printing (in the preview), but they are absent in result file.


(In reply to Alex Thurgood from comment #6)
> Unfortunately, testing a print to PDF with
> 
> Version: 7.0.0.0.alpha0+
> Build ID: a7b9cbbdd4b56b2f64b023f25de185353a6f01d9
> CPU threads: 8; OS: Mac OS X 10.15.4; UI render: GL; VCL: osx; 
> Locale: fr-FR (fr_FR.UTF-8); UI-Language: en-US
> Calc: threaded
> 
> fails to produce any output for me whatsoever. This is different behaviour
> to the presently described bug and is specific to macOS.

I think, you should report a new bug.
Comment 8 Alex Thurgood 2020-05-13 07:47:59 UTC
Sigh, testing with 

Version: 7.0.0.0.alpha1
Build ID: 6a03b2a54143a9bc0c6d4c7f1...
CPU threads: 8; OS: Mac OS X 10.15.4; UI render: GL; VCL: osx; 
Locale: fr-FR (fr_FR.UTF-8); UI: en-US
Calc: threaded

gives me the same problem of not being able to print to PDF, so can't test futher, sorry.

I do see the data in the Print Preview of the print dialog, however.


@Vera : am wondering whether this might be specific to your Qt/KDE backend ?
Comment 9 Vera Blagoveschenskaya 2020-05-13 07:56:38 UTC
(In reply to Alex Thurgood from comment #8)
> 
> @Vera : am wondering whether this might be specific to your Qt/KDE backend ?

Possibly so.
Comment 10 Vignesh 2020-06-12 16:12:48 UTC
Tested with Libre Office 6.4 can be seen in the preview but when printing it did not work.
Comment 11 Buovjaga 2020-06-26 16:58:21 UTC
Not reproduced with 6.4.4 or master on Win.

Repro on Linux back to the oldest commit of 6.3 bibisect repo.

Arch Linux 64-bit
Version: 7.1.0.0.alpha0+
Build ID: 0960a8c5ce48adb1bc7bd434ed5242b51ce72149
CPU threads: 8; OS: Linux 5.7; UI render: default; VCL: kf5
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 26 June 2020
Comment 12 Buovjaga 2020-06-26 17:04:33 UTC
In the last commit of Linux 50max repo, the PDF has content, but is flipped upside down.
Comment 13 QA Administrators 2022-06-27 03:28:55 UTC Comment hidden (obsolete)
Comment 14 Alex Thurgood 2022-06-27 07:17:31 UTC
Works for me with:

Version: 7.3.4.2 / LibreOffice Community
Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5
CPU threads: 8; OS: Mac OS X 12.4; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded

I see the data in the query1 form. Clciking on the PDF icon in the main toolbar creates a PDF containing the data from the database.
Comment 15 Robert Großkopf 2022-06-27 10:37:24 UTC
Tested this one with OpenSUSE 15.3 64bit rpm Linux.
LO 6.4.7, LO 7.0.5 and LO 7.1.5: Table control without content.
LO 7.2.5, LO 7.3.4.2 and also LO 7.4.0.0.beta1: Table control with content. Seems the bug has been gone.
There will be no fix for older versions of LO, so I will set this one to WORKSFORME. Feel free to reopen if you could reproduce it with a current available version (LO 7.3 or newer).