Issue 55161

Summary: Error message for wrong input (date with format of different locale) in validity dialog
Product: Calc Reporter: robertpopa22 <robert.popa>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: cno, issues
Version: 680m130   
Target Milestone: ---   
Hardware: All   
OS: Windows XP   
See Also:
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description robertpopa22 2005-09-28 07:35:17 UTC
The validity option must be improved to be compatible to eXcell:
- first the options already implemented (whole numbers, date, etc.) should work.
I have strugled a lot to understand theese and they simply do not take in
consideration the options specified
- for the list option there is a need to select data from a range in a sheet,
for compatibility reasons (and let's not make it like in eXcell restricted to
the active sheet, but let's give it the possibility to select data from any sheet)
- the only thing that worked was list, where I specified the entries manually
Comment 1 frank 2005-09-28 09:28:17 UTC

not a prio 2 task and 3 'defects' in one Issue -> not acceptable.

Also all of the described problems are not reproducible using OOo1.9.130 so
closing wfm.

Comment 2 frank 2005-09-28 09:28:53 UTC
closed wfm
Comment 3 robertpopa22 2005-09-29 06:17:09 UTC
Try in 1.9.130 Spreadsheet to enter for validity:
- date
- greater than 1/1/2005
- show error message: STOP

or anything else related to date
Comment 4 frank 2005-09-29 09:14:11 UTC
Hi Niklas,

If I set the validity with german locales (Date format DD.MM.YY) and try to
enter the date in american notation (01/01/99) this date is accepted but the
validity is set to accept only values greater than 01/01/2005 .

Please have a look at this one.

Comment 5 frank 2005-09-29 09:14:43 UTC
and re-assigned
Comment 6 niklas.nebel 2005-09-29 10:34:32 UTC
So the problem is caused by input in the validity dialog that doesn't match the
locale setting. A date input in a wrong format isn't valid, and no condition is
created. There should be an error message in that case, but that's nothing for
Comment 7 Marcus 2017-05-20 10:44:30 UTC
Reset the assignee to the default "".