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]
