Bug 135085 - Form entries and or Label control elements become transparent upon export to PDF.
Summary: Form entries and or Label control elements become transparent upon export to ...
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Printing and PDF export (show other bugs)
Version:
(earliest affected)
6.4.4.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-07-23 21:52 UTC by Richard Palusaar
Modified: 2020-09-24 18:02 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Test case (11.39 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-07-23 21:58 UTC, Richard Palusaar
Details
Bad PDF export (18.36 KB, application/pdf)
2020-07-23 21:59 UTC, Richard Palusaar
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Richard Palusaar 2020-07-23 21:52:03 UTC
Description:
Workaround. Opening the PDF in Inkscape, the form entries are visible! With the PDF open in Inkscape, choose to Save copy as. The resulting PDF will have the form entries fully visible, without any editing!

Back in June the problem did not exist. I downgraded to a distro package dated in May. The problem was still present. I tried downgrading from Fresh to Still, problem persisted.

I have tried disabling hardware acceleration under LO settings. Also I have tried manually setting the background color of a control to black and foreground to white, the problem persists, text is transparent.

So text entry is there but not visible. In the PDF you can select the text, copy, then paste it, in another application and it will be there...

While filing this bug report I was suggested further down to try safe mode and or resetting my user profile. In safe mode the bug is no longer apparent. I ran safe mode again and choose to wipe my user profile and restore all settings to factory defaults. Restarted LO Calc once more, did an export, problem solved. Filing the report in case anyone else has use for it.

Steps to Reproduce:
1. Create a spread sheet.
2. Add a form and some form controls.
3. Enter data into the form.
4. Export to PDF.
5. Open the PDF for viewing.

Actual Results:
Entry into the form works as expected, data entered is visible in the Calc spread sheet. Exporting the sheet to PDF results in all data contained in the form controls being transparent/not visible.

Expected Results:
I would expect the form entries to be visible in the exported PDF.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
OS: Linux, ArchLinux
LibreOffice:
Version: 6.4.4.2
Build ID: 6.4.4-1
CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded

OpenGL:
$ glxinfo | grep OpenGL
OpenGL vendor string: NVIDIA Corporation
OpenGL renderer string: GeForce GT 710/PCIe/SSE2
OpenGL core profile version string: 4.6.0 NVIDIA 450.57
OpenGL core profile shading language version string: 4.60 NVIDIA
OpenGL core profile context flags: (none)
OpenGL core profile profile mask: core profile
OpenGL core profile extensions:
OpenGL version string: 4.6.0 NVIDIA 450.57
OpenGL shading language version string: 4.60 NVIDIA
OpenGL context flags: (none)
OpenGL profile mask: (none)
OpenGL extensions:
OpenGL ES profile version string: OpenGL ES 3.2 NVIDIA 450.57
OpenGL ES profile shading language version string: OpenGL ES GLSL ES 3.20
OpenGL ES profile extensions:
Comment 1 Richard Palusaar 2020-07-23 21:58:05 UTC
Created attachment 163463 [details]
Test case

A test case, document which recreates the bug.
Comment 2 Richard Palusaar 2020-07-23 21:59:45 UTC
Created attachment 163464 [details]
Bad PDF export

This is an exported spread sheet exported as PDF which exhibits the reported issue.
Comment 3 Richard Palusaar 2020-07-23 22:02:00 UTC
As noted in my description, I am filing the bug in case it benefits others, as for myself the issue is currently resolved. If it is of no use then please mark it as resolved.
Comment 4 Robert Großkopf 2020-07-24 15:37:02 UTC
I tried it with OpenSUSe 15.1 64bit rpm Linux and LO 6.4.4.2
The only entries I couldn't see after the export are the entries in a numeric field. There seems to be no entry inside. If I set a cursor in this field it will start on the left side of the field. All other entries will appear. So I couldn't confirm the bug here.

If I change the numeric field with a formatted field the entry for the field will appear also.

Format for dates seems to be something like 07/23/20, which isn't shown in the field.

I switched the component to "Printing and PDF-Export", because it isn't a Base-problem.
Comment 5 Timur 2020-07-30 19:15:01 UTC
(In reply to Richard Palusaar from comment #0)
> apparent. I ran safe mode again and choose to wipe my user profile and
> restore all settings to factory defaults. Restarted LO Calc once more, did
> an export, problem solved. Filing the report in case anyone else has use for
> it.
We can only close.
Comment 6 Richard Palusaar 2020-09-23 21:26:17 UTC
I am now on LO v7.0.1.2. Bug reoccurred. Resetting the user profile resolved most of the problem. Form fields are filled with data in exported PDFs bug form controls of type Label are invisible, in the exported PDFs!
Comment 7 Richard Palusaar 2020-09-23 21:37:21 UTC
I just ruled out the PDF viewer being the issue. The same form Label controls are still invisible when the exported PDF is viewed on another host running Windows 10 with Adobe Acrobat Reader DC. The Label is there, it is just that it is TRANSPARENT. Same issue on printed paper when doing a direct print job from within Calc. I wonder what could be causing this...
Comment 8 Richard Palusaar 2020-09-24 01:22:14 UTC
Version: 7.0.1.2
Build ID: 00(Build:2)
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
=7.0.1-1
Calc: CL
Comment 9 Richard Palusaar 2020-09-24 02:46:06 UTC
Similar issue described here although I am on ArchLinux: see https://discourse.lubuntu.me/t/libreoffice-export-to-pdf-has-no-text/1042
Comment 10 Timur 2020-09-24 08:04:19 UTC
Lubuntu is likely bug 125234. Do not open. Reopen is wrong status, see https://bugs.documentfoundation.org/page.cgi?id=fields.html#bug_status.
Comment 11 Richard Palusaar 2020-09-24 15:39:46 UTC
I read the link regarding Bug Fields. If I understand it right I am supposed to have opened a new bug rather than reopen this one?

Thank you Timur. Based on the thread for bug 125234, which you linked to, there is hope that it is once again fixed in version 7.1. Currently ArchLinux is pushing out 7.0, for fresh. I shall try downgrading or using Still.

I am using GTK3 and not Qt5, as far as I can tell. I am on Gnome.
Comment 12 Richard Palusaar 2020-09-24 16:24:04 UTC
I am thinking that it might be an issue with fonts not being embedded in the exported PDF. I tried downgrading to Still, 6.4 and resetting my user profile. No change. As in my original post, Opening the PDF in Inkscape and from there exporting to PDF works. Inkscape has a feature where if when opening a PDF it finds fonts missing it can replace these fonts with a closest matching font.

I shall continue testing.

I have also tried the following solution: https://ask.libreoffice.org/en/question/242309/libreoffice-writer-export-pdf-does-not-embed-fonts/
Comment 13 Richard Palusaar 2020-09-24 16:41:36 UTC
Opening the same Calc document on Windows using LO 6.0 and exporting to PDF from there works as expected, meaning that the form label fields of the document are visible.
Comment 14 Richard Palusaar 2020-09-24 18:02:36 UTC
I found a culprit and a usable workaround/solution!

The issue is triggered when a form Label field makes use of the Cantarel font...
Changing the font of the label control to some other font makes the label visible in the exported PDF.

The issue was discovered and documented in Fedora, here: https://bugzilla.redhat.com/show_bug.cgi?id=1875377

This is a reoccuring issue and a pain to figure out. If possible, it should be fixed as the bug causes major headaches for users.