update translations for master

and force-fix errors using pocheck

Change-Id: I9b084737aef30bc65308a263b5fdcd68316197ba

1 files changed, 212 insertions, 122 deletions

diff --git a/source/bg/helpcontent2/source/text/scalc/01.po b/source/bg/helpcontent2/source/text/scalc/01.po
index afebd7ef005..8881c4c943b 100644
--- a/source/bg/helpcontent2/source/text/scalc/01.po
+++ b/source/bg/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: 2022-10-10 13:35+0200\n"
+"POT-Creation-Date: 2022-10-22 14:13+0200\n"
 "PO-Revision-Date: 2022-07-19 20:03+0000\n"
 "Last-Translator: Mihail Balabanov <m.balabanov@gmail.com>\n"
 "Language-Team: Bulgarian <https://translations.documentfoundation.org/projects/libo_help-master/textscalc01/bg/>\n"
@@ -44990,14 +44990,14 @@ msgctxt ""
 msgid "Conditional Formatting"
 msgstr "Условно форматиране"
 
-#. 76cMu
+#. Gvgde
 #: 05120000.xhp
 msgctxt ""
 "05120000.xhp\n"
-"hd_id3155132\n"
+"hd_id51665407876959\n"
 "help.text"
-msgid "Conditional Formatting"
-msgstr "Условно форматиране"
+msgid "<variable id=\"ConditionalFormattingh1\"><link href=\"text/scalc/01/05120000.xhp\" name=\"Conditional Formatting\">Conditional Formatting</link></variable>"
+msgstr ""
 
 #. qb52L
 #: 05120000.xhp
@@ -45224,22 +45224,22 @@ msgctxt ""
 msgid "Applies a cell style on the cell or cell range controlled by the condition set in the drop down list. The formatting is applied to each cell individually and the condition may depend on other cells values of the selected range."
 msgstr ""
 
-#. fkuaH
+#. fUCE7
 #: 05120100.xhp
 msgctxt ""
 "05120100.xhp\n"
-"par_id181662913907279\n"
+"hd_id951665406076405\n"
 "help.text"
-msgid "Condition"
+msgid "Conditions for Text and Numbers"
 msgstr ""
 
-#. gJBMQ
+#. fkuaH
 #: 05120100.xhp
 msgctxt ""
 "05120100.xhp\n"
-"par_id221663406419144\n"
+"par_id181662913907279\n"
 "help.text"
-msgid "Applies on"
+msgid "Condition"
 msgstr ""
 
 #. Yd3xQ
@@ -45260,40 +45260,148 @@ msgctxt ""
 msgid "is equal to"
 msgstr ""
 
-#. rWJoB
+#. bYfTW
 #: 05120100.xhp
 msgctxt ""
 "05120100.xhp\n"
-"par_id321663406539530\n"
+"par_id881662913907284\n"
 "help.text"
-msgid "<variable id=\"numbertext\">Numbers and text</variable>"
+msgid "The cell value equals the user defined value in text box in the right. Use text inside quotes if you compare text values."
 msgstr ""
 
-#. bYfTW
+#. Pbje6
 #: 05120100.xhp
 msgctxt ""
 "05120100.xhp\n"
-"par_id881662913907284\n"
+"par_id831662914760085\n"
 "help.text"
-msgid "The cell value equals the user defined value in text box in the right. Use text inside quotes if you compare text values."
+msgid "is not equal to"
 msgstr ""
 
-#. ziYCE
+#. T8x2N
 #: 05120100.xhp
 msgctxt ""
 "05120100.xhp\n"
-"par_id271662914239763\n"
+"par_id301662914760087\n"
 "help.text"
-msgid "is less than"
+msgid "The cell value is not equal (different) to the user defined value in the text box in the right. Use text inside quotes if you compare text values."
+msgstr ""
+
+#. uEArp
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id151662920861587\n"
+"help.text"
+msgid "begins with"
 msgstr ""
 
-#. bS8eG
+#. SrP9B
 #: 05120100.xhp
 msgctxt ""
 "05120100.xhp\n"
-"par_id121663406585137\n"
+"par_id341662920861588\n"
 "help.text"
-msgid "<variable id=\"numbers\">Numbers</variable>"
+msgid "The cell contents begins with the text or number defined in the text box on the right."
+msgstr ""
+
+#. v76zE
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id361662922600585\n"
+"help.text"
+msgid "ends with"
+msgstr ""
+
+#. Ag7VY
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id801662922600586\n"
+"help.text"
+msgid "The cell contents ends with the text or number defined in the right text box."
+msgstr ""
+
+#. kDJVK
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id151662922939292\n"
+"help.text"
+msgid "contains"
+msgstr ""
+
+#. b4MWb
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id251662922939293\n"
+"help.text"
+msgid "The cell contents contains the text or number defined in the right text box."
+msgstr ""
+
+#. ugaZe
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id291662923021542\n"
+"help.text"
+msgid "does not contain"
+msgstr ""
+
+#. CyQm8
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id541662923021543\n"
+"help.text"
+msgid "The cell contents does not contains the text or number defined in the text box on the right."
+msgstr ""
+
+#. yF6EV
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id801662922586796\n"
+"help.text"
+msgid "<variable id=\"text_comparison\">The condition applies to the internal text conversion of the cell contents. Numeric values are compared with their equivalent text representation. Numeric cell formats (currency, scientific, user-defined ... ) are not considered for comparisons.</variable>"
+msgstr ""
+
+#. YGARy
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"hd_id111665406111372\n"
+"help.text"
+msgid "Conditions on Numbers only"
+msgstr ""
+
+#. kszJm
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id991665406132471\n"
+"help.text"
+msgid "Condition"
+msgstr ""
+
+#. EeCxc
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id191665406132471\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. ziYCE
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id271662914239763\n"
+"help.text"
+msgid "is less than"
 msgstr ""
 
 #. BdnvW
@@ -45359,24 +45467,6 @@ msgctxt ""
 msgid "The cell value is greater than or equal to the user defined value in the text box in the right."
 msgstr ""
 
-#. Pbje6
-#: 05120100.xhp
-msgctxt ""
-"05120100.xhp\n"
-"par_id831662914760085\n"
-"help.text"
-msgid "is not equal to"
-msgstr ""
-
-#. T8x2N
-#: 05120100.xhp
-msgctxt ""
-"05120100.xhp\n"
-"par_id301662914760087\n"
-"help.text"
-msgid "The cell value is not equal (different) to the user defined value in the text box in the right. Use text inside quotes if you compare text values."
-msgstr ""
-
 #. B6eGh
 #: 05120100.xhp
 msgctxt ""
@@ -45539,6 +45629,15 @@ msgctxt ""
 msgid "The cell value is strictly greater than the average of the cell range values."
 msgstr ""
 
+#. tByUr
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id701665407334603\n"
+"help.text"
+msgid "<variable id=\"seenotebelow\">See note below.</variable>"
+msgstr ""
+
 #. AAKPP
 #: 05120100.xhp
 msgctxt ""
@@ -45593,130 +45692,85 @@ msgctxt ""
 msgid "The cell value is less or equal than the average of the cell range values."
 msgstr ""
 
-#. vFFDn
-#: 05120100.xhp
-msgctxt ""
-"05120100.xhp\n"
-"par_id451662919849856\n"
-"help.text"
-msgid "is error"
-msgstr ""
-
-#. d8WFb
+#. R6uQc
 #: 05120100.xhp
 msgctxt ""
 "05120100.xhp\n"
-"par_id911662919849857\n"
-"help.text"
-msgid "The cell is in the error condition defined in the text box on the right. <link href=\"text/scalc/05/02140000.xhp\" name=\"calc errors\">List of Calc errors</link>."
-msgstr ""
-
-#. DAG5B
-#: 05120100.xhp
-msgctxt ""
-"05120100.xhp\n"
-"par_id61662920733334\n"
-"help.text"
-msgid "A cell that references another cell with an error condition is not in error itself."
-msgstr ""
-
-#. uUxWk
-#: 05120100.xhp
-msgctxt ""
-"05120100.xhp\n"
-"par_id961662920774180\n"
-"help.text"
-msgid "is not error"
-msgstr ""
-
-#. BzFfB
-#: 05120100.xhp
-msgctxt ""
-"05120100.xhp\n"
-"par_id381662920774181\n"
-"help.text"
-msgid "The cell is not in the error condition defined in the text box on the right. <link href=\"text/scalc/05/02140000.xhp\" name=\"calc errors\">List of Calc errors</link>"
-msgstr ""
-
-#. uEArp
-#: 05120100.xhp
-msgctxt ""
-"05120100.xhp\n"
-"par_id151662920861587\n"
+"hd_id301665406258582\n"
 "help.text"
-msgid "begins with"
+msgid "Conditions on Errors in Cells."
 msgstr ""
 
-#. SrP9B
+#. PBCMe
 #: 05120100.xhp
 msgctxt ""
 "05120100.xhp\n"
-"par_id341662920861588\n"
+"par_id451665406273943\n"
 "help.text"
-msgid "The cell contents begins with the text or number defined in the text box on the right."
+msgid "Condition"
 msgstr ""
 
