update translations for master

and force-fix errors using pocheck Change-Id: Ifb5878eff9d322124054a88241a83402f35e2fa1
author: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> 2020-09-28 12:56:22 +0200
committer: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> 2020-09-28 13:04:21 +0200
commit: b7dd30b210d1d080404aed2dc7cf2270a10d1260 (patch)
tree: 3dd0a4de28dd0efabdf88779d66e2fe4fe618b0b /source/ug/helpcontent2
parent: 14a72851d401d86cf9fd72a5e139ab87eb0f47d1 (diff)
14 files changed, 1152 insertions, 666 deletions
diff --git a/source/ug/helpcontent2/source/text/sbasic/shared.po b/source/ug/helpcontent2/source/text/sbasic/shared.po
index 5be5fa8a411..9ed3bdd6383 100644
--- a/source/ug/helpcontent2/source/text/sbasic/shared.po
+++ b/source/ug/helpcontent2/source/text/sbasic/shared.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: 2020-09-07 17:18+0200\n"
+"POT-Creation-Date: 2020-09-28 11:22+0200\n"
 "PO-Revision-Date: 2018-10-21 20:38+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -4309,49 +4309,49 @@ msgctxt ""
 msgid "To move a module or dialog to another document, click the corresponding object in the list and drag it to the desired position. A horizontal line indicates the target position of the current object while dragging. Hold the <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> key while dragging to copy the object instead of moving it."
 msgstr ""
 
-#. FiYz2
+#. 8AfAv
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
 "tit\n"
 "help.text"
-msgid "Event-Driven Macros"
+msgid "Document Event-Driven Macros"
 msgstr ""
 
-#. BHSko
+#. mRxGZ
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
 "bm_id3154581\n"
 "help.text"
-msgid "<bookmark_value>deleting; macro assignments to events</bookmark_value>         <bookmark_value>macros; assigning to events</bookmark_value>         <bookmark_value>assigning macros to events</bookmark_value>         <bookmark_value>events; assigning macros</bookmark_value>"
+msgid "<bookmark_value>deleting; macro assignments to events</bookmark_value>         <bookmark_value>macros; assigning to events</bookmark_value>         <bookmark_value>assigning macros to events</bookmark_value>         <bookmark_value>documents; events</bookmark_value>         <bookmark_value>events; assigning macros</bookmark_value>         <bookmark_value>API; XDocumentEventListener</bookmark_value>"
 msgstr ""
 
-#. ZYLfF
+#. 7uCwS
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
 "hd_id3147348\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/01040000.xhp\" name=\"Event-Driven Macros\">Event-Driven Macros</link>"
+msgid "<link href=\"text/sbasic/shared/01040000.xhp\" name=\"Event-Driven Macros\">Document Event-Driven Macros</link>"
 msgstr ""
 
-#. CNDe6
+#. LRvA8
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
 "par_id3146120\n"
 "help.text"
-msgid "This section describes how to assign Basic programs to program events."
+msgid "This section describes how to assign scripts to application, document or form events."
 msgstr ""
 
-#. SDAQu
+#. 3G8fP
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
 "par_id3149263\n"
 "help.text"
-msgid "You can automatically execute a macro when a specified software event occurs by assigning the desired macro to the event. The following table provides an overview of program events and at what point an assigned macro is executed."
+msgid "You can automatically execute a macro when a specified software event occurs by assigning the desired macro to the event. The following table provides an overview of document events and at what point an assigned macro is executed."
 msgstr ""
 
 #. zBhWV
@@ -4372,31 +4372,40 @@ msgctxt ""
 msgid "An assigned macro is executed..."
 msgstr ""
 
-#. PFpKw
+#. e4Pjb
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id3145809\n"
+"help.text"
+msgid "routine"
+msgstr ""
+
+#. WtaR8
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
 "par_id3149379\n"
 "help.text"
-msgid "Program Start"
+msgid "Start Application"
 msgstr ""
 
-#. WGtYg
+#. otwcA
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
 "par_id3150715\n"
 "help.text"
-msgid "... after a $[officename] application is started."
+msgid "...after a $[officename] application is started."
 msgstr ""
 
-#. zvpGy
+#. zjA7c
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
 "par_id3146914\n"
 "help.text"
-msgid "Program End"
+msgid "Close Application"
 msgstr ""
 
 #. iwsSq
@@ -4408,13 +4417,31 @@ msgctxt ""
 msgid "...before a $[officename] application is terminated."
 msgstr ""
 
-#. FGd5M
+#. DZHzW
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id151599831705811\n"
+"help.text"
+msgid "Document created"
+msgstr ""
+
+#. KAZDF
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id501599831822339\n"
+"help.text"
+msgid "...New document created with <emph>File - New</emph> or with the <emph>New</emph> icon. Note that this event also fires when Basic IDE opens."
+msgstr ""
+
+#. HBjid
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
 "par_id3145150\n"
 "help.text"
-msgid "Create Document"
+msgid "New Document"
 msgstr ""
 
 #. fkuXY
@@ -4426,6 +4453,24 @@ msgctxt ""
 msgid "...after a new document is created with <emph>File - New</emph> or with the <emph>New</emph> icon."
 msgstr ""
 
+#. BYGJY
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id161599836960401\n"
+"help.text"
+msgid "Document loading finished"
+msgstr ""
+
+#. jCGwP
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id721599836993145\n"
+"help.text"
+msgid "...before a document is opened with <emph>File - Open</emph> or with the <emph>Open</emph> icon."
+msgstr ""
+
 #. F352r
 #: 01040000.xhp
 msgctxt ""
@@ -4444,40 +4489,139 @@ msgctxt ""
 msgid "...after a document is opened with <emph>File - Open</emph> or with the <emph>Open</emph> icon."
 msgstr ""
 
-#. VUPBD
+#. H2Uom
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
-"par_id3153266\n"
+"par_id3159171\n"
 "help.text"
-msgid "Save Document As"
-msgstr "پۈتۈكنى باشقا ئاتتا ساقلا"
+msgid "Document is going to be closed"
+msgstr ""
 
-#. qMrvw
+#. CvPgm
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
-"par_id3150208\n"
+"par_id3146868\n"
 "help.text"
-msgid "...before a document is saved under a specified name (with <emph>File - Save As</emph>, or with <emph>File - Save</emph> or the <emph>Save</emph> icon, if a document name has not yet been specified)."
+msgid "...before a document is closed."
 msgstr ""
 
-#. wacHA
+#. kLQvC
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
-"par_id3158215\n"
+"par_id3159097\n"
 "help.text"
-msgid "Document has been saved as"
-msgstr "پۈتۈك باشقا ئاتتا ساقلاندى"
+msgid "Document closed"
+msgstr "پۈتۈك يېپىلدى"
 
-#. G2CqP
+#. DNYcy
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
-"par_id3150980\n"
+"par_id3148606\n"
 "help.text"
-msgid "... after a document was saved under a specified name (with <emph>File - Save As</emph>, or with <emph>File - Save</emph> or with the <emph>Save</emph> icon, if a document name has not yet been specified)."
+msgid "...after a document was closed. Note that the \"Save Document\" event may also occur when the document is saved before closing."
+msgstr ""
+
+#. iMPCi
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id391600157320922\n"
+"help.text"
+msgid "-no UI-"
+msgstr ""
+
+#. F46jE
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id981599837681979\n"
+"help.text"
+msgid "View created"
+msgstr ""
+
+#. 77CWX
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id281599838210270\n"
+"help.text"
+msgid "Document is displayed. Note that this event also happens when a document is duplicated."
+msgstr ""
+
+#. CDwGy
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id511599837683562\n"
+"help.text"
+msgid "View is going to be closed"
+msgstr ""
+
+#. EtV6o
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id331599838046012\n"
+"help.text"
+msgid "Document layout is getting removed."
+msgstr ""
+
+#. 7FemV
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id951599837684882\n"
+"help.text"
+msgid "View closed"
+msgstr ""
+
+#. qGdPR
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id51599837816122\n"
+"help.text"
+msgid "Document layout is cleared prior to the document closure."
+msgstr ""
+
+#. eovzZ
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id3144772\n"
+"help.text"
+msgid "Activate Document"
+msgstr "پۈتۈك ئاكتىپلا"
+
+#. w5v7V
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id3149442\n"
+"help.text"
+msgid "...after a document is brought to the foreground."
+msgstr ""
+
+#. t2QSQ
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id3150888\n"
+"help.text"
+msgid "Deactivate Document"
+msgstr "پۈتۈك توختات"
+
+#. guqXK
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id3154060\n"
+"help.text"
+msgid "...after another document is brought to the foreground."
 msgstr ""
 
 #. MvDXG
@@ -4516,130 +4660,328 @@ msgctxt ""
 msgid "...after a document is saved with <emph>File - Save</emph> or the <emph>Save</emph> icon, provided that a document name has already been specified."
 msgstr ""
 
-#. prVye
+#. 7FEpD
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
-"par_id3159171\n"
+"par_id161599838976700\n"
 "help.text"
-msgid "Document is closing"
+msgid "Saving of document failed"
 msgstr ""
 
-#. CvPgm
+#. FnDEp
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
-"par_id3146868\n"
+"par_id391599838979652\n"
 "help.text"
-msgid "...before a document is closed."
+msgid "Document could not be saved."
 msgstr ""
 
-#. kLQvC
+#. VUPBD
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
-"par_id3159097\n"
+"par_id3153266\n"
 "help.text"
-msgid "Document closed"
-msgstr "پۈتۈك يېپىلدى"
+msgid "Save Document As"
+msgstr "پۈتۈكنى باشقا ئاتتا ساقلا"
 
-#. DNYcy
+#. qMrvw
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
-"par_id3148606\n"
+"par_id3150208\n"
 "help.text"
-msgid "...after a document was closed. Note that the \"Save Document\" event may also occur when the document is saved before closing."
+msgid "...before a document is saved under a specified name (with <emph>File - Save As</emph>, or with <emph>File - Save</emph> or the <emph>Save</emph> icon, if a document name has not yet been specified)."
 msgstr ""
 
-#. eovzZ
+#. wacHA
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
-"par_id3144772\n"
+"par_id3158215\n"
 "help.text"
-msgid "Activate Document"
-msgstr "پۈتۈك ئاكتىپلا"
+msgid "Document has been saved as"
+msgstr "پۈتۈك باشقا ئاتتا ساقلاندى"
 
-#. w5v7V
+#. G2CqP
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
-"par_id3149442\n"
+"par_id3150980\n"
 "help.text"
-msgid "...after a document is brought to the foreground."
+msgid "... after a document was saved under a specified name (with <emph>File - Save As</emph>, or with <emph>File - Save</emph> or with the <emph>Save</emph> icon, if a document name has not yet been specified)."
 msgstr ""
 
-#. t2QSQ
+#. 7BDQa
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
-"par_id3150888\n"
+"par_id561599839702598\n"
 "help.text"
-msgid "Deactivate Document"
-msgstr "پۈتۈك توختات"
+msgid "'Save As' has failed"
+msgstr ""
 
-#. guqXK
+#. FGnZt
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
-"par_id3154060\n"
+"par_id951599840240048\n"
 "help.text"
-msgid "...after another document is brought to the foreground."
+msgid "Document could not be saved."
 msgstr ""
 
-#. xAAJD
+#. 9PEDi
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
-"par_id3152384\n"
+"par_id851599839190548\n"
 "help.text"
-msgid "Print Document"
-msgstr "پۈتۈك باس"
+msgid "-no UI-"
+msgstr ""
 
