# 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