Test name: Chart wizard general functionality

Document Owner:

Jogi Sievers

Last document change:

09.05.2007

Status of document:

Standard

Valid for version: StarOffice8 PP8

Test Purpose

The general functionailty of the new wizard in the chart2 modul needs to be checked.

Preconditions of the test:

Installed Openoffice.org with included SRC680/chart2mst3 CWS

Test documents

randomData.ods (download the latest)

TESTCASE : tCreateNew3DChart

Test creation of new 3D Cone chart using the Chart Wizard
Load test document randomData.ods
Save document as OfficePath/user/work/tCreateNew3DChart.ods
Insert / Chart
Chart Wizard will be opened
Choose the Chart type bar (should be the second in the top-down list)
Select 2nd chart variant from left
Check 3D Look checkbox
Change Chart type look to realistic
Change Chart shape to cone
Change to Data Range tab page by clicking the Next-button
Set data range text box to
```
$Sheet1.$A$2:$E$13
```
Select data series in Rows radiobox
Uncheck First row as label checkbox
Change to Data Series tab page by clicking the Next-button
Select last (12th) entry in Data Series list on the left
Click on the add-button
Set Range for Name' text field to
A17
Select 2nd entry in Data Ranges (Y-Values) list on the right
Set Range for Y-Values text field to
B17:E17
Change to Chart Elements tab-page by clicking the Next-button
Set 'Title' text box to MyTitle
Set 'Subtitle' text box to 1 2 3
Set 'X Title' text box to Grått
Set 'Y Title' text box to Gräulich
Set 'Z Title' text box to 灰色
Check X Axis-checkbox
Uncheck Y Axis-checkbox
Check Z Axis-checkbox
Select under Legend (on the right) the Left radio-button
Click the Finish-button
File / Save
Press ESCAPE button (deselecting the OLE object)
Close the document
Open saved file again
Select chart OLE using navigator
Invoke Edit / Object / Edit to enter inplace mode of the chart (enabling the chart menus and editing possibilities)
Format / Chart Type
Verify now the made settings in the Chart Type dialog:
Check if chart type is bar

Check that variant is stacked

Check that the chart variant is 'Stacked' (2nd entry)

Check the the 3D Look box is checked

Check that 3D look is realistic

Check that 3D shape cone is selected

Leave dialog with CANCEL button.
Invoke Format / Data Ranges
Goto tab-page Data Range
Verify now the made settings in the Data Ranges dialog:
Check substrings
$A$2:$E$13
and
$A$17:$E$17
in Data Range

Check that radio button rows is checked

Check that radio button columns is unchecked.

Check if First row as label checkbox is unchecked

Check that First column as label checkbox is checked.

Go to tab page Data Series

Check if added range (13 in list on the left) was preserved.

Select Name-entry in Data Ranges list on the right.

Check that the string
$A$17
exists in range for Name

Select Y-Values in Data Ranges list on the right.

Check that the string
$B$17:$E$17
is in range for Y-Values
.
Close the dialog with cancel-button
Insert / Title
Verify now the made settings in the Titles dialog:
Check that Title text field contains MyTitle

Check that Subtitle text field contains 1 2 3

Check that X Title text field contains Grått

Check that Y Title text field contains Gräulich

Check that Z Title text field contains 灰色
Close the Title dialog by pressing Cancel-button
Insert / Grid
Verify now the made settings in the Grid dialog:
Check that Main Grid X Axis checkbox is checked

Check that 'Main Grid Y Axis' checkbox is checked
Check that 'Main Grid Z Axis' checkbox is checked

Check that 'Minor Grid X Axis' checkbox is unchecked

Check that Minor Grid Y Axis checkbox is unchecked

Check that Minor Grid Z Axis checkbox is unchecked
Leave dialog with Cancel-button.
Insert / Legend
Verify now the made settings in the Legend dialog:
Check that Legend Display checkbox is checked

Check that
Left
radio button is selected
Cancel InsertLegendDialog
Close document

TESTCASE : tCreateNewLineChart

Test creation of new Line chart using the Chart Wizard
File / Load / randomData.ods
Save document as Officepath/user/work/tCreateNewLineChart.ods
Insert / Chart
Change Chart type to LINE (5th entry from the top)
Select 3rd Change chart type variant (lines only)
Enable 'Stack Series' and select 'Percent'
Enable 'Smooth Lines'
Invoke 'Smooth Lines' dialog
Check B-Spline
Set Resolution to 33
Set Data Points Order to 5
Close 'Smooth Lines' dialog
Change to Data Range tab-page
Set Data Range text box to "$Sheet1.$A$1:$F$13;$Sheet1.$A$17:$F$17"
Change to Data Series tab-page
Select 3rd entry in Data Series
Remove series labeled 'John'
Select 4th entry in Data Series
Select 2nd entry in Data Ranges
Set 'Range for Y-Values' text box to "$Sheet1.$F$2:$F$13;$Sheet1.$D$17"
Set 'Categories' text box to "$Sheet1.$A$2:$A$13;$Sheet1.$A$1"
Change to Chart Elements tab-page
Uncheck 'Y Axis'
Uncheck 'Legend Display'
Create Chart by clicking Finish-button
File / Save
Press -key
File / Close document
Open saved file again
Open the Navigator (F5)
Select the first OLE object in the Navigator
Edit / Object / Edit to enter Inplace Mode
Format / Chart Type
Check if chart type is LINE
Check if chart variant is LINES ONLY (third variant in non-CTL versions from the left)
Check if 'Stack Series' box is checked
Check if 'Percent' radio button is checked
Check if 'Smooth Lines' box is checked
Invoke 'Smooth Lines' dialog
Check if 'B-Spline' radio button is checked
Check if 'Resolution' has value '33'
Check if 'Data Points Order' has value '5'
Close 'Smooth Lines' dialog
Leave Chart Type dialog with Cancel
Format / Data Ranges
Check substrings '$A$2:$C$13', '$A$19', '$B$1:$C$13', '$E$1:$F$13' and '$B$17:$E$17' in Data Range
Check if Radio Button ROWS is checked
Check if Radio Button COLUMNS is unchecked
Check if 'First row as label' box is unchecked
Check if 'First column as label' box is checked
Switch to tab page Data Series
Select 4th entry in Data Series
Select Name in Data Ranges
Check substring '$F$1' in Range for Name
Select Y-Values in Data Ranges
Check substring '$F$2:$F$13' and '$D$17'in Range for Name
Check substring '$A$2:$A$13' and '$A$19'in Categories
Insert Title
Check if 'Title' text box is empty
Check if 'Subtitle' text box is empty
Check if 'X Title' text box is empty
Check if 'Y Title' text box is empty
Check if 'Z Title' text box is empty
Leaving Title dialog with Cancel
Insert / Grids
Check if 'Gridlines X Axis' box is checked
Check if 'Gridlines Y Axis' box is unchecked
Check if 'Gridlines Z Axis' box is checked
Insert / Legend
Check if 'Legend Display' box is checked
Close document

Problematic areas

no problematic areas