-#. KHDSZ
+#. FsrLe
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
-"par_id3152873\n"
+"par_id961599839198859\n"
 "help.text"
-msgid "...after the <emph>Print</emph> dialog is closed, but before the actual print process begins."
+msgid "When the document disk location has changed, for example after a <emph>File - Save As...</emph> action."
 msgstr ""
 
-#. 7fBrq
+#. n5TCf
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
-"par_id3159227\n"
+"par_id501600150804809\n"
 "help.text"
-msgid "JavaScript run-time error"
+msgid "Storing or exporting copy of document"
 msgstr ""
 
-#. aHrNm
+#. wP2PH
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
-"par_id3145362\n"
+"par_id471610080505705\n"
 "help.text"
-msgid "...when a JavaScript run-time error occurs."
+msgid "...before a document is saved with <menuitem>File - Save a Copy</menuitem>, <menuitem>File - Export</menuitem>, <menuitem>File - Export as PDF</menuitem> or the <menuitem>Save</menuitem> icons."
 msgstr ""
 
-#. rG4ED
+#. ECboz
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
-"par_id3154767\n"
+"par_id502600180504809\n"
+"help.text"
+msgid "Document copy has been created"
+msgstr ""
+
+#. gF2u2
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id471601180505705\n"
+"help.text"
+msgid "...after a document is saved with <menuitem>File - Save a Copy</menuitem>, <menuitem>File - Export</menuitem>, <menuitem>File - Export as PDF</menuitem> or the <menuitem>Save</menuitem> icons."
+msgstr ""
+
+#. uAeBw
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id501006180504809\n"
+"help.text"
+msgid "Creating of document copy failed"
+msgstr ""
+
+#. dFCuE
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id471600081505705\n"
+"help.text"
+msgid "Document could not be copied or exported."
+msgstr ""
+
+#. qDSzB
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id501600180504809\n"
+"help.text"
+msgid "Print document"
+msgstr ""
+
+#. kDap2
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id471600180505705\n"
+"help.text"
+msgid "...after the Print dialog is closed, but before the actual print process begins. This event occurs for each copy printed."
+msgstr ""
+
+#. KNASw
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id371600180345993\n"
+"help.text"
+msgid "-no UI-"
+msgstr ""
+
+#. fNkWD
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id851600180346872\n"
+"help.text"
+msgid "...after document security settings have changed."
+msgstr ""
+
+#. 5Cfig
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id921600180238854\n"
+"help.text"
+msgid "'Modified' status was changed"
+msgstr ""
+
+#. vVXPg
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id321600180239944\n"
+"help.text"
+msgid "Modified state of a document has changed."
+msgstr ""
+
+#. po5DD
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id741600180121445\n"
 "help.text"
-msgid "Print Mail Merge"
+msgid "Document title changed"
 msgstr ""
 
-#. 8dDPL
+#. KjqSB
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
-"par_id3153555\n"
+"par_id801600180122852\n"
 "help.text"
-msgid "...after the <emph>Print</emph> dialog is closed, but before the actual print process begins. This event occurs for each copy printed."
+msgid "When the document title gets updated."
+msgstr ""
+
+#. AkeoE
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id641600180121445\n"
+"help.text"
+msgid "Loaded a sub component"
+msgstr ""
+
+#. Vq5NQ
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id701600180122852\n"
+"help.text"
+msgid "...after a database form has been opened."
+msgstr ""
+
+#. 7zuFb
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id641700180131445\n"
+"help.text"
+msgid "Closed a sub component"
+msgstr ""
+
+#. Gzmes
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id701600290122852\n"
+"help.text"
+msgid "...after a database form has been closed."
+msgstr ""
+
+#. KHhEE
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id421600097736759\n"
+"help.text"
+msgid "Printing of form letters started"
+msgstr ""
+
+#. AAYeB
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id411600097854273\n"
+"help.text"
+msgid "...before printing form letters using <emph>File - Print</emph> or <emph>Tools - Mail Merge Wizard</emph> menus."
+msgstr ""
+
+#. vDckq
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id41600097737991\n"
+"help.text"
+msgid "Printing of form letters finished"
+msgstr ""
+
+#. Wp5ff
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id451600097862282\n"
+"help.text"
+msgid "...after printing of form letters using <emph>File - Print</emph> or <emph>Tools - Mail Merge Wizard</emph> menus."
+msgstr ""
+
+#. RpMCy
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id641600160655602\n"
+"help.text"
+msgid "Printing of form fields started"
+msgstr ""
+
+#. NDjvr
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id331600160656617\n"
+"help.text"
+msgid "...before printing form fields."
+msgstr ""
+
+#. pMuA3
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id801600160725659\n"
+"help.text"
+msgid "Printing of form fields finished"
+msgstr ""
+
+#. 7GYKZ
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id961600160726645\n"
+"help.text"
+msgid "...after printing form fields."
 msgstr ""
 
 #. esqcH
@@ -4651,31 +4993,31 @@ msgctxt ""
 msgid "Change of the page count"
 msgstr ""
 
-#. QhSjh
+#. hAoeW
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
 "par_id3154627\n"
 "help.text"
-msgid "...when the page count changes."
+msgid "When the page count changes."
 msgstr ""
 
-#. ShGUB
+#. XQXbJ
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
-"par_id3154737\n"
+"par_id131600158369191\n"
 "help.text"
-msgid "Message received"
+msgid "Most events relate to documents, except <literal>OnStartApp</literal>, <literal>OnCloseApp</literal>, <literal>OnCreate</literal> and <literal>OnLoadFinished</literal> that occur at application level. <literal>OnSubComponentOpened</literal>, and <literal>OnSubComponentClosed</literal> events are fired by database's forms."
 msgstr ""
 
-#. qRVBA
+#. e6gAF
 #: 01040000.xhp
 msgctxt ""
 "01040000.xhp\n"
-"par_id3150952\n"
+"par_id321600158566782\n"
 "help.text"
-msgid "...if a message was received."
+msgid "Writer documents are triggering those specific events: <literal>OnLayoutFinished</literal>, <literal>OnMailMerge</literal>, <literal>OnMailMergeFinished</literal>, <literal>OnFieldMerge</literal>, <literal>OnFieldMergeFinished</literal> and <literal>OnPageCountChanged</literal>."
 msgstr ""
 
 #. 7xyqi
@@ -4795,6 +5137,15 @@ msgctxt ""
 msgid "Click <emph>OK</emph> to close the dialog."
 msgstr ""
 
+#. ruyPz
+#: 01040000.xhp
+msgctxt ""
+"01040000.xhp\n"
+"par_id341600162682135\n"
+"help.text"
+msgid "In addition to assigning macros to events, one can <link href=\"text/sbasic/python/python_document_events.xhp\" name=\"Monitor events\">monitor events</link> triggered in %PRODUCTNAME documents."
+msgstr ""
+
 #. XcdRk
 #: 01050000.xhp
 msgctxt ""
diff --git a/source/ug/helpcontent2/source/text/scalc/01.po b/source/ug/helpcontent2/source/text/scalc/01.po
index c047cdf7214..9a1b0820190 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: 2020-09-07 17:18+0200\n"
+"POT-Creation-Date: 2020-09-28 11:22+0200\n"
 "PO-Revision-Date: 2018-11-12 14:10+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -42271,6 +42271,15 @@ msgctxt ""
 msgid "Name"
 msgstr "ئاتى"
 
+#. 3juWm
+#: 04060199.xhp
+msgctxt ""
+"04060199.xhp\n"
+"par_id401599494815994\n"
+"help.text"
+msgid "Example"
+msgstr ""
+
 #. PcMRq
 #: 04060199.xhp
 msgctxt ""
@@ -42496,6 +42505,15 @@ msgctxt ""
 msgid "Name"
 msgstr "ئاتى"
 
+#. CCsqC
+#: 04060199.xhp
+msgctxt ""
+"04060199.xhp\n"
+"par_id201599495083374\n"
+"help.text"
+msgid "Example"
+msgstr ""
+
 #. AdNBV
 #: 04060199.xhp
 msgctxt ""
@@ -42694,6 +42712,15 @@ msgctxt ""
 msgid "Name"
 msgstr "ئاتى"
 
+#. Y4cRR
+#: 04060199.xhp
+msgctxt ""
+"04060199.xhp\n"
+"par_id201599494708332\n"
+"help.text"
+msgid "Example"
+msgstr ""
+
 #. s2CGS
 #: 04060199.xhp
 msgctxt ""
@@ -42775,6 +42802,15 @@ msgctxt ""
 msgid "Name"
 msgstr "ئاتى"
 
+#. tfD9G
+#: 04060199.xhp
+msgctxt ""
+"04060199.xhp\n"
+"par_id521599494740206\n"
+"help.text"
+msgid "Example"
+msgstr ""
+
 #. 52L2C
 #: 04060199.xhp
 msgctxt ""
diff --git a/source/ug/helpcontent2/source/text/sdatabase.po b/source/ug/helpcontent2/source/text/sdatabase.po
index 8790dd9b661..c23e2077789 100644
--- a/source/ug/helpcontent2/source/text/sdatabase.po
+++ b/source/ug/helpcontent2/source/text/sdatabase.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: 2020-08-17 12:39+0200\n"
+"POT-Creation-Date: 2020-09-28 11:22+0200\n"
 "PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
 "Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -688,13 +688,13 @@ msgctxt ""
 msgid "Specifying the relation type"
 msgstr ""
 
-#. kDhFD
+#. zkKD5
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3154791\n"
 "help.text"
-msgid "If you double-click on the line connecting two linked fields or call the menu command <emph>Insert - New Relation</emph>, you can specify the type of relation in the <link href=\"text/shared/explorer/database/02010101.xhp\" name=\"Relations\"><emph>Relations</emph></link> dialog."
+msgid "If you double-click on the line connecting two linked fields or call the menu command <emph>Insert - New Relation</emph>, you can specify the type of relation in the <link href=\"text/sdatabase/02010101.xhp\" name=\"Relations\"><emph>Relations</emph></link> dialog."
 msgstr ""
 
 #. rAkmw
@@ -2056,6 +2056,15 @@ msgctxt ""
 msgid "Examples"
 msgstr ""
 
+#. LuvGC
+#: 02010100.xhp
+msgctxt ""
+"02010100.xhp\n"
+"par_id3153792\n"
+"help.text"
+msgid "='Ms.'"
+msgstr ""
+
 #. 8GaiA
 #: 02010100.xhp
 msgctxt ""
@@ -2074,6 +2083,15 @@ msgctxt ""
 msgid "returns dates that occurred before January 10, 2001"
 msgstr ""
 
+#. mnGgM
+#: 02010100.xhp
+msgctxt ""
+"02010100.xhp\n"
+"par_id3150333\n"
+"help.text"
+msgid "LIKE 'g?ve'"
+msgstr ""
+
 #. T7ZhS
 #: 02010100.xhp
 msgctxt ""
@@ -2110,6 +2128,15 @@ msgctxt ""
 msgid "returns records with the values 1, 3, 5, 7. If the field name contains an item number, for example, you can create a query that returns the item having the specified number."
 msgstr ""
 
+#. cBAnB
+#: 02010100.xhp
+msgctxt ""
+"02010100.xhp\n"
+"par_id3152948\n"
+"help.text"
+msgid "NOT IN ('Smith')"
+msgstr ""
+
 #. uusce
 #: 02010100.xhp
 msgctxt ""
