update translations for master

and force-fix errors using pocheck

Change-Id: I5ee0866633d20e924f2a3a885ae04419b4f4a125

1 files changed, 690 insertions, 564 deletions

diff --git a/source/eo/helpcontent2/source/text/scalc/01.po b/source/eo/helpcontent2/source/text/scalc/01.po
index 21724d36df4..e9c2732db96 100644
--- a/source/eo/helpcontent2/source/text/scalc/01.po
+++ b/source/eo/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: 2021-12-20 13:20+0100\n"
+"POT-Creation-Date: 2022-01-31 18:19+0100\n"
 "PO-Revision-Date: 2020-08-13 17:35+0000\n"
 "Last-Translator: Donald Rogers <donr2648@clear.net.nz>\n"
 "Language-Team: Esperanto <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc01/eo/>\n"
@@ -8278,13 +8278,13 @@ msgctxt ""
 msgid "Always \"Windows (32-bit) NT 5.01\", for compatibility reasons"
 msgstr "Ĉiam \"Windows (32-bit) NT 5.01\", pro kongruecaj kialoj"
 
-#. WNv2d
+#. cFWJe
 #: 04060104.xhp
 msgctxt ""
 "04060104.xhp\n"
 "par_id9841608\n"
 "help.text"
-msgid "The type of the operating system: <br/>\"AIX\" for Advanced Interactive Executive IBM computer operating systems<br/>\"ANDROID\" for Google mobile operating system<br/>\"DRAGONFLY\" for DragonFly operating system forked from FreeBSD<br/>\"EMSCRIPTEM\" for browser WebAssembly system<br/>\"FREEBSD\", \"OPENBSD\" or \"NETBSD\" for operating systems based on the Berkeley Software Distribution (BSD)<br/>\"HAIKU\" for BeOS compatible operating system<br/>\"iOS\" for Apple mobile operating system <br/>\"LINUX\" for GNU/Linux based operating systems<br/>\"MACOSX\" for Apple Mac OS X<br/>\"SOLARIS\" for Oracle Solaris operating system<br/>\"WNT\" for Microsoft Windows"
+msgid "The type of the operating system: <br/>\"AIX\" for Advanced Interactive Executive IBM computer operating systems<br/>\"ANDROID\" for Google mobile operating system<br/>\"DRAGONFLY\" for DragonFly operating system forked from FreeBSD<br/>\"EMSCRIPTEN\" for browser WebAssembly system<br/>\"FREEBSD\", \"OPENBSD\" or \"NETBSD\" for operating systems based on the Berkeley Software Distribution (BSD)<br/>\"HAIKU\" for BeOS compatible operating system<br/>\"iOS\" for Apple mobile operating system <br/>\"LINUX\" for GNU/Linux based operating systems<br/>\"MACOSX\" for Apple Mac OS X<br/>\"SOLARIS\" for Oracle Solaris operating system<br/>\"WNT\" for Microsoft Windows"
 msgstr ""
 
 #. zcvAx
@@ -10951,14 +10951,14 @@ msgctxt ""
 msgid "<bookmark_value>mathematical functions</bookmark_value>  <bookmark_value>Function Wizard; mathematical</bookmark_value>  <bookmark_value>functions; mathematical functions</bookmark_value>  <bookmark_value>trigonometric functions</bookmark_value>"
 msgstr "<bookmark_value>matematikaj funkcioj</bookmark_value><bookmark_value>Funkcia Asistanto; matematikaj</bookmark_value><bookmark_value>funkcioj; matematikaj funkcioj</bookmark_value><bookmark_value>trigonometriaj funkcioj</bookmark_value>"
 
-#. 9umC6
+#. BJjDo
 #: 04060106.xhp
 msgctxt ""
 "04060106.xhp\n"
 "hd_id3147124\n"
 "help.text"
-msgid "Mathematical Functions"
-msgstr "Matematikaj funkcioj"
+msgid "<variable id=\"math_functions_h1\"><link href=\"text/scalc/01/04060106.xhp\" name=\"math_link\">Mathematical Functions</link></variable>"
+msgstr ""
 
 #. jjDha
 #: 04060106.xhp
@@ -12832,103 +12832,13 @@ msgctxt ""
 msgid "<item type=\"input\">=COMBINA(3;2)</item> returns 6."
 msgstr "<item type=\"input\">=DELTA(1;2)</item> liveras je 0."
 
-#. qUACJ
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id3156086\n"
-"help.text"
-msgid "<bookmark_value>TRUNC function</bookmark_value>  <bookmark_value>decimal places;cutting off</bookmark_value>"
-msgstr "<bookmark_value>TRUNKI-funkcio</bookmark_value><bookmark_value>dekumaj pozicioj;stuci</bookmark_value>"
-
-#. mD8uc
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id3156086\n"
-"help.text"
-msgid "TRUNC"
-msgstr "TRUNKI"
-
-#. svW2j
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3157866\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_KUERZEN\">Truncates a number by removing decimal places.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_KUERZEN\">Stucas nombron forigante dekumajn poziciojn.</ahelp>"
-
-#. MNndx
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3148511\n"
-"help.text"
-msgid "TRUNC(Number[; Count])"
-msgstr ""
-
-#. TXm3Z
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3150796\n"
-"help.text"
-msgid "Returns <emph>Number</emph> with at most <emph>Count</emph> decimal places. Excess decimal places are simply removed, irrespective of sign."
-msgstr ""
-
-#. XA6JV
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3150816\n"
-"help.text"
-msgid "<item type=\"literal\">TRUNC(Number; 0)</item> behaves as <item type=\"literal\">INT(Number)</item> for positive numbers, but effectively rounds towards zero for negative numbers."
-msgstr ""
-
-#. SyxhC
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3148548\n"
-"help.text"
-msgid "The <emph>visible</emph> decimal places of the result are specified in <switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href=\"text/shared/optionen/01060500.xhp\">%PRODUCTNAME Calc - Calculate</link>."
-msgstr "La <emph>videblajn</emph> dekumajn poziciojn de la rezulto oni agordas en <switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME - Preferoj</caseinline><defaultinline>Iloj - Agordaĵoj</defaultinline></switchinline> - <link href=\"text/shared/optionen/01060500.xhp\">%PRODUCTNAME Tabelilo - Kalkuli</link>."
-
-#. grGeQ
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3152569\n"
-"help.text"
-msgid "<item type=\"input\">=TRUNC(1.239;2)</item> returns 1.23. The 9 is lost."
-msgstr ""
-
-#. DJRaY
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id7050080\n"
-"help.text"
-msgid "<item type=\"input\">=TRUNC(-1.234999;3)</item> returns -1.234. All the 9s are lost."
-msgstr ""
-
-#. wGT5E
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id441635243969504\n"
-"help.text"
-msgid "<input>=TRUNC(-45.67)</input> returns -45. The default value for <emph>Count</emph> is 0."
-msgstr ""
-
-#. gMj5a
+#. ABMYW
 #: 04060106.xhp
 msgctxt ""
 "04060106.xhp\n"
