https://bugs.documentfoundation.org/show_bug.cgi?id=164239
Bug ID: 164239
Summary: Inconsistent Interpretation of Year-Month-Day like
strings in Calc
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 Calc encounters strings look like Year-Month-Day, the interpretation
varies unexpectedly. If the year value falls between 1 and 12, Calc interprets
the string as Text. However, Calc correctly interprets the string as a Date
when the year value is either 0 or any number between 13 and the maximum
supported year.
However, when a cell is pre-formatted as YYYY-MM-DD, year values between 1 and
12 are correctly interpreted as dates.
The issue appears more complex than initially reported in
https://bugs.documentfoundation.org/show_bug.cgi?id=164227, raising two
important questions:
1. The examples demonstrate that the preset cell format affects how entered
strings are interpreted into Calc's internal types and values. Is this behavior
intentional or is it a bug?
2. When a cell's format is set to "General" and a string is entered, does Calc:
- interpret it deterministically (always the same way), or
- interpret it conditionally based on the environment (e.g., the types of
surrounding cells)?
Steps to Reproduce:
1. Enter "12-1-1" in one cell
2. Enter "13-1-1" in another cell
3. Set the format as YYYY-MM-DD first, enter "12-1-1"
Actual Results:
1. Text
2. Date
3. Date
Expected Results:
1. Date
2. Date
3. Date
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.
