Update translations for master and force-fix errors using pocheck libreoffice-5-1-branch-point

Change-Id: Ia185c1d9ef3b66189ec6b1ab08795fa5f4aaca49
author: Robinson Tryon <qubit@runcibility.com> 2015-11-24 05:47:40 -0500
committer: Robinson Tryon <qubit@runcibility.com> 2015-11-25 01:57:27 -0500
commit: 9b7a6f9619c88ddee34c8cd1623eccdd7d4a4769 (patch)
tree: 9c1fecf277ba5ea9818c2f31f5cd90e5bee12e68 /source/ug
parent: 2c02b59bd90e8fb0f8ab7b2449bf885f7c41f6e7 (diff)
73 files changed, 6682 insertions, 4568 deletions
diff --git a/source/ug/avmedia/source/viewer.po b/source/ug/avmedia/source/viewer.po
index fc483598d79..0c878174132 100644
--- a/source/ug/avmedia/source/viewer.po
+++ b/source/ug/avmedia/source/viewer.po
@@ -3,9 +3,9 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2015-04-22 23:40+0200\n"
+"POT-Creation-Date: 2015-11-10 19:32+0100\n"
 "PO-Revision-Date: 2015-10-18 14:44+0000\n"
-"Last-Translator: Abduqadir Abliz <Sahran@live.com>\n"
+"Last-Translator: system user <>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: ug\n"
 "MIME-Version: 1.0\n"
@@ -25,12 +25,13 @@ msgid "Insert Audio or Video"
 msgstr "ئۈن ياكى سىن قىستۇر"
 
 #: mediawindow.src
+#, fuzzy
 msgctxt ""
 "mediawindow.src\n"
 "AVMEDIA_STR_OPENMEDIA_DLG\n"
 "string.text"
-msgid "Open Audio and Video Dialog"
-msgstr "ئۈن ياكى سىن سۆزلىشىشنى ئاچ"
+msgid "Open Audio or Video"
+msgstr "ئۈن ياكى سىن قىستۇر"
 
 #: mediawindow.src
 msgctxt ""
diff --git a/source/ug/basctl/source/basicide.po b/source/ug/basctl/source/basicide.po
index 6ae45034b1b..4eda25419de 100644
--- a/source/ug/basctl/source/basicide.po
+++ b/source/ug/basctl/source/basicide.po
@@ -3,9 +3,9 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2015-04-22 23:40+0200\n"
+"POT-Creation-Date: 2015-11-10 19:33+0100\n"
 "PO-Revision-Date: 2015-10-18 14:46+0000\n"
-"Last-Translator: Abduqadir Abliz <Sahran@live.com>\n"
+"Last-Translator: system user <>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: ug\n"
 "MIME-Version: 1.0\n"
@@ -424,14 +424,6 @@ msgstr "BASIC پروگراممىسى ئىجرا بولۇۋاتقاندا كۆز�
 #: basidesh.src
 msgctxt ""
 "basidesh.src\n"
-"RID_STR_CANNOTSAVEVBA\n"
-"string.text"
-msgid "You are editing a VBA macro. Changes can be saved only in OpenDocument Format."
-msgstr "سىز VBA ماكرونى تەھرىرلەۋاتىسىز. ئۆزگىرىش OpenDocument پىچىمىدىلا ساقلىغىلى بولىدۇ."
-
-#: basidesh.src
-msgctxt ""
-"basidesh.src\n"
 "RID_STR_REPLACESTDLIB\n"
 "string.text"
 msgid "The default library cannot be replaced."
diff --git a/source/ug/chart2/uiconfig/ui.po b/source/ug/chart2/uiconfig/ui.po
index f6919711b4c..3932b977497 100644
--- a/source/ug/chart2/uiconfig/ui.po
+++ b/source/ug/chart2/uiconfig/ui.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2015-08-25 12:33+0200\n"
+"POT-Creation-Date: 2015-11-10 19:32+0100\n"
 "PO-Revision-Date: 2015-05-14 04:19+0000\n"
 "Last-Translator: system user <>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -199,6 +199,15 @@ msgstr ""
 #: dlg_DataLabel.ui
 msgctxt ""
 "dlg_DataLabel.ui\n"
+"CB_WRAP_TEXT\n"
+"label\n"
+"string.text"
+msgid "Auto text _wrap"
+msgstr ""
+
+#: dlg_DataLabel.ui
+msgctxt ""
+"dlg_DataLabel.ui\n"
 "PB_NUMBERFORMAT\n"
 "label\n"
 "string.text"
@@ -876,13 +885,14 @@ msgid "Minor Grids"
 msgstr "ئاساسىي سېتكا"
 
 #: inserttitledlg.ui
+#, fuzzy
 msgctxt ""
 "inserttitledlg.ui\n"
 "InsertTitleDialog\n"
 "title\n"
 "string.text"
 msgid "Titles"
-msgstr ""
+msgstr "ياي(_T)"
 
 #: inserttitledlg.ui
 #, fuzzy
@@ -1113,10 +1123,82 @@ msgctxt ""
 "l\n"
 "label\n"
 "string.text"
-msgid "Title"
+msgid "Titles"
 msgstr "ياي(_T)"
 
 #: sidebarelements.ui
+msgctxt ""
+"sidebarelements.ui\n"
+"checkbutton_legend\n"
+"tooltip_text\n"
+"string.text"
+msgid "Show Legend"
+msgstr ""
+
+#: sidebarelements.ui
+msgctxt ""
+"sidebarelements.ui\n"
+"placement_label\n"
+"label\n"
+"string.text"
+msgid "_Placement:"
+msgstr ""
+
+#: sidebarelements.ui
+msgctxt ""
+"sidebarelements.ui\n"
+"comboboxtext_legend\n"
+"0\n"
+"stringlist.text"
+msgid "Right"
+msgstr ""
+
+#: sidebarelements.ui
+msgctxt ""
+"sidebarelements.ui\n"
+"comboboxtext_legend\n"
+"1\n"
+"stringlist.text"
+msgid "Top"
+msgstr ""
+
+#: sidebarelements.ui
+msgctxt ""
+"sidebarelements.ui\n"
+"comboboxtext_legend\n"
+"2\n"
+"stringlist.text"
+msgid "Bottom"
+msgstr ""
+
+#: sidebarelements.ui
+msgctxt ""
+"sidebarelements.ui\n"
+"comboboxtext_legend\n"
+"3\n"
+"stringlist.text"
+msgid "Left"
+msgstr ""
+
+#: sidebarelements.ui
+msgctxt ""
+"sidebarelements.ui\n"
+"comboboxtext_legend\n"
+"4\n"
+"stringlist.text"
+msgid "Manual"
+msgstr ""
+
+#: sidebarelements.ui
+msgctxt ""
+"sidebarelements.ui\n"
+"label_legen\n"
+"label\n"
+"string.text"
+msgid "Legend"
+msgstr ""
+
+#: sidebarelements.ui
 #, fuzzy
 msgctxt ""
 "sidebarelements.ui\n"
@@ -1222,82 +1304,28 @@ msgstr "ئوق"
 #: sidebarelements.ui
 msgctxt ""
 "sidebarelements.ui\n"
-"checkbutton_legend\n"
-"label\n"
-"string.text"
-msgid "Show legend"
-msgstr ""
-
-#: sidebarelements.ui
-msgctxt ""
-"sidebarelements.ui\n"
-"placement_label\n"
+"checkbutton_gridline_horizontal_major\n"
 "label\n"
 "string.text"
-msgid "_Placement:"
-msgstr ""
-
-#: sidebarelements.ui
-msgctxt ""
-"sidebarelements.ui\n"
-"comboboxtext_legend\n"
-"0\n"
-"stringlist.text"
-msgid "Bottom"
-msgstr ""
-
-#: sidebarelements.ui
-msgctxt ""
-"sidebarelements.ui\n"
-"comboboxtext_legend\n"
-"1\n"
-"stringlist.text"
-msgid "Left"
-msgstr ""
-
-#: sidebarelements.ui
-msgctxt ""
-"sidebarelements.ui\n"
-"comboboxtext_legend\n"
-"2\n"
-"stringlist.text"
-msgid "Right"
-msgstr ""
-
-#: sidebarelements.ui
-msgctxt ""
-"sidebarelements.ui\n"
-"comboboxtext_legend\n"
-"3\n"
-"stringlist.text"
-msgid "Top"
-msgstr ""
-
-#: sidebarelements.ui
-msgctxt ""
-"sidebarelements.ui\n"
-"comboboxtext_legend\n"
-"4\n"
-"stringlist.text"
-msgid "Manual"
+msgid "Horizontal major"
 msgstr ""
 
 #: sidebarelements.ui
 msgctxt ""
 "sidebarelements.ui\n"
-"label_legen\n"
+"checkbutton_gridline_vertical_major\n"
 "label\n"
 "string.text"
-msgid "Legend"
+msgid "Vertical major"
 msgstr ""
 
 #: sidebarelements.ui
 msgctxt ""
 "sidebarelements.ui\n"
-"checkbutton_gridline_vertical_major\n"
+"checkbutton_gridline_horizontal_minor\n"
 "label\n"
 "string.text"
-msgid "Vertical major"
+msgid "Horizontal minor"
 msgstr ""
 
 #: sidebarelements.ui
@@ -1312,28 +1340,29 @@ msgstr ""
 #: sidebarelements.ui
 msgctxt ""
 "sidebarelements.ui\n"
-"checkbutton_gridline_horizontal_major\n"
+"label_gri\n"
 "label\n"
 "string.text"
-msgid "Horizontal major"
+msgid "Gridlines"
 msgstr ""
 
 #: sidebarelements.ui
+#, fuzzy
 msgctxt ""
 "sidebarelements.ui\n"
-"checkbutton_gridline_horizontal_minor\n"
+"text_title\n"
 "label\n"
 "string.text"
-msgid "Horizontal minor"
-msgstr ""
+msgid "Title"
+msgstr "ياي(_T)"
 
 #: sidebarelements.ui
 msgctxt ""
 "sidebarelements.ui\n"
-"label_gri\n"
+"text_subtitle\n"
 "label\n"
 "string.text"
-msgid "Gridlines"
+msgid "Subtitle"
 msgstr ""
 
 #: sidebarerrorbar.ui
@@ -1429,24 +1458,6 @@ msgstr ""
 #: sidebarerrorbar.ui
 msgctxt ""
 "sidebarerrorbar.ui\n"
-"spinbutton_pos\n"
-"text\n"
-"string.text"
-msgid "0.00"
-msgstr ""
-
-#: sidebarerrorbar.ui
-msgctxt ""
-"sidebarerrorbar.ui\n"
-"spinbutton_neg\n"
-"text\n"
-"string.text"
-msgid "0.00"
-msgstr ""
-
-#: sidebarerrorbar.ui
-msgctxt ""
-"sidebarerrorbar.ui\n"
 "radiobutton_positive_negative\n"
 "tooltip_text\n"
 "string.text"
@@ -2613,6 +2624,15 @@ msgstr ""
 #: tp_DataLabel.ui
 msgctxt ""
 "tp_DataLabel.ui\n"
+"CB_WRAP_TEXT\n"
+"label\n"
+"string.text"
+msgid "Auto text _wrap"
+msgstr ""
+
+#: tp_DataLabel.ui
+msgctxt ""
+"tp_DataLabel.ui\n"
 "PB_NUMBERFORMAT\n"
 "label\n"
 "string.text"
diff --git a/source/ug/connectivity/registry/kab/org/openoffice/Office/DataAccess.po b/source/ug/connectivity/registry/kab/org/openoffice/Office/DataAccess.po
deleted file mode 100644
index daa52b0b69e..00000000000
--- a/source/ug/connectivity/registry/kab/org/openoffice/Office/DataAccess.po
+++ /dev/null
@@ -1,25 +0,0 @@
-#. extracted from connectivity/registry/kab/org/openoffice/Office/DataAccess
-msgid ""
-msgstr ""
-"Project-Id-Version: PACKAGE VERSION\n"
-"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2013-11-20 13:01+0100\n"
-"PO-Revision-Date: 2012-06-15 04:37+0200\n"
-"Last-Translator: Abduqadir <Sahran@live.com>\n"
-"Language-Team: LANGUAGE <LL@li.org>\n"
-"Language: ug\n"
-"MIME-Version: 1.0\n"
-"Content-Type: text/plain; charset=UTF-8\n"
-"Content-Transfer-Encoding: 8bit\n"
-"Plural-Forms: nplurals=1; plural=0;\n"
-"X-Generator: LibreOffice\n"
-"X-Accelerator-Marker: ~\n"
-
-#: Drivers.xcu
-msgctxt ""
-"Drivers.xcu\n"
-".Drivers.Installed.sdbc:address:kab\n"
-"DriverTypeDisplayName\n"
-"value.text"
-msgid "KDE Address Book"
-msgstr "KDE ئادرېس دەپتەر"
diff --git a/source/ug/connectivity/registry/mozab/org/openoffice/Office/DataAccess.po b/source/ug/connectivity/registry/mozab/org/openoffice/Office/DataAccess.po
deleted file mode 100644
index ab7264c9974..00000000000
--- a/source/ug/connectivity/registry/mozab/org/openoffice/Office/DataAccess.po
+++ /dev/null
@@ -1,61 +0,0 @@
-#. extracted from connectivity/registry/mozab/org/openoffice/Office/DataAccess
-msgid ""
-msgstr ""
-"Project-Id-Version: PACKAGE VERSION\n"
-"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2013-11-20 13:01+0100\n"
-"PO-Revision-Date: 2012-07-01 15:54+0200\n"
-"Last-Translator: Abduqadir <Sahran@live.com>\n"
-"Language-Team: LANGUAGE <LL@li.org>\n"
-"Language: ug\n"
-"MIME-Version: 1.0\n"
-"Content-Type: text/plain; charset=UTF-8\n"
-"Content-Transfer-Encoding: 8bit\n"
-"Plural-Forms: nplurals=1; plural=0;\n"
-"X-Generator: LibreOffice\n"
-"X-Accelerator-Marker: ~\n"
-
-#: Drivers.xcu
-msgctxt ""
-"Drivers.xcu\n"
-".Drivers.Installed.sdbc:address:outlook\n"
-"DriverTypeDisplayName\n"
-"value.text"
-msgid "Microsoft Outlook Address Book"
-msgstr "Microsoft Outlook ئادرېس دەپتەر"
-
-#: Drivers.xcu
-msgctxt ""
-"Drivers.xcu\n"
-".Drivers.Installed.sdbc:address:outlookexp\n"
-"DriverTypeDisplayName\n"
-"value.text"
-msgid "Microsoft Windows Address Book"
-msgstr "Microsoft Windows ئادرېس دەپتەر"
-
-#: Drivers.xcu
-msgctxt ""
-"Drivers.xcu\n"
-".Drivers.Installed.sdbc:address:mozilla:\n"
-"DriverTypeDisplayName\n"
-"value.text"
-msgid "SeaMonkey Address Book"
-msgstr "SeaMonkey ئادرېس دەپتەر"
-
-#: Drivers.xcu
-msgctxt ""
-"Drivers.xcu\n"
-".Drivers.Installed.sdbc:address:thunderbird:\n"
-"DriverTypeDisplayName\n"
-"value.text"
-msgid "Thunderbird/Icedove Address Book"
-msgstr "Thunderbird/Icedove ئادرېس دەپتەر"
-
-#: Drivers.xcu
-msgctxt ""
-"Drivers.xcu\n"
-".Drivers.Installed.sdbc:address:ldap:*\n"
-"DriverTypeDisplayName\n"
-"value.text"
-msgid "LDAP Address Book"
-msgstr "LDAP ئادرېس دەپتەر"
diff --git a/source/ug/connectivity/source/resource.po b/source/ug/connectivity/source/resource.po
index fbdfb1ab487..65219a21b62 100644
--- a/source/ug/connectivity/source/resource.po
+++ b/source/ug/connectivity/source/resource.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: resource\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2015-06-24 17:06+0200\n"
+"POT-Creation-Date: 2015-11-10 19:33+0100\n"
 "PO-Revision-Date: 2015-05-14 04:19+0000\n"
 "Last-Translator: system user <>\n"
 "Language-Team: Uyghur Computer Science Association <UKIJ@yahoogroups.com>\n"
@@ -109,24 +109,6 @@ msgid "Thunderbird Address Book Directory"
 msgstr "Thunderbird ئادرېس دەپتەر مۇندەرىجىسى"
 
 #: conn_shared_res.src
-#, fuzzy
-msgctxt ""
-"conn_shared_res.src\n"
-"STR_OE_ADDRESSBOOK\n"
-"string.text"
-msgid "Outlook Express Address Book"
-msgstr "Outlook Express ئادرېس دەپتىرى"
-
-#: conn_shared_res.src
-#, fuzzy
-msgctxt ""
-"conn_shared_res.src\n"
-"STR_OUTLOOK_MAPI_ADDRESSBOOK\n"
-"string.text"
-msgid "Outlook (MAPI) Address Book"
-msgstr "Outlook (MAPI) ئادرېس دەپتىرى"
-
-#: conn_shared_res.src
 msgctxt ""
 "conn_shared_res.src\n"
 "STR_NO_TABLE_CREATION_SUPPORT\n"
diff --git a/source/ug/cui/source/customize.po b/source/ug/cui/source/customize.po
index 6db1556d42a..494de3c9cab 100644
--- a/source/ug/cui/source/customize.po
+++ b/source/ug/cui/source/customize.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2015-04-22 23:40+0200\n"
+"POT-Creation-Date: 2015-11-16 19:02+0100\n"
 "PO-Revision-Date: 2015-05-14 04:19+0000\n"
 "Last-Translator: system user <>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -224,6 +224,14 @@ msgstr "%PRODUCTNAME %MODULENAME قورال بالداق"
 #: cfg.src
 msgctxt ""
 "cfg.src\n"
+"RID_SVXSTR_PRODUCTNAME_CONTEXTMENUS\n"
+"string.text"
+msgid "%PRODUCTNAME %MODULENAME Context Menus"
+msgstr ""
+
+#: cfg.src
+msgctxt ""
+"cfg.src\n"
 "RID_SVXSTR_TOOLBAR\n"
 "string.text"
 msgid "Toolbar"
@@ -262,12 +270,13 @@ msgid "Toolbar Name"
 msgstr ""
 
 #: cfg.src
+#, fuzzy
 msgctxt ""
 "cfg.src\n"
 "RID_SXVSTR_CONFIRM_DELETE_TOOLBAR\n"
 "string.text"
 msgid "There are no more commands on the toolbar. Do you want to delete the toolbar?"
-msgstr ""
+msgstr "قورال بالداقتا ھېچقانداق بۇيرۇق كۇنۇپكىسى يوق. قورال بالداقنى ئۆچۈرەمسىز؟"
 
 #: cfg.src
 msgctxt ""
@@ -286,12 +295,13 @@ msgid "The toolbar configuration for %SAVE IN SELECTION% will be reset to the de
 msgstr ""
 
 #: cfg.src
+#, fuzzy
 msgctxt ""
 "cfg.src\n"
 "RID_SVXSTR_CONFIRM_RESTORE_DEFAULT\n"
 "string.text"
 msgid "This will delete all changes previously made to this toolbar. Do you really want to reset the toolbar?"
-msgstr ""
+msgstr "بۇ مەشغۇلات ئىلگىرى قورال بالداققا ئېلىپ بېرىلغان بارلىق ئۆزگەرتىشلەرنى ئۆچۈرىدۇ. قورال بالداقنى ئەسلىگە قايتۇرامسىز؟"
 
 #: cfg.src
 msgctxt ""
diff --git a/source/ug/cui/source/dialogs.po b/source/ug/cui/source/dialogs.po
index e9ca65c742a..cb4ed9c0ae2 100644
--- a/source/ug/cui/source/dialogs.po
+++ b/source/ug/cui/source/dialogs.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2015-08-25 12:33+0200\n"
+"POT-Creation-Date: 2015-11-10 19:33+0100\n"
 "PO-Revision-Date: 2015-05-14 04:21+0000\n"
 "Last-Translator: system user <>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -316,14 +316,6 @@ msgstr "بۇ ID مەۋجۇد…"
 #: hyperdlg.src
 msgctxt ""
 "hyperdlg.src\n"
-"RID_SVXSTR_HYPDLG_APPLYBUT\n"
-"string.text"
-msgid "Apply"
-msgstr "قوللان"
-
-#: hyperdlg.src
-msgctxt ""
-"hyperdlg.src\n"
 "RID_SVXSTR_HYPDLG_CLOSEBUT\n"
 "string.text"
 msgid "Close"
@@ -752,17 +744,3 @@ msgctxt ""
 "string.text"
 msgid "Waiting"
 msgstr "كۈتۈۋاتىدۇ"
-
-msgctxt ""
-"svuidlg.src\n"
-"STR_GRAPHICLINK\n"
-"string.text"
-msgid "Graphic"
-msgstr "گرافىك"
-
-msgctxt ""
-"svuidlg.src\n"
-"STR_BUTTONCLOSE\n"
-"string.text"
-msgid "~Close"
-msgstr "ياپ(~C)"
diff --git a/source/ug/cui/source/options.po b/source/ug/cui/source/options.po
index 6e97549362a..cc827b417b0 100644
--- a/source/ug/cui/source/options.po
+++ b/source/ug/cui/source/options.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2015-04-22 23:40+0200\n"
+"POT-Creation-Date: 2015-11-10 19:33+0100\n"
 "PO-Revision-Date: 2015-05-14 04:22+0000\n"
 "Last-Translator: system user <>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -253,12 +253,13 @@ msgid "SmartArt to %PRODUCTNAME shapes or reverse"
 msgstr "SmartArt تىن %PRODUCTNAME شەكىللىرىگە ياكى ئەكسىچە"
 
 #: optgdlg.src
+#, fuzzy
 msgctxt ""
 "optgdlg.src\n"
 "RID_SVXSTR_LANGUAGE_RESTART\n"
 "string.text"
 msgid "The language setting of the user interface has been updated and will take effect the next time you start %PRODUCTNAME %PRODUCTVERSION"
-msgstr ""
+msgstr "ئىشلەتكۈچى كۆرۈنمە يۈزى تىل تەڭشىكى يېڭىلاندى، كېيىنكى قېتىم %PRODUCTNAME %PRODUCTVERSION قوزغاتقاندا كۈچكە ئىگە بولىدۇ"
 
 #: optinet2.src
 msgctxt ""
@@ -275,6 +276,7 @@ msgstr ""
 "ئېغىزنىڭ ئەڭ چوڭ قىممىتى 65535."
 
 #: optjava.src
+#, fuzzy
 msgctxt ""
 "optjava.src\n"
 "RID_SVXSTR_JRE_NOT_RECOGNIZED\n"
@@ -283,8 +285,11 @@ msgid ""
 "The folder you selected does not contain a Java runtime environment.\n"
 "Please select a different folder."
 msgstr ""
+"تاللىغان مۇندەرىجىدە Java ئىجرا مۇھىتى يوق.\n"
+"باشقا مۇندەرىجىنى تاللاڭ."
 
 #: optjava.src
+#, fuzzy
 msgctxt ""
 "optjava.src\n"
 "RID_SVXSTR_JRE_FAILED_VERSION\n"
@@ -293,8 +298,11 @@ msgid ""
 "The Java runtime environment you selected is not the required version.\n"
 "Please select a different folder."
 msgstr ""
+"تاللىغان Java ئىجرا مۇھىتى لازىملىق نەشرى ئەمەس.\n"
+"باشقا مۇندەرىجىنى تاللاڭ."
 
 #: optjava.src
+#, fuzzy
 msgctxt ""
 "optjava.src\n"
 "RID_SVXSTR_OPTIONS_RESTART\n"
@@ -303,6 +311,8 @@ msgid ""
 "You have to restart %PRODUCTNAME so the new or modified values can take effect.\n"
 "Please restart %PRODUCTNAME now."
 msgstr ""
+"%PRODUCTNAME قايتا قوزغىتىلغاندىن كېيىن ئۆزگەرتىلگەن يېڭى قىممەت كۈچكە ئىگە بولىدۇ.\n"
+"%PRODUCTNAME نى دەرھال قايتا قوزغىتىڭ."
 
 #: optlingu.src
 msgctxt ""
@@ -800,10 +810,10 @@ msgstr "شەخسىيلەشتۈرۈش"
 msgctxt ""
 "treeopt.src\n"
 "RID_OFADLG_OPTIONS_TREE_PAGES.SID_GENERAL_OPTIONS\n"
-"Appearance\n"
+"Application Colors\n"
 "itemlist.text"
-msgid "Appearance"
-msgstr "قىياپەت"
+msgid "Application Colors"
+msgstr ""
 
 #: treeopt.src
 msgctxt ""
diff --git a/source/ug/cui/source/tabpages.po b/source/ug/cui/source/tabpages.po
index 4705abf8577..551645d787a 100644
--- a/source/ug/cui/source/tabpages.po
+++ b/source/ug/cui/source/tabpages.po
@@ -3,8 +3,8 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2015-06-24 17:06+0200\n"
-"PO-Revision-Date: 2014-11-19 19:08+0000\n"
+"POT-Creation-Date: 2015-11-10 19:33+0100\n"
+"PO-Revision-Date: 2015-06-26 03:51+0000\n"
 "Last-Translator: system user <>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: ug\n"
@@ -14,7 +14,7 @@ msgstr ""
 "Plural-Forms: nplurals=1; plural=0;\n"
 "X-Generator: Pootle 2.7\n"
 "X-Accelerator-Marker: ~\n"
-"X-POOTLE-MTIME: 1416424101.000000\n"
+"X-POOTLE-MTIME: 1435290662.000000\n"
 
 #: border.src
 msgctxt ""
@@ -966,7 +966,7 @@ msgctxt ""
 "strings.src\n"
 "RID_SVXSTR_CHARNAME_HIGHLIGHTING\n"
 "string.text"
-msgid "Highlighting Color"
+msgid "Highlight Color"
 msgstr ""
 
 #: strings.src
@@ -1086,8 +1086,8 @@ msgctxt ""
 "strings.src\n"
 "RID_SVXSTR_NUM\n"
 "string.text"
-msgid "Apply numbering - symbol: "
-msgstr "تەرتىپ نومۇرى - بەلگە قوللان: "
+msgid "Bulleted and numbered lists. Bullet symbol: "
+msgstr ""
 
 #: strings.src
 msgctxt ""
diff --git a/source/ug/cui/uiconfig/ui.po b/source/ug/cui/uiconfig/ui.po
index f1bf0e94399..50c99810d14 100644
--- a/source/ug/cui/uiconfig/ui.po
+++ b/source/ug/cui/uiconfig/ui.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: LibO 40l10n\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2015-08-25 12:33+0200\n"
+"POT-Creation-Date: 2015-11-16 19:02+0100\n"
 "PO-Revision-Date: 2015-06-26 03:57+0000\n"
 "Last-Translator: system user <>\n"
 "Language-Team: none\n"
@@ -4040,6 +4040,15 @@ msgid "Menus"
 msgstr "تىزىملىك"
 
 #: customizedialog.ui
+msgctxt ""
+"customizedialog.ui\n"
+"contextmenus\n"
+"label\n"
+"string.text"
+msgid "Context Menus"
+msgstr ""
+
+#: customizedialog.ui
 #, fuzzy
 msgctxt ""
 "customizedialog.ui\n"
@@ -5266,13 +5275,14 @@ msgid "_All fields"
 msgstr ""
 
 #: fmsearchdialog.ui
+#, fuzzy
 msgctxt ""
 "fmsearchdialog.ui\n"
 "ftForm\n"
 "label\n"
 "string.text"
 msgid "Form:"
-msgstr ""
+msgstr "غا(_O)"
 
 #: fmsearchdialog.ui
 msgctxt ""
@@ -7276,6 +7286,15 @@ msgstr "قىستۇرما دېتال قىستۇر"
 #: insertplugin.ui
 msgctxt ""
 "insertplugin.ui\n"
+"label3\n"
+"label\n"
+"string.text"
+msgid "Warning: Plugins may not work on all platforms and may be removed in the future"
+msgstr ""
+
+#: insertplugin.ui
+msgctxt ""
+"insertplugin.ui\n"
 "urlbtn\n"
 "label\n"
 "string.text"
@@ -10768,40 +10787,44 @@ msgid "Help Improve %PRODUCTNAME"
 msgstr ""
 
 #: opthtmlpage.ui
+#, fuzzy
 msgctxt ""
 "opthtmlpage.ui\n"
 "size7FT\n"
 "label\n"
 "string.text"
 msgid "Size _7:"
-msgstr ""
+msgstr "سىزىق _3"
 
 #: opthtmlpage.ui
+#, fuzzy
 msgctxt ""
 "opthtmlpage.ui\n"
 "size6FT\n"
 "label\n"
 "string.text"
 msgid "Size _6:"
-msgstr ""
+msgstr "سىزىق _3"
 
 #: opthtmlpage.ui
+#, fuzzy
 msgctxt ""
 "opthtmlpage.ui\n"
 "size5FT\n"
 "label\n"
 "string.text"
 msgid "Size _5:"
-msgstr ""
+msgstr "سىزىق _3"
 
 #: opthtmlpage.ui
+#, fuzzy
 msgctxt ""
 "opthtmlpage.ui\n"
 "size4FT\n"
 "label\n"
 "string.text"
 msgid "Size _4:"
-msgstr ""
+msgstr "سىزىق _3"
 
 #: opthtmlpage.ui
 #, fuzzy
@@ -12742,7 +12765,7 @@ msgctxt ""
 "useopengl\n"
 "label\n"
 "string.text"
-msgid "Use OpenGL for all rendering"
+msgid "Use OpenGL for all rendering (on restart)"
 msgstr ""
 
 #: optviewpage.ui
@@ -12751,7 +12774,7 @@ msgctxt ""
 "forceopengl\n"
 "label\n"
 "string.text"
-msgid "Force OpenGL even if blacklisted"
+msgid "Force OpenGL even if blacklisted (on restart)"
 msgstr ""
 
 #: optviewpage.ui
