<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - PDF Export of Excel file date format"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=136236">136236</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>PDF Export of Excel file date format
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.4.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Printing and PDF export
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>mrogers@zaizi.com
</td>
</tr></table>
<p>
<div>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>