<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Date formatting issue when viewing Calc created .xlsx spreadsheet on iPad/iPhone"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126773">bug 126773</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;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEW
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Date formatting issue when viewing Calc created .xlsx spreadsheet on iPad/iPhone"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126773#c9">Comment # 9</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Date formatting issue when viewing Calc created .xlsx spreadsheet on iPad/iPhone"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126773">bug 126773</a>
from <span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span></b>
<pre>I guess that's some invention of those OSX/iOS viewers, there's no definition
that uppercase DD or D would be format code keywords for day of year, see also
<a href="https://support.office.com/en-us/article/Review-guidelines-for-customizing-a-number-format-c0a1d1fa-d3f4-4018-96b7-9c9354dd99f5">https://support.office.com/en-us/article/Review-guidelines-for-customizing-a-number-format-c0a1d1fa-d3f4-4018-96b7-9c9354dd99f5</a>
The ECMA-376-1:2016 OOXML specification doesn't say anything about case
sensitivity in
18.8.30 numFmt (Number Format)
or
18.8.31 numFmts (Number Formats)
but gives codes in lowercase. There is no DD or D with a special day of year
meaning.
Historically LibreOffice internally uses all uppercase format code keywords and
different casing doesn't produce duplicated format codes. AFAIK also in Excel
one can enter codes in lower or upper case, just that Excel internally uses all
lowercase format code keywords. So far this hasn't been a problem until this
odd iOS/OSX thing.
We maybe could convert format code keywords (and only those) to lowercase when
writing MS (Excel) file formats.</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>