[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[libreoffice-users] disable 2-digit options
- Subject: [libreoffice-users] disable 2-digit options
- From: Thomas Blasejewicz <email@example.com>
- Date: Sat, 29 Dec 2018 23:18:45 +0900
- To: firstname.lastname@example.org
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: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
|Re: [libreoffice-users] disable 2-digit options||Brian Barker <firstname.lastname@example.org>|
|Re: [libreoffice-users] disable 2-digit options||Luuk <email@example.com>|
- Prev by Date: Re: [libreoffice-users] Calc error?
- Next by Date: Re: [libreoffice-users] disable 2-digit options
- Previous by thread: [libreoffice-users] Calc error?
- Next by thread: Re: [libreoffice-users] disable 2-digit options