[Libreoffice-bugs] [Bug 129985] New: FILESAVE XLSX Default Excel data format saved incorrectly

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Jan 13 15:02:59 UTC 2020


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

            Bug ID: 129985
           Summary: FILESAVE XLSX Default Excel data format saved
                    incorrectly
           Product: LibreOffice
           Version: 6.5.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

Description:
Attached simple XLSX file contains date formatted cells with the default
locale-dependent Excel format in A2:A3.
After saving the file in Calc the date format changes to Custom
“[$-409]h.n.éééé” ([$-409]m.d.yyyy in Excel 2013 using English locale and
[$-40E]éééé.hh.nn ([$-40E]yyyy.mm.dd) using Hungarian locale.

Steps to Reproduce:
1. Open attached file in Calc and save it as XLSX.

Actual Results:
Excel does not recognize the cell format as Date, instead it lists it under
Custom.

Expected Results:
Excel recognizes the cell format as Date – Locale-dependent default.


Reproducible: Always


User Profile Reset: No



Additional Info:

-- 
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/20200113/ddb03c55/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list