update translations for 5.4.0 rc3 libreoffice-5-4-0

and force-fix errors using pocheck

Change-Id: I44afb116fdeb5809a82cf8647cd28e34351d8e9c
(cherry picked from commit f9619b996bb12965acf934c8d8debf24dc4ad1e3)

9 files changed, 102 insertions, 451 deletions

diff --git a/source/en-GB/helpcontent2/source/text/sbasic/shared.po b/source/en-GB/helpcontent2/source/text/sbasic/shared.po
index 9185e2247d3..dc26ebb5cf1 100644
--- a/source/en-GB/helpcontent2/source/text/sbasic/shared.po
+++ b/source/en-GB/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: 2017-06-20 13:55+0200\n"
+"POT-Creation-Date: 2017-07-20 11:52+0200\n"
 "PO-Revision-Date: 2017-06-21 09:34+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n != 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1498037673.000000\n"
 
 #: 00000002.xhp
@@ -157,8 +157,8 @@ msgctxt ""
 "00000002.xhp\n"
 "par_id3150324\n"
 "help.text"
-msgid "URL notation does not allow certain special characters to be used. These are either replaced by other characters or encoded. A slash (<emph>/</emph>) is used as a path separator. For example, a file referred to as <emph>C:\\My File.odt</emph> on the local host in \"Windows notation\" becomes <emph>file:///C|/My%20File.odt</emph> in URL notation."
-msgstr "URL notation does not allow certain special characters to be used. These are either replaced by other characters or encoded. A slash (<emph>/</emph>) is used as a path separator. For example, a file referred to as <emph>C:\\My File.odt</emph> on the local host in \"Windows notation\" becomes <emph>file:///C|/My%20File.odt</emph> in URL notation."
+msgid "URL notation does not allow certain special characters to be used. These are either replaced by other characters or encoded. A slash (<emph>/</emph>) is used as a path separator. For example, a file referred to as <emph>C:\\Users\\alice\\Documents\\My File.odt</emph> on the local host in \"Windows notation\" becomes <emph>file:///C:/Users/alice/Documents/My%20File.odt</emph> in URL notation."
+msgstr ""
 
 #: 00000003.xhp
 msgctxt ""
@@ -181,8 +181,8 @@ msgctxt ""
 "00000003.xhp\n"
 "par_id3153381\n"
 "help.text"
-msgid "You can set the locale used for controlling the formatting numbers, dates and currencies in $[officename] Basic in <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - Language Settings - Languages</emph>. In Basic format codes, the decimal point (<emph>.</emph>) is always used as <emph>placeholder</emph> for the decimal separator defined in your locale and will be replaced by the corresponding character."
-msgstr "You can set the locale used for controlling the formatting numbers, dates and currencies in $[officename] Basic in <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - Language Settings - Languages</emph>. In Basic format codes, the decimal point (<emph>.</emph>) is always used as <emph>placeholder</emph> for the decimal separator defined in your locale and will be replaced by the corresponding character."
+msgid "You can set the locale used for controlling the formatting numbers, dates and currencies in $[officename] Basic in <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph> </caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - Language Settings - Languages</emph>. In Basic format codes, the decimal point (<emph>.</emph>) is always used as <emph>placeholder</emph> for the decimal separator defined in your locale and will be replaced by the corresponding character."
+msgstr ""
 
 #: 00000003.xhp
 msgctxt ""
@@ -515,6 +515,14 @@ msgstr "<variable id=\"functexample\">Example:</variable>"
 #: 00000003.xhp
 msgctxt ""
 "00000003.xhp\n"
+"par_id06142017015837916\n"
+"help.text"
+msgid "<variable id=\"VBA-Financial\"><link href=\"text/sbasic/shared/special_vba_func.xhp\">VBA financial functions</link></variable>"
+msgstr ""
+
+#: 00000003.xhp
+msgctxt ""
+"00000003.xhp\n"
 "hd_id3152869\n"
 "help.text"
 msgid "<variable id=\"errorcode\">Error codes:</variable>"
@@ -28211,30 +28219,6 @@ msgstr "Returns the Unicode value of the first character in a string expression.
 #: 03120111.xhp
 msgctxt ""
 "03120111.xhp\n"
-"hd_id3155555\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntax:"
-
-#: 03120111.xhp
-msgctxt ""
-"03120111.xhp\n"
-"par_id3143267\n"
-"help.text"
-msgid "AscW (Text As String)"
-msgstr "AscW (Text As String)"
-
-#: 03120111.xhp
-msgctxt ""
-"03120111.xhp\n"
-"hd_id3147242\n"
-"help.text"
-msgid "Return value:"
-msgstr "Return value:"
-
-#: 03120111.xhp
-msgctxt ""
-"03120111.xhp\n"
 "par_id3150669\n"
 "help.text"
 msgid "Integer"
@@ -28243,14 +28227,6 @@ msgstr "Integer"
 #: 03120111.xhp
 msgctxt ""
 "03120111.xhp\n"
-"hd_id3148473\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parameters:"
-
-#: 03120111.xhp
-msgctxt ""
-"03120111.xhp\n"
 "par_id3149415\n"
 "help.text"
 msgid "<emph>Text:</emph> Any valid string expression. Only the first character in the string is relevant."
@@ -28267,14 +28243,6 @@ msgstr "Use the AscW function to replace keys with Unicode values. If the AscW f
 #: 03120111.xhp
 msgctxt ""
 "03120111.xhp\n"
-"hd_id3159413\n"
-"help.text"
-msgid "Example:"
-msgstr "Example:"
-
-#: 03120111.xhp
-msgctxt ""
-"03120111.xhp\n"
 "par_id3150792\n"
 "help.text"
 msgid "Print AscW(\"A\") ' returns 65"
@@ -28355,14 +28323,6 @@ msgstr "Returns the Unicode character that corresponds to the specified characte
 #: 03120112.xhp
 msgctxt ""
 "03120112.xhp\n"
-"hd_id3149514\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntax:"
-
-#: 03120112.xhp
-msgctxt ""
-"03120112.xhp\n"
 "par_id3150669\n"
 "help.text"
 msgid "ChrW(Expression As Integer)"
@@ -28371,14 +28331,6 @@ msgstr "ChrW(Expression As Integer)"
 #: 03120112.xhp
 msgctxt ""
 "03120112.xhp\n"
