diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2022-09-19 13:31:21 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2022-09-19 19:57:01 +0200 |
| commit | 4b86dd440667832cd5510a1bd31ff35514532d06 (patch) | |
| tree | 15bed1956c95b5af9f96db64c61f1be6ed08a473 | |
| parent | 9abe3f66a8951fef89d79b5125931773778cda22 (diff) | |
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>
71 files changed, 36 insertions, 25 deletions
diff --git a/AllLangPackage_html_media_lang.mk b/AllLangPackage_html_media_lang.mk index 31ced97af4..f5456c2c47 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 e414b97308..ae8e205232 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 Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/am/conditionalformatting.ods diff --git a/source/media/files/scalc/ar/conditionalformatting.ods b/source/media/files/scalc/ar/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/ar/conditionalformatting.ods diff --git a/source/media/files/scalc/ast/conditionalformatting.ods b/source/media/files/scalc/ast/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/ast/conditionalformatting.ods diff --git a/source/media/files/scalc/bg/conditionalformatting.ods b/source/media/files/scalc/bg/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/bg/conditionalformatting.ods diff --git a/source/media/files/scalc/bn-IN/conditionalformatting.ods b/source/media/files/scalc/bn-IN/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/bn-IN/conditionalformatting.ods diff --git a/source/media/files/scalc/bn/conditionalformatting.ods b/source/media/files/scalc/bn/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/bn/conditionalformatting.ods diff --git a/source/media/files/scalc/bo/conditionalformatting.ods b/source/media/files/scalc/bo/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/bo/conditionalformatting.ods diff --git a/source/media/files/scalc/bs/conditionalformatting.ods b/source/media/files/scalc/bs/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/bs/conditionalformatting.ods diff --git a/source/media/files/scalc/ca-valencia/conditionalformatting.ods b/source/media/files/scalc/ca-valencia/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/ca-valencia/conditionalformatting.ods diff --git a/source/media/files/scalc/ca/conditionalformatting.ods b/source/media/files/scalc/ca/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/ca/conditionalformatting.ods diff --git a/source/media/files/scalc/conditionalformatting.ods b/source/media/files/scalc/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/conditionalformatting.ods diff --git a/source/media/files/scalc/cs/conditionalformatting.ods b/source/media/files/scalc/cs/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/cs/conditionalformatting.ods diff --git a/source/media/files/scalc/da/conditionalformatting.ods b/source/media/files/scalc/da/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/da/conditionalformatting.ods diff --git a/source/media/files/scalc/de/conditionalformatting.ods b/source/media/files/scalc/de/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/de/conditionalformatting.ods diff --git a/source/media/files/scalc/dz/conditionalformatting.ods b/source/media/files/scalc/dz/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/dz/conditionalformatting.ods diff --git a/source/media/files/scalc/el/conditionalformatting.ods b/source/media/files/scalc/el/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/el/conditionalformatting.ods diff --git a/source/media/files/scalc/en-GB/conditionalformatting.ods b/source/media/files/scalc/en-GB/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/en-GB/conditionalformatting.ods diff --git a/source/media/files/scalc/en-US/conditionalformatting.ods b/source/media/files/scalc/en-US/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/en-US/conditionalformatting.ods diff --git a/source/media/files/scalc/en-ZA/conditionalformatting.ods b/source/media/files/scalc/en-ZA/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/en-ZA/conditionalformatting.ods diff --git a/source/media/files/scalc/eo/conditionalformatting.ods b/source/media/files/scalc/eo/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/eo/conditionalformatting.ods diff --git a/source/media/files/scalc/es/conditionalformatting.ods b/source/media/files/scalc/es/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/es/conditionalformatting.ods diff --git a/source/media/files/scalc/et/conditionalformatting.ods b/source/media/files/scalc/et/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/et/conditionalformatting.ods diff --git a/source/media/files/scalc/eu/conditionalformatting.ods b/source/media/files/scalc/eu/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/eu/conditionalformatting.ods diff --git a/source/media/files/scalc/fi/conditionalformatting.ods b/source/media/files/scalc/fi/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/fi/conditionalformatting.ods diff --git a/source/media/files/scalc/fr/conditionalformatting.ods b/source/media/files/scalc/fr/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/fr/conditionalformatting.ods diff --git a/source/media/files/scalc/gl/conditionalformatting.ods b/source/media/files/scalc/gl/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/gl/conditionalformatting.ods diff --git a/source/media/files/scalc/gu/conditionalformatting.ods b/source/media/files/scalc/gu/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/gu/conditionalformatting.ods diff --git a/source/media/files/scalc/he/conditionalformatting.ods b/source/media/files/scalc/he/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/he/conditionalformatting.ods diff --git a/source/media/files/scalc/hi/conditionalformatting.ods b/source/media/files/scalc/hi/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/hi/conditionalformatting.ods diff --git a/source/media/files/scalc/hr/conditionalformatting.ods b/source/media/files/scalc/hr/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/hr/conditionalformatting.ods diff --git a/source/media/files/scalc/hu/conditionalformatting.ods b/source/media/files/scalc/hu/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/hu/conditionalformatting.ods diff --git a/source/media/files/scalc/id/conditionalformatting.ods b/source/media/files/scalc/id/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/id/conditionalformatting.ods diff --git a/source/media/files/scalc/is/conditionalformatting.ods b/source/media/files/scalc/is/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/is/conditionalformatting.ods diff --git a/source/media/files/scalc/it/conditionalformatting.ods b/source/media/files/scalc/it/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/it/conditionalformatting.ods diff --git a/source/media/files/scalc/ja/conditionalformatting.ods b/source/media/files/scalc/ja/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/ja/conditionalformatting.ods diff --git a/source/media/files/scalc/ka/conditionalformatting.ods b/source/media/files/scalc/ka/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/ka/conditionalformatting.ods diff --git a/source/media/files/scalc/km/conditionalformatting.ods b/source/media/files/scalc/km/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/km/conditionalformatting.ods diff --git a/source/media/files/scalc/ko/conditionalformatting.ods b/source/media/files/scalc/ko/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/ko/conditionalformatting.ods diff --git a/source/media/files/scalc/lo/conditionalformatting.ods b/source/media/files/scalc/lo/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/lo/conditionalformatting.ods diff --git a/source/media/files/scalc/lt/conditionalformatting.ods b/source/media/files/scalc/lt/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/lt/conditionalformatting.ods diff --git a/source/media/files/scalc/lv/conditionalformatting.ods b/source/media/files/scalc/lv/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/lv/conditionalformatting.ods diff --git a/source/media/files/scalc/mk/conditionalformatting.ods b/source/media/files/scalc/mk/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/mk/conditionalformatting.ods diff --git a/source/media/files/scalc/nb/conditionalformatting.ods b/source/media/files/scalc/nb/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/nb/conditionalformatting.ods diff --git a/source/media/files/scalc/ne/conditionalformatting.ods b/source/media/files/scalc/ne/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/ne/conditionalformatting.ods diff --git a/source/media/files/scalc/nl/conditionalformatting.ods b/source/media/files/scalc/nl/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/nl/conditionalformatting.ods diff --git a/source/media/files/scalc/nn/conditionalformatting.ods b/source/media/files/scalc/nn/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/nn/conditionalformatting.ods diff --git a/source/media/files/scalc/om/conditionalformatting.ods b/source/media/files/scalc/om/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/om/conditionalformatting.ods diff --git a/source/media/files/scalc/pl/conditionalformatting.ods b/source/media/files/scalc/pl/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/pl/conditionalformatting.ods diff --git a/source/media/files/scalc/pt-BR/conditionalformatting.ods b/source/media/files/scalc/pt-BR/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/pt-BR/conditionalformatting.ods diff --git a/source/media/files/scalc/pt/conditionalformatting.ods b/source/media/files/scalc/pt/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/pt/conditionalformatting.ods diff --git a/source/media/files/scalc/qtz/conditionalformatting.ods b/source/media/files/scalc/qtz/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/qtz/conditionalformatting.ods diff --git a/source/media/files/scalc/ro/conditionalformatting.ods b/source/media/files/scalc/ro/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/ro/conditionalformatting.ods diff --git a/source/media/files/scalc/ru/conditionalformatting.ods b/source/media/files/scalc/ru/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/ru/conditionalformatting.ods diff --git a/source/media/files/scalc/si/conditionalformatting.ods b/source/media/files/scalc/si/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/si/conditionalformatting.ods diff --git a/source/media/files/scalc/sid/conditionalformatting.ods b/source/media/files/scalc/sid/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/sid/conditionalformatting.ods diff --git a/source/media/files/scalc/sk/conditionalformatting.ods b/source/media/files/scalc/sk/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/sk/conditionalformatting.ods diff --git a/source/media/files/scalc/sl/conditionalformatting.ods b/source/media/files/scalc/sl/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/sl/conditionalformatting.ods diff --git a/source/media/files/scalc/sq/conditionalformatting.ods b/source/media/files/scalc/sq/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/sq/conditionalformatting.ods diff --git a/source/media/files/scalc/sv/conditionalformatting.ods b/source/media/files/scalc/sv/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/sv/conditionalformatting.ods diff --git a/source/media/files/scalc/ta/conditionalformatting.ods b/source/media/files/scalc/ta/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/ta/conditionalformatting.ods diff --git a/source/media/files/scalc/tg/conditionalformatting.ods b/source/media/files/scalc/tg/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/tg/conditionalformatting.ods diff --git a/source/media/files/scalc/tr/conditionalformatting.ods b/source/media/files/scalc/tr/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/tr/conditionalformatting.ods diff --git a/source/media/files/scalc/ug/conditionalformatting.ods b/source/media/files/scalc/ug/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/ug/conditionalformatting.ods diff --git a/source/media/files/scalc/uk/conditionalformatting.ods b/source/media/files/scalc/uk/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/uk/conditionalformatting.ods diff --git a/source/media/files/scalc/vi/conditionalformatting.ods b/source/media/files/scalc/vi/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/vi/conditionalformatting.ods diff --git a/source/media/files/scalc/zh-CN/conditionalformatting.ods b/source/media/files/scalc/zh-CN/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/zh-CN/conditionalformatting.ods diff --git a/source/media/files/scalc/zh-TW/conditionalformatting.ods b/source/media/files/scalc/zh-TW/conditionalformatting.ods Binary files differnew file mode 100644 index 0000000000..5df7aa8c67 --- /dev/null +++ b/source/media/files/scalc/zh-TW/conditionalformatting.ods diff --git a/source/text/scalc/01/05120400.xhp b/source/text/scalc/01/05120400.xhp index ac3c4a2215..c5e90c644c 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 40dc41adc7..a31061bee7 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> |