Issue 106977

Summary: damaged time format hh:mm:ss and [hh]:mm:ss for Nos bigger 65535
Product: Calc Reporter: michaelkuss <michael.w.kuss>
Component: formattingAssignee: spreadsheet <spreadsheet>
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P4 CC: issues, rainerbielefeld_ooo_qa
Version: OOO310m19Keywords: oooqa
Target Milestone: ---   
Hardware: PC   
OS: Linux, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Excel screen shot
none
oocalc screen shot
none
the xls file to be imported into oocalc none

Description michaelkuss 2009-11-17 15:54:43 UTC 
When importing MS Excel xls files (I don't know which version created them), I
noticed that fields format with [HH]:MM:SS with HH larger than 65536 are
truncated to an unsigned short int variable.  I will attach screen shots of
Excel of oocalc, and the xls file in question.

It seems to me that for the HH value in oocalc is reserved an unsigned short int
variable only. This can be verified by just entering 66000:00:00 into a cell. It
will show up as 464:00:00.
Comment 1 michaelkuss 2009-11-17 15:55:48 UTC 
Created attachment 66155 [details]
Excel screen shot
Comment 2 michaelkuss 2009-11-17 15:56:49 UTC 
Created attachment 66156 [details]
oocalc screen shot
Comment 3 michaelkuss 2009-11-17 15:58:16 UTC 
Created attachment 66157 [details]
the xls file to be imported into oocalc
Comment 4 Rainer Bielefeld 2009-11-17 19:11:29 UTC 
That's not an EXCEL document, but some html-rtf-mixing (AFAIK such documents can
be created using EXCEL). My MS-EXCEL-Viewer won't open it, so the OOo result is
not so bad ;-)
Documents renamed to .html or .rtf will be opened correctly.

The problem hasn't to do with the import, but sith limitations in the number size.

Steps to reproduce:

1. open new CALC document
2. insert "61789:02:30"
   cell will look as input, formatting will be [HH]:MM:SS

12. insert "65534:02:30"
    cell will look as input, formatting will be [HH]:MM:SS

22. insert "65535:02:30"
    cell will look as input, formatting will be [HH]:MM:SS

23. insert "65536:02:30"
    expected cell will look as input, formatting will be [HH]:MM:SS
    Actual: "00:02:30"


*** This issue has been marked as a duplicate of 59919 ***
Comment 5 Rainer Bielefeld 2009-11-17 19:31:58 UTC 
.