-"hd_id3143228\n"
-"help.text"
-msgid "Return value:"
-msgstr "Return value:"
-
-#: 03120112.xhp
-msgctxt ""
-"03120112.xhp\n"
 "par_id3153824\n"
 "help.text"
 msgid "String"
@@ -28387,14 +28339,6 @@ msgstr "String"
 #: 03120112.xhp
 msgctxt ""
 "03120112.xhp\n"
-"hd_id3148944\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parameters:"
-
-#: 03120112.xhp
-msgctxt ""
-"03120112.xhp\n"
 "par_id3149295\n"
 "help.text"
 msgid "<emph>Expression:</emph> Numeric variables that represent a valid 16 bit Unicode value (0-65535). An empty value returns error code 5. A value out of the range [0,65535] returns error code 6."
@@ -28403,14 +28347,6 @@ msgstr "<emph>Expression:</emph> Numeric variables that represent a valid 16 bit
 #: 03120112.xhp
 msgctxt ""
 "03120112.xhp\n"
-"hd_id3154366\n"
-"help.text"
-msgid "Example:"
-msgstr "Example:"
-
-#: 03120112.xhp
-msgctxt ""
-"03120112.xhp\n"
 "par_id3154909\n"
 "help.text"
 msgid "' This example inserts the greek letter Alpha and Omega in a string."
@@ -31011,14 +30947,6 @@ msgstr "The InStrRev function returns the position at which the match was found,
 #: 03120411.xhp
 msgctxt ""
 "03120411.xhp\n"
-"hd_id3145090\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntax:"
-
-#: 03120411.xhp
-msgctxt ""
-"03120411.xhp\n"
 "par_id3146957\n"
 "help.text"
 msgid "InStrRev (Text1 As String, Text2 As String [,Start As Long] [, Compare As Integer])"
@@ -31027,14 +30955,6 @@ msgstr "InStrRev (Text1 As String, Text2 As String [,Start As Long] [, Compare A
 #: 03120411.xhp
 msgctxt ""
 "03120411.xhp\n"
-"hd_id3148538\n"
-"help.text"
-msgid "Return value:"
-msgstr "Return value:"
-
-#: 03120411.xhp
-msgctxt ""
-"03120411.xhp\n"
 "par_id3149763\n"
 "help.text"
 msgid "Long"
@@ -31043,14 +30963,6 @@ msgstr "Long"
 #: 03120411.xhp
 msgctxt ""
 "03120411.xhp\n"
-"hd_id3148473\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parameters:"
-
-#: 03120411.xhp
-msgctxt ""
-"03120411.xhp\n"
 "par_id3145609\n"
 "help.text"
 msgid "<emph>Text1:</emph> The string expression that you want to search."
@@ -31107,14 +31019,6 @@ msgstr "To avoid a run-time error, do not set the Compare parameter if the first
 #: 03120411.xhp
 msgctxt ""
 "03120411.xhp\n"
-"hd_id3154366\n"
-"help.text"
-msgid "Example:"
-msgstr "Example:"
-
-#: 03120411.xhp
-msgctxt ""
-"03120411.xhp\n"
 "par_id3144760\n"
 "help.text"
 msgid "sInput = \"The book is on the table\""
@@ -31165,8 +31069,8 @@ msgctxt ""
 "03120412.xhp\n"
 "hd_id3155934\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03120412.xhp\" name=\"InStrRev Function [Runtime]\">StrReverse Function [Runtime - VBA]</link>"
-msgstr "<link href=\"text/sbasic/shared/03120412.xhp\" name=\"InStrRev Function [Runtime]\">StrReverse Function [Runtime - VBA]</link>"
+msgid "<link href=\"text/sbasic/shared/03120412.xhp\" name=\"StrReverse Function [Runtime]\">StrReverse Function [Runtime - VBA]</link>"
+msgstr ""
 
 #: 03120412.xhp
 msgctxt ""
@@ -31179,14 +31083,6 @@ msgstr "Returns the string with the character order reversed."
 #: 03120412.xhp
 msgctxt ""
 "03120412.xhp\n"
-"hd_id3145090\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntax:"
-
-#: 03120412.xhp
-msgctxt ""
-"03120412.xhp\n"
 "par_id3146957\n"
 "help.text"
 msgid "StrReverse (Text1 As String)"
@@ -31195,14 +31091,6 @@ msgstr "StrReverse (Text1 As String)"
 #: 03120412.xhp
 msgctxt ""
 "03120412.xhp\n"
-"hd_id3148538\n"
-"help.text"
-msgid "Return value:"
-msgstr "Return value:"
-
-#: 03120412.xhp
-msgctxt ""
-"03120412.xhp\n"
 "par_id3149763\n"
 "help.text"
 msgid "String"
@@ -31211,27 +31099,11 @@ msgstr "String"
 #: 03120412.xhp
 msgctxt ""
 "03120412.xhp\n"
-"hd_id3148473\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parameters:"
-
-#: 03120412.xhp
-msgctxt ""
-"03120412.xhp\n"
 "par_id3145609\n"
 "help.text"
 msgid "<emph>Text1:</emph> The string expression that you want to reverse the character order."
 msgstr "<emph>Text1:</emph> The string expression that you want to reverse the character order."
 
-#: 03120412.xhp
-msgctxt ""
-"03120412.xhp\n"
-"hd_id3154366\n"
-"help.text"
-msgid "Example:"
-msgstr "Example:"
-
 #: 03130000.xhp
 msgctxt ""
 "03130000.xhp\n"
@@ -33107,30 +32979,6 @@ msgstr "Returns the depreciation of an asset for a specified period using the ar
 #: 03140000.xhp
 msgctxt ""
 "03140000.xhp\n"
-"hd_id061420170116474964\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-
-#: 03140000.xhp
-msgctxt ""
-"03140000.xhp\n"
-"hd_id0614201701254487\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functvalue\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functvalue\"/>"
-
-#: 03140000.xhp
-msgctxt ""
-"03140000.xhp\n"
-"hd_id061420170125448913\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-
-#: 03140000.xhp
-msgctxt ""
-"03140000.xhp\n"
 "par_id061420170142332738\n"
 "help.text"
 msgid "<emph>Cost</emph> fixes the initial cost of an asset."
@@ -33179,14 +33027,6 @@ msgstr "Use this form of depreciation if you require a higher initial depreciati
 #: 03140000.xhp
 msgctxt ""
 "03140000.xhp\n"
