tdf#119421 Add sample files for conditional formatting
Change-Id: Id5826f32bd2de2e286eecf57dc817f4b60a2599b
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/140196
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
diff --git a/AllLangPackage_html_media_lang.mk b/AllLangPackage_html_media_lang.mk
index 31ced97..f5456c2 100644
--- a/AllLangPackage_html_media_lang.mk
+++ b/AllLangPackage_html_media_lang.mk
@@ -287,5 +287,6 @@ $(foreach lang,$(filter-out en-US,$(gb_HELP_LANGS)),$(eval $(call gb_AllLangPack
files/scalc/$(lang)/pivot.ods \
files/scalc/$(lang)/functions_ifs.ods \
files/scalc/$(lang)/function_fourier.ods \
files/scalc/$(lang)/conditionalformatting.ods \
)))
# vim: set noet sw=4 ts=4:
diff --git a/Package_html_media.mk b/Package_html_media.mk
index e414b97..ae8e205 100644
--- a/Package_html_media.mk
+++ b/Package_html_media.mk
@@ -20,6 +20,7 @@ $(eval $(call gb_Package_add_files_with_dir,helpcontent2_html_media,$(LIBO_SHARE
files/scalc/pivot.ods \
files/scalc/trigon.ods \
files/scalc/functions_ifs.ods \
files/scalc/conditionalformatting.ods \
helpimg/area1.png \
helpimg/area2.png \
helpimg/border_ca_1.png \
diff --git a/source/media/files/scalc/am/conditionalformatting.ods b/source/media/files/scalc/am/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/am/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/ar/conditionalformatting.ods b/source/media/files/scalc/ar/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/ar/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/ast/conditionalformatting.ods b/source/media/files/scalc/ast/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/ast/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/bg/conditionalformatting.ods b/source/media/files/scalc/bg/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/bg/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/bn-IN/conditionalformatting.ods b/source/media/files/scalc/bn-IN/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/bn-IN/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/bn/conditionalformatting.ods b/source/media/files/scalc/bn/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/bn/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/bo/conditionalformatting.ods b/source/media/files/scalc/bo/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/bo/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/bs/conditionalformatting.ods b/source/media/files/scalc/bs/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/bs/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/ca-valencia/conditionalformatting.ods b/source/media/files/scalc/ca-valencia/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/ca-valencia/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/ca/conditionalformatting.ods b/source/media/files/scalc/ca/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/ca/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/conditionalformatting.ods b/source/media/files/scalc/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/cs/conditionalformatting.ods b/source/media/files/scalc/cs/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/cs/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/da/conditionalformatting.ods b/source/media/files/scalc/da/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/da/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/de/conditionalformatting.ods b/source/media/files/scalc/de/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/de/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/dz/conditionalformatting.ods b/source/media/files/scalc/dz/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/dz/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/el/conditionalformatting.ods b/source/media/files/scalc/el/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/el/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/en-GB/conditionalformatting.ods b/source/media/files/scalc/en-GB/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/en-GB/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/en-US/conditionalformatting.ods b/source/media/files/scalc/en-US/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/en-US/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/en-ZA/conditionalformatting.ods b/source/media/files/scalc/en-ZA/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/en-ZA/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/eo/conditionalformatting.ods b/source/media/files/scalc/eo/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/eo/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/es/conditionalformatting.ods b/source/media/files/scalc/es/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/es/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/et/conditionalformatting.ods b/source/media/files/scalc/et/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/et/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/eu/conditionalformatting.ods b/source/media/files/scalc/eu/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/eu/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/fi/conditionalformatting.ods b/source/media/files/scalc/fi/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/fi/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/fr/conditionalformatting.ods b/source/media/files/scalc/fr/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/fr/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/gl/conditionalformatting.ods b/source/media/files/scalc/gl/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/gl/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/gu/conditionalformatting.ods b/source/media/files/scalc/gu/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/gu/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/he/conditionalformatting.ods b/source/media/files/scalc/he/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/he/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/hi/conditionalformatting.ods b/source/media/files/scalc/hi/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/hi/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/hr/conditionalformatting.ods b/source/media/files/scalc/hr/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/hr/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/hu/conditionalformatting.ods b/source/media/files/scalc/hu/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/hu/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/id/conditionalformatting.ods b/source/media/files/scalc/id/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/id/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/is/conditionalformatting.ods b/source/media/files/scalc/is/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/is/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/it/conditionalformatting.ods b/source/media/files/scalc/it/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/it/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/ja/conditionalformatting.ods b/source/media/files/scalc/ja/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/ja/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/ka/conditionalformatting.ods b/source/media/files/scalc/ka/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/ka/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/km/conditionalformatting.ods b/source/media/files/scalc/km/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/km/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/ko/conditionalformatting.ods b/source/media/files/scalc/ko/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/ko/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/lo/conditionalformatting.ods b/source/media/files/scalc/lo/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/lo/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/lt/conditionalformatting.ods b/source/media/files/scalc/lt/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/lt/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/lv/conditionalformatting.ods b/source/media/files/scalc/lv/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/lv/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/mk/conditionalformatting.ods b/source/media/files/scalc/mk/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/mk/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/nb/conditionalformatting.ods b/source/media/files/scalc/nb/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/nb/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/ne/conditionalformatting.ods b/source/media/files/scalc/ne/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/ne/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/nl/conditionalformatting.ods b/source/media/files/scalc/nl/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/nl/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/nn/conditionalformatting.ods b/source/media/files/scalc/nn/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/nn/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/om/conditionalformatting.ods b/source/media/files/scalc/om/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/om/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/pl/conditionalformatting.ods b/source/media/files/scalc/pl/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/pl/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/pt-BR/conditionalformatting.ods b/source/media/files/scalc/pt-BR/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/pt-BR/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/pt/conditionalformatting.ods b/source/media/files/scalc/pt/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/pt/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/qtz/conditionalformatting.ods b/source/media/files/scalc/qtz/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/qtz/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/ro/conditionalformatting.ods b/source/media/files/scalc/ro/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/ro/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/ru/conditionalformatting.ods b/source/media/files/scalc/ru/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/ru/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/si/conditionalformatting.ods b/source/media/files/scalc/si/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/si/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/sid/conditionalformatting.ods b/source/media/files/scalc/sid/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/sid/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/sk/conditionalformatting.ods b/source/media/files/scalc/sk/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/sk/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/sl/conditionalformatting.ods b/source/media/files/scalc/sl/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/sl/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/sq/conditionalformatting.ods b/source/media/files/scalc/sq/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/sq/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/sv/conditionalformatting.ods b/source/media/files/scalc/sv/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/sv/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/ta/conditionalformatting.ods b/source/media/files/scalc/ta/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/ta/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/tg/conditionalformatting.ods b/source/media/files/scalc/tg/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/tg/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/tr/conditionalformatting.ods b/source/media/files/scalc/tr/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/tr/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/ug/conditionalformatting.ods b/source/media/files/scalc/ug/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/ug/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/uk/conditionalformatting.ods b/source/media/files/scalc/uk/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/uk/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/vi/conditionalformatting.ods b/source/media/files/scalc/vi/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/vi/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/zh-CN/conditionalformatting.ods b/source/media/files/scalc/zh-CN/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/zh-CN/conditionalformatting.ods
Binary files differ
diff --git a/source/media/files/scalc/zh-TW/conditionalformatting.ods b/source/media/files/scalc/zh-TW/conditionalformatting.ods
new file mode 100644
index 0000000..5df7aa8
--- /dev/null
+++ b/source/media/files/scalc/zh-TW/conditionalformatting.ods
Binary files differ
diff --git a/source/text/scalc/01/05120400.xhp b/source/text/scalc/01/05120400.xhp
index ac3c4a2..c5e90c6 100644
--- a/source/text/scalc/01/05120400.xhp
+++ b/source/text/scalc/01/05120400.xhp
@@ -28,29 +28,15 @@
<section id="howtoget">
<embed href="text/scalc/00/00000405.xhp#s_conditionalcolorscale"/>
</section>
<paragraph role="paragraph" id="par_id341663448456472">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>
<section id="databar">
<h2 id="par_id991609782427459"><link href="text/scalc/01/05120400.xhp#databar" name="Data Bar">Data Bar</link></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.</paragraph>
</section>
<section id="howtoget">
<embed href="text/scalc/00/00000405.xhp#s_conditionaldatabar"/>
</section>
<h3 id="hd_id631663449553346">Conditions</h3>
<paragraph role="paragraph" id="par_id931609781970981">The calculation of the bar area fill is based on the conditions below:</paragraph>
<list type="unordered">
<listitem>
<paragraph id="par_id281663449673792" role="listitem"><emph>Automatic</emph>: calculates using the minimum and maximum values in the range.</paragraph>
</listitem>
<listitem>
<paragraph id="par_id701663449697771" role="listitem"><emph>Min (Max)</emph>: calculates using the minimum (maximum) values in the range.</paragraph>
</listitem>
</list>
<section id="commonconditions">
<h3 id="hd_id541663598275609">Conditions</h3>
<paragraph role="paragraph" id="par_id231663598294535">The calculation of the color scale depends on 2 or 3 conditions, defined as follows:</paragraph>
<list type="unordered">
<listitem>
<paragraph id="par_id701864449697771" role="listitem"><emph>Min (Max)</emph>: calculates using the minimum (maximum) values in the range.</paragraph>
</listitem>
</list>
<section id="commonconditions">
<list type="unordered">
<listitem>
<paragraph id="par_id321663440728295" role="listitem"><emph>Value</emph>: a fixed value. Enter the value in the text box.</paragraph>
@@ -66,7 +52,25 @@
</listitem>
</list>
</section>
<embed href="text/scalc/06/calcsamplefiles.xhp#conditionalformatting"/>
<section id="databar">
<h2 id="par_id991609782427459"><link href="text/scalc/01/05120400.xhp#databar" name="Data Bar">Data Bar</link></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.</paragraph>
</section>
<section id="howtoget">
<embed href="text/scalc/00/00000405.xhp#s_conditionaldatabar"/>
</section>
<h3 id="hd_id631663449553346">Conditions</h3>
<paragraph role="paragraph" id="par_id931609781970981">The calculation of the bar area fill is based on the conditions below:</paragraph>
<list type="unordered">
<listitem>
<paragraph id="par_id281663449673792" role="listitem"><emph>Automatic</emph>: calculates using the minimum and maximum values in the range.</paragraph>
</listitem>
<listitem>
<paragraph id="par_id701663449697771" role="listitem"><emph>Min (Max)</emph>: calculates using the minimum (maximum) values in the range.</paragraph>
</listitem>
</list>
<embed href="text/scalc/01/05120400.xhp#commonconditions"/>
<h3 id="par_id281609781729359">More Options</h3>
<paragraph role="paragraph" id="par_id501663454998977">The Data Bar dialog opens to add details on the display of data bars.</paragraph>
<h4 id="hd_id221663453502042">Entry values</h4>
@@ -100,7 +104,7 @@
<paragraph role="paragraph" id="par_id601663453865023">Sets the minimum (maximum) length of the data bars, as a percentage of the column width.</paragraph>
<h4 id="hd_id211663453914830">Display bars only</h4>
<paragraph role="paragraph" id="par_id561663453936590">Do not display values in the cell, only the data bars.</paragraph>
<embed href="text/scalc/06/calcsamplefiles.xhp#conditionalformatting"/>
<section id="iconset">
<h2 id="hd_id3153709"><link href="text/scalc/01/05120400.xhp#iconset" name="Icon Set">Icon Set</link></h2>
<paragraph xml-lang="en-US" id="par_id3153764" role="paragraph">Add an icon to the cell based on the value relative to the specified thresholds. Several icon sets are available.</paragraph>
@@ -230,8 +234,10 @@
<h3 id="hd_id621663440395987">Conditions for thresholds</h3>
<paragraph xml-lang="en-US" id="par_id3153765" role="paragraph">Conditions to set the thresholds for each icon can be specified as follows</paragraph>
<embed href="text/scalc/01/05120400.xhp#commonconditions"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#conditionalformatting"/>
<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>
<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>
<paragraph role="paragraph" id="par_id651663598549283"><link href="https://wiki.documentfoundation.org/Faq/Calc/142">How to apply a Color Scale Conditional Formatting page</link> in TDF Wiki.</paragraph>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/06/calcsamplefiles.xhp b/source/text/scalc/06/calcsamplefiles.xhp
index 40dc41a..a31061b 100644
--- a/source/text/scalc/06/calcsamplefiles.xhp
+++ b/source/text/scalc/06/calcsamplefiles.xhp
@@ -29,5 +29,8 @@
<section id="func_fourier">
<paragraph role="paragraph" id="par_id591561765191143" localize="false"><object data="media/files/scalc/function_fourier.ods" id="ods_id61521525603534" type="application/vnd.oasis.opendocument.spreadsheet" /></paragraph>
</section>
<section id="conditionalformatting">
<paragraph role="paragraph" id="par_id591563765191143" localize="false"><object data="media/files/scalc/conditionalformatting.ods" id="ods_id61521525603534" type="application/vnd.oasis.opendocument.spreadsheet" /></paragraph>
</section>
</body>
</helpdocument>
