[Libreoffice-bugs] [Bug 126773] Date formatting issue when viewing Calc created .xlsx spreadsheet on iPad/iPhone

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=126773

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW

--- Comment #9 from Eike Rathke <erack at redhat.com> ---
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
https://support.office.com/en-us/article/Review-guidelines-for-customizing-a-number-format-c0a1d1fa-d3f4-4018-96b7-9c9354dd99f5

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190814/5477671b/attachment.html>