-"hd_id061420170125449765\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-
-#: 03140000.xhp
-msgctxt ""
-"03140000.xhp\n"
 "par_id061420170142332315\n"
 "help.text"
 msgid "Print ddb_yr1 ' returns 1,721.81 currency units."
@@ -33200,14 +33040,6 @@ msgctxt ""
 msgid "<link href=\"text/scalc/01/04060103.xhp#bm_id3149998\">DDB function in CALC</link>"
 msgstr "<link href=\"text/scalc/01/04060103.xhp#bm_id3149998\">DDB function in CALC</link>"
 
-#: 03140000.xhp
-msgctxt ""
-"03140000.xhp\n"
-"par_id06142017015837916\n"
-"help.text"
-msgid "<link href=\"text/sbasic/shared/special_vba_func.xhp\">VBA financial functions</link>"
-msgstr "<link href=\"text/sbasic/shared/special_vba_func.xhp\">VBA financial functions</link>"
-
 #: 03140001.xhp
 msgctxt ""
 "03140001.xhp\n"
@@ -33243,30 +33075,6 @@ msgstr "Returns the future value of an investment based on periodic, constant pa
 #: 03140001.xhp
 msgctxt ""
 "03140001.xhp\n"
-"hd_id061420170116474964\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-
-#: 03140001.xhp
-msgctxt ""
-"03140001.xhp\n"
-"hd_id0614201701254487\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functvalue\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functvalue\"/>"
-
-#: 03140001.xhp
-msgctxt ""
-"03140001.xhp\n"
-"hd_id061420170125448913\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-
-#: 03140001.xhp
-msgctxt ""
-"03140001.xhp\n"
 "par_id06142017042024114\n"
 "help.text"
 msgid "<emph>Rate</emph> is the periodic interest rate."
@@ -33323,14 +33131,6 @@ msgstr "1 - the payment is due at the beginning of the period."
 #: 03140001.xhp
 msgctxt ""
 "03140001.xhp\n"
-"hd_id061420170125449765\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-
-#: 03140001.xhp
-msgctxt ""
-"03140001.xhp\n"
 "par_id061420170142332315\n"
 "help.text"
 msgid "Print myFV ' returns 4234.00 currency units. The value at the end of the investment is 4234.00 currency units."
@@ -33344,14 +33144,6 @@ msgctxt ""
 msgid "<link href=\"text/scalc/01/04060118.xhp#bm_id3151205\">FV function in CALC</link>"
 msgstr "<link href=\"text/scalc/01/04060118.xhp#bm_id3151205\">FV function in CALC</link>"
 
-#: 03140001.xhp
-msgctxt ""
-"03140001.xhp\n"
-"par_id06142017015837916\n"
-"help.text"
-msgid "<link href=\"text/sbasic/shared/special_vba_func.xhp\">VBA financial functions</link>"
-msgstr "<link href=\"text/sbasic/shared/special_vba_func.xhp\">VBA financial functions</link>"
-
 #: 03140002.xhp
 msgctxt ""
 "03140002.xhp\n"
@@ -33387,30 +33179,6 @@ msgstr "Calculates the periodic amortisement for an investment with regular paym
 #: 03140002.xhp
 msgctxt ""
 "03140002.xhp\n"
-"hd_id061420170116474964\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-
-#: 03140002.xhp
-msgctxt ""
-"03140002.xhp\n"
-"hd_id0614201701254487\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functvalue\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functvalue\"/>"
-
-#: 03140002.xhp
-msgctxt ""
-"03140002.xhp\n"
-"hd_id061420170125448913\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-
-#: 03140002.xhp
-msgctxt ""
-"03140002.xhp\n"
 "par_id061420170730135034\n"
 "help.text"
 msgid "<emph>Rate</emph> is the periodic interest rate."
@@ -33475,14 +33243,6 @@ msgstr "1 - the payment is due at the beginning of the period."
 #: 03140002.xhp
 msgctxt ""
 "03140002.xhp\n"
-"hd_id061420170125449765\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-
-#: 03140002.xhp
-msgctxt ""
-"03140002.xhp\n"
 "par_id061420170142332315\n"
 "help.text"
 msgid "Print myIPmt ' returns -352.97 currency units. The compound interest during the fifth period (year) is 352.97 currency units."
@@ -33496,14 +33256,6 @@ msgctxt ""
 msgid "<link href=\"text/scalc/01/04060118.xhp#bm_id3149339\">IPMT function in CALC</link>"
 msgstr "<link href=\"text/scalc/01/04060118.xhp#bm_id3149339\">IPMT function in CALC</link>"
 
-#: 03140002.xhp
-msgctxt ""
-"03140002.xhp\n"
-"par_id06142017015837916\n"
-"help.text"
-msgid "<link href=\"text/sbasic/shared/special_vba_func.xhp\">VBA financial functions</link>"
-msgstr "<link href=\"text/sbasic/shared/special_vba_func.xhp\">VBA financial functions</link>"
-
 #: 03140003.xhp
 msgctxt ""
 "03140003.xhp\n"
@@ -33539,30 +33291,6 @@ msgstr "Calculates the internal rate of return for an investment."
 #: 03140003.xhp
 msgctxt ""
 "03140003.xhp\n"
-"hd_id061420170116474964\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-
-#: 03140003.xhp
-msgctxt ""
-"03140003.xhp\n"
-"hd_id0614201701254487\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functvalue\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functvalue\"/>"
-
-#: 03140003.xhp
-msgctxt ""
-"03140003.xhp\n"
-"hd_id061420170125448913\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-
-#: 03140003.xhp
-msgctxt ""
-"03140003.xhp\n"
 "par_id061420170730135034\n"
 "help.text"
 msgid "<emph>Values(): </emph>The array of values of the cash-flow. The values represent cash flow values at regular intervals, at least one value must be negative (payments), and at least one value must be positive (income)."
@@ -33579,14 +33307,6 @@ msgstr "<emph>Guess</emph> An initial estimate at what the IRR will be."
 #: 03140003.xhp
 msgctxt ""
 "03140003.xhp\n"
-"hd_id061420170125449765\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-
-#: 03140003.xhp
-msgctxt ""
-"03140003.xhp\n"
 "par_id061620170217548258\n"
 "help.text"
 msgid "Print irrValue ' returns 11.3321028236252 . The internal rate of return of the cash flow."
@@ -33600,14 +33320,6 @@ msgctxt ""
 msgid "<link href=\"text/scalc/01/04060103.xhp#bm_id3153948\">IRR function in CALC</link>"
 msgstr "<link href=\"text/scalc/01/04060103.xhp#bm_id3153948\">IRR function in CALC</link>"
 
-#: 03140003.xhp
-msgctxt ""
-"03140003.xhp\n"
-"par_id06142017015837916\n"
-"help.text"
-msgid "<link href=\"text/sbasic/shared/special_vba_func.xhp\">VBA financial functions</link>"
-msgstr "<link href=\"text/sbasic/shared/special_vba_func.xhp\">VBA financial functions</link>"
-
 #: 03140004.xhp
 msgctxt ""
 "03140004.xhp\n"
@@ -33643,30 +33355,6 @@ msgstr "Calculates the modified internal rate of return of a series of investmen
 #: 03140004.xhp
 msgctxt ""
 "03140004.xhp\n"
-"hd_id061420170116474964\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-
-#: 03140004.xhp
-msgctxt ""
-"03140004.xhp\n"
-"hd_id0614201701254487\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functvalue\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functvalue\"/>"
-
-#: 03140004.xhp
-msgctxt ""
-"03140004.xhp\n"
-"hd_id061420170125448913\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-
-#: 03140004.xhp
-msgctxt ""
-"03140004.xhp\n"
 "par_id061420170730135034\n"
 "help.text"
 msgid "<emph>Values(): </emph>An array of cash flows, representing a series of payments and income, where negative values are treated as payments and positive values are treated as income. This array must contain at least one negative and at least one positive value."
@@ -33691,14 +33379,6 @@ msgstr "<emph>ReinvestRate:</emph> the rate of interest of the reinvestment (the
 #: 03140004.xhp
 msgctxt ""
 "03140004.xhp\n"
-"hd_id061420170125449765\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-
-#: 03140004.xhp
-msgctxt ""
-"03140004.xhp\n"
 "par_id061620170217548258\n"
 "help.text"
 msgid "Print mirrValue ' returns 94.16. The modified internal rate of return of the cash flow."
@@ -33712,14 +33392,6 @@ msgctxt ""
 msgid "<link href=\"text/scalc/01/04060119.xhp#bm_id3148974\">MIRR function in CALC</link>"
 msgstr "<link href=\"text/scalc/01/04060119.xhp#bm_id3148974\">MIRR function in CALC</link>"
 
-#: 03140004.xhp
-msgctxt ""
-"03140004.xhp\n"
-"par_id06142017015837916\n"
-"help.text"
-msgid "<link href=\"text/sbasic/shared/special_vba_func.xhp\">VBA financial functions</link>"
-msgstr "<link href=\"text/sbasic/shared/special_vba_func.xhp\">VBA financial functions</link>"
-
 #: 03140005.xhp
 msgctxt ""
 "03140005.xhp\n"
@@ -33755,30 +33427,6 @@ msgstr "Calculates the number of periods for a loan or investment."
 #: 03140005.xhp
 msgctxt ""
 "03140005.xhp\n"
-"hd_id061420170116474964\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-
-#: 03140005.xhp
-msgctxt ""
-"03140005.xhp\n"
-"hd_id0614201701254487\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functvalue\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functvalue\"/>"
-
-#: 03140005.xhp
-msgctxt ""
-"03140005.xhp\n"
-"hd_id061420170125448913\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-
-#: 03140005.xhp
-msgctxt ""
-"03140005.xhp\n"
 "par_id06142017042024114\n"
 "help.text"
 msgid "<emph>Rate</emph> is the periodic interest rate."
@@ -33835,14 +33483,6 @@ msgstr "1 - the payment is due at the beginning of the period."
 #: 03140005.xhp
 msgctxt ""
 "03140005.xhp\n"
-"hd_id061420170125449765\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-msgstr "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-
-#: 03140005.xhp
-msgctxt ""
-"03140005.xhp\n"
 "par_id061420170142332315\n"
 "help.text"
 msgid "Print period ' returns -12,02. The payment period covers 12.02 periods."
@@ -33856,14 +33496,6 @@ msgctxt ""
 msgid "<link href=\"text/scalc/01/04060118.xhp#bm_id3156435\">NPER function in CALC</link>"
 msgstr "<link href=\"text/scalc/01/04060118.xhp#bm_id3156435\">NPER function in CALC</link>"
 
-#: 03140005.xhp
-msgctxt ""
-"03140005.xhp\n"
-"par_id06142017015837916\n"
-"help.text"
-msgid "<link href=\"text/sbasic/shared/special_vba_func.xhp\">VBA financial functions</link>"
-msgstr "<link href=\"text/sbasic/shared/special_vba_func.xhp\">VBA financial functions</link>"
-
 #: 05060700.xhp
 msgctxt ""
 "05060700.xhp\n"
diff --git a/source/en-GB/helpcontent2/source/text/scalc/01.po b/source/en-GB/helpcontent2/source/text/scalc/01.po
index 0b034b43367..ed297313a98 100644
--- a/source/en-GB/helpcontent2/source/text/scalc/01.po
+++ b/source/en-GB/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: 2017-05-30 09:54+0200\n"
+"POT-Creation-Date: 2017-07-20 11:52+0200\n"
 "PO-Revision-Date: 2017-06-04 12:21+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n != 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1496578862.000000\n"
 
 #: 01120000.xhp
@@ -57861,8 +57861,8 @@ msgctxt ""
 "func_color.xhp\n"
 "bm_id1102201617201921\n"
 "help.text"
-msgid "<bookmark_value>colors;numerical values</bookmark_value>  <bookmark_value>colors;calculating in spreadsheets</bookmark_value>  <bookmark_value>COLOR function</bookmark_value>"
-msgstr "<bookmark_value>colours;numerical values</bookmark_value>  <bookmark_value>colours;calculating in spreadsheets</bookmark_value>  <bookmark_value>COLOUR function</bookmark_value>"
+msgid "<bookmark_value>colors;numerical values</bookmark_value>         <bookmark_value>colors;calculating in spreadsheets</bookmark_value>         <bookmark_value>COLOR function</bookmark_value>"
+msgstr ""
 
 #: func_color.xhp
 msgctxt ""
@@ -61637,24 +61637,24 @@ msgctxt ""
 "func_rawsubtract.xhp\n"
 "bm_2016112109230\n"
 "help.text"
