AllLangPackage_html_media_lang.mk | 1
Package_html_media.mk | 1
source/media/files/scalc/am/conditionalformatting.ods |binary
source/media/files/scalc/ar/conditionalformatting.ods |binary
source/media/files/scalc/ast/conditionalformatting.ods |binary
source/media/files/scalc/bg/conditionalformatting.ods |binary
source/media/files/scalc/bn-IN/conditionalformatting.ods |binary
source/media/files/scalc/bn/conditionalformatting.ods |binary
source/media/files/scalc/bo/conditionalformatting.ods |binary
source/media/files/scalc/bs/conditionalformatting.ods |binary
source/media/files/scalc/ca-valencia/conditionalformatting.ods |binary
source/media/files/scalc/ca/conditionalformatting.ods |binary
source/media/files/scalc/conditionalformatting.ods |binary
source/media/files/scalc/cs/conditionalformatting.ods |binary
source/media/files/scalc/da/conditionalformatting.ods |binary
source/media/files/scalc/de/conditionalformatting.ods |binary
source/media/files/scalc/dz/conditionalformatting.ods |binary
source/media/files/scalc/el/conditionalformatting.ods |binary
source/media/files/scalc/en-GB/conditionalformatting.ods |binary
source/media/files/scalc/en-US/conditionalformatting.ods |binary
source/media/files/scalc/en-ZA/conditionalformatting.ods |binary
source/media/files/scalc/eo/conditionalformatting.ods |binary
source/media/files/scalc/es/conditionalformatting.ods |binary
source/media/files/scalc/et/conditionalformatting.ods |binary
source/media/files/scalc/eu/conditionalformatting.ods |binary
source/media/files/scalc/fi/conditionalformatting.ods |binary
source/media/files/scalc/fr/conditionalformatting.ods |binary
source/media/files/scalc/gl/conditionalformatting.ods |binary
source/media/files/scalc/gu/conditionalformatting.ods |binary
source/media/files/scalc/he/conditionalformatting.ods |binary
source/media/files/scalc/hi/conditionalformatting.ods |binary
source/media/files/scalc/hr/conditionalformatting.ods |binary
source/media/files/scalc/hu/conditionalformatting.ods |binary
source/media/files/scalc/id/conditionalformatting.ods |binary
source/media/files/scalc/is/conditionalformatting.ods |binary
source/media/files/scalc/it/conditionalformatting.ods |binary
source/media/files/scalc/ja/conditionalformatting.ods |binary
source/media/files/scalc/ka/conditionalformatting.ods |binary
source/media/files/scalc/km/conditionalformatting.ods |binary
source/media/files/scalc/ko/conditionalformatting.ods |binary
source/media/files/scalc/lo/conditionalformatting.ods |binary
source/media/files/scalc/lt/conditionalformatting.ods |binary
source/media/files/scalc/lv/conditionalformatting.ods |binary
source/media/files/scalc/mk/conditionalformatting.ods |binary
source/media/files/scalc/nb/conditionalformatting.ods |binary
source/media/files/scalc/ne/conditionalformatting.ods |binary
source/media/files/scalc/nl/conditionalformatting.ods |binary
source/media/files/scalc/nn/conditionalformatting.ods |binary
source/media/files/scalc/om/conditionalformatting.ods |binary
source/media/files/scalc/pl/conditionalformatting.ods |binary
source/media/files/scalc/pt-BR/conditionalformatting.ods |binary
source/media/files/scalc/pt/conditionalformatting.ods |binary
source/media/files/scalc/qtz/conditionalformatting.ods |binary
source/media/files/scalc/ro/conditionalformatting.ods |binary
source/media/files/scalc/ru/conditionalformatting.ods |binary
source/media/files/scalc/si/conditionalformatting.ods |binary
source/media/files/scalc/sid/conditionalformatting.ods |binary
source/media/files/scalc/sk/conditionalformatting.ods |binary
source/media/files/scalc/sl/conditionalformatting.ods |binary
source/media/files/scalc/sq/conditionalformatting.ods |binary
source/media/files/scalc/sv/conditionalformatting.ods |binary
source/media/files/scalc/ta/conditionalformatting.ods |binary
source/media/files/scalc/tg/conditionalformatting.ods |binary
source/media/files/scalc/tr/conditionalformatting.ods |binary
source/media/files/scalc/ug/conditionalformatting.ods |binary
source/media/files/scalc/uk/conditionalformatting.ods |binary
source/media/files/scalc/vi/conditionalformatting.ods |binary
source/media/files/scalc/zh-CN/conditionalformatting.ods |binary
source/media/files/scalc/zh-TW/conditionalformatting.ods |binary
source/text/scalc/01/05120400.xhp | 56
+++++-----
source/text/scalc/06/calcsamplefiles.xhp | 3
71 files changed, 36 insertions(+), 25 deletions(-)
New commits:
commit 4b86dd440667832cd5510a1bd31ff35514532d06
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Mon Sep 19 13:31:21 2022 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Mon Sep 19 19:57:01 2022 +0200
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.hal...@libreoffice.org>
diff --git a/AllLangPackage_html_media_lang.mk
b/AllLangPackage_html_media_lang.mk
index 31ced97af..f5456c2c4 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 e414b9730..ae8e20523 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 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/am/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/ar/conditionalformatting.ods
b/source/media/files/scalc/ar/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/ar/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/ast/conditionalformatting.ods
b/source/media/files/scalc/ast/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/ast/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/bg/conditionalformatting.ods
b/source/media/files/scalc/bg/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/bg/conditionalformatting.ods 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 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/bn-IN/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/bn/conditionalformatting.ods
b/source/media/files/scalc/bn/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/bn/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/bo/conditionalformatting.ods
b/source/media/files/scalc/bo/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/bo/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/bs/conditionalformatting.ods
b/source/media/files/scalc/bs/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/bs/conditionalformatting.ods 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 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/ca-valencia/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/ca/conditionalformatting.ods
b/source/media/files/scalc/ca/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/ca/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/conditionalformatting.ods
b/source/media/files/scalc/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and b/source/media/files/scalc/conditionalformatting.ods
differ
diff --git a/source/media/files/scalc/cs/conditionalformatting.ods
b/source/media/files/scalc/cs/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/cs/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/da/conditionalformatting.ods
b/source/media/files/scalc/da/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/da/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/de/conditionalformatting.ods
b/source/media/files/scalc/de/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/de/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/dz/conditionalformatting.ods
b/source/media/files/scalc/dz/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/dz/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/el/conditionalformatting.ods
b/source/media/files/scalc/el/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/el/conditionalformatting.ods 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 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/en-GB/conditionalformatting.ods 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 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/en-US/conditionalformatting.ods 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 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/en-ZA/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/eo/conditionalformatting.ods
b/source/media/files/scalc/eo/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/eo/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/es/conditionalformatting.ods
b/source/media/files/scalc/es/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/es/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/et/conditionalformatting.ods
b/source/media/files/scalc/et/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/et/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/eu/conditionalformatting.ods
b/source/media/files/scalc/eu/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/eu/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/fi/conditionalformatting.ods
b/source/media/files/scalc/fi/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/fi/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/fr/conditionalformatting.ods
b/source/media/files/scalc/fr/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/fr/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/gl/conditionalformatting.ods
b/source/media/files/scalc/gl/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/gl/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/gu/conditionalformatting.ods
b/source/media/files/scalc/gu/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/gu/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/he/conditionalformatting.ods
b/source/media/files/scalc/he/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/he/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/hi/conditionalformatting.ods
b/source/media/files/scalc/hi/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/hi/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/hr/conditionalformatting.ods
b/source/media/files/scalc/hr/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/hr/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/hu/conditionalformatting.ods
b/source/media/files/scalc/hu/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/hu/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/id/conditionalformatting.ods
b/source/media/files/scalc/id/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/id/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/is/conditionalformatting.ods
b/source/media/files/scalc/is/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/is/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/it/conditionalformatting.ods
b/source/media/files/scalc/it/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/it/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/ja/conditionalformatting.ods
b/source/media/files/scalc/ja/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/ja/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/ka/conditionalformatting.ods
b/source/media/files/scalc/ka/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/ka/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/km/conditionalformatting.ods
b/source/media/files/scalc/km/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/km/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/ko/conditionalformatting.ods
b/source/media/files/scalc/ko/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/ko/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/lo/conditionalformatting.ods
b/source/media/files/scalc/lo/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/lo/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/lt/conditionalformatting.ods
b/source/media/files/scalc/lt/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/lt/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/lv/conditionalformatting.ods
b/source/media/files/scalc/lv/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/lv/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/mk/conditionalformatting.ods
b/source/media/files/scalc/mk/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/mk/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/nb/conditionalformatting.ods
b/source/media/files/scalc/nb/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/nb/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/ne/conditionalformatting.ods
b/source/media/files/scalc/ne/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/ne/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/nl/conditionalformatting.ods
b/source/media/files/scalc/nl/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/nl/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/nn/conditionalformatting.ods
b/source/media/files/scalc/nn/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/nn/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/om/conditionalformatting.ods
b/source/media/files/scalc/om/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/om/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/pl/conditionalformatting.ods
b/source/media/files/scalc/pl/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/pl/conditionalformatting.ods 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 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/pt-BR/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/pt/conditionalformatting.ods
b/source/media/files/scalc/pt/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/pt/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/qtz/conditionalformatting.ods
b/source/media/files/scalc/qtz/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/qtz/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/ro/conditionalformatting.ods
b/source/media/files/scalc/ro/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/ro/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/ru/conditionalformatting.ods
b/source/media/files/scalc/ru/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/ru/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/si/conditionalformatting.ods
b/source/media/files/scalc/si/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/si/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/sid/conditionalformatting.ods
b/source/media/files/scalc/sid/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/sid/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/sk/conditionalformatting.ods
b/source/media/files/scalc/sk/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/sk/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/sl/conditionalformatting.ods
b/source/media/files/scalc/sl/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/sl/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/sq/conditionalformatting.ods
b/source/media/files/scalc/sq/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/sq/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/sv/conditionalformatting.ods
b/source/media/files/scalc/sv/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/sv/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/ta/conditionalformatting.ods
b/source/media/files/scalc/ta/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/ta/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/tg/conditionalformatting.ods
b/source/media/files/scalc/tg/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/tg/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/tr/conditionalformatting.ods
b/source/media/files/scalc/tr/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/tr/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/ug/conditionalformatting.ods
b/source/media/files/scalc/ug/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/ug/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/uk/conditionalformatting.ods
b/source/media/files/scalc/uk/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/uk/conditionalformatting.ods differ
diff --git a/source/media/files/scalc/vi/conditionalformatting.ods
b/source/media/files/scalc/vi/conditionalformatting.ods
new file mode 100644
index 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/vi/conditionalformatting.ods 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 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/zh-CN/conditionalformatting.ods 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 000000000..5df7aa8c6
Binary files /dev/null and
b/source/media/files/scalc/zh-TW/conditionalformatting.ods differ
diff --git a/source/text/scalc/01/05120400.xhp
b/source/text/scalc/01/05120400.xhp
index ac3c4a221..c5e90c644 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 40dc41adc..a31061bee 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>