-"par_id151635245092041\n"
+"hd_id561641930400206\n"
 "help.text"
-msgid "Refer to the <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TRUNC\" name=\"TRUNC_Wiki\">TRUNC</link> wiki page for more details about this function."
+msgid "<link href=\"text/scalc/01/func_trunc.xhp\" name=\"trunc_link\">TRUNC</link>"
 msgstr ""
 
 #. MQVNf
@@ -13777,96 +13687,15 @@ msgctxt ""
 msgid "<item type=\"input\">=ROUND(987.65;-2)</item> returns 1000."
 msgstr "<item type=\"input\">=BAZ16AL10(64)</item> liveras je 100."
 
-#. igSF4
+#. 6qDk5
 #: 04060106.xhp
 msgctxt ""
 "04060106.xhp\n"
-"bm_id3145991\n"
+"hd_id561641930400105\n"
 "help.text"
-msgid "<bookmark_value>ROUNDDOWN function</bookmark_value>"
-msgstr "<bookmark_value>RONDIGI.MALSUPREN-funkcio</bookmark_value>"
-
-#. pGdu6
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id3145991\n"
-"help.text"
-msgid "ROUNDDOWN"
-msgstr "RONDIGI.MALSUPREN"
-
-#. 8CrTA
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3146020\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_ABRUNDEN\">Rounds a number down, toward zero, to a certain precision.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_ABRUNDEN\">Subrondigas numeron al la antaŭa numero, direkte al  nul, laŭ specifita precizo.</ahelp>"
-
-#. MnKJo
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3146051\n"
-"help.text"
-msgid "ROUNDDOWN(Number [; Count])"
+msgid "<link href=\"text/scalc/01/func_rounddown.xhp\" name=\"rounddown_link\">ROUNDDOWN</link>"
 msgstr ""
 
-#. EXn4P
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3146064\n"
-"help.text"
-msgid "Returns <emph>Number</emph> rounded down (towards zero) to <emph>Count</emph> decimal places. If Count is omitted or zero, the function rounds down to an integer. If Count is negative, the function rounds down to the next 10, 100, 1000, etc."
-msgstr ""
-
-#. nFwPP
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2188787\n"
-"help.text"
-msgid "This function rounds towards zero. See ROUNDUP and ROUND for alternatives."
-msgstr "Ĉi tiu funkcio rondigas direkte al nul. Vidu je RONDIGI.SUPREN kaj RONDIGI por alternativoj."
-
-#. ZpuBm
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3163178\n"
-"help.text"
-msgid "<item type=\"input\">=ROUNDDOWN(1.234;2)</item> returns 1.23."
-msgstr "<item type=\"input\">=PUASON(60;50;1)</item> liveras je 0,93."
-
-#. DGvAw
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id5833307\n"
-"help.text"
-msgid "<item type=\"input\">=ROUNDDOWN(45.67;0)</item> returns 45."
-msgstr "<item type=\"input\">=GESALT(5;1)</item> liveras je 1."
-
-#. H6KYd
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id7726676\n"
-"help.text"
-msgid "<item type=\"input\">=ROUNDDOWN(-45.67)</item> returns -45."
-msgstr "<item type=\"input\">=GESALT(5;1)</item> liveras je 1."
-
-#. hYEdB
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3729361\n"
-"help.text"
-msgid "<item type=\"input\">=ROUNDDOWN(987.65;-2)</item> returns 900."
-msgstr "<item type=\"input\">=BAZ16AL10(64)</item> liveras je 100."
-
 #. HBbDL
 #: 04060106.xhp
 msgctxt ""
@@ -19789,13 +19618,13 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_FUNC_HYPERLINK\">When you click a cell that contains the HYPERLINK function, the hyperlink opens.</ahelp>"
 msgstr "<ahelp hid=\"HID_FUNC_HYPERLINK\">Kiam oni alklakas ĉelon kiu enhavas la funkcion HIPERLIGILO, la hiperligilo malfermiĝas.</ahelp>"
 
-#. 8js8d
+#. ciAoA
 #: 04060109.xhp
 msgctxt ""
 "04060109.xhp\n"
 "par_idN11800\n"
 "help.text"
-msgid "If you use the optional <emph>CellText</emph> parameter, the formula locates the URL, and then displays the text or number."
+msgid "If you use the optional <emph>CellValue</emph> parameter, the formula locates the URL, and then displays the text or number."
 msgstr ""
 
 #. 7DGBz
@@ -19807,22 +19636,22 @@ msgctxt ""
 msgid "To open a hyperlinked cell with the keyboard, select the cell, press F2 to enter the Edit mode, move the cursor in front of the hyperlink, press Shift+F10, and then choose <emph>Open Hyperlink</emph>."
 msgstr "Por malfermi hiperligitan ĉelon per la klavaro, elektu la ĉelon, premu je F2 por komencigi la redaktan reĝimon, movu la kursoron al antaŭ la hiperligilo, premu je SHIFT+F10, kaj tiam elektu je <emph>Malfermi Hiperligilon</emph>."
 
-#. BzM9o
+#. YFNSo
 #: 04060109.xhp
 msgctxt ""
 "04060109.xhp\n"
 "par_idN1180E\n"
 "help.text"
-msgid "HYPERLINK(\"URL\" [; \"CellText\"])"
+msgid "HYPERLINK(\"URL\" [; CellValue])"
 msgstr ""
 
-#. UbAEY
+#. weY4K
 #: 04060109.xhp
 msgctxt ""
 "04060109.xhp\n"
 "par_idN11811\n"
 "help.text"
-msgid "<emph>URL</emph> specifies the link target. The optional <emph>CellText</emph> parameter is the text or a number that is displayed in the cell and will be returned as the result. If the <emph>CellText</emph> parameter is not specified, the <emph>URL</emph> is displayed in the cell text and will be returned as the result."
+msgid "<emph>URL</emph> specifies the link target. The optional <emph>CellValue</emph> parameter is the text or a number that is displayed in the cell and will be returned as the result. If the <emph>CellValue</emph> parameter is not specified, the <emph>URL</emph> is displayed in the cell text and will be returned as the result."
 msgstr ""
 
 #. GdBa8
@@ -23047,31 +22876,103 @@ msgctxt ""
 msgid "WEEKS(StartDate; EndDate; Type)"
 msgstr ""
 