-msgid "<bookmark_value>rawsubtract;subtraction</bookmark_value>            <bookmark_value>RAWSUBTRACT function</bookmark_value>"
-msgstr "<bookmark_value>rawsubtract;subtraction</bookmark_value>            <bookmark_value>RAWSUBTRACT function</bookmark_value>"
+msgid "<bookmark_value>rawsubtract;subtraction</bookmark_value>        <bookmark_value>RAWSUBTRACT function</bookmark_value>"
+msgstr ""
 
 #: func_rawsubtract.xhp
 msgctxt ""
 "func_rawsubtract.xhp\n"
 "hd_2016112109231\n"
 "help.text"
-msgid "<variable id=\"rawsubtract_head\"><link href=\"text/scalc/01/func_rawsubtract.xhp\">RAWSUBTRACT</link></variable>"
-msgstr "<variable id=\"rawsubtract_head\"><link href=\"text/scalc/01/func_rawsubtract.xhp\">RAWSUBTRACT</link></variable>"
+msgid "<link href=\"text/scalc/01/func_rawsubtract.xhp\">RAWSUBTRACT</link>"
+msgstr ""
 
 #: func_rawsubtract.xhp
 msgctxt ""
 "func_rawsubtract.xhp\n"
 "par_2016112109232\n"
 "help.text"
-msgid "<ahelp hid=\".\">Subtracts a set of numbers and gives the result without eliminating small roundoff errors. </ahelp>"
-msgstr "<ahelp hid=\".\">Subtracts a set of numbers and gives the result without eliminating small roundoff errors. </ahelp>"
+msgid "<ahelp hid=\".\">Subtracts a set of numbers and gives the result without eliminating small roundoff errors.</ahelp>"
+msgstr ""
 
 #: func_rawsubtract.xhp
 msgctxt ""
diff --git a/source/en-GB/helpcontent2/source/text/scalc/guide.po b/source/en-GB/helpcontent2/source/text/scalc/guide.po
index d537bd0c0e9..9f8f4af4f00 100644
--- a/source/en-GB/helpcontent2/source/text/scalc/guide.po
+++ b/source/en-GB/helpcontent2/source/text/scalc/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: 2017-05-12 14:35+0200\n"
+"POT-Creation-Date: 2017-07-20 11:52+0200\n"
 "PO-Revision-Date: 2017-06-04 12:21+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n != 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1496578907.000000\n"
 
 #: address_auto.xhp
@@ -309,8 +309,8 @@ msgctxt ""
 "autofilter.xhp\n"
 "par_id3153714\n"
 "help.text"
-msgid "To display all records again, select the \"all<emph>\"</emph> entry in the AutoFilter combo box. If you choose \"Standard<emph>\"</emph>, the <item type=\"menuitem\">Standard Filter</item> dialog appears, allowing you to set up a standard filter. Choose \"Top 10\" to display the highest 10 values only."
-msgstr "To display all records again, select the <emph>- all -</emph> entry in the AutoFilter combo box. If you choose <emph>-Standard-</emph>, the <item type=\"menuitem\">Standard Filter</item> dialogue box appears, allowing you to set up a standard filter. Choose \"Top 10\" to display the highest 10 values only."
+msgid "To display all records again, select the <emph>all</emph> entry in the AutoFilter combo box. If you choose \"Standard<emph>\"</emph>, the <item type=\"menuitem\">Standard Filter</item> dialog appears, allowing you to set up a standard filter. Choose \"Top 10\" to display the highest 10 values only."
+msgstr ""
 
 #: autofilter.xhp
 msgctxt ""
diff --git a/source/en-GB/helpcontent2/source/text/schart/01.po b/source/en-GB/helpcontent2/source/text/schart/01.po
index 3bdd07d6f67..cae3cf8916a 100644
--- a/source/en-GB/helpcontent2/source/text/schart/01.po
+++ b/source/en-GB/helpcontent2/source/text/schart/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: 2017-06-06 20:00+0200\n"
+"POT-Creation-Date: 2017-07-20 11:52+0200\n"
 "PO-Revision-Date: 2017-06-12 15:16+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n != 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1497280618.000000\n"
 
 #: 03010000.xhp
@@ -1469,8 +1469,8 @@ msgctxt ""
 "04050100.xhp\n"
 "par_id18082016163702791\n"
 "help.text"
-msgid "To show the coefficient of determination R<sup>2</sup>, select the equation in the chart, right-click to open the context menu, and choose <item type=\"menuitem\">Insert R<sup>2</sup></item>."
-msgstr "To show the coefficient of determination R<sup>2</sup>, select the equation in the chart, right-click to open the context menu, and choose <item type=\"menuitem\">Insert R<sup>2</sup></item>."
+msgid "To show the coefficient of determination R<sup>2</sup>, select the equation in the chart, right-click to open the context menu, and choose <item type=\"menuitem\">Insert R</item><item type=\"menuitem\">2</item>."
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
@@ -1509,8 +1509,8 @@ msgctxt ""
 "04050100.xhp\n"
 "par_id180820161612524298\n"
 "help.text"
-msgid "<emph>Polynomial</emph> trend line: regression through equation <item type=\"literal\">y=Σ(a<sub>i</sub>∙x<sup>i</sup>)</item>. Intercept <item type=\"literal\">a<sub>0</sub></item> can be forced. Degree of polynomial must be given (at least 2)."
-msgstr "<emph>Polynomial</emph> trend line: regression through equation <item type=\"literal\">y=Σ(a<sub>i</sub>∙x<sup>i</sup>)</item>. Intercept <item type=\"literal\">a<sub>0</sub></item> can be forced. Degree of polynomial must be given (at least 2)."
+msgid "<emph>Polynomial</emph> trend line: regression through equation <item type=\"literal\">y=Σ(a</item><item type=\"literal\">i</item><item type=\"literal\">∙x</item><item type=\"literal\">i</item><item type=\"literal\">)</item>. Intercept <item type=\"literal\">a</item><item type=\"literal\">0</item> can be forced. Degree of polynomial must be given (at least 2)."
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
@@ -1525,16 +1525,16 @@ msgctxt ""
 "04050100.xhp\n"
 "par_id180820161612526680\n"
 "help.text"
