Issue 117198 - Time is apparently lost from datetime cells when reading Excel spreadsheets
Summary: Time is apparently lost from datetime cells when reading Excel spreadsheets
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.2
Hardware: PC Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-03 17:18 UTC by dandv
Modified: 2014-08-25 17:44 UTC (History)
2 users (show)

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

Attachments
Sample Excel file to demonstrate the problem (5.50 KB, application/vnd.ms-excel)
2011-03-03 17:18 UTC, dandv 		no flags Details
Gnumeric does dislplay the time (27.56 KB, image/png)
2011-03-03 17:18 UTC, dandv 		no flags Details
Gnumeric does display the time when editing the cell (27.56 KB, image/png)
2011-03-03 17:20 UTC, dandv 		no flags Details
Excel displays the time (68.02 KB, image/png)
2011-03-04 13:20 UTC, dandv 		no flags Details
Show Obsolete (1) 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 dandv 2011-03-03 17:18:26 UTC 
Created attachment 75985 [details]
Sample Excel file to demonstrate the problem

Excel has this neat feature that if the format of a cell is YYYY-MM-DD, it can
also store a time for the cell (HH:MM:SS). The time isn't displayed in the
cell, but it's display in the edit box at the top when the cursor is over the
cell. This feature is useful when the user is interested in the date, and only
occasionally in the time, as it allows a date column to be sized to contain
only the date (see the attached sample Excel file).

When opening such an Excel file in OO, Calc doesn't display the time
at all, not even when pressing F2 to edit the cell. By comparison, Gnumeric
displays the time in that case (see the attached screenshots).
Comment 1 dandv 2011-03-03 17:18:55 UTC 
Created attachment 75986 [details]
Gnumeric does dislplay the time
Comment 2 dandv 2011-03-03 17:20:03 UTC 
Created attachment 75987 [details]
Gnumeric does display the time when editing the cell

PS: I couldn't search if this issue has been already reported because the Search button at http://qa.openoffice.org/issue_handling/pre_submission.html is broken. Also, the "join" and "login" links on that page are broken. All in all, submitting this bug was a hassle.
Comment 3 dandv 2011-03-04 13:06:56 UTC 
Comment on attachment 75986 [details]
Gnumeric does dislplay the time

Wrong attachment
Comment 4 dandv 2011-03-04 13:20:50 UTC 
Created attachment 75998 [details]
Excel displays the time
Comment 5 Oliver-Rainer Wittmann 2012-06-13 12:31:55 UTC 
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.
Comment 6 gg43 2013-01-18 22:42:18 UTC 
In my opinion the problem in Calc is:
when a cell contain a number and you define one cell format (number, scientific, currency) in edit field appears always the original value (example number 123,457 with format 1234,12 in cell we see 123,46 and in edit field 123,457) but this does not happen when field contains a date time and the format in only date or if format is only time (in this case we see in edit field only date or date time expressed in time)
I confirm this bug


 Platform: 
Operating System: Windows 7 Home Premium Version 6.1.7601 Service Pack 1 Build 7601 (x64)
Apache Open Office 3.4.1 AOO341m1 Build 9593 Rev 1369110
Comment 7 Andreas Säger 2014-08-25 17:44:45 UTC 
LibreOffice 3.5 displays the time in the status bar.
AOO hides the decimal fraction (time of day) when the cell is formatted as date which can be quite misleading because nothing indicates the true cell value.