https://bugs.documentfoundation.org/show_bug.cgi?id=154286
Bug ID: 154286 Summary: Changing value of date fields fails as MM.DD.YYYY format is not recognized as date Product: LibreOffice Version: 7.5.1.2 release Hardware: x86-64 (AMD64) OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: pe...@supurovic.net Description: I have number of document where I use date values in fields. I need dates displayed in DD.MM.YY. format so I set that so. But, LibreOffice always insisted to enter values in MM/DD/YYYY format. That means when editing value I have to type in MM/DD/YYYY but it is then displayed as DD.MM.YY. That was until the latest update to version 7.5.1.2. Now when I edit date, it switches to MM/DD/YYYY and let me edit but value is not recognized as valid date any more. Now I have to enter date as DD.MM.YYYY. to be recognized as date. It is the displayed as DD.MM.YY. This happens only if I edit date value which was already entered before LibreOffice update (which is in my case very often). Suddenly already entered value becomes invalid until i reformat it. I use LibreOffice for decades and I have number of documents. This is very annoying odd behavior. Actual Results: Date entered as DD.MM.YYYY is not recognized as correct date value Expected Results: Date entered in any appropriate date format should be recognized as such. Reproducible: Always User Profile Reset: No Additional Info: In years I learned to live with requirement that I have to enter date in odd and illogical format and use formatting to display it properly, but now that odd format I was forced to use, does not work any more and I have to edit all date fields in all documents using now format (again, different than one I actually need to be displayed) to make it work again. -- You are receiving this mail because: You are the assignee for the bug.