Issue 125170 - Calc will not allow dates to be entered in the GB/UK format, even with GB Language pack installed
Summary: Calc will not allow dates to be entered in the GB/UK format, even with GB Lan...
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 4.1.0
Hardware: Mac Mac OS X, all
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-06-27 14:28 UTC by handyside
Modified: 2014-06-27 14:28 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

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

Note You need to log in before you can comment on or make changes to this issue.
Description handyside 2014-06-27 14:28:28 UTC 
Date Format set to 31. Dec. 1999
When 5th of July is entered as "5/7", "7. May. 2014" is displayed.
(When 5th of July is entered as "5/7/14", "14. Jul. 2005" is displayed!)

UK format is DD/MM/YYYY
Language is UK
Cell is set to DD. MMM. YYYY
yet still the date displayed is incorrect.

I'm OK with the ISO format SAVING the data that way. 
But I should be able to ENTER the data in the chosen Date Format.
I can in Excel. Why not in OO??