| Test Case AOOTest-384: Data -) Validity -) Criteria -)Date -) not between_00059 [Version : 1] | ||
|---|---|---|
| Author: | undefined - 24/10/2012 14:22:31 | |
| Summary: | ||
| Preconditions: | ||
| #: | Step actions: | Expected Results: |
| 1 |
| Expected Results: |
| 2 | New a sc , select a cell range and click menu 'Data -) Validity', select Criteria tab | |
| 3 | select 'Date' from 'Allow' select 'not between' input '01/01/08' into 'Minimum' input '03/01/08' into 'Maximum' | |
| 4 | select 'Error Alert' tab,check 'Show error message when invalid values are entered',input some messages in 'Error message' ,click ok | Validity dialog is closed. |
| 5 | Input '12/31/07' in the range,press 'Enter' | No message dialog |
| 6 | Input '03/02/08' in the range,press 'Enter' | No message dialog |
| 7 | Input '01/01/08' in the range,press 'Enter' | A stop message dialog appears |
| 8 | Press 'Enter' | The date you input in step 6 is not accepted |
| 9 | Input '03/01/08' in the range,press 'Enter' | A stop message dialog appears |
| 10 | Press 'Enter' | The date you input in step 8 is not accepted |
| 11 | Input '01/02/08' in the range,press 'Enter' | A stop message dialog appears |
| 12 | Press 'Enter' | The date you input in step 10 is not accepted |
| 13 | Input '02/29/08' in the range,press 'Enter' | A stop message dialog appears |
| 14 | Press 'Enter' | The date you input in step 12 is not accepted |
| 15 | Input some letters in the range,press 'Enter' | A stop message dialog appears |
| 16 | Press 'Enter' | The text you input in step 14 is not accepted |
| 17 | Input number between 39448 and 39508 (included) in the range,press 'Enter' PS: Datevalue('01/01/08')=39448 Datevalue('03/01/08')=39508 | A stop message dialog appears |
| 18 | Press 'Enter' | The number you input in step 16 is not accepted |
| 19 |
| |
| 20 |
| |
| 21 |
| |
| Execution type: | Manual | |
| Importance: | Medium | |
| Test Focus: | ||
| Feature first available at which release: | ||
| Automation script name: | ||
| Testsuite set: | ||
| Requirements | None | |
| Keywords: | None | |