-msgid "<emph>Exponential</emph> trend line: regression through equation <item type=\"literal\">y=b∙exp(a∙x)</item>.This equation is equivalent to <item type=\"literal\">y=b∙m<sup>x</sup></item> with <item type=\"literal\">m=exp(a)</item>. Intercept <item type=\"literal\">b</item> can be forced."
-msgstr "<emph>Exponential</emph> trend line: regression through equation <item type=\"literal\">y=b∙exp(a∙x)</item>.This equation is equivalent to <item type=\"literal\">y=b∙m<sup>x</sup></item> with <item type=\"literal\">m=exp(a)</item>. Intercept <item type=\"literal\">b</item> can be forced."
+msgid "<emph>Exponential</emph> trend line: regression through equation <item type=\"literal\">y=b∙exp(a∙x)</item>.This equation is equivalent to <item type=\"literal\">y=b∙m</item><item type=\"literal\">x</item> with <item type=\"literal\">m=exp(a)</item>. Intercept <item type=\"literal\">b</item> can be forced."
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
 "par_id180820161612527230\n"
 "help.text"
-msgid "<emph>Power</emph> trend line: regression through equation <item type=\"literal\">y=b∙x<sup>a</sup></item>."
-msgstr "<emph>Power</emph> trend line: regression through equation <item type=\"literal\">y=b∙x<sup>a</sup></item>."
+msgid "<emph>Power</emph> trend line: regression through equation <item type=\"literal\">y=b∙x</item><item type=\"literal\">a</item>."
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
@@ -1581,8 +1581,8 @@ msgctxt ""
 "04050100.xhp\n"
 "par_id8734702\n"
 "help.text"
-msgid "Power trend line: only positive x-values are considered; only positive y-values are considered, except if all y-values are negative: regression will then follow equation<item type=\"literal\"> y=-b∙x<sup>a</sup></item>."
-msgstr "Power trend line: only positive x-values are considered; only positive y-values are considered, except if all y-values are negative: regression will then follow equation<item type=\"literal\"> y=-b∙x<sup>a</sup></item>."
+msgid "Power trend line: only positive x-values are considered; only positive y-values are considered, except if all y-values are negative: regression will then follow equation<item type=\"literal\"> y=-b∙x</item><item type=\"literal\">a</item>."
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
@@ -1725,8 +1725,8 @@ msgctxt ""
 "04050100.xhp\n"
 "par_id9112216\n"
 "help.text"
-msgid "The exponential regression follows the equation <item type=\"literal\">y=b*exp(a*x)</item> or <item type=\"literal\">y=b*m^x</item>, which is transformed to <item type=\"literal\">ln(y)=ln(b)+a*x</item> or <item type=\"literal\">ln(y)=ln(b)+ln(m)*x</item> respectively."
-msgstr "The exponential regression follows the equation <item type=\"literal\">y=b*exp(a*x)</item> or <item type=\"literal\">y=b*m^x</item>, which is transformed to <item type=\"literal\">ln(y) = ln(b) + a*x</item> or <item type=\"literal\">ln(y) = ln(b) + ln(m)*x</item> respectively."
+msgid "The exponential regression follows the equation <item type=\"literal\">y=b*exp(a*x)</item> or <item type=\"literal\">y=b*m</item><sup>x</sup>, which is transformed to <item type=\"literal\">ln(y)=ln(b)+a*x</item> or <item type=\"literal\">ln(y)=ln(b)+ln(m)*x</item> respectively."
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
@@ -1781,8 +1781,8 @@ msgctxt ""
 "04050100.xhp\n"
 "par_id6946317\n"
 "help.text"
-msgid "Besides m, b and r<sup>2</sup> the array function LOGEST provides additional statistics for a regression analysis."
-msgstr "Besides m, b and r<sup>2</sup> the array function LOGEST provides additional statistics for a regression analysis."
+msgid "Besides m, b and r<sup>2</sup> the array function <emph>LOGEST</emph> provides additional statistics for a regression analysis."
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
@@ -1861,16 +1861,16 @@ msgctxt ""
 "04050100.xhp\n"
 "par_id5068514\n"
 "help.text"
-msgid "The first row of the LINEST output contains the coefficients of the regression polynomial, with the coefficient of xⁿ at the leftmost position."
-msgstr "The first row of the LINEST output contains the coefficients of the regression polynomial, with the coefficient of xⁿ at the leftmost position."
+msgid "The first row of the <emph>LINEST</emph> output contains the coefficients of the regression polynomial, with the coefficient of xⁿ at the leftmost position."
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
 "par_id8202154\n"
 "help.text"
-msgid "The first element of the third row of the LINEST output is the value of r<sup>2</sup>. See the <link href=\"text/scalc/01/04060107.xhp#Section8\">LINEST</link> function for details on proper use and an explanation of the other output parameters."
-msgstr "The first element of the third row of the LINEST output is the value of r<sup>2</sup>. See the <link href=\"text/scalc/01/04060107.xhp#Section8\">LINEST</link> function for details on proper use and an explanation of the other output parameters."
+msgid "The first element of the third row of the <emph>LINEST</emph> output is the value of r<sup>2</sup>. See the <link href=\"text/scalc/01/04060107.xhp#Section8\"><emph>LINEST</emph></link> function for details on proper use and an explanation of the other output parameters."
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
diff --git a/source/en-GB/helpcontent2/source/text/shared/explorer/database.po b/source/en-GB/helpcontent2/source/text/shared/explorer/database.po
index 19364d2f7f3..2fe224ecc24 100644
--- a/source/en-GB/helpcontent2/source/text/shared/explorer/database.po
+++ b/source/en-GB/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: 2017-05-30 09:54+0200\n"
+"POT-Creation-Date: 2017-07-20 11:52+0200\n"
 "PO-Revision-Date: 2017-06-04 22:38+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n != 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1496615904.000000\n"
 
 #: 02000000.xhp
@@ -11989,8 +11989,8 @@ msgctxt ""
 "rep_prop.xhp\n"
 "hd_id8836939\n"
 "help.text"
-msgid "<variable id=\"rep_prop\"><link href=\"text/shared/explorer/database/rep_prop.xhp\">Properties</link></variable>"
-msgstr "<variable id=\"rep_prop\"><link href=\"text/shared/explorer/database/rep_prop.xhp\">Properties</link></variable>"
+msgid "<variable id=\"rep_prop\"><link href=\"text/shared/explorer/database/rep_prop.xhp\">Properties</link> </variable>"
+msgstr ""
 
 #: rep_prop.xhp
 msgctxt ""
@@ -12005,8 +12005,8 @@ msgctxt ""
 "rep_prop.xhp\n"
 "par_id1080660\n"
 "help.text"
