https://bugs.documentfoundation.org/show_bug.cgi?id=164227
Bug ID: 164227
Summary: LibreOffice Calc incorrectly treats dots as part of
month names instead of separators on several date
patterns
Product: LibreOffice
Version: 24.8.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When a month name is followed by a dot (e.g. "Jan.", "Feb."), Calc treats the
dot as part of the month name rather than a separator. For example:
- Pattern1: "Jan.-15, 2024" -> Date(2024, 1, 15)
- Pattern2: "Mar.-28" -> Date(2024, 3, 28)
- Pattern3: "Mar.-30" -> Date(1932, 3, 1)
while "1-Jan.-2021" is treated as text instead of date.
Google Sheet will only accept "Jan.1" as date instead of "Jan.-1".
Steps to Reproduce:
To reproduce:
1. Enter "Jan.-15, 2024" in a cell
2. The cell should be formatted as text instead of being parsed as a date
3. Try with other abbreviated month names followed by dots
Actual Results:
Date(2024, 1, 15)
Expected Results:
Treat them as text.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 24.8.3.2 (AARCH64) / LibreOffice Community
Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92
CPU threads: 8; OS: macOS 15.0; UI render: Skia/Metal; VCL: osx
Locale: en-US (en_CN.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
