https://bugs.documentfoundation.org/show_bug.cgi?id=170806
Regina Henschel <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords| |regression Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #1 from Regina Henschel <[email protected]> --- (In reply to ady from comment #0) > The typo, just above "Table 20", says: "mmmmm a full name". Note that 5 > consecutive letters "m" actually means "the initial letter of the name of > the month", whereas its full name is (or should be) represented by 4 (not 5) > consecutive letters "m". I agree, that having five m in the ODF specification is wrong. I have classified it as editorial error and have added it to our list in https://github.com/oasis-tcs/odf-tc/issues/55#issuecomment-3904345386 (In reply to ady from comment #0) > STR: First set locale to "English (USA)" in Tools > Options > Languages And Locales. > 1. Open the attachment with Calc. > 2. Hard Recalculate ([CTRL]+[SHIFT]+[F9]); or, if it is not available, > Recalculate ([F9]). > 3. Review column J (each row / item in it contains a different case); if it > says "BAD", then the Text-as-date format in the respective row is not > recognized by DATEVALUE(). > > > Versions I tested (on Windows 10): > > DATEVALUE() OK: > _ ApacheOpenOffice 4.1.15 > _ LibreOffice 3.3.0 Confirm, it is correct in LibreOffice 3.5.4.2 Build ID: 165a79a-7059095-e13bb37-fef39a4-9503d18 > > DATEVALUE() fails on cell reference, but OK on direct text (REGRESSION?): > _ LO 4.0.0.3 > _ LO 5.0.6.3 The formats "MM-DD-YYYY", "MM-DD-YY", "DD MMM, YYYY" and "DD MMMM YYYY" fail in Version 4.0.1.2 (Build ID: 84102822e3d61eb989ddd325abf1ac077904985) >From version 3.5 to 4.0 a "Date acceptance patterns" was introduced. For locale "English (USA)" it does not contain all patterns that are listed in the ODF standard and it is not possible to specify the above listed formats there. For "MM-DD-YYYY" and "MM-DD-YY" the pattern M-D-Y could be added. However, it is not possible to add a pattern for "DD MMM, YYYY" or "DD MMMM YYYY". As the ODF standard has the format strings in "Table 20 - VALUE" as "shall support" for locale en-us, LibreOffice must accept these format strings for the VALUE and thereby for the DATEVALUE function. We could solve this by changing the syntax in "Date acceptance patterns" to allow the ODF syntax (similar to number format code) and add the above strings as default, or we accept all patterns in "Table 20 - VALUE" for locale en-us without being listed in "Date acceptance patterns". The current behavior is a bug. -- You are receiving this mail because: You are the assignee for the bug.
