Re: [libreoffice-users] disable 2-digit options

On 29-12-2018 15:18, Thomas Blasejewicz wrote:
> Good evening
> 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.
> Problem:
> I DID set a certain "date format"
> and
> 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
> 25                                   1900/1/24
> 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.
>
> Thank you.
> Thomas

A date is kept, internally, as a number.

So if a cell contains 33, nd is displayed as a date, you will get 
'1900/2/1', which is 33 days after counting the days started.


BTW: Why are you storing age ? Next year all your patients are one year 
older. Is it not much better to just store birthdates?




--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy