<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Insert current date only inserts month and day" href="https://bugs.documentfoundation.org/show_bug.cgi?id=129595#c16">Comment # 16</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Insert current date only inserts month and day" href="https://bugs.documentfoundation.org/show_bug.cgi?id=129595">bug 129595</a> from <a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> Eike Rathke</a> <pre>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?</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>