diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/01/05120000.xhp')
| -rw-r--r-- | helpcontent2/source/text/scalc/01/05120000.xhp | 163 |
1 files changed, 163 insertions, 0 deletions
diff --git a/helpcontent2/source/text/scalc/01/05120000.xhp b/helpcontent2/source/text/scalc/01/05120000.xhp new file mode 100644 index 000000000..9b8db4727 --- /dev/null +++ b/helpcontent2/source/text/scalc/01/05120000.xhp @@ -0,0 +1,163 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + --> + + +<meta> + <topic id="textscalc0105120000xml" indexer="include"> + <title xml-lang="en-US" id="tit">Conditional Formatting</title> + <filename>/text/scalc/01/05120000.xhp</filename> + </topic> + </meta> + <body> +<bookmark xml-lang="en-US" branch="hid/.uno:ConditionalFormatDialog" id="bm_id5008046" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/.uno:ConditionalFormatMenu" id="bm_id5008047" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/ConditionalFormatDialog" id="bm_id3152518" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/@@nowidget@@" id="bm_id3152518" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id3155132" role="heading" level="1">Conditional Formatting</paragraph> + <paragraph xml-lang="en-US" id="par_id3163710" role="paragraph"><variable id="bedingtetext"><ahelp hid=".">Choose <emph>Conditional Formatting</emph> to define format styles depending on certain conditions.</ahelp> +</variable> If a style was already assigned to a cell, it remains unchanged. The style entered here is then evaluated. There are several types of conditional formatting that can be used.</paragraph> + <paragraph xml-lang="en-US" id="par_id3163711" role="paragraph">You can enter several conditions that query the contents of cell values or formulas. The conditions are evaluated from the first to the last. If the condition 1 matches the condition, the defined style will be used. Otherwise, condition 2 is evaluated, and its defined style is used. If this style does not match, then the next condition is evaluated and so on.</paragraph> + <section id="howtoget"> + <embed href="text/scalc/00/00000405.xhp#bedingte"/> + </section> + <paragraph xml-lang="en-US" id="par_id2414014" role="warning">To apply conditional formatting, AutoCalculate must be enabled. Choose <emph>Data - Calculate - AutoCalculate</emph> (you see a check mark next to the command when AutoCalculate is enabled).</paragraph> +<bookmark xml-lang="en-US" branch="index" id="bm_id3153189"><bookmark_value>conditional formatting; conditions</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/list" id="bm_id5008050" localize="false"/> + <paragraph xml-lang="en-US" id="par_id3149413" role="paragraph"><ahelp hid="." visibility="hidden">List of the conditions defined for the cell range in order of evaluation.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/up" id="bm_id5008053" localize="false"/> + <paragraph xml-lang="en-US" id="par_id3149414" role="paragraph"><ahelp hid="." visibility="hidden">Increase priority of the selected condition.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/down" id="bm_id5008054" localize="false"/> + <paragraph xml-lang="en-US" id="par_id3149415" role="paragraph"><ahelp hid="." visibility="hidden">Decrease priority of the selected condition.</ahelp></paragraph> +<paragraph xml-lang="en-US" id="hd_id31531891" role="heading" level="2">Condition</paragraph> + <paragraph xml-lang="en-US" id="par_id31494131" role="paragraph">You can define as many conditions as you want.</paragraph> + <paragraph xml-lang="en-US" id="par_id31494132" role="paragraph">Specify if conditional formatting is dependent on one of the entry listed on the drop down box:</paragraph> + <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/add" id="bm_id5008051" localize="false"/> + <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/delete" id="bm_id5008052" localize="false"/> + <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/edassign" id="bm_id5008055" localize="false"/> + <list type="unordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id31494133" role="listitem">If you select <emph>All cells</emph>, see Color Scale, Data Bar or Icon Set explanations below, depending on which visual representation the conditional formatting should be represented.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id31494134" role="listitem">If you select <emph>Cell value is</emph>:</paragraph> + <switch select="sys"><comment>FIXME: Hack to get a nested list</comment><default> + <list type="unordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id31494135" role="listitem">Select a condition in the drop down list for the format to be applied to the selected cells and enter the value.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id31494136" role="listitem">In front of <emph>Apply Styles</emph>, select the desired style in the list or chose <emph>New Style</emph> to create one.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id31494137" role="listitem"><ahelp hid=".">Click the <emph>Add</emph> button to add another condition, click the <emph>Remove</emph> button to remove a condition.</ahelp></paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id31494138" role="listitem"><ahelp hid=".">In the <emph>Range</emph> field, define the range of cells concerned by the conditional formatting.</ahelp> Click on the <emph>Shrink</emph> button to minimize the dialog box. Click again on the button to come back to the dialog box once the range is selected.</paragraph> + </listitem> + </list> + </default></switch> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id31494139" role="listitem">If you select <emph>Formula is</emph> as a reference, enter a cell reference. If the cell reference is a value other than zero, the condition matches.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3149413a" role="listitem">If you select <emph>Date is</emph>, see below explanations for Date.</paragraph> + </listitem> + </list> + +<paragraph xml-lang="en-US" id="hd_id3147394" role="heading" level="2">Color Scale</paragraph> + <paragraph xml-lang="en-US" id="par_id3155602" role="paragraph">This is the same dialog box as if you select <emph>All cells</emph> in the first sub menu entry <emph>Condition</emph>. +Apply a color scale to a range consist of displaying a bicolor or tricolor gradient on this range depending on the value of each cell. A typical example might be an array of temperatures, lower blue colored, warmer red with a gradient nuances to the intermediate values.</paragraph> + <paragraph xml-lang="en-US" id="par_id3155603" role="paragraph">You must choose the two "extreme" colors indicate the method of calculation. The calculation of the color applied will be made in relation to: Min - Max - Percentile - Value - Percent - Formula.</paragraph> + <paragraph xml-lang="en-US" id="par_id3155604" role="paragraph">The choices Min and Max are sufficient to themselves as found in the range. Other options need to be specified by a value (Percentile, Value, Percentage) or a cell reference or formula (Formula).</paragraph> + <paragraph xml-lang="en-US" id="par_id3155605" role="paragraph">For a detailed explanation and examples, please visit <link href="https://wiki.documentfoundation.org/Faq/Calc/142">How to apply a Color Scale Conditional Formatting page</link> in TDF Wiki.</paragraph> + +<paragraph xml-lang="en-US" id="hd_id3153709" role="heading" level="2">Icon Set</paragraph> + <paragraph xml-lang="en-US" id="par_id3153764" role="paragraph">It is desired to plot the position of a value relative to the thresholds. The set of icons will help to indicate the thresholds and choose the type of icons. Available icon sets are:</paragraph> +<list type="unordered"> +<listitem> + <paragraph xml-lang="en-US" id="par_id31494140" role="listitem">3, 4 or 5 - arrows</paragraph> +</listitem> +<listitem> + <paragraph xml-lang="en-US" id="par_id31494141" role="listitem">3, 4 or 5 - gray arrows</paragraph> +</listitem> +<listitem> + <paragraph xml-lang="en-US" id="par_id31494142" role="listitem">3 - flags</paragraph> +</listitem> +<listitem> + <paragraph xml-lang="en-US" id="par_id31494143" role="listitem">3 - traffic lights 1 and 2 (two different designs)</paragraph> +</listitem> +<listitem> + <paragraph xml-lang="en-US" id="par_id31494144" role="listitem">3 - symbols (square, triangle, circle)</paragraph> +</listitem> +<listitem> + <paragraph xml-lang="en-US" id="par_id31494145" role="listitem">4 - circles from red to black</paragraph> +</listitem> +<listitem> + <paragraph xml-lang="en-US" id="par_id31494146" role="listitem">4 or 5 - ratings</paragraph> +</listitem> +<listitem> + <paragraph xml-lang="en-US" id="par_id31494147" role="ilistitem">5 - quarters</paragraph> +</listitem> +</list> + <paragraph xml-lang="en-US" id="par_id3153765" role="paragraph">Conditions to display each icon can be specified relative to a value (Value), a percentage of the number of values in the range (Percentage) as a percentage of range values (Percentile) or formula (Formula).</paragraph> + <paragraph xml-lang="en-US" id="par_id3155606" role="paragraph">For a detailed explanation and examples, please visit <link href="https://wiki.documentfoundation.org/Faq/Calc/141">How to use Icon Set Conditional Formatting page</link> in TDF Wiki.</paragraph> + +<paragraph xml-lang="en-US" id="hd_id3156384" role="heading" level="2">Dates</paragraph> + <paragraph xml-lang="en-US" id="par_id3145228" role="paragraph">This option will apply a defined style depending on a date that you choose in the drop down box: Today - Yesterday - Tomorrow - Last 7 days - This week - Last week.</paragraph> +<list type="unordered"> +<listitem> + <paragraph xml-lang="en-US" id="par_id31494157" role="listitem">In front of <emph>Apply Styles</emph>, select the desired style in the list or chose <emph>New Style</emph> to create one.</paragraph> +</listitem> +<listitem> + <paragraph xml-lang="en-US" id="par_id31494167" role="listitem">Click the <emph>Add</emph> button to add another condition, click the <emph>Remove</emph> button to remove a condition.</paragraph> +</listitem> +<listitem> + <paragraph xml-lang="en-US" id="par_id31494177" role="listitem">In the <emph>Range</emph> field, define the range of cells concerned by the conditional formatting. Click on the <emph>Shrink</emph> button to minimize the dialog box. Click again on the button to come back to the dialog box once the range is selected.</paragraph> +</listitem> +</list> + +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/condformatmanager/CondFormatManager" id="bm_id3152598" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/condformatmanager/@@nowidget@@" id="bm_id3152598" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id3153384" role="heading" level="2">Manage Conditional Formatting</paragraph> +<paragraph xml-lang="en-US" id="par_id3155906" role="paragraph"><ahelp hid=".">This dialog allows you to see all the conditional formatting defined in the spreadsheet.</ahelp></paragraph> + + <section id="howtoget"> + <paragraph role="paragraph" id="par_id31546818" xml-lang="en-US">Choose <emph>Format - Conditional Formatting - Manage</emph>.</paragraph> + </section> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/condformatmanager/add" id="bm_id3152600" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/condformatmanager/edit" id="bm_id3152601" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/condformatmanager/remove" id="bm_id3152602" localize="false"/> +<paragraph xml-lang="en-US" id="par_id3155907" role="paragraph">The <emph>Manage Conditional Formatting</emph> dialog box opens. <ahelp hid=".">Here you can add, edit or remove one or several conditional formattings.</ahelp></paragraph> + +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/condformatmanager/CONTAINER" id="bm_id3152603" localize="false"/> +<paragraph xml-lang="en-US" id="par_id3155909" role="paragraph"><ahelp hid=".">The <emph>Conditional Formats</emph> list displays the active conditional formatting rules set in the current spreadsheet.</ahelp> Only the first rule for each cell range is listed, even if there are multiple rules defined for a given range.</paragraph> + +<paragraph xml-lang="en-US" id="par_id3155908" role="paragraph">If you have defined a conditional formatting on a cell range and you try now to define a new conditional formatting on a part of this range, a warning message will be displayed, asking if you want to edit the existing conditional formatting (on the whole range) or define a new conditional formatting overlapping it (on the selected range).</paragraph> + + <section id="relatedtopics"> + <paragraph xml-lang="en-US" id="par_idN107E1" role="paragraph" localize="false"> + <embedvar href="text/scalc/guide/cellstyle_conditional.xhp#cellstyle_conditional"/> + </paragraph> + </section> + </body> +</helpdocument> |