-#. yF6EV
+#. 3BdfG
 #: 05120100.xhp
 msgctxt ""
 "05120100.xhp\n"
-"par_id801662922586796\n"
+"par_id71665406273943\n"
 "help.text"
-msgid "<variable id=\"text_comparison\">The condition applies to the internal text conversion of the cell contents. Numeric values are compared with their equivalent text representation. Numeric cell formats (currency, scientific, user-defined ... ) are not considered for comparisons.</variable>"
+msgid "Description"
 msgstr ""
 
-#. v76zE
+#. vFFDn
 #: 05120100.xhp
 msgctxt ""
 "05120100.xhp\n"
-"par_id361662922600585\n"
+"par_id451662919849856\n"
 "help.text"
-msgid "ends with"
+msgid "is error"
 msgstr ""
 
-#. Ag7VY
+#. Fz7Fr
 #: 05120100.xhp
 msgctxt ""
 "05120100.xhp\n"
-"par_id801662922600586\n"
+"par_id911662919849857\n"
 "help.text"
-msgid "The cell contents ends with the text or number defined in the right text box."
+msgid "The cell is in the error condition defined in the text box on the right. See <link href=\"text/scalc/05/02140000.xhp\" name=\"calc errors\">List of Calc errors</link>."
 msgstr ""
 
-#. kDJVK
+#. uUxWk
 #: 05120100.xhp
 msgctxt ""
 "05120100.xhp\n"
-"par_id151662922939292\n"
+"par_id961662920774180\n"
 "help.text"
-msgid "contains"
+msgid "is not error"
 msgstr ""
 
-#. b4MWb
+#. B6us3
 #: 05120100.xhp
 msgctxt ""
 "05120100.xhp\n"
-"par_id251662922939293\n"
+"par_id381662920774181\n"
 "help.text"
-msgid "The cell contents contains the text or number defined in the right text box."
+msgid "The cell is not in the error condition defined in the text box on the right. See <link href=\"text/scalc/05/02140000.xhp\" name=\"calc errors\">List of Calc errors</link>"
 msgstr ""
 
-#. ugaZe
+#. DAG5B
 #: 05120100.xhp
 msgctxt ""
 "05120100.xhp\n"
-"par_id291662923021542\n"
+"par_id61662920733334\n"
 "help.text"
-msgid "does not contain"
+msgid "A cell that references another cell with an error condition is not in error itself."
 msgstr ""
 
-#. CyQm8
+#. 9ycFs
 #: 05120100.xhp
 msgctxt ""
 "05120100.xhp\n"
-"par_id541662923021543\n"
+"par_id471665407993996\n"
 "help.text"
-msgid "The cell contents does not contains the text or number defined in the text box on the right."
+msgid "<embedvar href=\"text/scalc/01/05120000.xhp#ConditionalFormattingh1\" markup=\"ignore\"/>"
 msgstr ""
 
 #. 4zHYR
@@ -45764,6 +45818,15 @@ msgctxt ""
 msgid "For example, if C29 has a conditional formatting which formula is <input>B1>=(DATE(2015;5;4)+TIME(18;0;0))</input> - a logical expression that evaluates true or false - the style applied to C29 depends on B1 contents."
 msgstr ""
 
+#. PydFB
+#: 05120200.xhp
+msgctxt ""
+"05120200.xhp\n"
+"par_id471665407993996\n"
+"help.text"
+msgid "<embedvar href=\"text/scalc/01/05120000.xhp#ConditionalFormattingh1\" markup=\"ignore\"/>"
+msgstr ""
+
 #. PJRcV
 #: 05120300.xhp
 msgctxt ""
@@ -45854,6 +45917,15 @@ msgctxt ""
 msgid "<emph>This year, Last year and Next year</emph>: applies the cell style if the cell date contents is in this year, last year and next year respectively."
 msgstr ""
 
+#. jqWLy
+#: 05120300.xhp
+msgctxt ""
+"05120300.xhp\n"
+"par_id471665407993996\n"
+"help.text"
+msgid "<embedvar href=\"text/scalc/01/05120000.xhp#ConditionalFormattingh1\" markup=\"ignore\"/>"
+msgstr ""
+
 #. ZANZR
 #: 05120400.xhp
 msgctxt ""
@@ -46448,6 +46520,15 @@ msgctxt ""
 msgid "Conditions to set the thresholds for each icon can be specified as follows"
 msgstr ""
 
+#. qxbFT
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"par_id471665407993996\n"
+"help.text"
+msgid "<embedvar href=\"text/scalc/01/05120000.xhp#ConditionalFormattingh1\" markup=\"ignore\"/>"
+msgstr ""
+
 #. DdaUm
 #: 05120400.xhp
 msgctxt ""
