Issue 55161

Summary:	Error message for wrong input (date with format of different locale) in validity dialog
Product:	Calc	Reporter:	robertpopa22 <robert.popa>
Component:	formatting	Assignee:	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:	https://issues.apache.org/ooo/show_bug.cgi?id=123286
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

Hi,

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.

Frank

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.

Frank

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
2.0.1.

Comment 7 Marcus 2017-05-20 10:44:30 UTC

Reset the assignee to the default "issues@openoffice.apache.org".