<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 - [FILESAVE]: changes format of date in cell from DD.MM.YY to MM.DD.YY with save file to .XLSX"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113889">113889</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>[FILESAVE]: changes format of date in cell from DD.MM.YY to MM.DD.YY with save file to .XLSX
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.0.0.alpha0+
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>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>79045_79045@mail.ru
</td>
</tr></table>
<p>
<div>
<pre>Description:
Locale is RU!
if you save file to format XLSX and open it in MSO Excel, then in Excel format
of date in cell will be change from DD.MM.YY to MM.DD.YY. But if you open it
XLSX in LibreOffice, then format of date will be OK - DD.MM.YY
Steps to Reproduce:
1. Create a new file in Calc
2. Enter into any cell 23.10.2017 (will be apply format DD.MM.YY)
3. Save file as .XLSX
4. Open file in MS Excel (we tried 2007, 2016)
5. See to format of our cell with date, it changed to MM.DD.YY
Actual Results:
format of date changed from DD.MM.YY to MM.DD.YY if you open file in the MS
Excel
Expected Results:
format of date didn't change if you open file in the MS Excel
Reproducible: Always
User Profile Reset: No
Additional Info:
it's regression
i bibisected this bug using bibisect-win32-5.4
first bad commit:
source sha:51478cefaa4e265b42e3f67eda0a64767ff3efba
<a href="https://cgit.freedesktop.org/libreoffice/core/commit/?id=51478cefaa4e265b42e3f67eda0a64767ff3efba">https://cgit.freedesktop.org/libreoffice/core/commit/?id=51478cefaa4e265b42e3f67eda0a64767ff3efba</a>
author Eike Rathke <<a href="mailto:erack@redhat.com">erack@redhat.com</a>> 2017-04-18 14:57:00 (GMT)
committer Eike Rathke <<a href="mailto:erack@redhat.com">erack@redhat.com</a>> 2017-04-18 15:01:27 (GMT)
commit 51478cefaa4e265b42e3f67eda0a64767ff3efba
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:57.0) Gecko/20100101
Firefox/57.0</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>