[Libreoffice-bugs] [Bug 117143] Calc displays date in a SharePoint list export file with different formatting

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Apr 17 20:01:50 UTC 2020


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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |erack at redhat.com

--- Comment #7 from Eike Rathke <erack at redhat.com> ---
(In reply to Gabor Kelemen from comment #4)
> Excel with hu_HU UI and hu_HU locale on Win 8.1: yyyy.mm.dd h:mm
> Calc 6.1 with hu_HU UI and hu_HU locale: YY-MM-DD HH:MM
> Calc 6.2 with en_US UI and hu_HU locale: YY-MM-DD HH:MM 
> 
> Would it be possible to make this use at least some locale-dependent
> default? 

YY-MM-DD HH:MM *is* the default date+time format in the hu-HU locale.
Check with entering =NOW() in a General/Standard formatted cell.

> I understand that Excel is doing some educated guesswork, perhaps we could
> do something similar?

Why does Excel display it in a yyyy.mm.dd h:mm format?

-- 
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/20200417/d6387b88/attachment.htm>


More information about the Libreoffice-bugs mailing list