@@ -12764,6 +12787,24 @@ msgid "Enabling this may expose driver bugs"
 msgstr ""
 
 #: optviewpage.ui
+msgctxt ""
+"optviewpage.ui\n"
+"openglenabled\n"
+"label\n"
+"string.text"
+msgid "Current GL status: Enabled"
+msgstr ""
+
+#: optviewpage.ui
+msgctxt ""
+"optviewpage.ui\n"
+"opengldisabled\n"
+"label\n"
+"string.text"
+msgid "Current GL status: Disabled"
+msgstr ""
+
+#: optviewpage.ui
 #, fuzzy
 msgctxt ""
 "optviewpage.ui\n"
@@ -15689,6 +15730,51 @@ msgstr ""
 #: slantcornertabpage.ui
 msgctxt ""
 "slantcornertabpage.ui\n"
+"label5\n"
+"label\n"
+"string.text"
+msgid "_X:"
+msgstr ""
+
+#: slantcornertabpage.ui
+msgctxt ""
+"slantcornertabpage.ui\n"
+"controlx1\n"
+"text\n"
+"string.text"
+msgid "0.00"
+msgstr ""
+
+#: slantcornertabpage.ui
+msgctxt ""
+"slantcornertabpage.ui\n"
+"label6\n"
+"label\n"
+"string.text"
+msgid "_Y:"
+msgstr ""
+
+#: slantcornertabpage.ui
+msgctxt ""
+"slantcornertabpage.ui\n"
+"controly1\n"
+"text\n"
+"string.text"
+msgid "0.00"
+msgstr ""
+
+#: slantcornertabpage.ui
+msgctxt ""
+"slantcornertabpage.ui\n"
+"label3\n"
+"label\n"
+"string.text"
+msgid "Control Point 1"
+msgstr ""
+
+#: slantcornertabpage.ui
+msgctxt ""
+"slantcornertabpage.ui\n"
 "FT_RADIUS\n"
 "label\n"
 "string.text"
@@ -15698,6 +15784,15 @@ msgstr ""
 #: slantcornertabpage.ui
 msgctxt ""
 "slantcornertabpage.ui\n"
+"MTR_FLD_RADIUS\n"
+"text\n"
+"string.text"
+msgid "0.00"
+msgstr ""
+
+#: slantcornertabpage.ui
+msgctxt ""
+"slantcornertabpage.ui\n"
 "label1\n"
 "label\n"
 "string.text"
@@ -15716,12 +15811,66 @@ msgstr ""
 #: slantcornertabpage.ui
 msgctxt ""
 "slantcornertabpage.ui\n"
+"MTR_FLD_ANGLE\n"
+"text\n"
+"string.text"
+msgid "0.00"
+msgstr ""
+
+#: slantcornertabpage.ui
+msgctxt ""
+"slantcornertabpage.ui\n"
 "label2\n"
 "label\n"
 "string.text"
 msgid "Slant"
 msgstr ""
 
+#: slantcornertabpage.ui
+msgctxt ""
+"slantcornertabpage.ui\n"
+"label4\n"
+"label\n"
+"string.text"
+msgid "_X:"
+msgstr ""
+
+#: slantcornertabpage.ui
+msgctxt ""
+"slantcornertabpage.ui\n"
+"controlx2\n"
+"text\n"
+"string.text"
+msgid "0.00"
+msgstr ""
+
+#: slantcornertabpage.ui
+msgctxt ""
+"slantcornertabpage.ui\n"
+"label7\n"
+"label\n"
+"string.text"
+msgid "_Y:"
+msgstr ""
+
+#: slantcornertabpage.ui
+msgctxt ""
+"slantcornertabpage.ui\n"
+"controly2\n"
+"text\n"
+"string.text"
+msgid "0.00"
+msgstr ""
+
+#: slantcornertabpage.ui
+msgctxt ""
+"slantcornertabpage.ui\n"
+"label8\n"
+"label\n"
+"string.text"
+msgid "Control Point 2"
+msgstr ""
+
 #: smarttagoptionspage.ui
 msgctxt ""
 "smarttagoptionspage.ui\n"
@@ -15885,15 +16034,6 @@ msgstr "تاللانما(_P)…"
 #: spellingdialog.ui
 msgctxt ""
 "spellingdialog.ui\n"
-"notindictft\n"
-"label\n"
-"string.text"
-msgid "_Not in dictionary"
-msgstr "لۇغەتتە يوق(_N)"
-
-#: spellingdialog.ui
-msgctxt ""
-"spellingdialog.ui\n"
 "ignore\n"
 "label\n"
 "string.text"
@@ -15901,15 +16041,6 @@ msgid "_Ignore Once"
 msgstr "بىر قېتىم پەرۋا قىلما(_I)"
 
 #: spellingdialog.ui
-msgctxt ""
-"spellingdialog.ui\n"
-"suggestionsft\n"
-"label\n"
-"string.text"
-msgid "_Suggestions"
-msgstr "تەكلىپ(_S)"
-
-#: spellingdialog.ui
 #, fuzzy
 msgctxt ""
 "spellingdialog.ui\n"
@@ -16030,6 +16161,43 @@ msgctxt ""
 msgid "_Add to Dictionary"
 msgstr "لۇغەتكە قوش(_A)"
 
+#: spellingdialog.ui
+msgctxt ""
+"spellingdialog.ui\n"
+"suggestionsft\n"
+"label\n"
+"string.text"
+msgid "_Suggestions"
+msgstr "تەكلىپ(_S)"
+
+#: spellingdialog.ui
+msgctxt ""
+"spellingdialog.ui\n"
+"notindictft\n"
+"label\n"
+"string.text"
+msgid "_Not in dictionary"
+msgstr "لۇغەتتە يوق(_N)"
+
+#: spellingdialog.ui
+msgctxt ""
+"spellingdialog.ui\n"
+"paste\n"
+"label\n"
+"string.text"
+msgid "Paste"
+msgstr ""
+
+#: spellingdialog.ui
+#, fuzzy
+msgctxt ""
+"spellingdialog.ui\n"
+"insert\n"
+"label\n"
+"string.text"
+msgid "Special Character"
+msgstr "ئالاھىدە ھەرپلەر"
+
 #: spelloptionsdialog.ui
 msgctxt ""
 "spelloptionsdialog.ui\n"
@@ -17612,131 +17780,3 @@ msgctxt ""
 "string.text"
 msgid "View Layout"
 msgstr "كۆرۈنۈش ئۇسلۇبى"
-
-msgctxt ""
-"backgroundpage.ui\n"
-"paralb\n"
-"0\n"
-"stringlist.text"
-msgid "Paragraph"
-msgstr "ئابزاس"
-
-msgctxt ""
-"backgroundpage.ui\n"
-"paralb\n"
-"1\n"
-"stringlist.text"
-msgid "Character"
-msgstr "ھەرپ"
-
-msgctxt ""
-"backgroundpage.ui\n"
-"label7\n"
-"label\n"
-"string.text"
-msgid "Transparency"
-msgstr "سۈزۈكلۈك"
-
-msgctxt ""
-"optaccessibilitypage.ui\n"
-"tiphelptimeout\n"
-"label\n"
-"string.text"
-msgid "_Help tips disappear after"
-msgstr "ياردەم ئەسكەرتىشى قانچىلىك ۋاقىتتا يوقايدۇ(_H)"
-
-msgctxt ""
-"optaccessibilitypage.ui\n"
-"label3\n"
-"label\n"
-"string.text"
-msgid "seconds"
-msgstr "سېكۇنت"
-
-msgctxt ""
-"optgeneralpage.ui\n"
-"tooltips\n"
-"label\n"
-"string.text"
-msgid "_Tips"
-msgstr "ئەسكەرتىش(_T)"
-
-#, fuzzy
-msgctxt ""
-"opthtmlpage.ui\n"
-"export\n"
-"2\n"
-"stringlist.text"
-msgid "%PRODUCTNAME Writer"
-msgstr "%PRODUCTNAME يازغۇچ تىزىملىكى"
-
-#, fuzzy
-msgctxt ""
-"optmemorypage.ui\n"
-"label5\n"
-"label\n"
-"string.text"
-msgid "_Number of steps:"
-msgstr "قەدەم سانى(_N)"
-
-msgctxt ""
-"optmemorypage.ui\n"
-"label1\n"
-"label\n"
-"string.text"
-msgid "Undo"
-msgstr "يېنىۋال"
-
-#, fuzzy
-msgctxt ""
-"optviewpage.ui\n"
-"trans\n"
-"label\n"
-"string.text"
-msgid "_Transparency:"
-msgstr "سۈزۈكلۈك(_T)"
-
-msgctxt ""
-"optviewpage.ui\n"
-"showfonthistory\n"
-"label\n"
-"string.text"
-msgid "Show font h_istory"
-msgstr "خەت نۇسخا تارىخىنى كۆرسەت(_I)"
-
-#: backgroundpage.ui
-#, fuzzy
-msgctxt ""
-"backgroundpage.ui\n"
-"transparencyft\n"
-"label\n"
-"string.text"
-msgid "_Transparency:"
-msgstr "سۈزۈكلۈك(_T)"
-
-#: opthtmlpage.ui
-msgctxt ""
-"opthtmlpage.ui\n"
-"export\n"
-"0\n"
-"stringlist.text"
-msgid "Microsoft Internet Explorer"
-msgstr ""
-
-#: opthtmlpage.ui
-msgctxt ""
-"opthtmlpage.ui\n"
-"export\n"
-"1\n"
-"stringlist.text"
-msgid "Mozilla Firefox"
-msgstr ""
-
-#: optviewpage.ui
-msgctxt ""
-"optviewpage.ui\n"
-"label14\n"
-"label\n"
-"string.text"
-msgid "Selection"
-msgstr "تاللا"
diff --git a/source/ug/dictionaries/is.po b/source/ug/dictionaries/is.po
index 8b36f65e37c..85a8a265614 100644
--- a/source/ug/dictionaries/is.po
+++ b/source/ug/dictionaries/is.po
@@ -3,23 +3,23 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2013-11-20 13:01+0100\n"
+"POT-Creation-Date: 2015-11-10 19:33+0100\n"
 "PO-Revision-Date: 2013-06-08 13:09+0000\n"
-"Last-Translator: Abduqadir <Sahran@live.com>\n"
+"Last-Translator: Abduqadir Abliz <Sahran@live.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: ug\n"
 "MIME-Version: 1.0\n"
 "Content-Type: text/plain; charset=UTF-8\n"
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=1; plural=0;\n"
-"X-Generator: LibreOffice\n"
+"X-Generator: Pootle 2.7\n"
 "X-Accelerator-Marker: ~\n"
-"X-POOTLE-MTIME: 1370696981.0\n"
+"X-POOTLE-MTIME: 1370696981.000000\n"
 
 #: description.xml
 msgctxt ""
 "description.xml\n"
 "dispname\n"
 "description.text"
-msgid "Icelandic spelling dictionary and thesaurus"
-msgstr "ئىسلاندىيەچە ئىملا لۇغىتى ۋە مەنىداش سۆزلەر لۇغىتى"
+msgid "Icelandic spelling dictionary, hyphenation rules and thesaurus"
+msgstr ""
diff --git a/source/ug/dictionaries/sv_SE.po b/source/ug/dictionaries/sv_SE.po
index 212b9c23383..6e7e35f8296 100644
--- a/source/ug/dictionaries/sv_SE.po
+++ b/source/ug/dictionaries/sv_SE.po
@@ -2,23 +2,25 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: LibO 350-l10n\n"
-"Report-Msgid-Bugs-To: https://bugs.freedesktop.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2013-05-23 12:05+0200\n"
-"PO-Revision-Date: 2011-12-14 05:30+0200\n"
-"Last-Translator: Abduqadir <Sahran@live.com>\n"
+"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
+"POT-Creation-Date: 2015-11-10 19:33+0100\n"
+"PO-Revision-Date: 2013-05-24 01:07+0000\n"
+"Last-Translator: system user <>\n"
 "Language-Team: none\n"
 "Language: ug\n"
 "MIME-Version: 1.0\n"
 "Content-Type: text/plain; charset=UTF-8\n"
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=1; plural=0;\n"
-"X-Generator: LibreOffice\n"
+"X-Generator: Pootle 2.7\n"
 "X-Accelerator-Marker: ~\n"
+"X-POOTLE-MTIME: 1369357676.000000\n"
 
 #: description.xml
+#, fuzzy
 msgctxt ""
 "description.xml\n"
 "dispname\n"
 "description.text"
-msgid "Swedish spelling dictionary, and thesaurus"
+msgid "Swedish spelling dictionary, hyphenation and thesaurus"
 msgstr "شۋېدچە ئىملا ۋە مەنىداش سۆزلەر لۇغىتى"
diff --git a/source/ug/editeng/source/editeng.po b/source/ug/editeng/source/editeng.po
index 8e127f22ba9..b41e5e90c50 100644
--- a/source/ug/editeng/source/editeng.po
+++ b/source/ug/editeng/source/editeng.po
@@ -2,19 +2,19 @@
 msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
-"Report-Msgid-Bugs-To: https://bugs.freedesktop.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2013-05-23 12:05+0200\n"
+"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
+"POT-Creation-Date: 2015-11-10 19:33+0100\n"
 "PO-Revision-Date: 2013-05-29 03:12+0000\n"
-"Last-Translator: Abduqadir <Sahran@live.com>\n"
+"Last-Translator: system user <>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: ug\n"
 "MIME-Version: 1.0\n"
 "Content-Type: text/plain; charset=UTF-8\n"
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=1; plural=0;\n"
-"X-Generator: LibreOffice\n"
+"X-Generator: Pootle 2.7\n"
 "X-Accelerator-Marker: ~\n"
-"X-POOTLE-MTIME: 1369797131.0\n"
+"X-POOTLE-MTIME: 1369797131.000000\n"
 
 #: editeng.src
 msgctxt ""
@@ -89,13 +89,14 @@ msgid "Change Case"
 msgstr "چوڭ/كىچىك يېزىلىشىنى ئۆزگەرت"
 
 #: editeng.src
+#, fuzzy
 msgctxt ""
 "editeng.src\n"
 "RID_MENU_SPELL\n"
-"MN_SPELLING\n"
+"MN_IGNORE\n"
 "menuitem.text"
-msgid "~Spellcheck..."
-msgstr "ئىملا تەكشۈر(~S)…"
+msgid "I~gnore All"
+msgstr "ھەممىگە پەرۋا قىلما"
 
 #: editeng.src
 msgctxt ""
@@ -119,10 +120,10 @@ msgstr "لۇغەتكە قوش (~A)"
 msgctxt ""
 "editeng.src\n"
 "RID_MENU_SPELL\n"
-"MN_IGNORE\n"
+"MN_SPELLING\n"
 "menuitem.text"
-msgid "Ignore All"
-msgstr "ھەممىگە پەرۋا قىلما"
+msgid "~Spellcheck..."
+msgstr "ئىملا تەكشۈر(~S)…"
 
 #: editeng.src
 msgctxt ""
@@ -130,8 +131,17 @@ msgctxt ""
 "RID_MENU_SPELL\n"
 "MN_AUTOCORR\n"
 "menuitem.text"
-msgid "AutoCorrect"
-msgstr "ئاپتۇماتىك تۈزەت"
+msgid "AutoCorrect ~To"
+msgstr ""
+
+#: editeng.src
+msgctxt ""
+"editeng.src\n"
+"RID_MENU_SPELL\n"
+"MN_AUTO_CORRECT_DLG\n"
+"menuitem.text"
+msgid "Auto~Correct Options..."
+msgstr ""
 
 #: editeng.src
 msgctxt ""
diff --git a/source/ug/extensions/uiconfig/sabpilot/ui.po b/source/ug/extensions/uiconfig/sabpilot/ui.po
index 12eb9e8337e..ec55d515a52 100644
--- a/source/ug/extensions/uiconfig/sabpilot/ui.po
+++ b/source/ug/extensions/uiconfig/sabpilot/ui.po
@@ -3,8 +3,8 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2015-06-24 17:05+0200\n"
-"PO-Revision-Date: 2014-11-19 19:11+0000\n"
+"POT-Creation-Date: 2015-11-10 19:33+0100\n"
+"PO-Revision-Date: 2015-06-26 03:57+0000\n"
 "Last-Translator: system user <>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: ug\n"
@@ -14,7 +14,7 @@ msgstr ""
 "Plural-Forms: nplurals=1; plural=0;\n"
 "X-Generator: Pootle 2.7\n"
 "X-Accelerator-Marker: ~\n"
-"X-POOTLE-MTIME: 1416424309.000000\n"
+"X-POOTLE-MTIME: 1435291064.000000\n"
 
 #: contentfieldpage.ui
 msgctxt ""
@@ -596,33 +596,6 @@ msgstr ""
 #: selecttypepage.ui
 msgctxt ""
 "selecttypepage.ui\n"
-"ldap\n"
-"label\n"
-"string.text"
-msgid "LDAP address data"
-msgstr ""
-
-#: selecttypepage.ui
-msgctxt ""
-"selecttypepage.ui\n"
-"outlook\n"
-"label\n"
-"string.text"
-msgid "Outlook address book"
-msgstr ""
-
-#: selecttypepage.ui
-msgctxt ""
-"selecttypepage.ui\n"
-"windows\n"
-"label\n"
-"string.text"
-msgid "Windows system address book"
-msgstr ""
-
-#: selecttypepage.ui
-msgctxt ""
-"selecttypepage.ui\n"
 "other\n"
 "label\n"
 "string.text"
diff --git a/source/ug/extras/source/autocorr/emoji.po b/source/ug/extras/source/autocorr/emoji.po
index 10b9a5d4ba7..ac6f1ef7d90 100644
--- a/source/ug/extras/source/autocorr/emoji.po
+++ b/source/ug/extras/source/autocorr/emoji.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2015-09-02 13:03+0200\n"
+"POT-Creation-Date: 2015-11-10 19:32+0100\n"
 "PO-Revision-Date: 2015-06-26 04:00+0000\n"
 "Last-Translator: system user <>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -638,8 +638,8 @@ msgctxt ""
 "emoji.ulf\n"
 "HORIZONTAL_ELLIPSIS\n"
 "LngText.text"
-msgid "…"
-msgstr "…"
+msgid "."
+msgstr "."
 
 #. ‰ (U+02030), see http://wiki.documentfoundation.org/Emoji
 #: emoji.ulf
diff --git a/source/ug/filter/source/config/fragments/filters.po b/source/ug/filter/source/config/fragments/filters.po
index 6d9582136ab..94ea26fb09a 100644
--- a/source/ug/filter/source/config/fragments/filters.po
+++ b/source/ug/filter/source/config/fragments/filters.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2015-08-25 12:34+0200\n"
+"POT-Creation-Date: 2015-11-10 19:33+0100\n"
 "PO-Revision-Date: 2015-05-14 04:32+0000\n"
 "Last-Translator: system user <>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -468,22 +468,24 @@ msgid "Microsoft Excel 97-2003 Template"
 msgstr "Microsoft Excel 95 قېلىپى"
 
 #: MS_PowerPoint_97.xcu
+#, fuzzy
 msgctxt ""
 "MS_PowerPoint_97.xcu\n"
 "MS PowerPoint 97\n"
 "UIName\n"
 "value.text"
 msgid "Microsoft PowerPoint 97-2003"
-msgstr ""
+msgstr "Microsoft PowerPoint 97/2000/XP/2003 قېلىپى"
 
 #: MS_PowerPoint_97_AutoPlay.xcu
+#, fuzzy
 msgctxt ""
 "MS_PowerPoint_97_AutoPlay.xcu\n"
 "MS PowerPoint 97 AutoPlay\n"
 "UIName\n"
 "value.text"
 msgid "Microsoft PowerPoint 97-2003 AutoPlay"
-msgstr ""
+msgstr "Microsoft PowerPoint 97/2000/XP/2003 قېلىپى"
 
 #: MS_PowerPoint_97_Vorlage.xcu
 #, fuzzy
@@ -533,13 +535,14 @@ msgid "Microsoft Word 2007-2013 XML"
 msgstr "Microsoft Word 2003 XML"
 
 #: MS_Word_2007_XML_Template.xcu
+#, fuzzy
 msgctxt ""
 "MS_Word_2007_XML_Template.xcu\n"
 "MS Word 2007 XML Template\n"
 "UIName\n"
 "value.text"
 msgid "Microsoft Word 2007-2013 XML Template"
-msgstr ""
+msgstr "Microsoft Word 95 قېلىپى"
 
 #: MS_Word_95.xcu
 msgctxt ""
@@ -596,6 +599,15 @@ msgctxt ""
 msgid "Microsoft Works Document"
 msgstr ""
 
+#: MS_Write.xcu
+msgctxt ""
+"MS_Write.xcu\n"
+"MS_Write\n"
+"UIName\n"
+"value.text"
+msgid "Microsoft Write"
+msgstr ""
+
 #: MacDoc.xcu
 msgctxt ""
 "MacDoc.xcu\n"
@@ -1316,6 +1328,15 @@ msgctxt ""
 msgid "ODF Spreadsheet Template"
 msgstr "ODF ئېلېكترونلۇق جەدۋەل قېلىپى"
 
+#: calc_Gnumeric.xcu
+msgctxt ""
+"calc_Gnumeric.xcu\n"
+"Gnumeric Spreadsheet\n"
+"UIName\n"
+"value.text"
+msgid "Gnumeric Spreadsheet"
+msgstr ""
+
 #: calc_HTML_WebQuery.xcu
 msgctxt ""
 "calc_HTML_WebQuery.xcu\n"
@@ -1334,6 +1355,15 @@ msgctxt ""
 msgid "Microsoft Excel 2007 Binary"
 msgstr "Microsoft Excel 2007 ئىككىلىك سىستېما"
 
+#: calc_MS_Excel_2007_VBA_XML.xcu
+msgctxt ""
+"calc_MS_Excel_2007_VBA_XML.xcu\n"
+"Calc MS Excel 2007 VBA XML\n"
+"UIName\n"
+"value.text"
+msgid "Microsoft Excel 2007-2016 XML (macro enabled)"
+msgstr ""
+
 #: calc_MS_Excel_2007_XML.xcu
 #, fuzzy
 msgctxt ""
@@ -1345,13 +1375,14 @@ msgid "Microsoft Excel 2007-2013 XML"
 msgstr "Microsoft Excel 2003 XML"
 
 #: calc_MS_Excel_2007_XML_Template.xcu
+#, fuzzy
 msgctxt ""
 "calc_MS_Excel_2007_XML_Template.xcu\n"
 "Calc MS Excel 2007 XML Template\n"
 "UIName\n"
 "value.text"
 msgid "Microsoft Excel 2007-2013 XML Template"
-msgstr ""
+msgstr "Microsoft Excel 95 قېلىپى"
 
 #: calc_OOXML.xcu
 msgctxt ""
@@ -1389,6 +1420,15 @@ msgctxt ""
 msgid "PDF - Portable Document Format"
 msgstr ""
 
+#: calc_png_Export.xcu
+msgctxt ""
+"calc_png_Export.xcu\n"
+"calc_png_Export\n"
+"UIName\n"
+"value.text"
+msgid "PNG - Portable Network Graphic"
+msgstr ""
+
 #: chart8.xcu
 msgctxt ""
 "chart8.xcu\n"
@@ -1687,13 +1727,14 @@ msgid "ODF Presentation Template"
 msgstr "ODF كۆرسەتمە قېلىپى"
 
 #: impress_MS_PowerPoint_2007_XML.xcu
+#, fuzzy
 msgctxt ""
 "impress_MS_PowerPoint_2007_XML.xcu\n"
 "Impress MS PowerPoint 2007 XML\n"
 "UIName\n"
 "value.text"
 msgid "Microsoft PowerPoint 2007-2013 XML"
-msgstr ""
+msgstr "Microsoft Word 2003 XML"
 
 #: impress_MS_PowerPoint_2007_XML_AutoPlay.xcu
 msgctxt ""
@@ -1705,13 +1746,14 @@ msgid "Microsoft PowerPoint 2007-2013 XML AutoPlay"
 msgstr ""
 
 #: impress_MS_PowerPoint_2007_XML_Template.xcu
+#, fuzzy
 msgctxt ""
 "impress_MS_PowerPoint_2007_XML_Template.xcu\n"
 "Impress MS PowerPoint 2007 XML Template\n"
 "UIName\n"
 "value.text"
 msgid "Microsoft PowerPoint 2007-2013 XML Template"
-msgstr ""
+msgstr "Microsoft PowerPoint 97/2000/XP/2003 قېلىپى"
 
 #: impress_OOXML.xcu
 msgctxt ""
@@ -2173,12 +2215,3 @@ msgctxt ""
 "value.text"
 msgid "zTXT eBook"
 msgstr ""
-
-#: Mac_RagTime.xcu
-msgctxt ""
-"Mac_RagTime.xcu\n"
-"Mac_RagTime\n"
-"UIName\n"
-"value.text"
-msgid "RagTime Mac v2-3 Document"
-msgstr ""
diff --git a/source/ug/filter/source/config/fragments/types.po b/source/ug/filter/source/config/fragments/types.po
index 20774bed2e8..dc6ceaa330b 100644
--- a/source/ug/filter/source/config/fragments/types.po
+++ b/source/ug/filter/source/config/fragments/types.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2015-04-22 23:40+0200\n"
+"POT-Creation-Date: 2015-11-10 19:33+0100\n"
 "PO-Revision-Date: 2015-05-14 04:32+0000\n"
 "Last-Translator: system user <>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -25,6 +25,16 @@ msgctxt ""
 msgid "Microsoft Excel 2007 Binary"
 msgstr "Microsoft Excel 2007 ئىككىلىك ھۆججەت"
 
+#: MS_Excel_2007_VBA_XML.xcu
+#, fuzzy
+msgctxt ""
+"MS_Excel_2007_VBA_XML.xcu\n"
+"MS Excel 2007 VBA XML\n"
+"UIName\n"
+"value.text"
+msgid "Microsoft Excel 2007-2016 VBA XML"
+msgstr "Microsoft Excel 2003 XML"
+
 #: MS_Excel_2007_XML.xcu
 #, fuzzy
 msgctxt ""
@@ -36,31 +46,34 @@ msgid "Microsoft Excel 2007-2013 XML"
 msgstr "Microsoft Excel 2003 XML"
 
 #: MS_Excel_2007_XML_Template.xcu
+#, fuzzy
 msgctxt ""
 "MS_Excel_2007_XML_Template.xcu\n"
 "MS Excel 2007 XML Template\n"
 "UIName\n"
 "value.text"
 msgid "Microsoft Excel 2007-2013 XML Template"
-msgstr ""
+msgstr "Microsoft Excel 2003 XML"
 
 #: MS_PowerPoint_2007_XML.xcu
+#, fuzzy
 msgctxt ""
 "MS_PowerPoint_2007_XML.xcu\n"
 "MS PowerPoint 2007 XML\n"
 "UIName\n"
 "value.text"
 msgid "Microsoft PowerPoint 2007-2013 XML"
-msgstr ""
+msgstr "Microsoft Word 2003 XML"
 
 #: MS_PowerPoint_2007_XML_AutoPlay.xcu
+#, fuzzy
 msgctxt ""
 "MS_PowerPoint_2007_XML_AutoPlay.xcu\n"
 "MS PowerPoint 2007 XML AutoPlay\n"
 "UIName\n"
 "value.text"
 msgid "Microsoft PowerPoint 2007-2013 XML"
-msgstr ""
+msgstr "Microsoft Word 2003 XML"
 
 #: MS_PowerPoint_2007_XML_Template.xcu
 msgctxt ""
@@ -117,6 +130,15 @@ msgctxt ""
 msgid "Calc 8 Template"
 msgstr "Calc 8 قېلىپى"
 
+#: calc_Gnumeric.xcu
+msgctxt ""
+"calc_Gnumeric.xcu\n"
+"Gnumeric XML\n"
+"UIName\n"
+"value.text"
+msgid "Gnumeric Spreadsheet"
+msgstr ""
+
 #: calc_MS_Excel_2003_XML.xcu
 msgctxt ""
 "calc_MS_Excel_2003_XML.xcu\n"
@@ -272,13 +294,14 @@ msgid "Microsoft Word 2007-2013 XML"
 msgstr "Microsoft Word 2003 XML"
 
 #: writer_MS_Word_2007_XML_Template.xcu
+#, fuzzy
 msgctxt ""
 "writer_MS_Word_2007_XML_Template.xcu\n"
 "writer_MS_Word_2007_Template\n"
 "UIName\n"
 "value.text"
 msgid "Microsoft Word 2007-2013 XML Template"
-msgstr ""
+msgstr "Microsoft Word 2003 XML"
 
 #: writer_ODT_FlatXML.xcu
 msgctxt ""
diff --git a/source/ug/formula/source/core/resource.po b/source/ug/formula/source/core/resource.po
index 34e3c0dd709..2030604f068 100644
--- a/source/ug/formula/source/core/resource.po
+++ b/source/ug/formula/source/core/resource.po
@@ -3,8 +3,8 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2015-06-24 17:06+0200\n"
-"PO-Revision-Date: 2015-05-14 04:33+0000\n"
+"POT-Creation-Date: 2015-11-10 19:32+0100\n"
+"PO-Revision-Date: 2015-06-26 04:01+0000\n"
 "Last-Translator: system user <>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: ug\n"
@@ -14,7 +14,7 @@ msgstr ""
 "Plural-Forms: nplurals=1; plural=0;\n"
 "X-Generator: Pootle 2.7\n"
 "X-Accelerator-Marker: ~\n"
-"X-POOTLE-MTIME: 1431577997.000000\n"
+"X-POOTLE-MTIME: 1435291304.000000\n"
 
 #: core_resource.src
 msgctxt ""
@@ -3160,6 +3160,15 @@ msgstr "WEEKNUM"
 msgctxt ""
 "core_resource.src\n"
 "RID_STRLIST_FUNCTION_NAMES\n"
