Test case specification document

Test Name: Chart Context Menu

Document Owner:
Sophie Gautier

Last Document Change:
04.SEP.2009

Status of Document:
Preliminary

Test purpose

Test of the context menu entries interaction with chart.

Known issues:

Preconditions of the test:

Get OpenOffice.org 3.2

Test documents

Test cases

Test case 1 : Chart Area, Chart, Wall

File > New > Spreadsheet
Fill the range A2:B8 with random values
With the cursor in the range, select Insert > Chart
Choose a Line > Points and Lines chart type and click Next 3 times
In the Chart Element tab, unmark Display Legend
Click Finish
Move the cursor on the Chart Area
Right click on the chart area to get the contextual menu
Choose Format Chart area
Set Borders line properties to Continuous, click OK
Move the cursor on the Wall area
Right click on the Wall area to get the contextual menu
Choose Format Wall area
Choose Area Tab > Fill > Color, pick a color and click OK
In the Chart tool bar, click on the Chart type icon
Choose Line > 3D Lines chart and click OK
Right click on the Floor area, choose Format Floor
Choose Area Tab > Fill > Color, pick a color and click OK
Right click on the chart, choose Position and Size
Mark Keep ratio and change the Width and the Position, then click OK
Right click on the chart and choose Insert Titles
Insert a Title, a Subtitle and Titles for X and Y axes, for X and Y secondary axes
Click OK
Right click on the chart, choose Insert Legend
Right click on the chart, choose Delete Legend
Right click on the chart, choose Insert/Delete Axes
Add secondary X and Y axes by marking them and click OK
Right click on the chart, choose Insert/Delete Axes
Unmark X and Y secondary axes
Right click on the chart, choose Data Ranges
Shorten the data ranges to A2:B6 using the Select Data Range button
Click OK
Right click on the chart, choose 3D View
Change Perspective value and click OK
Right click on the chart, select Copy
Click somewhere on the sheet out of the chart, right click and choose Paste
Right click on the chart and choose Paste

Test case 2 : Legend, Title, Trend Line Equation

File > New > Spreadsheet
Fill the range A2:B8 with random values
With the cursor in the range, select Insert > Chart
Choose a Line > Points and Lines chart type and click Next 3 times
Add titles and click Finish
Select the Title and right click, choose Format Title in the contextual menu
Select the Font tab and modify the size, click OK
Select the Legend and right click, choose Format Legend in the contextual menu
Select the Font tab and modify the size, click OK
Select the Data series for Column A, right click and choose Insert Trend line
Select the Linear Type and mark Show Equation
Click OK
Select the Trend Line Equation and right click, choose Format Trend Line Equation
Choose the Font tab and change the size of the font
Select the trend line equation and right click, choose Insert R²
Select the trend line equation and right click, choose Delete R²
Right click on the chart, choose Chart Type
Choose Line > 3D Lines and click OK
Right click on the chart, choose Data Ranges
Shorten the data ranges to A2:B6 using the Select Data Range button
Click OK
Right click on the chart, choose 3D View
Modify the Perspective value and click OK
Right click on the chart, select Cut
Click the Undo button
Right click on the chart, select Copy
Click somewhere on the sheet out of the chart, right click and choose Paste
Right click on the chart and choose Paste

Test case 3 : Data Series, Point

File > New > Spreadsheet

