[Libreoffice-bugs] [Bug 136236] New: PDF Export of Excel file date format

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: mrogers at zaizi.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200828/71148c21/attachment.htm>