diff options
author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2018-06-08 23:58:14 -0300 |
---|---|---|
committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2018-06-12 17:56:23 +0200 |
commit | b574fd22322fd31db2da408729cdd1c402626524 (patch) | |
tree | ff8987e9a4ed307fb0d58ec1c54db689f761aa43 | |
parent | 7623916541246501c8c797ab9b6decece8ae230a (diff) |
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>
(cherry picked from commit 185624ce2dfea227f0357e417bb3615e88c95e8e)
Reviewed-on: https://gerrit.libreoffice.org/55687
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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differindex 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differindex 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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 Binary files differnew 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&".*";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 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> |