Fill the range A2:B8 with random values
With the cursor in the range, select Insert > Chart
Choose a Line > Pointes and Lines chart type and click Next 3 times
Add titles and click Finish
Select the first data point in the first data series and right click
Select Format Data Point in the contextual menu
Change the width and the height of the icon, click OK
Select the same data point, right click and choose Insert Single Data Label
Select the same data point and right click, select Format Single Data Label
Mark Show Value as Pourcentage, unmark Show values as number, click OK
Select the first single data point, right click, select Delete Single Data Label
Select the same data point, right click, select Reset Data Point
Select the first single data point, right click, select Format Data Series
Mark Secondary Y axis and click OK
Right clik on the first single data point and choose Chart type
Choose Stock type and Stock Chart 2 and click OK
Select the first data point, right click, select Data Range, select Data Series tab
Select Open Values, click on Select data range button in front of Range for Open Values, select data in column A
Select Close Values, click on Select data range button in front of Range for Close Values, select data in column B
Click OK
Select Stock Loss data point, right click, select Format Stock Loss
Change the width and the color in the Borders tab for Line properties, click OK
Select Stock Gain data point, right click, select Format Stock Gain
Change the width and the color in the Borders tab for Line properties, click OK
Right click on the Stock Loss data series, select Chart type
choose Line > Points and Lines, click OK
Select the first data series, right click, choose Insert Data Labels
Select the first data series, right click, choose Format Data Labels
Select the first data series, right click and select Insert Trend Lines
Select the same data series, right click and choose Format Trend Lines
Click on Show Equation in the Type tab, click OK
Select the same data series, right click, select Format Trend Line Equation
Change the font size, click OK
Select the second data series, right click, choose Insert Mean Value Line
Select the same data series, right click, choose Format Mean Value Line
Change the color in the Line properties, click OK
Select the second data series, right click, choose Insert Y error bars
In the dialog that open, click OK without modifying the defaults
Select the same data series, right click and choose Format Y error bars
Modify the error indicator on Positive, click OK
Select the same data series, right click, choose Delete Data Labels
Select the first data series, right click, choose Delete Trend Line Equation
Select the same data series, right click, choose Delete Trend Line
Select the second data series, right click, choose Delete Mean Value Line
Select the same data series, right click, chose Delete Y error bars
Select the second data point on the first data series, right click, choose Format Data Point
Change the height and the width of the icon, clik OK
Select the third data point in the same data series, right click, choose Format Data Point
Change the height and the width of the icon, clik OK
Select the same data series, right click, choose Reset all Data Points
Select the first data series, right click, select Arrangement
In the submenu, select Bring Forward
Select the first data series, right click, select Arrangement
In the submenu, select Send Backward
Select the same data series, right click, choose Chart Type
Select Line > 3D Lines, click OK
Select the second data series, right click, choose Dara ranges
In the dialog, under Data Range tab, shorten the data range to A2:B6 with the Select Data Range button
Click OK
Select the first data series, right click, choose 3D View
Modify the Perspective value and click OK
Select the second data series, right click, choose Cut
Click the Undo button
Select the second data series, right click, choose Copy
Click any where out of the chart in a cell, right click and choose Paste
Right click on the first data series in the chart, choose Paste
File > New > Text Document
Insert > Object > Chart
In the chart, click on the first data series to select it
Right click, select Chart Data Table in the contextual menu
Put the cursor in row 4
Click the Insert row icon, fill the row 5 with some values
Close the data table.

Test case 4 : Axes and Grid

File > New > Spreadsheet

Fill the range A2:B8 with random values
With the cursor in the range, select Insert > Chart
Choose Line > Points and Lines chart type and click Next 3 times
Add titles and click on Finish
Select the Y axis in the chart, right click, choose Format Axis
Check that this is the first entry of the contextual menu
Unmark Automatic in front of Major Interval and modify it to 3
Click OK
Select the Y Axis Major Grid in the chart, choose Format Major Grid
Check that this is the first entry of the contextual menu
Modify the color in the Line Properties, click OK
Select the X Axis in the chart, right click and choose Insert Minor Grid
Select the X Axis Minor Grid in the chart, right click and choose Format Minor Grid
Change the color of the line in the Line properties area, click OK
Select the X Axis, right click and choose Delete Axis
Select the X Axis Minor grid, right click, choose Insert Axis
Select the X Axis Minor grid, right click, choose Insert Major Grid
Select the X Axis Major Grid, right click, choose Delete Major Grid
Select the X Axis Minor Grid, right click, choose Delete Minor Grid
Select the X Axis, right click, choose Chart Type
Select Line > 3D Lines, click OK
Select the X axis, right click, choose Dara ranges
In the dialog, under the Data Range tab, modify the data range with the Select Data Range button
Click OK
Select the X axis, right click, choose 3D View
Mark Perspective and click OK
Select the X axis, right click, choose Cut
Select the X axis, right click, choose Copy
Click any where out of the chart in a cell, right click and choose Paste
Right click on the X axis in the chart, choose Paste
File > New > Text Document
Insert > Object > Chart
In the chart, click on the X axis to select it
Right click, select Chart Data Table in the contextual menu
Put the cursor in row 4
Click the Insert row icon, fill the row 5 with some values
Close the data table.

Test case 5 : Trend Line

File > New > Spreadsheet

