Issue 63225 - Time format calculation is limited to 2^32 seconds
Summary: Time format calculation is limited to 2^32 seconds
Status: ACCEPTED
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:
URL:
Keywords:
: 112198 (view as issue list)
Depends on:
Blocks:
 
Reported: 2006-03-15 15:54 UTC by frank
Modified: 2017-05-20 11:13 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

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 "issues@openoffice.apache.org".