Issue 106977 - damaged time format hh:mm:ss and [hh]:mm:ss for Nos bigger 65535
Summary: damaged time format hh:mm:ss and [hh]:mm:ss for Nos bigger 65535
Status: CLOSED DUPLICATE of issue 59919
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOO310m19
Hardware: PC Linux, all
: P4 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2009-11-17 15:54 UTC by michaelkuss
Modified: 2009-11-17 19:31 UTC (History)
2 users (show)

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

Attachments
Excel screen shot (20.49 KB, image/png)
2009-11-17 15:55 UTC, michaelkuss 		no flags Details
oocalc screen shot (71.27 KB, image/png)
2009-11-17 15:56 UTC, michaelkuss 		no flags Details
the xls file to be imported into oocalc (907 bytes, application/vnd.ms-excel)
2009-11-17 15:58 UTC, michaelkuss 		no flags Details
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 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 
.