https://bugs.documentfoundation.org/show_bug.cgi?id=152772
Bug ID: 152772
Summary: Custom Date Format bug
Product: LibreOffice
Version: 7.4.3.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Adding a user defined date format, the cell takes the sample data as its
content, not the cell data. So, if while designing the format "Dec 99" is
used, that is what the cell shows when the format is applied and the dialogue
box closed.
,
Steps to Reproduce:
1. Type a date into a cell - try 1/1/23
2. Right click, format cells
3. Select User-defined
4. Enter "MMM YY" as the format code - sample box shows "Dec 99"
5. Click OK
Actual Results:
The cell in the spreadsheet now shows "Dec 99"
Expected Results:
The cell should show "Jan 23"
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: yes
--
You are receiving this mail because:
You are the assignee for the bug.
