Description: When converting a .xlsx file to PDF if the excel file contains multiple source date formats then the output PDF outputs all dates in the Locale specific date format regardless of the style within excel. Steps to Reproduce: 1.Create a document in Excel with multiple columns. Format column a as numeric with British date format. Format column b as numeric with American date format 2./opt/libreoffice6.4/program/soffice --headless --invisible --nodefault --view --nolockcheck --nologo --norestore --nofirststartwizard --convert-to pdf /mer/MultiDates.xlsx 3.Look at the generated PDF document. And observe that the dates are all in the same format Actual Results: A PDF export of the .xlsx document is produced, however all the date fields are in the same format. Expected Results: I expected that the exported PDF would match what I see in Excel with regard to the date style. Reproducible: Always User Profile Reset: No Additional Info: Note that libra office itself is able to display the 2 columns in different different date formats. The date format produced is dependent upon the LANG environment vars. So I can switch all dates to American or all dates to British.
Created attachment 164820 [details] This is the test file I have been using
Created attachment 164821 [details] this is the result This is the result after generating from your document. It is ok?...
I might be having problems with bugzilla but that file does not correct. I see a grey background only.
Created attachment 164822 [details] This is my result Note that the US Dates and the UK dates are in the same format, one of them is wrong
Download my attachment if you have problem in your broiwser, and open the file from your folder, not with the help of the browser.
What I see is that dates are formatted by your locales, and the same in my case. From what I have tested you have to select for example the "UK Date" fields and right click - Format Cells - Number - and form here change the language to English - UK. The same in US DATE, change to English (USA). And now see if this works.
Created attachment 164824 [details] I have done what I told you to do, and this is the result. It's ok.
I managed to download your attachments. The attachemnt "this is the result" shows the problem. In particular the American date column is displayed as dd/mm/yyyy Your second attachment"I have done what I told you to do, and this is the result. It's ok." Shows the result I would expect.
In this case you have to follow this steps: ------------------- - You have to select for example the "UK Date" fields and right click - Format Cells - Number - and form here change the language to English - UK. - The same in US DATE, change to English (USA). ------------------- Please do this, and I am waiting for your answer if it worked.
I've repeated those steps on a new file and got the same incorrect results. So both columns have American format so 9/11/2001 rather that 11/09/2001 and 09/11/2001. For clarification I have done the formatting in Excel rather than Libra Office. Office 365 version 16.36.
I've repeated those steps on a new file and got the same incorrect results. So both columns have American format so 9/11/2001 rather that 11/09/2001 and 09/11/2001. ---> You need to change the format as I told you. With LibreOffice or Excel. For clarification I have done the formatting in Excel rather than Libra Office. Office 365 version 16.36. ---> You need to change the format as I told you. With LibreOffice or Excel. If you open the file with LibreOffice and the format Amercian for American column and UK format for UK column, and still shows wrong than is a LibreOffice bug. Waiting for your tests.
If I create the test file in Libra Office then it does work correctly and the UK dates and USA dates are formatted correctly.
So, I think the problem is in Excel. It's not a LibreOffice bug.
How can it be an Excel Bug when the transformed output from the .XLSX to PDF does not match what libra-office (or Excel) would itself display? There is a discrepancy in the convert to PDF logic.
Sorry, I tested now this. I see the problem now. I created a video in order to see the problem. When exported the PDF from Export to PDF from the file itself it's ok (example 3 in the video), but when generated from terminal is not ok (example 2 in the video). Example 1 is not ok, because the file itself is not ok set up. Confirm with Version: 7.1.0.0.alpha0+ Build ID: e69f547bce7de376a0af464c5f7af5e7d2c8784a CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2020-06-23_15:52:52 Calc: threaded
Created attachment 164986 [details] the exact file for testing
Created attachment 164987 [details] video showing the bug
The code in order to test this ------------------ ./instdir/program/soffice --headless --invisible --nodefault --view --nolockcheck --nologo --norestore --nofirststartwizard --convert-to pdf MultipleDatesTest.xlsx
Dear mrogers, 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 https://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://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Seems to be resolved until now. Pleasse check with a new version. I have tested with this version and everything seems fine also on export and from terminal. Version: 7.5.0.0.alpha0+ / LibreOffice Community Build ID: a36173359d4614a8935e2f764acadfcf736e091c CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded