Bug 34977 - FORMATTING/UI: time is apparently lost from datetime cells when reading Excel spreadsheets
Summary: FORMATTING/UI: time is apparently lost from datetime cells when reading Excel...
Status: CLOSED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: All All
: medium normal
Assignee: Eike Rathke
URL:
Whiteboard: numberformat target:3.5.0
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-03 09:03 UTC by Dan Dascalescu
Modified: 2012-02-16 07:31 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Sample Excel file to demonstrate the problem (5.50 KB, application/vnd.ms-excel)
2011-03-03 09:03 UTC, Dan Dascalescu 		Details
Calc doesn't display the time from the datetime cell (27.56 KB, image/png)
2011-03-03 09:04 UTC, Dan Dascalescu 		Details
Gnumeric does display the time when editing the cell (27.56 KB, image/png)
2011-03-03 09:04 UTC, Dan Dascalescu 		Details
Excel displays the time (68.02 KB, image/png)
2011-03-04 05:21 UTC, Dan Dascalescu 		Details
Show Obsolete (1) View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Dan Dascalescu 2011-03-03 09:03:36 UTC 
Created attachment 44078 [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 LibreOffice, 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 Dan Dascalescu 2011-03-03 09:04:35 UTC 
Created attachment 44079 [details]
Calc doesn't display the time from the datetime cell
Comment 2 Dan Dascalescu 2011-03-03 09:04:58 UTC 
Created attachment 44080 [details]
Gnumeric does display the time when editing the cell
Comment 3 Don't use this account, use tml@iki.fi 2011-03-04 02:22:01 UTC 
For Kohei I assume.
Comment 4 Dan Dascalescu 2011-03-04 05:02:47 UTC 
Comment on attachment 44079 [details]
Calc doesn't display the time from the datetime cell

Wrong attachment.
Comment 5 Dan Dascalescu 2011-03-04 05:21:42 UTC 
Created attachment 44115 [details]
Excel displays the time
Comment 6 Kohei Yoshida 2011-03-04 08:00:54 UTC 
Another date formatting issue.  We have no shortage of them...
Comment 7 Eike Rathke 2011-08-05 06:27:26 UTC 
That's pretty easy, I'll do.