Issue 55161 - Error message for wrong input (date with format of different locale) in validity dialog
Summary: Error message for wrong input (date with format of different locale) in valid...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 680m130
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-09-28 07:35 UTC by robertpopa22
Modified: 2017-05-20 10:44 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
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 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".