Issue 63225 - Time format calculation is limited to 2^32 seconds
Summary: Time format calculation is limited to 2^32 seconds
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.0.2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 112198 (view as issue list)
Depends on:
Reported: 2006-03-15 15:54 UTC by frank
Modified: 2017-05-20 11:13 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description frank 2006-03-15 15:54:11 UTC
Open a new spreadsheet
type 65535 into a cell
apply a border to this cell and set the numberformat to time (hh:mm:ss)
As you can see, the cell now displays zero time and the edit line changed to
three hashes.
Comment 1 niklas.nebel 2006-03-15 17:53:10 UTC
It has nothing to do with borders. 65535 days are more than 2^32 seconds, which
is the limit of time calculation. This might be changed later, but it doesn't
seem important at all.
Comment 2 ooo 2006-03-15 19:42:08 UTC
Accepted. Adapting summary. Enhancement.
Btw, the input limit of hours is a 16bit value, more than that wrap, e.g.
65535:00:00 is ok, 65536:00:00 wraps to 00:00:00
Comment 3 ooo 2010-06-08 15:22:04 UTC
*** Issue 112198 has been marked as a duplicate of this issue. ***
Comment 4 longcalcunog 2010-10-23 15:41:14 UTC
Created attachment 72630
Comment 5 Marcus 2017-05-20 11:13:43 UTC
Reset assigne to the default "".