[Libreoffice-bugs] [Bug 130107] New: CALC, WRITER: UI: date format examples are suboptimal

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 130107
           Summary: CALC, WRITER: UI: date format examples are suboptimal
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: needsUXEval
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mihhkel at gmail.com

The chosen example date of 31 Dec 1999 produces unclear date format list for
some formats in many locales, due to no leading zeroes existing in 31 or 12.
This applies both in Calc (Format Cells - Numbers - category: Date) and in
Writer text tables (Table - Number Format - category: Date).

For example:

Catalan:
31/12/99 shown for both "D/MM/YY" and "DD/MM/YY"

Chinese (traditional):
1999/12/31 shown for both "YYYY/M/D" and "YYYY/MM/DD"

Dutch (Netherlands):
"D-MM-JJ" and "DD-MM-JJ"

English (US):
"M/D/YY" and "MM/DD/YY"
"NNNNMMMM D, YYYY" and "NNNNMMMM DD, YYYY"

Estonian:
"D.M.YY" and "DD.MM.YY"
"NNNNDD. MMMM YYYY. a" and "NNNND. MMMM YYYY. a"
"NN, D. MMM YY" and "NN, DD. MMM YY"

Finnish:
"P.K.VVVV" and "PP.KK.VVVV"
"NN P. KKK VV" and "NN PP. KKK VV"

Etc. etc.

Suggestions for a better example date:

a) 1 Jan 1999. I realize that this might cause confusion regarding DD/MM/YY vs.
MM/DD/YY but frankly, there are only a few locales that use both:
https://en.wikipedia.org/wiki/Calendar_date#Usage_map

b) 31 Jan 1999. This only partially solves the leading-zeroes issue (i.e. for
only some of the date formats), but preserves the clarity of DD/MM/YY vs.
MM/DD/YY if deemed necessary.

Additional discussion point: should the example year be modernized? I think it
should in any case stay outside the range of 01...31, so one option would be to
be futuristic and use a year between 2032...2100 (although this would in a way
conflict with the default setting to interpret two-digit years as between 1930
and 2029).

-- 
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/20200121/28453df0/attachment.htm>