-msgid "Press <item type=\"keycode\">Shift-F1</item> and point with the mouse at an input box to see a help text for this input box."
-msgstr "Press <item type=\"keycode\">Shift-F1</item> and point with the mouse at an input box to see a help text for this input box."
+msgid "Press Shift-F1 and point with the mouse at an input box to see a help text for this input box."
+msgstr ""
 
 #: rep_prop.xhp
 msgctxt ""
@@ -12045,8 +12045,8 @@ msgctxt ""
 "rep_prop.xhp\n"
 "par_id3729361\n"
 "help.text"
-msgid "<ahelp hid=\".\">To display the Data or General tab page for the whole report, choose Edit - Select Report.</ahelp>"
-msgstr "<ahelp hid=\".\">To display the Data or General tab page for the whole report, choose Edit - Select Report.</ahelp>"
+msgid "<ahelp hid=\".\">To display the <emph>Data</emph> or <emph>General</emph> tab page for the whole report, choose <item type=\"menuitem\">Edit - Select All - Select Report</item>.</ahelp>"
+msgstr ""
 
 #: rep_prop.xhp
 msgctxt ""
diff --git a/source/en-GB/helpcontent2/source/text/shared/optionen.po b/source/en-GB/helpcontent2/source/text/shared/optionen.po
index 2f9dc85d104..f2b2cec0b00 100644
--- a/source/en-GB/helpcontent2/source/text/shared/optionen.po
+++ b/source/en-GB/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: 2017-06-20 14:27+0200\n"
+"POT-Creation-Date: 2017-07-20 11:53+0200\n"
 "PO-Revision-Date: 2017-06-21 09:36+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n != 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1498037810.000000\n"
 
 #: 01000000.xhp
@@ -2269,8 +2269,8 @@ msgctxt ""
 "01010501.xhp\n"
 "bm_id3150771\n"
 "help.text"
-msgid "<bookmark_value>defining;colors</bookmark_value><bookmark_value>colors;selection</bookmark_value><bookmark_value>colors;adding</bookmark_value>"
-msgstr "<bookmark_value>defining;colours</bookmark_value><bookmark_value>colours;selection</bookmark_value><bookmark_value>colours;adding</bookmark_value>"
+msgid "<bookmark_value>defining;colors</bookmark_value>  <bookmark_value>colors;selection</bookmark_value>  <bookmark_value>colors;adding</bookmark_value>"
+msgstr ""
 
 #: 01010501.xhp
 msgctxt ""
@@ -2293,8 +2293,8 @@ msgctxt ""
 "01010501.xhp\n"
 "par_id61884\n"
 "help.text"
-msgid "<image id=\"img_id5337\" src=\"media/screenshots/cui/ui/colorpickerdialog/ColorPicker.png\"><caption id=\"alt_id34144\">Pick a Color window</caption></image>"
-msgstr "<image id=\"img_id5337\" src=\"media/screenshots/cui/ui/colorpickerdialog/ColorPicker.png\"><caption id=\"alt_id34144\">Pick a Colour window</caption></image>"
+msgid "<image id=\"img_id5337\" src=\"media/screenshots/cui/ui/colorpickerdialog/ColorPicker.png\" width=\"0.566cm\" height=\"0.566cm\"><alt id=\"alt_id5337\">{ENTER ALTERNATE DESCRIPTION HERE}</alt><caption id=\"alt_id34144\">Pick a Color window</caption></image>"
+msgstr ""
 
 #: 01010501.xhp
 msgctxt ""
@@ -2413,8 +2413,8 @@ msgctxt ""
 "01010501.xhp\n"
 "par_id3153728\n"
 "help.text"
-msgid "<ahelp hid=\".\">Sets the Green component modifiable on the vertical color slider, and the Green and Blue components in the two dimensional color picker field. Allowed values are 0 to 255.</ahelp>"
-msgstr "<ahelp hid=\".\">Sets the Green component modifiable on the vertical colour slider, and the Green and Blue components in the two dimensional colour picker field. Allowed values are 0 to 255.</ahelp>"
+msgid "<ahelp hid=\".\">Sets the Green component modifiable on the vertical color slider, and the Red and Blue components in the two dimensional color picker field. Allowed values are 0 to 255.</ahelp>"
+msgstr ""
 
 #: 01010501.xhp
 msgctxt ""
@@ -2437,8 +2437,8 @@ msgctxt ""
 "01010501.xhp\n"
 "par_id3153729\n"
 "help.text"
-msgid "<ahelp hid=\".\">Sets the Red component modifiable on the vertical color slider, and the Green and Blue components in the two dimensional color picker field. Allowed values are 0 to 255.</ahelp>"
-msgstr "<ahelp hid=\".\">Sets the Red component modifiable on the vertical colour slider, and the Green and Blue components in the two dimensional colour picker field. Allowed values are 0 to 255.</ahelp>"
+msgid "<ahelp hid=\".\">Sets the Blue component modifiable on the vertical color slider, and the Green and Red components in the two dimensional color picker field. Allowed values are 0 to 255.</ahelp>"
+msgstr ""
 
 #: 01010501.xhp
 msgctxt ""
@@ -2517,8 +2517,8 @@ msgctxt ""
 "01010501.xhp\n"
 "par_id3153512\n"
 "help.text"
-msgid "<ahelp hid=\"cui/ui/colorpickerdialog/satSpinbutton\" visibility=\"hidden\">Set the Saturation directly in the HSB color model. Values are expressed in percent ( 0 to 100).</ahelp>"
-msgstr "<ahelp hid=\"cui/ui/colorpickerdialog/satSpinbutton\" visibility=\"hidden\">Set the Saturation directly in the HSB colour model. Values are expressed in percent (0 to 100).</ahelp>"
+msgid "<ahelp hid=\"cui/ui/colorpickerdialog/satSpinbutton\" visibility=\"hidden\">Set the Saturation directly in the HSB color model. Values are expressed in percent (0 to 100).</ahelp>"
+msgstr ""
 
 #: 01010501.xhp
 msgctxt ""
@@ -2541,8 +2541,8 @@ msgctxt ""
 "01010501.xhp\n"
 "par_id3146969\n"
 "help.text"
-msgid "<ahelp hid=\"cui/ui/colorpickerdialog/brightSpinbutton\" visibility=\"hidden\">Set the Brightness directly in the HSB color model. Values are expressed in percent ( 0 to 100).</ahelp>"
-msgstr "<ahelp hid=\"cui/ui/colorpickerdialog/brightSpinbutton\" visibility=\"hidden\">Set the Brightness directly in the HSB colour model. Values are expressed in percent (0 to 100).</ahelp>"
+msgid "<ahelp hid=\"cui/ui/colorpickerdialog/brightSpinbutton\" visibility=\"hidden\">Set the Brightness directly in the HSB color model. Values are expressed in percent (0 to 100).</ahelp>"
+msgstr ""
 
 #: 01010501.xhp
 msgctxt ""