+"SC_OPCODE_ISOWEEKNUM\n"
+"string.text"
+msgid "ISOWEEKNUM"
+msgstr ""
+
+#: core_resource.src
+msgctxt ""
+"core_resource.src\n"
+"RID_STRLIST_FUNCTION_NAMES\n"
 "SC_OPCODE_EASTERSUNDAY\n"
 "string.text"
 msgid "EASTERSUNDAY"
diff --git a/source/ug/helpcontent2/source/text/scalc.po b/source/ug/helpcontent2/source/text/scalc.po
index 71cd0874d14..b041ac56557 100644
--- a/source/ug/helpcontent2/source/text/scalc.po
+++ b/source/ug/helpcontent2/source/text/scalc.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2015-04-22 23:39+0200\n"
+"POT-Creation-Date: 2015-11-10 19:33+0100\n"
 "PO-Revision-Date: 2015-05-11 22:36+0000\n"
 "Last-Translator: system user <>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -104,77 +104,23 @@ msgid "File"
 msgstr "ھۆججەت"
 
 #: main0101.xhp
+#, fuzzy
 msgctxt ""
 "main0101.xhp\n"
 "hd_id3156023\n"
-"1\n"
 "help.text"
 msgid "<link href=\"text/scalc/main0101.xhp\" name=\"File\">File</link>"
 msgstr "<link href=\"text/scalc/main0101.xhp\" name=\"ھۆججەت\">ھۆججەت</link>"
 
 #: main0101.xhp
+#, fuzzy
 msgctxt ""
 "main0101.xhp\n"
 "par_id3151112\n"
-"2\n"
 "help.text"
 msgid "<ahelp hid=\".\">These commands apply to the current document, open a new document, or close the application.</ahelp>"
 msgstr "<ahelp hid=\".\">بۇ بۇيرۇقلار نۆۋەتتىكى پۈتۈككە ئىشلىتىلىدۇ، يېڭى پۈتۈك ئېچىش ياكى قوللىنىشچان پروگرامما يېپىش.</ahelp>"
 
-#: main0101.xhp
-msgctxt ""
-"main0101.xhp\n"
-"hd_id3154684\n"
-"4\n"
-"help.text"
-msgid "<link href=\"text/shared/01/01020000.xhp\" name=\"Open\">Open</link>"
-msgstr "<link href=\"text/shared/01/01020000.xhp\" name=\"ئاچ\">ئاچ</link>"
-
-#: main0101.xhp
-msgctxt ""
-"main0101.xhp\n"
-"hd_id3147434\n"
-"5\n"
-"help.text"
-msgid "<link href=\"text/shared/01/01070000.xhp\" name=\"Save As\">Save As</link>"
-msgstr "<link href=\"text/shared/01/01070000.xhp\" name=\"باشقا ئاتتا ساقلا\">باشقا ئاتتا ساقلا</link>"
-
-#: main0101.xhp
-msgctxt ""
-"main0101.xhp\n"
-"hd_id3147396\n"
-"11\n"
-"help.text"
-msgid "<link href=\"text/shared/01/01190000.xhp\" name=\"Versions\">Versions</link>"
-msgstr "<link href=\"text/shared/01/01190000.xhp\" name=\"نەشرى\">نەشرى</link>"
-
-#: main0101.xhp
-msgctxt ""
-"main0101.xhp\n"
-"hd_id3149400\n"
-"7\n"
-"help.text"
-msgid "<link href=\"text/shared/01/01100000.xhp\" name=\"Properties\">Properties</link>"
-msgstr "<link href=\"text/shared/01/01100000.xhp\" name=\"خاسلىق\">خاسلىق</link>"
-
-#: main0101.xhp
-msgctxt ""
-"main0101.xhp\n"
-"hd_id3155445\n"
-"9\n"
-"help.text"
-msgid "<link href=\"text/shared/01/01130000.xhp\" name=\"Print\">Print</link>"
-msgstr "<link href=\"text/shared/01/01130000.xhp\" name=\"باس\">باس</link>"
-
-#: main0101.xhp
-msgctxt ""
-"main0101.xhp\n"
-"hd_id3147339\n"
-"10\n"
-"help.text"
-msgid "<link href=\"text/shared/01/01140000.xhp\" name=\"Printer Setup\">Printer Setup</link>"
-msgstr "<link href=\"text/shared/01/01140000.xhp\" name=\"پرىنتېر تەڭشەك\">پرىنتېر تەڭشەك</link>"
-
 #: main0102.xhp
 msgctxt ""
 "main0102.xhp\n"
@@ -184,95 +130,50 @@ msgid "Edit"
 msgstr "تەھرىر"
 
 #: main0102.xhp
+#, fuzzy
 msgctxt ""
 "main0102.xhp\n"
 "hd_id3156023\n"
-"1\n"
 "help.text"
 msgid "<link href=\"text/scalc/main0102.xhp\" name=\"Edit\">Edit</link>"
 msgstr "<link href=\"text/scalc/main0102.xhp\" name=\"تەھرىر\">تەھرىر</link>"
 
 #: main0102.xhp
+#, fuzzy
 msgctxt ""
 "main0102.xhp\n"
 "par_id3154758\n"
-"2\n"
 "help.text"
 msgid "<ahelp hid=\".\">This menu contains commands for editing the contents of the current document.</ahelp>"
 msgstr "<ahelp hid=\".\">بۇ تىزىملىك نۆۋەتتىكى پۈتۈك مەزمۇنىنى تەھرىرلەشكە ئىشلىتىلىدىغان بۇيرۇقلارنى ئۆز ئىچىگە ئالىدۇ.</ahelp>"
 
 #: main0102.xhp
-msgctxt ""
-"main0102.xhp\n"
-"hd_id3146119\n"
-"3\n"
-"help.text"
-msgid "<link href=\"text/shared/01/02070000.xhp\" name=\"Paste Special\">Paste Special</link>"
-msgstr "<link href=\"text/shared/01/02070000.xhp\" name=\"ئۆزگىچە چاپلا\">ئۆزگىچە چاپلا</link>"
-
-#: main0102.xhp
-msgctxt ""
-"main0102.xhp\n"
-"hd_id3153728\n"
-"12\n"
-"help.text"
-msgid "<link href=\"text/shared/01/02240000.xhp\" name=\"Compare Document\">Compare Document</link>"
-msgstr "<link href=\"text/shared/01/02240000.xhp\" name=\"پۈتۈك سېلىشتۇر\">پۈتۈك سېلىشتۇر</link>"
-
-#: main0102.xhp
-msgctxt ""
-"main0102.xhp\n"
-"hd_id3154492\n"
-"4\n"
-"help.text"
-msgid "<link href=\"text/shared/01/02100000.xhp\" name=\"Find & Replace\">Find & Replace</link>"
-msgstr "<link href=\"text/shared/01/02100000.xhp\" name=\"ئىزدە & ئالماشتۇر\">ئىزدە & ئالماشتۇر</link>"
-
-#: main0102.xhp
-msgctxt ""
-"main0102.xhp\n"
-"hd_id3150715\n"
-"5\n"
-"help.text"
-msgid "<link href=\"text/scalc/01/02120000.xhp\" name=\"Headers & Footers\">Headers & Footers</link>"
-msgstr "<link href=\"text/scalc/01/02120000.xhp\" name=\"بەت قېشى & بەت ئاستى\">بەت قېشى & بەت ئاستى</link>"
-
-#: main0102.xhp
-msgctxt ""
-"main0102.xhp\n"
-"hd_id3149018\n"
-"6\n"
-"help.text"
-msgid "<link href=\"text/scalc/01/02150000.xhp\" name=\"Delete Contents\">Delete Contents</link>"
-msgstr "<link href=\"text/scalc/01/02150000.xhp\" name=\"مەزمۇننى ئۆچۈر\">مەزمۇننى ئۆچۈر</link>"
-
-#: main0102.xhp
-msgctxt ""
-"main0102.xhp\n"
-"hd_id3156384\n"
-"7\n"
-"help.text"
-msgid "<link href=\"text/scalc/01/02160000.xhp\" name=\"Delete Cells\">Delete Cells</link>"
-msgstr "<link href=\"text/scalc/01/02160000.xhp\" name=\"كاتەكچە ئۆچۈر\">كاتەكچە ئۆچۈر</link>"
-
-#: main0102.xhp
+#, fuzzy
 msgctxt ""
 "main0102.xhp\n"
 "hd_id3146919\n"
-"10\n"
 "help.text"
 msgid "<link href=\"text/shared/01/02180000.xhp\" name=\"Links\">Links</link>"
 msgstr "<link href=\"text/shared/01/02180000.xhp\" name=\"ئۇلىنىش\">ئۇلىنىش</link>"
 
 #: main0102.xhp
+#, fuzzy
 msgctxt ""
 "main0102.xhp\n"
 "hd_id3148488\n"
-"11\n"
 "help.text"
 msgid "<link href=\"text/shared/01/02220000.xhp\" name=\"ImageMap\">ImageMap</link>"
 msgstr "<link href=\"text/shared/01/02220000.xhp\" name=\"سۈرەت خەرىتە\">سۈرەت خەرىتە</link>"
 
+#: main0102.xhp
+#, fuzzy
+msgctxt ""
+"main0102.xhp\n"
+"hd_id0914201502131542\n"
+"help.text"
+msgid "<link href=\"text/shared/01/02200000.xhp\" name=\"Object\">Object</link>"
+msgstr "<link href=\"text/shared/01/01020000.xhp\" name=\"ئاچ\">ئاچ</link>"
+
 #: main0103.xhp
 msgctxt ""
 "main0103.xhp\n"
@@ -282,19 +183,19 @@ msgid "View"
 msgstr "كۆرۈنۈش"
 
 #: main0103.xhp
+#, fuzzy
 msgctxt ""
 "main0103.xhp\n"
 "hd_id3151112\n"
-"1\n"
 "help.text"
 msgid "<link href=\"text/scalc/main0103.xhp\" name=\"View\">View</link>"
 msgstr "<link href=\"text/scalc/main0103.xhp\" name=\"كۆرۈنۈش\">كۆرۈنۈش</link>"
 
 #: main0103.xhp
+#, fuzzy
 msgctxt ""
 "main0103.xhp\n"
 "par_id3149456\n"
-"2\n"
 "help.text"
 msgid "<ahelp hid=\".\">This menu contains commands for controlling the on-screen display of the document.</ahelp>"
 msgstr "<ahelp hid=\".\">بۇ تىزىملىك پۈتۈكنىڭ ئېكراندا كۆرۈنۈش شەكلىنى كونترول قىلىدىغان بۇيرۇقلارنى ئۆز ئىچىگە ئالىدۇ.</ahelp>"
@@ -308,18 +209,52 @@ msgid "Normal"
 msgstr "نورمال"
 
 #: main0103.xhp
+#, fuzzy
 msgctxt ""
 "main0103.xhp\n"
 "par_idN105AF\n"
 "help.text"
-msgid "<ahelp hid=\".\">Displays the normal view of the sheet.</ahelp>"
+msgid "<ahelp hid=\".\">Displays the normal layout view of the sheet.</ahelp>"
 msgstr "<ahelp hid=\".\">ۋاراقنىڭ ئادەتتىكى كۆرۈنۈشىنى كۆرسىتىدۇ.</ahelp>"
 
 #: main0103.xhp
+#, fuzzy
+msgctxt ""
+"main0103.xhp\n"
+"hd_id102720151109097115\n"
+"help.text"
+msgid "<link href=\"text/shared/01/03100000.xhp\">Page Break</link>"
+msgstr "<link href=\"text/shared/01/01020000.xhp\" name=\"ئاچ\">ئاچ</link>"
+
+#: main0103.xhp
+msgctxt ""
+"main0103.xhp\n"
+"hd_id10272015110909623\n"
+"help.text"
+msgid "Grid Lines for Sheet"
+msgstr ""
+
+#: main0103.xhp
+msgctxt ""
+"main0103.xhp\n"
+"par_id102720151147483554\n"
+"help.text"
+msgid "Toggle the visibility of grid lines for the current sheet."
+msgstr ""
+
+#: main0103.xhp
+msgctxt ""
+"main0103.xhp\n"
+"hd_id102720150908397549\n"
+"help.text"
+msgid "<link href=\"text/shared/01/gallery.xhp\">Clip Art Gallery</link>"
+msgstr ""
+
+#: main0103.xhp
+#, fuzzy
 msgctxt ""
 "main0103.xhp\n"
 "hd_id3125863\n"
-"3\n"
 "help.text"
 msgid "<link href=\"text/shared/01/03010000.xhp\" name=\"Zoom\">Zoom</link>"
 msgstr "<link href=\"text/shared/01/03010000.xhp\" name=\"چوڭايت تارايت\">چوڭايت تارايت</link>"
@@ -333,91 +268,82 @@ msgid "Insert"
 msgstr "قىستۇر"
 
 #: main0104.xhp
+#, fuzzy
 msgctxt ""
 "main0104.xhp\n"
 "hd_id3157909\n"
-"1\n"
 "help.text"
 msgid "<link href=\"text/scalc/main0104.xhp\" name=\"Insert\">Insert</link>"
 msgstr "<link href=\"text/scalc/main0104.xhp\" name=\"قىستۇر\">قىستۇر</link>"
 
 #: main0104.xhp
+#, fuzzy
 msgctxt ""
 "main0104.xhp\n"
 "par_id3153896\n"
-"2\n"
 "help.text"
 msgid "<ahelp hid=\".\">The Insert menu contains commands for inserting new elements, such as cells, rows, sheets and cell names into the current sheet.</ahelp>"
 msgstr "<ahelp hid=\".\">قىستۇر تىزىملىكى يېڭى ئېلېمېنت قىستۇرۇش بۇيرۇقىنى ئۆز ئىچىگە ئالىدۇ، مەسىلەن، نۆۋەتتىكى ۋاراققا كاتەكچە، قۇر، ۋاراق ۋە كاتەكچە ئاتى قىستۇرىدۇ.</ahelp>"
 
 #: main0104.xhp
+#, fuzzy
 msgctxt ""
 "main0104.xhp\n"
 "hd_id3150769\n"
-"3\n"
 "help.text"
 msgid "<link href=\"text/scalc/01/04020000.xhp\" name=\"Cells\">Cells</link>"
 msgstr "<link href=\"text/scalc/01/04020000.xhp\" name=\"كاتەكچە\">كاتەكچە</link>"
 
 #: main0104.xhp
+#, fuzzy
 msgctxt ""
 "main0104.xhp\n"
 "hd_id3149260\n"
-"4\n"
 "help.text"
 msgid "<link href=\"text/scalc/01/04050000.xhp\" name=\"Sheet\">Sheet</link>"
 msgstr "<link href=\"text/scalc/01/04050000.xhp\" name=\"ۋاراق\">ۋاراق</link>"
 
 #: main0104.xhp
+#, fuzzy
 msgctxt ""
 "main0104.xhp\n"
 "hd_id3153726\n"
-"7\n"
 "help.text"
 msgid "<link href=\"text/shared/01/04100000.xhp\" name=\"Special Character\">Special Character</link>"
 msgstr "<link href=\"text/shared/01/04100000.xhp\" name=\"ئالاھىدە ھەرپلەر\">ئالاھىدە ھەرپلەر</link>"
 
 #: main0104.xhp
+#, fuzzy
 msgctxt ""
 "main0104.xhp\n"
 "hd_id3156285\n"
-"13\n"
 "help.text"
 msgid "<link href=\"text/shared/02/09070000.xhp\" name=\"Hyperlink\">Hyperlink</link>"
 msgstr "<link href=\"text/shared/02/09070000.xhp\" name=\"ئۇلانما\">ئۇلانما</link>"
 
 #: main0104.xhp
+#, fuzzy
 msgctxt ""
 "main0104.xhp\n"
 "hd_id3154492\n"
-"5\n"
 "help.text"
 msgid "<link href=\"text/scalc/01/04060000.xhp\" name=\"Function\">Function</link>"
 msgstr "<link href=\"text/scalc/01/04060000.xhp\" name=\"فۇنكسىيە\">فۇنكسىيە</link>"
 
 #: main0104.xhp
-msgctxt ""
-"main0104.xhp\n"
-"hd_id3154511\n"
-"12\n"
-"help.text"
-msgid "<link href=\"text/scalc/01/04080000.xhp\" name=\"Function List\">Function List</link>"
-msgstr "<link href=\"text/scalc/01/04080000.xhp\" name=\"فۇنكىسىيە تىزىملىكى\">فۇنكىسىيە تىزىملىكى</link>"
-
-#: main0104.xhp
+#, fuzzy
 msgctxt ""
 "main0104.xhp\n"
 "hd_id3145640\n"
-"6\n"
 "help.text"
 msgid "<link href=\"text/shared/01/04050000.xhp\" name=\"Comment\">Comment</link>"
 msgstr "<link href=\"text/shared/01/04050000.xhp\" name=\"Comment\">ئىزاھات</link>"
 
 #: main0104.xhp
+#, fuzzy
 msgctxt ""
 "main0104.xhp\n"
 "hd_id3146918\n"
-"11\n"
 "help.text"
 msgid "<link href=\"text/schart/01/wiz_chart_type.xhp\" name=\"Chart\">Chart</link>"
 msgstr "<link href=\"text/schart/01/wiz_chart_type.xhp\" name=\"دىئاگرامما\">دىئاگرامما</link>"
@@ -431,10 +357,10 @@ msgid "Inserts a chart."
 msgstr "بىر دىئاگرامما قىستۇرىدۇ."
 
 #: main0104.xhp
+#, fuzzy
 msgctxt ""
 "main0104.xhp\n"
 "hd_id3147003\n"
-"10\n"
 "help.text"
 msgid "<link href=\"text/shared/01/04160500.xhp\" name=\"Floating Frame\">Floating Frame</link>"
 msgstr "<link href=\"text/shared/01/04160500.xhp\" name=\"لەيلىمە رامكا\">لەيلىمە رامكا</link>"
@@ -448,91 +374,91 @@ msgid "Format"
 msgstr "پىچىم"
 
 #: main0105.xhp
+#, fuzzy
 msgctxt ""
 "main0105.xhp\n"
 "hd_id3149669\n"
-"1\n"
 "help.text"
 msgid "<link href=\"text/scalc/main0105.xhp\" name=\"Format\">Format</link>"
 msgstr "<link href=\"text/scalc/main0105.xhp\" name=\"پىچىم\">پىچىم</link>"
 
 #: main0105.xhp
+#, fuzzy
 msgctxt ""
 "main0105.xhp\n"
 "par_id3145171\n"
-"2\n"
 "help.text"
-msgid "<ahelp hid=\".uno:FormatMenu\">The <emph>Format</emph> menu contains commands for formatting selected cells, <link href=\"text/shared/00/00000005.xhp#objekt\" name=\"objects\">objects</link>, and cell contents in your document.</ahelp>"
+msgid "<ahelp hid=\".\">The <emph>Format</emph> menu contains commands for formatting selected cells, <link href=\"text/shared/00/00000005.xhp#objekt\" name=\"objects\">objects</link>, and cell contents in your document.</ahelp>"
 msgstr "<ahelp hid=\".uno:FormatMenu\"><emph>پىچىم</emph> تىزىملىكى پۈتۈكنى پىچىمىنى بەلگىلەشكە ئىشلىتىلىدىغان تاللانغان كاتەكچە، <link href=\"text/shared/00/00000005.xhp#objekt\" name=\" ئوبيېكت\">ئوبيېكت</link> ۋە كاتەكچە مەزمۇن بۇيرۇقىنى ئۆز ئىچىگە ئالىدۇ.</ahelp>"
 
 #: main0105.xhp
+#, fuzzy
 msgctxt ""
 "main0105.xhp\n"
 "hd_id3154732\n"
-"4\n"
 "help.text"
 msgid "<link href=\"text/scalc/01/05020000.xhp\" name=\"Cells\">Cells</link>"
 msgstr "<link href=\"text/scalc/01/05020000.xhp\" name=\"كاتەكچە\">كاتەكچە</link>"
 
 #: main0105.xhp
+#, fuzzy
 msgctxt ""
 "main0105.xhp\n"
 "hd_id3155087\n"
-"9\n"
 "help.text"
 msgid "<link href=\"text/scalc/01/05070000.xhp\" name=\"Page\">Page</link>"
 msgstr "<link href=\"text/scalc/01/05070000.xhp\" name=\"بەت\">بەت</link>"
 
 #: main0105.xhp
+#, fuzzy
 msgctxt ""
 "main0105.xhp\n"
 "hd_id3145748\n"
-"12\n"
 "help.text"
 msgid "<link href=\"text/shared/01/05020000.xhp\" name=\"Character\">Character</link>"
 msgstr "<link href=\"text/shared/01/05020000.xhp\" name=\"ھەرپ\">ھەرپ</link>"
 
 #: main0105.xhp
+#, fuzzy
 msgctxt ""
 "main0105.xhp\n"
 "hd_id3154485\n"
-"13\n"
 "help.text"
 msgid "<link href=\"text/shared/01/05030000.xhp\" name=\"Paragraph\">Paragraph</link>"
 msgstr "<link href=\"text/shared/01/05030000.xhp\" name=\"ئابزاس\">ئابزاس</link>"
 
 #: main0105.xhp
+#, fuzzy
 msgctxt ""
 "main0105.xhp\n"
 "hd_id3157980\n"
-"11\n"
 "help.text"
 msgid "<link href=\"text/scalc/01/05110000.xhp\" name=\"AutoFormat\">AutoFormat</link>"
 msgstr "<link href=\"text/scalc/01/05110000.xhp\" name=\"ئۆزلۈكىدىن پىچىم\">ئۆزلۈكىدىن پىچىم</link>"
 
 #: main0105.xhp
+#, fuzzy
 msgctxt ""
 "main0105.xhp\n"
 "hd_id3159206\n"
-"14\n"
 "help.text"
 msgid "<link href=\"text/scalc/01/05120000.xhp\" name=\"Conditional Formatting\">Conditional Formatting</link>"
 msgstr "<link href=\"text/scalc/01/05120000.xhp\" name=\"شەرت پىچىم\">شەرت پىچىم</link>"
 
 #: main0105.xhp
+#, fuzzy
 msgctxt ""
 "main0105.xhp\n"
 "hd_id3154703\n"
-"17\n"
 "help.text"
 msgid "<link href=\"text/shared/02/01170100.xhp\" name=\"Control\">Control</link>"
 msgstr "<link href=\"text/shared/02/01170100.xhp\" name=\"كونترول\">كونترول</link>"
 
 #: main0105.xhp
+#, fuzzy
 msgctxt ""
 "main0105.xhp\n"
 "hd_id3147005\n"
-"16\n"
 "help.text"
 msgid "<link href=\"text/shared/02/01170200.xhp\" name=\"Form\">Form</link>"
 msgstr "<link href=\"text/shared/02/01170200.xhp\" name=\"كۆزنەك\">كۆزنەك</link>"
@@ -617,21 +543,21 @@ msgid "Window"
 msgstr "كۆزنەك"
 
 #: main0107.xhp
+#, fuzzy
 msgctxt ""
 "main0107.xhp\n"
 "hd_id3154758\n"
-"1\n"
 "help.text"
 msgid "<link href=\"text/scalc/main0107.xhp\" name=\"Window\">Window</link>"
 msgstr "<link href=\"text/scalc/main0107.xhp\" name=\"كۆزنەك\">كۆزنەك</link>"
 
 #: main0107.xhp
+#, fuzzy
 msgctxt ""
 "main0107.xhp\n"
 "par_id3150398\n"
-"2\n"
 "help.text"
-msgid "<ahelp hid=\".uno:WindowList\">Contains commands for manipulating and displaying document windows.</ahelp>"
+msgid "<ahelp hid=\".\">Contains commands for manipulating and displaying document windows.</ahelp>"
 msgstr "<ahelp hid=\".uno:WindowList\">پۈتۈك كۆزنەك مەشغۇلاتى ۋە كۆرسىتىشكە ئىشلىتىلىدىغان بۇيرۇقلارنى ئۆز ئىچىگە ئالىدۇ.</ahelp>"
 
 #: main0112.xhp
@@ -740,6 +666,66 @@ msgctxt ""
 msgid "<link href=\"text/scalc/01/12100000.xhp\" name=\"Refresh Range\">Refresh Range</link>"
 msgstr "<link href=\"text/scalc/01/12100000.xhp\" name=\"دائىرىنى يېڭىلا\">دائىرىنى يېڭىلا</link>"
 
+#: main0116.xhp
+msgctxt ""
+"main0116.xhp\n"
+"tit\n"
+"help.text"
+msgid "Sheet"
+msgstr ""
+
+#: main0116.xhp
+#, fuzzy
+msgctxt ""
+"main0116.xhp\n"
+"hd_id0906201507390173\n"
+"help.text"
+msgid "<link href=\"text/scalc/main0116.xhp\">Sheet</link>"
+msgstr "<link href=\"text/scalc/01/12090100.xhp\">باشلا</link>"
+
+#: main0116.xhp
+msgctxt ""
+"main0116.xhp\n"
+"par_id0906201507414091\n"
+"help.text"
+msgid "<ahelp hid=\".\">This menu contains commands to modify and manage a sheet and its elements.</ahelp>"
+msgstr ""
+
+#: main0116.xhp
+msgctxt ""
+"main0116.xhp\n"
+"hd_id3150792\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/02180000.xhp\" name=\"Move/Copy\">Move or Copy Sheet</link>"
+msgstr ""
+
+#: main0116.xhp
+#, fuzzy
+msgctxt ""
+"main0116.xhp\n"
+"hd_id3153968\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/02210000.xhp\" name=\"Select\">Show Sheet</link>"
+msgstr "<link href=\"text/scalc/01/04050000.xhp\" name=\"ۋاراق\">ۋاراق</link>"
+
+#: main0116.xhp
+#, fuzzy
+msgctxt ""
+"main0116.xhp\n"
+"hd_id3163708\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/02170000.xhp\" name=\"Delete\">Delete Sheet</link>"
+msgstr "<link href=\"text/scalc/01/02160000.xhp\" name=\"كاتەكچە ئۆچۈر\">كاتەكچە ئۆچۈر</link>"
+
+#: main0116.xhp
+#, fuzzy
+msgctxt ""
+"main0116.xhp\n"
+"hd_id3163733308\n"
+"help.text"
+msgid "<link href=\"text/shared/01/06140500.xhp\" name=\"Events\">Sheet Events</link>"
+msgstr "<link href=\"text/shared/01/01070000.xhp\" name=\"باشقا ئاتتا ساقلا\">باشقا ئاتتا ساقلا</link>"
+
 #: main0200.xhp
 msgctxt ""
 "main0200.xhp\n"
@@ -1266,22 +1252,24 @@ msgid "Print Preview Bar"
 msgstr "بەتنى ئالدىن كۆزەت ستونى"
 
 #: main0210.xhp
+#, fuzzy
 msgctxt ""
 "main0210.xhp\n"
 "hd_id3156023\n"
 "1\n"
 "help.text"
 msgid "<link href=\"text/scalc/main0210.xhp\" name=\"Print Preview  Bar\">Print Preview Bar</link>"
-msgstr ""
+msgstr "<link href=\"text/scalc/main0210.xhp\" name=\"بەتنى ئالدىن كۆزەت ستونى\">بەتنى ئالدىن كۆزەت ستونى</link>"
 
 #: main0210.xhp
+#, fuzzy
 msgctxt ""
 "main0210.xhp\n"
 "par_id3148663\n"
 "2\n"
 "help.text"
 msgid "<ahelp hid=\"HID_SC_WIN_PREVIEW\">The <emph>Print Preview</emph> Bar is displayed when you choose <emph>File - Print Preview</emph>.</ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\"HID_SC_WIN_PREVIEW\"> <emph>ھۆججەت - بەتنى ئالدىن كۆزەت</emph>نى تاللىغاندا <emph>بەتنى ئالدىن كۆزەت</emph> ستونى كۆرۈنىدۇ.</ahelp>"
 
 #: main0210.xhp
 msgctxt ""
@@ -1379,13 +1367,14 @@ msgid "<link href=\"text/scalc/main0214.xhp\" name=\"Image Bar\">Image Bar</link
 msgstr "<link href=\"text/scalc/main0218.xhp\" name=\"قورال ستونى\">قورال ستونى</link>"
 
 #: main0214.xhp
+#, fuzzy
 msgctxt ""
 "main0214.xhp\n"
 "par_id3153896\n"
 "2\n"
 "help.text"
 msgid "<ahelp hid=\".\">The <emph>Image</emph> bar is displayed when you insert or select an image in a sheet.</ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\".\">ۋاراققا رەسىمدىن بىرنى قىستۇرغاندا ياكى تاللىغاندا <emph>رەسىم</emph> ستونى كۆرۈنىدۇ.</ahelp>"
 
 #: main0218.xhp
 msgctxt ""
diff --git a/source/ug/helpcontent2/source/text/scalc/00.po b/source/ug/helpcontent2/source/text/scalc/00.po
index 98905215371..20cef95d24c 100644
--- a/source/ug/helpcontent2/source/text/scalc/00.po
+++ b/source/ug/helpcontent2/source/text/scalc/00.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2015-04-22 23:39+0200\n"
+"POT-Creation-Date: 2015-11-10 19:33+0100\n"
 "PO-Revision-Date: 2015-05-11 22:36+0000\n"
 "Last-Translator: system user <>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -66,136 +66,134 @@ msgid "Edit Menu"
 msgstr "تىزىملىك تەھرىر"
 
 #: 00000402.xhp
+#, fuzzy
 msgctxt ""
 "00000402.xhp\n"
 "hd_id3147303\n"
-"1\n"
 "help.text"
 msgid "Edit Menu"
 msgstr "تىزىملىك تەھرىر"
 
 #: 00000402.xhp
+#, fuzzy
 msgctxt ""
 "00000402.xhp\n"
 "par_id3155555\n"
-"2\n"
 "help.text"