@@ -46520,6 +46601,15 @@ msgctxt ""
 msgid "If you have defined a conditional formatting on a cell range and you try now to define a new conditional formatting on a part of this range, a warning message will be displayed, asking if you want to edit the existing conditional formatting (on the whole range) or define a new conditional formatting overlapping it (on the selected range)."
 msgstr ""
 
+#. MpYLG
+#: 05120500.xhp
+msgctxt ""
+"05120500.xhp\n"
+"par_id471665407993996\n"
+"help.text"
+msgid "<embedvar href=\"text/scalc/01/05120000.xhp#ConditionalFormattingh1\" markup=\"ignore\"/>"
+msgstr ""
+
 #. GXZBY
 #: 06020000.xhp
 msgctxt ""
@@ -69182,14 +69272,14 @@ msgctxt ""
 msgid "<variable id=\"DEPSEvolutionaryalgorithmh2\"><link href=\"text/scalc/01/solver_options_algo.xhp#DEPSEvolutionaryalgorithmh2\" name=\"DEPS Evolutionary algorithm\">DEPS Evolutionary Algorithm</link></variable>"
 msgstr "<variable id=\"DEPSEvolutionaryalgorithmh2\"><link href=\"text/scalc/01/solver_options_algo.xhp#DEPSEvolutionaryalgorithmh2\" name=\"DEPS Evolutionary algorithm\">Еволюционен алгоритъм DEPS</link></variable>"
 
-#. xBZfN
+#. nebDs
 #: solver_options_algo.xhp
 msgctxt ""
 "solver_options_algo.xhp\n"
 "par_id931590164412542\n"
 "help.text"
-msgid "DEPS consists of two independent algorithms: Differential Evolution and Particle Swarm Optimization. Both are especially suited for numerical problems, such as nonlinear optimization, and are complementary to each other in that they even out their others shortcomings."
-msgstr "DEPS се състои от два независими алгоритъма: диференциална еволюция (Differential Evolution) и оптимизация с рояк от частици (Particle Swarm Optimization). И двата са особено подходящи за числови задачи, например нелинейно оптимиране, и се допълват един друг, като взаимно компенсират недостатъците си."
+msgid "DEPS consists of two independent algorithms: Differential Evolution and Particle Swarm Optimization. Both are especially suited for numerical problems, such as nonlinear optimization, and are complementary to each other in that they even out each other’s shortcomings."
+msgstr ""
 
 #. EFbzc
 #: solver_options_algo.xhp
@@ -69776,14 +69866,14 @@ msgctxt ""
 msgid "Sparklines are defined for one cell, but multiple sparklines can be joined together into a group. The group shares the same properties for rendering the sparkline. The unique data that is defined only for one sparkline is the data range, that a sparkline will use for rendering."
 msgstr "Блещукащите линии се дефинират за по една клетка, но могат да бъдат обединени в група. Групата споделя еднакви настройки за изобразяване. Уникалните данни, дефинирани поотделно за всяка блещукаща линия, са диапазоните с данни, използвани за изобразяването."
 
-#. 5FwvG
+#. cqUKB
 #: sparklines.xhp
 msgctxt ""
 "sparklines.xhp\n"
 "par_id761654173486733\n"
 "help.text"
-msgid "Choose <menuitem>Insert – Sparklines</menuitem>"
-msgstr "Изберете <menuitem>Вмъкване - Блещукащи линии</menuitem>."
+msgid "Choose <menuitem>Insert - Sparkline</menuitem>."
+msgstr ""
 
 #. 6ivXp
 #: sparklines.xhp
@@ -69911,14 +70001,14 @@ msgctxt ""
 msgid "<emph>Display hidden</emph>: check to show all columns or stacks in the range even when the data is in hidden cells. If unchecked, the hidden data is ignored."
 msgstr "<emph>Показване на скритите</emph>: отметнете, за да се покажат всички обикновени или насложени стълбове в диапазона, дори когато данните са в скрити клетки. Ако не е отметнато, скритите данни се игнорират."
 
-#. Y6kWv
+#. 7NZyB
 #: sparklines.xhp
 msgctxt ""
 "sparklines.xhp\n"
 "par_id21654177035348\n"
 "help.text"
-msgid "<emph>Right-to-left</emph>: check to display the sparklines reverse order of the data."
-msgstr "<emph>От дясно наляво</emph>: ако е отметнато, блещукащите линии ще се показват с обратен ред на данните."
+msgid "<emph>Right-to-left</emph>: check to have the sparklines show the data in reverse order."
+msgstr ""
 
 #. FhUrj
 #: sparklines.xhp