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: [email protected]
          Reporter: [email protected]
                CC: [email protected], [email protected]

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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to