@@ -2578,6 +2605,195 @@ msgctxt ""
 msgid "By clicking the <link href=\"text/shared/02/14030000.xhp\" name=\"Run SQL command directly\"><emph>Run SQL command directly</emph></link> icon in the SQL view, you can formulate a query that is not processed by $[officename] and sent directly to the database engine."
 msgstr ""
 
+#. fKBDD
+#: 02010101.xhp
+msgctxt ""
+"02010101.xhp\n"
+"tit\n"
+"help.text"
+msgid "Join Properties"
+msgstr ""
+
+#. TTCNB
+#: 02010101.xhp
+msgctxt ""
+"02010101.xhp\n"
+"bm_id3154015\n"
+"help.text"
+msgid "<bookmark_value>links;relational databases (Base)</bookmark_value>      <bookmark_value>inner joins (Base)</bookmark_value>      <bookmark_value>joins in databases (Base)</bookmark_value>      <bookmark_value>left joins (Base)</bookmark_value>      <bookmark_value>right joins (Base)</bookmark_value>      <bookmark_value>full joins (Base)</bookmark_value>"
+msgstr ""
+
+#. DG7RD
+#: 02010101.xhp
+msgctxt ""
+"02010101.xhp\n"
+"hd_id3154015\n"
+"help.text"
+msgid "Join Properties"
+msgstr ""
+
+#. MzpBt
+#: 02010101.xhp
+msgctxt ""
+"02010101.xhp\n"
+"par_id3151205\n"
+"help.text"
+msgid "If you double-click a connection between two linked fields in the query design, or if you choose <emph>Insert - New Relation</emph>, the <emph>Join Properties</emph> dialog appears. These properties will be used in all queries created in the future."
+msgstr ""
+
+#. oszEF
+#: 02010101.xhp
+msgctxt ""
+"02010101.xhp\n"
+"hd_id3155066\n"
+"help.text"
+msgid "Tables involved"
+msgstr ""
+
+#. 2AkcB
+#: 02010101.xhp
+msgctxt ""
+"02010101.xhp\n"
+"par_id3153924\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/joindialog/table2\">Specifies two different tables that you want to join.</ahelp>"
+msgstr ""
+
+#. X6wkD
+#: 02010101.xhp
+msgctxt ""
+"02010101.xhp\n"
+"hd_id3155766\n"
+"help.text"
+msgid "Fields involved"
+msgstr ""
+
+#. 8bYEZ
+#: 02010101.xhp
+msgctxt ""
+"02010101.xhp\n"
+"par_id3148994\n"
+"help.text"
+msgid "<ahelp hid=\".\">Specifies two data fields that will be joined by a relation.</ahelp>"
+msgstr ""
+
+#. R8CbB
+#: 02010101.xhp
+msgctxt ""
+"02010101.xhp\n"
+"hd_id3159267\n"
+"help.text"
+msgid "Options"
+msgstr ""
+
+#. MRJCp
+#: 02010101.xhp
+msgctxt ""
+"02010101.xhp\n"
+"hd_id3147340\n"
+"help.text"
+msgid "Type"
+msgstr ""
+
+#. rxAGo
+#: 02010101.xhp
+msgctxt ""
+"02010101.xhp\n"
+"par_id3152482\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">Specifies the join type of the selected join.</ahelp> Some databases support only a subset of the various possible types."
+msgstr ""
+
+#. ngfse
+#: 02010101.xhp
+msgctxt ""
+"02010101.xhp\n"
+"hd_id3155334\n"
+"help.text"
+msgid "Inner Join"
+msgstr ""
+
+#. 356Dv
+#: 02010101.xhp
+msgctxt ""
+"02010101.xhp\n"
+"par_id3155936\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In an inner join, the results table contains only those records for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link is created by a corresponding WHERE clause."
+msgstr ""
+
+#. XYKGT
+#: 02010101.xhp
+msgctxt ""
+"02010101.xhp\n"
+"hd_id3156372\n"
+"help.text"
+msgid "Left Join"
+msgstr ""
+
+#. dRFux
+#: 02010101.xhp
+msgctxt ""
+"02010101.xhp\n"
+"par_id3166450\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a left join, the results table contains all records of the queried fields from the left table and only those records of the queried fields from the right table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the LEFT OUTER JOIN command."
+msgstr ""
+
+#. DxGWD
+#: 02010101.xhp
+msgctxt ""
+"02010101.xhp\n"
+"hd_id3155607\n"
+"help.text"
+msgid "Right Join"
+msgstr ""
+
+#. 9eD8R
+#: 02010101.xhp
+msgctxt ""
+"02010101.xhp\n"
+"par_id3150647\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a right join, the results table contains all records of the queried fields from the right table and only those records of the queried fields from the left table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the RIGHT OUTER JOIN command."
+msgstr ""
+
+#. wcFAd
+#: 02010101.xhp
+msgctxt ""
+"02010101.xhp\n"
+"hd_id3158215\n"
+"help.text"
+msgid "Full Join"
+msgstr ""
+
+#. wAFid
+#: 02010101.xhp
+msgctxt ""
+"02010101.xhp\n"
+"par_id3163665\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a full join, the results table contains all records of the queried fields from the left and right tables.</ahelp> In the SQL of $[officename] this type of link corresponds to the FULL OUTER JOIN command."
+msgstr ""
+
+#. gYRyC
+#: 02010101.xhp
+msgctxt ""
+"02010101.xhp\n"
+"hd_id0305200912031976\n"
+"help.text"
+msgid "Natural"
+msgstr ""
+
+#. 44FEn
+#: 02010101.xhp
+msgctxt ""
+"02010101.xhp\n"
+"par_id0305200912031977\n"
+"help.text"
+msgid "<ahelp hid=\".\">In a natural join, the keyword NATURAL in inserted into the SQL statement that defines the relation. The relation joins all columns that have the same column name in both tables. The resulting joined table contains only one column for each pair of equally named columns.</ahelp>"
+msgstr ""
+
 #. cLmBi
 #: main.xhp
 msgctxt ""
diff --git a/source/ug/helpcontent2/source/text/shared/00.po b/source/ug/helpcontent2/source/text/shared/00.po
index 65ff580c32a..5bf2ae0c9e8 100644
--- a/source/ug/helpcontent2/source/text/shared/00.po
+++ b/source/ug/helpcontent2/source/text/shared/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: 2020-08-17 12:39+0200\n"
+"POT-Creation-Date: 2020-09-28 11:22+0200\n"
 "PO-Revision-Date: 2018-11-14 12:11+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -8026,14 +8026,14 @@ msgctxt ""
 msgid "Basic Shapes"
 msgstr "ئاساسىي شەكىللەر"
 
-#. LKQPo
+#. PZB3N
 #: 00000404.xhp
 msgctxt ""
 "00000404.xhp\n"
 "par_idN10EEE\n"
 "help.text"
-msgid "<image id=\"Graphic4\" src=\"cmd/sc_symbolshapes.smiley.png\" width=\"0.222inch\" height=\"0.222inch\"><alt id=\"alt_\">Icon</alt></image>"
-msgstr "<image id=\"img_id3146969\" src=\"cmd/sc_bezierinsert.png\" width=\"0.222inch\" height=\"0.222inch\"><alt id=\"alt_id3146969\">سىنبەلگە</alt></image>"
+msgid "<image id=\"Graphic4\" src=\"cmd/sc_symbolshapes.smiley.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_\">Icon Symbol Shapes</alt></image>"
+msgstr ""
 
 #. raBMx
 #: 00000404.xhp
diff --git a/source/ug/helpcontent2/source/text/shared/01.po b/source/ug/helpcontent2/source/text/shared/01.po
index 1d37550bb42..b3085e84f71 100644
--- a/source/ug/helpcontent2/source/text/shared/01.po
+++ b/source/ug/helpcontent2/source/text/shared/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: 2020-09-07 17:18+0200\n"
+"POT-Creation-Date: 2020-09-28 11:22+0200\n"
 "PO-Revision-Date: 2018-11-14 12:12+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -7666,13 +7666,13 @@ msgctxt ""
 msgid "<ahelp hid=\".\" visibility=\"hidden\">Searches for the characters that you specify in values and in the results of formulas.</ahelp>"
 msgstr ""
 
-#. eyn9j
+#. Hxei2
 #: 02100000.xhp
 msgctxt ""
 "02100000.xhp\n"
 "hd_id3145650\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"CALC\">Notes</caseinline></switchinline>"
+msgid "<switchinline select=\"appl\"><caseinline select=\"CALC\">Comments</caseinline></switchinline>"
 msgstr ""
 
 #. MTECk
@@ -8161,13 +8161,13 @@ msgctxt ""
 msgid "Represents an uppercase character if <emph>Match case</emph> is selected in <emph>Options</emph>."
 msgstr ""
 
-#. iArH4
+#. V4cUQ
 #: 02100001.xhp
 msgctxt ""
 "02100001.xhp\n"
 "par_id5311440\n"
 "help.text"
-msgid "For a full list of supported metacharacters and syntax, see <link href=\"http://userguide.icu-project.org/strings/regexp\" name=\"ICU Regular Expressions documentation\">ICU Regular Expressions documentation</link>"
+msgid "For a full list of supported metacharacters and syntax, see <link href=\"https://unicode-org.github.io/icu/\" name=\"ICU Regular Expressions documentation\">ICU Regular Expressions documentation</link>"
 msgstr ""
 
 #. HBqoH
@@ -28519,13 +28519,13 @@ msgctxt ""
 msgid "Slant & Corner Radius"
 msgstr "قىيپاش&بۇلۇڭ رادىئۇسى"
 
-#. JuafH
+#. FKWxd
 #: 05230400.xhp
 msgctxt ""
 "05230400.xhp\n"
 "bm_id3149988\n"
 "help.text"
-msgid "<bookmark_value>slanting draw objects</bookmark_value><bookmark_value>draw objects; slanting</bookmark_value><bookmark_value>areas; slanting</bookmark_value>"
+msgid "<bookmark_value>slanting draw objects</bookmark_value><bookmark_value>draw objects; slanting</bookmark_value><bookmark_value>areas; slanting</bookmark_value><bookmark_value>shapes; control points</bookmark_value><bookmark_value>draw objects; control points</bookmark_value>"
 msgstr ""
 
 #. DxadW
@@ -28609,13 +28609,49 @@ msgctxt ""
 msgid "Angle"
 msgstr "بۇلۇڭ"
 
-#. RZJiu
+#. wuSBC
 #: 05230400.xhp
 msgctxt ""
 "05230400.xhp\n"
 "par_id3153683\n"
 "help.text"
-msgid "<ahelp hid=\"cui/ui/slantcornertabpage/MTR_FLD_ANGLE\">Enter the angle of the slant axis.</ahelp>"
+msgid "<ahelp hid=\"cui/ui/slantcornertabpage/MTR_FLD_ANGLE\">Enter the angle of the slant axis.</ahelp>. The slant angle relates to how much an object inclines or slants from its normal vertical position."
+msgstr ""
+
+#. cCmPK
+#: 05230400.xhp
+msgctxt ""
+"05230400.xhp\n"
+"hd_id621600964074859\n"
+"help.text"
+msgid "Control points 1 and 2"
+msgstr ""
+
+#. XXRdh
+#: 05230400.xhp
+msgctxt ""
+"05230400.xhp\n"
+"par_id551600994115345\n"
+"help.text"
+msgid "Some shapes have a special handle which you can drag to change the properties of the shape. The mouse pointer changes to a hand symbol over these special handles. The control points refers to the X and Y coordinates of the position of these handles. When the object has no handle, the values in these boxes are zero. When the shape has one control point, the coordinates of the other control point are zero."
+msgstr ""
+
+#. fbzxN
+#: 05230400.xhp
+msgctxt ""
+"05230400.xhp\n"
+"par_id841600966950007\n"
+"help.text"
+msgid "Enter a value to set the X and Y coordinates of the control points of the object."
+msgstr ""
+
+#. wGED2
+#: 05230400.xhp
+msgctxt ""
+"05230400.xhp\n"
+"par_id911600993420542\n"
+"help.text"
+msgid "<image src=\"media/helpimg/sdraw/control_points.png\" id=\"img_id691600993420543\"><alt id=\"alt_id651600993420544\">Control points in a shape</alt></image>"
 msgstr ""
 
 #. m8GMy