-#. DGrw3
+#. uwhoB
 #: 04060111.xhp
 msgctxt ""
 "04060111.xhp\n"
 "par_id3151387\n"
 "help.text"
-msgid "<emph>StartDate</emph> is the first date"
+msgid "<emph>StartDate</emph> is the start date in the interval."
 msgstr ""
 
-#. VLEPK
+#. AGYKD
 #: 04060111.xhp
 msgctxt ""
 "04060111.xhp\n"
 "par_id3146324\n"
 "help.text"
-msgid "<emph>EndDate</emph> is the second date"
+msgid "<emph>EndDate</emph> is the end date in the interval. The end date must be greater than the start date, or else an error is returned."
 msgstr ""
 
-#. YHupv
+#. PcBbC
 #: 04060111.xhp
 msgctxt ""
 "04060111.xhp\n"
 "par_id3166467\n"
 "help.text"
-msgid "<emph>Type</emph> calculates the type of difference. The possible values are 0 (interval) and 1 (in numbers of weeks)."
+msgid "<emph>Type</emph> specifies the type of difference to be calculated. Possible values are 0 (time interval) or 1 (calendar weeks)."
+msgstr ""
+
+#. QaW6B
+#: 04060111.xhp
+msgctxt ""
+"04060111.xhp\n"
+"par_id81641990941192\n"
+"help.text"
+msgid "If <emph>Type = 0</emph> the function will assume that 7 days is equivalent to one week without considering any specific day to mark the beginning of a week."
+msgstr ""
+
+#. geCV7
+#: 04060111.xhp
+msgctxt ""
+"04060111.xhp\n"
+"par_id31641991010650\n"
+"help.text"
+msgid "If <emph>Type = 1</emph> the function will consider Monday to be the first day of the week. Therefore, except for the start date, each occurrence of a Monday in the interval is counted as an additional week."
+msgstr ""
+
+#. CF4K3
+#: 04060111.xhp
+msgctxt ""
+"04060111.xhp\n"
+"par_id971641990480242\n"
+"help.text"
+msgid "This function considers Monday to be the first day of the week regardless of the current locale settings."
+msgstr ""
+
+#. H2Gpc
+#: 04060111.xhp
+msgctxt ""
+"04060111.xhp\n"
+"par_id671641994821992\n"
+"help.text"
+msgid "In the following examples, dates are passed as strings. However, they can also be stored in separate cells and be passed as references."
+msgstr ""
+
+#. SyEBP
+#: 04060111.xhp
+msgctxt ""
+"04060111.xhp\n"
+"par_id71641991391639\n"
+"help.text"
+msgid "<input>=WEEKS(\"01/12/2022\",\"01/17/2022\",0)</input> returns 0 because <emph>Type</emph> was set to 0 and there are only 5 days in the interval."
+msgstr ""
+
+#. zVfY3
+#: 04060111.xhp
+msgctxt ""
+"04060111.xhp\n"
+"par_id71641991390039\n"
+"help.text"
+msgid "<input>=WEEKS(\"01/12/2022\",\"01/19/2022\",0)</input> returns 1 because <emph>Type</emph> was set to 0 and there are 7 days in the interval."
+msgstr ""
+
+#. rABLZ
+#: 04060111.xhp
+msgctxt ""
+"04060111.xhp\n"
+"par_id71641991391123\n"
+"help.text"
+msgid "<input>=WEEKS(\"01/12/2022\",\"01/17/2022\",1)</input> returns 1 because <emph>Type</emph> was set to 1 and the interval contains a Monday, since 01/12/2022 is a Wednesday and 01/17/2022 is a Monday."
+msgstr ""
+
+#. AxokT
+#: 04060111.xhp
+msgctxt ""
+"04060111.xhp\n"
+"par_id71641991332523\n"
+"help.text"
+msgid "<input>=WEEKS(\"01/10/2022\",\"01/15/2022\",1)</input> returns 0 because <emph>Type</emph> was set to 1 and the interval does not contain any Mondays, except for the start date."
 msgstr ""
 
 #. 94JhK
@@ -33154,186 +33055,6 @@ msgctxt ""
 msgid "<emph>DataE</emph> is the range of the expected values."
 msgstr ""
 
-#. KmntJ
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3154096\n"
-"help.text"
-msgid "Data_B (observed)"
-msgstr "Datumoj_B (observitaj)"
-
-#. ByU5t
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3152948\n"
-"help.text"
-msgid "Data_E (expected)"
-msgstr "Datumoj_E (atendataj)"
-
-#. jFpGp
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3152876\n"
-"help.text"
-msgid "1"
-msgstr ""
-
-#. yVGtC
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3159279\n"
-"help.text"
-msgid "<item type=\"input\">195</item>"
-msgstr "<item type=\"input\">195</item>"
-
-#. ZGbzD
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3149105\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">170</item>"
-
-#. ZiBjZ
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3149922\n"
-"help.text"
-msgid "2"
-msgstr ""
-
-#. zDgpW
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3148621\n"
-"help.text"
-msgid "<item type=\"input\">151</item>"
-msgstr "<item type=\"input\">151</item>"
-
-#. RVD5R
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3148987\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">170</item>"
-
-#. FbArc
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3149417\n"
-"help.text"
-msgid "3"
-msgstr ""
-
-#. BzCPW
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3148661\n"
-"help.text"
-msgid "<item type=\"input\">148</item>"
-msgstr "<item type=\"input\">148</item>"
-
-#. FMqUi
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3151128\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">170</item>"
-
-#. SnMGY
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3148467\n"
-"help.text"
-msgid "4"
-msgstr ""
-
-#. pMLAc
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3149237\n"
-"help.text"
-msgid "<item type=\"input\">189</item>"
-msgstr "<item type=\"input\">189</item>"
-
-#. MSsKd
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3145304\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">170</item>"
-
-#. HztMb
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3149927\n"
-"help.text"
-msgid "5"
-msgstr ""
-
-#. 9cTzf
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3150630\n"
-"help.text"
-msgid "<item type=\"input\">183</item>"
-msgstr "<item type=\"input\">183</item>"
-
-#. 4XAhh
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3150423\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">170</item>"
-
-#. bZFnZ
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3143275\n"
-"help.text"
-msgid "6"
-msgstr ""
-
-#. P6GPe
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3144750\n"
-"help.text"
-msgid "<item type=\"input\">154</item>"
-msgstr "<item type=\"input\">154</item>"
-
-#. WpLSG
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3153947\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">170</item>"
-
 #. rEABj
 #: 04060181.xhp
 msgctxt ""
