Settings

Apache OpenOffice 4.1 Calc Guide

Chapter 9: Data Analysis

< Previous Section

Next Section >

• Introduction
• Consolidating Data
• Creating Subtotals
• Using “What If” Scenarios
  • Creating Scenarios
  • Settings
  • Changing Scenarios
    • Changing Scenario Properties
    • Changing Scenario Cell Values
  • Working with Scenarios Using the Navigator
  • Tracking Values in Scenarios
• Using Other “What If” Tools
  • Multiple Operations in Columns or Rows
    • Calculating with One Formula and One Variable
    • Calculating with Several Formulas Simultaneously
  • Multiple Operations Across Rows and Columns
    • Calculating with Two Variables
• Working Backwards Using Goal Seek
  • Goal Seek Example
• Using the Solver
  • Solver Example

< Previous Page

Next Page >

Settings

The lower portion of the Create Scenario dialog contains several options. The default settings, such as Display border shown in Figure 247, are likely suitable in most situations.

Display border

Places a border around the range of cells that your scenario alters. To choose the border color, use the field to the right of this option. The border has a title bar displaying the name of the active scenario. Click the arrow button to the right of the scenario name to open a drop-down list of all the scenarios defined for the cells within the border. You can choose any of the scenarios from this list at any time.

Copy back

Copies any changes you make to the values of scenario cells back into the active scenario. If you do not select this option, the saved scenario values are never changed when you make changes. The actual behavior of the Copy back setting depends on the cell protection, the sheet protection, and the Prevent changes setting (see Table 12 in Changing Scenario Cell Values).

If you are viewing a scenario which has Copy back enabled and then create a new scenario by changing the values and selecting Tools → Scenarios, you also inadvertently overwrite the values in the first scenario. This can be avoided. Leave the current values alone, create a new scenario with Copy back enabled, and then change the values only when you are viewing the new scenario.

Copy entire sheet

Adds a sheet to your document that permanently displays the new scenario in full, in addition to creating the scenario and making it selectable on the original sheet.

Prevent changes

Prevents changes to a Copy back-enabled scenario when the sheet is protected but the cells are not. Also prevents changes to the settings described in this section while the sheet is protected. A fuller explanation of the effect this option has in different situations is given below.