Bug 152772 - Custom Date Format bug
Summary: Custom Date Format bug
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.3.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-12-31 12:26 UTC by david.c.day
Modified: 2022-12-31 21:54 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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...