I am thinking the cell is formated to a date format. That number 0 is referenced to 1899-12-30, so when changed to dates 0 to 33 show these numbers. Interestingly, excel uses a simpler date, but last time I checked it didn't work with negative numbers, but calc does??
0 1899-12-30 1 1899-12-31 2 1900-01-01 3 1900-01-02 4 1900-01-03 5 1900-01-04 6 1900-01-05 7 1900-01-06 8 1900-01-07 9 1900-01-08 10 1900-01-09 11 1900-01-10 12 1900-01-11 13 1900-01-12 14 1900-01-13 15 1900-01-14 16 1900-01-15 17 1900-01-16 18 1900-01-17 19 1900-01-18 20 1900-01-19 21 1900-01-20 22 1900-01-21 23 1900-01-22 24 1900-01-23 25 1900-01-24 26 1900-01-25 27 1900-01-26 28 1900-01-27 29 1900-01-28 30 1900-01-29 31 1900-01-30 32 1900-01-31 33 1900-02-01 On 2 Oct 2015 at 19:38, Thomas Blasejewicz wrote: To: "[email protected]" <[email protected]> From: Thomas Blasejewicz <[email protected]> Subject: [libreoffice-users] Calc cell formats Date sent: Fri, 2 Oct 2015 19:38:50 +0900 > 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 > +----------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:[email protected] mailto:[email protected] http://www.guam.net/home/mikes Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +----------------------------------------------------------+ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS ROSETTA 34991272.095630 | SETI 63447742.029277 ABC 16613838.513356 | EINSTEIN 73361235.218894 -- 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
