Testname: Functions: SUMIF

Document Owner:

Oliver Craemer

Last document change:

28.02.2008

Status of document:

Standard

Valid for version: OpenOffice.org_3.0

Test purpose:

The return value for calculation with the SUMIF function should be tested

Known issues:

Preconditions of test:

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

Test documents:

i85000_SUMIF.ods

Testcases:

SUMIF Status: Standard -
  • Open testdocument i85000_SUMIF.ods
  • Verify that the summarycell J4 shows 'ok'
  • Save the document to the current fileformat (e.g. *.ods)
  • Close and reload the document
  • Verify that the summarycell J4 still shows 'ok'
  • Save the document to *.xls
  • Close and reload the document
  • Verify that the summarycell J4 still shows 'ok'
  • Close the document

References:

-

Acronyms:

-

testcase specification history

Functions: SUMIF
Date Change User
28.02.2008 (09:02:35) status updated Oliver Craemer
28.02.2008 Testcase specification created Oliver Craemer