[Libreoffice-bugs] [Bug 143979] New: FORMATTING: Date format is mangled when file is closed and reopened

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 143979
           Summary: FORMATTING: Date format is mangled when file is closed
                    and reopened
           Product: LibreOffice
           Version: 7.1.4.2 release
          Hardware: x86-64 (AMD64)
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: me at shadsterling.com

Description:
I habitually format date cells as `YYYY-MM""MMM-DDNN` (where the `""` acts as a
separator between `MM` and `MMM`), so today appears as `2021-08Aug-20Fri`

In some files, every time I close and reopen the file the date cell formats
have reverted to `YYYY-MMMMM-DDNN` (where `MMMMM` is expanded to the first
letter of `MMM`), so today appears as `2021-A-20Fri`

The format it saved with also does not appear in the list of formats in the
Format Cells dialog

Steps to Reproduce:
1. Format some dates with `YYYY-MM""MMM-DDNN`
2. Save and close
3. Reopen

For some files it does it every time, for other files it never does it, I have
no idea what the difference is

Actual Results:
All my dates got reformatted

Expected Results:
All my formats should be preserved


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.1.4.2 / LibreOffice Community
Build ID: a529a4fab45b75fefc5b6226684193eb000654f6
CPU threads: 16; OS: Mac OS X 10.16; UI render: default; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

-- 
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/20210820/7e26e1dc/attachment.htm>