[Libreoffice-bugs] [Bug 132106] CELL() function "format" should include more date formats to return "D1" (or a new "D0")

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |ASSIGNED
           Assignee|libreoffice-bugs at lists.free |erack at redhat.com
                   |desktop.org                 |
            Summary|CELL() function "format"    |CELL() function "format"
                   |should include more date    |should include more date
                   |formats to return "D1"      |formats to return "D1" (or
                   |                            |a new "D0")

--- Comment #9 from Eike Rathke <erack at redhat.com> ---
Thanks a lot!
So the Excel documentation is incomplete and it's more like ODFF says for D1
(with example and "or similar") and what we implemented so far, but still the
differentiation between D1 and D4 is somewhat a mystery to me. Maybe D4 is
*only* for formats where M precedes D in a MDY date(+time) format, and D1 is
*only* for formats where D precedes M in DMY. That would make sense with your
list. And the D4 example would be wrong in the ODFF. And leaves no choice for
YMD.

Maybe we should just introduce D0 for the YMD order (D10 isn't a good choice as
it is 3 characters instead of the other 2), and rework using the simplified
predefined index returns. Actually the D1 vs D4 (and then D0) and other Dx
returns could be used to determine how to parse a date display string if those
actually follow the DMY vs MDY vs YMD order.

I'll try to take a stab at this.

Btw, it's news to me that Excel allows these [$-x-...] and [$-ru-RU] and
[$-ru-RU-x-...] language tag modifiers. Are they saved the same to document
storage?

-- 
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/20200417/6e97bd5b/attachment-0001.htm>