Testcase 1

1. File / New / Spreadsheet
2. Create a Data Range A1:C5 and fill with different values
3. Select Row 3
   
4. Format / Row / Hide
5. Check, if Row 3 are hided
   
6. Click into Cell A1
7. Insert / Chart...
8. Choose a Type
   
9. Leave the Dialog by using Finish
10. Check, if the chart are build without the values into Row 3
11. File / Save as... {Name of your choice}
    
12. File reload
13. Check, if the chart also correct build
14. Select chart by using Navigator
15. Select a Dataseries
    
16. Format / Object properties Tabpage Options
17. Mark Checkbox Include values from hidden cells
18. Leave the Dialog by using ok
19. Check, if the chart are build include the values into Row 3
20. File / Save
21. File reload
22. Check, if the chart also correct build
23. Select Column B
24. Format / Column / Hide
25. Check, if Column B are hided
26. Check, if the chart are build include the values into Column B
27. File / Save
28. File reload
29. Check, if the chart also correct build
30. Select chart by using Navigator
31. Change Charttype and Subtype
32. Check, if the chart also correct build
33. File / Save
34. File reload
35. Check, if the chart also correct build
36. Format / Row / Show
37. Check, if all Rows  are shown into the Sheet
38. Check, if the chart also correct build
39. Select chart by using Navigator
40. Uncheck Checkbox Include values from hidden cells
41. Leave the Dialog by using ok
42. Leave Chart
43. Check, if the chart are build include the values into Row 3
44. Check, if the chart are build exclude the values into Column B
45. File / Save
46. File reload
47. Check, if the chart also correct build
48. Format / Column / Show
49. Check, if all Columns are shown into the Sheet
50. Check, if the chart are build include the values into Column B
51. File / Save
52. File reload
53. Check, if the chart also correct build

[Edit testcase details]

Hide Cells by using filter

1. File / Load /a.odt (Testdocument)
2. Check, if Filter in Column A are set and only Zells they are include an A are visible
3. Check, if the chart are build only from Zellcontent A
4. Select chart by using Navigator
5. Select a Dataseries
6. Format / Object properties Tabpage Options
7. Mark Checkbox Include values from hidden cells
8. Leave the Dialog by using ok
9. Check, if the chart are build include all values into Column A
10. File / Save
11. File reload
12. Check, if the chart also correct build
13. Use Button Filter in Column A (Test1) and select as new Filtervalue  B
14. Check, if the chart are build include all values into Column A
15. File / Save
16. File reload
17. Check, if the chart also correct build
18. Uncheck Checkbox Include values from hidden cells
19. Check, if the chart are build only from Zellcontent B
20. File / Save
21. File reload
22. Check, if the chart also correct build
23. Use Button Filter in Column A (Test1) and select as new Filtervalue  All
24. Check, if the chart are build include all values into Column A
25. File / Save
26. File reload
27. Check, if the chart also correct build
28. Use Button Filter in Column A (Test1) and select Standard Filter...
29. Choose as Field Name Test 1
30. Choose as Condition = (equal)
31. Choose as value C
32. Leave the Dialog by using ok
33. Check, if the chart are build only from Zellcontent B
34. File / Save
35. File reload
36. Check, if the chart also correct build.

[Edit testcase details]