Hi Joost, Thank you very much for the reply.
I tried in OOo-DEV3.2 just now, input 49958 in a cell and format it to that format will show "###", and change the width doesn't work. Best regards, Lihua 在 2009-10-14三的 13:07 +0200，Joost Andrae写道： > Hi, > > > There is a time format: [HH]:mm:ss > > this time format allows to count hours > 24 hours > > A1 03:00 > A2 23:00 > A3 =sum(a1:a2) ==> 02:00:00 > > if you format A3 as [HH]:mm:ss then A3 gives 26:00:00 (26 hours) > > > > > I found it has a value scope from -49710 to 49710, which means from > > the value scope must be higher because I can create a date of 2036-10-10 > having the date value of 49958 > > > Nov/23/1763 00:00:00 to Feb/6/2036 00:00:00. But this format show hour > > value as hours passed since Dec/30/1899, So it's value is 1193040:00:00. > > > > the default value for the zero point for date values is 1899-12-30. Calc > can handle both negative and positive values for a date value. For the > value -1 Calc would display 1899-12-29. The default value can be changed > (in /tools/options/calc/calculate) to 1900-1-1 (to be compatible to > StarCalc 1.0 documents) and to 1904-1-1 to stay compatible to older > Excel documents. > > > Input 49711 with this time format will display "###" in the cell. I > > guess it must be out side of the permitted scope. But why it has this > > limitation? I guess it must have something to do with the storage of the > > time in the memory. I wonder how it stored? and why it has this > > limitation? Could anyone give me some hint? > > change the cell width. The value just doesn't fit into the cell boundaries. > > Kind regards, Joost > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > -- Lihua 北京红旗贰仟软件技术有限公司 Beijing Redflag 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.6141 http://www.RedOffice.com --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