@@ -33424,168 +33145,6 @@ msgctxt ""
 msgid "Data_E (expected)"
 msgstr "Datumoj_E (atendataj)"
 
-#. M2NhH
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2952876\n"
-"help.text"
-msgid "1"
-msgstr ""
-
-#. mEBPP
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2959279\n"
-"help.text"
-msgid "<item type=\"input\">195</item>"
-msgstr "<item type=\"input\">195</item>"
-
-#. dToZL
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2949105\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">170</item>"
-
-#. EWS97
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2949922\n"
-"help.text"
-msgid "2"
-msgstr ""
-
-#. DWkBk
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2948621\n"
-"help.text"
-msgid "<item type=\"input\">151</item>"
-msgstr "<item type=\"input\">151</item>"
-
-#. DEGVA
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2948987\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">170</item>"
-
-#. Wwt2C
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2949417\n"
-"help.text"
-msgid "3"
-msgstr ""
-
-#. 7qHtk
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2948661\n"
-"help.text"
-msgid "<item type=\"input\">148</item>"
-msgstr "<item type=\"input\">148</item>"
-
-#. Ked6Y
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2951128\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">170</item>"
-
-#. BSjh8
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2948467\n"
-"help.text"
-msgid "4"
-msgstr ""
-
-#. te7qv
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2949237\n"
-"help.text"
-msgid "<item type=\"input\">189</item>"
-msgstr "<item type=\"input\">189</item>"
-
-#. HHXxw
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2945304\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">170</item>"
-
-#. wEAU9
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2949927\n"
-"help.text"
-msgid "5"
-msgstr ""
-
-#. 5PwZu
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2950630\n"
-"help.text"
-msgid "<item type=\"input\">183</item>"
-msgstr "<item type=\"input\">183</item>"
-
-#. GCF9s
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2950423\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">170</item>"
-
-#. 4mWE7
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2943275\n"
-"help.text"
-msgid "6"
-msgstr ""
-
-#. BkDtt
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2944750\n"
-"help.text"
-msgid "<item type=\"input\">154</item>"
-msgstr "<item type=\"input\">154</item>"
-
-#. a278z
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2953947\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">170</item>"
-
 #. CCSNU
 #: 04060181.xhp
 msgctxt ""
@@ -42973,14 +42532,14 @@ msgctxt ""
 msgid "<ahelp hid=\"modules/scalc/ui/functionpanel/insert\">Inserts the selected function into the document.</ahelp>"
 msgstr ""
 
-#. CHa3i
+#. fMNek
 #: 04090000.xhp
 msgctxt ""
 "04090000.xhp\n"
 "tit\n"
 "help.text"
-msgid "Link to External Data"
-msgstr "Ligilo al eksteraj datumoj"
+msgid "External Links"
+msgstr ""
 
 #. Fnwpz
 #: 04090000.xhp
@@ -42991,14 +42550,14 @@ msgctxt ""
 msgid "<ahelp hid=\"modules/scalc/ui/externaldata/browse\" visibility=\"hidden\">Open a file dialog to locate the file containing the data you want to insert.</ahelp>"
 msgstr ""
 
-#. kcfuM
+#. rGHoi
 #: 04090000.xhp
 msgctxt ""
 "04090000.xhp\n"
 "hd_id3145785\n"
 "help.text"
-msgid "<link href=\"text/scalc/01/04090000.xhp\" name=\"External Data\">Link to External Data</link>"
-msgstr "<link href=\"text/scalc/01/04090000.xhp\" name=\"External Data\">Ligilo al eksteraj datumoj</link>"
+msgid "<link href=\"text/scalc/01/04090000.xhp\" name=\"External Data\">External Links</link>"
+msgstr ""
 
 #. SaAut
 #: 04090000.xhp
@@ -45358,22 +44917,31 @@ msgctxt ""
 msgid "Conditional Formatting"
 msgstr "Kondiĉa formatado"
 
-#. wjrDJ
+#. qb52L
 #: 05120000.xhp
 msgctxt ""
 "05120000.xhp\n"
 "par_id3163710\n"
 "help.text"
-msgid "<variable id=\"bedingtetext\"><ahelp hid=\".\">Choose <emph>Conditional Formatting</emph> to define format styles depending on certain conditions.</ahelp></variable> If a style was already assigned to a cell, it remains unchanged. The style entered here is then evaluated. There are several types of conditional formatting that can be used."
+msgid "<variable id=\"bedingtetext\"><ahelp hid=\".\">Use <emph>Conditional Formatting</emph> to define range-based conditions that determine which cell style will be applied to each cell in a given range based on its contents.</ahelp></variable> The cell style corresponding to the first condition that evaluates to <emph>true</emph> is applied. Cell styles applied through Conditional Formatting override cell styles applied manually using the <link href=\"text/scalc/main0202.xhp\" name=\"FormattingBar_link\"><emph>Formatting Bar</emph></link> or the <emph>Styles</emph> sidebar."
 msgstr ""
 
-#. aG8CH
+#. 2GWTv
 #: 05120000.xhp
 msgctxt ""
 "05120000.xhp\n"
 "par_id3163711\n"
 "help.text"
-msgid "You can enter several conditions that query the contents of cell values or formulas. The conditions are evaluated from the first to the last. If the condition 1 matches the condition, the defined style will be used. Otherwise, condition 2 is evaluated, and its defined style is used. If this style does not match, then the next condition is evaluated and so on."
+msgid "You can enter several conditions that query the cell values or results of formulas. The conditions are evaluated from first to the last. If <emph>Condition 1</emph> is true based on the current cell contents, the corresponding cell style is applied. Otherwise, <emph>Condition 2</emph> is evaluated to determine if its corresponding style will be applied. If none of the conditions match cell contents, then no changes are made to the cell format."
+msgstr ""
+
+#. GNdvU
+#: 05120000.xhp
+msgctxt ""
+"05120000.xhp\n"
+"par_id431642031216368\n"
+"help.text"
+msgid "Conditional formats do no overwrite cell styles and direct formatting applied manually. They remain saved as cell properties and are applied when the cell matches no conditions or when you remove all conditional formats."
 msgstr ""
 
 #. AMXCn
@@ -53161,6 +52729,132 @@ msgctxt ""
 msgid "<ahelp hid=\".\">Commands to calculate formula cells.</ahelp>"
 msgstr ""
 
