[Libreoffice-bugs] [Bug 130222] New: XLS and XLS date format lost

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 130222
           Summary: XLS and XLS date format lost
           Product: LibreOffice
           Version: 6.0 all versions
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jg at jguk.org

Easy to reproduce, please verify in latest version of Calc
Ubuntu doesn't have a newer version, I don't install any other package.

1. Create an XLS file
2. Set date as "27 Jan 2020" change the format to D MMM YYYY
3. Fill down 3 cells
4. Delete A2, A3
5. Save the file as XLS or XLSX
6. Open the file, and enter "27 Jan 2020" in A2.
7. Observe the date format was lost, it shows 27/1/2020

This bug seems to be a regression, it worked well for years.

Works fine in ODS

-- 
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/20200127/5d20f30b/attachment-0001.htm>