https://bugs.documentfoundation.org/show_bug.cgi?id=136236
Bug ID: 136236
Summary: PDF Export of Excel file date format
Product: LibreOffice
Version: 6.4.4.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Printing and PDF export
Assignee: [email protected]
Reporter: [email protected]
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.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