+#. 9AbDs
+#: calculation_accuracy.xhp
+msgctxt ""
+"calculation_accuracy.xhp\n"
+"tit\n"
+"help.text"
+msgid "Calculation Accuracy"
+msgstr ""
+
+#. 8Bv3f
+#: calculation_accuracy.xhp
+msgctxt ""
+"calculation_accuracy.xhp\n"
+"bm_id741642020503366\n"
+"help.text"
+msgid "<bookmark_value>calculation;accuracy</bookmark_value>        <bookmark_value>precision;calculation</bookmark_value>"
+msgstr ""
+
+#. 4gPte
+#: calculation_accuracy.xhp
+msgctxt ""
+"calculation_accuracy.xhp\n"
+"hd_id961642017927878\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/calculation_accuracy.xhp\" name=\"accuracy\">%PRODUCTNAME Calculation Accuracy</link>"
+msgstr ""
+
+#. sW5fH
+#: calculation_accuracy.xhp
+msgctxt ""
+"calculation_accuracy.xhp\n"
+"hd_id941642017968835\n"
+"help.text"
+msgid "Inherent Accuracy Problem"
+msgstr ""
+
+#. hov7p
+#: calculation_accuracy.xhp
+msgctxt ""
+"calculation_accuracy.xhp\n"
+"par_id541642018071800\n"
+"help.text"
+msgid "%PRODUCTNAME  Calc, just like most other spreadsheet software, uses floating-point math capabilities available on hardware. Given that most contemporary hardware uses binary floating-point arithmetic with limited precision defined in <link href=\"https://en.wikipedia.org/wiki/IEEE_754\" name=\"IEEE754\">IEEE 754</link> standard, many decimal numbers - including as simple as 0.1 - cannot be precisely represented in %PRODUCTNAME Calc (which uses 64-bit double-precision numbers internally)."
+msgstr ""
+
+#. YPbto
+#: calculation_accuracy.xhp
+msgctxt ""
+"calculation_accuracy.xhp\n"
+"par_id191642019423811\n"
+"help.text"
+msgid "Calculations with those numbers necessarily <link href=\"https://en.wikipedia.org/wiki/Floating-point_arithmetic#Accuracy_problems\" name=\"wpediaaccuracy\">results in rounding errors</link>, and those accumulate with every calculation."
+msgstr ""
+
+#. dvRFz
+#: calculation_accuracy.xhp
+msgctxt ""
+"calculation_accuracy.xhp\n"
+"par_id221642019437175\n"
+"help.text"
+msgid "This is not a bug, but is expected and currently unavoidable without using complex calculations in software, which would incur inappropriate performance penalties, and thus is out of question. Users need to account for that, and use rounding and comparisons with <link href=\"https://en.wikipedia.org/wiki/Machine_epsilon\" name=\"macnie_epsilon\">machine epsilon (or unit roundoff)</link> as necessary."
+msgstr ""
+
+#. ncGy5
+#: calculation_accuracy.xhp
+msgctxt ""
+"calculation_accuracy.xhp\n"
+"par_id801642019531438\n"
+"help.text"
+msgid "An example with numbers:"
+msgstr ""
+
+#. BpnPy
+#: calculation_accuracy.xhp
+msgctxt ""
+"calculation_accuracy.xhp\n"
+"par_id761642018318896\n"
+"help.text"
+msgid "This will result in -999.129999999997 in A3, instead of expected -999.13 (you might need to increase shown decimal places in cell format to see this)."
+msgstr ""
+
+#. kDcn9
+#: calculation_accuracy.xhp
+msgctxt ""
+"calculation_accuracy.xhp\n"
+"par_id221642020132399\n"
+"help.text"
+msgid "An example with dates and times:"
+msgstr ""
+
+#. aWCYz
+#: calculation_accuracy.xhp
+msgctxt ""
+"calculation_accuracy.xhp\n"
+"par_id801642018326882\n"
+"help.text"
+msgid "Due to the specific of time representation in Calc, this also applies to all calculations involving times. For example, the cells A1 and A2 below show the date and time data as entered (in ISO 8601 format):"
+msgstr ""
+
+#. rcuhc
+#: calculation_accuracy.xhp
+msgctxt ""
+"calculation_accuracy.xhp\n"
+"par_id101643312991679\n"
+"help.text"
+msgid "Cell A3 will show 00:10:00 if the default formatting [HH]:MM:SS is applied to the cell. However, cell A3 will show 00:09:59.999999 instead of expected 00:10:00.000000 if formatted using [HH]:MM:SS.000000 format string. This happens despite only whole numbers of hours and minutes were used, because internally, any time is a fraction of a day, 12:00 (noon) being represented as 0.5."
+msgstr ""
+
+#. EZjhJ
+#: calculation_accuracy.xhp
+msgctxt ""
+"calculation_accuracy.xhp\n"
+"par_id921642020011065\n"
+"help.text"
+msgid "The data in A1 is represented internally as 43934.5125, and in A2 as 43934.5055555555591126903891563 (which is not exact representation of the entered datetime, which would be 43934.505555555555555555...)."
+msgstr ""
+
+#. QY6Ti
+#: calculation_accuracy.xhp
+msgctxt ""
+"calculation_accuracy.xhp\n"
+"par_id801642020017858\n"
+"help.text"
+msgid "Their subtraction results in 0.00694444443287037, a value slightly less than expected 0.00694444444444..., which is 10 minutes."
+msgstr ""
+
 #. J8xZD
 #: cell_styles.xhp
 msgctxt ""
@@ -53215,6 +52909,24 @@ msgctxt ""
 msgid "Examples"
 msgstr ""
 
+#. XAFa7
+#: common_func.xhp
+msgctxt ""
+"common_func.xhp\n"
+"hd_id301640873452726\n"
+"help.text"
+msgid "Technical information"
+msgstr ""
+
+#. 7AVhU
+#: common_func.xhp
+msgctxt ""
+"common_func.xhp\n"
+"par_id251640873774457\n"
+"help.text"
+msgid "This function is not part of the <emph>Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format</emph> standard. The name space is"
+msgstr ""
+
 #. STMGF
 #: common_func.xhp
 msgctxt ""
@@ -54376,22 +54088,22 @@ msgctxt ""
 msgid "<emph>values (mandatory):</emph> A numeric array or range. <emph>values</emph> are the historical values, for which you want to forecast the next points."
 msgstr ""
 
-#. qBdZB
+#. S6DPQ
 #: exponsmooth_embd.xhp
 msgctxt ""
 "exponsmooth_embd.xhp\n"
 "par_id0403201618594553\n"
 "help.text"
-msgid "<emph>timeline (mandatory):</emph> A numeric array or range. The time line (x-value) range for the historical values."
+msgid "<emph>timeline (mandatory):</emph> A numeric array or range. The timeline (x-value) range for the historical values."
 msgstr ""
 
-#. wE7cv
+#. Re7Cm
 #: exponsmooth_embd.xhp
 msgctxt ""
 "exponsmooth_embd.xhp\n"
 "par_id040320161859450\n"
 "help.text"
