OpenOffice.org OpenOffice - 3.3 Guía básica descargar pdf (Pagina 246)

4) Optionally add some information to the Comment box. The example shows the

default comment. This information is displayed in the Navigator when you click

the Scenarios icon and select the desired scenario.

5) Optionally select or deselect the options in the Settings section. See page 246

for more information about these options.

6) Click OK to close the dialog. The new scenario is automatically activated.

You can create several scenarios for any given range of cells.

Settings

The lower portion of the Create Scenario dialog contains several options. The default

settings (as shown in Figure 243) are likely to be suitable in most situations.

Display border

Places a border around the range of cells that your scenario alters. To choose the

color of the border, 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 that have been

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 11 on page 247).

Caution

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 is easily avoided if you 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 to your document a sheet that permanently displays the new scenario in full.

This is in addition to creating the scenario and making it selectable on the original

sheet as normal.

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.

Changing scenarios

Scenarios have two aspects that can be altered independently:

• Scenario properties (the settings described above)

• Scenario cell values (the entries within the scenario border)

246 OpenOffice.org 3.3 Calc Guide

1 2 ... 241 242 243 244 245 246 247 248 249 250 251 ... 433 434

Comentarios a estos manuales

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía básica Pagina 246

Comentarios a estos manuales

Relacionado con productos y manuales para Software OpenOffice.org OpenOffice - 3.3