[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

References:
[libreoffice-users] disable 2-digit optionsThomas Blasejewicz <nyuwa@hb.tp1.jp>
Privacy Policy | Impressum (Legal Info) | Copyright information: 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.