-msgid "The time line doesn't have to to be sorted, the functions will sort it for calculations. <br/>The time line values must have a consistent step between them. <br/>If a constant step can't be identified in the sorted time line, the functions will return the #NUM! error. <br/>If the ranges of the time line and historical values aren't of same size, the functions will return the #N/A error.<br/>If the time line contains less than 2 periods of data, the functions will return the #VALUE! Error."
+msgid "The timeline does not have to be sorted, the functions will sort it for calculations.<br/>The timeline values must have a consistent step between them.<br/>If a constant step cannot be identified in the sorted timeline, the functions will return the #NUM! error.<br/>If the ranges of both the timeline and the historical values are not the same size, the functions will return the #N/A error.<br/>If the timeline contains fewer than 2 data periods, the functions will return the #VALUE! error."
 msgstr ""
 
 #. AbNWD
@@ -58057,6 +57769,15 @@ msgctxt ""
 msgid "Torr"
 msgstr ""
 
+#. CNDuZ
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id911641306487164\n"
+"help.text"
+msgid "1 - The \"at\" unit is deprecated. Use \"atm\" instead."
+msgstr ""
+
 #. vWzBh
 #: func_convert.xhp
 msgctxt ""
@@ -58606,6 +58327,15 @@ msgctxt ""
 msgid "Cubic yard"
 msgstr ""
 
+#. EsueL
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id671641306535516\n"
+"help.text"
+msgid "2 - These units are not part of the <emph>Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format</emph> standard for the CONVERT function. They are preserved for backward compatibility."
+msgstr ""
+
 #. ej2DE
 #: func_convert.xhp
 msgctxt ""
@@ -59020,13 +58750,13 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_FUNC_DATEDIF\">This function returns the number of whole days, months or years between Start date and End date.</ahelp>"
 msgstr ""
 
-#. hDLZF
+#. zRWUX
 #: func_datedif.xhp
 msgctxt ""
 "func_datedif.xhp\n"
-"par_id3150474\n"
+"par_id531642776283977\n"
 "help.text"
-msgid "DATEDIF(Start date; End date; Interval)"
+msgid "<input>DATEDIF(Start date; End date; Interval)</input>"
 msgstr ""
 
 #. CMjse
@@ -59047,13 +58777,13 @@ msgctxt ""
 msgid "<emph>End date</emph> is the date until the calculation is carried out. End date must be later, than Start date."
 msgstr ""
 
-#. FH5g5
+#. PZGXK
 #: func_datedif.xhp
 msgctxt ""
 "func_datedif.xhp\n"
 "par_id3153183\n"
 "help.text"
-msgid "<emph>Interval</emph> is a string, accepted values are \"d\", \"m\", \"y\", \"ym\", \"md\" or \"yd\"."
+msgid "<emph>Interval</emph> is a string that determines how the difference will be calculated. Possible values are \"d\", \"m\", \"y\", \"ym\", \"md\" or \"yd\" regardless of the current language settings."
 msgstr ""
 
 #. Lxgdp
@@ -60676,13 +60406,13 @@ msgctxt ""
 msgid "<bookmark_value>FORECAST.ETS.MULT function</bookmark_value>"
 msgstr "<bookmark_value>PASKADIMANĈO-funkcio</bookmark_value>"
 
-#. GByS5
+#. LnXao
 #: func_forecastetsmult.xhp
 msgctxt ""
 "func_forecastetsmult.xhp\n"
 "hd_id0603201610022291\n"
 "help.text"
-msgid "<link href=\"text/scalc/01/func_forecastetsmult.xhp\"> FORECAST.ETS.MULT Function</link>"
+msgid "<link href=\"text/scalc/01/func_forecastetsmult.xhp\">FORECAST.ETS.MULT Function</link>"
 msgstr ""
 
 #. tYAjY
@@ -64150,13 +63880,13 @@ msgctxt ""
 msgid "<bookmark_value>rawsubtract;subtraction</bookmark_value>        <bookmark_value>RAWSUBTRACT function</bookmark_value>"
 msgstr ""
 
-#. fYK6C
+#. e3VEx
 #: func_rawsubtract.xhp
 msgctxt ""
 "func_rawsubtract.xhp\n"
 "hd_2016112109231\n"
 "help.text"
-msgid "<link href=\"text/scalc/01/func_rawsubtract.xhp\">RAWSUBTRACT</link>"
+msgid "<variable id=\"rawsubtracth1\"><link href=\"text/scalc/01/func_rawsubtract.xhp\">RAWSUBTRACT</link></variable>"
 msgstr ""
 
 #. CoCx7
@@ -64609,6 +64339,132 @@ msgctxt ""
 msgid "<input>=ROMAN(0)</input> returns \"\" (empty text)."
 msgstr ""
 
