Issue 52483 - Entering dates in the key field doesn't work
Summary: Entering dates in the key field doesn't work
Status: CLOSED DUPLICATE of issue 26928
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.0 Beta
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-07-26 12:00 UTC by henrikclausen
Modified: 2005-08-04 13:33 UTC (History)
1 user (show)

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

Attachments
Entering new date in field B2 is not possible. BTW: Locale is Danish. (22.50 KB, application/vnd.ms-excel)
2005-07-26 12:01 UTC, henrikclausen 		no flags Details
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 henrikclausen 2005-07-26 12:00:19 UTC 
A compatibility issue with an Excel spreadsheet. The spreadsheet is supposed to
create a one month calendar based on a date to be entered in field B2. Calc
refuses to accept any format of date I enter, thus the calendar creation does
not work. Works fine in Excel. I'll enclose the spreadsheet next.
Comment 1 henrikclausen 2005-07-26 12:01:31 UTC 
Created attachment 28226 [details]
Entering new date in field B2 is not possible. BTW: Locale is Danish.
Comment 2 henrikclausen 2005-07-26 12:05:17 UTC 
This is tested in build 100 and build 121. 

Windows XP is English, but running with Danish locale settings - might be
contributing cause. 

Editing the existing value (like changing the month from '07' to '08') of B2 is
not possible either. The error message in every case is: "The value entered is
invalid" (as translated from Danish).
Comment 3 frank 2005-08-04 13:33:36 UTC 
Hi,

this is a double to Issue 26928.

To solve your problem, just switch off the validation settings under Data Validity.

Frank

*** This issue has been marked as a duplicate of 26928 ***
Comment 4 frank 2005-08-04 13:33:49 UTC 
closed double