-msgid "<variable id=\"kopffuss\">Choose <emph>Edit - Headers & Footers</emph></variable>"
+msgid "<variable id=\"kopffuss\">Choose <emph>Insert - Headers and Footers</emph></variable>"
 msgstr "<variable id=\"kopffuss\"><emph>تەھرىر - بەت قېشى & بەت ئاستى</emph> نى تاللاڭ</variable>"
 
 #: 00000402.xhp
+#, fuzzy
 msgctxt ""
 "00000402.xhp\n"
 "par_id3159233\n"
-"3\n"
 "help.text"
-msgid "<variable id=\"bkopfzeile\">Choose <emph>Edit - Headers & Footers - Header/Footer</emph> tabs</variable>"
+msgid "<variable id=\"bkopfzeile\">Choose <emph>Insert - Headers and Footers - Header and Footer</emph> tabs</variable>"
 msgstr "<variable id=\"bkopfzeile\"><emph>تەھرىر - بەت قېشى & بەت ئاستى - بەت قېشى/ئاستى</emph> بەتكۈچنى تاللاڭ</variable>"
 
 #: 00000402.xhp
+#, fuzzy
 msgctxt ""
 "00000402.xhp\n"
 "par_id3150443\n"
-"4\n"
 "help.text"
-msgid "<variable id=\"bausfullen\">Choose <emph>Edit - Fill</emph></variable>"
+msgid "<variable id=\"bausfullen\">Choose <emph>Sheet - Fill Cells</emph></variable>"
 msgstr "<variable id=\"bausfullen\"><emph>تەھرىر - تولدۇر</emph>نى تاللاڭ</variable>"
 
 #: 00000402.xhp
+#, fuzzy
 msgctxt ""
 "00000402.xhp\n"
 "par_id3143267\n"
-"5\n"
 "help.text"
-msgid "<variable id=\"bausunten\">Choose <emph>Edit - Fill - Down</emph></variable>"
+msgid "<variable id=\"bausunten\">Choose <emph>Sheet - Fill Cells - Down</emph></variable>"
 msgstr "<variable id=\"bausunten\"><emph>تەھرىر - تولدۇر - ئاستى</emph>نى تاللاڭ</variable>"
 
 #: 00000402.xhp
+#, fuzzy
 msgctxt ""
 "00000402.xhp\n"
 "par_id3153880\n"
-"6\n"
 "help.text"
-msgid "<variable id=\"bausrechts\">Choose <emph>Edit - Fill - Right</emph></variable>"
+msgid "<variable id=\"bausrechts\">Choose <emph>Sheet - Fill Cells - Right</emph></variable>"
 msgstr "<variable id=\"bausrechts\"><emph>تەھرىر - تولدۇر - ئوڭ</emph>نى تاللاڭ</variable>"
 
 #: 00000402.xhp
+#, fuzzy
 msgctxt ""
 "00000402.xhp\n"
 "par_id3151245\n"
-"7\n"
 "help.text"
-msgid "<variable id=\"bausoben\">Choose <emph>Edit - Fill - Up</emph></variable>"
+msgid "<variable id=\"bausoben\">Choose <emph>Sheet - Fill Cells - Up</emph></variable>"
 msgstr "<variable id=\"bausoben\"><emph>تەھرىر - تولدۇر - ئۈستى</emph>نى تاللاڭ</variable>"
 
 #: 00000402.xhp
+#, fuzzy
 msgctxt ""
 "00000402.xhp\n"
 "par_id3145068\n"
-"8\n"
 "help.text"
-msgid "<variable id=\"bauslinks\">Choose <emph>Edit - Fill - Left</emph></variable>"
+msgid "<variable id=\"bauslinks\">Choose <emph>Sheet - Fill Cells - Left</emph></variable>"
 msgstr "<variable id=\"bauslinks\"><emph>تەھرىر - تولدۇر - سول</emph>نى تاللاڭ</variable>"
 
 #: 00000402.xhp
+#, fuzzy
 msgctxt ""
 "00000402.xhp\n"
 "par_id3150400\n"
-"9\n"
 "help.text"
-msgid "<variable id=\"baustab\">Choose <emph>Edit - Fill - Sheet</emph></variable>"
+msgid "<variable id=\"baustab\">Choose <emph>Sheet - Fill Cells - Sheet</emph></variable>"
 msgstr "<variable id=\"baustab\"><emph>تەھرىر - تولدۇر - ۋاراق</emph>نى تاللاڭ</variable>"
 
 #: 00000402.xhp
+#, fuzzy
 msgctxt ""
 "00000402.xhp\n"
 "par_id3154910\n"
-"10\n"
 "help.text"
-msgid "<variable id=\"bausreihe\">Choose <emph>Edit - Fill - Series</emph></variable>"
+msgid "<variable id=\"bausreihe\">Choose <emph>Sheet - Fill Cells - Series</emph></variable>"
 msgstr "<variable id=\"bausreihe\"><emph>تەھرىر - تولدۇر - يۈرۈشلۈك</emph>نى تاللاڭ</variable>"
 
 #: 00000402.xhp
 msgctxt ""
 "00000402.xhp\n"
 "par_id3154123\n"
-"11\n"
 "help.text"
-msgid "Choose <emph>Edit - Delete Contents</emph>"
-msgstr "<emph>تەھرىر - مەزمۇننى ئۆچۈر</emph>نى تاللاڭ"
+msgid "Choose <emph>Sheet - Clear Cells</emph>"
+msgstr ""
 
 #: 00000402.xhp
 msgctxt ""
 "00000402.xhp\n"
 "par_id3145785\n"
-"20\n"
 "help.text"
 msgid "Backspace"
 msgstr ""
 
 #: 00000402.xhp
+#, fuzzy
 msgctxt ""
 "00000402.xhp\n"
 "par_id3150011\n"
-"12\n"
 "help.text"
-msgid "<variable id=\"bzelo\">Choose <emph>Edit - Delete Cells</emph></variable>"
+msgid "<variable id=\"bzelo\">Choose <emph>Sheet - Delete Cells</emph></variable>"
 msgstr "<variable id=\"bzelo\"><emph>تەھرىر - كاتەكچە ئۆچۈر</emph>نى تاللاڭ</variable>"
 
 #: 00000402.xhp
+#, fuzzy
 msgctxt ""
 "00000402.xhp\n"
 "par_id3153951\n"
-"13\n"
 "help.text"
-msgid "Choose <emph>Edit – Sheet - Delete</emph>"
-msgstr "Choose <emph>Edit ? Sheet - Delete</emph>"
+msgid "Choose <emph>Sheet - Delete Sheet</emph>"
+msgstr "<emph>تەھرىر - مەزمۇننى ئۆچۈر</emph>نى تاللاڭ"
 
 #: 00000402.xhp
+#, fuzzy
 msgctxt ""
 "00000402.xhp\n"
 "par_id3155306\n"
-"18\n"
 "help.text"
 msgid "Open context menu for a sheet tab"
 msgstr "ۋاراق بەتكۈچنىڭ تىل مۇھىت تىزىملىكىنى ئاچ"
@@ -204,45 +202,44 @@ msgstr "ۋاراق بەتكۈچنىڭ تىل مۇھىت تىزىملىكىنى �
 msgctxt ""
 "00000402.xhp\n"
 "par_id3146119\n"
-"14\n"
 "help.text"
-msgid "Choose <emph>Edit – Sheets – Move/Copy</emph>"
-msgstr "Choose <emph>Edit ? Sheets ? Move/Copy</emph>"
+msgid "Choose <emph>Sheet - Move or Copy Sheet</emph>"
+msgstr ""
 
 #: 00000402.xhp
+#, fuzzy
 msgctxt ""
 "00000402.xhp\n"
 "par_id3148645\n"
-"19\n"
 "help.text"
 msgid "Open context menu for a sheet tab"
 msgstr "ۋاراق بەتكۈچنىڭ تىل مۇھىت تىزىملىكىنى ئاچ"
 
 #: 00000402.xhp
+#, fuzzy
 msgctxt ""
 "00000402.xhp\n"
 "par_id3153093\n"
-"15\n"
 "help.text"
-msgid "<variable id=\"bmaumloe\">Choose <emph>Edit - Delete Manual Break</emph></variable>"
+msgid "<variable id=\"bmaumloe\">Choose <emph>Sheet - Delete Page Break</emph></variable>"
 msgstr "<variable id=\"bmaumloe\"><emph>تەھرىر - ئايرىش بەلگىسىنى قولدا ئۆچۈر</emph>نى تاللاڭ</variable>"
 
 #: 00000402.xhp
+#, fuzzy
 msgctxt ""
 "00000402.xhp\n"
 "par_id3153191\n"
-"16\n"
 "help.text"
-msgid "<variable id=\"bzeilum\">Choose <emph>Edit - Delete Manual Break - Row Break</emph></variable>"
+msgid "<variable id=\"bzeilum\">Choose <emph>Sheet - Delete Page Break - Row Break</emph></variable>"
 msgstr "<variable id=\"bzeilum\"><emph>تەھرىر - قولدا قۇر ئالماشتۇرۇش بەلگىسىنى ئۆچۈر - قۇر ئالماشتۇرۇش بەلگىسى</emph>نى تاللاڭ</variable>"
 
 #: 00000402.xhp
+#, fuzzy
 msgctxt ""
 "00000402.xhp\n"
 "par_id3145645\n"
-"17\n"
 "help.text"
-msgid "<variable id=\"bspaum\">Choose <emph>Edit - Delete Manual Break - Column Break</emph></variable>"
+msgid "<variable id=\"bspaum\">Choose <emph>Sheet - Delete Page Break - Column Break</emph></variable>"
 msgstr "<variable id=\"bspaum\"><emph>تەھرىر - قولدا قۇر ئالماشتۇرۇش بەلگىسىنى ئۆچۈر - ستون ئايرىش بەلگىسى</emph>نى تاللاڭ</variable>"
 
 #: 00000403.xhp
@@ -254,28 +251,28 @@ msgid "View Menu"
 msgstr "كۆرۈنۈش تىزىملىكى"
 
 #: 00000403.xhp
+#, fuzzy
 msgctxt ""
 "00000403.xhp\n"
 "hd_id3145673\n"
-"1\n"
 "help.text"
 msgid "View Menu"
 msgstr "كۆرۈنۈش تىزىملىكى"
 
 #: 00000403.xhp
+#, fuzzy
 msgctxt ""
 "00000403.xhp\n"
 "par_id3150275\n"
-"2\n"
 "help.text"
 msgid "<variable id=\"aspze\">Choose <emph>View - Column & Row Headers</emph></variable>"
 msgstr "<variable id=\"aspze\"><emph>كۆرۈنۈش - ستون & قۇر ماۋزۇسى</emph>نى تاللاڭ</variable>"
 
 #: 00000403.xhp
+#, fuzzy
 msgctxt ""
 "00000403.xhp\n"
 "par_id3154514\n"
-"3\n"
 "help.text"
 msgid "<variable id=\"awehe\">Choose <emph>View - Value Highlighting</emph></variable>"
 msgstr "<variable id=\"awehe\"><emph>كۆرۈنۈش - قىممىتىنى يورۇت</emph>نى تاللاڭ</variable>"
@@ -284,18 +281,17 @@ msgstr "<variable id=\"awehe\"><emph>كۆرۈنۈش - قىممىتىنى يور�
 msgctxt ""
 "00000403.xhp\n"
 "par_id3148947\n"
-"4\n"
 "help.text"
-msgid "<variable id=\"rechenleiste\">Choose <emph>View - Toolbars - Formula Bar</emph></variable>"
-msgstr "<variable id=\"rechenleiste\"><emph>كۆرۈنۈش - قورال ستونى - فورمۇلا ستونى</emph>نى تاللاڭ</variable>"
+msgid "<variable id=\"rechenleiste\">Choose <emph>View - Formula Bar</emph> or <emph>View - Toolbars - Formula Bar</emph></variable>"
+msgstr ""
 
 #: 00000403.xhp
+#, fuzzy
 msgctxt ""
 "00000403.xhp\n"
 "par_id3148663\n"
-"5\n"
 "help.text"
-msgid "<variable id=\"seumvo\">Choose <emph>View - Page Break Preview</emph></variable>"
+msgid "<variable id=\"seumvo\">Choose <emph>View - Page Break</emph></variable>"
 msgstr "<variable id=\"seumvo\"><emph>كۆرۈنۈش - بەتكە ئايرىپ ئالدىن كۆزەت</emph>نى تاللاڭ</variable>"
 
 #: 00000404.xhp
@@ -901,13 +897,14 @@ msgid "<variable id=\"fodrhin\">Choose <emph>Format - Print Ranges - Add</emph><
 msgstr "<variable id=\"fodrhin\"><emph>پىچىم - بېسىش دائىرىسى - قوش</emph>نى تاللاڭ</variable>"
 
 #: 00000405.xhp
+#, fuzzy
 msgctxt ""
 "00000405.xhp\n"
 "par_id3155812\n"
 "28\n"
 "help.text"
 msgid "<variable id=\"fodbah\">Choose <emph>Format - Print Ranges - Clear</emph></variable>"
-msgstr ""
+msgstr "<variable id=\"fodbah\"><emph>پىچىم - بېسىش دائىرىسى - چىقىرىۋەت</emph>نى تاللاڭ</variable>"
 
 #: 00000405.xhp
 msgctxt ""
@@ -1220,10 +1217,10 @@ msgid "Window Menu"
 msgstr "كۆزنەك تىزىملىكى"
 
 #: 00000407.xhp
+#, fuzzy
 msgctxt ""
 "00000407.xhp\n"
 "hd_id3155628\n"
-"1\n"
 "help.text"
 msgid "Window Menu"
 msgstr "كۆزنەك تىزىملىكى"
@@ -1232,19 +1229,17 @@ msgstr "كۆزنەك تىزىملىكى"
 msgctxt ""
 "00000407.xhp\n"
 "par_id3147335\n"
-"2\n"
 "help.text"
-msgid "<variable id=\"fete\">Choose <emph>Window - Split</emph></variable>"
-msgstr "<variable id=\"fete\"><emph>كۆزنەك - پارچىلا</emph>نى تاللاڭ</variable>"
+msgid "<variable id=\"fete\">Choose <item type=\"menuitem\">View - Split Window</item></variable>"
+msgstr ""
 
 #: 00000407.xhp
 msgctxt ""
 "00000407.xhp\n"
 "par_id3153663\n"
-"3\n"
 "help.text"
-msgid "<variable id=\"fefix\">Choose <emph>Window - Freeze</emph></variable>"
-msgstr "<variable id=\"fefix\"><emph>كۆزنەك - مۇقىم</emph>نى تاللاڭ</variable>"
+msgid "<variable id=\"fefix\">Choose <item type=\"menuitem\">View - Freeze Rows and Columns</item></variable>"
+msgstr ""
 
 #: 00000412.xhp
 msgctxt ""
diff --git a/source/ug/helpcontent2/source/text/scalc/01.po b/source/ug/helpcontent2/source/text/scalc/01.po
index 949f4032548..6cbf5a0857d 100644
--- a/source/ug/helpcontent2/source/text/scalc/01.po
+++ b/source/ug/helpcontent2/source/text/scalc/01.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2015-08-25 12:34+0200\n"
+"POT-Creation-Date: 2015-11-16 19:02+0100\n"
 "PO-Revision-Date: 2015-05-11 22:37+0000\n"
 "Last-Translator: system user <>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -552,28 +552,26 @@ msgid "Headers & Footers"
 msgstr ""
 
 #: 02120000.xhp
+#, fuzzy
 msgctxt ""
 "02120000.xhp\n"
 "hd_id3145251\n"
-"1\n"
 "help.text"
-msgid "Headers & Footers"
-msgstr ""
+msgid "<link href=\"text/scalc/01/02120000.xhp\" name=\"Headers & Footers\">Headers & Footers</link>"
+msgstr "<link href=\"text/scalc/01/12030000.xhp\" name=\"تەرتىپلە\">تەرتىپلە</link>"
 
 #: 02120000.xhp
 msgctxt ""
 "02120000.xhp\n"
 "par_id3151073\n"
-"2\n"
 "help.text"
-msgid "<variable id=\"kopfundfusszeilentext\"><ahelp hid=\".uno:EditHeaderAndFooter\">Allows you to define and format headers and footers.</ahelp></variable>"
+msgid "<variable id=\"kopfundfusszeilentext\"><ahelp hid=\".\">Allows you to define and format headers and footers.</ahelp> </variable>"
 msgstr ""
 
 #: 02120000.xhp
 msgctxt ""
 "02120000.xhp\n"
 "par_id3153415\n"
-"3\n"
 "help.text"
 msgid "The<emph> Headers/Footers </emph>dialog contains the tabs for defining headers and footers. There will be separate tabs for the left and right page headers and footers if the <emph>Same content left/right</emph> option was not marked in the <link href=\"text/scalc/01/05070000.xhp\" name=\"Page Style\">Page Style</link> dialog."
 msgstr ""
@@ -1716,7 +1714,7 @@ msgctxt ""
 "02140700.xhp\n"
 "par_id2308201415431874867\n"
 "help.text"
-msgid "<ahelp hid=\"\">The distribution function for the random number generator.</ahelp>"
+msgid "<ahelp hid=\".\">The distribution function for the random number generator.</ahelp>"
 msgstr ""
 
 #: 02140700.xhp
@@ -2571,21 +2569,20 @@ msgid "Delete Manual Breaks"
 msgstr "ھەممە قولدا قۇر ئالماشتۇرۇش بەلگىسىنى ئۆچۈر"
 
 #: 02190000.xhp
+#, fuzzy
 msgctxt ""
 "02190000.xhp\n"
 "hd_id3150541\n"
-"1\n"
 "help.text"
-msgid "<link href=\"text/scalc/01/02190000.xhp\" name=\"Delete Manual Breaks\">Delete Manual Break</link>"
+msgid "<link href=\"text/scalc/01/02190000.xhp\" name=\"Delete Manual Breaks\">Delete Page Break</link>"
 msgstr "<link href=\"text/scalc/01/12030000.xhp\" name=\"تەرتىپلە\">تەرتىپلە</link>"
 
 #: 02190000.xhp
 msgctxt ""
 "02190000.xhp\n"
 "par_id3154365\n"
-"2\n"
 "help.text"
-msgid "<ahelp hid=\".\">Choose the type of manual break that you want to delete.</ahelp>"
+msgid "<ahelp hid=\".\">Choose the type of page break that you want to delete.</ahelp>"
 msgstr ""
 
 #: 02190100.xhp
@@ -2683,10 +2680,10 @@ msgid "Sheet"
 msgstr "ۋاراق"
 
 #: 02200000.xhp
+#, fuzzy
 msgctxt ""
 "02200000.xhp\n"
 "hd_id3146794\n"
-"1\n"
 "help.text"
 msgid "<link href=\"text/scalc/01/02200000.xhp\" name=\"Sheet\">Sheet</link>"
 msgstr "<link href=\"text/scalc/01/12030000.xhp\" name=\"تەرتىپلە\">تەرتىپلە</link>"
@@ -2695,46 +2692,10 @@ msgstr "<link href=\"text/scalc/01/12030000.xhp\" name=\"تەرتىپلە\">تە
 msgctxt ""
 "02200000.xhp\n"
 "par_id3149456\n"
-"2\n"
 "help.text"
 msgid "<ahelp hid=\".\">Edit commands for entire sheets.</ahelp>"
 msgstr ""
 
-#: 02200000.xhp
-msgctxt ""
-"02200000.xhp\n"
-"hd_id3150792\n"
-"3\n"
-"help.text"
-msgid "<link href=\"text/scalc/01/02180000.xhp\" name=\"Move/Copy\">Move/Copy</link>"
-msgstr "<link href=\"text/scalc/01/12030000.xhp\" name=\"تەرتىپلە\">تەرتىپلە</link>"
-
-#: 02200000.xhp
-msgctxt ""
-"02200000.xhp\n"
-"hd_id3153968\n"
-"4\n"
-"help.text"
-msgid "<link href=\"text/scalc/01/02210000.xhp\" name=\"Select\">Select</link>"
-msgstr "<link href=\"text/scalc/01/12030000.xhp\" name=\"تەرتىپلە\">تەرتىپلە</link>"
-
-#: 02200000.xhp
-msgctxt ""
-"02200000.xhp\n"
-"hd_id3163708\n"
-"5\n"
-"help.text"
-msgid "<link href=\"text/scalc/01/02170000.xhp\" name=\"Delete\">Delete</link>"
-msgstr "<link href=\"text/scalc/01/12030000.xhp\" name=\"تەرتىپلە\">تەرتىپلە</link>"
-
-#: 02200000.xhp
-msgctxt ""
-"02200000.xhp\n"
-"hd_id3163733308\n"
-"help.text"
-msgid "<link href=\"text/shared/01/06140500.xhp\" name=\"Events\">Events</link>"
-msgstr "<link href=\"text/scalc/01/12030000.xhp\" name=\"تەرتىپلە\">تەرتىپلە</link>"
-
 #: 02210000.xhp
 msgctxt ""
 "02210000.xhp\n"
@@ -2776,7 +2737,7 @@ msgctxt ""
 "par_id3153969\n"
 "3\n"
 "help.text"
-msgid "<ahelp hid=\"HID_SELECTTABLES\" visibility=\"visible\">Lists the sheets in the current document. To select a sheet, press the up or down arrow keys to move to a sheet in the list. To add a sheet to the selection, hold down Ctrl (Mac: Command) while pressing the arrow keys and then press Spacebar. To select a range of sheets, hold down Shift and press the arrow keys. </ahelp>"
+msgid "<ahelp hid=\"HID_SELECTTABLES\" visibility=\"visible\">Lists the sheets in the current document. To select a sheet, press the up or down arrow keys to move to a sheet in the list. To add a sheet to the selection, hold down <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> while pressing the arrow keys and then press Spacebar. To select a range of sheets, hold down Shift and press the arrow keys. </ahelp>"
 msgstr ""
 
 #: 03070000.xhp
@@ -2792,14 +2753,13 @@ msgctxt ""
 "03070000.xhp\n"
 "bm_id3156024\n"
 "help.text"
-msgid "<bookmark_value>spreadsheets; displaying headers of columns/rows</bookmark_value><bookmark_value>displaying; headers of columns/rows</bookmark_value>"
+msgid "<bookmark_value>spreadsheets; displaying headers of columns/rows</bookmark_value>  <bookmark_value>displaying; headers of columns/rows</bookmark_value>"
 msgstr ""
 
 #: 03070000.xhp
 msgctxt ""
 "03070000.xhp\n"
 "hd_id3156024\n"
-"1\n"
 "help.text"
 msgid "<link href=\"text/scalc/01/03070000.xhp\" name=\"Column & Row Headers\">Column & Row Headers</link>"
 msgstr ""
@@ -2808,27 +2768,24 @@ msgstr ""
 msgctxt ""
 "03070000.xhp\n"
 "par_id3147230\n"
-"2\n"
 "help.text"
-msgid "<ahelp hid=\".uno:ViewRowColumnHeaders\">Shows column headers and row headers.</ahelp>"
+msgid "<ahelp hid=\".\">Shows column headers and row headers.</ahelp>"
 msgstr ""
 
 #: 03070000.xhp
 msgctxt ""
 "03070000.xhp\n"
 "par_id3156280\n"
-"4\n"
 "help.text"
-msgid "To hide the column and row headers unmark this menu entry."
+msgid "To hide the column and row headers, unmark this menu entry."
 msgstr ""
 
 #: 03070000.xhp
 msgctxt ""
 "03070000.xhp\n"
 "par_id3156441\n"
-"3\n"
 "help.text"
-msgid "You can also set the view of the column and row headers in <emph><switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href=\"text/shared/optionen/01060100.xhp\" name=\"Spreadsheet - View\">%PRODUCTNAME Calc - View</link></emph>."
+msgid "You can also set the view of the column and row headers in <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"menuitem\">%PRODUCTNAME - Preferences</item></caseinline><defaultinline><item type=\"menuitem\">Tools - Options</item></defaultinline></switchinline><emph> - <link href=\"text/shared/optionen/01060100.xhp\" name=\"Spreadsheet - View\">%PRODUCTNAME Calc - View</link></emph>."
 msgstr ""
 
 #: 03080000.xhp
@@ -2840,11 +2797,12 @@ msgid "Value Highlighting"
 msgstr ""
 
 #: 03080000.xhp
+#, fuzzy
 msgctxt ""
 "03080000.xhp\n"
 "bm_id3151384\n"
 "help.text"
-msgid "<bookmark_value>spreadsheets; value highlighting</bookmark_value><bookmark_value>values;highlighting</bookmark_value><bookmark_value>highlighting; values in sheets</bookmark_value><bookmark_value>colors;values</bookmark_value>"
+msgid "<bookmark_value>spreadsheets; value highlighting</bookmark_value>  <bookmark_value>values;highlighting</bookmark_value>  <bookmark_value>highlighting; values in sheets</bookmark_value>  <bookmark_value>colors;values</bookmark_value>"
 msgstr "<bookmark_value>فورمۇلا ستونى; sheet area names</bookmark_value><bookmark_value>ۋاراق دائىرە ئاتى</bookmark_value><bookmark_value>كۆرسەت; كاتەكچە نەقىل</bookmark_value><bookmark_value>كاتەكچە نەقىل; showing</bookmark_value>"
 
 #: 03080000.xhp
@@ -2860,7 +2818,7 @@ msgctxt ""
 "03080000.xhp\n"
 "par_id3154366\n"
 "help.text"
-msgid "<ahelp hid=\".uno:ViewValueHighlighting\">Displays cell contents in different colors, depending on type.</ahelp>"
+msgid "<ahelp hid=\".\">Displays cell contents in different colors, depending on type.</ahelp>"
 msgstr ""
 
 #: 03080000.xhp
@@ -2900,14 +2858,14 @@ msgctxt ""
 "03090000.xhp\n"
 "bm_id3147264\n"
 "help.text"
-msgid "<bookmark_value>formula bar;spreadsheets</bookmark_value><bookmark_value>spreadsheets; formula bar</bookmark_value>"
+msgid "<bookmark_value>formula bar;spreadsheets</bookmark_value>  <bookmark_value>spreadsheets; formula bar</bookmark_value>"
 msgstr ""
 
 #: 03090000.xhp
+#, fuzzy
 msgctxt ""
 "03090000.xhp\n"
 "hd_id3147264\n"
-"1\n"
 "help.text"
 msgid "<link href=\"text/scalc/01/03090000.xhp\" name=\"Formula Bar\">Formula Bar</link>"
 msgstr "<link href=\"text/scalc/01/12030000.xhp\" name=\"تەرتىپلە\">تەرتىپلە</link>"
@@ -2916,16 +2874,14 @@ msgstr "<link href=\"text/scalc/01/12030000.xhp\" name=\"تەرتىپلە\">تە
 msgctxt ""
 "03090000.xhp\n"
 "par_id3156423\n"
-"2\n"
 "help.text"
-msgid "<ahelp hid=\".uno:InputLineVisible\">Shows or hides the Formula Bar, which is used for entering and editing formulas.</ahelp> The Formula Bar is the most important tool when working with spreadsheets."
+msgid "<ahelp hid=\".\">Shows or hides the Formula Bar, which is used for entering and editing formulas. The Formula Bar is the most important tool when working with spreadsheets.</ahelp>"
 msgstr ""
 
 #: 03090000.xhp
 msgctxt ""
 "03090000.xhp\n"
 "par_id3154686\n"
-"4\n"
 "help.text"
 msgid "To hide the Formula Bar, unmark the menu item."
 msgstr ""
@@ -2934,7 +2890,6 @@ msgstr ""
 msgctxt ""
 "03090000.xhp\n"
 "par_id3145787\n"
-"3\n"
 "help.text"
 msgid "If the Formula Bar is hidden, you can still edit cells by activating the edit mode with F2. After editing cells, accept the changes by pressing Enter, or discard entries by pressing Esc. Esc is also used to exit the edit mode."
 msgstr ""
@@ -2944,41 +2899,39 @@ msgctxt ""
 "03100000.xhp\n"
 "tit\n"
 "help.text"
-msgid "Page Break Preview"
+msgid "Page Break View"
 msgstr ""
 
 #: 03100000.xhp
+#, fuzzy
 msgctxt ""
 "03100000.xhp\n"
 "hd_id3151384\n"
-"1\n"
 "help.text"
-msgid "<link href=\"text/scalc/01/03100000.xhp\" name=\"Page Break Preview\">Page Break Preview</link>"
-msgstr ""
+msgid "<link href=\"text/scalc/01/03100000.xhp\" name=\"Page Break View\">Page Break View</link>"
+msgstr "<link href=\"text/scalc/01/12030000.xhp\" name=\"تەرتىپلە\">تەرتىپلە</link>"
 
 #: 03100000.xhp
 msgctxt ""
 "03100000.xhp\n"
 "par_id3150792\n"
-"2\n"
 "help.text"
-msgid "<ahelp hid=\".uno:PagebreakMode\">Display the page breaks and print ranges in the sheet. Choose <emph>View - Normal</emph> to switch this mode off.</ahelp>"
+msgid "<variable id=\"page_break_view_text\"><ahelp hid=\".\">Display the page breaks and print ranges in the sheet.</ahelp></variable> Choose <item type=\"menuitem\">View - Normal</item> to switch this mode off."
 msgstr ""
 
 #: 03100000.xhp
 msgctxt ""
 "03100000.xhp\n"
 "par_id3153877\n"
-"13\n"
 "help.text"
 msgid "The context menu of the page break preview contains functions for editing page breaks, including the following options:"
 msgstr ""
 
 #: 03100000.xhp
+#, fuzzy
 msgctxt ""
 "03100000.xhp\n"
 "hd_id3154731\n"
-"14\n"
 "help.text"
 msgid "Delete All Manual Breaks"
 msgstr "ھەممە قولدا قۇر ئالماشتۇرۇش بەلگىسىنى ئۆچۈر"
