https://bugs.documentfoundation.org/show_bug.cgi?id=155194
Bug ID: 155194
Summary: EDITING: Date/time is recognized as text on edit
Product: LibreOffice
Version: 7.4.6.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
In the following case it is impossible to EDIT a date/time value.
Steps to reproduce:
- Open Libre Office Calc, creating a new spreadsheet
- Under "Tools" -> "Options" -> Language Settings" -> "Languages" -> "Date
acceptance patterns" enter "D.M.Y" (without quotation marks)
- In the cell A1 enter a value "2023-05-27 09:00" (without quotation marks)
-> We see "###" in the cell
- Enlarge column width to see a value
-> We see "2023-05-27 09:00:00"
- Change format code ("Format" -> "Cells") from "YYYY-MM-DD HH:MM:SS" to
"DD.MM.YYYY HH:MM:SS"
-> We see "27.05.2023 09:00:00" in the cell and "05/27/2023 09:00:00" in the
"Input line"
- Press "F2" to edit the value
-> Value in the cell changes to "05/27/2023 09:00:00"
- Edit the value (e.g. replace the last zero by the same value, zero), press
"Enter"
-> Formatting changes to left-justified, the value is not a date/time anymore
but text. Any formula based on this cell (like "A1+1") shows "#VALUE"
- The same happens if I try to edit a value in the Input line.
Expected behavior:
- On Edit, the value should be formatted such a way, that it will be recognized
back.
- It should be possible to enter "27.05.2023 09:00:00" as date/time.
--
You are receiving this mail because:
You are the assignee for the bug.
