Testname: Plotting of missing Values

Document Owner:

Thomas Klarhoefer

Last document change:

15.04.2008

Status of document:

Standard

Valid for version: OpenOffice.org_3.0

Test purpose:

Check the behaviour how OOo deals with cells they are empty or did not contain a valid value

Known issues:

Preconditions of test:

OOo 3.0

Test documents:

-

Testcases:

Testcase 1 Status: Standard -
  1. File / New / Spreadsheet
  2. Create cell range B2:C7 with values started by 0 and goto 5
  3. Delete  the value in cell  B5
  4. Insert Chart Type Line Points and Lines using Toolbar
  5. Check, if the first Data Serie "leave a gap" for the deleted value in cell B5
  6. Select the first Data Serie
  7. Kontextmenu / Object properties.../ Tabpage Options
  8. Choose Option Continue Line as Option for Plot missing values
  9. Leave the Dialog by using ok
  10. Check, if the Option Continue Line as Plot missing value for the  Data Serie are visible and show the correct option
  11. File / Save as... {name of your choice}
  12. File / reload
  13. Check, if the Option Continue Line as Plot missing value for the  Data Serie are visible and show the correct option
  14. Format / Chart Type
  15. Change Chart Type to Type Bar Subtyp Normal
  16. Check, if the first Data Serie "leave a gap" for the deleted value in cell B5
  17. Select the first Data Serie
  18. Kontextmenu / Object properties.../ Tabpage Options
  19. Check, if the Option Continue Line as Option for Plot missing values are greyed out
  20. Choose Option Assume zero as Option for Plot missing values
  21. Check, if the Option Assume zero as Plot missing value for the  Data Serie are visible and show the correct option
  22. File / Save
  23. File / reload
  24. Check, if the Option Assume zero as Plot missing value for the  Data Serie are visible and show the correct option.

References:

http://specs.openoffice.org/chart/MissingValues.odt

Acronyms:

-

testcase specification history

Plotting of missing Values
Date Change User
15.04.2008 (17:02:58) status updated Thomas Klarhoefer
15.04.2008 (17:01:29) testcase details updated Thomas Klarhoefer
15.04.2008 (13:31:52) testcase details updated Thomas Klarhoefer
15.04.2008 (10:54:05) testcase details updated Thomas Klarhoefer
15.04.2008 (10:42:52) testcase details updated Thomas Klarhoefer
14.03.2008 (13:29:19) testcase details updated Thomas Klarhoefer
14.03.2008 (12:17:19) testcase details updated Thomas Klarhoefer
14.03.2008 (12:06:32) testcase details updated Thomas Klarhoefer
14.03.2008 (11:47:07) testcase details updated Thomas Klarhoefer
14.03.2008 (10:54:53) testcase details added Thomas Klarhoefer
14.03.2008 Testcase specification created Thomas Klarhoefer