@@ -2987,16 +2940,15 @@ msgstr "ھەممە قولدا قۇر ئالماشتۇرۇش بەلگىسىنى �
 msgctxt ""
 "03100000.xhp\n"
 "par_id3149400\n"
-"15\n"
 "help.text"
-msgid "<ahelp hid=\".uno:DeleteAllBreaks\">Deletes all manual breaks in the current sheet.</ahelp>"
+msgid "<ahelp hid=\".\">Deletes all manual breaks in the current sheet.</ahelp>"
 msgstr ""
 
 #: 03100000.xhp
+#, fuzzy
 msgctxt ""
 "03100000.xhp\n"
 "hd_id3155067\n"
-"18\n"
 "help.text"
 msgid "Add Print Range"
 msgstr "بېسىش دائىرىسى قوش"
@@ -3005,7 +2957,6 @@ msgstr "بېسىش دائىرىسى قوش"
 msgctxt ""
 "03100000.xhp\n"
 "par_id3155764\n"
-"19\n"
 "help.text"
 msgid "Adds the selected cells to print ranges."
 msgstr ""
@@ -6165,198 +6116,6 @@ msgctxt ""
 msgid "Functions"
 msgstr "فونكىسىيە"
 
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_idN10683\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_workday.xhp#workday\"/>"
-msgstr ""
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id5189062\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_yearfrac.xhp#yearfrac\"/>"
-msgstr ""
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id6854457\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_date.xhp#date\"/>"
-msgstr ""
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id6354457\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_datedif.xhp#datedif\"/>"
-msgstr ""
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id3372295\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_datevalue.xhp#datevalue\"/>"
-msgstr ""
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id5684377\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_edate.xhp#edate\"/>"
-msgstr ""
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id7576525\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_today.xhp#today\"/>"
-msgstr ""
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id641193\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_year.xhp#year\"/>"
-msgstr ""
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id6501968\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_now.xhp#now\"/>"
-msgstr ""
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id3886532\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_weeknum.xhp#weeknum\"/>"
-msgstr ""
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id614947\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_weeknumadd.xhp#weeknumadd\"/>"
-msgstr ""
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id3953062\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_minute.xhp#minute\"/>"
-msgstr ""
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id2579729\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_month.xhp#month\"/>"
-msgstr ""
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id1346781\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_eomonth.xhp#eomonth\"/>"
-msgstr ""
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id8951384\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_networkdays.xhp#networkdays\"/>"
-msgstr ""
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id1074251\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_eastersunday.xhp#eastersunday\"/>"
-msgstr ""
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id372325\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_second.xhp#second\"/>"
-msgstr ""
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id224005\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_hour.xhp#hour\"/>"
-msgstr ""
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id5375835\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_day.xhp#day\"/>"
-msgstr ""
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id1208838\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_days.xhp#days\"/>"
-msgstr ""
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id7679982\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_days360.xhp#days360\"/>"
-msgstr ""
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id9172643\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_weekday.xhp#weekday\"/>"
-msgstr ""
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id2354503\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_time.xhp#time\"/>"
-msgstr ""
-
-#: 04060102.xhp
-msgctxt ""
-"04060102.xhp\n"
-"par_id7765434\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_timevalue.xhp#timevalue\"/>"
-msgstr ""
-
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
@@ -7053,14 +6812,6 @@ msgstr ""
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
-"par_idN10B13\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>"
-msgstr ""
-
-#: 04060103.xhp
-msgctxt ""
-"04060103.xhp\n"
 "hd_id3150037\n"
 "14\n"
 "help.text"
@@ -10736,7 +10487,7 @@ msgctxt ""
 "par_id3155900\n"
 "137\n"
 "help.text"
-msgid "<ahelp hid=\"HID_FUNC_TYP\">Returns the type of value.</ahelp>"
+msgid "<ahelp hid=\"HID_FUNC_TYP\">Returns the type of value, where 1 = number, 2 = text, 4 = Boolean value, 8 = formula, 16 = error value, 64 = array.</ahelp>"
 msgstr ""
 
 #: 04060104.xhp
@@ -10763,7 +10514,7 @@ msgctxt ""
 "par_id3150830\n"
 "140\n"
 "help.text"
-msgid "<emph>Value</emph> is a specific value for which the data type is determined. Value 1 = number, value 2 = text, value 4 = Boolean value, value 8 = formula, value 16 = error value."
+msgid "<emph>Value</emph> is a specific value for which the data type is determined."
 msgstr ""
 
 #: 04060104.xhp
@@ -11735,14 +11486,6 @@ msgstr ""
 #: 04060105.xhp
 msgctxt ""
 "04060105.xhp\n"
-"par_idN107FA\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>"
-msgstr ""
-
-#: 04060105.xhp
-msgctxt ""
-"04060105.xhp\n"
 "hd_id3149507\n"
 "55\n"
 "help.text"
@@ -19075,14 +18818,6 @@ msgstr ""
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
-"par_idN10FA7\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#moreontop\"/>"
-msgstr ""
-
-#: 04060107.xhp
-msgctxt ""
-"04060107.xhp\n"
 "bm_id3159084\n"
 "help.text"
 msgid "<bookmark_value>FREQUENCY function</bookmark_value>"
@@ -19513,14 +19248,6 @@ msgstr ""
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
-"par_idN11269\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#moreontop\"/>"
-msgstr ""
-
-#: 04060107.xhp
-msgctxt ""
-"04060107.xhp\n"
 "bm_id3151030\n"
 "help.text"
 msgid "<bookmark_value>MDETERM function</bookmark_value><bookmark_value>determinants</bookmark_value>"
@@ -19582,14 +19309,6 @@ msgstr ""
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
-"par_idN11333\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#moreontop\"/>"
-msgstr ""
-
-#: 04060107.xhp
-msgctxt ""
-"04060107.xhp\n"
 "bm_id3151348\n"
 "help.text"
 msgid "<bookmark_value>MINVERSE function</bookmark_value><bookmark_value>inverse arrays</bookmark_value>"
@@ -19643,14 +19362,6 @@ msgstr ""
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
-"par_idN113EE\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#moreontop\"/>"
-msgstr ""
-
-#: 04060107.xhp
-msgctxt ""
-"04060107.xhp\n"
 "hd_id3157868\n"
 "44\n"
 "help.text"
@@ -19731,14 +19442,6 @@ msgstr ""
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
-"par_idN114C3\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#moreontop\"/>"
-msgstr ""
-
-#: 04060107.xhp
-msgctxt ""
-"04060107.xhp\n"
 "hd_id3152574\n"
 "53\n"
 "help.text"
@@ -19810,14 +19513,6 @@ msgstr ""
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
-"par_idN115A5\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#moreontop\"/>"
-msgstr ""
-
-#: 04060107.xhp
-msgctxt ""
-"04060107.xhp\n"
 "hd_id3159352\n"
 "61\n"
 "help.text"
@@ -19932,22 +19627,6 @@ msgstr ""
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
-"par_idN11416\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>"
-msgstr ""
-
-#: 04060107.xhp
-msgctxt ""
-"04060107.xhp\n"
-"par_idN116C6\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#moreontop\"/>"
-msgstr ""
-
-#: 04060107.xhp
-msgctxt ""
-"04060107.xhp\n"
 "hd_id3154162\n"
 "72\n"
 "help.text"
@@ -20665,14 +20344,6 @@ msgstr ""
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
-"par_idN11B04\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#moreontop\"/>"
-msgstr ""
-
-#: 04060107.xhp
-msgctxt ""
-"04060107.xhp\n"
 "bm_id1596728\n"
 "help.text"
 msgid "<bookmark_value>LOGEST function</bookmark_value>"
@@ -20753,22 +20424,6 @@ msgstr ""
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
-"par_idN118F7\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>"
-msgstr ""
-
-#: 04060107.xhp
-msgctxt ""
-"04060107.xhp\n"
-"par_idN11BC3\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#moreontop\"/>"
-msgstr ""
-
-#: 04060107.xhp
-msgctxt ""
-"04060107.xhp\n"
 "hd_id3163216\n"
 "158\n"
 "help.text"
@@ -21040,14 +20695,6 @@ msgstr ""
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
-"par_idN11C91\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#moreontop\"/>"
-msgstr ""
-
-#: 04060107.xhp
-msgctxt ""
-"04060107.xhp\n"
 "bm_id3144842\n"
 "help.text"
 msgid "<bookmark_value>SUMX2MY2 function</bookmark_value>"
@@ -21110,14 +20757,6 @@ msgstr ""
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
-"par_idN11D6B\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#moreontop\"/>"
-msgstr ""
-
-#: 04060107.xhp
-msgctxt ""
-"04060107.xhp\n"
 "bm_id3145026\n"
 "help.text"
 msgid "<bookmark_value>SUMX2PY2 function</bookmark_value>"
@@ -21180,14 +20819,6 @@ msgstr ""
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
-"par_idN11E45\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#moreontop\"/>"
-msgstr ""
-
-#: 04060107.xhp
-msgctxt ""
-"04060107.xhp\n"
 "bm_id3163527\n"
 "help.text"
 msgid "<bookmark_value>SUMXMY2 function</bookmark_value>"
@@ -21250,14 +20881,6 @@ msgstr ""
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
-"par_idN11F1F\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#moreontop\"/>"
-msgstr ""
-
-#: 04060107.xhp
-msgctxt ""
-"04060107.xhp\n"
 "bm_id3166062\n"
 "help.text"
 msgid "<bookmark_value>TREND function</bookmark_value>"
@@ -21338,22 +20961,6 @@ msgstr ""
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
-"par_idN11D2F\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>"
-msgstr ""
-
-#: 04060107.xhp
-msgctxt ""
-"04060107.xhp\n"
-"par_idN12019\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#moreontop\"/>"
-msgstr ""
-
-#: 04060107.xhp
-msgctxt ""
-"04060107.xhp\n"
 "hd_id3166231\n"
 "204\n"
 "help.text"
@@ -21452,22 +21059,6 @@ msgstr ""
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
-"par_idN11DFD\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>"
-msgstr ""
-
-#: 04060107.xhp
-msgctxt ""
-"04060107.xhp\n"
-"par_idN12113\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#moreontop\"/>"
-msgstr ""
-
-#: 04060107.xhp
-msgctxt ""
-"04060107.xhp\n"
 "hd_id3173839\n"
 "215\n"
 "help.text"
@@ -23323,14 +22914,6 @@ msgstr ""
 #: 04060109.xhp
 msgctxt ""
 "04060109.xhp\n"
-"par_idN1104B\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>"
-msgstr ""
-
-#: 04060109.xhp
-msgctxt ""
-"04060109.xhp\n"
 "hd_id3155586\n"
 "120\n"
 "help.text"
@@ -23558,14 +23141,6 @@ msgstr ""
 #: 04060109.xhp
 msgctxt ""
 "04060109.xhp\n"
-"par_idN111CA\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>"
-msgstr ""
-
-#: 04060109.xhp
-msgctxt ""
-"04060109.xhp\n"
 "hd_id3159254\n"
 "140\n"
 "help.text"
@@ -31802,68 +31377,6 @@ msgstr ""
 #: 04060116.xhp
 msgctxt ""
 "04060116.xhp\n"
-"bm_id3149146\n"
-"help.text"
-msgid "<bookmark_value>IMCOS function</bookmark_value>"
-msgstr ""
-
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"hd_id3149146\n"
-"73\n"
-"help.text"
-msgid "IMCOS"
-msgstr "IMCOS"
-
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149725\n"
-"74\n"
-"help.text"
-msgid "<ahelp hid=\"HID_AAI_FUNC_IMCOS\">The result is the cosine of a complex number.</ahelp>"
-msgstr ""
-
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"hd_id3159116\n"
-"75\n"
-"help.text"
-msgid "Syntax"
-msgstr ""
-
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3147415\n"
-"76\n"
-"help.text"
-msgid "IMCOS(\"ComplexNumber\")"
-msgstr ""
-
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"hd_id3152980\n"
-"78\n"
-"help.text"
-msgid "Example"
-msgstr "مىسال"
-
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3157901\n"
-"79\n"
-"help.text"
-msgid "<item type=\"input\">=IMCOS(\"3+4j\") </item>returns -27.03-3.85i (rounded)."
-msgstr ""
-
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
 "bm_id3150024\n"
 "help.text"
 msgid "<bookmark_value>IMDIV function</bookmark_value>"
@@ -32369,68 +31882,6 @@ msgstr ""
 #: 04060116.xhp
 msgctxt ""
 "04060116.xhp\n"
-"bm_id3148431\n"
-"help.text"
-msgid "<bookmark_value>IMSIN function</bookmark_value>"
-msgstr ""
-
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"hd_id3148431\n"
-"136\n"
-"help.text"
-msgid "IMSIN"
-msgstr "IMSIN"
-
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3152591\n"
-"137\n"
-"help.text"
-msgid "<ahelp hid=\"HID_AAI_FUNC_IMSIN\">The result is the sine of a complex number.</ahelp>"
-msgstr ""
-
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"hd_id3149822\n"
-"138\n"
-"help.text"
-msgid "Syntax"
-msgstr ""
-
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3150387\n"
-"139\n"
-"help.text"
-msgid "IMSIN(\"ComplexNumber\")"
-msgstr ""
-
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"hd_id3150613\n"
-"141\n"
-"help.text"
-msgid "Example"
-msgstr "مىسال"
-
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3154310\n"
-"142\n"
-"help.text"
-msgid "<item type=\"input\">=IMSIN(\"3+4j\")</item> returns 3.85+27.02j (rounded)."
-msgstr ""
-
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
 "bm_id3163826\n"
 "help.text"
 msgid "<bookmark_value>IMSUB function</bookmark_value>"
@@ -34474,14 +33925,6 @@ msgstr ""
 #: 04060118.xhp
 msgctxt ""
 "04060118.xhp\n"
-"par_idN10A0D\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>"
-msgstr ""
-
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
 "hd_id3148429\n"
 "233\n"
 "help.text"
@@ -35088,14 +34531,6 @@ msgstr ""
 #: 04060118.xhp
 msgctxt ""
 "04060118.xhp\n"
-"par_idN10E2A\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>"
-msgstr ""
-
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
 "hd_id3149791\n"
 "259\n"
 "help.text"
@@ -36032,14 +35467,6 @@ msgstr ""
 #: 04060118.xhp
 msgctxt ""
 "04060118.xhp\n"
-"par_idN114D8\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>"
-msgstr ""
-
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
 "hd_id3146800\n"
 "286\n"
 "help.text"
@@ -36245,14 +35672,6 @@ msgstr ""
 #: 04060118.xhp
 msgctxt ""
 "04060118.xhp\n"
-"par_idN1166C\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>"
-msgstr ""
-
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
 "hd_id3155795\n"
 "299\n"
 "help.text"
@@ -36431,14 +35850,6 @@ msgstr ""
 #: 04060119.xhp
 msgctxt ""
 "04060119.xhp\n"
-"par_idN1067C\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>"
-msgstr ""
-
-#: 04060119.xhp
-msgctxt ""
-"04060119.xhp\n"
 "hd_id3148582\n"
 "248\n"
 "help.text"
@@ -38669,14 +38080,6 @@ msgstr ""
 #: 04060119.xhp
 msgctxt ""
 "04060119.xhp\n"
-"par_idN11645\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>"
-msgstr ""
-
-#: 04060119.xhp
-msgctxt ""
-"04060119.xhp\n"
 "hd_id3152358\n"
 "339\n"
 "help.text"
@@ -40160,14 +39563,6 @@ msgstr ""
 #: 04060181.xhp
 msgctxt ""
 "04060181.xhp\n"
-"par_idN109DF\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>"
-msgstr ""
-
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
 "hd_id3147077\n"
 "61\n"
 "help.text"
@@ -40276,14 +39671,6 @@ msgstr ""
 #: 04060181.xhp
 msgctxt ""
 "04060181.xhp\n"
-"par_idN109DFms\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>"
-msgstr ""
-
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
 "hd_id2947077\n"
 "61\n"
 "help.text"
@@ -40399,14 +39786,6 @@ msgstr ""
 #: 04060181.xhp
 msgctxt ""
 "04060181.xhp\n"
-"par_idN10AB3\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>"
-msgstr ""
-
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
 "hd_id3145649\n"
 "73\n"
 "help.text"
@@ -40523,14 +39902,6 @@ msgstr ""
 #: 04060181.xhp
 msgctxt ""
 "04060181.xhp\n"
-"par_idN10AB3ms\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>"
-msgstr ""
-
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
 "hd_id2945649\n"
 "73\n"
 "help.text"
@@ -41132,7 +40503,7 @@ msgctxt ""
 "par_id2949906\n"
 "89\n"
 "help.text"
-msgid "<ahelp hid=\"HID_FUNC_CHISQINV_MS\">Returns the inverse of the one-tailed probability of the chi-squared distribution.</ahelp>"
+msgid "<ahelp hid=\"HID_FUNC_CHIINV_MS\">Returns the inverse of the one-tailed probability of the chi-squared distribution.</ahelp>"
 msgstr ""
 
 #: 04060181.xhp
@@ -41993,7 +41364,7 @@ msgctxt ""
 "par_id2956338\n"
 "156\n"
 "help.text"
-msgid "<ahelp hid=\"HID_FUNC_CHISQDIST_MS\">Returns the probability value from the indicated Chi square that a hypothesis is confirmed.</ahelp> CHISQ.DIST.RT compares the Chi square value to be given for a random sample that is calculated from the sum of (observed value-expected value)^2/expected value for all values with the theoretical Chi square distribution and determines from this the probability of error for the hypothesis to be tested."
+msgid "<ahelp hid=\"HID_FUNC_CHIVERT_MS\">Returns the probability value from the indicated Chi square that a hypothesis is confirmed.</ahelp> CHISQ.DIST.RT compares the Chi square value to be given for a random sample that is calculated from the sum of (observed value-expected value)^2/expected value for all values with the theoretical Chi square distribution and determines from this the probability of error for the hypothesis to be tested."
 msgstr ""
 
 #: 04060181.xhp
@@ -45692,7 +45063,7 @@ msgctxt ""
 "par_id2904953\n"
 "77\n"
 "help.text"
-msgid "<ahelp hid=\"HID_FUNC_NORMDIST_MS\">Returns the values of a lognormal distribution.</ahelp>"
+msgid "<ahelp hid=\"HID_FUNC_LOGNORMDIST_MS\">Returns the values of a lognormal distribution.</ahelp>"
 msgstr ""
 
 #: 04060183.xhp
@@ -53056,32 +52427,29 @@ msgctxt ""
 "04080000.xhp\n"
 "bm_id3154126\n"
 "help.text"
-msgid "<bookmark_value>formula list window</bookmark_value><bookmark_value>function list window</bookmark_value><bookmark_value>inserting functions; function list window</bookmark_value>"
+msgid "<bookmark_value>formula list window</bookmark_value>  <bookmark_value>function list window</bookmark_value>  <bookmark_value>inserting functions; function list window</bookmark_value>"
 msgstr ""
 
 #: 04080000.xhp
 msgctxt ""
 "04080000.xhp\n"
 "hd_id3154126\n"
-"1\n"
 "help.text"
-msgid "<link href=\"text/scalc/01/04080000.xhp\" name=\"Function List\">Function List</link>"
-msgstr "<link href=\"text/scalc/01/04080000.xhp\" name=\"فۇنكىسىيە تىزىملىكى\">فۇنكىسىيە تىزىملىكى</link>"
+msgid "<variable id=\"function_list_title\"><link href=\"text/scalc/01/04080000.xhp\" name=\"Function List\">Function List</link></variable>"
+msgstr ""
 
 #: 04080000.xhp
 msgctxt ""
 "04080000.xhp\n"
 "par_id3151118\n"
-"2\n"
 "help.text"
-msgid "<variable id=\"funktionslistetext\"><ahelp hid=\"HID_SC_FUNCTIONLIST\">This command opens the <emph>Function List</emph> window, which displays all functions that can be inserted into your document.</ahelp></variable> The <emph>Function List</emph> window is similar to the <emph>Functions</emph> tab page of the <link href=\"text/scalc/01/04060000.xhp\" name=\"Function Wizard\">Function Wizard</link>. The functions are inserted with placeholders to be replaced with your own values."
+msgid "<variable id=\"function_list_text\"><ahelp hid=\"HID_SC_FUNCTIONLIST\">Opens the Function List deck of the Sidebar, which displays all functions that can be inserted into your document.</ahelp></variable> The <emph>Function List</emph> deck is similar to the <emph>Functions</emph> tab page of the <link href=\"text/scalc/01/04060000.xhp\" name=\"Function Wizard\">Function Wizard</link>. The functions are inserted with placeholders to be replaced with your own values."
 msgstr ""
 
 #: 04080000.xhp
 msgctxt ""
 "04080000.xhp\n"
 "par_id3152576\n"
-"3\n"
 "help.text"
 msgid "The <emph>Function List</emph> window is a resizable <link href=\"text/shared/00/00000005.xhp#andocken\" name=\"dockable window\">dockable window</link>. Use it to quickly enter functions in the spreadsheet. By double-clicking an entry in the functions list, the respective function is directly inserted with all parameters."
 msgstr ""
@@ -53090,7 +52458,6 @@ msgstr ""
 msgctxt ""
 "04080000.xhp\n"
 "hd_id3145799\n"
-"4\n"
 "help.text"
 msgid "Category List"
 msgstr ""
@@ -53099,7 +52466,6 @@ msgstr ""
 msgctxt ""
 "04080000.xhp\n"
 "hd_id3153160\n"
-"5\n"
 "help.text"
 msgid "Function List"
 msgstr ""
@@ -53108,16 +52474,15 @@ msgstr ""
 msgctxt ""
 "04080000.xhp\n"
 "par_id3149412\n"
-"6\n"
 "help.text"
 msgid "<ahelp hid=\"SC:LISTBOX:FID_FUNCTION_BOX:LB_FUNC\">Displays the available functions.</ahelp> When you select a function, the area below the list box displays a short description. To insert the selected function double-click it or click the <emph>Insert Function into calculation sheet</emph> icon."
 msgstr ""
 
 #: 04080000.xhp
+#, fuzzy
 msgctxt ""
 "04080000.xhp\n"
 "hd_id3146971\n"
-"7\n"
 "help.text"
 msgid "Insert Function into calculation sheet"
 msgstr "فونكىسىيە قىستۇر"
@@ -53127,14 +52492,13 @@ msgctxt ""
 "04080000.xhp\n"
 "par_id3150043\n"
 "help.text"
-msgid "<image id=\"img_id3159267\" src=\"sc/res/fx.png\" width=\"0.1945inch\" height=\"0.1945inch\"><alt id=\"alt_id3159267\">Icon</alt></image>"
+msgid "<image id=\"img_id3159267\" src=\"sc/res/fx.png\"><alt id=\"alt_id3159267\">Icon</alt></image>"
 msgstr ""
 
 #: 04080000.xhp
 msgctxt ""
 "04080000.xhp\n"
 "par_id3147345\n"
-"8\n"
 "help.text"
 msgid "<ahelp hid=\"SC:IMAGEBUTTON:FID_FUNCTION_BOX:IMB_INSERT\">Inserts the selected function into the document.</ahelp>"
 msgstr ""
@@ -53711,13 +53075,14 @@ msgid "<link href=\"text/shared/01/05340200.xhp\" name=\"Width\">Width</link>"
 msgstr "<link href=\"text/scalc/01/12030000.xhp\" name=\"تەرتىپلە\">تەرتىپلە</link>"
 
 #: 05040000.xhp
+#, fuzzy
 msgctxt ""
 "05040000.xhp\n"
 "hd_id3145171\n"
 "4\n"
 "help.text"
 msgid "<link href=\"text/scalc/01/05040200.xhp\" name=\"Optimal Width\">Optimal Width</link>"
-msgstr ""
+msgstr "<link href=\"text/scalc/01/12030000.xhp\" name=\"تەرتىپلە\">تەرتىپلە</link>"
 
 #: 05040200.xhp
 msgctxt ""
@@ -54653,14 +54018,6 @@ msgstr ""
 #: 05080300.xhp
 msgctxt ""
 "05080300.xhp\n"
-"par_idN105AE\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/guide/printranges.xhp#printranges\"/>"
-msgstr ""
-
-#: 05080300.xhp
-msgctxt ""
-"05080300.xhp\n"
 "hd_id3156281\n"
 "3\n"
 "help.text"
@@ -54787,14 +54144,13 @@ msgctxt ""
 "05100000.xhp\n"
 "bm_id3150447\n"
 "help.text"
-msgid "<bookmark_value>Stylist, see Styles and Formatting window</bookmark_value>         <bookmark_value>Styles and Formatting window</bookmark_value>         <bookmark_value>formats; Styles and Formatting window</bookmark_value>         <bookmark_value>formatting; Styles and Formatting window</bookmark_value>         <bookmark_value>paint can for applying styles</bookmark_value>"
+msgid "<bookmark_value>Stylist, see Styles and Formatting window</bookmark_value>  <bookmark_value>Styles and Formatting window</bookmark_value>  <bookmark_value>formats; Styles and Formatting window</bookmark_value>  <bookmark_value>formatting; Styles and Formatting window</bookmark_value>  <bookmark_value>paint can for applying styles</bookmark_value>"
 msgstr ""
 
 #: 05100000.xhp
 msgctxt ""
 "05100000.xhp\n"
 "hd_id3150447\n"
-"1\n"
 "help.text"
 msgid "<link href=\"text/scalc/01/05100000.xhp\" name=\"Styles and Formatting\">Styles and Formatting</link>"
 msgstr ""
@@ -54803,16 +54159,14 @@ msgstr ""
 msgctxt ""
 "05100000.xhp\n"
 "par_id3147434\n"
-"2\n"
 "help.text"
-msgid "Use the Styles and Formatting window to assign styles to objects and text sections. You can update Styles, modify existing Styles or create new Styles."
+msgid "Use the Styles and Formatting deck of the Sidebar to assign styles to cells and pages. You can apply, update, and modify existing styles or create new styles."
 msgstr ""
 
 #: 05100000.xhp
 msgctxt ""
 "05100000.xhp\n"
 "par_id3149665\n"
-"30\n"
 "help.text"
 msgid "The Styles and Formatting <link href=\"text/shared/00/00000005.xhp#andocken\" name=\"dockable window\">dockable window</link> can remain open while editing the document."
 msgstr ""
@@ -54821,7 +54175,6 @@ msgstr ""
 msgctxt ""
 "05100000.xhp\n"
 "hd_id3150012\n"
-"36\n"
 "help.text"
 msgid "How to apply a cell style:"
 msgstr ""
@@ -54830,7 +54183,6 @@ msgstr ""
 msgctxt ""
 "05100000.xhp\n"
 "par_id3159155\n"
-"37\n"
 "help.text"
 msgid "Select the cell or cell range."
 msgstr ""
@@ -54839,16 +54191,15 @@ msgstr ""
 msgctxt ""
 "05100000.xhp\n"
 "par_id3145749\n"
-"38\n"
 "help.text"
 msgid "Double-click the style in the Styles and Formatting window."
 msgstr ""
 
 #: 05100000.xhp
+#, fuzzy
 msgctxt ""
 "05100000.xhp\n"
 "hd_id3153877\n"
-"4\n"
 "help.text"
 msgid "Cell Styles"
 msgstr "كاتەكچە ئۇسلۇبى"
@@ -54857,9 +54208,8 @@ msgstr "كاتەكچە ئۇسلۇبى"
 msgctxt ""
 "05100000.xhp\n"
 "par_id3145801\n"
-"6\n"
 "help.text"
-msgid "<ahelp hid=\".uno:ParaStyle\">Displays the list of the available Cell Styles for <link href=\"text/shared/00/00000005.xhp#formatierung\" name=\"indirect cell formatting\">indirect cell formatting</link>.</ahelp>"
+msgid "<ahelp hid=\".\">Displays the list of the available Cell Styles for <link href=\"text/shared/00/00000005.xhp#formatierung\" name=\"indirect cell formatting\">indirect cell formatting</link>.</ahelp>"
 msgstr ""
 
 #: 05100000.xhp
@@ -54867,23 +54217,23 @@ msgctxt ""
 "05100000.xhp\n"
 "par_id3150751\n"
 "help.text"
-msgid "<image id=\"img_id3153714\" src=\"sc/res/sf01.png\" width=\"0.1665in\" height=\"0.1665in\"><alt id=\"alt_id3153714\">Icon</alt></image>"
+msgid "<image id=\"img_id3153714\" src=\"sc/res/sf01.png\"><alt id=\"alt_id3153714\">Icon</alt></image>"
 msgstr ""
 
 #: 05100000.xhp
+#, fuzzy
 msgctxt ""
 "05100000.xhp\n"
 "par_id3154255\n"
-"5\n"
 "help.text"
 msgid "Cell Styles"
 msgstr "كاتەكچە ئۇسلۇبى"
 
 #: 05100000.xhp
+#, fuzzy
 msgctxt ""
 "05100000.xhp\n"
 "hd_id3153963\n"
-"7\n"
 "help.text"
 msgid "Page Styles"
 msgstr "بەت ئۇسلۇبى"
@@ -54892,9 +54242,8 @@ msgstr "بەت ئۇسلۇبى"
 msgctxt ""
 "05100000.xhp\n"
 "par_id3147003\n"
-"9\n"
 "help.text"
-msgid "<ahelp hid=\".uno:PageStyle\">Displays the Page Styles available for indirect page formatting.</ahelp>"
+msgid "<ahelp hid=\".\">Displays the Page Styles available for indirect page formatting.</ahelp>"
 msgstr ""
 
 #: 05100000.xhp
@@ -54902,23 +54251,23 @@ msgctxt ""
 "05100000.xhp\n"
 "par_id3159100\n"
 "help.text"
-msgid "<image id=\"img_id3149814\" src=\"sw/imglst/sf04.png\" width=\"0.1665in\" height=\"0.1665in\"><alt id=\"alt_id3149814\">Icon</alt></image>"
+msgid "<image id=\"img_id3149814\" src=\"sw/imglst/sf04.png\"><alt id=\"alt_id3149814\">Icon</alt></image>"
 msgstr ""
 
 #: 05100000.xhp
