https://bugs.documentfoundation.org/show_bug.cgi?id=161552
Bug ID: 161552
Summary: Calc's date format fails
Product: LibreOffice
Version: 24.2.4.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Formatting a cell as date format fails when date is in month/date/year format
(American style). Calc turns the cells into comments
* I open a CSV file with cell dates like 05/26/2025
* I format the cells for Date and any format like MM/DD/YY or MMM D, YYYY
* Calc converts the date to a comment as in '05/26/2025
* I suspect it does not understand American date format
* If input date is d/m/y format 26/05/2025 it is handled as a date
Steps to Reproduce:
1. I open a CSV file with cell dates like 05/26/2025
2. I format the cells for Date and any format like MM/DD/YY or MMM D, YYYY
3. Calc converts the date to a comment as in '05/26/2025
* I suspect it does not understand American date format
* If input date is d/m/y format 26/05/2025 it is handled as a date
Actual Results:
Calc converts the date to a comment as in '05/26/2025
Expected Results:
A date, formatted in the format I pick, sortable as a date
Reproducible: Always
User Profile Reset: Yes
Additional Info:
I just download LibraOffice yesterday and I am testing it out to see if I can
swap away from MS Office products. This was one of the issues I found. Another
is that LibraOffice Calc crashed on me. I can't recreate that one yet, so not
reporting it.
Version: 24.2.4.2 (X86_64) / LibreOffice Community
Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2
CPU threads: 20; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
