1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir 3cdf0e10cSrcweir 4*02dbb15cSAndrew Rist<!--*********************************************************** 5cdf0e10cSrcweir * 6*02dbb15cSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 7*02dbb15cSAndrew Rist * or more contributor license agreements. See the NOTICE file 8*02dbb15cSAndrew Rist * distributed with this work for additional information 9*02dbb15cSAndrew Rist * regarding copyright ownership. The ASF licenses this file 10*02dbb15cSAndrew Rist * to you under the Apache License, Version 2.0 (the 11*02dbb15cSAndrew Rist * "License"); you may not use this file except in compliance 12*02dbb15cSAndrew Rist * with the License. You may obtain a copy of the License at 13*02dbb15cSAndrew Rist * 14*02dbb15cSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 15*02dbb15cSAndrew Rist * 16*02dbb15cSAndrew Rist * Unless required by applicable law or agreed to in writing, 17*02dbb15cSAndrew Rist * software distributed under the License is distributed on an 18*02dbb15cSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 19*02dbb15cSAndrew Rist * KIND, either express or implied. See the License for the 20*02dbb15cSAndrew Rist * specific language governing permissions and limitations 21*02dbb15cSAndrew Rist * under the License. 22*02dbb15cSAndrew Rist * 23*02dbb15cSAndrew Rist ***********************************************************--> 24*02dbb15cSAndrew Rist 25*02dbb15cSAndrew Rist 26cdf0e10cSrcweir 27cdf0e10cSrcweir<helpdocument version="1.0"> 28cdf0e10cSrcweir<meta> 29cdf0e10cSrcweir<topic id="textscalc0106050000xml" indexer="include" status="PUBLISH"> 30cdf0e10cSrcweir<title id="tit" xml-lang="en-US">Create Scenario</title> 31cdf0e10cSrcweir<filename>/text/scalc/01/06050000.xhp</filename> 32cdf0e10cSrcweir</topic> 33cdf0e10cSrcweir<history> 34cdf0e10cSrcweir<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> 35cdf0e10cSrcweir<lastedited date="2005-01-04T12:06:54">UFI: sc.features "Adding Scenario Protection to Calc" 36cdf0e10cSrcweirdedr: reviewed</lastedited> 37cdf0e10cSrcweir</history> 38cdf0e10cSrcweir</meta> 39cdf0e10cSrcweir<body> 40cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:ScenarioManager" id="bm_id3154490" localize="false"/><!-- HID added by script --> 41cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:ScenarioManager" id="bm_id3145068" localize="false"/> 42cdf0e10cSrcweir<paragraph role="heading" id="hd_id3156023" xml-lang="en-US" level="1" l10n="U" oldref="1">Create Scenario</paragraph> 43cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3150541" xml-lang="en-US" l10n="U" oldref="2"><variable id="szenariotext"><ahelp hid=".uno:ScenarioManager">Defines a scenario for the selected sheet area.</ahelp> 44cdf0e10cSrcweir</variable></paragraph> 45cdf0e10cSrcweir<section id="howtoget"> 46cdf0e10cSrcweir <embed href="text/scalc/00/00000406.xhp#exsze"/> 47cdf0e10cSrcweir</section> 48cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN10637" xml-lang="en-US" l10n="NEW"> 49cdf0e10cSrcweir<embedvar href="text/scalc/guide/scenario.xhp#scenario"/> 50cdf0e10cSrcweir</paragraph> 51cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_NEWSCENARIO:ED_NAME" id="bm_id3154123" localize="false"/> 52cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_SC_SCENWIN_TOP" id="bm_id3153195" localize="false"/> 53cdf0e10cSrcweir<paragraph role="heading" id="hd_id3156280" xml-lang="en-US" level="2" l10n="U" oldref="3">Name of scenario</paragraph> 54cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3151041" xml-lang="en-US" l10n="U" oldref="13"><ahelp hid="HID_SC_SCENWIN_TOP">Defines the name for the scenario. Use a clear and unique name so you can easily identify the scenario.</ahelp> You can also modify a scenario name in the Navigator through the <emph>Properties </emph>context menu command.</paragraph> 55cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:MultiLineEdit:RID_SCDLG_NEWSCENARIO:ED_COMMENT" id="bm_id3152596" localize="false"/> 56cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_SC_SCENWIN_BOTTOM" id="bm_id3156444" localize="false"/> 57cdf0e10cSrcweir<paragraph role="heading" id="hd_id3153954" xml-lang="en-US" level="2" l10n="U" oldref="14">Comment</paragraph> 58cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3155411" xml-lang="en-US" l10n="U" oldref="15"><ahelp hid="HID_SC_SCENWIN_BOTTOM">Specifies additional information about the scenario. This information will be displayed in the <link href="text/scalc/01/02110000.xhp" name="Navigator">Navigator</link> when you click the <emph>Scenarios</emph> icon and select the desired scenario.</ahelp> You can also modify this information in the Navigator through the <emph>Properties </emph>context menu command.</paragraph> 59cdf0e10cSrcweir<paragraph role="heading" id="hd_id3145273" xml-lang="en-US" level="2" l10n="U" oldref="16">Settings</paragraph> 60cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3153364" xml-lang="en-US" l10n="U" oldref="17">This section is used to define some of the settings used in the scenario display.</paragraph> 61cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_NEWSCENARIO:CB_SHOWFRAME" id="bm_id3151119" localize="false"/> 62cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_NEWSCENARIO:LB_COLOR" id="bm_id3151118" localize="false"/> 63cdf0e10cSrcweir<paragraph role="heading" id="hd_id3145367" xml-lang="en-US" level="3" l10n="CHG" oldref="18">Display border<comment>UFI: #i38688#</comment></paragraph> 64cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3151073" xml-lang="en-US" l10n="U" oldref="19"><ahelp hid="SC:LISTBOX:RID_SCDLG_NEWSCENARIO:LB_COLOR">Highlights the scenario in your table with a border. The color for the border is specified in the field to the right of this option.</ahelp> The border will have a title bar displaying the name of the last scenario. The button on the right of the scenario border offers you an overview of all the scenarios in this area, if several have been defined. You can choose any of the scenarios from this list without restrictions.</paragraph> 65cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_NEWSCENARIO:CB_TWOWAY" id="bm_id3147124" localize="false"/> 66cdf0e10cSrcweir<paragraph role="heading" id="hd_id3149582" xml-lang="en-US" level="3" l10n="U" oldref="20">Copy back</paragraph> 67cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3154942" xml-lang="en-US" l10n="CHG" oldref="21"><ahelp hid="SC:CHECKBOX:RID_SCDLG_NEWSCENARIO:CB_TWOWAY">Copies the values of cells that you change into the active scenario. If you do not select this option, the scenario is not changed when you change cell values. The behavior of the <emph>Copy back</emph> setting depends on the cell protection, the sheet protection, and the <emph>Prevent changes</emph> settings.</ahelp></paragraph> 68cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_NEWSCENARIO:CB_COPYALL" id="bm_id3153418" localize="false"/> 69cdf0e10cSrcweir<paragraph role="heading" id="hd_id3149402" xml-lang="en-US" level="3" l10n="U" oldref="22">Copy entire sheet</paragraph> 70cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3146969" xml-lang="en-US" l10n="U" oldref="23"><ahelp hid="SC:CHECKBOX:RID_SCDLG_NEWSCENARIO:CB_COPYALL">Copies the entire sheet into an additional scenario sheet. </ahelp></paragraph> 71cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_NEWSCENARIO:CB_PROTECT" id="bm_id3014007" localize="false"/> 72cdf0e10cSrcweir<paragraph role="heading" id="par_idN1075A" xml-lang="en-US" level="3" l10n="NEW">Prevent changes</paragraph> 73cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN1075E" xml-lang="en-US" l10n="NEW"><ahelp hid="sc:CheckBox:RID_SCDLG_NEWSCENARIO:CB_PROTECT">Prevents changes to the active scenario. The behavior of the <emph>Copy back</emph> setting depends on the cell protection, the sheet protection, and the <emph>Prevent changes</emph> settings.</ahelp></paragraph> 74cdf0e10cSrcweir<list type="unordered"> 75cdf0e10cSrcweir<listitem> 76cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN10778" xml-lang="en-US" l10n="NEW">You can only change the scenario properties if the <emph>Prevent changes</emph> option is not selected and if the sheet is not protected.</paragraph> 77cdf0e10cSrcweir</listitem> 78cdf0e10cSrcweir<listitem> 79cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN10780" xml-lang="en-US" l10n="NEW">You can only edit cell values if the <emph>Prevent changes</emph> option is selected, if the <emph>Copy back</emph> is option is not selected, and if the cells are not protected.</paragraph> 80cdf0e10cSrcweir</listitem> 81cdf0e10cSrcweir<listitem> 82cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN1078C" xml-lang="en-US" l10n="NEW">You can only change scenario cell values and write them back into the scenario if the <emph>Prevent changes</emph> option is not selected, if the <emph>Copy back</emph> option is selected, and if the cells are not protected.</paragraph> 83cdf0e10cSrcweir</listitem> 84cdf0e10cSrcweir</list> 85cdf0e10cSrcweir</body> 86cdf0e10cSrcweir</helpdocument> 87