https://bugs.documentfoundation.org/show_bug.cgi?id=164124
Bug ID: 164124
Summary: Is the interpretation of entered strings in
LibreOffice Calc influenced by the cell format?
Product: LibreOffice
Version: 24.8.3.2 release
Hardware: ARM
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I encountered an issue where entering ‘2021-6/1’ produces different results
based on the cell’s format:
if the format is ‘YYYY-MM-DD’, it is interpreted as a date;
otherwise, for formats like ‘MMM DD,’ it is treated as text.
Steps to Reproduce:
1. Set the cell format as YYYY-MM-DD, enter string "2021-6/1"
2. Set the cell format as MMM-DD, enter string "2021-6/1"
Actual Results:
I believe the underlying interpretation rules should be independent of the cell
format.
Expected Results:
1. date 1905-07-19
2. text 2021-6/1
Reproducible: Always
User Profile Reset: No
Additional Info:
I believe the entered string ‘2021-6/1’ should be interpreted as text,
regardless of the cell format.
--
You are receiving this mail because:
You are the assignee for the bug.
