# Test Name: Template Test

Document Owner: Vladimir Kozlovsky | Last Document Change: 26. 04. 2009 | Status of Document: Preliminary

### Test purpose

Verify that the function HYPERLINK works as expected

### Known issues:

- issue 27972

### Preconditions of the test:

- none

### Test documents

- i27972_Hyperlink_Test.xls

### Test cases

##### Test case 1

- Open test document 'i27972_Hyperlink_Test.xls'

- Make sure that the A1 cell returns text "http://www.example.org"
- Select A1 cell
- Expected result: hyperlink cell A1 is defined by '=HYPERLINK("http://www.example.org")' formula and creates "http://www.example.org" as URL

- Make sure that the A2 cell returns text "Click here"
- Select A2 cell
- Expected result: hyperlink cell A2 is defined by '=HYPERLINK("http://www.example.org";"Click Here")' formula and creates "http://www.example.org" as URL

- Make sure that the A3 cell returns text "http://www.example.org"
- Select A3 cell
- Expected result: hyperlink cell A3 is defined by '=HYPERLINK("http://www.")&"example.org"' formula and creates "http://www.example.org" as URL

- Make sure that the A4 cell returns text "Click example.org"
- Select A4 cell
- Expected result: hyperlink cell A4 is defined by '=HYPERLINK("http://www.";"Click ")&"example.org"' formula and creates "http://www.example.org" as URL

- Make sure that the A5 cell returns text "http://www.example.org"
- Select A5 cell
- Expected result: hyperlink cell A5 is defined by '=HYPERLINK("")&"http://www.example.org"' formula and creates "http://www.example.org" as URL

- Make sure that the A6 cell returns text "Click http://www.example.org"
- Select A6 cell
- Expected result:hyperlink cell A6 is defined by '=HYPERLINK("";"Click ")&"http://www.example.org"' formula and creates "http://www.example.org" as URL

- Make sure that the A7 cell returns text "Click"
- Select A7 cell
- Expected result: hyperlink cell A7 is defined by '=MID(HYPERLINK("http://www.example.org";"Click here");1;5)' formula and creates "http:" as URL

- Make sure that the A8 cell returns text "http://www.example.org"
- Select A8 cell
- Expected result: hyperlink cell A8 is defined by '=IF(TRUE();HYPERLINK("http://www.example.org");"something")' formula and creates "http://www.example.org" as URL

- Make sure that the A9 cell returns text "something"
- Select A9 cell
- Expected result: hyperlink cell A9 is defined by '=IF(FALSE();HYPERLINK("http://www.example.org");"something")' formula and creates "something" as URL

- Make sure that the A10 cell returns text "1"
- Select A10 cell
- Expected result: hyperlink cell A10 is defined by '=IF(FALSE();HYPERLINK("http://www.example.org");1)' formula and creates "1" as URL

- Make sure that the A11 cell returns Boolean result TRUE
- Select A11 cell
- Expected result: hyperlink cell A11 is defined by '=IF(FALSE();HYPERLINK("http://www.example.org");1=1)' formula and creates "1" as URL

- Make sure that the A12 cell returns '#DIV/0!'
- Select A12 cell
- Expected result: hyperlink cell A12 is defined by '=HYPERLINK("http://www.example.org")&(1/0)' formula and does not create a hyperlink cell, because an error code would be part of the URL. The cell result is '#DIV/0!'

- Make sure that the A13 cell returns text "http://www.example.org"
- Select A13 cell
- Expected result: hyperlink cell A13 is defined by '=HYPERLINK($B4)' formula, where B4 contains "http://www.example.org", and creates "http://www.example.org" as URL

- Save document to 'i27972_Hyperlink_Test.ods'
- Open document 'i27972_Hyperlink_Test.ods'
- Repeat all steps defined above
- Expected result: Nothing changed

### References (specification):

- http://specs.openoffice.org/