[Libreoffice-bugs] [Bug 119013] New: Date Format MM/DD/YY not Preserved When Save As XLSX or XLS

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Jul 31 07:01:54 UTC 2018


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

            Bug ID: 119013
           Summary: Date Format MM/DD/YY not Preserved When Save As XLSX
                    or XLS
           Product: LibreOffice
           Version: 6.0.5.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: suokunlong at 126.com

Created attachment 143834
  --> https://bugs.documentfoundation.org/attachment.cgi?id=143834&action=edit
test ods file with date formatted as MM/DD/YY

The attached ODS file contains cell value formatted as "MM/DD/YY" (09/01/17).
When save as xlsx or xls format and reopen, the cell value becomes "YY/MM/DD"
(17/09/01).

-- 
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/20180731/34b68967/attachment.html>


More information about the Libreoffice-bugs mailing list