[Libreoffice-commits] help.git: Branch 'libreoffice-6-1' - AllLangPackage_html_media_lang.mk help3xsl/online_transform.xsl Package_html_media.mk source/media source/text
Olivier Hallot
olivier.hallot at libreoffice.org
Tue Jun 12 15:56:48 UTC 2018
AllLangPackage_html_media_lang.mk | 15 ++++++++++-----
Package_html_media.mk | 1 +
help3xsl/online_transform.xsl | 13 +++++++------
source/media/files/scalc/am/functions_ifs.ods |binary
source/media/files/scalc/am/imtrigon.ods |binary
source/media/files/scalc/am/pivot.ods |binary
source/media/files/scalc/am/trigon.ods |binary
source/media/files/scalc/ar/functions_ifs.ods |binary
source/media/files/scalc/ar/imtrigon.ods |binary
source/media/files/scalc/ar/pivot.ods |binary
source/media/files/scalc/ar/trigon.ods |binary
source/media/files/scalc/ast/functions_ifs.ods |binary
source/media/files/scalc/ast/imtrigon.ods |binary
source/media/files/scalc/ast/pivot.ods |binary
source/media/files/scalc/ast/trigon.ods |binary
source/media/files/scalc/bg/functions_ifs.ods |binary
source/media/files/scalc/bg/imtrigon.ods |binary
source/media/files/scalc/bg/pivot.ods |binary
source/media/files/scalc/bg/trigon.ods |binary
source/media/files/scalc/bn-IN/functions_ifs.ods |binary
source/media/files/scalc/bn-IN/imtrigon.ods |binary
source/media/files/scalc/bn-IN/pivot.ods |binary
source/media/files/scalc/bn-IN/trigon.ods |binary
source/media/files/scalc/bn/functions_ifs.ods |binary
source/media/files/scalc/bn/imtrigon.ods |binary
source/media/files/scalc/bn/pivot.ods |binary
source/media/files/scalc/bn/trigon.ods |binary
source/media/files/scalc/bo/functions_ifs.ods |binary
source/media/files/scalc/bo/imtrigon.ods |binary
source/media/files/scalc/bo/pivot.ods |binary
source/media/files/scalc/bo/trigon.ods |binary
source/media/files/scalc/bs/functions_ifs.ods |binary
source/media/files/scalc/bs/imtrigon.ods |binary
source/media/files/scalc/bs/pivot.ods |binary
source/media/files/scalc/bs/trigon.ods |binary
source/media/files/scalc/ca-valencia/functions_ifs.ods |binary
source/media/files/scalc/ca-valencia/imtrigon.ods |binary
source/media/files/scalc/ca-valencia/pivot.ods |binary
source/media/files/scalc/ca-valencia/trigon.ods |binary
source/media/files/scalc/ca/functions_ifs.ods |binary
source/media/files/scalc/ca/imtrigon.ods |binary
source/media/files/scalc/ca/pivot.ods |binary
source/media/files/scalc/ca/trigon.ods |binary
source/media/files/scalc/cs/functions_ifs.ods |binary
source/media/files/scalc/cs/imtrigon.ods |binary
source/media/files/scalc/cs/pivot.ods |binary
source/media/files/scalc/cs/trigon.ods |binary
source/media/files/scalc/da/functions_ifs.ods |binary
source/media/files/scalc/da/imtrigon.ods |binary
source/media/files/scalc/da/pivot.ods |binary
source/media/files/scalc/da/trigon.ods |binary
source/media/files/scalc/de/functions_ifs.ods |binary
source/media/files/scalc/de/imtrigon.ods |binary
source/media/files/scalc/de/pivot.ods |binary
source/media/files/scalc/de/trigon.ods |binary
source/media/files/scalc/dz/functions_ifs.ods |binary
source/media/files/scalc/dz/imtrigon.ods |binary
source/media/files/scalc/dz/pivot.ods |binary
source/media/files/scalc/dz/trigon.ods |binary
source/media/files/scalc/el/functions_ifs.ods |binary
source/media/files/scalc/el/imtrigon.ods |binary
source/media/files/scalc/el/pivot.ods |binary
source/media/files/scalc/el/trigon.ods |binary
source/media/files/scalc/en-GB/functions_ifs.ods |binary
source/media/files/scalc/en-GB/imtrigon.ods |binary
source/media/files/scalc/en-GB/pivot.ods |binary
source/media/files/scalc/en-GB/trigon.ods |binary
source/media/files/scalc/en-US/functions_ifs.ods |binary
source/media/files/scalc/en-US/imtrigon.ods |binary
source/media/files/scalc/en-US/pivot.ods |binary
source/media/files/scalc/en-US/trigon.ods |binary
source/media/files/scalc/en-ZA/functions_ifs.ods |binary
source/media/files/scalc/en-ZA/imtrigon.ods |binary
source/media/files/scalc/en-ZA/pivot.ods |binary
source/media/files/scalc/en-ZA/trigon.ods |binary
source/media/files/scalc/eo/functions_ifs.ods |binary
source/media/files/scalc/eo/imtrigon.ods |binary
source/media/files/scalc/eo/pivot.ods |binary
source/media/files/scalc/eo/trigon.ods |binary
source/media/files/scalc/es/functions_ifs.ods |binary
source/media/files/scalc/es/imtrigon.ods |binary
source/media/files/scalc/es/pivot.ods |binary
source/media/files/scalc/es/trigon.ods |binary
source/media/files/scalc/et/functions_ifs.ods |binary
source/media/files/scalc/et/imtrigon.ods |binary
source/media/files/scalc/et/pivot.ods |binary
source/media/files/scalc/et/trigon.ods |binary
source/media/files/scalc/eu/functions_ifs.ods |binary
source/media/files/scalc/eu/imtrigon.ods |binary
source/media/files/scalc/eu/pivot.ods |binary
source/media/files/scalc/eu/trigon.ods |binary
source/media/files/scalc/fi/functions_ifs.ods |binary
source/media/files/scalc/fi/imtrigon.ods |binary
source/media/files/scalc/fi/pivot.ods |binary
source/media/files/scalc/fi/trigon.ods |binary
source/media/files/scalc/fr/functions_ifs.ods |binary
source/media/files/scalc/fr/imtrigon.ods |binary
source/media/files/scalc/fr/pivot.ods |binary
source/media/files/scalc/fr/trigon.ods |binary
source/media/files/scalc/functions_ifs.ods |binary
source/media/files/scalc/gl/functions_ifs.ods |binary
source/media/files/scalc/gl/imtrigon.ods |binary
source/media/files/scalc/gl/pivot.ods |binary
source/media/files/scalc/gl/trigon.ods |binary
source/media/files/scalc/gu/functions_ifs.ods |binary
source/media/files/scalc/gu/imtrigon.ods |binary
source/media/files/scalc/gu/pivot.ods |binary
source/media/files/scalc/gu/trigon.ods |binary
source/media/files/scalc/he/functions_ifs.ods |binary
source/media/files/scalc/he/imtrigon.ods |binary
source/media/files/scalc/he/pivot.ods |binary
source/media/files/scalc/he/trigon.ods |binary
source/media/files/scalc/hi/functions_ifs.ods |binary
source/media/files/scalc/hi/imtrigon.ods |binary
source/media/files/scalc/hi/pivot.ods |binary
source/media/files/scalc/hi/trigon.ods |binary
source/media/files/scalc/hr/functions_ifs.ods |binary
source/media/files/scalc/hr/imtrigon.ods |binary
source/media/files/scalc/hr/pivot.ods |binary
source/media/files/scalc/hr/trigon.ods |binary
source/media/files/scalc/hu/functions_ifs.ods |binary
source/media/files/scalc/hu/imtrigon.ods |binary
source/media/files/scalc/hu/pivot.ods |binary
source/media/files/scalc/hu/trigon.ods |binary
source/media/files/scalc/id/functions_ifs.ods |binary
source/media/files/scalc/id/imtrigon.ods |binary
source/media/files/scalc/id/pivot.ods |binary
source/media/files/scalc/id/trigon.ods |binary
source/media/files/scalc/is/functions_ifs.ods |binary
source/media/files/scalc/is/imtrigon.ods |binary
source/media/files/scalc/is/pivot.ods |binary
source/media/files/scalc/is/trigon.ods |binary
source/media/files/scalc/it/functions_ifs.ods |binary
source/media/files/scalc/it/imtrigon.ods |binary
source/media/files/scalc/it/pivot.ods |binary
source/media/files/scalc/it/trigon.ods |binary
source/media/files/scalc/ja/functions_ifs.ods |binary
source/media/files/scalc/ja/imtrigon.ods |binary
source/media/files/scalc/ja/pivot.ods |binary
source/media/files/scalc/ja/trigon.ods |binary
source/media/files/scalc/ka/functions_ifs.ods |binary
source/media/files/scalc/ka/imtrigon.ods |binary
source/media/files/scalc/ka/pivot.ods |binary
source/media/files/scalc/ka/trigon.ods |binary
source/media/files/scalc/km/functions_ifs.ods |binary
source/media/files/scalc/km/imtrigon.ods |binary
source/media/files/scalc/km/pivot.ods |binary
source/media/files/scalc/km/trigon.ods |binary
source/media/files/scalc/ko/functions_ifs.ods |binary
source/media/files/scalc/ko/imtrigon.ods |binary
source/media/files/scalc/ko/pivot.ods |binary
source/media/files/scalc/ko/trigon.ods |binary
source/media/files/scalc/lo/functions_ifs.ods |binary
source/media/files/scalc/lo/imtrigon.ods |binary
source/media/files/scalc/lo/pivot.ods |binary
source/media/files/scalc/lo/trigon.ods |binary
source/media/files/scalc/lt/functions_ifs.ods |binary
source/media/files/scalc/lt/imtrigon.ods |binary
source/media/files/scalc/lt/pivot.ods |binary
source/media/files/scalc/lt/trigon.ods |binary
source/media/files/scalc/lv/functions_ifs.ods |binary
source/media/files/scalc/lv/imtrigon.ods |binary
source/media/files/scalc/lv/pivot.ods |binary
source/media/files/scalc/lv/trigon.ods |binary
source/media/files/scalc/mk/functions_ifs.ods |binary
source/media/files/scalc/mk/imtrigon.ods |binary
source/media/files/scalc/mk/pivot.ods |binary
source/media/files/scalc/mk/trigon.ods |binary
source/media/files/scalc/nb/functions_ifs.ods |binary
source/media/files/scalc/nb/imtrigon.ods |binary
source/media/files/scalc/nb/pivot.ods |binary
source/media/files/scalc/nb/trigon.ods |binary
source/media/files/scalc/ne/functions_ifs.ods |binary
source/media/files/scalc/ne/imtrigon.ods |binary
source/media/files/scalc/ne/pivot.ods |binary
source/media/files/scalc/ne/trigon.ods |binary
source/media/files/scalc/nl/functions_ifs.ods |binary
source/media/files/scalc/nl/imtrigon.ods |binary
source/media/files/scalc/nl/pivot.ods |binary
source/media/files/scalc/nl/trigon.ods |binary
source/media/files/scalc/nn/functions_ifs.ods |binary
source/media/files/scalc/nn/imtrigon.ods |binary
source/media/files/scalc/nn/pivot.ods |binary
source/media/files/scalc/nn/trigon.ods |binary
source/media/files/scalc/om/functions_ifs.ods |binary
source/media/files/scalc/om/imtrigon.ods |binary
source/media/files/scalc/om/pivot.ods |binary
source/media/files/scalc/om/trigon.ods |binary
source/media/files/scalc/pl/functions_ifs.ods |binary
source/media/files/scalc/pl/imtrigon.ods |binary
source/media/files/scalc/pl/pivot.ods |binary
source/media/files/scalc/pl/trigon.ods |binary
source/media/files/scalc/pt-BR/functions_ifs.ods |binary
source/media/files/scalc/pt-BR/imtrigon.ods |binary
source/media/files/scalc/pt-BR/pivot.ods |binary
source/media/files/scalc/pt-BR/trigon.ods |binary
source/media/files/scalc/pt/functions_ifs.ods |binary
source/media/files/scalc/pt/imtrigon.ods |binary
source/media/files/scalc/pt/pivot.ods |binary
source/media/files/scalc/pt/trigon.ods |binary
source/media/files/scalc/ro/functions_ifs.ods |binary
source/media/files/scalc/ro/imtrigon.ods |binary
source/media/files/scalc/ro/pivot.ods |binary
source/media/files/scalc/ro/trigon.ods |binary
source/media/files/scalc/ru/functions_ifs.ods |binary
source/media/files/scalc/ru/imtrigon.ods |binary
source/media/files/scalc/ru/pivot.ods |binary
source/media/files/scalc/ru/trigon.ods |binary
source/media/files/scalc/si/functions_ifs.ods |binary
source/media/files/scalc/si/imtrigon.ods |binary
source/media/files/scalc/si/pivot.ods |binary
source/media/files/scalc/si/trigon.ods |binary
source/media/files/scalc/sid/functions_ifs.ods |binary
source/media/files/scalc/sid/imtrigon.ods |binary
source/media/files/scalc/sid/pivot.ods |binary
source/media/files/scalc/sid/trigon.ods |binary
source/media/files/scalc/sk/functions_ifs.ods |binary
source/media/files/scalc/sk/imtrigon.ods |binary
source/media/files/scalc/sk/pivot.ods |binary
source/media/files/scalc/sk/trigon.ods |binary
source/media/files/scalc/sl/functions_ifs.ods |binary
source/media/files/scalc/sl/imtrigon.ods |binary
source/media/files/scalc/sl/pivot.ods |binary
source/media/files/scalc/sl/trigon.ods |binary
source/media/files/scalc/sq/functions_ifs.ods |binary
source/media/files/scalc/sq/imtrigon.ods |binary
source/media/files/scalc/sq/pivot.ods |binary
source/media/files/scalc/sq/trigon.ods |binary
source/media/files/scalc/sv/functions_ifs.ods |binary
source/media/files/scalc/sv/imtrigon.ods |binary
source/media/files/scalc/sv/pivot.ods |binary
source/media/files/scalc/sv/trigon.ods |binary
source/media/files/scalc/ta/functions_ifs.ods |binary
source/media/files/scalc/ta/imtrigon.ods |binary
source/media/files/scalc/ta/pivot.ods |binary
source/media/files/scalc/ta/trigon.ods |binary
source/media/files/scalc/tg/functions_ifs.ods |binary
source/media/files/scalc/tg/imtrigon.ods |binary
source/media/files/scalc/tg/pivot.ods |binary
source/media/files/scalc/tg/trigon.ods |binary
source/media/files/scalc/tr/functions_ifs.ods |binary
source/media/files/scalc/tr/imtrigon.ods |binary
source/media/files/scalc/tr/pivot.ods |binary
source/media/files/scalc/tr/trigon.ods |binary
source/media/files/scalc/ug/functions_ifs.ods |binary
source/media/files/scalc/ug/imtrigon.ods |binary
source/media/files/scalc/ug/pivot.ods |binary
source/media/files/scalc/ug/trigon.ods |binary
source/media/files/scalc/uk/functions_ifs.ods |binary
source/media/files/scalc/uk/imtrigon.ods |binary
source/media/files/scalc/uk/pivot.ods |binary
source/media/files/scalc/uk/trigon.ods |binary
source/media/files/scalc/vi/functions_ifs.ods |binary
source/media/files/scalc/vi/imtrigon.ods |binary
source/media/files/scalc/vi/pivot.ods |binary
source/media/files/scalc/vi/trigon.ods |binary
source/media/files/scalc/zh-CN/functions_ifs.ods |binary
source/media/files/scalc/zh-CN/imtrigon.ods |binary
source/media/files/scalc/zh-CN/pivot.ods |binary
source/media/files/scalc/zh-CN/trigon.ods |binary
source/media/files/scalc/zh-TW/functions_ifs.ods |binary
source/media/files/scalc/zh-TW/imtrigon.ods |binary
source/media/files/scalc/zh-TW/pivot.ods |binary
source/media/files/scalc/zh-TW/trigon.ods |binary
source/text/scalc/01/func_countifs.xhp | 8 ++------
source/text/scalc/06/calcsamplefiles.xhp | 3 +++
266 files changed, 23 insertions(+), 17 deletions(-)
New commits:
commit b574fd22322fd31db2da408729cdd1c402626524
Author: Olivier Hallot <olivier.hallot at libreoffice.org>
Date: Fri Jun 8 23:58:14 2018 -0300
tdf#116642 Fix COUNTIFS page + help makefiles
+ Add callateral file for COUNTIFS
+ Adjust makefiles
+ some tweaks in XSLT
+ adjust languages to gb_HELP_LANGS.
Change-Id: I9d2684d20804b93fd0671621d28a8d786a101fdf
Reviewed-on: https://gerrit.libreoffice.org/55493
Tested-by: Jenkins <ci at libreoffice.org>
Reviewed-by: Olivier Hallot <olivier.hallot at libreoffice.org>
(cherry picked from commit 185624ce2dfea227f0357e417bb3615e88c95e8e)
Reviewed-on: https://gerrit.libreoffice.org/55687
diff --git a/AllLangPackage_html_media_lang.mk b/AllLangPackage_html_media_lang.mk
index 7482ec997..caf4f7687 100644
--- a/AllLangPackage_html_media_lang.mk
+++ b/AllLangPackage_html_media_lang.mk
@@ -161,7 +161,6 @@ $(eval $(call gb_AllLangPackage_add_files_for_lang,helpcontent2_html_media_lang,
))
$(eval $(call gb_AllLangPackage_add_files_for_lang,helpcontent2_html_media_lang,pt-BR,$(LIBO_SHARE_HELP_FOLDER)$(if $(HELP_ONLINE),/$(PRODUCTVERSION))/media, \
- files/scalc/pt-BR/pivot.ods \
helpimg/pt-BR/feldalle.png \
helpimg/pt-BR/feldbrei.png \
helpimg/pt-BR/feldcolo.png \
@@ -234,9 +233,8 @@ $(eval $(call gb_AllLangPackage_add_files_for_lang,helpcontent2_html_media_lang,
helpimg/zh-TW/zellvor.png \
))
-#TODO: fy is filtered out for now, as $(SRCDIR)/helpcontent2/source/media/ doesn't contain the
-# corresponding screenshots yet:
-$(foreach lang,$(filter-out en-US fy,$(completelangiso)),$(eval $(call gb_AllLangPackage_add_files_for_lang,helpcontent2_html_media_lang,$(lang),$(LIBO_SHARE_HELP_FOLDER)$(if $(HELP_ONLINE),/$(PRODUCTVERSION))/media, \
+
+$(foreach lang,$(filter-out en-US,$(gb_HELP_LANGS)),$(eval $(call gb_AllLangPackage_add_files_for_lang,helpcontent2_html_media_lang,$(lang),$(LIBO_SHARE_HELP_FOLDER)$(if $(HELP_ONLINE),/$(PRODUCTVERSION))/media, \
screenshots/modules/smath/ui/alignmentdialog/$(lang)/AlignmentDialog.png \
screenshots/modules/smath/ui/catalogdialog/$(lang)/CatalogDialog.png \
screenshots/modules/smath/ui/fontdialog/$(lang)/FontDialog.png \
@@ -246,5 +244,12 @@ $(foreach lang,$(filter-out en-US fy,$(completelangiso)),$(eval $(call gb_AllLan
screenshots/modules/smath/ui/spacingdialog/$(lang)/SpacingDialog.png \
screenshots/modules/smath/ui/symdefinedialog/$(lang)/EditSymbols.png \
)))
-
+#TODO: Find a clever way to pick en-US files (default) when localized files are missing
+#
+$(foreach lang,$(filter-out en-US,$(gb_HELP_LANGS)),$(eval $(call gb_AllLangPackage_add_files_for_lang,helpcontent2_html_media_lang,$(lang),$(LIBO_SHARE_HELP_FOLDER)$(if $(HELP_ONLINE),/$(PRODUCTVERSION))/media, \
+ files/scalc/$(lang)/imtrigon.ods \
+ files/scalc/$(lang)/trigon.ods \
+ files/scalc/$(lang)/pivot.ods \
+ files/scalc/$(lang)/functions_ifs.ods \
+)))
# vim: set noet sw=4 ts=4:
diff --git a/Package_html_media.mk b/Package_html_media.mk
index 203dcac27..46635fd94 100644
--- a/Package_html_media.mk
+++ b/Package_html_media.mk
@@ -18,6 +18,7 @@ $(eval $(call gb_Package_add_files_with_dir,helpcontent2_html_media,$(LIBO_SHARE
files/scalc/imtrigon.ods \
files/scalc/pivot.ods \
files/scalc/trigon.ods \
+ files/scalc/functions_ifs.ods \
helpimg/area1.png \
helpimg/area2.png \
helpimg/border_ca_1.png \
diff --git a/help3xsl/online_transform.xsl b/help3xsl/online_transform.xsl
index d73413a3d..031476757 100644
--- a/help3xsl/online_transform.xsl
+++ b/help3xsl/online_transform.xsl
@@ -1105,6 +1105,7 @@
<xsl:variable name="height">
<xsl:call-template name="convert2px"><xsl:with-param name="value" select="@height"/></xsl:call-template>
</xsl:variable>
+ <xsl:variable name="auxID" select="concat('obj',generate-id())"/>
<xsl:choose>
<xsl:when test="starts-with(@type,'video/youtube')">
<div id="mediadiv">
@@ -1127,7 +1128,7 @@
<xsl:with-param name="string" select="@data"/>
</xsl:call-template>
</xsl:variable>
- <div class="samplefilesection">
+ <div class="samplefilesection" id="{$auxID}">
<h3><xsl:apply-templates select="$tmp_doc//variable[@id='samplefile']"/></h3>
<a class="objectfiles" href="{concat($target,$src)}"><img src="{concat($target,'media/navigation/libo-calc.svg')}" width="25px" height="30px"></img></a>
</div>
@@ -1138,7 +1139,7 @@
<xsl:with-param name="string" select="@data"/>
</xsl:call-template>
</xsl:variable>
- <div class="samplefilesection">
+ <div class="samplefilesection" id="{$auxID}">
<h3><xsl:apply-templates select="$tmp_doc//variable[@id='samplefile']"/></h3>
<a class="objectfiles" href="{concat($target,$src)}"><img src="{concat($target,'media/navigation/libo-writer.svg')}" width="25px" height="30px"></img></a>
</div>
@@ -1149,7 +1150,7 @@
<xsl:with-param name="string" select="@data"/>
</xsl:call-template>
</xsl:variable>
- <div class="samplefilesection">
+ <div class="samplefilesection" id="{$auxID}">
<h3><xsl:apply-templates select="$tmp_doc//variable[@id='samplefile']"/></h3>
<a class="objectfiles" href="{concat($target,$src)}"><img src="{concat($target,'media/navigation/libo-impress.svg')}" width="25px" height="30px"></img></a>
</div>
@@ -1160,7 +1161,7 @@
<xsl:with-param name="string" select="@data"/>
</xsl:call-template>
</xsl:variable>
- <div class="samplefilesection">
+ <div class="samplefilesection" id="{$auxID}">
<h3><xsl:apply-templates select="$tmp_doc//variable[@id='samplefile']"/></h3>
<a class="objectfiles" href="{concat($target,$src)}"><img src="{concat($target,'media/navigation/libo-draw.svg')}" width="25px" height="30px"></img></a>
</div>
@@ -1171,7 +1172,7 @@
<xsl:with-param name="string" select="@data"/>
</xsl:call-template>
</xsl:variable>
- <div class="samplefilesection">
+ <div class="samplefilesection" id="{$auxID}">
<h3><xsl:apply-templates select="$tmp_doc//variable[@id='samplefile']"/></h3>
<a class="objectfiles" href="{concat($target,$src)}"><img src="{concat($target,'media/navigation/libo-math.svg')}" width="25px" height="30px"></img></a>
</div>
@@ -1182,7 +1183,7 @@
<xsl:with-param name="string" select="@data"/>
</xsl:call-template>
</xsl:variable>
- <div class="samplefilesection">
+ <div class="samplefilesection" id="{$auxID}">
<h3><xsl:apply-templates select="$tmp_doc//variable[@id='samplefile']"/></h3>
<a class="objectfiles" href="{concat($target,$src)}"><img src="{concat($target,'media/navigation/libo-base.svg')}" width="25px" height="30px"></img></a>
</div>
diff --git a/source/media/files/scalc/am/functions_ifs.ods b/source/media/files/scalc/am/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/am/functions_ifs.ods differ
diff --git a/source/media/files/scalc/am/imtrigon.ods b/source/media/files/scalc/am/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/am/imtrigon.ods differ
diff --git a/source/media/files/scalc/am/pivot.ods b/source/media/files/scalc/am/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/am/pivot.ods differ
diff --git a/source/media/files/scalc/am/trigon.ods b/source/media/files/scalc/am/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/am/trigon.ods differ
diff --git a/source/media/files/scalc/ar/functions_ifs.ods b/source/media/files/scalc/ar/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/ar/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ar/imtrigon.ods b/source/media/files/scalc/ar/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/ar/imtrigon.ods differ
diff --git a/source/media/files/scalc/ar/pivot.ods b/source/media/files/scalc/ar/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/ar/pivot.ods differ
diff --git a/source/media/files/scalc/ar/trigon.ods b/source/media/files/scalc/ar/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/ar/trigon.ods differ
diff --git a/source/media/files/scalc/ast/functions_ifs.ods b/source/media/files/scalc/ast/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/ast/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ast/imtrigon.ods b/source/media/files/scalc/ast/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/ast/imtrigon.ods differ
diff --git a/source/media/files/scalc/ast/pivot.ods b/source/media/files/scalc/ast/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/ast/pivot.ods differ
diff --git a/source/media/files/scalc/ast/trigon.ods b/source/media/files/scalc/ast/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/ast/trigon.ods differ
diff --git a/source/media/files/scalc/bg/functions_ifs.ods b/source/media/files/scalc/bg/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/bg/functions_ifs.ods differ
diff --git a/source/media/files/scalc/bg/imtrigon.ods b/source/media/files/scalc/bg/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/bg/imtrigon.ods differ
diff --git a/source/media/files/scalc/bg/pivot.ods b/source/media/files/scalc/bg/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/bg/pivot.ods differ
diff --git a/source/media/files/scalc/bg/trigon.ods b/source/media/files/scalc/bg/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/bg/trigon.ods differ
diff --git a/source/media/files/scalc/bn-IN/functions_ifs.ods b/source/media/files/scalc/bn-IN/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/bn-IN/functions_ifs.ods differ
diff --git a/source/media/files/scalc/bn-IN/imtrigon.ods b/source/media/files/scalc/bn-IN/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/bn-IN/imtrigon.ods differ
diff --git a/source/media/files/scalc/bn-IN/pivot.ods b/source/media/files/scalc/bn-IN/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/bn-IN/pivot.ods differ
diff --git a/source/media/files/scalc/bn-IN/trigon.ods b/source/media/files/scalc/bn-IN/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/bn-IN/trigon.ods differ
diff --git a/source/media/files/scalc/bn/functions_ifs.ods b/source/media/files/scalc/bn/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/bn/functions_ifs.ods differ
diff --git a/source/media/files/scalc/bn/imtrigon.ods b/source/media/files/scalc/bn/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/bn/imtrigon.ods differ
diff --git a/source/media/files/scalc/bn/pivot.ods b/source/media/files/scalc/bn/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/bn/pivot.ods differ
diff --git a/source/media/files/scalc/bn/trigon.ods b/source/media/files/scalc/bn/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/bn/trigon.ods differ
diff --git a/source/media/files/scalc/bo/functions_ifs.ods b/source/media/files/scalc/bo/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/bo/functions_ifs.ods differ
diff --git a/source/media/files/scalc/bo/imtrigon.ods b/source/media/files/scalc/bo/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/bo/imtrigon.ods differ
diff --git a/source/media/files/scalc/bo/pivot.ods b/source/media/files/scalc/bo/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/bo/pivot.ods differ
diff --git a/source/media/files/scalc/bo/trigon.ods b/source/media/files/scalc/bo/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/bo/trigon.ods differ
diff --git a/source/media/files/scalc/bs/functions_ifs.ods b/source/media/files/scalc/bs/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/bs/functions_ifs.ods differ
diff --git a/source/media/files/scalc/bs/imtrigon.ods b/source/media/files/scalc/bs/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/bs/imtrigon.ods differ
diff --git a/source/media/files/scalc/bs/pivot.ods b/source/media/files/scalc/bs/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/bs/pivot.ods differ
diff --git a/source/media/files/scalc/bs/trigon.ods b/source/media/files/scalc/bs/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/bs/trigon.ods differ
diff --git a/source/media/files/scalc/ca-valencia/functions_ifs.ods b/source/media/files/scalc/ca-valencia/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/ca-valencia/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ca-valencia/imtrigon.ods b/source/media/files/scalc/ca-valencia/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/ca-valencia/imtrigon.ods differ
diff --git a/source/media/files/scalc/ca-valencia/pivot.ods b/source/media/files/scalc/ca-valencia/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/ca-valencia/pivot.ods differ
diff --git a/source/media/files/scalc/ca-valencia/trigon.ods b/source/media/files/scalc/ca-valencia/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/ca-valencia/trigon.ods differ
diff --git a/source/media/files/scalc/ca/functions_ifs.ods b/source/media/files/scalc/ca/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/ca/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ca/imtrigon.ods b/source/media/files/scalc/ca/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/ca/imtrigon.ods differ
diff --git a/source/media/files/scalc/ca/pivot.ods b/source/media/files/scalc/ca/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/ca/pivot.ods differ
diff --git a/source/media/files/scalc/ca/trigon.ods b/source/media/files/scalc/ca/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/ca/trigon.ods differ
diff --git a/source/media/files/scalc/cs/functions_ifs.ods b/source/media/files/scalc/cs/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/cs/functions_ifs.ods differ
diff --git a/source/media/files/scalc/cs/imtrigon.ods b/source/media/files/scalc/cs/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/cs/imtrigon.ods differ
diff --git a/source/media/files/scalc/cs/pivot.ods b/source/media/files/scalc/cs/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/cs/pivot.ods differ
diff --git a/source/media/files/scalc/cs/trigon.ods b/source/media/files/scalc/cs/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/cs/trigon.ods differ
diff --git a/source/media/files/scalc/da/functions_ifs.ods b/source/media/files/scalc/da/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/da/functions_ifs.ods differ
diff --git a/source/media/files/scalc/da/imtrigon.ods b/source/media/files/scalc/da/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/da/imtrigon.ods differ
diff --git a/source/media/files/scalc/da/pivot.ods b/source/media/files/scalc/da/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/da/pivot.ods differ
diff --git a/source/media/files/scalc/da/trigon.ods b/source/media/files/scalc/da/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/da/trigon.ods differ
diff --git a/source/media/files/scalc/de/functions_ifs.ods b/source/media/files/scalc/de/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/de/functions_ifs.ods differ
diff --git a/source/media/files/scalc/de/imtrigon.ods b/source/media/files/scalc/de/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/de/imtrigon.ods differ
diff --git a/source/media/files/scalc/de/pivot.ods b/source/media/files/scalc/de/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/de/pivot.ods differ
diff --git a/source/media/files/scalc/de/trigon.ods b/source/media/files/scalc/de/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/de/trigon.ods differ
diff --git a/source/media/files/scalc/dz/functions_ifs.ods b/source/media/files/scalc/dz/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/dz/functions_ifs.ods differ
diff --git a/source/media/files/scalc/dz/imtrigon.ods b/source/media/files/scalc/dz/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/dz/imtrigon.ods differ
diff --git a/source/media/files/scalc/dz/pivot.ods b/source/media/files/scalc/dz/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/dz/pivot.ods differ
diff --git a/source/media/files/scalc/dz/trigon.ods b/source/media/files/scalc/dz/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/dz/trigon.ods differ
diff --git a/source/media/files/scalc/el/functions_ifs.ods b/source/media/files/scalc/el/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/el/functions_ifs.ods differ
diff --git a/source/media/files/scalc/el/imtrigon.ods b/source/media/files/scalc/el/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/el/imtrigon.ods differ
diff --git a/source/media/files/scalc/el/pivot.ods b/source/media/files/scalc/el/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/el/pivot.ods differ
diff --git a/source/media/files/scalc/el/trigon.ods b/source/media/files/scalc/el/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/el/trigon.ods differ
diff --git a/source/media/files/scalc/en-GB/functions_ifs.ods b/source/media/files/scalc/en-GB/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/en-GB/functions_ifs.ods differ
diff --git a/source/media/files/scalc/en-GB/imtrigon.ods b/source/media/files/scalc/en-GB/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/en-GB/imtrigon.ods differ
diff --git a/source/media/files/scalc/en-GB/pivot.ods b/source/media/files/scalc/en-GB/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/en-GB/pivot.ods differ
diff --git a/source/media/files/scalc/en-GB/trigon.ods b/source/media/files/scalc/en-GB/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/en-GB/trigon.ods differ
diff --git a/source/media/files/scalc/en-US/functions_ifs.ods b/source/media/files/scalc/en-US/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/en-US/functions_ifs.ods differ
diff --git a/source/media/files/scalc/en-US/imtrigon.ods b/source/media/files/scalc/en-US/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/en-US/imtrigon.ods differ
diff --git a/source/media/files/scalc/en-US/pivot.ods b/source/media/files/scalc/en-US/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/en-US/pivot.ods differ
diff --git a/source/media/files/scalc/en-US/trigon.ods b/source/media/files/scalc/en-US/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/en-US/trigon.ods differ
diff --git a/source/media/files/scalc/en-ZA/functions_ifs.ods b/source/media/files/scalc/en-ZA/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/en-ZA/functions_ifs.ods differ
diff --git a/source/media/files/scalc/en-ZA/imtrigon.ods b/source/media/files/scalc/en-ZA/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/en-ZA/imtrigon.ods differ
diff --git a/source/media/files/scalc/en-ZA/pivot.ods b/source/media/files/scalc/en-ZA/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/en-ZA/pivot.ods differ
diff --git a/source/media/files/scalc/en-ZA/trigon.ods b/source/media/files/scalc/en-ZA/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/en-ZA/trigon.ods differ
diff --git a/source/media/files/scalc/eo/functions_ifs.ods b/source/media/files/scalc/eo/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/eo/functions_ifs.ods differ
diff --git a/source/media/files/scalc/eo/imtrigon.ods b/source/media/files/scalc/eo/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/eo/imtrigon.ods differ
diff --git a/source/media/files/scalc/eo/pivot.ods b/source/media/files/scalc/eo/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/eo/pivot.ods differ
diff --git a/source/media/files/scalc/eo/trigon.ods b/source/media/files/scalc/eo/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/eo/trigon.ods differ
diff --git a/source/media/files/scalc/es/functions_ifs.ods b/source/media/files/scalc/es/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/es/functions_ifs.ods differ
diff --git a/source/media/files/scalc/es/imtrigon.ods b/source/media/files/scalc/es/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/es/imtrigon.ods differ
diff --git a/source/media/files/scalc/es/pivot.ods b/source/media/files/scalc/es/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/es/pivot.ods differ
diff --git a/source/media/files/scalc/es/trigon.ods b/source/media/files/scalc/es/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/es/trigon.ods differ
diff --git a/source/media/files/scalc/et/functions_ifs.ods b/source/media/files/scalc/et/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/et/functions_ifs.ods differ
diff --git a/source/media/files/scalc/et/imtrigon.ods b/source/media/files/scalc/et/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/et/imtrigon.ods differ
diff --git a/source/media/files/scalc/et/pivot.ods b/source/media/files/scalc/et/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/et/pivot.ods differ
diff --git a/source/media/files/scalc/et/trigon.ods b/source/media/files/scalc/et/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/et/trigon.ods differ
diff --git a/source/media/files/scalc/eu/functions_ifs.ods b/source/media/files/scalc/eu/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/eu/functions_ifs.ods differ
diff --git a/source/media/files/scalc/eu/imtrigon.ods b/source/media/files/scalc/eu/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/eu/imtrigon.ods differ
diff --git a/source/media/files/scalc/eu/pivot.ods b/source/media/files/scalc/eu/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/eu/pivot.ods differ
diff --git a/source/media/files/scalc/eu/trigon.ods b/source/media/files/scalc/eu/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/eu/trigon.ods differ
diff --git a/source/media/files/scalc/fi/functions_ifs.ods b/source/media/files/scalc/fi/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/fi/functions_ifs.ods differ
diff --git a/source/media/files/scalc/fi/imtrigon.ods b/source/media/files/scalc/fi/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/fi/imtrigon.ods differ
diff --git a/source/media/files/scalc/fi/pivot.ods b/source/media/files/scalc/fi/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/fi/pivot.ods differ
diff --git a/source/media/files/scalc/fi/trigon.ods b/source/media/files/scalc/fi/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/fi/trigon.ods differ
diff --git a/source/media/files/scalc/fr/functions_ifs.ods b/source/media/files/scalc/fr/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/fr/functions_ifs.ods differ
diff --git a/source/media/files/scalc/fr/imtrigon.ods b/source/media/files/scalc/fr/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/fr/imtrigon.ods differ
diff --git a/source/media/files/scalc/fr/pivot.ods b/source/media/files/scalc/fr/pivot.ods
index 0b8284651..1311d93ca 100644
Binary files a/source/media/files/scalc/fr/pivot.ods and b/source/media/files/scalc/fr/pivot.ods differ
diff --git a/source/media/files/scalc/fr/trigon.ods b/source/media/files/scalc/fr/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/fr/trigon.ods differ
diff --git a/source/media/files/scalc/functions_ifs.ods b/source/media/files/scalc/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/functions_ifs.ods differ
diff --git a/source/media/files/scalc/gl/functions_ifs.ods b/source/media/files/scalc/gl/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/gl/functions_ifs.ods differ
diff --git a/source/media/files/scalc/gl/imtrigon.ods b/source/media/files/scalc/gl/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/gl/imtrigon.ods differ
diff --git a/source/media/files/scalc/gl/pivot.ods b/source/media/files/scalc/gl/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/gl/pivot.ods differ
diff --git a/source/media/files/scalc/gl/trigon.ods b/source/media/files/scalc/gl/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/gl/trigon.ods differ
diff --git a/source/media/files/scalc/gu/functions_ifs.ods b/source/media/files/scalc/gu/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/gu/functions_ifs.ods differ
diff --git a/source/media/files/scalc/gu/imtrigon.ods b/source/media/files/scalc/gu/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/gu/imtrigon.ods differ
diff --git a/source/media/files/scalc/gu/pivot.ods b/source/media/files/scalc/gu/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/gu/pivot.ods differ
diff --git a/source/media/files/scalc/gu/trigon.ods b/source/media/files/scalc/gu/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/gu/trigon.ods differ
diff --git a/source/media/files/scalc/he/functions_ifs.ods b/source/media/files/scalc/he/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/he/functions_ifs.ods differ
diff --git a/source/media/files/scalc/he/imtrigon.ods b/source/media/files/scalc/he/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/he/imtrigon.ods differ
diff --git a/source/media/files/scalc/he/pivot.ods b/source/media/files/scalc/he/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/he/pivot.ods differ
diff --git a/source/media/files/scalc/he/trigon.ods b/source/media/files/scalc/he/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/he/trigon.ods differ
diff --git a/source/media/files/scalc/hi/functions_ifs.ods b/source/media/files/scalc/hi/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/hi/functions_ifs.ods differ
diff --git a/source/media/files/scalc/hi/imtrigon.ods b/source/media/files/scalc/hi/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/hi/imtrigon.ods differ
diff --git a/source/media/files/scalc/hi/pivot.ods b/source/media/files/scalc/hi/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/hi/pivot.ods differ
diff --git a/source/media/files/scalc/hi/trigon.ods b/source/media/files/scalc/hi/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/hi/trigon.ods differ
diff --git a/source/media/files/scalc/hr/functions_ifs.ods b/source/media/files/scalc/hr/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/hr/functions_ifs.ods differ
diff --git a/source/media/files/scalc/hr/imtrigon.ods b/source/media/files/scalc/hr/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/hr/imtrigon.ods differ
diff --git a/source/media/files/scalc/hr/pivot.ods b/source/media/files/scalc/hr/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/hr/pivot.ods differ
diff --git a/source/media/files/scalc/hr/trigon.ods b/source/media/files/scalc/hr/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/hr/trigon.ods differ
diff --git a/source/media/files/scalc/hu/functions_ifs.ods b/source/media/files/scalc/hu/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/hu/functions_ifs.ods differ
diff --git a/source/media/files/scalc/hu/imtrigon.ods b/source/media/files/scalc/hu/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/hu/imtrigon.ods differ
diff --git a/source/media/files/scalc/hu/pivot.ods b/source/media/files/scalc/hu/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/hu/pivot.ods differ
diff --git a/source/media/files/scalc/hu/trigon.ods b/source/media/files/scalc/hu/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/hu/trigon.ods differ
diff --git a/source/media/files/scalc/id/functions_ifs.ods b/source/media/files/scalc/id/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/id/functions_ifs.ods differ
diff --git a/source/media/files/scalc/id/imtrigon.ods b/source/media/files/scalc/id/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/id/imtrigon.ods differ
diff --git a/source/media/files/scalc/id/pivot.ods b/source/media/files/scalc/id/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/id/pivot.ods differ
diff --git a/source/media/files/scalc/id/trigon.ods b/source/media/files/scalc/id/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/id/trigon.ods differ
diff --git a/source/media/files/scalc/is/functions_ifs.ods b/source/media/files/scalc/is/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/is/functions_ifs.ods differ
diff --git a/source/media/files/scalc/is/imtrigon.ods b/source/media/files/scalc/is/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/is/imtrigon.ods differ
diff --git a/source/media/files/scalc/is/pivot.ods b/source/media/files/scalc/is/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/is/pivot.ods differ
diff --git a/source/media/files/scalc/is/trigon.ods b/source/media/files/scalc/is/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/is/trigon.ods differ
diff --git a/source/media/files/scalc/it/functions_ifs.ods b/source/media/files/scalc/it/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/it/functions_ifs.ods differ
diff --git a/source/media/files/scalc/it/imtrigon.ods b/source/media/files/scalc/it/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/it/imtrigon.ods differ
diff --git a/source/media/files/scalc/it/pivot.ods b/source/media/files/scalc/it/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/it/pivot.ods differ
diff --git a/source/media/files/scalc/it/trigon.ods b/source/media/files/scalc/it/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/it/trigon.ods differ
diff --git a/source/media/files/scalc/ja/functions_ifs.ods b/source/media/files/scalc/ja/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/ja/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ja/imtrigon.ods b/source/media/files/scalc/ja/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/ja/imtrigon.ods differ
diff --git a/source/media/files/scalc/ja/pivot.ods b/source/media/files/scalc/ja/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/ja/pivot.ods differ
diff --git a/source/media/files/scalc/ja/trigon.ods b/source/media/files/scalc/ja/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/ja/trigon.ods differ
diff --git a/source/media/files/scalc/ka/functions_ifs.ods b/source/media/files/scalc/ka/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/ka/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ka/imtrigon.ods b/source/media/files/scalc/ka/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/ka/imtrigon.ods differ
diff --git a/source/media/files/scalc/ka/pivot.ods b/source/media/files/scalc/ka/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/ka/pivot.ods differ
diff --git a/source/media/files/scalc/ka/trigon.ods b/source/media/files/scalc/ka/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/ka/trigon.ods differ
diff --git a/source/media/files/scalc/km/functions_ifs.ods b/source/media/files/scalc/km/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/km/functions_ifs.ods differ
diff --git a/source/media/files/scalc/km/imtrigon.ods b/source/media/files/scalc/km/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/km/imtrigon.ods differ
diff --git a/source/media/files/scalc/km/pivot.ods b/source/media/files/scalc/km/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/km/pivot.ods differ
diff --git a/source/media/files/scalc/km/trigon.ods b/source/media/files/scalc/km/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/km/trigon.ods differ
diff --git a/source/media/files/scalc/ko/functions_ifs.ods b/source/media/files/scalc/ko/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/ko/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ko/imtrigon.ods b/source/media/files/scalc/ko/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/ko/imtrigon.ods differ
diff --git a/source/media/files/scalc/ko/pivot.ods b/source/media/files/scalc/ko/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/ko/pivot.ods differ
diff --git a/source/media/files/scalc/ko/trigon.ods b/source/media/files/scalc/ko/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/ko/trigon.ods differ
diff --git a/source/media/files/scalc/lo/functions_ifs.ods b/source/media/files/scalc/lo/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/lo/functions_ifs.ods differ
diff --git a/source/media/files/scalc/lo/imtrigon.ods b/source/media/files/scalc/lo/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/lo/imtrigon.ods differ
diff --git a/source/media/files/scalc/lo/pivot.ods b/source/media/files/scalc/lo/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/lo/pivot.ods differ
diff --git a/source/media/files/scalc/lo/trigon.ods b/source/media/files/scalc/lo/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/lo/trigon.ods differ
diff --git a/source/media/files/scalc/lt/functions_ifs.ods b/source/media/files/scalc/lt/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/lt/functions_ifs.ods differ
diff --git a/source/media/files/scalc/lt/imtrigon.ods b/source/media/files/scalc/lt/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/lt/imtrigon.ods differ
diff --git a/source/media/files/scalc/lt/pivot.ods b/source/media/files/scalc/lt/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/lt/pivot.ods differ
diff --git a/source/media/files/scalc/lt/trigon.ods b/source/media/files/scalc/lt/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/lt/trigon.ods differ
diff --git a/source/media/files/scalc/lv/functions_ifs.ods b/source/media/files/scalc/lv/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/lv/functions_ifs.ods differ
diff --git a/source/media/files/scalc/lv/imtrigon.ods b/source/media/files/scalc/lv/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/lv/imtrigon.ods differ
diff --git a/source/media/files/scalc/lv/pivot.ods b/source/media/files/scalc/lv/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/lv/pivot.ods differ
diff --git a/source/media/files/scalc/lv/trigon.ods b/source/media/files/scalc/lv/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/lv/trigon.ods differ
diff --git a/source/media/files/scalc/mk/functions_ifs.ods b/source/media/files/scalc/mk/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/mk/functions_ifs.ods differ
diff --git a/source/media/files/scalc/mk/imtrigon.ods b/source/media/files/scalc/mk/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/mk/imtrigon.ods differ
diff --git a/source/media/files/scalc/mk/pivot.ods b/source/media/files/scalc/mk/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/mk/pivot.ods differ
diff --git a/source/media/files/scalc/mk/trigon.ods b/source/media/files/scalc/mk/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/mk/trigon.ods differ
diff --git a/source/media/files/scalc/nb/functions_ifs.ods b/source/media/files/scalc/nb/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/nb/functions_ifs.ods differ
diff --git a/source/media/files/scalc/nb/imtrigon.ods b/source/media/files/scalc/nb/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/nb/imtrigon.ods differ
diff --git a/source/media/files/scalc/nb/pivot.ods b/source/media/files/scalc/nb/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/nb/pivot.ods differ
diff --git a/source/media/files/scalc/nb/trigon.ods b/source/media/files/scalc/nb/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/nb/trigon.ods differ
diff --git a/source/media/files/scalc/ne/functions_ifs.ods b/source/media/files/scalc/ne/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/ne/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ne/imtrigon.ods b/source/media/files/scalc/ne/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/ne/imtrigon.ods differ
diff --git a/source/media/files/scalc/ne/pivot.ods b/source/media/files/scalc/ne/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/ne/pivot.ods differ
diff --git a/source/media/files/scalc/ne/trigon.ods b/source/media/files/scalc/ne/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/ne/trigon.ods differ
diff --git a/source/media/files/scalc/nl/functions_ifs.ods b/source/media/files/scalc/nl/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/nl/functions_ifs.ods differ
diff --git a/source/media/files/scalc/nl/imtrigon.ods b/source/media/files/scalc/nl/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/nl/imtrigon.ods differ
diff --git a/source/media/files/scalc/nl/pivot.ods b/source/media/files/scalc/nl/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/nl/pivot.ods differ
diff --git a/source/media/files/scalc/nl/trigon.ods b/source/media/files/scalc/nl/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/nl/trigon.ods differ
diff --git a/source/media/files/scalc/nn/functions_ifs.ods b/source/media/files/scalc/nn/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/nn/functions_ifs.ods differ
diff --git a/source/media/files/scalc/nn/imtrigon.ods b/source/media/files/scalc/nn/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/nn/imtrigon.ods differ
diff --git a/source/media/files/scalc/nn/pivot.ods b/source/media/files/scalc/nn/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/nn/pivot.ods differ
diff --git a/source/media/files/scalc/nn/trigon.ods b/source/media/files/scalc/nn/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/nn/trigon.ods differ
diff --git a/source/media/files/scalc/om/functions_ifs.ods b/source/media/files/scalc/om/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/om/functions_ifs.ods differ
diff --git a/source/media/files/scalc/om/imtrigon.ods b/source/media/files/scalc/om/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/om/imtrigon.ods differ
diff --git a/source/media/files/scalc/om/pivot.ods b/source/media/files/scalc/om/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/om/pivot.ods differ
diff --git a/source/media/files/scalc/om/trigon.ods b/source/media/files/scalc/om/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/om/trigon.ods differ
diff --git a/source/media/files/scalc/pl/functions_ifs.ods b/source/media/files/scalc/pl/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/pl/functions_ifs.ods differ
diff --git a/source/media/files/scalc/pl/imtrigon.ods b/source/media/files/scalc/pl/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/pl/imtrigon.ods differ
diff --git a/source/media/files/scalc/pl/pivot.ods b/source/media/files/scalc/pl/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/pl/pivot.ods differ
diff --git a/source/media/files/scalc/pl/trigon.ods b/source/media/files/scalc/pl/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/pl/trigon.ods differ
diff --git a/source/media/files/scalc/pt-BR/functions_ifs.ods b/source/media/files/scalc/pt-BR/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/pt-BR/functions_ifs.ods differ
diff --git a/source/media/files/scalc/pt-BR/imtrigon.ods b/source/media/files/scalc/pt-BR/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/pt-BR/imtrigon.ods differ
diff --git a/source/media/files/scalc/pt-BR/pivot.ods b/source/media/files/scalc/pt-BR/pivot.ods
index 991dcb7ad..936051726 100644
Binary files a/source/media/files/scalc/pt-BR/pivot.ods and b/source/media/files/scalc/pt-BR/pivot.ods differ
diff --git a/source/media/files/scalc/pt-BR/trigon.ods b/source/media/files/scalc/pt-BR/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/pt-BR/trigon.ods differ
diff --git a/source/media/files/scalc/pt/functions_ifs.ods b/source/media/files/scalc/pt/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/pt/functions_ifs.ods differ
diff --git a/source/media/files/scalc/pt/imtrigon.ods b/source/media/files/scalc/pt/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/pt/imtrigon.ods differ
diff --git a/source/media/files/scalc/pt/pivot.ods b/source/media/files/scalc/pt/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/pt/pivot.ods differ
diff --git a/source/media/files/scalc/pt/trigon.ods b/source/media/files/scalc/pt/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/pt/trigon.ods differ
diff --git a/source/media/files/scalc/ro/functions_ifs.ods b/source/media/files/scalc/ro/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/ro/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ro/imtrigon.ods b/source/media/files/scalc/ro/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/ro/imtrigon.ods differ
diff --git a/source/media/files/scalc/ro/pivot.ods b/source/media/files/scalc/ro/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/ro/pivot.ods differ
diff --git a/source/media/files/scalc/ro/trigon.ods b/source/media/files/scalc/ro/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/ro/trigon.ods differ
diff --git a/source/media/files/scalc/ru/functions_ifs.ods b/source/media/files/scalc/ru/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/ru/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ru/imtrigon.ods b/source/media/files/scalc/ru/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/ru/imtrigon.ods differ
diff --git a/source/media/files/scalc/ru/pivot.ods b/source/media/files/scalc/ru/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/ru/pivot.ods differ
diff --git a/source/media/files/scalc/ru/trigon.ods b/source/media/files/scalc/ru/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/ru/trigon.ods differ
diff --git a/source/media/files/scalc/si/functions_ifs.ods b/source/media/files/scalc/si/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/si/functions_ifs.ods differ
diff --git a/source/media/files/scalc/si/imtrigon.ods b/source/media/files/scalc/si/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/si/imtrigon.ods differ
diff --git a/source/media/files/scalc/si/pivot.ods b/source/media/files/scalc/si/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/si/pivot.ods differ
diff --git a/source/media/files/scalc/si/trigon.ods b/source/media/files/scalc/si/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/si/trigon.ods differ
diff --git a/source/media/files/scalc/sid/functions_ifs.ods b/source/media/files/scalc/sid/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/sid/functions_ifs.ods differ
diff --git a/source/media/files/scalc/sid/imtrigon.ods b/source/media/files/scalc/sid/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/sid/imtrigon.ods differ
diff --git a/source/media/files/scalc/sid/pivot.ods b/source/media/files/scalc/sid/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/sid/pivot.ods differ
diff --git a/source/media/files/scalc/sid/trigon.ods b/source/media/files/scalc/sid/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/sid/trigon.ods differ
diff --git a/source/media/files/scalc/sk/functions_ifs.ods b/source/media/files/scalc/sk/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/sk/functions_ifs.ods differ
diff --git a/source/media/files/scalc/sk/imtrigon.ods b/source/media/files/scalc/sk/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/sk/imtrigon.ods differ
diff --git a/source/media/files/scalc/sk/pivot.ods b/source/media/files/scalc/sk/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/sk/pivot.ods differ
diff --git a/source/media/files/scalc/sk/trigon.ods b/source/media/files/scalc/sk/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/sk/trigon.ods differ
diff --git a/source/media/files/scalc/sl/functions_ifs.ods b/source/media/files/scalc/sl/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/sl/functions_ifs.ods differ
diff --git a/source/media/files/scalc/sl/imtrigon.ods b/source/media/files/scalc/sl/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/sl/imtrigon.ods differ
diff --git a/source/media/files/scalc/sl/pivot.ods b/source/media/files/scalc/sl/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/sl/pivot.ods differ
diff --git a/source/media/files/scalc/sl/trigon.ods b/source/media/files/scalc/sl/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/sl/trigon.ods differ
diff --git a/source/media/files/scalc/sq/functions_ifs.ods b/source/media/files/scalc/sq/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/sq/functions_ifs.ods differ
diff --git a/source/media/files/scalc/sq/imtrigon.ods b/source/media/files/scalc/sq/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/sq/imtrigon.ods differ
diff --git a/source/media/files/scalc/sq/pivot.ods b/source/media/files/scalc/sq/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/sq/pivot.ods differ
diff --git a/source/media/files/scalc/sq/trigon.ods b/source/media/files/scalc/sq/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/sq/trigon.ods differ
diff --git a/source/media/files/scalc/sv/functions_ifs.ods b/source/media/files/scalc/sv/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/sv/functions_ifs.ods differ
diff --git a/source/media/files/scalc/sv/imtrigon.ods b/source/media/files/scalc/sv/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/sv/imtrigon.ods differ
diff --git a/source/media/files/scalc/sv/pivot.ods b/source/media/files/scalc/sv/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/sv/pivot.ods differ
diff --git a/source/media/files/scalc/sv/trigon.ods b/source/media/files/scalc/sv/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/sv/trigon.ods differ
diff --git a/source/media/files/scalc/ta/functions_ifs.ods b/source/media/files/scalc/ta/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/ta/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ta/imtrigon.ods b/source/media/files/scalc/ta/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/ta/imtrigon.ods differ
diff --git a/source/media/files/scalc/ta/pivot.ods b/source/media/files/scalc/ta/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/ta/pivot.ods differ
diff --git a/source/media/files/scalc/ta/trigon.ods b/source/media/files/scalc/ta/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/ta/trigon.ods differ
diff --git a/source/media/files/scalc/tg/functions_ifs.ods b/source/media/files/scalc/tg/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/tg/functions_ifs.ods differ
diff --git a/source/media/files/scalc/tg/imtrigon.ods b/source/media/files/scalc/tg/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/tg/imtrigon.ods differ
diff --git a/source/media/files/scalc/tg/pivot.ods b/source/media/files/scalc/tg/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/tg/pivot.ods differ
diff --git a/source/media/files/scalc/tg/trigon.ods b/source/media/files/scalc/tg/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/tg/trigon.ods differ
diff --git a/source/media/files/scalc/tr/functions_ifs.ods b/source/media/files/scalc/tr/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/tr/functions_ifs.ods differ
diff --git a/source/media/files/scalc/tr/imtrigon.ods b/source/media/files/scalc/tr/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/tr/imtrigon.ods differ
diff --git a/source/media/files/scalc/tr/pivot.ods b/source/media/files/scalc/tr/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/tr/pivot.ods differ
diff --git a/source/media/files/scalc/tr/trigon.ods b/source/media/files/scalc/tr/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/tr/trigon.ods differ
diff --git a/source/media/files/scalc/ug/functions_ifs.ods b/source/media/files/scalc/ug/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/ug/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ug/imtrigon.ods b/source/media/files/scalc/ug/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/ug/imtrigon.ods differ
diff --git a/source/media/files/scalc/ug/pivot.ods b/source/media/files/scalc/ug/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/ug/pivot.ods differ
diff --git a/source/media/files/scalc/ug/trigon.ods b/source/media/files/scalc/ug/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/ug/trigon.ods differ
diff --git a/source/media/files/scalc/uk/functions_ifs.ods b/source/media/files/scalc/uk/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/uk/functions_ifs.ods differ
diff --git a/source/media/files/scalc/uk/imtrigon.ods b/source/media/files/scalc/uk/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/uk/imtrigon.ods differ
diff --git a/source/media/files/scalc/uk/pivot.ods b/source/media/files/scalc/uk/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/uk/pivot.ods differ
diff --git a/source/media/files/scalc/uk/trigon.ods b/source/media/files/scalc/uk/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/uk/trigon.ods differ
diff --git a/source/media/files/scalc/vi/functions_ifs.ods b/source/media/files/scalc/vi/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/vi/functions_ifs.ods differ
diff --git a/source/media/files/scalc/vi/imtrigon.ods b/source/media/files/scalc/vi/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/vi/imtrigon.ods differ
diff --git a/source/media/files/scalc/vi/pivot.ods b/source/media/files/scalc/vi/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/vi/pivot.ods differ
diff --git a/source/media/files/scalc/vi/trigon.ods b/source/media/files/scalc/vi/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/vi/trigon.ods differ
diff --git a/source/media/files/scalc/zh-CN/functions_ifs.ods b/source/media/files/scalc/zh-CN/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/zh-CN/functions_ifs.ods differ
diff --git a/source/media/files/scalc/zh-CN/imtrigon.ods b/source/media/files/scalc/zh-CN/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/zh-CN/imtrigon.ods differ
diff --git a/source/media/files/scalc/zh-CN/pivot.ods b/source/media/files/scalc/zh-CN/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/zh-CN/pivot.ods differ
diff --git a/source/media/files/scalc/zh-CN/trigon.ods b/source/media/files/scalc/zh-CN/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/zh-CN/trigon.ods differ
diff --git a/source/media/files/scalc/zh-TW/functions_ifs.ods b/source/media/files/scalc/zh-TW/functions_ifs.ods
new file mode 100644
index 000000000..93e43e201
Binary files /dev/null and b/source/media/files/scalc/zh-TW/functions_ifs.ods differ
diff --git a/source/media/files/scalc/zh-TW/imtrigon.ods b/source/media/files/scalc/zh-TW/imtrigon.ods
new file mode 100644
index 000000000..ad5f96824
Binary files /dev/null and b/source/media/files/scalc/zh-TW/imtrigon.ods differ
diff --git a/source/media/files/scalc/zh-TW/pivot.ods b/source/media/files/scalc/zh-TW/pivot.ods
new file mode 100644
index 000000000..936051726
Binary files /dev/null and b/source/media/files/scalc/zh-TW/pivot.ods differ
diff --git a/source/media/files/scalc/zh-TW/trigon.ods b/source/media/files/scalc/zh-TW/trigon.ods
new file mode 100644
index 000000000..d603df80d
Binary files /dev/null and b/source/media/files/scalc/zh-TW/trigon.ods differ
diff --git a/source/text/scalc/01/func_countifs.xhp b/source/text/scalc/01/func_countifs.xhp
index 8a46e0f59..f47b269ab 100644
--- a/source/text/scalc/01/func_countifs.xhp
+++ b/source/text/scalc/01/func_countifs.xhp
@@ -25,21 +25,16 @@
<bookmark_value>counting column;satisfying criteria</bookmark_value>
</bookmark>
<paragraph id="hd_id456845684568" role="heading" level="2" xml-lang="en-US"><variable id="countifs_head"><link href="text/scalc/01/func_countifs.xhp">COUNTIFS</link></variable> function</paragraph>
-<paragraph id="par_id462646264626" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="countifs_des">Returns the count of rows or columns that meet criteria in multiple ranges.</variable></ahelp></paragraph>
+<paragraph id="par_id462646264626" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="countifs_des">Returns the count of cells that meet criteria in multiple ranges.</variable></ahelp></paragraph>
</section>
<paragraph id="hd_id465746574657" role="heading" level="3" xml-lang="en-US">Syntax</paragraph>
<paragraph id="par_id27421466710275" role="code" xml-lang="en-US">COUNTIFS(Range1; Criterion1 [; Range2; Criterion2 [; ...]])</paragraph>
<paragraph id="par_id242131304318587" role="paragraph" xml-lang="en-US"><emph>Range1</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for counting and finding the corresponding criterion.</paragraph>
-
<embed href="text/scalc/01/ex_data_stat_func.xhp#par00"/>
-
<paragraph id="par_id14734320631377" role="warning" xml-lang="en-US"><emph>Range1, Range2, ...</emph> and <emph>Criterion1, Criterion2, ...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument.</paragraph>
-
<embed href="text/scalc/01/ex_data_stat_func.xhp#note01"/>
<embed href="text/scalc/01/ex_data_stat_func.xhp#par01"/>
-
<embed href="text/scalc/01/ODFF.xhp#odff"/>
-
<embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/>
<paragraph id="hd_id3861259759512" role="heading" level="4" xml-lang="en-US">Simple usage</paragraph>
<paragraph id="par_id15856592423333" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIFS(B2:B6;">=20")</item></paragraph>
@@ -57,6 +52,7 @@
<paragraph id="par_id3245551524846" role="paragraph" xml-lang="en-US">If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the COUNTIFS function. For example, the above function can be rewritten as follows:</paragraph>
<paragraph id="par_id109501907712434" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIFS(A2:A6;E2&".*";B2:B6;"<"&MAX(B2:B6))</item></paragraph>
<paragraph id="par_id738533068520" role="paragraph" xml-lang="en-US">If E2 = pen, the function returns 1, because the link to the cell is substituted with its content and it works as a function above.</paragraph>
+<embed href="text/scalc/06/calcsamplefiles.xhp#func_ifs"/>
<section id="relatedtopics">
<paragraph id="par_id14337286612130" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060181.xhp#count">COUNT</link>, <link href="text/scalc/01/04060181.xhp#countif">COUNTIF</link>, <link href="text/scalc/01/04060181.xhp#counta">COUNTA</link>, <embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/>, <embedvar href="text/scalc/01/func_minifs.xhp#minifs_head"/>, <embedvar href="text/scalc/01/func_maxifs.xhp#maxifs_head"/>, <embedvar href="text/scalc/01/func_averageifs.xhp#averageifs_head"/>, <link href="text/scalc/01/04060184.xhp#max">MAX</link>, <link href="text/scalc/01/04060184.xhp#min">MIN</link></paragraph>
<paragraph id="par_id235992404316585" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph>
diff --git a/source/text/scalc/06/calcsamplefiles.xhp b/source/text/scalc/06/calcsamplefiles.xhp
index 230baab03..e79e02bfc 100644
--- a/source/text/scalc/06/calcsamplefiles.xhp
+++ b/source/text/scalc/06/calcsamplefiles.xhp
@@ -23,5 +23,8 @@
<section id="pivot">
<paragraph role="paragraph" id="par_id161521563314918" xml-lang="en-US"><object data="media/files/scalc/pivot.ods" id="ods_id61521547603544" type="application/vnd.oasis.opendocument.spreadsheet" /></paragraph>
</section>
+ <section id="func_ifs">
+ <paragraph role="paragraph" id="par_id721528312694192" xml-lang="en-US"><object data="media/files/scalc/functions_ifs.ods" id="ods_id61521547603534" type="application/vnd.oasis.opendocument.spreadsheet" /></paragraph>
+ </section>
</body>
</helpdocument>
More information about the Libreoffice-commits
mailing list