Language:

The Free and Open Productivity Suite
Apache OpenOffice 4.1.7 released

 

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 Events

Apache Software Foundation

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

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