https://bugs.freedesktop.org/show_bug.cgi?id=65267
Priority: medium
Bug ID: 65267
Assignee: [email protected]
Summary: FORMATTING: Inputting times as HHMM to cells formatted
as HHMM produces unexpected results
Severity: normal
Classification: Unclassified
OS: Mac OS X (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.0.2.2 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
When trying to input a time, for example a quarter past four in the afternoon
as HHMM, that is 1615, to a cell with a format code HHMM, the result is
something else than 1615. Inputting 1615 results to 06/02/1904 00:00:00. It
seems to me that the input is being interpreted as a date.
Steps to reproduce:
1. Set cell format code to HHMM
- Right click on cell, choose Format cell...
- Set format code to HHMM and click ok.
2. Input time as HHMM
- Enter a time, for example 1615 and press enter.
3. Cell displays now 0000 and holds a wildly different time.
Current behavior:
Cell displays 0000 and contains a date from 12/30/1899 00:00:00 to 06/16/1906
00:00:00 depending on the time entered, assuming that a time from 0000 to 2359
is entered.
Expected behavior:
Cell displays the time entered and contains the time entered.
Operating System: Mac OS X
Version: 4.0.2.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