Fill the range A2:B8 with random values
With the cursor in the range, select Insert > Chart
Choose Line > Points and Lines chart type and click Next 3 times
Add Titles and click on Finish
Select the data series Column B in the chart, right click, choose Insert Trend Line
Under the Type tab, mark Show Equation, click OK
Select the Trend Line, right click, select Format Trend Line
Under the Line tab, change the color of the Line properties and click OK
Select the Trend Line, right click, select Format Trend Line Equation
Under the Font tab of the dialog, modify the font size, click OK
Select the Trend Line, right click, select Delete Trend Line Equation
Select the Trend Line, right click, select Insert Trend Line Equation
Select the Trend Line, right click, select Delete Trend Line Equation
Select the Trend Line, right click, select Insert R² and Trend Line Equation
Select the Trend Line, right click, select Chart Type
Select Line > 3D Lines, click OK
Select the Trend Line, right click, select Data Range
Modifiy the data range using the Select Data Range button, click OK
Select the Trend Line, right click, choose Cut
Click the Undo button
Select the Trend Line, right click, choose Copy
Click any where out of the chart in a cell, right click and choose Paste
Right click on the Trend Line in the chart, choose Paste
File > New > Text Document
Insert > Object > Chart
In the chart, click on the Data series Column 3
Right click, select Insert Trend Line in the contextual menu
In the dialog, let Linear Regression Type and mark Show Equation, click OK
Select the Trend Line, right click, choose Data Table
Put the cursor in row 4
Click the Insert row icon, fill the row 5 with some values
Close the data table.

Test case 6 : Mean Value Line, Y Error Bars/ Data Labels

Files > New > Spreadsheet

Fill the range A2:B8 with random values
With the cursor in the range, select Insert > Chart
Choose a Line > Points and Lines chart type, and click Next 3 times
Add titles and click Finish
In the chart, select the data series Column B, right click, choose Insert Mean Value Line
Select the Mean Value Line, right click and select Format Mean Value Line
Change the color of the Line Properties, click OK
In the chart, select the data series Column A, right click, choose Insert Y Error Bars, click OK
Select the Error Bar, right click, choose Format Y error Bars
On the Y Error Bars tab, change the Error indicator to Positive and click OK
In the chart, select the data series Column A, right click and choose Insert Data Label
Select the same data series in the chart, right click and choose Format Data Labels
Under the Data Labels tab, mark Show value as percentage, click OK
Select the first single Data Label in the same data series, right click, choose Format Single Data Label
Modify the font size under the Font tab, click OK
In the chart, select the data series Column B, right click, select Format Data Series
Under the Option tab, modify Align data series on and mark Secondary Y axis, click OK
In the chart, select the data series Column B, right click, select Chart Type,
Choose Line > 3D Lines and click OK
In the chart, select the data series Column B, right click, select Data Ranges
In the Data Range tab, click on the Select Data Range button
Shorten the data range to A2:B4,
Click OK
In the chart, select the data series Column B, right click, select Cut
Click the Undo button
In the chart, select the data series Column B, right click, select Copy
Click any where out of the chart on a cell, right click an select Paste
Select the data series Column B on the chart, right click select Paste
File > New > Text Document
Insert > Object > Chart
In the chart, click on the Data series Column 1
Right click, select Insert Mean value line
Select the Mean Value Line, right click, choose Data Table
Put the cursor in row 4
Click the Insert row icon, fill the row 5 with some values
Close the data table.

Test case 7 : Stock Loss & Stock Gain;

File > New > Spreadsheet

Fill the range A2:B8 with random values
With the cursor in the range, select Insert > Chart
Select Stock, Stock Chart 2, click on Next 2 times
Select Open Values, click the Select Data Range button, select Column A
Select Close Values, click the Select Data Range button, select Column B
Click Finish
Click on the Stock Loss in the chart to select it, right click, choose Format Stock Loss
On the Area tab, change the color of the area and click OK
Click on the Stock Gain to select it, right click, choose Format Stock Gain
In the Area Tab, change the color of the area, click OK
Select the Stock Loss, right click, choose Chart Type
Choose Line > 3D Lines, click OK
Click Undo one time
Select Stock Loss, right click, select Data Ranges
Under the Data Range tab, click on the Select Data Range button and modify the data range
Click OK
Select the Stock Loss, right click, choose Copy
Click any where out of the chart in a cell, right click and choose Paste
Right click on the Stock Loss in the chart, choose Paste
File > New > Text Document
Insert > Object > Chart
In the Chart toolbar, click the Chart type icon
Select Stock > Stock Chart 2, click ok
In the chart, click on the Data series Column 3
Right click, choose Chart Data Table
Put the cursor in row 4
Click the Insert row icon, fill the row 5 with some values
Close the data table.

Problematic areas

When copying the chart area (and only the chart area) in edit mode, pasting leave an empty frame see 104652

Acronyms:

References (specification, API-documentation, ...):

Chart Context Menu