Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.11

 

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

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.