<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:oliver.brinzing@gmx.de" title="Oliver Brinzing <oliver.brinzing@gmx.de>"> <span class="fn">Oliver Brinzing</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN wrong column format in ODS but not XLSX"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=119509">bug 119509</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>oliver.brinzing@gmx.de
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN wrong column format in ODS but not XLSX"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=119509#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN wrong column format in ODS but not XLSX"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=119509">bug 119509</a>
from <span class="vcard"><a class="email" href="mailto:oliver.brinzing@gmx.de" title="Oliver Brinzing <oliver.brinzing@gmx.de>"> <span class="fn">Oliver Brinzing</span></a>
</span></b>
<pre>i can confirm with your attached *.ods test file:
- open attached *.ods file
- format cells B2:B38 with Number Standard
- save
- reload
- B2:B38 has Date format TT.MM.JJ
test file's content.xml stored the date with "MM/DD/YY" format:
<table:table-cell table:style-name="ce1" office:value-type="date"
office:date-value="2018-06-27" calcext:value-type="date">
<text:p>06/27/18</text:p>
</table:table-cell>
and i can reproduce with a new spreadsheet, if i change the
cell language property from "Default (German)" -> Date Format
"TT.MM.JJ" to "English (USA)" -> "MM/DD/YY" (direct formatting).
Version: 6.2.0.0.alpha0+ (x64)
Build ID: ae5d6e44ce2310ef3ec4b0d12fe2d0005567a1ef
CPU threads: 4; OS: Windows 10.0; UI render: default;
Locale: de-DE (de_DE); Calc: threaded
workaround:
- select B2:B38
- context menu: "Clear Direct Formatting"
- save and reload
this will add "table:style-name="Default" to <table:table-cell/>
elements in "content.xml"</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>