+#. aU68a
+#: func_rounddown.xhp
+msgctxt ""
+"func_rounddown.xhp\n"
+"tit\n"
+"help.text"
+msgid "ROUNDDOWN function"
+msgstr ""
+
+#. riRPe
+#: func_rounddown.xhp
+msgctxt ""
+"func_rounddown.xhp\n"
+"bm_id3156384\n"
+"help.text"
+msgid "<bookmark_value>ROUNDDOWN function</bookmark_value>    <bookmark_value>numbers;rounding down</bookmark_value>"
+msgstr ""
+
+#. sroq5
+#: func_rounddown.xhp
+msgctxt ""
+"func_rounddown.xhp\n"
+"hd_id601641846107898\n"
+"help.text"
+msgid "<variable id=\"rounddown_h1\"><link href=\"text/scalc/01/func_rounddown.xhp\" name=\"rounddown_link\">ROUNDDOWN function</link></variable>"
+msgstr ""
+
+#. dFaB6
+#: func_rounddown.xhp
+msgctxt ""
+"func_rounddown.xhp\n"
+"par_id841641927277474\n"
+"help.text"
+msgid "Rounds down a number while keeping a specified number of decimal digits."
+msgstr ""
+
+#. gchGZ
+#: func_rounddown.xhp
+msgctxt ""
+"func_rounddown.xhp\n"
+"par_id701642530512560\n"
+"help.text"
+msgid "This function is equivalent to the <link href=\"text/scalc/01/func_trunc.xhp\" name=\"TRUNC_link\">TRUNC function</link>."
+msgstr ""
+
+#. soLKp
+#: func_rounddown.xhp
+msgctxt ""
+"func_rounddown.xhp\n"
+"par_id341641927560587\n"
+"help.text"
+msgid "<input>ROUNDDOWN(Number [; Count])</input>"
+msgstr ""
+
+#. zMhAG
+#: func_rounddown.xhp
+msgctxt ""
+"func_rounddown.xhp\n"
+"par_id11641927688319\n"
+"help.text"
+msgid "<emph>Number:</emph> The number to be rounded down."
+msgstr ""
+
+#. CkVAE
+#: func_rounddown.xhp
+msgctxt ""
+"func_rounddown.xhp\n"
+"par_id861641927715672\n"
+"help.text"
+msgid "<emph>Count:</emph> Optional parameter that defines the number of decimal places to be kept. The default value is 0 (zero)."
+msgstr ""
+
+#. rJEFs
+#: func_rounddown.xhp
+msgctxt ""
+"func_rounddown.xhp\n"
+"par_id911641928545976\n"
+"help.text"
+msgid "Use negative values for <emph>Count</emph> to round the integer part of the original <emph>Number</emph>. For example, -1 will round down the first integer number before the decimal separator, -2 will round down the two integer numbers before the decimal separator, and so forth."
+msgstr ""
+
+#. WfEbN
+#: func_rounddown.xhp
+msgctxt ""
+"func_rounddown.xhp\n"
+"par_id181641929609906\n"
+"help.text"
+msgid "In %PRODUCTNAME the <emph>Count</emph> parameter is optional whereas in MS Excel this parameter is mandatory. When an ODS file contains a call to ROUNDDOWN without the <emph>Count</emph> parameter and the file is exported to XLS or XLSX formats, the missing argument will automatically be added with value zero to maintain compatibility."
+msgstr ""
+
+#. BCmT8
+#: func_rounddown.xhp
+msgctxt ""
+"func_rounddown.xhp\n"
+"par_id901641928192870\n"
+"help.text"
+msgid "<input>=ROUNDDOWN(21.89)</input> returns 21. Note that this example uses the default value for <emph>Count</emph> which is 0."
+msgstr ""
+
+#. aGJYK
+#: func_rounddown.xhp
+msgctxt ""
+"func_rounddown.xhp\n"
+"par_id901641928192110\n"
+"help.text"
+msgid "<input>=ROUNDDOWN(103.37,1)</input> returns 103.3."
+msgstr ""
+
+#. bzN7A
+#: func_rounddown.xhp
+msgctxt ""
+"func_rounddown.xhp\n"
+"par_id171641928456743\n"
+"help.text"
+msgid "<input>=ROUNDDOWN(0.664,2)</input> returns 0.66."
+msgstr ""
+
+#. e4fx9
+#: func_rounddown.xhp
+msgctxt ""
+"func_rounddown.xhp\n"
+"par_id641641928712287\n"
+"help.text"
+msgid "<input>=ROUNDDOWN(214.2,-1)</input> returns 210. Note the negative value for <emph>Count</emph>, which causes the first integer value before the decimal separator to be rounded towards zero."
+msgstr ""
+
 #. E7heY
 #: func_roundsig.xhp
 msgctxt ""
@@ -64627,13 +64483,13 @@ msgctxt ""
 msgid "<bookmark_value>ROUNDSIG Function</bookmark_value>"
 msgstr ""
 
-#. jcZEL
+#. UCpWh
 #: func_roundsig.xhp
 msgctxt ""
 "func_roundsig.xhp\n"
 "hd_id351519154702177\n"
 "help.text"
-msgid "<link href=\"text/scalc/01/func_roundsig.xhp\" name=\"command name\">ROUNDSIG</link>"
+msgid "<link href=\"text/scalc/01/func_roundsig.xhp\" name=\"function roundsig\">ROUNDSIG</link>"
 msgstr ""
 
 #. jJKBA
@@ -65725,6 +65581,132 @@ msgctxt ""
 msgid "<item type=\"input\">TODAY()</item> returns the current computer system date."
 msgstr ""
 
+#. Y2uYG
+#: func_trunc.xhp
+msgctxt ""
+"func_trunc.xhp\n"
+"tit\n"
+"help.text"
+msgid "TRUNC function"
+msgstr ""
+
+#. UkBEB
+#: func_trunc.xhp
+msgctxt ""
+"func_trunc.xhp\n"
+"bm_id3156384\n"
+"help.text"
+msgid "<bookmark_value>TRUNC function</bookmark_value>    <bookmark_value>decimal places;cutting off</bookmark_value>    <bookmark_value>numbers;truncate</bookmark_value>"
+msgstr ""
+
+#. CQ5Zg
+#: func_trunc.xhp
+msgctxt ""
+"func_trunc.xhp\n"
+"hd_id601641846107898\n"
+"help.text"
+msgid "<variable id=\"trunc_h1\"><link href=\"text/scalc/01/func_trunc.xhp\" name=\"trunc_link\">TRUNC function</link></variable>"
+msgstr ""
+
+#. dkTrh
+#: func_trunc.xhp
+msgctxt ""
+"func_trunc.xhp\n"
+"par_id841641927277474\n"
+"help.text"
+msgid "Truncates a number while keeping a specified number of decimal digits."
+msgstr ""
+
+#. Hxed7
+#: func_trunc.xhp
+msgctxt ""
+"func_trunc.xhp\n"
+"par_id701642530512560\n"
+"help.text"
+msgid "This function is equivalent to the <link href=\"text/scalc/01/func_rounddown.xhp\" name=\"ROUNDDOWN_link\">ROUNDDOWN function</link>."
+msgstr ""
+
+#. oZAWU
+#: func_trunc.xhp
+msgctxt ""
+"func_trunc.xhp\n"
+"par_id321641927458888\n"
+"help.text"
+msgid "The rounding method used by this function is known as <emph>rounding towards zero</emph>. The resulting number will always be smaller than or equal to the original number."
+msgstr ""
+
+#. SqCQv
+#: func_trunc.xhp
+msgctxt ""
+"func_trunc.xhp\n"
+"par_id341641927560587\n"
+"help.text"
+msgid "<input>TRUNC(Number [; Count])</input>"
+msgstr ""
+
+#. RryDW
+#: func_trunc.xhp
+msgctxt ""
+"func_trunc.xhp\n"
+"par_id11641927688319\n"
+"help.text"
+msgid "<emph>Number:</emph> The number to be truncated."
+msgstr ""
+
+#. Hg6mt
+#: func_trunc.xhp
+msgctxt ""
+"func_trunc.xhp\n"
+"par_id861641927715672\n"
+"help.text"
+msgid "<emph>Count:</emph> Optional parameter that defines the number of decimal places to be kept. The default value is 0 (zero)."
+msgstr ""
+
+#. HKrSh
+#: func_trunc.xhp
+msgctxt ""
+"func_trunc.xhp\n"
+"par_id911641928545976\n"
+"help.text"
+msgid "Use negative values for <emph>Count</emph> to round the integer part of the original <emph>Number</emph>. For example, -1 will round down the first integer number before the decimal separator, -2 will round down the two integer numbers before the decimal separator, and so forth."
+msgstr ""
+
+#. EJFZd
+#: func_trunc.xhp
+msgctxt ""
+"func_trunc.xhp\n"
+"par_id901641928192870\n"
+"help.text"
+msgid "<input>=TRUNC(21.89)</input> returns 21. Note that this example uses the default value for <emph>Count</emph> which is 0."
+msgstr ""
+
+#. ccEGa
+#: func_trunc.xhp
+msgctxt ""
+"func_trunc.xhp\n"
+"par_id901641928192110\n"
+"help.text"
+msgid "<input>=TRUNC(103.37,1)</input> returns 103.3."
+msgstr ""
+
+#. jJvgo
+#: func_trunc.xhp
+msgctxt ""
+"func_trunc.xhp\n"
+"par_id171641928456743\n"
+"help.text"
+msgid "<input>=TRUNC(0.664,2)</input> returns 0.66."
+msgstr ""
+
+#. Qf3R9
+#: func_trunc.xhp
+msgctxt ""
+"func_trunc.xhp\n"
+"par_id641641928712287\n"
+"help.text"
+msgid "<input>=TRUNC(214.2,-1)</input> returns 210. Note the negative value for <emph>Count</emph>, which causes the first integer value before the decimal separator to be rounded towards zero."
+msgstr ""
+
 #. w86Dm
 #: func_value.xhp
 msgctxt ""
