https://bugs.documentfoundation.org/show_bug.cgi?id=167885
Bug ID: 167885
Summary: LibreCalc doesn't understand times in HH:MMa or HH:MMp
format
Product: LibreOffice
Version: 24.2.7.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I'm trying to enter times in HH:MMa/HH:MMp format. For instance, the following
should translate, but they all enter in as generic text:
* 5:25a should become a time-formatted cell of 05:25 AM
* 12:55p should become 12:55 PM
* 12:00n should become 12:00 PM (12 noon)
* 12:00m should become 12:00 AM (12 midnight)
Steps to Reproduce:
1. Open a new spreadsheet
2. Enter in anything with HH:MMa formatting into a cell
Actual Results:
Cell turns into a text-formatted cell.
Expected Results:
Cell turns into a time-formatted cell with HH:MM AM/PM format (or whatever is
defined)
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
--
You are receiving this mail because:
You are the assignee for the bug.