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: [email protected] 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
