<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Date formatting issue when viewing Calc created .xlsx spreadsheet on iPad/iPhone"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126773#c7">Comment # 7</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - 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:cjdshaw@yahoo.co.uk" title="cjdshaw@yahoo.co.uk">cjdshaw@yahoo.co.uk</a>
</span></b>
<pre>OK, I've got to the bottom of this. It was made easier by the same problem
occuring in the OSX Quicklook viewer.
OSX and iOS seem to interpret "DD" or "D" in a format specifier as "days since
beginning of year" and "dd" or "d" as "days since beginning of month"
Excel defaults to outputting its date formats in lower case, whereas
LibreOffice defaults to upper case. By unzipping
"Calc-Created-Spreadsheet.xlsx", changing the date formats in "xl/styles.xml"
to lower case, and rezipping, I was able to fix the problem.
Can anyone think of a reason why defaulting to lower case would be a problem?
Entering date formats into Calc in lower case works fine, but it automatically
converts them to upper case</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>