| Summary: | FORMATTING/UI: time is apparently lost from datetime cells when reading Excel spreadsheets | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Dan Dascalescu <ddascalescu+freedesktop> |
| Component: | Calc | Assignee: | Eike Rathke <erack> |
| Status: | CLOSED FIXED | ||
| Severity: | normal | ||
| Priority: | medium | ||
| Version: | 3.3.0 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | numberformat target:3.5.0 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
Sample Excel file to demonstrate the problem
Calc doesn't display the time from the datetime cell Gnumeric does display the time when editing the cell Excel displays the time |
||
Created attachment 44079 [details]
Calc doesn't display the time from the datetime cell
Created attachment 44080 [details]
Gnumeric does display the time when editing the cell
For Kohei I assume. Comment on attachment 44079 [details]
Calc doesn't display the time from the datetime cell
Wrong attachment.
Created attachment 44115 [details]
Excel displays the time
Another date formatting issue. We have no shortage of them... That's pretty easy, I'll do. |
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).