Bug 128119 - FORMATTING> Enter part of a date in a date-formatted cell and receive the fully formatted string
Summary: FORMATTING> Enter part of a date in a date-formatted cell and receive the ful...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.7.1 release
Hardware: x86-64 (AMD64) Linux (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-10-13 11:56 UTC by schoenes-rad
Modified: 2019-10-13 15:09 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 schoenes-rad 2019-10-13 11:56:03 UTC 
Description:
I have formatted a cell as DATE YYYY-MM-DD.  When I enter a date in the format mm-dd I would like to see the result as current YYYY-MM-DD.  MS EXCEL works like that, by the way.

Example:  Current year is 2019.  I enter 9-12 and would like to see (and the cell to contain) a properly formatted date of 2019-09-12 .

Steps to Reproduce:
1.Format the cell as DATE YYYY-MM-DD
2.Enter 10-12
3.

Actual Results:
Shows 10-12

Expected Results:
Show 2019-10-12


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 6.2.7.1
Build ID: 6.2.7.1-1.fc30
CPU threads: 2; OS: Linux 5.2; UI render: default; VCL: gtk3; 
Locale: de-DE (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 1 Xavier Van Wijmeersch 2019-10-13 13:47:41 UTC 
When you add this D-M in tools => options => languages => Date acceptance patterns
you will have the result you want.
For me its not a bug more a WFM

Version: 6.3.2.2
Build ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c
CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: gtk3; 
Locale: nl-BE (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 2 schoenes-rad 2019-10-13 15:09:16 UTC 
Thanks Xavier - works as described!