diff --git a/source/ug/helpcontent2/source/text/shared/02.po b/source/ug/helpcontent2/source/text/shared/02.po
index cdc3f935f86..3622abc68dc 100644
--- a/source/ug/helpcontent2/source/text/shared/02.po
+++ b/source/ug/helpcontent2/source/text/shared/02.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: 2020-08-17 12:39+0200\n"
+"POT-Creation-Date: 2020-09-28 11:22+0200\n"
 "PO-Revision-Date: 2018-11-12 14:11+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -19518,3 +19518,12 @@ msgctxt ""
 "help.text"
 msgid "Some shapes have a special handle which you can drag to change the properties of the shape. The mouse pointer changes to a hand symbol over these special handles."
 msgstr ""
+
+#. Ju4Wr
+#: symbolshapes.xhp
+msgctxt ""
+"symbolshapes.xhp\n"
+"par_id911600993420542\n"
+"help.text"
+msgid "<image src=\"media/helpimg/sdraw/control_points.png\" id=\"img_id691600993420543\"><alt id=\"alt_id651600993420544\">Control points in a shape</alt></image>"
+msgstr ""
diff --git a/source/ug/helpcontent2/source/text/shared/05.po b/source/ug/helpcontent2/source/text/shared/05.po
index a6eecf79078..bdefb6a423f 100644
--- a/source/ug/helpcontent2/source/text/shared/05.po
+++ b/source/ug/helpcontent2/source/text/shared/05.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: 2020-08-31 14:55+0200\n"
+"POT-Creation-Date: 2020-09-28 11:22+0200\n"
 "PO-Revision-Date: 2018-10-21 20:38+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -1285,13 +1285,13 @@ msgctxt ""
 msgid "The page does not exist and must be created."
 msgstr ""
 
-#. BDKK7
+#. wBHiJ
 #: err_html.xhp
 msgctxt ""
 "err_html.xhp\n"
 "par_id201592238985883\n"
 "help.text"
-msgid "The page exist, but the Help ID is wrong or missing."
+msgid "The page exists, but the Help ID is wrong or missing."
 msgstr ""
 
 #. Bbuu2
diff --git a/source/ug/helpcontent2/source/text/shared/06.po b/source/ug/helpcontent2/source/text/shared/06.po
index aeb9861027b..bfbefddeb37 100644
--- a/source/ug/helpcontent2/source/text/shared/06.po
+++ b/source/ug/helpcontent2/source/text/shared/06.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: 2020-08-25 16:09+0200\n"
+"POT-Creation-Date: 2020-09-28 11:22+0200\n"
 "PO-Revision-Date: 2018-09-03 13:31+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -295,6 +295,15 @@ msgctxt ""
 msgid "<image id=\"img_id090120160131201466\" src=\"media/screenshots/cui/ui/pageformatpage/PageFormatPage.png\"><alt id=\"alt_id090120160131201466\">Page format tab page</alt></image>"
 msgstr ""
 
+#. ZKaCs
+#: shared_cui_screenshots.xhp
+msgctxt ""
+"shared_cui_screenshots.xhp\n"
+"par_id521601001943409\n"
+"help.text"
+msgid "<image src=\"media/screenshots/cui/ui/slantcornertabpage/SlantAndCornerRadius.png\" id=\"img_id91601001943410\"><alt id=\"alt_id101601001943411\">Slant and Corner Radius tab page</alt></image>"
+msgstr ""
+
 #. agtWk
 #: simpress_screenshots.xhp
 msgctxt ""
diff --git a/source/ug/helpcontent2/source/text/shared/explorer/database.po b/source/ug/helpcontent2/source/text/shared/explorer/database.po
index d6970ce0c2e..0ffc6818c71 100644
--- a/source/ug/helpcontent2/source/text/shared/explorer/database.po
+++ b/source/ug/helpcontent2/source/text/shared/explorer/database.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: 2020-08-17 12:39+0200\n"
+"POT-Creation-Date: 2020-09-28 11:22+0200\n"
 "PO-Revision-Date: 2018-11-12 14:11+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -16,195 +16,6 @@ msgstr ""
 "X-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1542031867.000000\n"
 
-#. fKBDD
-#: 02010101.xhp
-msgctxt ""
-"02010101.xhp\n"
-"tit\n"
-"help.text"
-msgid "Join Properties"
-msgstr "باغلاق خاسلىقى"
-
-#. TTCNB
-#: 02010101.xhp
-msgctxt ""
-"02010101.xhp\n"
-"bm_id3154015\n"
-"help.text"
-msgid "<bookmark_value>links;relational databases (Base)</bookmark_value>      <bookmark_value>inner joins (Base)</bookmark_value>      <bookmark_value>joins in databases (Base)</bookmark_value>      <bookmark_value>left joins (Base)</bookmark_value>      <bookmark_value>right joins (Base)</bookmark_value>      <bookmark_value>full joins (Base)</bookmark_value>"
-msgstr ""
-
-#. DG7RD
-#: 02010101.xhp
-msgctxt ""
-"02010101.xhp\n"
-"hd_id3154015\n"
-"help.text"
-msgid "Join Properties"
-msgstr "باغلاق خاسلىقى"
-
-#. MzpBt
-#: 02010101.xhp
-msgctxt ""
-"02010101.xhp\n"
-"par_id3151205\n"
-"help.text"
-msgid "If you double-click a connection between two linked fields in the query design, or if you choose <emph>Insert - New Relation</emph>, the <emph>Join Properties</emph> dialog appears. These properties will be used in all queries created in the future."
-msgstr ""
-
-#. oszEF
-#: 02010101.xhp
-msgctxt ""
-"02010101.xhp\n"
-"hd_id3155066\n"
-"help.text"
-msgid "Tables involved"
-msgstr "باغلانغان جەدۋەل"
-
-#. 2AkcB
-#: 02010101.xhp
-msgctxt ""
-"02010101.xhp\n"
-"par_id3153924\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/joindialog/table2\">Specifies two different tables that you want to join.</ahelp>"
-msgstr ""
-
-#. X6wkD
-#: 02010101.xhp
-msgctxt ""
-"02010101.xhp\n"
-"hd_id3155766\n"
-"help.text"
-msgid "Fields involved"
-msgstr "باغلانغان سۆز بۆلىكى"
-
-#. 8bYEZ
-#: 02010101.xhp
-msgctxt ""
-"02010101.xhp\n"
-"par_id3148994\n"
-"help.text"
-msgid "<ahelp hid=\".\">Specifies two data fields that will be joined by a relation.</ahelp>"
-msgstr ""
-
-#. R8CbB
-#: 02010101.xhp
-msgctxt ""
-"02010101.xhp\n"
-"hd_id3159267\n"
-"help.text"
-msgid "Options"
-msgstr "تاللانما"
-
-#. MRJCp
-#: 02010101.xhp
-msgctxt ""
-"02010101.xhp\n"
-"hd_id3147340\n"
-"help.text"
-msgid "Type"
-msgstr "تىپى"
-
-#. rxAGo
-#: 02010101.xhp
-msgctxt ""
-"02010101.xhp\n"
-"par_id3152482\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">Specifies the join type of the selected join.</ahelp> Some databases support only a subset of the various possible types."
-msgstr ""
-
-#. ngfse
-#: 02010101.xhp
-msgctxt ""
-"02010101.xhp\n"
-"hd_id3155334\n"
-"help.text"
-msgid "Inner Join"
-msgstr ""
-
-#. 356Dv
-#: 02010101.xhp
-msgctxt ""
-"02010101.xhp\n"
-"par_id3155936\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In an inner join, the results table contains only those records for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link is created by a corresponding WHERE clause."
-msgstr ""
-
-#. XYKGT
-#: 02010101.xhp
-msgctxt ""
-"02010101.xhp\n"
-"hd_id3156372\n"
-"help.text"
-msgid "Left Join"
-msgstr ""
-
-#. dRFux
-#: 02010101.xhp
-msgctxt ""
-"02010101.xhp\n"
-"par_id3166450\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a left join, the results table contains all records of the queried fields from the left table and only those records of the queried fields from the right table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the LEFT OUTER JOIN command."
-msgstr ""
-
-#. DxGWD
-#: 02010101.xhp
-msgctxt ""
-"02010101.xhp\n"
-"hd_id3155607\n"
-"help.text"
-msgid "Right Join"
-msgstr ""
-
-#. 9eD8R
-#: 02010101.xhp
-msgctxt ""
-"02010101.xhp\n"
-"par_id3150647\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a right join, the results table contains all records of the queried fields from the right table and only those records of the queried fields from the left table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the RIGHT OUTER JOIN command."
-msgstr ""
-
-#. wcFAd
-#: 02010101.xhp
-msgctxt ""
-"02010101.xhp\n"
-"hd_id3158215\n"
-"help.text"
-msgid "Full Join"
-msgstr ""
-
-#. wAFid
-#: 02010101.xhp
-msgctxt ""
-"02010101.xhp\n"
-"par_id3163665\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a full join, the results table contains all records of the queried fields from the left and right tables.</ahelp> In the SQL of $[officename] this type of link corresponds to the FULL OUTER JOIN command."
-msgstr ""
-
-#. gYRyC
-#: 02010101.xhp
-msgctxt ""
-"02010101.xhp\n"
-"hd_id0305200912031976\n"
-"help.text"
-msgid "Natural"
-msgstr "تەبىئىي"
-
-#. 44FEn
-#: 02010101.xhp
-msgctxt ""
-"02010101.xhp\n"
-"par_id0305200912031977\n"
-"help.text"
-msgid "<ahelp hid=\".\">In a natural join, the keyword NATURAL in inserted into the SQL statement that defines the relation. The relation joins all columns that have the same column name in both tables. The resulting joined table contains only one column for each pair of equally named columns.</ahelp>"
-msgstr ""
-
 #. pK6MV
 #: 04000000.xhp
 msgctxt ""
diff --git a/source/ug/helpcontent2/source/text/shared/optionen.po b/source/ug/helpcontent2/source/text/shared/optionen.po
index 53cc9ada81b..1c8a0ec1113 100644
--- a/source/ug/helpcontent2/source/text/shared/optionen.po
+++ b/source/ug/helpcontent2/source/text/shared/optionen.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: 2020-09-07 17:18+0200\n"
+"POT-Creation-Date: 2020-09-28 11:22+0200\n"
 "PO-Revision-Date: 2018-11-14 12:12+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -15415,13 +15415,13 @@ msgctxt ""
 msgid "Expert Configuration"
 msgstr ""
 
-#. YGAEk
+#. rmYbp
 #: expertconfig.xhp
 msgctxt ""
 "expertconfig.xhp\n"
 "par_id0609201521430059\n"
 "help.text"
