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: [email protected]
Reporter: [email protected]
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.
