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
Depends on:
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: ---

Entering new date in field B2 is not possible. BTW: Locale is Danish. (22.50 KB, application/
2005-07-26 12:01 UTC, henrikclausen
no flags Details

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

this is a double to Issue 26928.

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


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