To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106977 Issue #|106977 Summary|truncated time format when importing from xls Component|Spreadsheet Version|OOO310m19 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|open-import Assigned to|spreadsheet Reported by|michaelkuss
------- Additional comments from michaelk...@openoffice.org Tue Nov 17 15:54:43 +0000 2009 ------- 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. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
