From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- helpcontent2/source/text/scalc/guide/scenario.xhp | 85 +++++++++++++++++++++++ 1 file changed, 85 insertions(+) create mode 100644 helpcontent2/source/text/scalc/guide/scenario.xhp (limited to 'helpcontent2/source/text/scalc/guide/scenario.xhp') diff --git a/helpcontent2/source/text/scalc/guide/scenario.xhp b/helpcontent2/source/text/scalc/guide/scenario.xhp new file mode 100644 index 000000000..a6cdd2979 --- /dev/null +++ b/helpcontent2/source/text/scalc/guide/scenario.xhp @@ -0,0 +1,85 @@ + + + + + + + + + + +Using Scenarios +/text/scalc/guide/scenario.xhp + + + +scenarios; creating/editing/deleting +opening;scenarios +selecting;scenarios in Navigator +UFI: removed "sample" from index term: no sample in OOoMW changed "scenarios;"Using Scenarios + +A $[officename] Calc scenario is a set of cell values that can be used within your calculations. You assign a name to every scenario on your sheet. Define several scenarios on the same sheet, each with some different values in the cells. Then you can easily switch the sets of cell values by their name and immediately observe the results. Scenarios are a tool to test out "what-if" questions. +Creating Your Own Scenarios +To create a scenario, select all the cells that provide the data for the scenario. + + +Select the cells that contain the values that will change between scenarios. To select multiple cells, hold down the CommandCtrl key as you click each cell. + + +Choose Tools - Scenarios. The Create Scenario dialog appears. + + +Enter a name for the new scenario and leave the other fields unchanged with their default values. Close the dialog with OK. Your new scenario is automatically activated. + + +Using Scenariosremoved "commercial" switched contentsScenarios can be selected in the Navigator: + + +Open the Navigator with the Navigator icon +Navigator icon + on the Standard bar. + + +Click the Scenarios icon +Scenarios icon + in the Navigator. + + +In the Navigator, you see the defined scenarios with the comments that were entered when the scenarios were created. + + +Double-click a scenario name in the Navigator to apply that scenario to the current sheet. + + +To delete a scenario, right-click the name in the Navigator and choose Delete. + + +To edit a scenario, right-click the name in the Navigator and choose Properties. + + +To hide the border of a set of cells that are part of a scenario, open the Properties dialog for each scenario that affects the cells and clear the Display border checkbox. Hiding the border also removes the listbox on the sheet where you can choose the scenarios. + + +If you want to know which values in the scenario affect other values, choose Tools - Detective - Trace Dependents. You see arrows to the cells that are directly dependent on the current cell. +
+Creating Scenarios + +
+ + -- cgit v1.2.3