AllLangHelp_scalc.mk | 5
source/text/scalc/01/05120000.xhp | 236 ++++++++++---------------------------
source/text/scalc/01/05120100.xhp | 241 ++++++++++++++++++++++++++++++++++++++
source/text/scalc/01/05120200.xhp | 27 ++++
source/text/scalc/01/05120300.xhp | 51 ++++++++
source/text/scalc/01/05120400.xhp | 81 ++++++++++++
source/text/scalc/01/05120500.xhp | 36 +++++
7 files changed, 509 insertions(+), 168 deletions(-)
New commits:
commit aefcd8e0945387c36ae5a80b6815763cae2a3022
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Sun Sep 11 20:56:47 2022 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Mon Sep 12 17:03:25 2022 +0200
tdf#119421 Refactor conditional formatting Help pages
* Still work to be done with other CF pages floating around
* Strucutred the entry page for the CF dialog
* Split conditions descriptions into sub-pages
Many thanks to Roman Kuznetsov for the inputs.
Change-Id: I5a9d91ab34febc127eb7dc762258428629ec5477
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/139783
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 3b3df75b3..e7ab38d66 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -115,6 +115,11 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/05100000 \
helpcontent2/source/text/scalc/01/05110000 \
helpcontent2/source/text/scalc/01/05120000 \
+ helpcontent2/source/text/scalc/01/05120100 \
+ helpcontent2/source/text/scalc/01/05120200 \
+ helpcontent2/source/text/scalc/01/05120300 \
+ helpcontent2/source/text/scalc/01/05120400 \
+ helpcontent2/source/text/scalc/01/05120500 \
helpcontent2/source/text/scalc/01/06020000 \
helpcontent2/source/text/scalc/01/06030000 \
helpcontent2/source/text/scalc/01/06030100 \
diff --git a/source/text/scalc/01/05120000.xhp
b/source/text/scalc/01/05120000.xhp
index 9abe1ee3e..28d08990c 100644
--- a/source/text/scalc/01/05120000.xhp
+++ b/source/text/scalc/01/05120000.xhp
@@ -1,183 +1,83 @@
<?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 .
- -->
+ <!--
+ * 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"/>
-<h1 id="hd_id3155132">Conditional Formatting</h1>
- <paragraph xml-lang="en-US" id="par_id3163710" role="paragraph"><variable
id="bedingtetext"><ahelp hid=".">Use <emph>Conditional Formatting</emph> to
define range-based conditions that determine which cell style will be applied
to each cell in a given range based on its contents.</ahelp></variable> The
cell style corresponding to the first condition that evaluates to
<emph>true</emph> is applied. Cell styles applied through Conditional
Formatting override cell styles applied manually using the <link
href="text/scalc/main0202.xhp" name="FormattingBar_link"><emph>Formatting
Bar</emph></link> or the <emph>Styles</emph> sidebar.</paragraph>
- <section id="howtoget">
- <embed href="text/scalc/00/00000405.xhp#bedingte"/>
- </section>
- <paragraph xml-lang="en-US" id="par_id3163711" role="paragraph">You can
enter several conditions that query the cell values or results of formulas. The
conditions are evaluated from first to the last. If <emph>Condition 1</emph> is
true based on the current cell contents, the corresponding cell style is
applied. Otherwise, <emph>Condition 2</emph> is evaluated to determine if its
corresponding style will be applied. If none of the conditions match cell
contents, then no changes are made to the cell format.</paragraph>
- <paragraph role="paragraph" id="par_id431642031216368">Conditional
formats do no overwrite cell styles and direct formatting applied manually.
They remain saved as cell properties and are applied when the cell matches no
conditions or when you remove all conditional formats.</paragraph>
+ <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"/>
+ <h1 id="hd_id3155132">Conditional Formatting</h1>
+ <paragraph xml-lang="en-US" id="par_id3163710"
role="paragraph"><variable id="bedingtetext"><ahelp hid=".">Use
<emph>Conditional Formatting</emph> to define range-based conditions that
determine which cell style will be applied to each cell in a given range based
on its contents.</ahelp></variable> The cell style corresponding to the first
condition that evaluates to <emph>true</emph> is applied. Cell styles applied
through Conditional Formatting override cell styles applied manually using the
<link href="text/scalc/main0202.xhp" name="FormattingBar_link"><emph>Formatting
Bar</emph></link> or the <emph>Styles</emph> sidebar.</paragraph>
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000405.xhp#bedingte"/>
+ </section>
+ <paragraph xml-lang="en-US" id="par_id3163711" role="paragraph">You can
enter several conditions that query the cell values or results of formulas. The
conditions are evaluated from first to the last. If <emph>Condition 1</emph> is
true based on the current cell contents, the corresponding cell style is
applied. Otherwise, <emph>Condition 2</emph> is evaluated to determine if its
corresponding style will be applied. If none of the conditions match cell
contents, then no changes are made to the cell format.</paragraph>
+ <paragraph role="paragraph" id="par_id431642031216368">Conditional
formats do no overwrite cell styles and direct formatting applied manually.
They remain saved as cell properties and are applied when the cell matches no
conditions or when you remove all conditional formats.</paragraph>
<warning id="par_id2414014">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).</warning>
-<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"/>
-<h2 id="hd_id71624649758112">Condition list</h2>
+
+ <h2 id="hd_id961662926287139">Cell range</h2>
+ <h3 id="hd_id431662926282555">Range</h3>
+ <paragraph xml-lang="en-US" id="par_id31494138" role="paragraph">Defines
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>
+
+ <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"/>
+
+ <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/conditionalformatdialog/edassign"
id="bm_id5008055" localize="false"/>
+ <h2 id="hd_id71624649758112">Condition list</h2>
<paragraph xml-lang="en-US" id="par_id3149413" role="paragraph">List of
the conditions defined for the cell range in order of evaluation. You can
define as many conditions as you want.</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/conditionalformatdialog/up" id="bm_id5008053"
localize="false"/>
-<h3 id="hd_id41624649786605">Up</h3>
-<paragraph xml-lang="en-US" id="par_id3149414" role="paragraph"><ahelp
hid=".">Increase priority of the selected condition.</ahelp></paragraph>
+ <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/conditionalformatdialog/up" id="bm_id5008053"
localize="false"/>
+ <h3 id="hd_id41624649786605">Up</h3>
+ <paragraph xml-lang="en-US" id="par_id3149414" role="paragraph"><ahelp
hid=".">Increase priority of the selected condition.</ahelp></paragraph>
<h3 id="hd_id861624649792266">Down</h3>
<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=".">Decrease priority of the selected condition.</ahelp></paragraph>
-
-<h2 id="hd_id31531891">Condition list entry</h2>
- <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"/>
+ <h3 id="hd_id71662926011736">Add</h3>
+ <paragraph role="paragraph" id="par_id721662926016039">Adds the
condition to the condition list.</paragraph>
<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>
-
-<h2 id="hd_id3147394">Color Scale</h2>
- <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>
-
-<h2 id="par_id991609782427459">Data Bar</h2>
- <paragraph role="paragraph" id="par_id41609780964157">Data bar option
will fill the cell with solid or gradient color corresponding to the numeric
value in the cell. Default is blue for positive and red for negative.
</paragraph>
- <paragraph role="paragraph" id="par_id931609781970981">The calculation
of the area of fill is based on Min - Max - Percentile - Value - Percent -
Formula.</paragraph>
- <paragraph role="paragraph" id="par_id981609782003841">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 role="paragraph" id="par_id281609781729359"><emph>More
Options...</emph> opens a dialog to: </paragraph>
- <list type="unordered">
- <listitem>
- <paragraph id="par_id271609781812913" role="listitem">change
colors</paragraph>
- </listitem>
- <listitem>
- <paragraph id="par_id921609781838551" role="listitem"> change
position of vertical axis within the cell</paragraph>
- </listitem>
- <listitem>
- <paragraph id="par_id631609781859971" role="listitem"> the bar's
minimum and maximum length in percentage</paragraph>
- </listitem>
- </list>
-
-<h2 id="hd_id3153709">Icon Set</h2>
- <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>
-
-<h2 id="hd_id3156384">Dates</h2>
- <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"/>
-<h2 id="hd_id3153384">Manage Conditional Formatting</h2>
-<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>
+ <h3 id="hd_id401662926020291">Delete</h3>
+ <paragraph role="paragraph" id="par_id301662926026944">Deletes the
condition from the condition list.</paragraph>
+ <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/conditionalentry/type" id="bm_id941662938267119"
localize="false"/>
+ <h2 id="hd_id31531891">Condition list entries</h2>
+ <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>
+ <embed href="text/scalc/01/05120100.xhp#cellvalueis"/>
+ <embed href="text/scalc/01/05120200.xhp#formulais"/>
+ <embed href="text/scalc/01/05120300.xhp#dateis"/>
+ <embed href="text/scalc/01/05120400.xhp#allcells"/>
+ <bookmark xml-lang="en-US"
branch="modules/scalc/ui/conditionalentry/style" id="bm_id241662938779751"
localize="false"/>
+ <h2 id="hd_id431662938949798">Apply Style</h2>
+ <paragraph role="paragraph" id="par_id971662939043786">Select the cell
style to apply when the condition is verified. Select <emph>New Style</emph> to
open the <link href="text/scalc/01/cell_styles.xhp" name="cellstyledialog">Cell
Style dialog</link> and define the style properties.</paragraph>
+ <embed href="text/scalc/01/05120500.xhp#manageconditions"/>
<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>
+ <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>
+</body>
</helpdocument>
diff --git a/source/text/scalc/01/05120100.xhp
b/source/text/scalc/01/05120100.xhp
new file mode 100644
index 000000000..3caba2fdc
--- /dev/null
+++ b/source/text/scalc/01/05120100.xhp
@@ -0,0 +1,241 @@
+<?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/.
+ *
+ -->
+
+ <meta>
+ <topic id="conditionalformattingcellis" indexer="include"
status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Conditional Formatting - Cell
value is</title>
+ <filename>/text/scalc/01/05120100.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+
+ <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/conditionalentry/typeis" id="bm_id941662938267119"
localize="false"/>
+ <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/conditionalentry/val1" id="bm_id811662938541882"
localize="false"/>
+ <section id="cellvalueis">
+ <h1 id="hd_id431662935550205"><variable id="h1"><link
href="text/scalc/01/05120100.xhp" name="Cell Value">Condition - Cell value
is</link></variable></h1>
+ <paragraph role="paragraph" id="par_id11662915615351">Applies a cell
style on the cell or cell range controlled by the condition set in the drop
down list. The formatting is applied to each cell individually and the
condition may depend on other cells values of the selected range.</paragraph>
+ </section>
+
+ <paragraph xml-lang="en-US" id="par_id31494135" role="paragraph">Select a
condition in the drop down list for the format to be applied to the selected
cells and enter the value. Valid conditions are:</paragraph>
+ <table id="tab_id211662913907277">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id181662913907279" role="tablehead"
xml-lang="en-US">Condition</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id941662913907280" role="tablehead"
xml-lang="en-US">Description</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id31662913907282" role="tablecontent"
xml-lang="en-US">is equal to</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id881662913907284" role="tablecontent"
xml-lang="en-US">Applies the selected style to the cell when the cell value
equals the user defined value in text box in the right. Use text inside quotes
if you compare text values.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id271662914239763" role="tablecontent"
xml-lang="en-US" >is less than</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id501662914239764" role="tablecontent"
xml-lang="en-US" >Applies the selected style to the cell when the cell value is
strictly less than the user defined value in the text box in the right. Valid
only for number values in cells.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id701662914433053" role="tablecontent"
xml-lang="en-US" >is greater than</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id461662914433054" role="tablecontent"
xml-lang="en-US" >Applies the selected style to the cell when the cell value is
strictly greater than the user defined value in the text box in the right.
Valid only for number values in cells.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id421662914480517" role="tablecontent"
xml-lang="en-US" >is less than or equal to</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id631662914480518" role="tablecontent"
xml-lang="en-US" >Applies the selected style to the cell when the cell value is
less than or equal to the user defined value in the text box in the right.
Valid only for number values in cells.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id651662914713102" role="tablecontent"
xml-lang="en-US" >is greater than or equal to</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id251662914713103" role="tablecontent"
xml-lang="en-US" >Applies the selected style to the cell when the cell value is
greater than or equal to the user defined value in the text box in the right.
Valid only for number values in cells.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id831662914760085" role="tablecontent"
xml-lang="en-US" >is not equal to</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id301662914760087" role="tablecontent"
xml-lang="en-US" >Applies the selected style to the cell when the cell value is
not equal (different) to the user defined value in the text box in the right.
Valid for number and text values in cells. Use text inside quotes if you
compare text values.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id81662914901503" role="tablecontent"
xml-lang="en-US" >is between</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id21662914901504" role="tablecontent"
xml-lang="en-US" >Applies the selected style to the cell when the cell value is
between the two values defined in the text boxes on the right - lower and upper
values - including the boundary values themselves. Valid only for number values
in cells.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id411662915178872" role="tablecontent"
xml-lang="en-US" >is not between</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id861662915178873" role="tablecontent"
xml-lang="en-US" >Applies the selected style to the cell when the cell value is
not between the two values defined in the text boxes on the right - lower and
upper values - including the boundary values themselves. Valid only for number
values in cells.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id731662915275926" role="tablecontent"
xml-lang="en-US" >is duplicate</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id881662915275927" role="tablecontent"
xml-lang="en-US" >Applies the selected style to the cell when at least one
other cell in the range has equal contents. Valid for number and text values in
cells.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id381662915857686" role="tablecontent"
xml-lang="en-US" >is not duplicate</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id341662915857687" role="tablecontent"
xml-lang="en-US" >Applies the selected style to the cell when the cell contents
is unique in the range. Valid for number and text values in cells.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1001662915996409" role="tablecontent"
xml-lang="en-US" >is in top N elements</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id571662915996410" role="tablecontent"
xml-lang="en-US" >Applies the selected style to the cell when the cell value is
between the maximum value in the range and the N<sup>th</sup> greater element
of the same. Enter the value of N in the text box on the right. Valid only for
number values in cells.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id341662916338175" role="tablecontent"
xml-lang="en-US" >is in bottom N elements</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id11662916338177" role="tablecontent"
xml-lang="en-US" >Applies the selected style to the cell when the cell value is
between the minimum value in the range and the N<sup>th</sup> lower element of
the same. Enter the value of N in the text box on the right. Valid only for
number values in cells.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id181662916407095" role="tablecontent"
xml-lang="en-US" >is in top N percent</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id911662916407097" role="tablecontent"
xml-lang="en-US" >Applies the selected style to the cell when the <emph>cell
range index value is in the top N percent</emph> of the number of cells in the
range. For example, in a 20 cells range and N equals 20, the style is applied
to the 4 last cells of the range. Enter the value of N in the text box on the
right.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id421662917285432" role="tablecontent"
xml-lang="en-US" >is in bottom N percent</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id111662917285433" role="tablecontent"
xml-lang="en-US" >Applies the selected style to the cell when the <emph>cell
range index value is in the bottom N percent</emph> of the number of cells in
the range. For example, in a 20 cells range and N equals 20, the style is
applied to the 4 first cells of the range. Enter the value of N in the text box
on the right.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id861662917382735" role="tablecontent"
xml-lang="en-US" >is above average</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id811662917382736" role="tablecontent"
xml-lang="en-US" >Applies the selected style to the cell when the cell value is
strictly greater than the average of the cell range values.</paragraph>
+ <embed
href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id421662919561954" role="tablecontent"
xml-lang="en-US" >is below average</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id661662919561956" role="tablecontent"
xml-lang="en-US" >Applies the selected style to the cell when the cell value is
strictly less than the average of the cell range values.</paragraph>
+ <embed
href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id831662919693474" role="tablecontent"
xml-lang="en-US" >is above or equal average</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id71662919693475" role="tablecontent"
xml-lang="en-US" >Applies the selected style to the cell when the cell value is
greater or equal than the average of the cell range values.</paragraph>
+ <embed
href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id521662919771410" role="tablecontent"
xml-lang="en-US" >is below or equal average</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id131662919771411" role="tablecontent"
xml-lang="en-US" >Applies the selected style to the cell when the cell value is
less or equal than the average of the cell range values.</paragraph>
+ <embed
href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id451662919849856" role="tablecontent"
xml-lang="en-US" >is error</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id911662919849857" role="tablecontent"
xml-lang="en-US" >Applies the selected style to the cell when the cell is in a
error condition defined in the right text box. <link
href="text/scalc/05/02140000.xhp" name="calc errors">List of Calc
errors</link>.</paragraph>
+ <tip id="par_id61662920733334">A cell that references another
cell with an error condition is not in error itself.</tip>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id961662920774180" role="tablecontent"
xml-lang="en-US" >is not error</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id381662920774181" role="tablecontent"
xml-lang="en-US" >Applies the selected style to the cell when the cell is not
in a error condition defined in the right text box. <link
href="text/scalc/05/02140000.xhp" name="calc errors">List of Calc
errors</link></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id151662920861587" role="tablecontent"
xml-lang="en-US" >begins with</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id341662920861588" role="tablecontent"
xml-lang="en-US" >Applies the selected style to the cell when the cell contents
begins with the text or number defined in the right text box.</paragraph>
+ <note id="par_id801662922586796"><variable
id="text_comparison">The condition applies to the internal text conversion of
the cell contents. Numeric values are compared with their equivalent text
representation. Numeric cell formats (currency, scientific, user-defined ... )
are not considered for comparisons.</variable></note>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id361662922600585" role="tablecontent"
xml-lang="en-US" >ends with</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id801662922600586" role="tablecontent"
xml-lang="en-US" >Applies the selected style to the cell when the cell contents
ends with the text or number defined in the right text box.</paragraph>
+ <note localize="false" id="par_id221662923585290"><embedvar
href="text/scalc/01/05120100.xhp#text_comparison" markup="keep"/></note>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id151662922939292" role="tablecontent"
xml-lang="en-US" >contains</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id251662922939293" role="tablecontent"
xml-lang="en-US" >Applies the selected style to the cell when the cell contents
contains the text or number defined in the right text box.</paragraph>
+ <note localize="false" id="par_id221662923585291"><embedvar
href="text/scalc/01/05120100.xhp#text_comparison" markup="keep"/></note>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id291662923021542" role="tablecontent"
xml-lang="en-US" >does not contain</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id541662923021543" role="tablecontent"
xml-lang="en-US" >Applies the selected style to the cell when the cell contents
does not contains the text or number defined in the right text box.</paragraph>
+ <note localize="false" id="par_id221662923585292"><embedvar
href="text/scalc/01/05120100.xhp#text_comparison" markup="keep"/></note>
+ </tablecell>
+ </tablerow>
+ </table>
+
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/05120200.xhp
b/source/text/scalc/01/05120200.xhp
new file mode 100644
index 000000000..90c9c5d15
--- /dev/null
+++ b/source/text/scalc/01/05120200.xhp
@@ -0,0 +1,27 @@
+<?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/.
+ *
+ -->
+
+ <meta>
+ <topic id="pageconditionalformattingformulais" indexer="include"
status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Conditional Formatting - Formula
is</title>
+ <filename>/text/scalc/01/05120200.xhp</filename>
+ </topic>
+</meta>
+<body>
+<bookmark id="bm_id221662936567368" xml-lang="en-US" branch="hid/zzzz"
localize="false"/>
+<section id="formulais">
+ <h1 id="hd_id471662936567369"><variable id="h1"><link
href="text/scalc/01/05120200.xhp" name="Formula is">Condition - Formula
is</link></variable></h1>
+ <paragraph xml-lang="en-US" id="par_id31494139" role="paragraph">Applies
the selected style to the cell when the formula expression in the text box in
the right is <emph>not</emph> zero.</paragraph>
+</section>
+ <paragraph role="paragraph" id="par_id1001662932287796">The formula is
expressed similar to a test condition evaluating to <literal>TRUE</literal> or
<literal>FALSE</literal>.</paragraph>
+ <paragraph role="paragraph" id="par_id111662936728630">For example, if C29
has a conditional formatting which formula is
<input>B1>=(DATE(2015;5;4)+TIME(18;0;0))</input> - a logical expression that
evaluates true or false - the style applied to C29 depends on B1
contents.</paragraph>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/05120300.xhp
b/source/text/scalc/01/05120300.xhp
new file mode 100644
index 000000000..42ef32b0e
--- /dev/null
+++ b/source/text/scalc/01/05120300.xhp
@@ -0,0 +1,51 @@
+<?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/.
+ *
+ -->
+
+ <meta>
+ <topic id="conditioal formattingdateis" indexer="include"
status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Conditional Formatting - Date
is</title>
+ <filename>/text/scalc/01/05120300.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+ <bookmark id="bm_id691662936831681" xml-lang="en-US" branch="hid/zzzz"
localize="false"/>
+ <section id="dateis">
+ <h1 id="hd_id321662936831682"><variable id="h1"><link
href="text/scalc/01/05120300.xhp" name="Date is">Condition - Date
is</link></variable></h1>
+ <paragraph role="paragraph" id="par_id31662934883939">Applies the
selected style to the cell when the cell contents is formatted as date and the
condition is one of the available date interval in the dropdown
list.</paragraph>
+ </section>
+
+ <list type="unordered">
+ <listitem>
+ <paragraph id="par_id231662933568615"
role="listitem"><emph>Today</emph>: applies the cell style if the cell date
contents is today.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id891662933647849"
role="listitem"><emph>Yesterday</emph>: applies the cell style if the cell date
contents is yesterday.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id701662933702962"
role="listitem"><emph>Tomorrow</emph>: applies the cell style if the cell date
contents is tomorrow.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id291662933755624" role="listitem"><emph>Last
7 days</emph>: applies the cell style if the cell date contents is in the last
7 calendar days.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id151662933849611" role="listitem"><emph>This
week, Last week and Next week</emph>: applies the cell style if the cell date
contents is in this week, last week and next week respectively. The start and
end of the week is locale dependent.</paragraph>
+ </listitem>
+
+ <listitem>
+ <paragraph id="par_id421662934429482" role="listitem"><emph>This
month, Last month and Next month</emph>: applies the cell style if the cell
date contents is in this month, last month and next month
respectively.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id461662934605639" role="listitem"><emph>This
year, Last year and Next year</emph>: applies the cell style if the cell date
contents is in this year, last year and next year respectively.</paragraph>
+ </listitem>
+ </list>
+
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/05120400.xhp
b/source/text/scalc/01/05120400.xhp
new file mode 100644
index 000000000..c6136ed96
--- /dev/null
+++ b/source/text/scalc/01/05120400.xhp
@@ -0,0 +1,81 @@
+<?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/.
+ *
+ -->
+
+ <meta>
+ <topic id="conditionalformattingallcells" indexer="include"
status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Conditional Formatting - All
cells</title>
+ <filename>/text/scalc/01/05120400.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+
+ <section id="allcells">
+ <h1 id="hd_id861662937013389"><variable id="h1"><link
href="text/scalc/01/05120400.xhp" name="All cells">Condition - All
cells</link></variable></h1>
+ <paragraph role="paragraph" id="par_id31662915586650">Applies the
conditional formatting to the set of cells defined in the selected range. The
formatting is applied based on the contents of the whole range.</paragraph>
+ </section>
+ <h2 id="hd_id3147394">Color Scale</h2>
+ <paragraph xml-lang="en-US" id="par_id3155602" role="paragraph">Applies a
color scale to a range consisting 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>
+
+ <h2 id="par_id991609782427459">Data Bar</h2>
+ <paragraph role="paragraph" id="par_id41609780964157">Data bar option will
fill the cell with solid or gradient color corresponding to the numeric value
in the cell. Default is blue for positive and red for negative. </paragraph>
+ <paragraph role="paragraph" id="par_id931609781970981">The calculation of
the area of fill is based on Min - Max - Percentile - Value - Percent -
Formula.</paragraph>
+ <paragraph role="paragraph" id="par_id981609782003841">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 role="paragraph" id="par_id281609781729359"><emph>More
Options...</emph> opens a dialog to: </paragraph>
+ <list type="unordered">
+ <listitem>
+ <paragraph id="par_id271609781812913" role="listitem">change
colors</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id921609781838551" role="listitem"> change
position of vertical axis within the cell</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id631609781859971" role="listitem"> the bar's
minimum and maximum length in percentage</paragraph>
+ </listitem>
+ </list>
+
+ <h2 id="hd_id3153709">Icon Set</h2>
+ <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>
+
+ <section id="relatedtopics">
+ <paragraph xml-lang="en-US" id="par_id3155606" role="paragraph"><link
href="https://wiki.documentfoundation.org/Faq/Calc/141";>How to use Icon Set
Conditional Formatting page</link> in TDF Wiki.</paragraph>
+ </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/05120500.xhp
b/source/text/scalc/01/05120500.xhp
new file mode 100644
index 000000000..b65cf8a6f
--- /dev/null
+++ b/source/text/scalc/01/05120500.xhp
@@ -0,0 +1,36 @@
+<?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/.
+ *
+ -->
+
+ <meta>
+ <topic id="conditionalformattingmanage" indexer="include"
status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Conditional Formatting - Manage
Conditions</title>
+ <filename>/text/scalc/01/05120500.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+ <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"/>
+ <section id="manageconditions">
+ <h1 id="hd_id391662937414401"><variable id="h1"><link
href="text/scalc/01/05120500.xhp" name="Manage Conditions">Manage
Conditions</link></variable></h1>
+ <paragraph xml-lang="en-US" id="par_id3155906" role="paragraph">Manage
all the conditional formatting defined in the spreadsheet.</paragraph>
+ </section>
+ <section id="howtoget">
+ <paragraph role="paragraph" id="par_id31546818"
xml-lang="en-US">Choose <menuitem>Format - Conditional Formatting -
Manage</menuitem>.</paragraph>
+ </section>
+ <paragraph xml-lang="en-US" id="par_id3155907" role="paragraph">The
<emph>Manage Conditional Formatting</emph> dialog is where you can add, edit or
delete one or several conditional formattings.</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">The
<emph>Conditional Formats</emph> list displays the active conditional
formatting rules set in the current spreadsheet. 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>
+
+</body>
+</helpdocument>
