Re: [libreoffice-users] Calc cell formats

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:                     "users@global.libreoffice.org" 
<users@global.libreoffice.org>
From:                   Thomas Blasejewicz <nyuwa@hb.tp1.jp>
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: 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


+----------------------------------------------------------+
  Michael D. Setzer II -  Computer Science Instructor      
  Guam Community College  Computer Center                  
  mailto:mikes@kuentos.guam.net                            
  mailto:msetzerii@gmail.com
  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: 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