https://bugs.documentfoundation.org/show_bug.cgi?id=156886
Bug ID: 156886
Summary: Calc fails to format date as requested
Product: LibreOffice
Version: 7.6.0.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: bogaboga...@gmail.com
Description:
Calc adding an "'" to the date on date format change, fails to format date,
which when removed, formatting happens as initially expected.
Steps to Reproduce:
1. Have a date in LibreOffice Calc appear as 1/3/2023.
2. Right click the cell
3. Click Format Cells
4. Choose Date and select the type of format (I chose the format D. MMM. YYYY)
5. Click OK.
Actual Results:
LibreOffice Calc adds a "'" to the beginning of the date cell value (not
visible at first), and does nothing requested. When this "'" is removed, date
is formatted as initially expected.
Expected Results:
It should have changed the "1/3/2023" date format to "03 January 2023"
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Same applies to multiple date selections and custom date formats
--
You are receiving this mail because:
You are the assignee for the bug.
