diff options
| author | Andras Timar <atimar@suse.com> | 2013-08-27 13:05:14 +0200 |
|---|---|---|
| committer | Andras Timar <atimar@suse.com> | 2013-08-27 13:05:14 +0200 |
| commit | 39a7e6c2242bbe9050f4b7a408d95f06dcfd7a02 (patch) | |
| tree | c4e0ba45bef1fc60d76a1e28b588cc1d0ac3fbfe | |
| parent | 3bb6a44f94e5fa896748085a54f91f4ecffacc38 (diff) | |
fdo#55618 update help for CALC Conditional Formatting
Change-Id: I409e6bd6452eda75dd0319adcd07b3f9a4603255
| -rw-r--r-- | source/text/scalc/01/05120000.xhp | 143 | ||||
| -rw-r--r-- | source/text/scalc/guide/cellstyle_conditional.xhp | 4 |
2 files changed, 102 insertions, 45 deletions
diff --git a/source/text/scalc/01/05120000.xhp b/source/text/scalc/01/05120000.xhp index aafe0bc4b8..b0bb03c827 100644 --- a/source/text/scalc/01/05120000.xhp +++ b/source/text/scalc/01/05120000.xhp @@ -28,60 +28,117 @@ </meta> <body> <bookmark xml-lang="en-US" branch="hid/.uno:ConditionalFormatDialog" id="bm_id5008046" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/.uno:ConditionalFormatDialog" id="bm_id3147428" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/sc:ModalDialog:RID_SCDLG_CONDFORMAT" id="bm_id3152518" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3155132" role="heading" level="1" l10n="U" oldref="1">Conditional Formatting</paragraph> <paragraph xml-lang="en-US" id="par_id3163710" role="paragraph" l10n="U" oldref="2"><variable id="bedingtetext"><ahelp hid=".uno:ConditionalFormatDialog">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. You can enter three conditions that query the contents of cell values or formulas. The conditions are evaluated from 1 to 3. If the condition 1 matches the condition, the defined style will be used. Otherwise, condition 2 is evaluated, and its defined style used. If this style does not match, condition 3 is evaluated.</paragraph> +</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" l10n="NEW">To apply conditional formatting, AutoCalculate must be enabled. Choose Tools - Cell Contents - AutoCalculate (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/sc:CheckBox:RID_SCDLG_CONDFORMAT:CBX_COND1" id="bm_id3152598" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_CONDFORMAT:CBX_COND2" id="bm_id3154490" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_CONDFORMAT:CBX_COND3" id="bm_id3155415" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3153189" role="heading" level="2" l10n="U" - oldref="18">Condition 1/2/3</paragraph> - <paragraph xml-lang="en-US" id="par_id3149413" role="paragraph" l10n="U" oldref="4"><ahelp hid="SC:CHECKBOX:RID_SCDLG_CONDFORMAT:CBX_COND3">Mark the boxes corresponding to each condition and enter the corresponding condition.</ahelp> To close the dialog, click <emph>OK</emph>.</paragraph> -<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND1_1" id="bm_id3149581" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND2_1" id="bm_id3153158" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND3_1" id="bm_id3149379" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3147394" role="heading" level="2" l10n="U" oldref="5">Cell Value / Formula</paragraph> - <paragraph xml-lang="en-US" id="par_id3155602" role="paragraph" l10n="U" oldref="6"><ahelp hid="SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND3_1">Specifies if conditional formatting is dependent on a cell value or a formula.</ahelp> If you select a formula as a reference, the <emph>Cell Value Condition</emph> box is displayed to the right of the <emph>Cell value/Formula</emph> field. If the condition is "Formula is", enter a cell reference. If the cell reference is a value other than zero, the condition matches.</paragraph> -<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND1_2" id="bm_id3153712" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND2_2" id="bm_id3145641" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND3_2" id="bm_id3154755" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3153709" role="heading" level="2" l10n="U" oldref="7">Cell Value Condition</paragraph> - <paragraph xml-lang="en-US" id="par_id3153764" role="paragraph" l10n="U" oldref="8"><ahelp hid="SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND3_2">Choose a condition for the format to be applied to the selected cells.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND1_TEMPLATE" id="bm_id3147345" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND2_TEMPLATE" id="bm_id3146918" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND3_TEMPLATE" id="bm_id3149257" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3156384" role="heading" level="2" l10n="U" oldref="9">Cell Style</paragraph> - <paragraph xml-lang="en-US" id="par_id3145228" role="paragraph" l10n="U" oldref="10"><ahelp hid="SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND3_TEMPLATE">Choose the style to be applied if the specified condition matches.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/sc:PushButton:RID_SCDLG_CONDFORMAT:BTN_COND1_NEW" id="bm_id3149267" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/sc:PushButton:RID_SCDLG_CONDFORMAT:BTN_COND2_NEW" id="bm_id3149367" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/sc:PushButton:RID_SCDLG_CONDFORMAT:BTN_COND3_NEW" id="bm_id3249267" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id0509200913175331" role="heading" level="2" l10n="NEW">New Style</paragraph> - <paragraph xml-lang="en-US" id="par_id0509200913175368" role="paragraph" l10n="NEW"><ahelp hid=".">If you haven't already defined a style to be used, you can click New Style to open the Organizer tab page of the Cell Style dialog. Define a new style there and click OK.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_CONDFORMAT:EDT_COND2_2" id="bm_id3150298" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_CONDFORMAT:EDT_COND1_1" id="bm_id3147001" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_CONDFORMAT:EDT_COND1_2" id="bm_id3154020" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_CONDFORMAT:EDT_COND2_1" id="bm_id3159236" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_CONDFORMAT:EDT_COND3_1" id="bm_id3149207" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_CONDFORMAT:EDT_COND3_2" id="bm_id3158212" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3146316" role="heading" level="2" l10n="U" - oldref="11">Parameter field</paragraph> - <paragraph xml-lang="en-US" id="par_id3155114" role="paragraph" l10n="U" oldref="12"><ahelp hid="SC:EDIT:RID_SCDLG_CONDFORMAT:EDT_COND3_2" visibility="hidden">Enter a reference, value or formula.</ahelp> Enter a reference, value or formula in the parameter field, or in both parameter fields if you have selected a condition that requires two parameters. You can also enter formulas containing relative references.</paragraph> - <paragraph xml-lang="en-US" id="par_id3145257" role="paragraph" l10n="U" oldref="13">Once the parameters have been defined, the condition is complete. It may appear as:</paragraph> - <paragraph xml-lang="en-US" id="par_id3150784" role="paragraph" l10n="U" oldref="14">Cell value is equal 0: Cell style Null value (You must have already defined a cell style with this name before assigning it to a condition).</paragraph> - <paragraph xml-lang="en-US" id="par_id3150365" role="paragraph" l10n="CHG" oldref="15">Cell value is between $B$20 and $B$21: Cell style Result (The corresponding value limits must already exist in cells B20 and B21).</paragraph> - <paragraph xml-lang="en-US" id="par_id3152992" role="paragraph" l10n="CHG" oldref="16">Formula is SUM($A$1:$A$5)=10: Cell style Result (The selected cells are formatted with the Result style if the sum of the contents in cells A1 to A5 is equal to 10).</paragraph> - <embed href="text/shared/00/00000001.xhp#eingabesymbol"/> +<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> + <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> + <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">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_id31494138" 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> + </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="http://wiki.documentfoundation.org/Faq/Calc/142">How to apply a Color Scale Conditional Formatting page in TDF Wiki</link>.</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="http://wiki.documentfoundation.org/Faq/Calc/141">How to use Icon Set Conditional Formating page in TDF Wiki</link>.</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/sc:ModalDialog:RID_SCDLG_COND_FORMAT_MANAGER" 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">This dialog allows you to see all the conditional formatting defined in the spreadsheet.</paragraph> + + <section id="howtoget"> + <paragraph role="paragraph" id="par_id31546818" xml-lang="en-US">Choose <emph>Format - Conditional Formatting - Manage</emph></paragraph> + </section> +<paragraph xml-lang="en-US" id="par_id3155907" role="paragraph">The <emph>Manage Conditional Formatting</emph> dialog box opens. Here you can add, edit or remove one or several conditional formattings.</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" l10n="NEW"> <embedvar href="text/scalc/guide/cellstyle_conditional.xhp#cellstyle_conditional"/> </paragraph> </section> </body> -</helpdocument>
\ No newline at end of file +</helpdocument> diff --git a/source/text/scalc/guide/cellstyle_conditional.xhp b/source/text/scalc/guide/cellstyle_conditional.xhp index 535ce71aa6..69510ab75a 100644 --- a/source/text/scalc/guide/cellstyle_conditional.xhp +++ b/source/text/scalc/guide/cellstyle_conditional.xhp @@ -40,7 +40,7 @@ <paragraph xml-lang="en-US" id="hd_id3149263" role="heading" level="1" l10n="U" oldref="24"><variable id="cellstyle_conditional"><link href="text/scalc/guide/cellstyle_conditional.xhp" name="Applying Conditional Formatting">Applying Conditional Formatting</link> </variable></paragraph> - <paragraph xml-lang="en-US" id="par_id3159156" role="paragraph" l10n="U" oldref="25">Using the menu command <emph>Format - Conditional formatting</emph>, the dialog allows you to define up to three conditions per cell, which must be met in order for the selected cells to have a particular format.</paragraph> + <paragraph xml-lang="en-US" id="par_id3159156" role="paragraph">Using the menu command <emph>Format - Conditional formatting</emph>, the dialog allows you to define conditions per cell, which must be met in order for the selected cells to have a particular format.</paragraph> <paragraph xml-lang="en-US" id="par_id8039796" role="warning" l10n="NEW">To apply conditional formatting, AutoCalculate must be enabled. Choose <emph>Tools - Cell Contents - AutoCalculate</emph> (you see a check mark next to the command when AutoCalculate is enabled).</paragraph> <paragraph xml-lang="en-US" id="par_id3154944" role="paragraph" l10n="U" oldref="26">With conditional formatting, you can, for example, highlight the totals that exceed the average value of all totals. If the totals change, the formatting changes correspondingly, without having to apply other styles manually.</paragraph> <paragraph xml-lang="en-US" id="hd_id4480727" role="heading" level="2" l10n="NEW">To Define the Conditions</paragraph> @@ -142,4 +142,4 @@ <paragraph xml-lang="en-US" id="par_id3159123" role="paragraph" l10n="U" oldref="68"><link href="text/scalc/01/05120000.xhp" name="Format - Conditional formatting">Format - Conditional formatting</link></paragraph> </section> </body> -</helpdocument>
\ No newline at end of file +</helpdocument> |