https://bugs.documentfoundation.org/show_bug.cgi?id=167528
Bug ID: 167528
Summary: Editing seconds in date/time cell turns value into
text (regression)
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:
In LibreOffice Calc, if a cell contains a valid date/time value (e.g.,
`15.07.2024 14:30`) and the user edits it in the input bar to manually add
seconds (e.g., changing it to `15.07.2024 14:30:00`), the cell **silently
switches from a numeric datetime value to a text string**.
There is no warning or visible `'` prefix, and the formatting remains
"DateTime-like", but the cell is no longer usable in date/time calculations –
formulas like `=(G1-F1)*24` return `#VALUE!`.
Steps to Reproduce:
1. Format a cell as `DD.MM.YYYY HH:MM`
2. Enter a valid datetime: `15.07.2024 14:30`
3. Click into the input line (above the grid), and add `:00` → `15.07.2024
14:30:00`
4. Press Enter
Actual Results:
The cell becomes a **text string** (checked via `ISTTEXT()` and `TYP()`),
without any visible `'`. Calculations fail with `#VALUE!`.
Expected Results:
The cell remains a valid numeric datetime value and can be used in
calculations. The formatting may adjust to include seconds, or the time be
stored correctly internally.
Reproducible: Always
User Profile Reset: No
Additional Info:
Regression:
This behavior did not occur in earlier versions such as LO 7.6.x. Entering
seconds manually did not break datetime values!
Workaround:
Use the `VALUE()` function or “Text to Columns” (with explicit Date format) to
restore numeric datetime values.
Additional Info:
- Version: 24.2.7.2 (x86_64)
- Build ID: 420(Build:2)
- Locale: de-DE
Keywords: regression, datetime, input-bar, formatting, parsing
--
You are receiving this mail because:
You are the assignee for the bug.
