[Libreoffice-bugs] [Bug 142216] New: FILEOPEN XLSX Excel default time formats don’t match in Calc with Hungarian locale

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 142216
           Summary: FILEOPEN XLSX Excel default time formats don’t match
                    in Calc with Hungarian locale
           Product: LibreOffice
           Version: 7.2.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: nemeth at numbertext.org, varga.balazs3 at nisz.hu

Created attachment 171878
  --> https://bugs.documentfoundation.org/attachment.cgi?id=171878&action=edit
Example file from Excel

This is similar to bug #133672 but with Excel default time formats instead of
dates.
Attached example file contains all default time formatting options applied on
cells in a Hungarian Excel 2019.
Calc does not have the same set of defaults, so there are some conversion
differences, especially with the locale-dependent format in A2.
Also the AM/PM translation does not match either.

Steps to reproduce:
    1. Open attached file in Calc

Actual results:
First item is padded to two digits.
Items with AM/PM are uppoercase instead of lowercase.
This may cause differences in display and autofilter results.

Expected results:
Ideally same display of time as Excel.

LibreOffice details:
Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: d7f734db2c078ced3ce08ad58cd816a79abe3bcf
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL

-- 
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/20210511/143d2674/attachment.htm>