[Libreoffice-bugs] [Bug 129595] Insert current date only inserts month and day

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #16 from Eike Rathke <erack at redhat.com> ---
The ja-JP locale data has
M月D日
as the default medium date display format, apparently on purpose as users
expect it (or at least did so 15 years ago), this is also used as the default
date format when a date is entered in a cell not using the shortcut.

All number formatting depends on the locale, either system locale, LibreOffice
locale or the cell's locale depending on what was individually assigned where.
Also for inserting a date with the shortcut the current cell formatting is
taken into account. If no cell format was assigned then the LibreOffice default
locale's default date format is used.

If the result happens to be ### it just means the column is too narrow to
display that (numeric) formatted result, so widen the column by hitting
Shift+Alt+Right on that cell to make it fit (or use a smaller font size).

Now, so far there is no bug.

Or is this a request to change the default Japanese medium date format? Are
there any references what the correct date format would be? So far there are no
complaints as far as I know, so I take it that the majority of Japanese users
are happy with the choice. "Excel uses yyyy/m/d" is not a compelling view to
that regard, but maybe it should be YYYY年M月D日 instead? Just how widespread is
that used and expected as a default date display format in spreadsheets?

-- 
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/20200512/4f887893/attachment-0001.htm>