Date: prev next · Thread: first prev next last
2018 Archives by date, by thread · List index


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


--
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

Context


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.