+#, fuzzy
 msgctxt ""
 "05100000.xhp\n"
 "par_id3150361\n"
-"8\n"
 "help.text"
 msgid "Page Styles"
 msgstr "بەت ئۇسلۇبى"
 
 #: 05100000.xhp
+#, fuzzy
 msgctxt ""
 "05100000.xhp\n"
 "hd_id3150202\n"
-"10\n"
 "help.text"
 msgid "Fill Format Mode"
 msgstr "پىچىم تولدۇرۇش ھالىتى"
@@ -54927,7 +54276,6 @@ msgstr "پىچىم تولدۇرۇش ھالىتى"
 msgctxt ""
 "05100000.xhp\n"
 "par_id3155531\n"
-"12\n"
 "help.text"
 msgid "<ahelp hid=\"HID_TEMPLDLG_WATERCAN\">Turns the Fill Format mode on and off. Use the paint can to assign the Style selected in the Styles and Formatting window.</ahelp>"
 msgstr ""
@@ -54937,14 +54285,14 @@ msgctxt ""
 "05100000.xhp\n"
 "par_id3155087\n"
 "help.text"
-msgid "<image id=\"img_id3153068\" src=\"cmd/sc_fillstyle.png\" width=\"0.1665in\" height=\"0.1665in\"><alt id=\"alt_id3153068\">Icon</alt></image>"
+msgid "<image id=\"img_id3153068\" src=\"cmd/sc_fillstyle.png\"><alt id=\"alt_id3153068\">Icon</alt></image>"
 msgstr ""
 
 #: 05100000.xhp
+#, fuzzy
 msgctxt ""
 "05100000.xhp\n"
 "par_id3156198\n"
-"11\n"
 "help.text"
 msgid "Fill Format Mode"
 msgstr "پىچىم تولدۇرۇش ھالىتى"
@@ -54953,7 +54301,6 @@ msgstr "پىچىم تولدۇرۇش ھالىتى"
 msgctxt ""
 "05100000.xhp\n"
 "hd_id3148870\n"
-"13\n"
 "help.text"
 msgid "How to apply a new style with the paint can:"
 msgstr ""
@@ -54962,7 +54309,6 @@ msgstr ""
 msgctxt ""
 "05100000.xhp\n"
 "par_id3145078\n"
-"27\n"
 "help.text"
 msgid "Select the desired style from the Styles and Formatting window."
 msgstr ""
@@ -54971,7 +54317,6 @@ msgstr ""
 msgctxt ""
 "05100000.xhp\n"
 "par_id3159098\n"
-"28\n"
 "help.text"
 msgid "Click the <emph>Fill Format Mode</emph> icon."
 msgstr ""
@@ -54980,7 +54325,6 @@ msgstr ""
 msgctxt ""
 "05100000.xhp\n"
 "par_id3148609\n"
-"15\n"
 "help.text"
 msgid "Click a cell to format it, or drag your mouse over a certain range to format the whole range. Repeat this action for other cells and ranges."
 msgstr ""
@@ -54989,16 +54333,15 @@ msgstr ""
 msgctxt ""
 "05100000.xhp\n"
 "par_id3149438\n"
-"29\n"
 "help.text"
 msgid "Click the <emph>Fill Format Mode</emph> again to exit this mode."
 msgstr ""
 
 #: 05100000.xhp
+#, fuzzy
 msgctxt ""
 "05100000.xhp\n"
 "hd_id3153975\n"
-"16\n"
 "help.text"
 msgid "New Style from Selection"
 msgstr "تاللانغان يېڭى ئۇسلۇب"
@@ -55007,7 +54350,6 @@ msgstr "تاللانغان يېڭى ئۇسلۇب"
 msgctxt ""
 "05100000.xhp\n"
 "par_id3149499\n"
-"18\n"
 "help.text"
 msgid "<ahelp hid=\"HID_TEMPLDLG_NEWBYEXAMPLE\">Creates a new style based on the formatting of a selected object.</ahelp> Assign a name for the style in the <link href=\"text/shared/01/05140100.xhp\" name=\"Create Style\">Create Style</link> dialog."
 msgstr ""
@@ -55017,23 +54359,23 @@ msgctxt ""
 "05100000.xhp\n"
 "par_id3150050\n"
 "help.text"
-msgid "<image id=\"img_id3154649\" src=\"cmd/sc_stylenewbyexample.png\" width=\"0.1665in\" height=\"0.1665in\"><alt id=\"alt_id3154649\">Icon</alt></image>"
+msgid "<image id=\"img_id3154649\" src=\"cmd/sc_stylenewbyexample.png\"><alt id=\"alt_id3154649\">Icon</alt></image>"
 msgstr ""
 
 #: 05100000.xhp
+#, fuzzy
 msgctxt ""
 "05100000.xhp\n"
 "par_id3146963\n"
-"17\n"
 "help.text"
 msgid "New Style from Selection"
 msgstr "تاللانغان يېڭى ئۇسلۇب"
 
 #: 05100000.xhp
+#, fuzzy
 msgctxt ""
 "05100000.xhp\n"
 "hd_id3153813\n"
-"19\n"
 "help.text"
 msgid "Update Style"
 msgstr "ئۇسلۇب يېڭىلا"
@@ -55042,7 +54384,6 @@ msgstr "ئۇسلۇب يېڭىلا"
 msgctxt ""
 "05100000.xhp\n"
 "par_id3154707\n"
-"21\n"
 "help.text"
 msgid "<ahelp hid=\"HID_TEMPLDLG_UPDATEBYEXAMPLE\">Updates the Style selected in the Styles and Formatting window with the current formatting of the selected object.</ahelp>"
 msgstr ""
@@ -55052,14 +54393,14 @@ msgctxt ""
 "05100000.xhp\n"
 "par_id3145118\n"
 "help.text"
-msgid "<image id=\"img_id3155754\" src=\"cmd/sc_styleupdatebyexample.png\" width=\"0.1665in\" height=\"0.1665in\"><alt id=\"alt_id3155754\">Icon</alt></image>"
+msgid "<image id=\"img_id3155754\" src=\"cmd/sc_styleupdatebyexample.png\"><alt id=\"alt_id3155754\">Icon</alt></image>"
 msgstr ""
 
 #: 05100000.xhp
+#, fuzzy
 msgctxt ""
 "05100000.xhp\n"
 "par_id3147501\n"
-"20\n"
 "help.text"
 msgid "Update Style"
 msgstr "ئۇسلۇب يېڭىلا"
@@ -55092,7 +54433,6 @@ msgstr ""
 msgctxt ""
 "05100000.xhp\n"
 "hd_id3149053\n"
-"24\n"
 "help.text"
 msgid "Style Groups"
 msgstr ""
@@ -55101,7 +54441,6 @@ msgstr ""
 msgctxt ""
 "05100000.xhp\n"
 "par_id3147299\n"
-"25\n"
 "help.text"
 msgid "<ahelp hid=\"HID_TEMPLATE_FILTER\">Lists the available style groups.</ahelp>"
 msgstr ""
@@ -55768,14 +55107,6 @@ msgctxt ""
 msgid "If you have defined a conditional formatting on a cell range and you try now to define a new conditional formatting on a part of this range, a warning message will be displayed, asking if you want to edit the existing conditional formatting (on the whole range) or define a new conditional formatting overlapping it (on the selected range)."
 msgstr ""
 
-#: 05120000.xhp
-msgctxt ""
-"05120000.xhp\n"
-"par_idN107E1\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/guide/cellstyle_conditional.xhp#cellstyle_conditional\"/>"
-msgstr ""
-
 #: 06020000.xhp
 msgctxt ""
 "06020000.xhp\n"
@@ -56492,14 +55823,6 @@ msgstr ""
 #: 06050000.xhp
 msgctxt ""
 "06050000.xhp\n"
-"par_idN10637\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/guide/scenario.xhp#scenario\"/>"
-msgstr ""
-
-#: 06050000.xhp
-msgctxt ""
-"06050000.xhp\n"
 "hd_id3156280\n"
 "3\n"
 "help.text"
@@ -56689,14 +56012,6 @@ msgctxt ""
 msgid "<link href=\"text/scalc/01/06060200.xhp\" name=\"Documents\">Documents</link>"
 msgstr "<link href=\"text/scalc/01/12030000.xhp\" name=\"تەرتىپلە\">تەرتىپلە</link>"
 
-#: 06060000.xhp
-msgctxt ""
-"06060000.xhp\n"
-"par_idN10622\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/guide/cell_protect.xhp#cell_protect\"/>"
-msgstr ""
-
 #: 06060100.xhp
 msgctxt ""
 "06060100.xhp\n"
@@ -57137,32 +56452,30 @@ msgctxt ""
 "07080000.xhp\n"
 "tit\n"
 "help.text"
-msgid "Split"
-msgstr "پارچىلا"
+msgid "Split Window"
+msgstr ""
 
 #: 07080000.xhp
+#, fuzzy
 msgctxt ""
 "07080000.xhp\n"
 "hd_id3163800\n"
-"1\n"
 "help.text"
-msgid "<link href=\"text/scalc/01/07080000.xhp\" name=\"Split\">Split</link>"
+msgid "<link href=\"text/scalc/01/07080000.xhp\" name=\"Split\">Split Window</link>"
 msgstr "<link href=\"text/scalc/01/12030000.xhp\" name=\"تەرتىپلە\">تەرتىپلە</link>"
 
 #: 07080000.xhp
 msgctxt ""
 "07080000.xhp\n"
 "par_id3150084\n"
-"2\n"
 "help.text"
-msgid "<ahelp hid=\".uno:SplitWindow\" visibility=\"visible\">Divides the current window at the top left corner of the active cell.</ahelp>"
+msgid "<ahelp hid=\".\">Divides the current window at the top left corner of the active cell.</ahelp>"
 msgstr ""
 
 #: 07080000.xhp
 msgctxt ""
 "07080000.xhp\n"
 "par_id3154910\n"
-"3\n"
 "help.text"
 msgid "You can also use the mouse to split the window horizontally or vertically. To do this, drag the thick black line located directly above the vertical scrollbar or directly to the right of the horizontal scrollbar into the window. A thick black line will show where the window is split."
 msgstr ""
@@ -57171,7 +56484,6 @@ msgstr ""
 msgctxt ""
 "07080000.xhp\n"
 "par_id3149263\n"
-"4\n"
 "help.text"
 msgid "A split window has its own scrollbars in each partial section; by contrast, <link href=\"text/scalc/01/07090000.xhp\" name=\"fixed window sections\">fixed window sections</link> are not scrollable."
 msgstr ""
@@ -57181,25 +56493,24 @@ msgctxt ""
 "07090000.xhp\n"
 "tit\n"
 "help.text"
-msgid "Freeze"
+msgid "Freeze Rows and Columns"
 msgstr ""
 
 #: 07090000.xhp
+#, fuzzy
 msgctxt ""
 "07090000.xhp\n"
 "hd_id3150517\n"
-"1\n"
 "help.text"
-msgid "<link href=\"text/scalc/01/07090000.xhp\" name=\"Freeze\">Freeze</link>"
+msgid "<link href=\"text/scalc/01/07090000.xhp\" name=\"Freeze\">Freeze Rows and Columns</link>"
 msgstr "<link href=\"text/scalc/01/12030000.xhp\" name=\"تەرتىپلە\">تەرتىپلە</link>"
 
 #: 07090000.xhp
 msgctxt ""
 "07090000.xhp\n"
 "par_id3156289\n"
-"2\n"
 "help.text"
-msgid "<ahelp hid=\".uno:FreezePanes\" visibility=\"visible\">Divides the sheet at the top left corner of the active cell and the area to the top left is no longer scrollable.</ahelp>"
+msgid "<ahelp hid=\".\">Divides the sheet at the top left corner of the active cell and the area to the top left is no longer scrollable.</ahelp>"
 msgstr ""
 
 #: 12010000.xhp
@@ -58305,14 +57616,6 @@ msgstr ""
 #: 12040300.xhp
 msgctxt ""
 "12040300.xhp\n"
-"par_idN105EB\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/guide/filters.xhp#filters\"/>"
-msgstr ""
-
-#: 12040300.xhp
-msgctxt ""
-"12040300.xhp\n"
 "hd_id3153771\n"
 "25\n"
 "help.text"
@@ -60515,12 +59818,12 @@ msgid "<ahelp hid=\"modules/scalc/ui/pivotfilterdialog/val3\" visibility=\"visib
 msgstr ""
 
 #: 12090103.xhp
+#, fuzzy
 msgctxt ""
 "12090103.xhp\n"
 "hd_id3146980\n"
-"27\n"
 "help.text"
-msgid "<link href=\"text/scalc/01/12090104.xhp\" name=\"More>>\">More>></link>"
+msgid "<link href=\"text/scalc/01/12090104.xhp\" name=\"Options\">Options</link>"
 msgstr "<link href=\"text/scalc/01/12030000.xhp\" name=\"تەرتىپلە\">تەرتىپلە</link>"
 
 #: 12090104.xhp
@@ -60546,7 +59849,7 @@ msgctxt ""
 "par_id3147102\n"
 "2\n"
 "help.text"
-msgid "<variable id=\"zusaetzetext\"><ahelp hid=\"\" visibility=\"visible\">Displays or hides additional filtering options.</ahelp></variable>"
+msgid "<variable id=\"zusaetzetext\"><ahelp hid=\"modules/scalc/ui/pivotfilterdialog/more\" visibility=\"visible\">Displays or hides additional filtering options.</ahelp></variable>"
 msgstr ""
 
 #: 12090104.xhp
@@ -60573,7 +59876,7 @@ msgctxt ""
 "par_id3145673\n"
 "6\n"
 "help.text"
-msgid "Distinguishes between uppercase and lowercase letters."
+msgid "<ahelp hid=\".\" visibility=\"visible\">Distinguishes between uppercase and lowercase letters.</ahelp>"
 msgstr ""
 
 #: 12090104.xhp
@@ -60591,7 +59894,7 @@ msgctxt ""
 "par_id3151245\n"
 "8\n"
 "help.text"
-msgid "Allows you to use wildcards in the filter definition."
+msgid "<ahelp hid=\".\" visibility=\"visible\">Allows you to use wildcards in the filter definition.</ahelp>"
 msgstr ""
 
 #: 12090104.xhp
@@ -60607,9 +59910,8 @@ msgstr ""
 msgctxt ""
 "12090104.xhp\n"
 "hd_id3153379\n"
-"30\n"
 "help.text"
-msgid "Unique records only"
+msgid "No duplications"
 msgstr ""
 
 #: 12090104.xhp
@@ -60618,43 +59920,24 @@ msgctxt ""
 "par_id3154138\n"
 "31\n"
 "help.text"
-msgid "Excludes duplicate rows in the list of filtered data."
+msgid "<ahelp hid=\".\" visibility=\"visible\">Excludes duplicate rows in the list of filtered data.</ahelp>"
 msgstr ""
 
 #: 12090104.xhp
+#, fuzzy
 msgctxt ""
 "12090104.xhp\n"
 "hd_id3156282\n"
-"32\n"
 "help.text"
-msgid "Data area"
-msgstr ""
+msgid "Data range"
+msgstr "سانلىق مەلۇمات دائىرىسى"
 
 #: 12090104.xhp
 msgctxt ""
 "12090104.xhp\n"
 "par_id3150768\n"
-"33\n"
-"help.text"
-msgid "Displays the name of the filtered data area in the table."
-msgstr ""
-
-#: 12090104.xhp
-msgctxt ""
-"12090104.xhp\n"
-"hd_id3156424\n"
-"34\n"
-"help.text"
-msgid "More<<"
-msgstr ""
-
-#: 12090104.xhp
-msgctxt ""
-"12090104.xhp\n"
-"par_id3125864\n"
-"35\n"
 "help.text"
-msgid "Hides the additional options."
+msgid "<ahelp hid=\".\" visibility=\"visible\">Displays the name of the filtered data range in the table.</ahelp>"
 msgstr ""
 
 #: 12090104.xhp
@@ -61622,14 +60905,6 @@ msgctxt ""
 msgid "In the case of grouping date values, specifies the intervals to group by."
 msgstr ""
 
-#: 12090400.xhp
-msgctxt ""
-"12090400.xhp\n"
-"par_idN105B2\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/guide/datapilot_grouping.xhp#datapilot_grouping\"/>"
-msgstr ""
-
 #: 12100000.xhp
 msgctxt ""
 "12100000.xhp\n"
@@ -61957,7 +61232,7 @@ msgctxt ""
 "12120100.xhp\n"
 "par_idN1070D\n"
 "help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/showlist\">Shows a list of all valid strings or values to select from. The list can also be opened by selecting the cell and pressing Ctrl+D (Mac: Command+D).</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/showlist\">Shows a list of all valid strings or values to select from. The list can also be opened by selecting the cell and pressing <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+D.</ahelp>"
 msgstr ""
 
 #: 12120100.xhp
@@ -62343,7 +61618,120 @@ msgctxt ""
 "ODFF.xhp\n"
 "hd_id1000010\n"
 "help.text"
-msgid "This function belongs to Open Document Formula version 1.2 Standard."
+msgid "This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)"
+msgstr ""
+
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"tit\n"
+"help.text"
+msgid "Examples Dataset for Statistical Functions"
+msgstr ""
+
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"hd_id182061916311770\n"
+"help.text"
+msgid "Examples Dataset for a family of the AVERAGE"
+msgstr ""
+
+#: ex_data_stat_func.xhp
+#, fuzzy
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"hd_id2657394931588\n"
+"help.text"
+msgid "Examples"
+msgstr "مىساللار:"
+
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"hd_id2609201512474295\n"
+"help.text"
+msgid "Consider the following table"
+msgstr ""
+
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id18260631312423\n"
+"help.text"
+msgid "Product Name"
+msgstr ""
+
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id2509201517433075\n"
+"help.text"
+msgid "Sales"
+msgstr ""
+
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id2509201519383294\n"
+"help.text"
+msgid "Revenue"
+msgstr ""
+
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id2855779586764\n"
+"help.text"
+msgid "pencil"
+msgstr ""
+
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id24967262611733\n"
+"help.text"
+msgid "pen"
+msgstr ""
+
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id252542413030532\n"
+"help.text"
+msgid "notebook"
+msgstr ""
+
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id2509201519374677\n"
+"help.text"
+msgid "book"
+msgstr ""
+
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id19479417931163\n"
+"help.text"
+msgid "pencil-case"
+msgstr ""
+
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id85353130721737\n"
+"help.text"
+msgid "not"
+msgstr ""
+
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id15693941827291\n"
+"help.text"
+msgid "not"
 msgstr ""
 
 #: format_graphic.xhp
@@ -62402,6 +61790,1399 @@ msgctxt ""
 msgid "<ahelp hid=\".\">Switches <emph>Edit Points</emph> mode for an inserted freeform line on and off.</ahelp>"
 msgstr ""
 