@@ -67363,13 +67345,157 @@ msgctxt ""
 msgid "<ahelp hid=\".\"><variable id=\"streams_desc\">Create live data streams for spreadsheets.</variable></ahelp>"
 msgstr ""
 
-#. Zsu3z
+#. GmNXG
 #: live_data_stream.xhp
 msgctxt ""
 "live_data_stream.xhp\n"
 "par_id240920171007389295\n"
 "help.text"
-msgid "Menu <menuitem>Data – Streams...</menuitem>"
+msgid "Choose <menuitem>Data – Streams</menuitem>"
+msgstr ""
+
+#. aV8Lc
+#: live_data_stream.xhp
+msgctxt ""
+"live_data_stream.xhp\n"
+"par_id221641995264796\n"
+"help.text"
+msgid "Data streaming is the continuous flow of data generated by various sources. In %PRODUCTNAME Calc, data streams can be processed, stored, analyzed, and acted upon as it's generated in real-time."
+msgstr ""
+
+#. KANFG
+#: live_data_stream.xhp
+msgctxt ""
+"live_data_stream.xhp\n"
+"par_id831641996045238\n"
+"help.text"
+msgid "Some real-life examples of streaming data include use cases in every industry, including real-time stock trades, up-to-the-minute retail inventory management, social media feeds, multiplayer game interactions, and ride-sharing apps."
+msgstr ""
+
+#. sWHpE
+#: live_data_stream.xhp
+msgctxt ""
+"live_data_stream.xhp\n"
+"hd_id791641995257145\n"
+"help.text"
+msgid "Source stream"
+msgstr ""
+
+#. dyVdA
+#: live_data_stream.xhp
+msgctxt ""
+"live_data_stream.xhp\n"
+"hd_id931641998122172\n"
+"help.text"
+msgid "URL"
+msgstr ""
+
+#. oYvgF
+#: live_data_stream.xhp
+msgctxt ""
+"live_data_stream.xhp\n"
+"par_id31641995269740\n"
+"help.text"
+msgid "URL of the source document in the local file system or internet."
+msgstr ""
+
+#. 3Bdbh
+#: live_data_stream.xhp
+msgctxt ""
+"live_data_stream.xhp\n"
+"hd_id811641996480534\n"
+"help.text"
+msgid "Interpret stream data as"
+msgstr ""
+
+#. QpvTc
+#: live_data_stream.xhp
+msgctxt ""
+"live_data_stream.xhp\n"
+"par_id591641996318461\n"
+"help.text"
+msgid "<emph>value1,value2,...,valueN, and fill into range</emph>:"
+msgstr ""
+
+#. iB5Fv
+#: live_data_stream.xhp
+msgctxt ""
+"live_data_stream.xhp\n"
+"par_id441641996322078\n"
+"help.text"
+msgid "<emph>address,value</emph>:"
+msgstr ""
+
+#. JYyrF
+#: live_data_stream.xhp
+msgctxt ""
+"live_data_stream.xhp\n"
+"hd_id241641998151807\n"
+"help.text"
+msgid "Empty lines trigger UI refresh"
+msgstr ""
+
+#. CEui4
+#: live_data_stream.xhp
+msgctxt ""
+"live_data_stream.xhp\n"
+"hd_id341641995330350\n"
+"help.text"
+msgid "When new data arrives"
+msgstr ""
+
+#. snU6R
+#: live_data_stream.xhp
+msgctxt ""
+"live_data_stream.xhp\n"
+"par_id731641995339462\n"
+"help.text"
+msgid "There are three features of this option:"
+msgstr ""
+
+#. GLs5t
+#: live_data_stream.xhp
+msgctxt ""
+"live_data_stream.xhp\n"
+"par_id471641995370002\n"
+"help.text"
+msgid "<emph>Move existing data down</emph>: the existing data is moved down in index and the empty space is filled by arriving data. In short, we deal in fix range of indexes."
+msgstr ""
+
+#. nfgHU
+#: live_data_stream.xhp
+msgctxt ""
+"live_data_stream.xhp\n"
+"par_id841641995386510\n"
+"help.text"
+msgid "<emph>Move the range down</emph>: the arriving data is appended at the end of existing data and range of indexes to be processed is shifted."
+msgstr ""
+
+#. 4zg6F
+#: live_data_stream.xhp
+msgctxt ""
+"live_data_stream.xhp\n"
+"par_id1001641996559358\n"
+"help.text"
+msgid "<emph>Overwrite existing data</emph>: the arriving data overrides the existing data."
+msgstr ""
+
+#. ZHiEZ
+#: live_data_stream.xhp
+msgctxt ""
+"live_data_stream.xhp\n"
+"hd_id121641995404922\n"
+"help.text"
+msgid "Maximal Amount of Rows"
+msgstr ""
+
+#. GTkWu
+#: live_data_stream.xhp
+msgctxt ""
+"live_data_stream.xhp\n"
+"par_id961641995414472\n"
+"help.text"
+msgid "Limit the maximum numbers of rows to a specified value or leave undefined, but limited to the %PRODUCTNAME Calc row limit."
 msgstr ""
 
 #. k7H5Y