To demonstrate the problems :-
Create a database with one table and one form
Configure the table with five fields (all options set to default) :-
Date1 - Key field of type Date [DATE]
Text1 - Field of type Text [VARCHAR]
Date2 - Field of type Date [DATE]
Date3 - Field of type Date [DATE]
Memo1 - Field of type Memo [LONGVARCHAR]
Configure the form to show all five fields
Use the form to input "01/01/81" into all five fields (enter six such lines in Memo1) and save it
Problem 1 :-
Display the form and export it as a PDF file, every checkbox on the "General" panel unchecked except "Create PDF Form" and "View PDF after export", with "PDF" selected as the "Submit Format"
Expected result is that the displayed (and saved) PDF should show all fields as "01/01/81" (six such lines in Memo1)
My first actual result was that Date1 was blank, Text1 was shown as "01/01/81", Date2 was blank, Date3 was shown as "01/01/81" and Memo1 was shown as six lines of "01/01/81"
If I then exited from LibreOffice, restarted it, redisplayed the form and performed the same export to PDF, I got slightly different results - this time, only Text1 and Memo1 were shown correctly, but all three date fields were blank
ie. Actual results are unpredictable, but there is a definite problem somewhere with fields of type date
I only have release 126.96.36.199 available for testing. I may well be wrong, but I have the feeling that this problem may not have occurred on the release that was available early in 2016.
Problem 2 :-
If checkbox "Archive PDF/A-1a (ISO19005-1)" is checked when exporting the form as PDF, all dates are displayed correctly, but a white area is shown in Memo1, obscuring most of the text.
This is not IMO a Base problem, but a PDF export /printing problem - changing module accordingly.
Possible DUP of bug 61850
Also, the incorrect font support could be down to bug 50879, where it appears that the default font used for certain fields in forms is not always embedded.
@Alan : could you provide a sample PDF file showing the behaviour you report ?
Setting to NEEDINFO, pending receipt of requested information.
Created attachment 132897 [details]
Sample database file
Created attachment 132898 [details]
Screen shot of filled-in form
Created attachment 132899 [details]
Exported PDF file showing blank dates
Created attachment 132900 [details]
Exported PDF file showing partially blank LONGVARCHAR field
I also just noticed that, even when the LONGVARCHAR field is not partially blanked out on the exported PDF, it only shows 7 lines whereas the form shows 8 lines. I would also suspect a font problem.
@Thanks Alan - I'm pretty certain the problem you are experiencing is already referenced here somewhere in the bugzilla, just a matter of finding it.
Build ID: 55833ef28adb67a34a61f545219f9ba9a7c1a4e5
CPU threads: 2; OS: Mac OS X 10.12.4; UI render: default;
Locale: fr-FR (fr_FR.UTF-8); Calc: group
I am confirming only for LONGVARCHAR multiline field of the form. As one can see from the enclosed screenshot the date entries are correctly displayed in Apple Preview for all fields except the multiline control.
Created attachment 133181 [details]
Screenshot with master 5.4.0
Suspect duplicate of bug 92959
If this is the same bug as:
then the problem has been around since OOo3.3
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/
If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not
appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/
2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword
Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa
Thank you for helping us make LibreOffice even better for everyone!
No longer a problem in LibreOffice 188.8.131.52