Hi Regina,
Thank you very much. So the number in the cell stands for the days after
certain date. And 49711*86400 = 4295030400, it bigger than
_D_MAX_U_LONG_, So it shows "###". And the other time format needn't
consider the integer portion of the number, so they have no such
limitation.
Thanks again.
Best regards,
Lihua
在 2009-10-16五的 11:56 +0200，Regina Henschel写道：
> Hi Lihua,
>
> Zhu Lihua schrieb:
> > Hi all,
> >
> > There is a time format: [HH]:mm:ss
> >
> > I found it has a value scope from -49710 to 49710, which means from
> > 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.
> >
> > 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?
>
> I'm not sure, because I'm no developer. As far as I know, Eike maintains
> the number formatter. Perhaps ask him?
>
> I found this:
>
> The input number is converted to seconds and this seconds are limited to
> 0xffffffff (=4294967295). But I do not know why they are limited.
>
> You find it in /svtools/source/numbers/zformat.cxx.
> The constant is in line 71
> const double _D_MAX_U_LONG_ = (double) 0xffffffff;
> Line 2486 generates the ###
> if( floor( fTime ) > _D_MAX_U_LONG_ )
> {
> OutString = rScan.GetErrorString();
> return FALSE;
> }
>
> kind regards
> Regina
>
> ---------------------------------------------------------------------
> 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]
