<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 - Date field format switch between Libre Office and Excel"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114195">114195</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Date field format switch between Libre Office and Excel
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.3.2 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>filippo.caimi@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
I create an XLS or XLSX file with Calc and I insert a date in a cell formatted
as DATE - DD/MM/YY and I save it.
Then if the same file is opened with Excel, the date format will be switched as
MM/DD/YY and the language retrived by Excel is Chinese...
This occurs systematically each time the file is first saved using Calc and
then opened with Excel.
The file is always shown correctly on Calc.
If the file used is a planning table, a schedule or something like that, that
bug becomes really dangerous!
Steps to Reproduce:
1. Create an XLS / XLSX file with Calc writing a date in a cell formatted as
DD/MM/YY and save it
2. Open the same file with Excel --> the date will look like MM/DD/YY ! So try
to adjust the format to DD/MM/YY and save it and close.
3. Open back again the same file with calc and just save it.
4. Open back again the same file with Excel and the format will be switched
again as MM/DD/YY
Actual Results:
Date cell format is saved in a way that is not compatible with excel
Expected Results:
Date cell format should be kept between different applications
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; 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>