[libreoffice-users] Calc cell formats

Good evening
I do have (naturally) a number of spread sheets.
One is a list of my patients.
It includes columns with name, sex, age, date of birth etc.

I did create a page style, where I tried to set "numbers" to standard
(because there are NO decimals!)
and "date" to "1999/02/10".

(the file originally was a Lotus123 file, saved in Excel 2003 format,
read with Calc and then saved as ODS)
However, when I apply that style, the "date" which had been
unintelligible 5-digit numbers changes to the
specified format, but at the same time columns with the age of patients
(TWO digits, no calcuations whatsoever)
and consecutive numbers switch to a row of three # =because they are to
narrow to display the "1900/02/10) inserted.
What is this nonsense all about???
Why is the age of a person (e.g. 33) be replaced by a nonsense date?

Also, while I specified the date as given above, opening the very same
file under kubuntu, it suddenly is reverse to 02/10/1999. Why?

AND the style I specified does not seem to be retained.
When I close the file and reopen (in particular if this is on another
computer) it, the settings seem to have vanished.

Thank you.
Thomas



-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted