https://bugs.documentfoundation.org/show_bug.cgi?id=147825
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Hardware|x86-64 (AMD64) |All OS|Linux (All) |All Summary|FORMAT CELLS in Calc will |Duration formats |not hold more than 23 hours |([HH]:MM:SS, [MM]:SS, [SS]) |even when set to [HH]:MM:SS |are limited to max uint32 | |seconds values. --- Comment #6 from Eike Rathke <[email protected]> --- In SvNumberformat::ImpGetTimeOutput(), hour, minute and second values are calculated using uint32 and fTime (seconds in double) is limited to D_MAX_U_INT32. Maybe instead we could use uint64 and limit fTime more sensibly depending on how many decimal fractions are to be displayed (e.g. 2^52-1 largest integer value representable in double if no fractions, 2^48-1 if one decimal, 2^44-1 if two, ...), i.e. 2^(52-nCntPost*4)-1 or some such. The duration formats display #FMT since LO 7.0.0 for >4294967296 seconds (71582788 minutes, 1193046 hours, 49710 days). Fwiw, the input value 86399 is in *days* (not seconds), that would be 86399*86400=7464873600 seconds or 124414560 minutes or 2073576 hours. -- You are receiving this mail because: You are the assignee for the bug.
