Calc Guide

Changing scenario cell values
Table 11 summarizes the interaction of various settings in preventing
or allowing changes in scenario cell values.
Table 11: Prevent changes behavior for scenario cell value changes
Settings Change allowed
Sheet protection ON
Scenario cell protection OFF
Prevent changes ON
Copy back ON
Scenario cell values cannot be
changed.
Sheet protection ON
Scenario cell protection OFF
Prevent changes OFF
Copy back ON
Scenario cell values can be changed,
and the scenario is updated.
Sheet protection ON
Scenario cell protection OFF
Prevent changes ON or OFF
Copy back OFF
Scenario cell values can be changed,
but the scenario is not updated due to
the Copy back setting.
Sheet protection ON
Scenario cell protection ON
Prevent changes ANY SETTING
Copy back ANY SETTING
Scenario cell values cannot be
changed.
Sheet protection OFF
Scenario cell protection ANY
SETTING
Prevent changes ANY SETTING
Copy back ANY SETTING
Scenario cell values can be changed
and the scenario is updated or not,
depending on the Copy back setting.
Working with scenarios using the Navigator
After scenarios are added to a spreadsheet, you can jump to a
particular scenario by selecting it from the list in the Navigator.
To find a scenario in the Navigator, click the Scenarios icon in the
Navigator. The defined scenarios are listed, along with the comments
that were entered when the scenarios were created.
To apply a scenario to the current sheet, double-click the scenario
name in the Navigator.
280 OpenOffice.org 3.x Calc Guide