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@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
author: Olivier Hallot <olivier.hallot@libreoffice.org> 2018-06-08 23:58:14 -0300
committer: Olivier Hallot <olivier.hallot@libreoffice.org> 2018-06-11 02:50:17 +0200
commit: 185624ce2dfea227f0357e417bb3615e88c95e8e (patch)
tree: 160501b05bee71db34c1eea56a51651c8ca3c982
parent: 4189aaf3b4d4c00773d5afb4c0ad5f0eea5820b5 (diff)
266 files changed, 23 insertions, 17 deletions
diff --git a/AllLangPackage_html_media_lang.mk b/AllLangPackage_html_media_lang.mk
index 7482ec9976..caf4f76876 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 203dcac271..46635fd941 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 d73413a3d4..0314767576 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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/am/functions_ifs.ods
diff --git a/source/media/files/scalc/am/imtrigon.ods b/source/media/files/scalc/am/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/am/imtrigon.ods
diff --git a/source/media/files/scalc/am/pivot.ods b/source/media/files/scalc/am/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/am/pivot.ods
diff --git a/source/media/files/scalc/am/trigon.ods b/source/media/files/scalc/am/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/am/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/ar/functions_ifs.ods
diff --git a/source/media/files/scalc/ar/imtrigon.ods b/source/media/files/scalc/ar/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/ar/imtrigon.ods
diff --git a/source/media/files/scalc/ar/pivot.ods b/source/media/files/scalc/ar/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/ar/pivot.ods
diff --git a/source/media/files/scalc/ar/trigon.ods b/source/media/files/scalc/ar/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/ar/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/ast/functions_ifs.ods
diff --git a/source/media/files/scalc/ast/imtrigon.ods b/source/media/files/scalc/ast/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/ast/imtrigon.ods
diff --git a/source/media/files/scalc/ast/pivot.ods b/source/media/files/scalc/ast/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/ast/pivot.ods
diff --git a/source/media/files/scalc/ast/trigon.ods b/source/media/files/scalc/ast/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/ast/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/bg/functions_ifs.ods
diff --git a/source/media/files/scalc/bg/imtrigon.ods b/source/media/files/scalc/bg/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/bg/imtrigon.ods
diff --git a/source/media/files/scalc/bg/pivot.ods b/source/media/files/scalc/bg/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/bg/pivot.ods
diff --git a/source/media/files/scalc/bg/trigon.ods b/source/media/files/scalc/bg/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/bg/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/bn-IN/functions_ifs.ods
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 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/bn-IN/imtrigon.ods
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 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/bn-IN/pivot.ods
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 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/bn-IN/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/bn/functions_ifs.ods
diff --git a/source/media/files/scalc/bn/imtrigon.ods b/source/media/files/scalc/bn/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/bn/imtrigon.ods
diff --git a/source/media/files/scalc/bn/pivot.ods b/source/media/files/scalc/bn/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/bn/pivot.ods
diff --git a/source/media/files/scalc/bn/trigon.ods b/source/media/files/scalc/bn/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/bn/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/bo/functions_ifs.ods
diff --git a/source/media/files/scalc/bo/imtrigon.ods b/source/media/files/scalc/bo/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/bo/imtrigon.ods
diff --git a/source/media/files/scalc/bo/pivot.ods b/source/media/files/scalc/bo/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/bo/pivot.ods
diff --git a/source/media/files/scalc/bo/trigon.ods b/source/media/files/scalc/bo/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/bo/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/bs/functions_ifs.ods
diff --git a/source/media/files/scalc/bs/imtrigon.ods b/source/media/files/scalc/bs/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/bs/imtrigon.ods
diff --git a/source/media/files/scalc/bs/pivot.ods b/source/media/files/scalc/bs/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/bs/pivot.ods
diff --git a/source/media/files/scalc/bs/trigon.ods b/source/media/files/scalc/bs/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/bs/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/ca-valencia/functions_ifs.ods
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 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/ca-valencia/imtrigon.ods
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 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/ca-valencia/pivot.ods
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 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/ca-valencia/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/ca/functions_ifs.ods
diff --git a/source/media/files/scalc/ca/imtrigon.ods b/source/media/files/scalc/ca/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/ca/imtrigon.ods
diff --git a/source/media/files/scalc/ca/pivot.ods b/source/media/files/scalc/ca/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/ca/pivot.ods
diff --git a/source/media/files/scalc/ca/trigon.ods b/source/media/files/scalc/ca/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/ca/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/cs/functions_ifs.ods
diff --git a/source/media/files/scalc/cs/imtrigon.ods b/source/media/files/scalc/cs/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/cs/imtrigon.ods
diff --git a/source/media/files/scalc/cs/pivot.ods b/source/media/files/scalc/cs/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/cs/pivot.ods
diff --git a/source/media/files/scalc/cs/trigon.ods b/source/media/files/scalc/cs/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/cs/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/da/functions_ifs.ods
diff --git a/source/media/files/scalc/da/imtrigon.ods b/source/media/files/scalc/da/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/da/imtrigon.ods
diff --git a/source/media/files/scalc/da/pivot.ods b/source/media/files/scalc/da/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/da/pivot.ods
diff --git a/source/media/files/scalc/da/trigon.ods b/source/media/files/scalc/da/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/da/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/de/functions_ifs.ods
diff --git a/source/media/files/scalc/de/imtrigon.ods b/source/media/files/scalc/de/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/de/imtrigon.ods
diff --git a/source/media/files/scalc/de/pivot.ods b/source/media/files/scalc/de/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/de/pivot.ods
diff --git a/source/media/files/scalc/de/trigon.ods b/source/media/files/scalc/de/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/de/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/dz/functions_ifs.ods
diff --git a/source/media/files/scalc/dz/imtrigon.ods b/source/media/files/scalc/dz/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/dz/imtrigon.ods
diff --git a/source/media/files/scalc/dz/pivot.ods b/source/media/files/scalc/dz/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/dz/pivot.ods
diff --git a/source/media/files/scalc/dz/trigon.ods b/source/media/files/scalc/dz/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/dz/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/el/functions_ifs.ods
diff --git a/source/media/files/scalc/el/imtrigon.ods b/source/media/files/scalc/el/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/el/imtrigon.ods
diff --git a/source/media/files/scalc/el/pivot.ods b/source/media/files/scalc/el/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/el/pivot.ods
diff --git a/source/media/files/scalc/el/trigon.ods b/source/media/files/scalc/el/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/el/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/en-GB/functions_ifs.ods
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 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/en-GB/imtrigon.ods
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 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/en-GB/pivot.ods
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 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/en-GB/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/en-US/functions_ifs.ods
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 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/en-US/imtrigon.ods
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 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/en-US/pivot.ods
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 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/en-US/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/en-ZA/functions_ifs.ods
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 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/en-ZA/imtrigon.ods
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 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/en-ZA/pivot.ods
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 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/en-ZA/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/eo/functions_ifs.ods
diff --git a/source/media/files/scalc/eo/imtrigon.ods b/source/media/files/scalc/eo/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/eo/imtrigon.ods
diff --git a/source/media/files/scalc/eo/pivot.ods b/source/media/files/scalc/eo/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/eo/pivot.ods
diff --git a/source/media/files/scalc/eo/trigon.ods b/source/media/files/scalc/eo/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/eo/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/es/functions_ifs.ods
diff --git a/source/media/files/scalc/es/imtrigon.ods b/source/media/files/scalc/es/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/es/imtrigon.ods
diff --git a/source/media/files/scalc/es/pivot.ods b/source/media/files/scalc/es/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/es/pivot.ods
diff --git a/source/media/files/scalc/es/trigon.ods b/source/media/files/scalc/es/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/es/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/et/functions_ifs.ods
diff --git a/source/media/files/scalc/et/imtrigon.ods b/source/media/files/scalc/et/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/et/imtrigon.ods
diff --git a/source/media/files/scalc/et/pivot.ods b/source/media/files/scalc/et/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/et/pivot.ods
diff --git a/source/media/files/scalc/et/trigon.ods b/source/media/files/scalc/et/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/et/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/eu/functions_ifs.ods
diff --git a/source/media/files/scalc/eu/imtrigon.ods b/source/media/files/scalc/eu/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/eu/imtrigon.ods
diff --git a/source/media/files/scalc/eu/pivot.ods b/source/media/files/scalc/eu/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/eu/pivot.ods
diff --git a/source/media/files/scalc/eu/trigon.ods b/source/media/files/scalc/eu/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/eu/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/fi/functions_ifs.ods
diff --git a/source/media/files/scalc/fi/imtrigon.ods b/source/media/files/scalc/fi/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/fi/imtrigon.ods
diff --git a/source/media/files/scalc/fi/pivot.ods b/source/media/files/scalc/fi/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/fi/pivot.ods
diff --git a/source/media/files/scalc/fi/trigon.ods b/source/media/files/scalc/fi/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/fi/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/fr/functions_ifs.ods
diff --git a/source/media/files/scalc/fr/imtrigon.ods b/source/media/files/scalc/fr/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/fr/imtrigon.ods
diff --git a/source/media/files/scalc/fr/pivot.ods b/source/media/files/scalc/fr/pivot.ods
index 0b82846510..1311d93cab 100644
--- a/source/media/files/scalc/fr/pivot.ods
+++ b/source/media/files/scalc/fr/pivot.ods
diff --git a/source/media/files/scalc/fr/trigon.ods b/source/media/files/scalc/fr/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/fr/trigon.ods
diff --git a/source/media/files/scalc/functions_ifs.ods b/source/media/files/scalc/functions_ifs.ods
new file mode 100644
index 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/functions_ifs.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/gl/functions_ifs.ods
diff --git a/source/media/files/scalc/gl/imtrigon.ods b/source/media/files/scalc/gl/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/gl/imtrigon.ods
diff --git a/source/media/files/scalc/gl/pivot.ods b/source/media/files/scalc/gl/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/gl/pivot.ods
diff --git a/source/media/files/scalc/gl/trigon.ods b/source/media/files/scalc/gl/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/gl/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/gu/functions_ifs.ods
diff --git a/source/media/files/scalc/gu/imtrigon.ods b/source/media/files/scalc/gu/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/gu/imtrigon.ods
diff --git a/source/media/files/scalc/gu/pivot.ods b/source/media/files/scalc/gu/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/gu/pivot.ods
diff --git a/source/media/files/scalc/gu/trigon.ods b/source/media/files/scalc/gu/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/gu/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/he/functions_ifs.ods
diff --git a/source/media/files/scalc/he/imtrigon.ods b/source/media/files/scalc/he/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/he/imtrigon.ods
diff --git a/source/media/files/scalc/he/pivot.ods b/source/media/files/scalc/he/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/he/pivot.ods
diff --git a/source/media/files/scalc/he/trigon.ods b/source/media/files/scalc/he/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/he/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/hi/functions_ifs.ods
diff --git a/source/media/files/scalc/hi/imtrigon.ods b/source/media/files/scalc/hi/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/hi/imtrigon.ods
diff --git a/source/media/files/scalc/hi/pivot.ods b/source/media/files/scalc/hi/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/hi/pivot.ods
diff --git a/source/media/files/scalc/hi/trigon.ods b/source/media/files/scalc/hi/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/hi/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/hr/functions_ifs.ods
diff --git a/source/media/files/scalc/hr/imtrigon.ods b/source/media/files/scalc/hr/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/hr/imtrigon.ods
diff --git a/source/media/files/scalc/hr/pivot.ods b/source/media/files/scalc/hr/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/hr/pivot.ods
diff --git a/source/media/files/scalc/hr/trigon.ods b/source/media/files/scalc/hr/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/hr/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/hu/functions_ifs.ods
diff --git a/source/media/files/scalc/hu/imtrigon.ods b/source/media/files/scalc/hu/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/hu/imtrigon.ods
diff --git a/source/media/files/scalc/hu/pivot.ods b/source/media/files/scalc/hu/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/hu/pivot.ods
diff --git a/source/media/files/scalc/hu/trigon.ods b/source/media/files/scalc/hu/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/hu/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/id/functions_ifs.ods
diff --git a/source/media/files/scalc/id/imtrigon.ods b/source/media/files/scalc/id/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/id/imtrigon.ods
diff --git a/source/media/files/scalc/id/pivot.ods b/source/media/files/scalc/id/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/id/pivot.ods
diff --git a/source/media/files/scalc/id/trigon.ods b/source/media/files/scalc/id/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/id/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/is/functions_ifs.ods
diff --git a/source/media/files/scalc/is/imtrigon.ods b/source/media/files/scalc/is/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/is/imtrigon.ods
diff --git a/source/media/files/scalc/is/pivot.ods b/source/media/files/scalc/is/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/is/pivot.ods
diff --git a/source/media/files/scalc/is/trigon.ods b/source/media/files/scalc/is/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/is/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/it/functions_ifs.ods
diff --git a/source/media/files/scalc/it/imtrigon.ods b/source/media/files/scalc/it/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/it/imtrigon.ods
diff --git a/source/media/files/scalc/it/pivot.ods b/source/media/files/scalc/it/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/it/pivot.ods
diff --git a/source/media/files/scalc/it/trigon.ods b/source/media/files/scalc/it/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/it/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/ja/functions_ifs.ods
diff --git a/source/media/files/scalc/ja/imtrigon.ods b/source/media/files/scalc/ja/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/ja/imtrigon.ods
diff --git a/source/media/files/scalc/ja/pivot.ods b/source/media/files/scalc/ja/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/ja/pivot.ods
diff --git a/source/media/files/scalc/ja/trigon.ods b/source/media/files/scalc/ja/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/ja/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/ka/functions_ifs.ods
diff --git a/source/media/files/scalc/ka/imtrigon.ods b/source/media/files/scalc/ka/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/ka/imtrigon.ods
diff --git a/source/media/files/scalc/ka/pivot.ods b/source/media/files/scalc/ka/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/ka/pivot.ods
diff --git a/source/media/files/scalc/ka/trigon.ods b/source/media/files/scalc/ka/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/ka/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/km/functions_ifs.ods
diff --git a/source/media/files/scalc/km/imtrigon.ods b/source/media/files/scalc/km/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/km/imtrigon.ods
diff --git a/source/media/files/scalc/km/pivot.ods b/source/media/files/scalc/km/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/km/pivot.ods
diff --git a/source/media/files/scalc/km/trigon.ods b/source/media/files/scalc/km/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/km/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/ko/functions_ifs.ods
diff --git a/source/media/files/scalc/ko/imtrigon.ods b/source/media/files/scalc/ko/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/ko/imtrigon.ods
diff --git a/source/media/files/scalc/ko/pivot.ods b/source/media/files/scalc/ko/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/ko/pivot.ods
diff --git a/source/media/files/scalc/ko/trigon.ods b/source/media/files/scalc/ko/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/ko/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/lo/functions_ifs.ods
diff --git a/source/media/files/scalc/lo/imtrigon.ods b/source/media/files/scalc/lo/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/lo/imtrigon.ods
diff --git a/source/media/files/scalc/lo/pivot.ods b/source/media/files/scalc/lo/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/lo/pivot.ods
diff --git a/source/media/files/scalc/lo/trigon.ods b/source/media/files/scalc/lo/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/lo/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/lt/functions_ifs.ods
diff --git a/source/media/files/scalc/lt/imtrigon.ods b/source/media/files/scalc/lt/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/lt/imtrigon.ods
diff --git a/source/media/files/scalc/lt/pivot.ods b/source/media/files/scalc/lt/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/lt/pivot.ods
diff --git a/source/media/files/scalc/lt/trigon.ods b/source/media/files/scalc/lt/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/lt/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/lv/functions_ifs.ods
diff --git a/source/media/files/scalc/lv/imtrigon.ods b/source/media/files/scalc/lv/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/lv/imtrigon.ods
diff --git a/source/media/files/scalc/lv/pivot.ods b/source/media/files/scalc/lv/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/lv/pivot.ods
diff --git a/source/media/files/scalc/lv/trigon.ods b/source/media/files/scalc/lv/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/lv/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/mk/functions_ifs.ods
diff --git a/source/media/files/scalc/mk/imtrigon.ods b/source/media/files/scalc/mk/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/mk/imtrigon.ods
diff --git a/source/media/files/scalc/mk/pivot.ods b/source/media/files/scalc/mk/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/mk/pivot.ods
diff --git a/source/media/files/scalc/mk/trigon.ods b/source/media/files/scalc/mk/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/mk/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/nb/functions_ifs.ods
diff --git a/source/media/files/scalc/nb/imtrigon.ods b/source/media/files/scalc/nb/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/nb/imtrigon.ods
diff --git a/source/media/files/scalc/nb/pivot.ods b/source/media/files/scalc/nb/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/nb/pivot.ods
diff --git a/source/media/files/scalc/nb/trigon.ods b/source/media/files/scalc/nb/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/nb/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/ne/functions_ifs.ods
diff --git a/source/media/files/scalc/ne/imtrigon.ods b/source/media/files/scalc/ne/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/ne/imtrigon.ods
diff --git a/source/media/files/scalc/ne/pivot.ods b/source/media/files/scalc/ne/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/ne/pivot.ods
diff --git a/source/media/files/scalc/ne/trigon.ods b/source/media/files/scalc/ne/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/ne/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/nl/functions_ifs.ods
diff --git a/source/media/files/scalc/nl/imtrigon.ods b/source/media/files/scalc/nl/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/nl/imtrigon.ods
diff --git a/source/media/files/scalc/nl/pivot.ods b/source/media/files/scalc/nl/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/nl/pivot.ods
diff --git a/source/media/files/scalc/nl/trigon.ods b/source/media/files/scalc/nl/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/nl/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/nn/functions_ifs.ods
diff --git a/source/media/files/scalc/nn/imtrigon.ods b/source/media/files/scalc/nn/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/nn/imtrigon.ods
diff --git a/source/media/files/scalc/nn/pivot.ods b/source/media/files/scalc/nn/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/nn/pivot.ods
diff --git a/source/media/files/scalc/nn/trigon.ods b/source/media/files/scalc/nn/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/nn/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/om/functions_ifs.ods
diff --git a/source/media/files/scalc/om/imtrigon.ods b/source/media/files/scalc/om/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/om/imtrigon.ods
diff --git a/source/media/files/scalc/om/pivot.ods b/source/media/files/scalc/om/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/om/pivot.ods
diff --git a/source/media/files/scalc/om/trigon.ods b/source/media/files/scalc/om/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/om/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/pl/functions_ifs.ods
diff --git a/source/media/files/scalc/pl/imtrigon.ods b/source/media/files/scalc/pl/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/pl/imtrigon.ods
diff --git a/source/media/files/scalc/pl/pivot.ods b/source/media/files/scalc/pl/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/pl/pivot.ods
diff --git a/source/media/files/scalc/pl/trigon.ods b/source/media/files/scalc/pl/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/pl/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/pt-BR/functions_ifs.ods
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 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/pt-BR/imtrigon.ods
diff --git a/source/media/files/scalc/pt-BR/pivot.ods b/source/media/files/scalc/pt-BR/pivot.ods
index 991dcb7add..9360517267 100644
--- a/source/media/files/scalc/pt-BR/pivot.ods
+++ b/source/media/files/scalc/pt-BR/pivot.ods
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 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/pt-BR/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/pt/functions_ifs.ods
diff --git a/source/media/files/scalc/pt/imtrigon.ods b/source/media/files/scalc/pt/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/pt/imtrigon.ods
diff --git a/source/media/files/scalc/pt/pivot.ods b/source/media/files/scalc/pt/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/pt/pivot.ods
diff --git a/source/media/files/scalc/pt/trigon.ods b/source/media/files/scalc/pt/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/pt/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/ro/functions_ifs.ods
diff --git a/source/media/files/scalc/ro/imtrigon.ods b/source/media/files/scalc/ro/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/ro/imtrigon.ods
diff --git a/source/media/files/scalc/ro/pivot.ods b/source/media/files/scalc/ro/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/ro/pivot.ods
diff --git a/source/media/files/scalc/ro/trigon.ods b/source/media/files/scalc/ro/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/ro/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/ru/functions_ifs.ods
diff --git a/source/media/files/scalc/ru/imtrigon.ods b/source/media/files/scalc/ru/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/ru/imtrigon.ods
diff --git a/source/media/files/scalc/ru/pivot.ods b/source/media/files/scalc/ru/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/ru/pivot.ods
diff --git a/source/media/files/scalc/ru/trigon.ods b/source/media/files/scalc/ru/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/ru/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/si/functions_ifs.ods
diff --git a/source/media/files/scalc/si/imtrigon.ods b/source/media/files/scalc/si/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/si/imtrigon.ods
diff --git a/source/media/files/scalc/si/pivot.ods b/source/media/files/scalc/si/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/si/pivot.ods
diff --git a/source/media/files/scalc/si/trigon.ods b/source/media/files/scalc/si/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/si/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/sid/functions_ifs.ods
diff --git a/source/media/files/scalc/sid/imtrigon.ods b/source/media/files/scalc/sid/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/sid/imtrigon.ods
diff --git a/source/media/files/scalc/sid/pivot.ods b/source/media/files/scalc/sid/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/sid/pivot.ods
diff --git a/source/media/files/scalc/sid/trigon.ods b/source/media/files/scalc/sid/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/sid/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/sk/functions_ifs.ods
diff --git a/source/media/files/scalc/sk/imtrigon.ods b/source/media/files/scalc/sk/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/sk/imtrigon.ods
diff --git a/source/media/files/scalc/sk/pivot.ods b/source/media/files/scalc/sk/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/sk/pivot.ods
diff --git a/source/media/files/scalc/sk/trigon.ods b/source/media/files/scalc/sk/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/sk/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/sl/functions_ifs.ods
diff --git a/source/media/files/scalc/sl/imtrigon.ods b/source/media/files/scalc/sl/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/sl/imtrigon.ods
diff --git a/source/media/files/scalc/sl/pivot.ods b/source/media/files/scalc/sl/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/sl/pivot.ods
diff --git a/source/media/files/scalc/sl/trigon.ods b/source/media/files/scalc/sl/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/sl/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/sq/functions_ifs.ods
diff --git a/source/media/files/scalc/sq/imtrigon.ods b/source/media/files/scalc/sq/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/sq/imtrigon.ods
diff --git a/source/media/files/scalc/sq/pivot.ods b/source/media/files/scalc/sq/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/sq/pivot.ods
diff --git a/source/media/files/scalc/sq/trigon.ods b/source/media/files/scalc/sq/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/sq/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/sv/functions_ifs.ods
diff --git a/source/media/files/scalc/sv/imtrigon.ods b/source/media/files/scalc/sv/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/sv/imtrigon.ods
diff --git a/source/media/files/scalc/sv/pivot.ods b/source/media/files/scalc/sv/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/sv/pivot.ods
diff --git a/source/media/files/scalc/sv/trigon.ods b/source/media/files/scalc/sv/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/sv/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/ta/functions_ifs.ods
diff --git a/source/media/files/scalc/ta/imtrigon.ods b/source/media/files/scalc/ta/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/ta/imtrigon.ods
diff --git a/source/media/files/scalc/ta/pivot.ods b/source/media/files/scalc/ta/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/ta/pivot.ods
diff --git a/source/media/files/scalc/ta/trigon.ods b/source/media/files/scalc/ta/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/ta/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/tg/functions_ifs.ods
diff --git a/source/media/files/scalc/tg/imtrigon.ods b/source/media/files/scalc/tg/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/tg/imtrigon.ods
diff --git a/source/media/files/scalc/tg/pivot.ods b/source/media/files/scalc/tg/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/tg/pivot.ods
diff --git a/source/media/files/scalc/tg/trigon.ods b/source/media/files/scalc/tg/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/tg/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/tr/functions_ifs.ods
diff --git a/source/media/files/scalc/tr/imtrigon.ods b/source/media/files/scalc/tr/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/tr/imtrigon.ods
diff --git a/source/media/files/scalc/tr/pivot.ods b/source/media/files/scalc/tr/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/tr/pivot.ods
diff --git a/source/media/files/scalc/tr/trigon.ods b/source/media/files/scalc/tr/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/tr/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/ug/functions_ifs.ods
diff --git a/source/media/files/scalc/ug/imtrigon.ods b/source/media/files/scalc/ug/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/ug/imtrigon.ods
diff --git a/source/media/files/scalc/ug/pivot.ods b/source/media/files/scalc/ug/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/ug/pivot.ods
diff --git a/source/media/files/scalc/ug/trigon.ods b/source/media/files/scalc/ug/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/ug/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/uk/functions_ifs.ods
diff --git a/source/media/files/scalc/uk/imtrigon.ods b/source/media/files/scalc/uk/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/uk/imtrigon.ods
diff --git a/source/media/files/scalc/uk/pivot.ods b/source/media/files/scalc/uk/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/uk/pivot.ods
diff --git a/source/media/files/scalc/uk/trigon.ods b/source/media/files/scalc/uk/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/uk/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/vi/functions_ifs.ods
diff --git a/source/media/files/scalc/vi/imtrigon.ods b/source/media/files/scalc/vi/imtrigon.ods
new file mode 100644
index 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/vi/imtrigon.ods
diff --git a/source/media/files/scalc/vi/pivot.ods b/source/media/files/scalc/vi/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/vi/pivot.ods
diff --git a/source/media/files/scalc/vi/trigon.ods b/source/media/files/scalc/vi/trigon.ods
new file mode 100644
index 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/vi/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/zh-CN/functions_ifs.ods
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 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/zh-CN/imtrigon.ods
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 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/zh-CN/pivot.ods
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 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/zh-CN/trigon.ods
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 0000000000..93e43e201e
--- /dev/null
+++ b/source/media/files/scalc/zh-TW/functions_ifs.ods
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 0000000000..ad5f968246
--- /dev/null
+++ b/source/media/files/scalc/zh-TW/imtrigon.ods
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 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/zh-TW/pivot.ods
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 0000000000..d603df80dd
--- /dev/null
+++ b/source/media/files/scalc/zh-TW/trigon.ods
diff --git a/source/text/scalc/01/func_countifs.xhp b/source/text/scalc/01/func_countifs.xhp
index 8a46e0f592..f47b269ab7 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&amp;".*";B2:B6;"&lt;"&amp;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 230baab03e..e79e02bfcb 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>
author	Olivier Hallot <olivier.hallot@libreoffice.org>	2018-06-08 23:58:14 -0300
committer	Olivier Hallot <olivier.hallot@libreoffice.org>	2018-06-11 02:50:17 +0200
commit	185624ce2dfea227f0357e417bb3615e88c95e8e (patch)
tree	160501b05bee71db34c1eea56a51651c8ca3c982
parent	4189aaf3b4d4c00773d5afb4c0ad5f0eea5820b5 (diff)