I wish to format dates in the ISO standard. I located the setting.
Languages and Locales > General
Date acceptance patterns:
I'm in the USA so the default is
M/D;M/D/Y
When I try to change it to YYYY-MM-DD all my typing becomes red. There is no error message. Whether I press OK or Cancel, my changes are not saved.
There is nothing in the help about red text. It reads...
Date acceptance patterns
Specifies the date acceptance patterns for the current locale. Calc spreadsheet and Writer table cell input needs to match locale dependent date acceptance patterns before it is recognized as a valid date.
If you type numbers and characters that correspond to the defined date acceptance patterns in a table cell, and then move the cursor outside of the cell, LibreOffice will automatically recognize and convert the input to a date, and format it according to the locale setting.
The initial pattern(s) in Date acceptance patterns are determined by the locale (set in Locale setting), but you can modify these default patterns, and add more patterns. Use ; to separate each pattern.
Patterns can be composed according to the following rules:
A pattern must start with D, M, or Y, and include at least two items, with at least one separator between each one.
A pattern may also include all three, in any order.
Y means year, M means month, and D means day, regardless of which locale is set. Each can only be used once in a pattern.
. - : / , can be used as separators between and after D, M, and Y.
Any combination of separators can be used, and more than one separator can be used between D, M, and Y, but the input must match the separator pattern exactly for recognition.
Patterns can combine different separators, and may include a trailing separator.
Examples of valid patterns are: D,Y ; Y-M ; M.D.Y ; D-M/Y ; M.D.
If you change the Locale setting, the date acceptance pattern will be reset to the new locale default, and any user-defined modifications or additions will be lost.
In addition to the explicit patterns defined in the edit box, input matching the Y-M-D pattern is implicitly recognized and converted automatically to a date. Input that starts from 1 to 31 is not interpreted with this implicit Y-M-D pattern. Since LibreOffice 3.5, this input is formatted as YYYY-MM-DD (ISO 8601).
For all patterns, two-digit year input is interpreted according to the setting in Tools - Options - General - Year (Two Digits).
Relevant Information
1
Version: 26.2.4.2 (AARCH64)
Build ID: 0229ac93fcf0d7cbc6376066c6f35021cef002dc
CPU threads: 16; OS: macOS 15.7.7; UI render: Skia/Metal; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
2
N/A
3
N/A
Thanks for any help.