#

###

###

###

###

###

#####

#####

#####

#####

#####

#####

#####

###

###

###

    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:

    58163
    69422
    86146
    102820

    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