Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.11

 

Test Case AOOTest-387: Data -) Validity -) Criteria -)Time -) between (through 00:00)_00067 [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 'Time' from 'Allow'

select 'between'

input '27:00' into 'Maximum' (next day 3:00)

input '21:00' into 'Minimum'

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 '27:00' in the range,press 'Enter'

No message dialog

6

Input '21:00' in the range,press 'Enter'

No message dialog

7

Input 1.125 in the range,press 'Enter'

PS : TimeValue('27:00')=1.125

No message dialog

8

Input 0.875 in the range,press 'Enter'

PS : TimeValue('21:00')=0.875

No message dialog

9

Input '03:00:01' in the range,press 'Enter'

A stop message dialog appears

10

Press 'Enter'

The time you input in step 8 is not accepted

11

Input '20:59:59' in the range,press 'Enter'

A stop message dialog appears

12

Press 'Enter'

The time you input in step 10 is not accepted

13

Input 1.126 in the range,press 'Enter'

A stop message dialog appears

14

Press 'Enter'

The number you input in step 12 is not accepted

15

Input 0.874 in the range,press 'Enter'

A stop message dialog appears

16

Press 'Enter'

The number you input in step 14 is not accepted

17

Input letters in the range,press 'Enter'

A stop message dialog appears

18

Press 'Enter'

The letters you input in step 16 is not accepted

19

Input 24:00 in the range,press 'Enter'

No message dialog

20

Input 12:00 in the range,press 'Enter'

A stop message dialog appears

21

Press 'Enter'

The time you input in step 19 is not accepted

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.