-msgid "Choose <emph>Tools – Options – %PRODUCTNAME – Advanced – Expert Configuration</emph>"
+msgid "Choose <menuitem>Tools - Options - %PRODUCTNAME - Advanced - Open Expert Configuration</menuitem>."
 msgstr ""
 
 #. 7CGay
@@ -15631,13 +15631,13 @@ msgctxt ""
 msgid "<ahelp hid=\"cui/ui/aboutconfigdialog/edit\">Opens a dialog to edit the preference.</ahelp>"
 msgstr ""
 
-#. tLoDF
+#. aZSk8
 #: expertconfig.xhp
 msgctxt ""
 "expertconfig.xhp\n"
 "par_id0609201523043085\n"
 "help.text"
-msgid "You can double click in the preference row to edit the current value of the property."
+msgid "Double-click in the preference row to edit current string and long values or toggle boolean types."
 msgstr ""
 
 #. HGh4N
@@ -15739,6 +15739,42 @@ msgctxt ""
 msgid "<ahelp hid=\"cui/ui/optadvancedpage/javas\">Select the JRE that you want to use. On some systems, you must wait a minute until the list gets populated. On some systems, you must restart %PRODUCTNAME to use your changed setting.</ahelp> The path to the JRE is displayed beneath the list box."
 msgstr ""
 
+#. BEsVP
+#: java.xhp
+msgctxt ""
+"java.xhp\n"
+"par_id431600889434242\n"
+"help.text"
+msgid "You can override the default JRE of the operating system with one of the following alternatives:"
+msgstr ""
+
+#. Skrxp
+#: java.xhp
+msgctxt ""
+"java.xhp\n"
+"par_id191600889458048\n"
+"help.text"
+msgid "By setting the environment variable <literal>JAVA_HOME</literal>,"
+msgstr ""
+
+#. Z6Vzz
+#: java.xhp
+msgctxt ""
+"java.xhp\n"
+"par_id131600889466713\n"
+"help.text"
+msgid "By adding a JRE to the <literal>$PATH</literal> variable,"
+msgstr ""
+
+#. CFjhz
+#: java.xhp
+msgctxt ""
+"java.xhp\n"
+"par_id501600889473339\n"
+"help.text"
+msgid "By providing the configuration file         <switchinline select=\"sys\">            <caseinline select=\"MAC\"><literal>javasettings_macOS_X86_64.xml</literal></caseinline>            <caseinline select=\"WIN\"><literal>javasettings_Windows_X86_64.xml</literal></caseinline>            <caseinline select=\"UNIX\"><literal>javasettings_Linux_X86_64.xml</literal></caseinline>            <defaultinline><literal>javasettings_${_OS}_${_ARCH}.xml</literal></defaultinline>        </switchinline> in the folder <literal><instdir>/presets/config</literal>."
+msgstr ""
+
 #. UM9FC
 #: java.xhp
 msgctxt ""
diff --git a/source/ug/helpcontent2/source/text/simpress/guide.po b/source/ug/helpcontent2/source/text/simpress/guide.po
index dd918670746..16f71d0e34d 100644
--- a/source/ug/helpcontent2/source/text/simpress/guide.po
+++ b/source/ug/helpcontent2/source/text/simpress/guide.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: 2020-08-21 14:00+0200\n"
+"POT-Creation-Date: 2020-09-28 11:22+0200\n"
 "PO-Revision-Date: 2018-09-03 13:31+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -1528,13 +1528,13 @@ msgctxt ""
 msgid "Click the Date Area and move the time and date field. Select the <date/time> field and apply some formatting to change the format for the date and time on all slides. The same applies to the Footer Area and the Slide Number Area."
 msgstr ""
 
-#. ZqhAK
+#. DhBjE
 #: footer.xhp
 msgctxt ""
 "footer.xhp\n"
 "par_id171597939732335\n"
 "help.text"
-msgid "Normally the predefined elements of the Master side are set to visible in the presentation. You can control the visibility of the predefined elements by choosing <menuitem>Slide - Master Elements</menuitem>."
+msgid "Normally the predefined elements of the master slide are set to visible in the presentation. You can control the visibility of the predefined elements by choosing <menuitem>Slide - Master Elements</menuitem>."
 msgstr ""
 
 #. MhrkU
diff --git a/source/ug/helpcontent2/source/text/smath/01.po b/source/ug/helpcontent2/source/text/smath/01.po
index 65e1e16eb5a..bc155967517 100644
--- a/source/ug/helpcontent2/source/text/smath/01.po
+++ b/source/ug/helpcontent2/source/text/smath/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: 2020-07-02 14:37+0200\n"
+"POT-Creation-Date: 2020-09-28 11:22+0200\n"
 "PO-Revision-Date: 2018-11-12 14:11+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -4606,13 +4606,13 @@ msgctxt ""
 msgid "Note that some entries require spaces for the correct structure. This is especially true when you specify attributes with fixed values instead of placeholders."
 msgstr ""
 
-#. RXMei
+#. mPEEx
 #: 03090600.xhp
 msgctxt ""
 "03090600.xhp\n"
 "par_id3145230\n"
 "help.text"
-msgid "For more information about formatting in <emph>%PRODUCTNAME</emph>        <emph>Math</emph>, see <link href=\"text/smath/01/03091100.xhp\" name=\"Brackets and Grouping\">Brackets and Grouping</link>."
+msgid "For more information about formatting in %PRODUCTNAME Math, see <link href=\"text/smath/01/03091100.xhp\" name=\"Brackets and Grouping\">Brackets and Grouping</link>."
 msgstr ""
 
 #. 5WAfz
diff --git a/source/ug/helpcontent2/source/text/swriter/01.po b/source/ug/helpcontent2/source/text/swriter/01.po
index 71ec3e87df1..5aad3d5118e 100644
--- a/source/ug/helpcontent2/source/text/swriter/01.po
+++ b/source/ug/helpcontent2/source/text/swriter/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: 2020-09-07 17:18+0200\n"
+"POT-Creation-Date: 2020-09-28 11:22+0200\n"
 "PO-Revision-Date: 2018-10-21 20:38+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -754,13 +754,13 @@ msgctxt ""
 msgid "<ahelp hid=\".\" visibility=\"hidden\">Switches between master view and normal view if a master document is open.</ahelp> Switches between <link href=\"text/shared/01/02110000.xhp\" name=\"master view\">master view</link> and normal view if a <link href=\"text/shared/01/01010001.xhp\" name=\"master document\">master document</link> is open."
 msgstr ""
 
-#. nYBEF
+#. BeyBx
 #: 02110000.xhp
 msgctxt ""
 "02110000.xhp\n"
 "par_id3150689\n"
 "help.text"
-msgid "<image id=\"img_id3150695\" src=\"sw/res/sc20244.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3150695\">Icon</alt></image>"
+msgid "<image id=\"img_id3150695\" src=\"sw/res/sc20244.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3150695\">Icon Toggle Master View</alt></image>"
 msgstr ""
 
 #. 9STbB
@@ -799,13 +799,13 @@ msgctxt ""
 msgid "To continue the search, click the <link href=\"text/swriter/01/02110100.xhp\" name=\"Repeat Search\"><emph>Repeat Search</emph></link> icon on the <emph>Navigation</emph> toolbar."
 msgstr ""
 
-#. qDMmC
+#. 4yTEA
 #: 02110000.xhp
 msgctxt ""
 "02110000.xhp\n"
 "par_idN1087B\n"
 "help.text"
-msgid "<image id=\"img_id3628141\" src=\"sw/res/sc20249.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3628141\">Icon</alt></image>"
+msgid "<image id=\"img_id3628141\" src=\"sw/res/sc20249.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3628141\">Icon Navigation</alt></image>"
 msgstr ""
 
 #. pEcMq
@@ -835,13 +835,13 @@ msgctxt ""
 msgid "<ahelp hid=\".\" visibility=\"hidden\">Jumps to the previous item in the document. To specify the type of item to jump to, click the <emph>Navigation</emph> icon, and then click an item category - for example, \"Images\".</ahelp> Jumps to the previous item in the document. To specify the type of item to jump to, click the <link href=\"text/swriter/01/02110100.xhp\" name=\"Navigation\">Navigation</link> icon, and then click an item category - for example, \"Images\"."
 msgstr ""
 
-#. hVKMM
+#. oM8gD
 #: 02110000.xhp
 msgctxt ""
 "02110000.xhp\n"
 "par_id3154616\n"
 "help.text"
-msgid "<image id=\"img_id3154622\" src=\"sw/res/sc20186.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3154622\">Icon</alt></image>"
+msgid "<image id=\"img_id3154622\" src=\"sw/res/sc20186.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3154622\">Icon Previous Object</alt></image>"
 msgstr ""
 
 #. JmqqL
@@ -871,13 +871,13 @@ msgctxt ""
 msgid "<ahelp hid=\".\" visibility=\"hidden\">Jumps to the next item in the document. To specify the type of item to jump to, click the <link href=\"text/swriter/01/02110100.xhp\" name=\"Navigation\"><emph>Navigation</emph></link> icon, and then click an item category - for example, \"Images\".</ahelp> Jumps to the next item in the document. To specify the type of item to jump to, click the <link href=\"text/swriter/01/02110100.xhp\" name=\"Navigation\">Navigation</link> icon, and then click an item category - for example, \"Images\"."
 msgstr ""
 
-#. tWXFv
+#. PLyGg
 #: 02110000.xhp
 msgctxt ""
 "02110000.xhp\n"
 "par_id3150767\n"
 "help.text"
-msgid "<image id=\"img_id3150773\" src=\"sw/res/sc20175.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3150773\">Icon</alt></image>"
+msgid "<image id=\"img_id3150773\" src=\"sw/res/sc20175.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3150773\">Icon Next Object</alt></image>"
 msgstr ""
 
 #. LHkgf
@@ -934,13 +934,13 @@ msgctxt ""
 msgid "<ahelp hid=\"modules/swriter/ui/navigatorpanel/listbox\">Shows or hides the <emph>Navigator </emph>list.</ahelp>"
 msgstr ""
 
-#. LKPw3
+#. ys6tB
 #: 02110000.xhp
 msgctxt ""
 "02110000.xhp\n"
 "par_id3154949\n"
 "help.text"
-msgid "<image id=\"img_id3154955\" src=\"sw/res/sc20233.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3154955\">Icon</alt></image>"
+msgid "<image id=\"img_id3154955\" src=\"sw/res/sc20233.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3154955\">Icon List box on/off</alt></image>"
 msgstr ""
 
 #. 8uyJF
@@ -970,13 +970,13 @@ msgctxt ""
 msgid "<ahelp hid=\"modules/swriter/ui/navigatorpanel/root\">Switches between the display of all categories in the Navigator and the selected category.</ahelp>"
 msgstr ""
 
-#. W22Bt
+#. wjRi9
 #: 02110000.xhp
 msgctxt ""
 "02110000.xhp\n"
 "par_id3154133\n"
 "help.text"
-msgid "<image id=\"img_id3154140\" src=\"sw/res/sc20244.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3154140\">Icon</alt></image>"
+msgid "<image id=\"img_id3154140\" src=\"sw/res/sc20244.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3154140\">Icon Switch Content View</alt></image>"
 msgstr ""
 
 #. gKSBn
