Hi Zhu Lihua, Zhu Lihua wrote: > Hi, all, > > When we input a time (e.g., 11:07) in a cell and convert it into one of a > date format with time (e.g., 2008/1/29 11:07), the actual result is > 1899/12/30 11:07. > > I input a 0 in cell and convert it into a date format. The result is > 1899/12/30. > > So I think program takes 0 as default date information of the missing date > information of the input time. > > Now my questions: > > 1. Why 0 equals 1899/12/30? Is this a convention or a definition of Sun?
Yes, 1899/12/30 is a default. > > 2. Is this just a date tells the users that this is not a certain date? > because we can't determine the date it should be. The Excel default here is 1899/12/31. Please note it's one day difference to OOo Calc. > > BTW, I found in MSExcel, it converted into a "wrong" date: 1900/1/0. I guess > maybe my 2nd question is the purpose? > The reason behind all this is a Excel bug. Excel's internal calendar knows the date 1900/02/29. For Excel 1900 is a leap year, although 1900 was definitely not [1]. Because OOo developers did not consider to implement a bug for compatibility reasons, you will find one day difference for all days before 1900/02/29. Later dates are equal in both applications. [1] Leap year rules: - Leap year is every year, that can be divided by four (four year rule) - Four year rule does not apply for years, that can be divided by 100, this means i.e. 1900 is *no* leap year - 100 year rule is not valid for years, that can be divided by 400, this means i.e. year 2000 is a leap year Best regards Peter -- Peter Junge Open Source Strategy Director 北京红旗中文贰仟软件技术有限公司 Beijing Redflag Chinese 2000 Software Co., Ltd. Building No.2, Block A, Huilongsen, 18 Xihuan Nanlu Beijing Economic-Technological Development Area Beijing - P.R.China Tel：+86-10-51570010 ext.6183 http://www.redflag2000.cn http://www.redflag2000.cn/english/index.htm --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
