Testname: Functions: ISERROR(undefinedname) results in TRUE

Document Owner:

Oliver Craemer

Last document change:

28.02.2008

Status of document:

Standard

Valid for version: OpenOffice.org_3.0

Test purpose:

Verify that the ISERROR function works correctly

Known issues:

Preconditions of test:

Functionnames are localized. In this test the english names are used. For non-english version please use the names used in your locale

Test documents:

-

Testcases:

ISERROR(undefinedname) results in TRUE Status: Standard -
  • Open new spreadsheet document
  • In cell A1 enter '=ISERROR(undefined)'
  • Verify that the cell shows 'TRUE'
  • Save document to *.ods
  • Close and reload the document
  • Verify that cell A1 still shows 'TRUE'
  • Close document
ISERROR(CHOOSE(0;"text1";"text2")) results in TRUE Status: Standard -
  • Open new spreadsheet document
  • In cell A1 enter '= ISERROR(CHOOSE(0;"text1";"text2")) '
  • Verify that the cell shows 'TRUE'
  • Save document to *.ods
  • Close and reload the document
  • Verify that cell A1 still shows 'TRUE'
  • Close document
ISERROR(VLOOKUP("abc";undefinedname;2;0)) results in TRUE Status: Standard -

  • Open new spreadsheet document

  • In cell A1 enter '=ISERROR(VLOOKUP("abc";undefinedname;2;0))
  • Verify that the cell shows 'TRUE'
  • Save document to *.ods
  • Close and reload the document
  • Verify that cell A1 still shows 'TRUE'
  • Close document
ISERROR(ISEVEN(SUM(undefinedname))) results in TRUE Status: Standard -

  • Open new spreadsheet document

  • In cell A1 enter '=ISERROR(ISEVEN(SUM(undefinedname)))'
  • Verify that the cell shows 'TRUE'
  • Save document to *.ods
  • Close and reload the document
  • Verify that cell A1 still shows 'TRUE'
  • Close document
ISERROR((12*34)+(56+INT(AVERAGE(undefinedname)))) results in TRUE Status: Standard -

  • Open new spreadsheet document

  • In cell A1 enter '=ISERROR((12*34)+(56+INT(AVERAGE(undefinedname))))�
  • Verify that the cell shows 'TRUE'
  • Save document to *.ods
  • Close and reload the document
  • Verify that cell A1 still shows 'TRUE'
  • Close document

References:

-

Acronyms:

-

testcase specification history

Functions: ISERROR(undefinedname) results in TRUE
Date Change User
28.02.2008 (18:17:14) status updated Oliver Craemer
28.02.2008 (18:16:57) status updated Oliver Craemer
28.02.2008 (18:16:42) status updated Oliver Craemer
28.02.2008 (18:16:28) testcase details added Oliver Craemer
28.02.2008 (18:12:34) testcase added Oliver Craemer
28.02.2008 (18:11:30) testcase details updated Oliver Craemer
28.02.2008 (18:07:21) testcase details added Oliver Craemer
28.02.2008 (18:06:14) testcase added Oliver Craemer
28.02.2008 (18:04:29) testcase deleted Oliver Craemer
28.02.2008 (18:03:58) testcase details updated Oliver Craemer
28.02.2008 (18:01:45) testcase details added Oliver Craemer
28.02.2008 (17:59:22) testcase added Oliver Craemer
28.02.2008 (17:58:47) testcase details updated Oliver Craemer
28.02.2008 (17:56:27) testcase details updated Oliver Craemer
28.02.2008 (17:54:41) testcase details updated Oliver Craemer
28.02.2008 (17:51:51) testcase details added Oliver Craemer
28.02.2008 (17:49:15) testcase added Oliver Craemer
28.02.2008 (17:48:36) status updated Oliver Craemer
28.02.2008 (17:48:20) testcase details added Oliver Craemer
28.02.2008 (17:46:15) testcase added Oliver Craemer
27.02.2008 (09:38:30) status updated Oliver Craemer
27.02.2008 Testcase specification created Oliver Craemer