https://bugs.freedesktop.org/show_bug.cgi?id=76441
Priority: medium
Bug ID: 76441
Assignee: [email protected]
Summary: FORMATTING: time presentation
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.5.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 96151
--> https://bugs.freedesktop.org/attachment.cgi?id=96151&action=edit
snapshot format, cell, input box of Calc sheet
Cell format
MM:SS
type in 1:20 or 01:20
20:00 appears in cell and 01:20:00 AM appears in input box
tried various combos of reformating, retyping, editing contents, no luck. Just
checked - typing in 00:01:20 works, apparently format defaults to HH:MM:SS
This has been a bugbear for me with various spreadsheets [XL etc] for 30 years.
People can't conceive of day/time independant of calendars.
Problem description:
Steps to reproduce:
1. ....
2. ....
3. ....
Current behavior:
enter 1:20 get 20:00
Expected behavior:
1:20
Operating System: Windows 7
Version: 4.1.5.3 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