@@ -1015,13 +1015,13 @@ msgctxt ""
 msgid "<ahelp hid=\".\" visibility=\"hidden\">Click here to set a reminder at the current cursor position. You can define up to five reminders. To jump to a reminder, click the <link href=\"text/swriter/01/02110100.xhp\" name=\"Navigation\"><emph>Navigation</emph></link> icon, in the <emph>Navigation</emph> window click the <emph>Reminder</emph> icon, and then click the <emph>Previous</emph> or <emph>Next</emph> button.</ahelp> Click here to set a reminder at the current cursor position. You can define up to five reminders. To jump to a reminder, click the <link href=\"text/swriter/01/02110100.xhp\" name=\"Navigation\">Navigation</link> icon, in the Navigation window click the Reminder icon, and then click the Previous or Next button."
 msgstr ""
 
-#. 5Zk9L
+#. j2jDL
 #: 02110000.xhp
 msgctxt ""
 "02110000.xhp\n"
 "par_id3154608\n"
 "help.text"
-msgid "<image id=\"img_id3154904\" src=\"sw/res/sr20014.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3154904\">Icon</alt></image>"
+msgid "<image id=\"img_id3154904\" src=\"sw/res/sr20014.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3154904\">Icon Set Reminder</alt></image>"
 msgstr ""
 
 #. 5ArS8
@@ -1060,13 +1060,13 @@ msgctxt ""
 msgid "<ahelp hid=\"modules/swriter/ui/navigatorpanel/header\">Moves the cursor to the header, or from the header to the document text area.</ahelp>"
 msgstr ""
 
-#. LUS7n
+#. Vq7Aq
 #: 02110000.xhp
 msgctxt ""
 "02110000.xhp\n"
 "par_id3153900\n"
 "help.text"
-msgid "<image id=\"img_id3153911\" src=\"sw/res/sc20179.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3153911\">Icon</alt></image>"
+msgid "<image id=\"img_id3153911\" src=\"sw/res/sc20179.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3153911\">Icon Header</alt></image>"
 msgstr ""
 
 #. SPDHG
@@ -1096,13 +1096,13 @@ msgctxt ""
 msgid "<ahelp hid=\"modules/swriter/ui/navigatorpanel/footer\">Moves the cursor to the footer, or from the footer to the document text area.</ahelp>"
 msgstr ""
 
-#. yFFti
+#. ZCu8N
 #: 02110000.xhp
 msgctxt ""
 "02110000.xhp\n"
 "par_id3150217\n"
 "help.text"
-msgid "<image id=\"img_id3150224\" src=\"sw/res/sc20177.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3150224\">Icon</alt></image>"
+msgid "<image id=\"img_id3150224\" src=\"sw/res/sc20177.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3150224\">Icon Footer</alt></image>"
 msgstr ""
 
 #. DxkG4
@@ -1132,13 +1132,13 @@ msgctxt ""
 msgid "<ahelp hid=\"modules/swriter/ui/navigatorpanel/anchor\">Jumps between the footnote text and the footnote anchor.</ahelp>"
 msgstr ""
 
-#. BSMjJ
+#. GVbtG
 #: 02110000.xhp
 msgctxt ""
 "02110000.xhp\n"
 "par_id3153100\n"
 "help.text"
-msgid "<image id=\"img_id3153108\" src=\"sw/res/sc20182.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3153108\">Icon</alt></image>"
+msgid "<image id=\"img_id3153108\" src=\"sw/res/sc20182.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3153108\">Icon Anchor <-> Text</alt></image>"
 msgstr ""
 
 #. DnZEQ
@@ -1168,13 +1168,13 @@ msgctxt ""
 msgid "<ahelp hid=\"modules/swriter/ui/navigatorpanel/dragmode\">Sets the drag and drop options for inserting items from the Navigator into a document, for example, as a hyperlink. Click this icon, and then choose the option that you want to use.</ahelp>"
 msgstr ""
 
-#. VF7HV
+#. vfMVd
 #: 02110000.xhp
 msgctxt ""
 "02110000.xhp\n"
 "par_id3155120\n"
 "help.text"
-msgid "<image id=\"img_id3155126\" src=\"cmd/sc_chainframes.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3155126\">Icon</alt></image>"
+msgid "<image id=\"img_id3155126\" src=\"cmd/sc_chainframes.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3155126\">Icon Drag mode</alt></image>"
 msgstr ""
 
 #. zDXiV
@@ -1276,13 +1276,13 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_NAVI_OUTLINES\">Click <emph>1 </emph>to only view the top level headings (chapter heading) in the Navigator window, and <emph>10</emph> to view all of the headings.</ahelp>"
 msgstr ""
 
-#. WoPAw
+#. rjaS7
 #: 02110000.xhp
 msgctxt ""
 "02110000.xhp\n"
 "par_id3153588\n"
 "help.text"
-msgid "<image id=\"img_id3153595\" src=\"sw/res/sc20236.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3153595\">Icon</alt></image>"
+msgid "<image id=\"img_id3153595\" src=\"sw/res/sc20236.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3153595\">Icon Outline level</alt></image>"
 msgstr ""
 
 #. BrCEr
@@ -1312,13 +1312,13 @@ msgctxt ""
 msgid "<ahelp hid=\"modules/swriter/ui/navigatorpanel/chapterup\">Moves the selected heading, and the text below the heading, up one heading position in the Navigator and in the document. To move only the selected heading and not the text associated with the heading, hold down Ctrl, and then click this icon.</ahelp>"
 msgstr ""
 
-#. VWBAT
+#. Z5FsL
 #: 02110000.xhp
 msgctxt ""
 "02110000.xhp\n"
 "par_id3153268\n"
 "help.text"
-msgid "<image id=\"img_id3153275\" src=\"sw/res/sc20174.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3153275\">Icon</alt></image>"
+msgid "<image id=\"img_id3153275\" src=\"sw/res/sc20174.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3153275\">Icon Chapter Up</alt></image>"
 msgstr ""
 
 #. aTBif
@@ -1348,13 +1348,13 @@ msgctxt ""
 msgid "<ahelp hid=\"modules/swriter/ui/navigatorpanel/chapterdown\">Moves the selected heading, and the text below the heading, down one heading position in the Navigator and in the document. To move only the selected heading and not the text associated with the heading, hold down Ctrl, and then click this icon.</ahelp>"
 msgstr ""
 
-#. uWd5E
+#. iv4iE
 #: 02110000.xhp
 msgctxt ""
 "02110000.xhp\n"
 "par_id3153768\n"
 "help.text"
-msgid "<image id=\"img_id3150828\" src=\"sw/res/sc20171.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3150828\">Icon</alt></image>"
+msgid "<image id=\"img_id3150828\" src=\"sw/res/sc20171.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3150828\">Icon Chapter down</alt></image>"
 msgstr ""
 
 #. rYRtE
@@ -1384,13 +1384,13 @@ msgctxt ""
 msgid "<ahelp hid=\"modules/swriter/ui/navigatorpanel/promote\">Increases the outline level of the selected heading, and the headings that occur below the heading, by one. To only increase the outline level of the selected heading, hold down Ctrl, and then click this icon.</ahelp>"
 msgstr ""
 
-#. U2WNF
+#. MZCz3
 #: 02110000.xhp
 msgctxt ""
 "02110000.xhp\n"
 "par_id3155414\n"
 "help.text"
-msgid "<image id=\"img_id3155420\" src=\"sw/res/sc20172.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3155420\">Icon</alt></image>"
+msgid "<image id=\"img_id3155420\" src=\"sw/res/sc20172.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3155420\">Icon Promote level</alt></image>"
 msgstr ""
 
 #. z6Cg8
@@ -1420,13 +1420,13 @@ msgctxt ""
 msgid "<ahelp hid=\"modules/swriter/ui/navigatorpanel/demote\">Decreases the outline level of the selected heading, and the headings that occur below the heading, by one. To only decrease the outline level of the selected heading, hold down Ctrl, and then click this icon.</ahelp>"
 msgstr ""
 
-#. EwSYC
+#. Bb4uA
 #: 02110000.xhp
 msgctxt ""
 "02110000.xhp\n"
 "par_id3148414\n"
 "help.text"
-msgid "<image id=\"img_id3148420\" src=\"sw/res/sc20173.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3148420\">Icon</alt></image>"
+msgid "<image id=\"img_id3148420\" src=\"sw/res/sc20173.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3148420\">Icon Demote level</alt></image>"
 msgstr ""
 
 #. Ydmmz
@@ -22633,13 +22633,13 @@ msgctxt ""
 msgid "<image id=\"img_id3150122\" src=\"cmd/sc_stylenewbyexample.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3150122\">Icon New Style from Selection</alt></image>"
 msgstr ""
 
-#. cRnpp
+#. B3XbU
 #: 05140000.xhp
 msgctxt ""
 "05140000.xhp\n"
 "par_id3147490\n"
 "help.text"
-msgid "Style actions"
+msgid "Style actions menu"
 msgstr ""
 
 #. KFB5g
@@ -22687,13 +22687,13 @@ msgctxt ""
 msgid "<ahelp hid=\".\">The manually formatted attributes of the text at the cursor position in the document will be added to the style that is selected in the Styles window.</ahelp>"
 msgstr ""
 
-#. j6a4F
+#. zktVC
 #: 05140000.xhp
 msgctxt ""
 "05140000.xhp\n"
 "par_idN10A31\n"
 "help.text"
-msgid "<link href=\"text/text/swriter/01/05170000.xhp\" name=\"loadstyles\"><menuitem>Load Styles</menuitem></link>"
+msgid "<link href=\"text/swriter/01/05170000.xhp\" name=\"loadstyles\"><menuitem>Load Styles</menuitem></link>"
 msgstr ""
 
 #. TSnrm
diff --git a/source/ug/helpcontent2/source/text/swriter/02.po b/source/ug/helpcontent2/source/text/swriter/02.po
index 515fda9cc81..9c3a786b81b 100644
--- a/source/ug/helpcontent2/source/text/swriter/02.po
+++ b/source/ug/helpcontent2/source/text/swriter/02.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: 2020-06-29 13:09+0200\n"
+"POT-Creation-Date: 2020-09-28 11:22+0200\n"
 "PO-Revision-Date: 2017-11-22 15:31+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -1285,14 +1285,14 @@ msgctxt ""
 msgid "Formula"
 msgstr "فورمۇلا"
 
-#. vYCuk
+#. utFBz
 #: 14020000.xhp
 msgctxt ""
 "14020000.xhp\n"
 "bm_id3149687\n"
 "help.text"
-msgid "<bookmark_value>operators; in formulas</bookmark_value><bookmark_value>statistical functions</bookmark_value><bookmark_value>trigonometric functions</bookmark_value><bookmark_value>pages;number of</bookmark_value><bookmark_value>variables;document properties</bookmark_value><bookmark_value>arithmetical operators in formulas</bookmark_value>"
-msgstr "<bookmark_value>ئەمەل; فورمۇلادا</bookmark_value><bookmark_value>ستاتىستىكا فونكسىيە</bookmark_value><bookmark_value>ئۈچبۇلۇڭ فونكسىيە</bookmark_value><bookmark_value>بەت;سانى</bookmark_value><bookmark_value>ئۆزگەرگۈچى مىقدار;پۈتۈك خاسلىقى</bookmark_value><bookmark_value>فورمۇلادىكى ھېساب ئەمەللىرى</bookmark_value>"
+msgid "<bookmark_value>formulas; in text documents</bookmark_value><bookmark_value>operators; in table formulas</bookmark_value><bookmark_value>statistical functions in tables</bookmark_value><bookmark_value>mathematical functions in tables</bookmark_value><bookmark_value>trigonometric functions in tables</bookmark_value><bookmark_value>pages;number of pages in table formulas</bookmark_value><bookmark_value>variables;document properties in table formulas</bookmark_value><bookmark_value>arithmetical operators in formulas</bookmark_value>"
+msgstr ""
 
 #. piUZw
 #: 14020000.xhp
