https://bugs.documentfoundation.org/show_bug.cgi?id=166914
--- Comment #24 from Eike Rathke <[email protected]> --- (In reply to Fabbian from comment #22) > > OpenOffice accepts every nonsense it encounters because Excel did. > > It isn't nonsense and if you want interoperability you need to produce the > same result Excel produces given the same input. To me an input string 1.2-3 being accepted/interpreted as date 01/02/2003 (MM/DD/YYYY in en-US locale) or 2001-02-03 (YYYY-MM-DD in en-CA locale) or 01.02.2003 (DD.MM.YYYY in de-DE locale) is nonsense. Which OpenOffice does. (In reply to Fabbian from comment #23) > Review https://www.iso.org/iso-8601-date-and-time-format.html and > https://en.wikipedia.org/wiki/ISO_8601 > > YYYY-MM-DD complies with ISO 8601. YY-MM-DD does not. That exact wikipedia article says it does with the year 2000 version, I quoted before in comment 21. In any case the iso.org page is not a reference, it only mentions one possible format, you'd have to buy the standard from them. > Not only is the LibreOffice Calc VALUE function not compatible with Excel's > and OpenOffice's VALUE function, it is not consistent with ISO 8601. Anyhow, originally this was all about a YYYY/MM/DD format not being accepted before you took https://wiki.documentfoundation.org/Documentation/Calc_Functions/VALUE to drop some YY-MM-DD vs YYYY-MM-DD thing. -- You are receiving this mail because: You are the assignee for the bug.