+#: ful_func.xhp
+msgctxt ""
+"ful_func.xhp\n"
+"tit\n"
+"help.text"
+msgid "Frequently Used Lexemes"
+msgstr ""
+
+#: ful_func.xhp
+msgctxt ""
+"ful_func.xhp\n"
+"hd_id126511265112651\n"
+"help.text"
+msgid "Syntax"
+msgstr ""
+
+#: ful_func.xhp
+#, fuzzy
+msgctxt ""
+"ful_func.xhp\n"
+"hd_id980889808898088\n"
+"help.text"
+msgid "Examples"
+msgstr "مىساللار:"
+
+#: ful_func.xhp
+msgctxt ""
+"ful_func.xhp\n"
+"par_id2595283314097\n"
+"help.text"
+msgid "<variable id=\"func_im_comp_numb\"><emph>Complex_number</emph> is a complex number that is entered in the form \"a+bi\" or \"a+bj\", or is the result of a string operation with other functions, cell references, or expressed by concatenating (&) other strings, resulting in a string in the form \"a+bi\" or \"a+bj\".</variable>"
+msgstr ""
+
+#: ful_func.xhp
+msgctxt ""
+"ful_func.xhp\n"
+"par_id26516178768369\n"
+"help.text"
+msgid "<variable id=\"func_im_real_numb\">If <emph>Complex_number</emph> is actually a real number (b=0), then it can be either a string expression or a number value.</variable>"
+msgstr ""
+
+#: ful_func.xhp
+msgctxt ""
+"ful_func.xhp\n"
+"par_id1566939488738\n"
+"help.text"
+msgid "<variable id=\"func_im_return_text\">The function always returns a string representing a complex number.</variable>"
+msgstr ""
+
+#: ful_func.xhp
+msgctxt ""
+"ful_func.xhp\n"
+"par_id9623767621137\n"
+"help.text"
+msgid "<variable id=\"func_im_ignor_zero\">If the result is a complex number with one of its parts (a or b) equal to zero, that part is not displayed.</variable>"
+msgstr ""
+
+#: ful_func.xhp
+msgctxt ""
+"ful_func.xhp\n"
+"par_id962376762132\n"
+"help.text"
+msgid "<variable id=\"func_define_complex\"><emph>Complex_number</emph> - A string representing a complex number, a real number in either string or number format, or a reference to a cell containing a number</variable>"
+msgstr ""
+
+#: ful_func.xhp
+msgctxt ""
+"ful_func.xhp\n"
+"par_id962376732432\n"
+"help.text"
+msgid "<variable id=\"func_imag_zero\">The imaginary part is equal to zero, so it is not displayed in the result.</variable>"
+msgstr ""
+
+#: ful_func.xhp
+msgctxt ""
+"ful_func.xhp\n"
+"par_id29750345314640\n"
+"help.text"
+msgid "The result is presented in the string format and has the character \"i\" or \"j\" as an imaginary unit."
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"tit\n"
+"help.text"
+msgid "AGGREGATE function"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"bm_id126123001625791\n"
+"help.text"
+msgid "<bookmark_value>AGGREGATE function</bookmark_value>"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"hd_id3154073\n"
+"help.text"
+msgid "<variable id=\"aggregate_head\"><link href=\"text/scalc/01/func_aggregate.xhp\">AGGREGATE</link></variable> function"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2209201514174373\n"
+"help.text"
+msgid "<ahelp hid=\".\"><variable id=\"aggregate_des\">This function returns an aggregate result of the calculations in the range. You can use different aggregate functions listed below. The Aggregate function enables you to omit hidden rows, errors, SUBTOTAL and other AGGREGATE function results in the calculation.</variable></ahelp>"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2209201514174453\n"
+"help.text"
+msgid "AGGREGATE function is applied to vertical ranges of data with activated AutoFilter. If AutoFilter is not activated, automatic recalculation of the function result does not work for newly hidden rows. It is not supposed to work with horizontal ranges, however it can be applied to them as well, but with limitations. In particular, the AGGREGATE function applied to a horizontal data range does not recognize hiding columns, however correctly omits errors and results of SUBTOTAL and other AGGREGATE functions embedded into the row."
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"hd_id239693194826384\n"
+"help.text"
+msgid "Syntax"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id200801176228491\n"
+"help.text"
+msgid "AGGREGATE(Function; Option; Ref1 [; Ref2 [; …]])"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201516102726\n"
+"help.text"
+msgid "or"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id30181907128680\n"
+"help.text"
+msgid "AGGREGATE(Function; Option; Array [; k])"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2209201514174378\n"
+"help.text"
+msgid "<emph>Function</emph> – obligatory argument. A function index or a reference to a cell with value from 1 to 19, in accordance with the following table."
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201511454963\n"
+"help.text"
+msgid "Function index"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201511454945\n"
+"help.text"
+msgid "Function applied"
+msgstr ""
+
+#: func_aggregate.xhp
+#, fuzzy
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201511360043\n"
+"help.text"
+msgid "AVERAGE"
+msgstr "AVERAGE"
+
+#: func_aggregate.xhp
+#, fuzzy
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id230920151136007\n"
+"help.text"
+msgid "COUNT"
+msgstr "COUNT"
+
+#: func_aggregate.xhp
+#, fuzzy
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201511360018\n"
+"help.text"
+msgid "COUNTA"
+msgstr "COUNTA"
+
+#: func_aggregate.xhp
+#, fuzzy
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201511360026\n"
+"help.text"
+msgid "MAX"
+msgstr "MAX"
+
+#: func_aggregate.xhp
+#, fuzzy
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201511360078\n"
+"help.text"
+msgid "MIN"
+msgstr "MIN"
+
+#: func_aggregate.xhp
+#, fuzzy
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201511360087\n"
+"help.text"
+msgid "PRODUCT"
+msgstr "PRODUCT"
+
+#: func_aggregate.xhp
+#, fuzzy
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201511360153\n"
+"help.text"
+msgid "STDEV.S"
+msgstr "STDEVP"
+
+#: func_aggregate.xhp
+#, fuzzy
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201511360178\n"
+"help.text"
+msgid "STDEV.P"
+msgstr "STDEVP"
+
+#: func_aggregate.xhp
+#, fuzzy
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201511360199\n"
+"help.text"
+msgid "SUM"
+msgstr "SUM"
+
+#: func_aggregate.xhp
+#, fuzzy
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201511360174\n"
+"help.text"
+msgid "VAR.S"
+msgstr "VARP"
+
+#: func_aggregate.xhp
+#, fuzzy
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201511360120\n"
+"help.text"
+msgid "VAR.P"
+msgstr "VARP"
+
+#: func_aggregate.xhp
+#, fuzzy
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201511360122\n"
+"help.text"
+msgid "MEDIAN"
+msgstr "MEDIAN"
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id230920151136016\n"
+"help.text"
+msgid "MODE.SNGL"
+msgstr ""
+
+#: func_aggregate.xhp
+#, fuzzy
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201511360180\n"
+"help.text"
+msgid "LARGE"
+msgstr "LARGE"
+
+#: func_aggregate.xhp
+#, fuzzy
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201511360150\n"
+"help.text"
+msgid "SMALL"
+msgstr "SMALL"
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201511360157\n"
+"help.text"
+msgid "PERCENTILE.INC"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201511360151\n"
+"help.text"
+msgid "QUARTILE.INC"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id230920151136017\n"
+"help.text"
+msgid "PERCENTILE.EXC"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201511360169\n"
+"help.text"
+msgid "QUARTILE.EXC"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2209201514174372\n"
+"help.text"
+msgid "<emph>Option</emph> – obligatory argument. An option index or reference to a cell with value from 0 to 7 determines what to ignore in the range for the function."
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201512011557\n"
+"help.text"
+msgid "Option index"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201512011551\n"
+"help.text"
+msgid "Option applied"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201512011567\n"
+"help.text"
+msgid "Ignore only nested SUBTOTAL and AGGREGATE functions"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id315771547630277\n"
+"help.text"
+msgid "Ignore only hidden rows, nested SUBTOTAL and AGGREGATE functions"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201512011514\n"
+"help.text"
+msgid "Ignore only errors, nested SUBTOTAL and AGGREGATE functions"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201512011547\n"
+"help.text"
+msgid "Ignore hidden rows, errors, nested SUBTOTAL and AGGREGATE functions"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201512011510\n"
+"help.text"
+msgid "Ignore nothing"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201512011592\n"
+"help.text"
+msgid "Ignore only hidden rows"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id230920151201150\n"
+"help.text"
+msgid "Ignore only errors"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201512011539\n"
+"help.text"
+msgid "Ignore only hidden rows and errors"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id220402843321947\n"
+"help.text"
+msgid "<emph>Ref1</emph> – obligatory argument. The first numeric argument (if the range is set by a list of values inside the function) or a reference to a cell that contains it."
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201514193338\n"
+"help.text"
+msgid "<emph>Ref2,3,...</emph> – optional. A numeric argument or a reference to a cell (up to 253 arguments), for which you need the aggregate value."
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id99381371214702\n"
+"help.text"
+msgid "<emph>Array</emph> – obligatory argument. The array can be specified by the boundaries of the range, the name of the named range or the column label."
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201515555812\n"
+"help.text"
+msgid "For using column labels “Automatically find columns and rows labels” function needs to be enabled."
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2209201514174370\n"
+"help.text"
+msgid "<emph>k</emph> – obligatory argument for the following functions: LARGE, SMALL, PERCENTILE.INC, QUARTILE.INC, PERCENTILE.EXC, QUARTILE.EXC. It is a numeric argument, which must correspond to the second argument of these functions."
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201516525483\n"
+"help.text"
+msgid "If the second argument is necessary, but not specified, the function returns the error Err:511.<br/>If the second argument specified not correctly, the function returns the error Err:502."
+msgstr ""
+
+#: func_aggregate.xhp
+#, fuzzy
+msgctxt ""
+"func_aggregate.xhp\n"
+"hd_id198071265128228\n"
+"help.text"
+msgid "Examples"
+msgstr "مىساللار:"
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201518454314\n"
+"help.text"
+msgid "<emph>ColumnOne</emph>"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201518454361\n"
+"help.text"
+msgid "<emph>ColumnTwo</emph>"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201518454323\n"
+"help.text"
+msgid "<emph>ColumnThree</emph>"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id27530261624700\n"
+"help.text"
+msgid "#DIV/0!"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201517384053\n"
+"help.text"
+msgid "3"
+msgstr ""
+
+#: func_aggregate.xhp
+#, fuzzy
+msgctxt ""
+"func_aggregate.xhp\n"
+"id_par29987248418152\n"
+"help.text"
+msgid "#VALUE!"
+msgstr "#VALUE!"
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id230920152006414\n"
+"help.text"
+msgid "<item type=\"input\">=AGGREGATE(4;1;A2:A9)</item><br/>Returns maximum value for the range A2:A9 =34, whereas <item type=\"input\">=MAX(A2:A9)</item> returns the error Err:511."
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201520064180\n"
+"help.text"
+msgid "<item type=\"input\">=AGGREGATE(9;5;A5:C5)</item><br/>Returns sum for the range A5:C5 =29, even if the some of the columns are hidden."
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201520064118\n"
+"help.text"
+msgid "<item type=\"input\">=AGGREGATE(9;5;B2:B9)</item><br/>Returns sum of the column B =115. If any row is hidden, the function omit its value, for example if the 7th row is hidden, the function returns 95."
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id196152404026557\n"
+"help.text"
+msgid "If you need to apply the function with a 3-D range, this example shows how to do it."
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201520180167\n"
+"help.text"
+msgid "<item type=\"input\">=AGGREGATE(13;3;Sheet1.B2:B9:Sheet3.B2:B9)</item><br/>The function returns mode of the values of second columns through sheets 1:3 (that have the same data) =8."
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201520395365\n"
+"help.text"
+msgid "You can use reference to a cell or a range for every argument in the formula. The following example shows how it works. Besides, it shows that you can use column labels to specify an array."
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id2309201520395380\n"
+"help.text"
+msgid "<item type=\"input\">=AGGREGATE(E3;E5;'ColumnOne')</item><br/>If E5 =13 and E7 =5, the function returns mode of the first column =10."
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id241712879431120\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link>, <link href=\"text/scalc/01/04060181.xhp#count\">COUNT</link>, <link href=\"text/scalc/01/04060181.xhp#counta\">COUNTA</link>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>, <link href=\"text/scalc/01/04060106.xhp#Section26\">PRODUCT</link>, <link href=\"text/scalc/01/04060185.xhp#stdevdots\">STDEV.S</link>, <link href=\"text/scalc/01/04060185.xhp#stdevdotp\">STDEV.P</link>, <link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link>, <link href=\"text/scalc/01/04060185.xhp#vardots\">VAR.S</link>, <link href=\"text/scalc/01/04060185.xhp#vardotp\">VAR.P</link>, <link href=\"text/scalc/01/04060184.xhp#median\">MEDIAN</link>, <link href=\"text/scalc/01/04060184.xhp#modedotsngl\">MODE.SNGL</link>, <link href=\"text/scalc/01/04060183.xhp#large\">LARGE</link>, <link href=\"text/scalc/01/04060183.xhp#small\">SMALL</link>, <link href=\"text/scalc/01/04060184.xhp#percentileinc\">PERCENTILE.INC</link> , <link href=\"text/scalc/01/04060184.xhp#quartileinc\">QUARTILE.INC</link>, <link href=\"text/scalc/01/04060184.xhp#percentileexc\">PERCENTILE.EXC</link>, <link href=\"text/scalc/01/04060184.xhp#quartileexc\">QUARTILE.EXC</link>"
+msgstr ""
+
+#: func_aggregate.xhp
+msgctxt ""
+"func_aggregate.xhp\n"
+"par_id125062615028497\n"
+"help.text"
+msgid "<link href=\"text/shared/optionen/01060500.xhp#hd_id3156199\">Automatically find column and row labels</link>"
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"tit\n"
+"help.text"
+msgid "AVERAGEIF function"
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"bm_id237812197829662\n"
+"help.text"
+msgid "<bookmark_value>AVERAGEIF function</bookmark_value>  <bookmark_value>arithmetic mean;satisfying condition</bookmark_value>"
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"hd_id16852304621982\n"
+"help.text"
+msgid "<variable id=\"averageif_head\"><link href=\"text/scalc/01/func_averageif.xhp\">AVERAGEIF</link></variable> function"
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id7281266615152\n"
+"help.text"
+msgid "<ahelp hid=\".\"><variable id=\"averageif_des\">Returns the arithmetic mean of all cells in a range that satisfy a given condition. The AVERAGEIF function sums up all the results that match the logical test and divides this sum by the quantity of selected values.</variable></ahelp>"
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"hd_id210572014129502\n"
+"help.text"
+msgid "Syntax"
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id200801176228491\n"
+"help.text"
+msgid "AVERAGEIF(Range; Criterion [; Average_Range ])"
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id15226321619829\n"
+"help.text"
+msgid "<emph>Range</emph> – required argument. An array, a name of named range or a label of a column or a row containing numbers for averaging or numbers or text for the condition."
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id24499731228013\n"
+"help.text"
+msgid "<emph>Criterion</emph> – required argument. A condition in the form of expression or a cell reference with expression that defines what cells should be used to calculate the mean. The expression can contain text, numbers or regular expressions."
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id174711913219765\n"
+"help.text"
+msgid "<emph>Average_Range</emph> – optional. It is a range of values for calculating the mean."
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id45123108916423\n"
+"help.text"
+msgid "Note that if the <emph>Average_Range</emph> is not specified, <emph>Range</emph> is used for both, the calculation of the mean and the search according to the condition. If the <emph>Average_Range</emph> is specified, the <emph>Range</emph> is used only for the condition test, while <emph>Average_Range</emph> is used for the mean calculation.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and an operation of a string concatenation (&)."
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id278275053653\n"
+"help.text"
+msgid "If a cell in a range of values for calculating the mean is empty or contains text, function AVERAGEIF ignores this cell.<br/>If the whole range is empty, contains only text or all values of the range do not satisfy the condition (or any combination of those), the function returns the #DIV/0! error."
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id38832436828097\n"
+"help.text"
+msgid "In all calculations below, range for average calculation contains the row #6, but it is ignored, because it contains text."
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"hd_id229513120314273\n"
+"help.text"
+msgid "Simple usage"
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id2509201519225446\n"
+"help.text"
+msgid "<item type=\"input\">=AVERAGEIF(B2:B6;\"<35\")</item>"
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id11322891219251\n"
+"help.text"
+msgid "Calculates the average for values of the range B2:B6 that are less than 35. Returns 19, because the second row does not participate in the calculation."
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id250920151922590\n"
+"help.text"
+msgid "<item type=\"input\">=AVERAGEIF(B2:B6;\"<\"&MAX(B2:B6))</item>"
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id3813266131474\n"
+"help.text"
+msgid "Calculates the average for values of the same range that are less than the maximum value of this range. Returns 19, because the largest value (the second row) does not participate in the calculation."
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id2509201519230832\n"
+"help.text"
+msgid "<item type=\"input\">=AVERAGEIF(B2:B6;\">\"&SMALL(B2:B6;1))</item>"
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id243522732832394\n"
+"help.text"
+msgid "Calculates the average for values of the same range that are greater than the first smallest value of this range. Returns 25, because the first smallest value (the fourth row) does not participate in the calculation."
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"hd_id2101254257133\n"
+"help.text"
+msgid "Using the Average_Range"
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id2509201519315584\n"
+"help.text"
+msgid "<item type=\"input\">=AVERAGEIF(B2:B6;\"<35\";C2:C6)</item>"
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id148222637631350\n"
+"help.text"
+msgid "The function searches what values are less than 35 in the B2:B6 range, and calculates the average of corresponding values from the C2:C6 range. Returns 145, because the second row does not participate in the calculation."
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id2509201519315535\n"
+"help.text"
+msgid "<item type=\"input\">=AVERAGEIF(B2:B6;\">\"&MIN(B2:B6);C2:C6)</item>"
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id2412836525208\n"
+"help.text"
+msgid "The function searches what values from the range B2:B6 are greater than the least value in the B2:B6 range, and calculates the average of corresponding values from the C2:C6 range. Returns 113.3, because the fourth row (where there is the least value in the range B2:B6) does not participate in the calculation."
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id2509201519315547\n"
+"help.text"
+msgid "<item type=\"input\">=AVERAGEIF(B2:B6;\"<\"&LARGE(B2:B6;2);C2:C6)</item>"
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id173931101529497\n"
+"help.text"
+msgid "The function searches what values from the range B2:B6 are less than the second large value in the B2:B6 range, and calculates the average of corresponding values from the C2:C6 range. Returns 180, because only the fourth row participates in the calculation."
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"hd_id30054471316969\n"
+"help.text"
+msgid "Using regular expressions"
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id2509201519360514\n"
+"help.text"
+msgid "<item type=\"input\">=AVERAGEIF(A2:A6;\"pen\";B2:B6)</item>"
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id14714860719948\n"
+"help.text"
+msgid "The function searches what cells from the range A2:A6 contain only the word “pen”, and calculates the average of corresponding values from the B2:B6 range. Returns 35, because only the second row participates in the calculation. The search is performed in the A2:A6 range, but the values are returned from the B2:B6 range."
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id250920151936096\n"
+"help.text"
+msgid "<item type=\"input\">=AVERAGEIF(A2:A6;\"pen.*\";B2:B6)</item>"
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id26959239098104\n"
+"help.text"
+msgid "The function searches what cells from the range A2:A6 begin with “pen” ending with any quantity of other symbols, and calculates the average of corresponding values from the B2:B6 range. Returns 27.5, because now also “pencil” satisfies the condition, and both, first and second rows participate in the calculation."
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id2509201519361352\n"
+"help.text"
+msgid "<item type=\"input\">=AVERAGEIF(A2:A6;\".*book.*\";B2:B6)</item>"
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id227041304619482\n"
+"help.text"
+msgid "The function searches what cells from the range A2:A6 contain “book” starting and ending with any quantity of other symbols, and calculates the average of corresponding values from the B2:B6 range. Returns 18.5, because only third and fourth rows participate in the calculation."
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"hd_id251309885188\n"
+"help.text"
+msgid "Reference to a cell as a criterion"
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id177972099720424\n"
+"help.text"
+msgid "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 AVERAGEIF function."
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id134941261230060\n"
+"help.text"
+msgid "<item type=\"input\">=AVERAGEIF(A2:A6;\".*\"&E2&\".*\";B2:B6)</item>"
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id172572288310247\n"
+"help.text"
+msgid "The function searches what cells from the range A2:A6 contain a combination of symbols specified in E2 starting and ending with any quantity of other symbols, and calculates the average of corresponding values from the B2:B6 range. If E2 = book, the function returns 18.5."
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id316901523627285\n"
+"help.text"
+msgid "<item type=\"input\">=AVERAGEIF(A2:A6;\"<\"&E2;B2:B6)</item>"
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id302181300528607\n"
+"help.text"
+msgid "The function searches what cells from the range A2:A6 are less than the value specified in E2, and calculates the average of corresponding values from the B2:B6 range. If E2 = 35, the function returns 145."
+msgstr ""
+
+#: func_averageif.xhp
+msgctxt ""
+"func_averageif.xhp\n"
+"par_id171371269326270\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link>, <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>, <link href=\"text/scalc/01/04060183.xhp#large\">LARGE</link>, <link href=\"text/scalc/01/04060183.xhp#small\">SMALL</link>"
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"tit\n"
+"help.text"
+msgid "AVERAGEIFS function"
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"bm_id536715367153671\n"
+"help.text"
+msgid "<bookmark_value>AVERAGEIFS function</bookmark_value>  <bookmark_value>arithmetic mean;satisfying conditions</bookmark_value>"
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"hd_id537445374453744\n"
+"help.text"
+msgid "<variable id=\"averageifs_head\"><link href=\"text/scalc/01/func_averageifs.xhp\">AVERAGEIFS</link></variable> function"
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"par_id538405384053840\n"
+"help.text"
+msgid "<ahelp hid=\".\"><variable id=\"averageifs_des\">Returns the arithmetic mean of all cells in a range that satisfy given multiple criteria. The AVERAGEIFS function sums up all the results that match the logical tests and divides this sum by the quantity of selected values.</variable></ahelp>"
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"hd_id538895388953889\n"
+"help.text"
+msgid "Syntax"
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"par_id21050267713178\n"
+"help.text"
+msgid "AVERAGEIFS(Average_range; Criterion_range1; Criterion1 [; Criterion_range2; Criterion2 [; ...]])"
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"par_id165832700711773\n"
+"help.text"
+msgid "<emph>Average_range</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 calculating the mean."
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"par_id23557225011065\n"
+"help.text"
+msgid "<emph>Criterion_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 finding the corresponding criterion."
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"par_id115612745015792\n"
+"help.text"
+msgid "<emph>Criterion1</emph> – required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used to calculate the mean. The expression can contain text, numbers or regular expressions."
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"par_id249477513695\n"
+"help.text"
+msgid "<emph>Criterion_range2</emph> – Optional. Criterion_range2 and all the following mean the same as Criterion_range1."
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"par_id157492744623347\n"
+"help.text"
+msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1."
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"par_id262061474420658\n"
+"help.text"
+msgid "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given Average_range is taken into calculation of the mean.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and the operator of a string concatenation (&).<br/>The operators equal to (=), not equal to (<>), greater than (>), greater than or equal to (>=), less than (<), and less than or equal to (<=) can be used in criterion arguments for comparison of numbers.<br/>The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for it."
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"par_id51531273215056\n"
+"help.text"
+msgid "If a cell in a range of values for calculating the mean is empty or contains text, the function AVERAGEIFS ignores this cell.<br/>If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).<br/>If the whole range is empty, contains only text or all values of the range do not satisfy the condition (or any combination of those), the function returns the #DIV/0! error.<br/>If the range of values for calculating the mean and any range for finding criterion have unequal sizes, the function returns err:502."
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"par_id151201977228038\n"
+"help.text"
+msgid "In all examples below, ranges for average calculation contain the row #6, but it is ignored, because it contains text."
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"hd_id20733192524041\n"
+"help.text"
+msgid "Simple usage"
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"par_id24004653627203\n"
+"help.text"
+msgid "<item type=\"input\">=AVERAGEIFS(B2:B6;B2:B6;\">=20\")</item>"
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"par_id30201168686268\n"
+"help.text"
+msgid "Calculates the average for values of the range B2:B6 that are greater than or equal to 20. Returns 25, because the fifth row does not meet the criterion."
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"par_id30279247419921\n"
+"help.text"
+msgid "<item type=\"input\">=AVERAGEIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">70\")</item>"
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"par_id2930764965983\n"
+"help.text"
+msgid "Calculates the average for values of the range C2:C6 that are greater than 70 and correspond to cells of B2:B6 with values  greater than or equal to 20. Returns 137.5, because the second and fifth rows do not meet at least one criterion."
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"hd_id317532515726820\n"
+"help.text"
+msgid "Using regular expressions and nested functions"
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"par_id457966021670\n"
+"help.text"
+msgid "<item type=\"input\">=AVERAGEIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>"
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"par_id66091035229950\n"
+"help.text"
+msgid "Calculates the average for values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 127.5, because the third and fifth rows do not meet at least one criterion."
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"par_id303162761931870\n"
+"help.text"
+msgid "<item type=\"input\">=AVERAGEIFS(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>"
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"par_id40031348913642\n"
+"help.text"
+msgid "Calculates the average for values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range except its maximum. Returns 65, because only second row meets all criteria."
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"hd_id31201205191857\n"
+"help.text"
+msgid "Reference to a cell as a criterion"
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"par_id316794795433\n"
+"help.text"
+msgid "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 AVERAGEIFS function. For example, the above function can be rewritten as follows:"
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"par_id67531072426731\n"
+"help.text"
+msgid "<item type=\"input\">=AVERAGEIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>"
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"par_id65612244926745\n"
+"help.text"
+msgid "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content."
+msgstr ""
+
+#: func_averageifs.xhp
+msgctxt ""
+"func_averageifs.xhp\n"
+"par_id1279148769260\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link>, <embedvar href=\"text/scalc/01/func_averageif.xhp#averageif_head\"/>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/> <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>"
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"tit\n"
+"help.text"
+msgid "COUNTIFS function"
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"bm_id452245224522\n"
+"help.text"
+msgid "<bookmark_value>COUNTIFS function</bookmark_value>  <bookmark_value>counting row;satisfying criteria</bookmark_value>  <bookmark_value>counting column;satisfying criteria</bookmark_value>"
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"hd_id456845684568\n"
+"help.text"
+msgid "<variable id=\"countifs_head\"><link href=\"text/scalc/01/func_countifs.xhp\">COUNTIFS</link></variable> function"
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"par_id462646264626\n"
+"help.text"
+msgid "<ahelp hid=\".\"><variable id=\"countifs_des\">Returns the count of rows or columns that meet criteria in multiple ranges.</variable></ahelp>"
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"hd_id465746574657\n"
+"help.text"
+msgid "Syntax"
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"par_id27421466710275\n"
+"help.text"
+msgid "COUNTIFS(Range1; Criterion1 [; Range2; Criterion2 [; ...]])"
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"par_id242131304318587\n"
+"help.text"
+msgid "<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."
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"par_id23526994221948\n"
+"help.text"
+msgid "<emph>Criterion1</emph> – required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used for counting. The expression can contain text, numbers or regular expressions."
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"par_id190621657742\n"
+"help.text"
+msgid "<emph>Criterion_range2</emph> – Optional. Criterion_range2 and all the following mean the same as Criterion_range1."
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"par_id317001803813193\n"
+"help.text"
+msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1."
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"par_id14223137501158\n"
+"help.text"
+msgid "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a row or a column is taken into counting.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and the operator of a string concatenation (&).<br/>The operators equal to (=), not equal to (<>), greater than (>), greater than or equal to (>=), less than (<), and less than or equal to (<=) can be used in criterion arguments for comparison of numbers.<br/>The function can have up to 500 arguments, meaning that you can specify 250 pairs of ranges and criteria."
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"par_id16654883224356\n"
+"help.text"
+msgid "If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).<br/>If ranges for arguments <emph>Range</emph> have unequal sizes, the function returns err:502."
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"hd_id3861259759512\n"
+"help.text"
+msgid "Simple usage"
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"par_id15856592423333\n"
+"help.text"
+msgid "<item type=\"input\">=COUNTIFS(B2:B6;\">=20\")</item>"
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"par_id323511393121175\n"
+"help.text"
+msgid "Counts the amount of rows of the range B2:B6 with values greater than or equal to 20. Returns 3, because the fifth and the sixth rows do not meet the criterion."
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"par_id74301057922522\n"
+"help.text"
+msgid "<item type=\"input\">=COUNTIFS(B2:B6;\">=20\";C2:C6;\">70\")</item>"
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"par_id109622995127628\n"
+"help.text"
+msgid "Counts the amount of rows that contain simultaneously values greater than 70 in the C2:C6 range and values greater than or equal to 20 in the B2:B6 range. Returns 2, because the second, the fifth and the sixth rows do not meet at least one criterion."
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"hd_id298462825526166\n"
+"help.text"
+msgid "Using regular expressions and nested functions"
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"par_id22736248573471\n"
+"help.text"
+msgid "<item type=\"input\">=COUNTIFS(B2:B6;\"[:alpha:]*\")</item>"
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"par_id22137303324873\n"
+"help.text"
+msgid "Counts the amount of rows of the B2:B6 range that contain only alphabet symbols. Returns 1, because only sixth row meets the criterion."
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"par_id82271340221411\n"
+"help.text"
+msgid "<item type=\"input\">=COUNTIFS(B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>"
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"par_id1105320769334\n"
+"help.text"
+msgid "Counts the amount of rows of the B2:B6 range excluding rows with minimum and maximum values of this range. Returns 2, because the third, the fifth and the sixth rows do not meet at least one criterion."
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"par_id267603146513224\n"
+"help.text"
+msgid "<item type=\"input\">=COUNTIFS(A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>"
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"par_id111252614832220\n"
+"help.text"
+msgid "Counts the amount of rows that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range with exception of its maximum. Returns 1, because only second row meets all criteria."
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"hd_id212582362610399\n"
+"help.text"
+msgid "Reference to a cell as a criterion"
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"par_id3245551524846\n"
+"help.text"
+msgid "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:"
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"par_id109501907712434\n"
+"help.text"
+msgid "<item type=\"input\">=COUNTIFS(A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>"
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"par_id738533068520\n"
+"help.text"
+msgid "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."
+msgstr ""
+
+#: func_countifs.xhp
+msgctxt ""
+"func_countifs.xhp\n"
+"par_id14337286612130\n"
+"help.text"
+msgid "<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_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>"
+msgstr ""
+
 #: func_date.xhp
 msgctxt ""
 "func_date.xhp\n"
@@ -62546,7 +63327,7 @@ msgctxt ""
 "func_datedif.xhp\n"
 "par_id3153551\n"
 "help.text"
-msgid "<ahelp hid=\"HID_FUNC_DATUM\">This function returns the number of whole days, months or years between Start date and End date.</ahelp>"
+msgid "<ahelp hid=\"HID_FUNC_DATEDIF\">This function returns the number of whole days, months or years between Start date and End date.</ahelp>"
 msgstr ""
 
 #: func_datedif.xhp
@@ -63442,6 +64223,248 @@ msgctxt ""
 msgid "<item type=\"input\">=EOMONTH(\"2001-09-14\";6)</item> works as well. If the date is given as string, it has to be in ISO format."
 msgstr ""
 
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"tit\n"
+"help.text"
+msgid "ERROR.TYPE function"
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"bm_id346793467934679\n"
+"help.text"
+msgid "<bookmark_value>ERROR.TYPE function</bookmark_value>  <bookmark_value>index of the Error type</bookmark_value>"
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"hd_id348223482234822\n"
+"help.text"
+msgid "<variable id=\"error_type_head\"><link href=\"text/scalc/01/func_error_type.xhp\">ERROR.TYPE</link></variable> function"
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"par_id350283502835028\n"
+"help.text"
+msgid "<ahelp hid=\".\"><variable id=\"error_type_des\">Returns a number representing a specific Error type, or the error value #N/A, if there is no error. </variable></ahelp>"
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"hd_id351323513235132\n"
+"help.text"
+msgid "Syntax"
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"par_id1861223540440\n"
+"help.text"
+msgid "ERROR.TYPE(Error_value)"
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"par_id217737315\n"
+"help.text"
+msgid "<emph>Error_value</emph> – required argument. The error value or a reference to a cell, whose value needs to be processed."
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"par_id15254419018421\n"
+"help.text"
+msgid "Error value"
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"par_id134093102310948\n"
+"help.text"
+msgid "Returns"
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"par_id121020152053105891\n"
+"help.text"
+msgid "Err:511"
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"par_id121020152053148760\n"
+"help.text"
+msgid "#DIV/0!"
+msgstr ""
+
+#: func_error_type.xhp
+#, fuzzy
+msgctxt ""
+"func_error_type.xhp\n"
+"par_id121020152053296785\n"
+"help.text"
+msgid "#VALUE!"
+msgstr "#VALUE!"
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"par_id121020152053329868\n"
+"help.text"
+msgid "#REF!"
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"par_id121020152053353976\n"
+"help.text"
+msgid "#NAME?"
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"par_id121020152053408216\n"
+"help.text"
+msgid "#NUM!"
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"par_id121020152054007072\n"
+"help.text"
+msgid "#N/A"
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"par_id121020152054075191\n"
+"help.text"
+msgid "Anything else"
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"par_id121020152054075192\n"
+"help.text"
+msgid "#N/A"
+msgstr ""
+
+#: func_error_type.xhp
+#, fuzzy
+msgctxt ""
+"func_error_type.xhp\n"
+"hd_id352113521135211\n"
+"help.text"
+msgid "Examples"
+msgstr "مىساللار:"
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"hd_id182972884627444\n"
+"help.text"
+msgid "Simple usage"
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"par_id15812966716957\n"
+"help.text"
+msgid "<item type=\"input\">=ERROR.TYPE(#N/A)</item>"
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"par_id280533214928308\n"
+"help.text"
+msgid "Returns 7, because 7 is the index number of the error value #N/A."
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"par_id1047088636291\n"
+"help.text"
+msgid "<item type=\"input\">=ERROR.TYPE(A3)</item>"
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"par_id24308515918391\n"
+"help.text"
+msgid "If A3 contains an expression equivalent to the division by zero, the function returns 2, because 2 is the index number of the error value #DIV/0!"
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"hd_id9842206115046\n"
+"help.text"
+msgid "More advanced way"
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"par_id90121141327448\n"
+"help.text"
+msgid "If in division A1 by A2, A2 can turn to zero, you can handle the situation as follows:"
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"par_id16083887218317\n"
+"help.text"
+msgid "<item type=\"input\">=IF(ISERROR(A1/A2);IF(ERROR.TYPE(A1/A2)=2;\"the denominator can't be equal to zero\");A1/A2)</item>"
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"par_id12475201719494\n"
+"help.text"
+msgid "The ISERROR function returns TRUE or FALSE depending on whether there is an error or not. If the error takes place, the function IF addresses to the second argument, if there is no error, it returns the result of the division. The second argument checks the index number representing the specific Error type, and if it is equal to 2, it returns the specified text \"the denominator can't be zero\" or 0 otherwise. Thus, clear text would signify the division by zero, the result of the division would appear when the division is successful, or if there is, for example, an error of another type, zero would be returned."
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"par_id26251175451270\n"
+"help.text"
+msgid "If the ERROR.TYPE function is used as condition of the IF function and the ERROR.TYPE returns #N/A, the IF function returns #N/A as well. Use ISERROR to avoid it as shown in the example above."
+msgstr ""
+
+#: func_error_type.xhp
+msgctxt ""
+"func_error_type.xhp\n"
+"par_id352953529535295\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/04060104.xhp#iserror\">ISERROR</link>, <link href=\"text/scalc/01/04060104.xhp#na\">NA</link>, <link href=\"text/scalc/01/04060104.xhp#Section4\">IF</link>"
+msgstr ""
+
 #: func_hour.xhp
 msgctxt ""
 "func_hour.xhp\n"
@@ -63539,6 +64562,719 @@ msgctxt ""
 msgid "<link href=\"text/scalc/01/04060102.xhp\" name=\"YEAR\">YEAR</link>, <link href=\"text/scalc/01/04060102.xhp\" name=\"NOW\">NOW</link>, <link href=\"text/scalc/01/04060102.xhp\" name=\"MINUTE\">MINUTE</link>, <link href=\"text/scalc/01/04060102.xhp\" name=\"MONTH\">MONTH</link>, <link href=\"text/scalc/01/04060102.xhp\" name=\"DAY\">DAY</link>, <link href=\"text/scalc/01/04060102.xhp\" name=\"WEEKDAY\">WEEKDAY</link>."
 msgstr ""
 
