Bug 152772

Summary:	Custom Date Format bug
Product:	LibreOffice	Reporter:	david.c.day
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	normal	CC:	miguelangelrv
Priority:	medium
Version:	7.4.3.2 release
Hardware:	All
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description david.c.day 2022-12-31 12:26:21 UTC

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

Comment 1 MM 2022-12-31 15:38:55 UTC

Unconfirmed on windows 10 x64 with Version: 7.4.3.2 (x64) / LibreOffice Community
Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890
CPU threads: 12; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win UI: en-US Calc: CL

Comment 2 m_a_riosv 2022-12-31 20:37:25 UTC

Maybe the option
Menu/Tools/Options/LibreOffice/General - Year two digits.

Comment 3 david.c.day 2022-12-31 21:54:11 UTC

The option is set to "1930" to 2029.

This is not the issue at hand - the date which appears in the spreadsheet with that custom format applied is in the correct format, but it is set to "Dec 99" when it should reflect the data in the cell - so, it seems to be picking up the example date, not the cell date.  This was in the topmost, leftmost cell, and I would have entered the data as "1/1/23" or possibly "=1/1/23" - THAT may be the problem...