@@ -1321,13 +1321,31 @@ msgctxt ""
 msgid "The formula appears in the input line. To specify a range of cells in a table, select the desired cells with the mouse. The corresponding cell references also appear in the input line. Enter additional parameters, as necessary, and click <emph>Apply</emph> to confirm your entry. You can also enter the formula directly if you know the appropriate syntax. This is necessary, for example, in the <link href=\"text/swriter/01/04090000.xhp\" name=\"Insert Fields\"><emph>Insert Fields</emph></link> and <emph>Edit Fields</emph> dialogs."
 msgstr "فورمۇلا كىرگۈزۈش قۇرىدا كۆرۈنىدۇ. جەدۋەل كاتەكچە رايونىنى بەلگىلەشتە، چاشقىنەكتە لازىملىق كاتەكچە تاللىنىدۇ. مۇناسىپ كاتەكچە نەقىلىمۇ كىرگۈزۈش قۇرىدا كۆرۈنىدۇ. ئېھتىياجغا ئاساسەن باشقا پارامېتىرلارنى كىرگۈزۈشكە بولىدۇ، ھەمدە <emph>قوللان</emph>  نى چېكىپ كىرگۈزگەن تۈر جەزملىنىدۇ. ئەگەر مۇناسىپ فورمۇلا ئىشلىتىلىشىنى بىلسىڭىز بىۋاسىتە كىرگۈزسىڭىزمۇ بولىدۇ. بۇ زۆرۈردۇر، مەسىلەن، <link href=\"text/swriter/01/04090000.xhp\" name=\"سۆز بۆلەك قىستۇر\"><emph>سۆز بۆلەك قىستۇر</emph></link> ۋە <emph>سۆز بۆلەك تەھرىر</emph> سۆزلىشىش رامكىسىدا."
 
-#. hEuvw
+#. fdG9Y
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id621599564033048\n"
+"help.text"
+msgid "With the cursor in a table, press <keycode>F2</keycode>"
+msgstr ""
+
+#. NdBeD
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id101599562003431\n"
+"help.text"
+msgid "In the Table toolbar, press the <emph>Formula</emph> icon."
+msgstr ""
+
+#. cgzyx
 #: 14020000.xhp
 msgctxt ""
 "14020000.xhp\n"
 "par_id3155142\n"
 "help.text"
-msgid "<image id=\"img_id3155148\" src=\"sw/res/sc20556.png\" width=\"0.222inch\" height=\"0.222inch\"><alt id=\"alt_id3155148\">Icon</alt></image>"
+msgid "<image id=\"img_id3155148\" src=\"sw/res/sc20556.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3155148\">Formula icon in Table toolbar</alt></image>"
 msgstr ""
 
 #. DbZyc
@@ -1357,6 +1375,33 @@ msgctxt ""
 msgid "Basic Calculation Functions"
 msgstr "ئاساسىي ھېسابلاش فونكسىيىسى"
 
+#. E8BRA
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id221599495805480\n"
+"help.text"
+msgid "Operation"
+msgstr ""
+
+#. 7KcQ9
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id641599495805481\n"
+"help.text"
+msgid "Name"
+msgstr ""
+
+#. QywKU
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id121599495851064\n"
+"help.text"
+msgid "Example"
+msgstr ""
+
 #. 6VYWD
 #: 14020000.xhp
 msgctxt ""
@@ -1492,23 +1537,41 @@ msgctxt ""
 msgid "Basic Functions in the Submenu"
 msgstr "تارماق تىزىملىكتىكى ئاساسىي فونكسىيە"
 
-#. KwSwL
+#. xt4uW
 #: 14020000.xhp
 msgctxt ""
 "14020000.xhp\n"
-"par_id3145185\n"
+"par_id121599495989098\n"
 "help.text"
-msgid "Sum"
-msgstr "يىغىندا"
+msgid "Function"
+msgstr ""
+
+#. T7Ybo
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id901599495989100\n"
+"help.text"
+msgid "Name"
+msgstr ""
+
+#. 2fE5r
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id501599496006870\n"
+"help.text"
+msgid "Example"
+msgstr ""
 
-#. 4zUcf
+#. KwSwL
 #: 14020000.xhp
 msgctxt ""
 "14020000.xhp\n"
-"par_id3155312\n"
+"par_id3145185\n"
 "help.text"
-msgid "SUM"
-msgstr "SUM"
+msgid "Sum"
+msgstr "يىغىندا"
 
 #. QD5ax
 #: 14020000.xhp
@@ -1537,15 +1600,6 @@ msgctxt ""
 msgid "Round"
 msgstr "پۈتۈن سان"
 
-#. gm4AZ
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3145598\n"
-"help.text"
-msgid "ROUND"
-msgstr "ROUND"
-
 #. 4a69n
 #: 14020000.xhp
 msgctxt ""
@@ -1573,15 +1627,6 @@ msgctxt ""
 msgid "Percent"
 msgstr "پىرسەنت"
 
-#. iqydk
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3155930\n"
-"help.text"
-msgid "PHD"
-msgstr "PHD"
-
 #. Ni2B5
 #: 14020000.xhp
 msgctxt ""
@@ -1609,15 +1654,6 @@ msgctxt ""
 msgid "Square Root"
 msgstr "كۋادرات يىلتىز"
 
-#. c6nHv
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3153038\n"
-"help.text"
-msgid "SQRT"
-msgstr "SQRT"
-
 #. XCbNu
 #: 14020000.xhp
 msgctxt ""
@@ -1645,15 +1681,6 @@ msgctxt ""
 msgid "Power"
 msgstr "دەرىجە"
 
-#. cEryt
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3147124\n"
-"help.text"
-msgid "POW"
-msgstr "POW"
-
 #. wFRf4
 #: 14020000.xhp
 msgctxt ""
@@ -1690,6 +1717,33 @@ msgctxt ""
 msgid "<ahelp hid=\".\">You can insert various operators in your formula.</ahelp> Choose from the following functions:"
 msgstr ""
 
+#. uCpNp
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id61599496064739\n"
+"help.text"
+msgid "Operator"
+msgstr ""
+
+#. HCUeF
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id611599496064740\n"
+"help.text"
+msgid "Name"
+msgstr ""
+
+#. CNZiw
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id461599496082741\n"
+"help.text"
+msgid "Example"
+msgstr ""
+
 #. kN6pM
 #: 14020000.xhp
 msgctxt ""
@@ -1816,15 +1870,6 @@ msgctxt ""
 msgid "Less than or Equal"
 msgstr "كىچىك ياكى تەڭ"
 
-#. tJa3Z
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3153599\n"
-"help.text"
-msgid "LEQ"
-msgstr "LEQ"
-
 #. m6G89
 #: 14020000.xhp
 msgctxt ""
@@ -1852,15 +1897,6 @@ msgctxt ""
 msgid "Greater than or Equal"
 msgstr "چوڭ ياكى تەڭ"
 
-#. ZXFxt
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3153751\n"
-"help.text"
-msgid "GEQ"
-msgstr "GEQ"
-
 #. 88BXS
 #: 14020000.xhp
 msgctxt ""
@@ -1888,15 +1924,6 @@ msgctxt ""
 msgid "Less"
 msgstr "كىچىك"
 
-#. 4pUT2
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3150859\n"
-"help.text"
-msgid "L"
-msgstr ""
-
 #. KuMFP
 #: 14020000.xhp
 msgctxt ""
@@ -1924,15 +1951,6 @@ msgctxt ""
 msgid "Greater"
 msgstr "چوڭ"
 
-#. FsDY9
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3150743\n"
-"help.text"
-msgid "G"
-msgstr ""
-
 #. RDYj2
 #: 14020000.xhp
 msgctxt ""
@@ -1960,15 +1978,6 @@ msgctxt ""
 msgid "Boolean Or"
 msgstr "لوگىكىلىق Or"
 
-#. EySkK
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3148430\n"
-"help.text"
-msgid "OR"
-msgstr "OR"
-
 #. UfFLs
 #: 14020000.xhp
 msgctxt ""
@@ -1996,15 +2005,6 @@ msgctxt ""
 msgid "Boolean X Or"
 msgstr "لوگىكىلىق X Or"
 
-#. FAtfL
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3149457\n"
-"help.text"
-msgid "XOR"
-msgstr "XOR"
-
 #. vEKy7
 #: 14020000.xhp
 msgctxt ""
@@ -2032,15 +2032,6 @@ msgctxt ""
 msgid "Boolean And"
 msgstr "لوگىكىلىق And"
 
-#. gVGd8
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3152948\n"
-"help.text"
-msgid "AND"
-msgstr "AND"
-
 #. CPiHF
 #: 14020000.xhp
 msgctxt ""
@@ -2068,15 +2059,6 @@ msgctxt ""
 msgid "Boolean Not"
 msgstr "لوگىكىلىق Not"
 
-#. uBHtJ
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3153961\n"
-"help.text"
-msgid "NOT"
-msgstr "NOT"
-
 #. i4SeE
 #: 14020000.xhp
 msgctxt ""
@@ -2113,23 +2095,41 @@ msgctxt ""
 msgid "<ahelp hid=\".\">You can choose from the following statistical functions:</ahelp>"
 msgstr ""
 
-#. SimgP
+#. AeKzo
 #: 14020000.xhp
 msgctxt ""
 "14020000.xhp\n"
-"par_id3153176\n"
+"par_id541599496194035\n"
 "help.text"
-msgid "Mean"
-msgstr "ئوتتۇرىچە"
+msgid "Function"
+msgstr ""
+
+#. fLyDG
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id481599496194036\n"
+"help.text"
+msgid "Name"
+msgstr ""
 
-#. qpfti
+#. z9BBL
 #: 14020000.xhp
 msgctxt ""
 "14020000.xhp\n"
-"par_id3154053\n"
+"par_id331599524563749\n"
 "help.text"
-msgid "MEAN"
-msgstr "MEAN"
+msgid "Example"
+msgstr ""
+
+#. SimgP
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id3153176\n"
+"help.text"
+msgid "Mean"
+msgstr "ئوتتۇرىچە"
 
 #. Gu59Y
 #: 14020000.xhp
@@ -2158,15 +2158,6 @@ msgctxt ""
 msgid "Minimum Value"
 msgstr "ئەڭ كىچىك قىممەت"
 
-#. WjaSZ
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3155258\n"
-"help.text"
-msgid "MIN"
-msgstr "MIN"
-
 #. 9CKG8
 #: 14020000.xhp
 msgctxt ""
@@ -2194,15 +2185,6 @@ msgctxt ""
 msgid "Maximum Value"
 msgstr "ئەڭ چوڭ قىممەت"
 
-#. QyhWp
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3154016\n"
-"help.text"
-msgid "MAX"
-msgstr "MAX"
-
 #. mCGfj
 #: 14020000.xhp
 msgctxt ""
@@ -2221,41 +2203,113 @@ msgctxt ""
 msgid "Example: MAX 10|30|20 displays 30.00"
 msgstr "مىسال: MAX 10|30|20 كۆرسىتىدىغىنى 30.00"
 