diff --git a/source/en-GB/helpcontent2/source/text/swriter/guide.po b/source/en-GB/helpcontent2/source/text/swriter/guide.po
index e2316b2db74..1efc000143e 100644
--- a/source/en-GB/helpcontent2/source/text/swriter/guide.po
+++ b/source/en-GB/helpcontent2/source/text/swriter/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: 2017-06-20 14:50+0200\n"
+"POT-Creation-Date: 2017-07-20 11:52+0200\n"
 "PO-Revision-Date: 2017-06-21 09:41+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n != 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1498038089.000000\n"
 
 #: anchor_object.xhp
@@ -11341,8 +11341,8 @@ msgctxt ""
 "protection.xhp\n"
 "par_id18112016234566\n"
 "help.text"
-msgid "If the protection has a password, and you want only to change it, click to the <emph>Password</emph> button in the <emph>Write protection</emph>, enter the correct password twice."
-msgstr "If the protection has a password, and you want only to change it, click to the <emph>Password</emph> button in the <emph>Write protection</emph>, enter the correct password twice."
+msgid "If the section is protected with a password and you only want to change it, click on the <emph>Password</emph> button in the <emph>Edit Sections</emph> window and enter the correct password twice."
+msgstr ""
 
 #: protection.xhp
 msgctxt ""
@@ -11405,8 +11405,8 @@ msgctxt ""
 "protection.xhp\n"
 "par_id3155178\n"
 "help.text"
-msgid "<variable id=\"firstof\">If necessary, choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"menuitem\">%PRODUCTNAME - Preferences</item></caseinline><defaultinline><item type=\"menuitem\">Tools - Options</item></defaultinline></switchinline><item type=\"menuitem\"> - %PRODUCTNAME Writer - Formatting Aids</item> and select <emph>Enable cursor</emph> under the <emph>Protected Areas</emph>.</variable>"
-msgstr "<variable id=\"firstof\">If necessary, choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"menuitem\">%PRODUCTNAME - Preferences</item></caseinline><defaultinline><item type=\"menuitem\">Tools - Options</item></defaultinline></switchinline><item type=\"menuitem\"> - %PRODUCTNAME Writer - Formatting Aids</item> and select <emph>Enable cursor</emph> under the <emph>Protected Areas</emph>.</variable>"
+msgid "<variable id=\"firstof\">If necessary, choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"menuitem\">%PRODUCTNAME - Preferences</item> </caseinline><defaultinline><item type=\"menuitem\">Tools - Options</item></defaultinline></switchinline><item type=\"menuitem\"> - %PRODUCTNAME Writer - Formatting Aids</item> and select <emph>Enable cursor</emph> under the <emph>Protected Areas</emph>.</variable>"
+msgstr ""
 
 #: protection.xhp
 msgctxt ""
@@ -11493,8 +11493,8 @@ msgctxt ""
 "protection.xhp\n"
 "par_id18112016812973\n"
 "help.text"
-msgid "To enable the protection of the whole document, go to <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph><item type=\"menuitem\">%PRODUCTNAME - Preferences</item></emph></caseinline><defaultinline><emph><item type=\"menuitem\">Tools - Options</item></emph></defaultinline></switchinline><emph><item type=\"menuitem\"> - %PRODUCTNAME Writer - Compatibility</item></emph> and choose <emph>Protect form</emph>. To disable protection, uncheck it."
-msgstr "To enable the protection of the whole document, go to <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph><item type=\"menuitem\">%PRODUCTNAME - Preferences</item></emph></caseinline><defaultinline><emph><item type=\"menuitem\">Tools - Options</item></emph></defaultinline></switchinline><emph><item type=\"menuitem\"> - %PRODUCTNAME Writer - Compatibility</item></emph> and choose <emph>Protect form</emph>. To disable protection, uncheck it."
+msgid "To enable the protection of the whole document, go to <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Writer - Compatibility</emph> and choose <emph>Protect form</emph>. To disable protection, uncheck it."
+msgstr ""
 
 #: protection.xhp
 msgctxt ""
diff --git a/source/en-GB/xmlsecurity/source/dialogs.po b/source/en-GB/xmlsecurity/source/dialogs.po
index ca3ac74ef04..12fafab3afb 100644
--- a/source/en-GB/xmlsecurity/source/dialogs.po
+++ b/source/en-GB/xmlsecurity/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: 2017-04-12 14:13+0200\n"
+"POT-Creation-Date: 2017-07-20 11:52+0200\n"
 "PO-Revision-Date: 2016-05-26 13:14+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -153,3 +153,13 @@ msgid ""
 msgstr ""
 "Adding or removing a macro signature will remove all document signatures.\n"
 "Do you really want to continue?"
+
+#: digitalsignaturesdialog.src
+msgctxt ""
+"digitalsignaturesdialog.src\n"
+"STR_XMLSECDLG_QUERY_REALLYREMOVE\n"
+"string.text"
+msgid ""
+"Document signature cannot be restored, once removed.\n"
+"Do you really want to remove selected signature?"
+msgstr ""
diff --git a/source/en-GB/xmlsecurity/uiconfig/ui.po b/source/en-GB/xmlsecurity/uiconfig/ui.po
index b239154a276..155c8dfa467 100644
--- a/source/en-GB/xmlsecurity/uiconfig/ui.po
+++ b/source/en-GB/xmlsecurity/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: 2017-06-20 13:55+0200\n"
+"POT-Creation-Date: 2017-07-20 11:52+0200\n"
 "PO-Revision-Date: 2017-06-20 22:32+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n != 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1497997974.000000\n"
 
 #: certgeneral.ui
@@ -491,6 +491,15 @@ msgstr "Expiration date"
 #: selectcertificatedialog.ui
 msgctxt ""
 "selectcertificatedialog.ui\n"
+"type\n"
+"label\n"
+"string.text"
+msgid "Type"
+msgstr ""
+
+#: selectcertificatedialog.ui
+msgctxt ""
+"selectcertificatedialog.ui\n"
 "STR_DIGITAL_SIGNATURE\n"
 "label\n"
 "string.text"