<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 - CONVERSION FORMAT DATE"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116450">116450</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>CONVERSION FORMAT DATE
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.0.1.1 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (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>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>luuk34@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>When looking at an old bug report
(<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - Date format problem using the Dutch (NL) localization"
href="show_bug.cgi?id=33689">https://bugs.documentfoundation.org/show_bug.cgi?id=33689</a>) i found this:
It is possible to have DATE fields in different locales in 1 spreadsheet,
simply by pressing CTRL+1 , and choosing a different language.
Doing this it's possible to create a sheet with these two formulas (i.e.):
1) =TEXT(A2;"DD-MM-YYYY")
2) =TEXT(A2;"DD-MM-JJJJ")
The first with Language set to 'English', the second with language set to
'Dutch'
Above works correct in Openoffice, but saving this sheet as XLSX changes the
format of the English formatted date to '17-03-YYYY'
This can be shown by opening this file in Excel, of in OpenOffice, which shows
the date as "17-03-YYYY" (when the settings of the locale is set to Dutch)</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>