+#: func_imcos.xhp
+msgctxt ""
+"func_imcos.xhp\n"
+"tit\n"
+"help.text"
+msgid "IMCOS function"
+msgstr ""
+
+#: func_imcos.xhp
+msgctxt ""
+"func_imcos.xhp\n"
+"bm_id262410558824\n"
+"help.text"
+msgid "<bookmark_value>IMCOS function</bookmark_value><bookmark_value>cosine;complex number</bookmark_value>"
+msgstr ""
+
+#: func_imcos.xhp
+msgctxt ""
+"func_imcos.xhp\n"
+"hd_id90361032228870\n"
+"help.text"
+msgid "<variable id=\"imcos_head\"><link href=\"text/scalc/01/func_imcos.xhp\">IMCOS</link></variable> function"
+msgstr ""
+
+#: func_imcos.xhp
+msgctxt ""
+"func_imcos.xhp\n"
+"par_id1066273182723\n"
+"help.text"
+msgid "<ahelp hid=\".\"><variable id=\"imcos_des\">Returns the cosine of a complex number.</variable> The cosine of a complex number can be expressed by:</ahelp>"
+msgstr ""
+
+#: func_imcos.xhp
+msgctxt ""
+"func_imcos.xhp\n"
+"par_id164021484116762\n"
+"help.text"
+msgid "<variable id=\"imcos\">IMCOS</variable>(Complex_number)"
+msgstr ""
+
+#: func_imcos.xhp
+msgctxt ""
+"func_imcos.xhp\n"
+"par_id2890729435632\n"
+"help.text"
+msgid "<embedvar href=\"text/scalc/01/ful_func.xhp#func_define_complex\"/> whose cosine is to be calculated."
+msgstr ""
+
+#: func_imcos.xhp
+msgctxt ""
+"func_imcos.xhp\n"
+"par_id4581301219753\n"
+"help.text"
+msgid "<item type=\"input\">=<embedvar href=\"text/scalc/01/func_imcos.xhp#imcos\"/>(\"4-3i\")</item><br/>                returns -6.58066304055116-7.58155274274654i."
+msgstr ""
+
+#: func_imcos.xhp
+msgctxt ""
+"func_imcos.xhp\n"
+"par_id25412646522614\n"
+"help.text"
+msgid "<item type=\"input\">=<embedvar href=\"text/scalc/01/func_imcos.xhp#imcos\"/>(2)</item><br/>returns -0.416146836547142 as a string. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>"
+msgstr ""
+
+#: func_imcosh.xhp
+msgctxt ""
+"func_imcosh.xhp\n"
+"tit\n"
+"help.text"
+msgid "IMCOSH function"
+msgstr ""
+
+#: func_imcosh.xhp
+msgctxt ""
+"func_imcosh.xhp\n"
+"bm_id123771237712377\n"
+"help.text"
+msgid "<bookmark_value>IMCOSH function</bookmark_value><bookmark_value>hyperbolic cosine;complex number</bookmark_value>"
+msgstr ""
+
+#: func_imcosh.xhp
+msgctxt ""
+"func_imcosh.xhp\n"
+"hd_id124691246912469\n"
+"help.text"
+msgid "<variable id=\"imcosh_head\"><link href=\"text/scalc/01/func_imcosh.xhp\">IMCOSH</link></variable> function"
+msgstr ""
+
+#: func_imcosh.xhp
+msgctxt ""
+"func_imcosh.xhp\n"
+"par_id125881258812588\n"
+"help.text"
+msgid "<ahelp hid=\".\"><variable id=\"imcosh_des\">Returns the hyperbolic cosine of a complex number.</variable> The hyperbolic cosine of a complex number can be expressed by:</ahelp>"
+msgstr ""
+
+#: func_imcosh.xhp
+msgctxt ""
+"func_imcosh.xhp\n"
+"par_id16051131322110\n"
+"help.text"
+msgid "<variable id=\"imcosh\">IMCOSH</variable>(Complex_number)"
+msgstr ""
+
+#: func_imcosh.xhp
+msgctxt ""
+"func_imcosh.xhp\n"
+"par_id766137661376613\n"
+"help.text"
+msgid "<embedvar href=\"text/scalc/01/ful_func.xhp#func_define_complex\"/> whose hyperbolic cosine is to be calculated."
+msgstr ""
+
+#: func_imcosh.xhp
+msgctxt ""
+"func_imcosh.xhp\n"
+"par_id55891471962\n"
+"help.text"
+msgid "<item type=\"input\">=<embedvar href=\"text/scalc/01/func_imcosh.xhp#imcosh\"/>(\"4-3i\")</item><br/>returns -27.0349456030742-3.85115333481178i."
+msgstr ""
+
+#: func_imcosh.xhp
+msgctxt ""
+"func_imcosh.xhp\n"
+"par_id152561887112896\n"
+"help.text"
+msgid "<item type=\"input\">=<embedvar href=\"text/scalc/01/func_imcosh.xhp#imcosh\"/>(2)</item><br/>returns 3.76219569108363 as a string. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>"
+msgstr ""
+
+#: func_imcot.xhp
+msgctxt ""
+"func_imcot.xhp\n"
+"tit\n"
+"help.text"
+msgid "IMCOT function"
+msgstr ""
+
+#: func_imcot.xhp
+msgctxt ""
+"func_imcot.xhp\n"
+"bm_id762757627576275\n"
+"help.text"
+msgid "<bookmark_value>IMCOT function</bookmark_value><bookmark_value>cotangent;complex number</bookmark_value>"
+msgstr ""
+
+#: func_imcot.xhp
+msgctxt ""
+"func_imcot.xhp\n"
+"hd_id763567635676356\n"
+"help.text"
+msgid "<variable id=\"imcot_head\"><link href=\"text/scalc/01/func_imcot.xhp\">IMCOT</link></variable> function"
+msgstr ""
+
+#: func_imcot.xhp
+msgctxt ""
+"func_imcot.xhp\n"
+"par_id764617646176461\n"
+"help.text"
+msgid "<ahelp hid=\".\"><variable id=\"imcot_des\">Returns the cotangent of a complex number.</variable> The cotangent of a complex number can be expressed by:</ahelp>"
+msgstr ""
+
+#: func_imcot.xhp
+msgctxt ""
+"func_imcot.xhp\n"
+"par_id311713256011430\n"
+"help.text"
+msgid "<image id=\"img_id5988220084990\" src=\"res/helpimg/sc_func_imcot.png\"><alt id=\"alt_id5988220084990\">cot(a+bi)=cos(a+bi)/sin(a+bi)</alt></image>"
+msgstr ""
+
+#: func_imcot.xhp
+msgctxt ""
+"func_imcot.xhp\n"
+"par_id16051131322110\n"
+"help.text"
+msgid "<variable id=\"imcot\">IMCOT</variable>(Complex_number)"
+msgstr ""
+
+#: func_imcot.xhp
+msgctxt ""
+"func_imcot.xhp\n"
+"par_id766137661376613\n"
+"help.text"
+msgid "<embedvar href=\"text/scalc/01/ful_func.xhp#func_define_complex\"/> whose cotangent is to be calculated."
+msgstr ""
+
+#: func_imcot.xhp
+msgctxt ""
+"func_imcot.xhp\n"
+"par_id21183436423819\n"
+"help.text"
+msgid "<item type=\"input\">=<embedvar href=\"text/scalc/01/func_imcot.xhp#imcot\"/>(\"4-3i\")</item><br/>returns 0.00490118239430447+0.999266927805902i."
+msgstr ""
+
+#: func_imcot.xhp
+msgctxt ""
+"func_imcot.xhp\n"
+"par_id18472284929530\n"
+"help.text"
+msgid "<item type=\"input\">=<embedvar href=\"text/scalc/01/func_imcot.xhp#imcot\"/>(2)</item><br/>returns -0.457657554360286 as a string. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>"
+msgstr ""
+
+#: func_imcsc.xhp
+msgctxt ""
+"func_imcsc.xhp\n"
+"tit\n"
+"help.text"
+msgid "IMCSC function"
+msgstr ""
+
+#: func_imcsc.xhp
+msgctxt ""
+"func_imcsc.xhp\n"
+"bm_id931179311793117\n"
+"help.text"
+msgid "<bookmark_value>IMCSC function</bookmark_value><bookmark_value>cosecant;complex number</bookmark_value>"
+msgstr ""
+
+#: func_imcsc.xhp
+msgctxt ""
+"func_imcsc.xhp\n"
+"hd_id931679316793167\n"
+"help.text"
+msgid "<variable id=\"imcsc_head\"><link href=\"text/scalc/01/func_imcsc.xhp\">IMCSC</link></variable> function"
+msgstr ""
+
+#: func_imcsc.xhp
+msgctxt ""
+"func_imcsc.xhp\n"
+"par_id932329323293232\n"
+"help.text"
+msgid "<ahelp hid=\".\"><variable id=\"imcsc_des\">Returns the cosecant of a complex number. </variable> The cosecant of a complex number can be expressed by:</ahelp>"
+msgstr ""
+
+#: func_imcsc.xhp
+msgctxt ""
+"func_imcsc.xhp\n"
+"par_id13510198901485\n"
+"help.text"
+msgid "<image id=\"img_id24404683532568\" src=\"res/helpimg/sc_func_imcsc.png\"><alt id=\"alt_id148492012231637\">csc(a+bi)=1/sin(a+bi)</alt></image>"
+msgstr ""
+
+#: func_imcsc.xhp
+msgctxt ""
+"func_imcsc.xhp\n"
+"par_id30461169611909\n"
+"help.text"
+msgid "<variable id=\"imcsc\">IMCSC</variable>(Complex_number)"
+msgstr ""
+
+#: func_imcsc.xhp
+msgctxt ""
+"func_imcsc.xhp\n"
+"par_id1899971619670\n"
+"help.text"
+msgid "<embedvar href=\"text/scalc/01/ful_func.xhp#func_define_complex\"/> whose cosecant needs to be calculated."
+msgstr ""
+
+#: func_imcsc.xhp
+msgctxt ""
+"func_imcsc.xhp\n"
+"par_id25692477525537\n"
+"help.text"
+msgid "<item type=\"input\">=<embedvar href=\"text/scalc/01/func_imcsc.xhp#imcsc\"/>(\"4-3i\")</item><br/>returns -0.0754898329158637-0.0648774713706355i."
+msgstr ""
+
+#: func_imcsc.xhp
+msgctxt ""
+"func_imcsc.xhp\n"
+"par_id32572967420710\n"
+"help.text"
+msgid "<item type=\"input\">=<embedvar href=\"text/scalc/01/func_imcsc.xhp#imcsc\"/>(2)</item><br/>returns 1.09975017029462 as a string. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>"
+msgstr ""
+
+#: func_imcsch.xhp
+msgctxt ""
+"func_imcsch.xhp\n"
+"tit\n"
+"help.text"
+msgid "IMCSCH function"
+msgstr ""
+
+#: func_imcsch.xhp
+msgctxt ""
+"func_imcsch.xhp\n"
+"bm_id976559765597655\n"
+"help.text"
+msgid "<bookmark_value>IMCSCH function</bookmark_value><bookmark_value>hyperbolic cosecant;complex number</bookmark_value>"
+msgstr ""
+
+#: func_imcsch.xhp
+msgctxt ""
+"func_imcsch.xhp\n"
+"hd_id977779777797777\n"
+"help.text"
+msgid "<variable id=\"imcsch_head\"><link href=\"text/scalc/01/func_imcsch.xhp\">IMCSCH</link></variable> function"
+msgstr ""
+
+#: func_imcsch.xhp
+msgctxt ""
+"func_imcsch.xhp\n"
+"par_id979369793697936\n"
+"help.text"
+msgid "<ahelp hid=\".\"><variable id=\"imcsch_des\">Returns the hyperbolic cosecant of a complex number.</variable> The hyperbolic cosecant of a complex number can be expressed by:</ahelp>"
+msgstr ""
+
+#: func_imcsch.xhp
+msgctxt ""
+"func_imcsch.xhp\n"
+"par_id195151657917534\n"
+"help.text"
+msgid "<image id=\"img_id23513691929169\" src=\"res/helpimg/sc_func_imcsch.png\"><alt id=\"alt_id313882186926700\">csch(a+bi)=1/sinh(a+bi)</alt></image>"
+msgstr ""
+
+#: func_imcsch.xhp
+msgctxt ""
+"func_imcsch.xhp\n"
+"par_id30461169611909\n"
+"help.text"
+msgid "<variable id=\"imcsch\">IMCSCH</variable>(Complex_number)"
+msgstr ""
+
+#: func_imcsch.xhp
+msgctxt ""
+"func_imcsch.xhp\n"
+"par_id1899971619670\n"
+"help.text"
+msgid "<embedvar href=\"text/scalc/01/ful_func.xhp#func_define_complex\"/> whose hyperbolic cosecant needs to be calculated."
+msgstr ""
+
+#: func_imcsch.xhp
+msgctxt ""
+"func_imcsch.xhp\n"
+"par_id16814232201137\n"
+"help.text"
+msgid "<item type=\"input\">=<embedvar href=\"text/scalc/01/func_imcsch.xhp#imcsch\"/>(\"4-3i\")</item><br/>returns -0.036275889628626+0.0051744731840194i."
+msgstr ""
+
+#: func_imcsch.xhp
+msgctxt ""
+"func_imcsch.xhp\n"
+"par_id2395211576789\n"
+"help.text"
+msgid "<item type=\"input\">=<embedvar href=\"text/scalc/01/func_imcsch.xhp#imcsch\"/>(2)</item><br/>returns 0.275720564771783 as a string. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>"
+msgstr ""
+
+#: func_imsec.xhp
+msgctxt ""
+"func_imsec.xhp\n"
+"tit\n"
+"help.text"
+msgid "IMSEC function"
+msgstr ""
+
+#: func_imsec.xhp
+msgctxt ""
+"func_imsec.xhp\n"
+"bm_id101862404332680\n"
+"help.text"
+msgid "<bookmark_value>IMSEC function</bookmark_value><bookmark_value>secant;complex number</bookmark_value>"
+msgstr ""
+
+#: func_imsec.xhp
+msgctxt ""
+"func_imsec.xhp\n"
+"hd_id29384186273495\n"
+"help.text"
+msgid "<variable id=\"imsec_head\"><link href=\"text/scalc/01/func_imsec.xhp\">IMSEC</link></variable> function"
+msgstr ""
+
+#: func_imsec.xhp
+msgctxt ""
+"func_imsec.xhp\n"
+"par_id23292284928998\n"
+"help.text"
+msgid "<ahelp hid=\".\"><variable id=\"imsec_des\">Returns the secant of a complex number. </variable> The secant of a complex number can be expressed by:</ahelp>"
+msgstr ""
+
+#: func_imsec.xhp
+msgctxt ""
+"func_imsec.xhp\n"
+"par_id17543461310594\n"
+"help.text"
+msgid "<image id=\"img_id112671346811327\" src=\"res/helpimg/sc_func_imsec.png\"><alt id=\"alt_id303562937523579\">sec(a+bi)=1/cos(a+bi)</alt></image>"
+msgstr ""
+
+#: func_imsec.xhp
+msgctxt ""
+"func_imsec.xhp\n"
+"par_id66061624115094\n"
+"help.text"
+msgid "<variable id=\"imsec\">IMSEC</variable>(Complex_number)"
+msgstr ""
+
+#: func_imsec.xhp
+msgctxt ""
+"func_imsec.xhp\n"
+"par_id3186739645701\n"
+"help.text"
+msgid "<embedvar href=\"text/scalc/01/ful_func.xhp#func_define_complex\"/> whose secant needs to be calculated."
+msgstr ""
+
+#: func_imsec.xhp
+msgctxt ""
+"func_imsec.xhp\n"
+"par_id16814232201137\n"
+"help.text"
+msgid "<item type=\"input\">=<embedvar href=\"text/scalc/01/func_imsec.xhp#imsec\"/>(\"4-3i\")</item><br/>returns -0.0652940278579471+0.0752249603027732i."
+msgstr ""
+
+#: func_imsec.xhp
+msgctxt ""
+"func_imsec.xhp\n"
+"par_id2395211576789\n"
+"help.text"
+msgid "<item type=\"input\">=<embedvar href=\"text/scalc/01/func_imsec.xhp#imsec\"/>(2)</item><br/>returns -2.40299796172238 as a string. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>"
+msgstr ""
+
+#: func_imsech.xhp
+msgctxt ""
+"func_imsech.xhp\n"
+"tit\n"
+"help.text"
+msgid "IMSECH function"
+msgstr ""
+
+#: func_imsech.xhp
+msgctxt ""
+"func_imsech.xhp\n"
+"bm_id220201324724579\n"
+"help.text"
+msgid "<bookmark_value>IMSECH function</bookmark_value><bookmark_value>hyperbolic secant;complex number</bookmark_value>"
+msgstr ""
+
+#: func_imsech.xhp
+msgctxt ""
+"func_imsech.xhp\n"
+"hd_id258933143113817\n"
+"help.text"
+msgid "<variable id=\"imsech_head\"><link href=\"text/scalc/01/func_imsech.xhp\">IMSECH</link></variable> function"
+msgstr ""
+
+#: func_imsech.xhp
+msgctxt ""
+"func_imsech.xhp\n"
+"par_id116441182314950\n"
+"help.text"
+msgid "<ahelp hid=\".\"><variable id=\"imsech_des\">Returns the hyperbolic secant of a complex number. </variable> The hyperbolic secant of a complex number can be expressed by:</ahelp>"
+msgstr ""
+
+#: func_imsech.xhp
+msgctxt ""
+"func_imsech.xhp\n"
+"par_id74572850718840\n"
+"help.text"
+msgid "<image id=\"img_id8983315386682\" src=\"res/helpimg/sc_func_imsech.png\"><alt id=\"alt_id9157586510683\">sech(a+bi)=1/cosh(a+bi)</alt></image>"
+msgstr ""
+
+#: func_imsech.xhp
+msgctxt ""
+"func_imsech.xhp\n"
+"par_id17253876723855\n"
+"help.text"
+msgid "<variable id=\"imsech\">IMSECH</variable>(Complex_number)"
+msgstr ""
+
+#: func_imsech.xhp
+msgctxt ""
+"func_imsech.xhp\n"
+"par_id31259109804356\n"
+"help.text"
+msgid "<embedvar href=\"text/scalc/01/ful_func.xhp#func_define_complex\"/> whose hyperbolic secant needs to be calculated."
+msgstr ""
+
+#: func_imsech.xhp
+msgctxt ""
+"func_imsech.xhp\n"
+"par_id1906826088444\n"
+"help.text"
+msgid "<item type=\"input\">=<embedvar href=\"text/scalc/01/func_imsech.xhp#imsech\"/>(\"4-3i\")</item><br/>returns -0.0362534969158689+0.00516434460775318i."
+msgstr ""
+
+#: func_imsech.xhp
+msgctxt ""
+"func_imsech.xhp\n"
+"par_id247492030016627\n"
+"help.text"
+msgid "<item type=\"input\">=<embedvar href=\"text/scalc/01/func_imsech.xhp#imsech\"/>(2)</item><br/>returns 0.26580222883408 as a string. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>"
+msgstr ""
+
+#: func_imsin.xhp
+msgctxt ""
+"func_imsin.xhp\n"
+"tit\n"
+"help.text"
+msgid "IMSIN function"
+msgstr ""
+
+#: func_imsin.xhp
+msgctxt ""
+"func_imsin.xhp\n"
+"bm_id79322063230162\n"
+"help.text"
+msgid "<bookmark_value>IMSIN function</bookmark_value><bookmark_value>sine;complex number</bookmark_value>"
+msgstr ""
+
+#: func_imsin.xhp
+msgctxt ""
+"func_imsin.xhp\n"
+"hd_id3192388765304\n"
+"help.text"
+msgid "<variable id=\"imsin_head\"><link href=\"text/scalc/01/func_imsin.xhp\">IMSIN</link></variable> function"
+msgstr ""
+
+#: func_imsin.xhp
+msgctxt ""
+"func_imsin.xhp\n"
+"par_id1955633330277\n"
+"help.text"
+msgid "<ahelp hid=\".\"><variable id=\"imsin_des\">Returns the sine of a complex number. </variable> The sine of a complex number can be expressed by:</ahelp>"
+msgstr ""
+
+#: func_imsin.xhp
+msgctxt ""
+"func_imsin.xhp\n"
+"par_id3189460120934\n"
+"help.text"
+msgid "sin(a+bi)=sin(a)cosh(b)+cos(a)sinh(b)i"
+msgstr ""
+
+#: func_imsin.xhp
+msgctxt ""
+"func_imsin.xhp\n"
+"par_id284611113926520\n"
+"help.text"
+msgid "<variable id=\"imsin\">IMSIN</variable>(Complex_number)"
+msgstr ""
+
+#: func_imsin.xhp
+msgctxt ""
+"func_imsin.xhp\n"
+"par_id31206835928272\n"
+"help.text"
+msgid "<embedvar href=\"text/scalc/01/ful_func.xhp#func_define_complex\"/> whose sine needs to be calculated."
+msgstr ""
+
+#: func_imsin.xhp
+msgctxt ""
+"func_imsin.xhp\n"
+"par_id5063188419467\n"
+"help.text"
+msgid "<item type=\"input\">=<embedvar href=\"text/scalc/01/func_imsin.xhp#imsin\"/>(\"4-3i\")</item><br/>returns -7.61923172032141+6.548120040911i."
+msgstr ""
+
+#: func_imsin.xhp
+msgctxt ""
+"func_imsin.xhp\n"
+"par_id1527387141125\n"
+"help.text"
+msgid "<item type=\"input\">=<embedvar href=\"text/scalc/01/func_imsin.xhp#imsin\"/>(2)</item><br/>returns 0.909297426825682 as a string. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>"
+msgstr ""
+
+#: func_imsinh.xhp
+msgctxt ""
+"func_imsinh.xhp\n"
+"tit\n"
+"help.text"
+msgid "IMSINH function"
+msgstr ""
+
+#: func_imsinh.xhp
+msgctxt ""
+"func_imsinh.xhp\n"
+"bm_id79322063230162\n"
+"help.text"
+msgid "<bookmark_value>IMSINH function</bookmark_value><bookmark_value>hyperbolic sine;complex number</bookmark_value>"
+msgstr ""
+
+#: func_imsinh.xhp
+msgctxt ""
+"func_imsinh.xhp\n"
+"hd_id3192388765304\n"
+"help.text"
+msgid "<variable id=\"imsinh_head\"><link href=\"text/scalc/01/func_imsinh.xhp\">IMSINH</link></variable> function"
+msgstr ""
+
+#: func_imsinh.xhp
+msgctxt ""
+"func_imsinh.xhp\n"
+"par_id1955633330277\n"
+"help.text"
+msgid "<ahelp hid=\".\"><variable id=\"imsinh_des\">Returns the hyperbolic sine of a complex number.</variable> The hyperbolic sine of a complex number can be expressed by:</ahelp>"
+msgstr ""
+
+#: func_imsinh.xhp
+msgctxt ""
+"func_imsinh.xhp\n"
+"par_id3189460120934\n"
+"help.text"
+msgid "sinh(a+bi)=sinh(a)cos(b)+cosh(a)sin(b)i"
+msgstr ""
+
+#: func_imsinh.xhp
+msgctxt ""
+"func_imsinh.xhp\n"
+"par_id284611113926520\n"
+"help.text"
+msgid "<variable id=\"imsinh\">IMSINH</variable>(Complex_number)"
+msgstr ""
+
+#: func_imsinh.xhp
+msgctxt ""
+"func_imsinh.xhp\n"
+"par_id31206835928272\n"
+"help.text"
+msgid "<embedvar href=\"text/scalc/01/ful_func.xhp#func_define_complex\"/> whose hyperbolic sine needs to be calculated."
+msgstr ""
+
+#: func_imsinh.xhp
+msgctxt ""
+"func_imsinh.xhp\n"
+"par_id5063188419467\n"
+"help.text"
+msgid "<item type=\"input\">=<embedvar href=\"text/scalc/01/func_imsinh.xhp#imsinh\"/>(\"4-3i\")</item>returns -27.0168132580039-3.85373803791938i."
+msgstr ""
+
+#: func_imsinh.xhp
+msgctxt ""
+"func_imsinh.xhp\n"
+"par_id1527387141125\n"
+"help.text"
+msgid "<item type=\"input\"><br/>=<embedvar href=\"text/scalc/01/func_imsinh.xhp#imsinh\"/>(2)</item>returns 3.62686040784702 as a string. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>"
+msgstr ""
+
+#: func_imsinh.xhp
+#, fuzzy
+msgctxt ""
+"func_imsinh.xhp\n"
+"par_id2773214341302\n"
+"help.text"
+msgid "<embedvar href=\"text/scalc/01/func_imsin.xhp#imsin_head\"/>,<embedvar href=\"text/scalc/01/func_imcos.xhp#imcos_head\"/>,<embedvar href=\"text/scalc/01/func_imcosh.xhp#imcosh_head\"/>"
+msgstr "<embedvar href=\"text/scalc/01/func_imsin.xhp#imsin_head\"/>,<embedvar href=\"text/scalc/01/func_imcos.xhp#imcos_head\"/>,<embedvar href=\"text/scalc/01/func_imcosh.xhp#imcosh_head\"/>"
+
+#: func_imtan.xhp
+msgctxt ""
+"func_imtan.xhp\n"
+"tit\n"
+"help.text"
+msgid "IMTAN function"
+msgstr ""
+
+#: func_imtan.xhp
+msgctxt ""
+"func_imtan.xhp\n"
+"bm_id4210250889873\n"
+"help.text"
+msgid "<bookmark_value>IMTAN function</bookmark_value><bookmark_value>tangent;complex number</bookmark_value>"
+msgstr ""
+
+#: func_imtan.xhp
+msgctxt ""
+"func_imtan.xhp\n"
+"hd_id9522389621160\n"
+"help.text"
+msgid "<variable id=\"imtan_head\"><link href=\"text/scalc/01/func_imtan.xhp\">IMTAN</link></variable> function"
+msgstr ""
+
+#: func_imtan.xhp
+msgctxt ""
+"func_imtan.xhp\n"
+"par_id5700137827273\n"
+"help.text"
+msgid "<ahelp hid=\".\"><variable id=\"imtan_des\">Returns the tangent of a complex number.</variable> The tangent of a complex number can be expressed by:</ahelp>"
+msgstr ""
+
+#: func_imtan.xhp
+msgctxt ""
+"func_imtan.xhp\n"
+"par_id25021317131239\n"
+"help.text"
+msgid "<image id=\"img_id16283275473700\" src=\"res/helpimg/sc_func_imtan.png\"><alt id=\"alt_id676711494402\">tan(a+bi)=sin(a+bi)/cos(a+bi)</alt></image>"
+msgstr ""
+
+#: func_imtan.xhp
+msgctxt ""
+"func_imtan.xhp\n"
+"par_id23219159944377\n"
+"help.text"
+msgid "<variable id=\"imtan\">IMTAN</variable>(Complex_number)"
+msgstr ""
+
+#: func_imtan.xhp
+msgctxt ""
+"func_imtan.xhp\n"
+"par_id10242899132094\n"
+"help.text"
+msgid "<embedvar href=\"text/scalc/01/ful_func.xhp#func_define_complex\"/> whose tangent is to be calculated."
+msgstr ""
+
+#: func_imtan.xhp
+msgctxt ""
+"func_imtan.xhp\n"
+"par_id5063188419467\n"
+"help.text"
+msgid "<item type=\"input\">=<embedvar href=\"text/scalc/01/func_imtan.xhp#imtan\"/>(\"4-3i\")</item><br/>returns 0.00490825806749606-1.00070953606723i."
+msgstr ""
+
+#: func_imtan.xhp
+msgctxt ""
+"func_imtan.xhp\n"
+"par_id1527387141125\n"
+"help.text"
+msgid "<item type=\"input\">=<embedvar href=\"text/scalc/01/func_imtan.xhp#imtan\"/>(2)</item><br/>returns -2.18503986326152 as a string. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>"
+msgstr ""
+
 #: func_minute.xhp
 msgctxt ""
 "func_minute.xhp\n"
@@ -64102,6 +65838,238 @@ msgctxt ""
 msgid "<item type=\"input\">=SECOND(C4)</item> returns 17 if contents of C4 = <item type=\"input\">12:20:17</item>."
 msgstr ""
 
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"tit\n"
+"help.text"
+msgid "SUMIFS function"
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"bm_id658066580665806\n"
+"help.text"
+msgid "<bookmark_value>SUMIFS function</bookmark_value>  <bookmark_value>sum;satisfying conditions</bookmark_value>"
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"hd_id658866588665886\n"
+"help.text"
+msgid "<variable id=\"sumifs_head\"><link href=\"text/scalc/01/func_sumifs.xhp\">SUMIFS</link></variable> function"
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"par_id659756597565975\n"
+"help.text"
+msgid "<ahelp hid=\".\"><variable id=\"sumifs_des\">Returns the sum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp>"
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"hd_id660246602466024\n"
+"help.text"
+msgid "Syntax"
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"par_id11655988824213\n"
+"help.text"
+msgid "SUMIFS( Sum_Range ; Criterion_range1 ; Criterion1 [ ; Criterion_range2 ; Criterion2 [;...]])"
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"par_id59901690530236\n"
+"help.text"
+msgid "<emph>Sum_Range</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 calculating the sum."
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"par_id14445505532098\n"
+"help.text"
+msgid "<emph>Criterion_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 finding the corresponding criterion."
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"par_id24470258022447\n"
+"help.text"
+msgid "<emph>Criterion1</emph> – required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used to calculate the sum. The expression can contain text, numbers or regular expressions."
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"par_id111151356820933\n"
+"help.text"
+msgid "<emph>Criterion_range2</emph> – Optional. Criterion_range2 and all the following mean the same as Criterion_range1."
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"par_id14734320631376\n"
+"help.text"
+msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1."
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"par_id94162948227556\n"
+"help.text"
+msgid "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given <emph>Sum_Range</emph> is taken into calculation of the sum.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and the operator of a string concatenation (&).<br/>The operators equal to (=), not equal to (<>), greater than (>), greater than or equal to (>=), less than (<), and less than or equal to (<=) can be used in criterion arguments for comparison of numbers.<br/>The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for them."
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"par_id175721789527973\n"
+"help.text"
+msgid "If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).<br/>If the range of values for calculating the sum and any range for finding criterion have unequal sizes, the function returns err:502."
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"par_id1191767622119\n"
+"help.text"
+msgid "In all examples below, ranges for sum calculation contain the row #6, but it is ignored, because it contains text."
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"hd_id193452436229521\n"
+"help.text"
+msgid "Simple usage"
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"par_id94321051525036\n"
+"help.text"
+msgid "<item type=\"input\">=SUMIFS(B2:B6;B2:B6;\">=20\")</item>"
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"par_id28647227259438\n"
+"help.text"
+msgid "Calculates the sum of values of the range B2:B6 that are greater than or equal to 20. Returns 75, because the fifth row does not meet the criterion."
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"par_id36952767622741\n"
+"help.text"
+msgid "<item type=\"input\">=SUMIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">70\")</item>"
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"par_id189772445525114\n"
+"help.text"
+msgid "Calculates the sum of values of the range C2:C6 that are greater than 70 and correspond to cells of the B2:B6 range with values  greater than or equal to 20. Returns 275, because the second and the fifth rows do not meet at least one criterion."
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"hd_id30455222431067\n"
+"help.text"
+msgid "Using regular expressions and nested functions"
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"par_id307691022525348\n"
+"help.text"
+msgid "<item type=\"input\">=SUMIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>"
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"par_id27619246864839\n"
+"help.text"
+msgid "Calculates the sum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 255, because the third and the fifth rows do not meet at least one criterion."
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"par_id220502883332563\n"
+"help.text"
+msgid "<item type=\"input\">=SUMIFS(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>"
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"par_id15342189586295\n"
+"help.text"
+msgid "Calculates the sum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range except its maximum. Returns 65, because only second row meets all criteria."
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"hd_id8168283329426\n"
+"help.text"
+msgid "Reference to a cell as a criterion"
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"par_id50762995519951\n"
+"help.text"
+msgid "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 SUMIFS function. For example, the above function can be rewritten as follows:"
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"par_id135761606425300\n"
+"help.text"
+msgid "<item type=\"input\">=SUMIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>"
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"par_id30574750215839\n"
+"help.text"
+msgid "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content."
+msgstr ""
+
+#: func_sumifs.xhp
+msgctxt ""
+"func_sumifs.xhp\n"
+"par_id11921178730928\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link>, <link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_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>"
+msgstr ""
+
 #: func_time.xhp
 msgctxt ""
 "func_time.xhp\n"
@@ -64302,7 +66270,7 @@ msgctxt ""
 "func_timevalue.xhp\n"
 "par_id3153632\n"
 "help.text"
-msgid "<item type=\"input\">=TIMEVALUE(\"24:00\")</item> returns 1. If you use the HH:MM:SS time format, the value is 00:00:00."
+msgid "<item type=\"input\">=TIMEVALUE(\"24:00\")</item> returns 0. If you use the HH:MM:SS time format, the value is 00:00:00."
 msgstr ""
 
 #: func_today.xhp
diff --git a/source/ug/helpcontent2/source/text/scalc/guide.po b/source/ug/helpcontent2/source/text/scalc/guide.po
index 71c9749ae7e..1d5cd99686f 100644
--- a/source/ug/helpcontent2/source/text/scalc/guide.po
+++ b/source/ug/helpcontent2/source/text/scalc/guide.po
author	Robinson Tryon <qubit@runcibility.com>	2015-11-24 05:47:40 -0500
committer	Robinson Tryon <qubit@runcibility.com>	2015-11-25 01:57:27 -0500
commit	9b7a6f9619c88ddee34c8cd1623eccdd7d4a4769 (patch)
tree	9c1fecf277ba5ea9818c2f31f5cd90e5bee12e68 /source/ug
parent	2c02b59bd90e8fb0f8ab7b2449bf885f7c41f6e7 (diff)