-#. SGRGy
+#. 76riF
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id21599557699262\n"
+"help.text"
+msgid "Product"
+msgstr ""
+
+#. 5caRN
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id671599563830630\n"
+"help.text"
+msgid "Calculates the product of the selected cells."
+msgstr ""
+
+#. bwMRb
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id631599557734781\n"
+"help.text"
+msgid "Example: PRODUCT <A2:C2> displays the product of the values in cells A2 to C2"
+msgstr ""
+
+#. DXVgk
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id31599557699262\n"
+"help.text"
+msgid "Count"
+msgstr ""
+
+#. 53YC3
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id331599557734781\n"
+"help.text"
+msgid "Counts the number of non empty cells."
+msgstr ""
+
+#. zj2px
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id141599563739504\n"
+"help.text"
+msgid "Example: COUNT <A2:C2> displays the number of non empty cells in A2 to C2."
+msgstr ""
+
+#. SJ9rR
 #: 14020000.xhp
 msgctxt ""
 "14020000.xhp\n"
 "hd_id3153200\n"
 "help.text"
-msgid "Trigonometric Functions"
-msgstr "ترىگونومېترىك (ئۈچبۇلۇڭ) فونكسىيە"
+msgid "Functions"
+msgstr ""
 
-#. DR74v
+#. gRWF7
 #: 14020000.xhp
 msgctxt ""
 "14020000.xhp\n"
 "par_id3153226\n"
 "help.text"
-msgid "<ahelp hid=\".\">You can choose from the following trigonometric functions:</ahelp>"
+msgid "<ahelp hid=\".\">You can choose from the following  functions:</ahelp>"
 msgstr ""
 
-#. HmrvU
+#. CYmFE
 #: 14020000.xhp
 msgctxt ""
 "14020000.xhp\n"
-"par_id3145156\n"
+"par_id341599524600306\n"
 "help.text"
-msgid "Sine"
-msgstr "سىنۇس"
+msgid "Function"
+msgstr ""
+
+#. zUhbC
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id521599524600307\n"
+"help.text"
+msgid "Name"
+msgstr ""
+
+#. S6FE9
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id831599524616362\n"
+"help.text"
+msgid "Example"
+msgstr ""
 
-#. eSbMj
+#. HmrvU
 #: 14020000.xhp
 msgctxt ""
 "14020000.xhp\n"
-"par_id3149507\n"
+"par_id3145156\n"
 "help.text"
-msgid "SIN"
-msgstr "SIN"
+msgid "Sine"
+msgstr "سىنۇس"
 
 #. PefeW
 #: 14020000.xhp
@@ -2284,15 +2338,6 @@ msgctxt ""
 msgid "Cosine"
 msgstr "كوسىنوس"
 
-#. BAQ7F
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3154510\n"
-"help.text"
-msgid "COS"
-msgstr "COS"
-
 #. xBop9
 #: 14020000.xhp
 msgctxt ""
@@ -2320,15 +2365,6 @@ msgctxt ""
 msgid "Tangent"
 msgstr "تانگېنس"
 
-#. aV8d5
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3151012\n"
-"help.text"
-msgid "TAN"
-msgstr "TAN"
-
 #. zaJcG
 #: 14020000.xhp
 msgctxt ""
@@ -2356,15 +2392,6 @@ msgctxt ""
 msgid "Arc Sine"
 msgstr "ئارك سىنۇسى"
 
-#. R6DwT
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3151055\n"
-"help.text"
-msgid "ASIN"
-msgstr "ASIN"
-
 #. CVzAA
 #: 14020000.xhp
 msgctxt ""
@@ -2392,15 +2419,6 @@ msgctxt ""
 msgid "Arc Cosine"
 msgstr "ئارك كوسىنوس"
 
-#. 7QBGb
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3149728\n"
-"help.text"
-msgid "ACOS"
-msgstr "ACOS"
-
 #. ZRyBG
 #: 14020000.xhp
 msgctxt ""
@@ -2428,15 +2446,6 @@ msgctxt ""
 msgid "Arc Tangent"
 msgstr "ئارك تانگېنس"
 
-#. jWGhA
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3147057\n"
-"help.text"
-msgid "ATAN"
-msgstr "ATAN"
-
 #. aEs7N
 #: 14020000.xhp
 msgctxt ""
@@ -2455,6 +2464,60 @@ msgctxt ""
 msgid "Example: ATAN 1"
 msgstr "مىسال: ATAN 1"
 
+#. bsPu3
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id591599557967519\n"
+"help.text"
+msgid "Absolute value"
+msgstr ""
+
+#. 2tt8G
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id211593557987787\n"
+"help.text"
+msgid "Returns the absolute value of the number."
+msgstr ""
+
+#. jYyUX
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id301599563956612\n"
+"help.text"
+msgid "Example: ABS -34 returns 34"
+msgstr ""
+
+#. zEe8j
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id591599557963519\n"
+"help.text"
+msgid "Sign"
+msgstr ""
+
+#. 8Y984
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id211599557987787\n"
+"help.text"
+msgid "Returns the algebraic sign of the number."
+msgstr ""
+
+#. wDJs9
+#: 14020000.xhp
+msgctxt ""
+"14020000.xhp\n"
+"par_id941599563922458\n"
+"help.text"
+msgid "Example: SIGN -23 returns -1"
+msgstr ""
+
 #. sHz7K
 #: 14020000.xhp
 msgctxt ""
@@ -2473,32 +2536,32 @@ msgctxt ""
 msgid "The following document properties are also found under <emph>File - Properties - Statistics</emph>."
 msgstr "پۈتۈكنىڭ تۆۋەندىكى خاسلىقىنىمۇ <emph>ھۆججەت - Pخاسلىق - Sستاتىستىكا</emph>دىن تاپقىلى بولىدۇ."
 
-#. iGhMX
+#. jxf6E
 #: 14020000.xhp
 msgctxt ""
 "14020000.xhp\n"
-"par_id3157538\n"
+"par_id901599524662588\n"
 "help.text"
-msgid "CHAR"
-msgstr "CHAR"
+msgid "Name"
+msgstr ""
 
-#. Mehmy
+#. vmA7Y
 #: 14020000.xhp
 msgctxt ""
 "14020000.xhp\n"
-"par_id3152954\n"
+"par_id741599524662589\n"
 "help.text"
-msgid "Number of characters in the document"
-msgstr "پۈتۈكتىكى ھەرپ سانى"
+msgid "Description"
+msgstr ""
 
-#. SgWXo
+#. Mehmy
 #: 14020000.xhp
 msgctxt ""
 "14020000.xhp\n"
-"par_id3152982\n"
+"par_id3152954\n"
 "help.text"
-msgid "WORD"
-msgstr "WORD"
+msgid "Number of characters in the document"
+msgstr "پۈتۈكتىكى ھەرپ سانى"
 
 #. knEJC
 #: 14020000.xhp
@@ -2509,15 +2572,6 @@ msgctxt ""
 msgid "Number of words in the document"
 msgstr "پۈتۈكتىكى سۆز سانى"
 
-#. sxNfJ
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3152715\n"
-"help.text"
-msgid "PARA"
-msgstr "PARA"
-
 #. X5hJF
 #: 14020000.xhp
 msgctxt ""
@@ -2527,15 +2581,6 @@ msgctxt ""
 msgid "Number of paragraphs in the document"
 msgstr "پۈتۈكتىكى ئابزاس سانى"
 
-#. ZJA76
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3148453\n"
-"help.text"
-msgid "GRAPH"
-msgstr "GRAPH"
-
 #. t5nqK
 #: 14020000.xhp
 msgctxt ""
@@ -2545,15 +2590,6 @@ msgctxt ""
 msgid "Number of graphics in the document"
 msgstr "پۈتۈكتىكى گرافىك سانى"
 
-#. 95TWA
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3151091\n"
-"help.text"
-msgid "TABLES"
-msgstr "TABLES"
-
 #. Bdc8a
 #: 14020000.xhp
 msgctxt ""
@@ -2563,15 +2599,6 @@ msgctxt ""
 msgid "Number of tables in the document"
 msgstr "پۈتۈكتىكى جەدۋەل سانى"
 
-#. ksnxD
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3151198\n"
-"help.text"
-msgid "OLE"
-msgstr "OLE"
-
 #. zJGko
 #: 14020000.xhp
 msgctxt ""
@@ -2581,15 +2608,6 @@ msgctxt ""
 msgid "Number of OLE objects in the document"
 msgstr "پۈتۈكتىكى OLE ئوبيېكت سانى"
 
-#. vMmnr
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3146903\n"
-"help.text"
-msgid "PAGE"
-msgstr "بەت"
-
 #. QeCMR
 #: 14020000.xhp
 msgctxt ""
@@ -2608,59 +2626,50 @@ msgctxt ""
 msgid "More Defined Values"
 msgstr "بەلگىلەنگەن باشقا قىممەتلەر"
 
-#. 7QQ8G
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3153562\n"
-"help.text"
-msgid "PI"
-msgstr "PI"
-
-#. RogDi
+#. TUJRH
 #: 14020000.xhp
 msgctxt ""
 "14020000.xhp\n"
-"par_id3147343\n"
+"par_id981599524696609\n"
 "help.text"
-msgid "PI"
-msgstr "PI"
+msgid "Description"
+msgstr ""
 
-#. Cc3Ec
+#. gnbPF
 #: 14020000.xhp
 msgctxt ""
 "14020000.xhp\n"
-"par_id3147366\n"
+"par_id101599524696610\n"
 "help.text"
-msgid "3.1415..."
-msgstr "3.1415..."
+msgid "Name"
+msgstr ""
 
-#. SqL4F
+#. FFwhP
 #: 14020000.xhp
 msgctxt ""
 "14020000.xhp\n"
-"par_id3147393\n"
+"par_id731599524730168\n"
 "help.text"
-msgid "Euler's constant"
-msgstr "ئەيلېر تۇراقلىق مىقدارى"
+msgid "Value"
+msgstr ""
 
-#. 2mpxR
+#. 7QQ8G
 #: 14020000.xhp
 msgctxt ""
 "14020000.xhp\n"
-"par_id3147462\n"
+"par_id3153562\n"
 "help.text"
-msgid "E"
-msgstr ""
+msgid "PI"
+msgstr "PI"
 
-#. 5EfZH
+#. SqL4F
 #: 14020000.xhp
 msgctxt ""
 "14020000.xhp\n"
-"par_id3147485\n"
+"par_id3147393\n"
 "help.text"
-msgid "2.71828..."
-msgstr "2.71828..."
+msgid "Euler's constant"
+msgstr "ئەيلېر تۇراقلىق مىقدارى"
 
 #. GGtyF
 #: 14020000.xhp
@@ -2671,15 +2680,6 @@ msgctxt ""
 msgid "True"
 msgstr "راست"
 
-#. CDybB
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3145355\n"
-"help.text"
-msgid "TRUE"
-msgstr "TRUE"
-
 #. db4a5
 #: 14020000.xhp
 msgctxt ""
@@ -2698,24 +2698,6 @@ msgctxt ""
 msgid "False"
 msgstr "يالغان"
 
-#. ynTVk
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3150385\n"
-"help.text"
-msgid "FALSE"
-msgstr "FALSE"
-
-#. xqFYa
-#: 14020000.xhp
-msgctxt ""
-"14020000.xhp\n"
-"par_id3149304\n"
-"help.text"
-msgid "0"
-msgstr ""
-
 #. qx5iP
 #: 14030000.xhp
 msgctxt ""
author	Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>	2020-09-28 12:56:22 +0200
committer	Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>	2020-09-28 13:04:21 +0200
commit	b7dd30b210d1d080404aed2dc7cf2270a10d1260 (patch)
tree	3dd0a4de28dd0efabdf88779d66e2fe4fe618b0b /source/ug/helpcontent2
parent	14a72851d401d86cf9fd72a5e139ab87eb0f47d1 (diff)