I am using Calc to maintain a list of patients including entries like
name, age, date of birth etc.
I tried to set a consistent style to about 20 different sheets.
Sheet styles do not allow to adjust font etc.
I choose character style to set the desired font for all sheets.
I DID set a certain "date format"
a certain "number format".
However, this gives me either an incomprehensible 5-digit number for the
dates (of birth),
or alternatively a similarily incomprehensible 5-digit number for the
age = 2 digits.
I found under:
Tools - Options - General -> a "Two digit options":
Year (two digits)
Defines a date range, within which the system recognizes a two-digit year.
In LibreOffice, years are indicated by four digits, so that the
difference between 1/1/99 and 1/1/01 is two years. This *Year (two
digits)* setting allows the user to define the years in which two-digit
dates are added to 2000. To illustrate, if you specify a date of 1/1/30
or later, the entry "1/1/20" is recognized as 1/1/2020 instead of 1/1/1920.
That may be wonderful in certain situations, but leaves me having to
choose between the "age" (MOST of my patients have a 2-digit age!!!) or
"date of birth" of my patients.
And, naturally, having to format those columns by hand, for all sheets
(and maybe all eternity)
AND ... my patients turn out to have a VERY strange "date of birth":
70 ("age" translates into ) 1900/3/10
33 1900/2/1 (I am sure, there is
some logical rule, but I cannot see it)
The above cited help section does NOT indicate any way of how to
*DISABLE *that function.
Is there a way to do so?
I tried to just delete the number in the year field. THAT did not work.
Any help would be greatly appreciated.
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
- [libreoffice-users] disable 2-digit options · Thomas Blasejewicz
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy