I have dates conditionally formatted to read as Year Month after 1700, AD Year from 0-1700, and Year BC before 1 AD (eg: 2021 Aug, AD 500, 500 BC; interestingly, there is no Year 0 in the Gregorian/Julian calendars, with 1 BC hopping right to AD 1 on New Year’s Day). It’s done using this formula:
[>-73046]JJJJ MMM;[<-693595]EE" BC";"AD "EE
Those numbers are the values for the days December 31, 1699 and January 1, 1 AD, respectively. EE is code for “era”: Number Format Codes - LibreOffice Help. Upon restarting that formula always changes to:
[>-73046]JJJJ MMM;[<-693593]YYYY" BC";"AD "YYYY
… not affecting recent, post-1700 dates but rendering the AD/BC ones with leading zeros and negative signs, so as AD 0500 and -0500 BC from the example above. Changing the formula back and restarting Calc results in the same problem.
Changing the Date Acceptance Patterns as recommended on Why does LO change a date format? - #4 by Lupp didn’t fix things.
Help? I feel there must be some change-on-save setting I must be missing, some simple checkbox I need to check or uncheck somewhere…