Bug 107647 - Please add new date formats to show only month and year under Format Cell options
Summary: Please add new date formats to show only month and year under Format Cell opt...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.2.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-05-05 13:50 UTC by Peeyush
Modified: 2017-05-05 14:06 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 Peeyush 2017-05-05 13:50:53 UTC 
Description:
Hi!

Suggestion for enhancement:
Please add the following date formats to show only month & year:
Format: Apr 17
Format: April 17
Format: Apr 2017
Format: April 2017

Thankyou!

Steps to Reproduce:
1.Right click on cell 
2.select Format cell
3.select number 
4.Select date 

Actual Results:  
Current option to show month and year is only in numeric format 

Expected Results:
As mentioned in Description


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.81 Safari/537.36
Comment 1 Eike Rathke 2017-05-05 14:03:23 UTC 
You can add them as user defined formats in the number formatter:
MMM YY
MMMM YY
MMM YYYY
MMMM YYYY
Comment 2 Joel Madero 2017-05-05 14:06:03 UTC 
This is already easily possible.

1. right click on cell
2. format cell
3. Numbers tab;
4. User-defined category

Then with format code:
mmm yy = "Apr 17"
mmmm yy = "April 17"
mmm yyyy = "Apr 2017"
mmmm yyyy = "April 2017"

Closing as WFM.