update translations for master

and force-fix errors using pocheck

Change-Id: I5ee0866633d20e924f2a3a885ae04419b4f4a125

4 files changed, 723 insertions, 597 deletions

diff --git a/source/bn-IN/helpcontent2/source/text/scalc/00.po b/source/bn-IN/helpcontent2/source/text/scalc/00.po
index b2023d267b6..055e8d2b392 100644
--- a/source/bn-IN/helpcontent2/source/text/scalc/00.po
+++ b/source/bn-IN/helpcontent2/source/text/scalc/00.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2021-09-27 19:09+0200\n"
+"POT-Creation-Date: 2022-01-31 18:19+0100\n"
 "PO-Revision-Date: 2018-11-14 11:52+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -286,6 +286,15 @@ msgctxt ""
 msgid "<variable id=\"seumvo\">Choose <emph>View - Page Break</emph>.</variable>"
 msgstr ""
 
+#. YeaFw
+#: 00000403.xhp
+msgctxt ""
+"00000403.xhp\n"
+"par_id3155383\n"
+"help.text"
+msgid "<variable id=\"functionlist\">Choose <menuitem>View - Function List</menuitem>.</variable>"
+msgstr ""
+
 #. yDXA6
 #: 00000404.xhp
 msgctxt ""
@@ -583,15 +592,6 @@ msgctxt ""
 msgid "<variable id=\"addinana\"><emph>Insert - Function</emph> - Category <emph>Add-In</emph></variable>"
 msgstr "<variable id=\"addinana\"><emph>সন্নিবেশ - ফাংশন</emph> - শ্রেণী <emph>অ্যাড-ইন</emph></variable>"
 
-#. g8EoH
-#: 00000404.xhp
-msgctxt ""
-"00000404.xhp\n"
-"par_id3155383\n"
-"help.text"
-msgid "<variable id=\"funktionsliste\">Choose <menuitem>Insert - Function List</menuitem>.</variable>"
-msgstr ""
-
 #. UQGrR
 #: 00000404.xhp
 msgctxt ""
@@ -601,13 +601,13 @@ msgctxt ""
 msgid "<variable id=\"einamen\">Choose <menuitem>Insert - Named Range or Expression</menuitem>.</variable>"
 msgstr ""
 
-#. VLxrw
+#. mQLYV
 #: 00000404.xhp
 msgctxt ""
 "00000404.xhp\n"
 "par_id3146776\n"
 "help.text"
-msgid "<variable id=\"eiextdata\">Choose <menuitem>Sheet - Link to External Data</menuitem>.</variable>"
+msgid "<variable id=\"eiextdata\">Choose <menuitem>Sheet - External Links</menuitem>.</variable>"
 msgstr ""
 
 #. ECgNS
diff --git a/source/bn-IN/helpcontent2/source/text/scalc/01.po b/source/bn-IN/helpcontent2/source/text/scalc/01.po
index 256d2d0c656..fab2f1d0c32 100644
--- a/source/bn-IN/helpcontent2/source/text/scalc/01.po
+++ b/source/bn-IN/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-12-31 12:36+0000\n"
 "Last-Translator: serval2412 <serval2412@yahoo.fr>\n"
 "Language-Team: Bengali (India) <https://translations.documentfoundation.org/projects/libo_help-master/textscalc01/bn_IN/>\n"
@@ -8278,13 +8278,13 @@ msgctxt ""
 msgid "Always \"Windows (32-bit) NT 5.01\", for compatibility reasons"
 msgstr "উপযুক্ততার কারণে, সর্বদা \"Windows (32-bit) NT 5.01\""
 
-#. 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>mathematical functions</bookmark_value><bookmark_value>Function Wizard; mathematical</bookmark_value><bookmark_value>functions; mathematical functions</bookmark_value><bookmark_value>trigonometric functions</bookmark_value>"
 
-#. 9umC6
+#. BJjDo
 #: 04060106.xhp
 msgctxt ""
 "04060106.xhp\n"
 "hd_id3147124\n"
 "help.text"
-msgid "Mathematical Functions"
-msgstr "গাণিতিক ফাংশন"
+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\">=COMBINA(3;2)</item> ৬ প্রদান করে।"
 
-#. 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>TRUNC function</bookmark_value><bookmark_value>decimal places;cutting off</bookmark_value>"
-
-#. mD8uc
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id3156086\n"
-"help.text"
-msgid "TRUNC"
-msgstr "TRUNC"
-
-#. 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\">দশমিক স্থান অপসারণ করার মাধ্যমে একটি সংখ্যা ছোট করা হয়।</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 "সর্বোচ্চ <emph>Count</emph> দশমিক স্থান সহ <emph>Number</emph> প্রদান করে। চিহ্ন বিবেচনা না করে, অতিরিক্ত দশমিক স্থান পুরোপুরি অপসারণ করা হয়।"
-
-#. 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 "<item type=\"literal\">TRUNC(Number; 0)</item> ধ্বনাত্মক সংখ্যার জন্য <item type=\"literal\">INT(Number)</item> হিসেবে আচরণ করে থাকে, কিন্তু ঋনাত্মক সংখ্যাকে কার্যকরভাবে পূর্ণসংখ্যা করে মান শূন্য করা হয়।"
-
-#. 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 ""
-
-#. 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 "<item type=\"input\">=TRUNC(1.239;2)</item>, -১.২৩ প্রদান করে। ৯ হারিয়ে গিয়েছে।"
-
-#. 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 "<item type=\"input\">=TRUNC(-1.234999;3)</item>, -১.২৩৪ প্রদান করে। সকল ৯ হারিয়ে গিয়েছে।"
-
-#. 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\">=ROUND(987.65;-2)</item> ১০০০ প্রদান করে।"
 
-#. igSF4
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id3145991\n"
-"help.text"
-msgid "<bookmark_value>ROUNDDOWN function</bookmark_value>"
-msgstr "<bookmark_value>ROUNDDOWN function</bookmark_value>"
-
-#. pGdu6
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id3145991\n"
-"help.text"
-msgid "ROUNDDOWN"
-msgstr "ROUNDDOWN"
-
-#. 8CrTA
+#. 6qDk5
 #: 04060106.xhp
 msgctxt ""
 "04060106.xhp\n"
-"par_id3146020\n"
+"hd_id561641930400105\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\">একটি সংখ্যাকে দশমিকের পরে একটি নির্দিষ্ট ঘর পর্যন্ত, শূন্য মান হতে ছোট মানের পূর্ণসংখ্যায় রূপান্তর করা হয়।</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 "দশমিক স্থান পর্যন্ত <emph>হিসাব</emph> করার জন্য একটি পূর্ণসংখ্যায় (শূন্যের কাছাকাছি) রূপান্তরিত <emph>সংখ্যা</emph> প্রদান করে থাকে। যদি সংখ্যাটি বাদ দেওয়া হয় অথবা শূন্য হয়, তাহলে ফাংশনটি ব্যবহার করে তুলনামুলক ছোট পূর্ণসংখ্যা ইনটিজারে রূপান্তর করা যায়। যদি সংখ্যাটি ঋনাত্মক হয়, তাহলে ফাংশনটি ব্যবহার করে পরবর্তী ১০, ১০০, ১০০০ ইত্যাদি পূর্ণসংখ্যায় রূপান্তর করা যায়।"
-
-#. 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 "এই ফাংশনটি পূর্ণসংখ্যা শূন্যতে পরিবর্তন করে থাকে। বিকল্প হিসেবে ROUNDUP এবং ROUND দেখুন।"
-
-#. 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\">=ROUNDDOWN(1.234;2)</item> ১.২৩ প্রদান করে।"
-
-#. 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\">=ROUNDDOWN(45.67;0)</item> ৪৫ প্রদান করে।"
-
-#. 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\">=ROUNDDOWN(-45.67)</item> -৪৫ প্রদান করে।"
-
-#. 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\">=ROUNDDOWN(987.65;-2)</item> ৯০০ প্রদান করে।"
-
 #. HBbDL
 #: 04060106.xhp
 msgctxt ""
@@ -19789,14 +19618,14 @@ 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\">আপনি যখন HYPERLINK ফাংশন রয়েছে এমন একটি ঘরে ক্লিক করেন, হাইপারলিংক খোলে যায়।</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."
-msgstr "আপনি যদি এচ্ছিক প্যারামিটার <emph>CellText</emph> ব্যবহার করেন, সূত্রটি URL নির্দেশ করে থাকে, এবং তারপর পাঠ্য অথবা সংখ্যা প্রদর্শন করে থাকে।"
+msgid "If you use the optional <emph>CellValue</emph> parameter, the formula locates the URL, and then displays the text or number."
+msgstr ""
 
 #. 7DGBz
 #: 04060109.xhp
@@ -19807,23 +19636,23 @@ 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 "কীবোর্ড দিয়ে হাইপারলিংক যুক্ত ঘর খুলতে, ঘর নির্বাচন করুন, সম্পাদনা মোডে সন্নিবেশ করার জন্য F2 চাপুন, হাইপারলিংকের সামনে কার্সারটি নিয়ে যান, Shift+F10 চাপুন, এবং তারপর <emph>হাইপারলিংক খোলা হবে</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."
-msgstr "<emph>URL</emph> লিঙ্ক লক্ষ্য উল্লেখ করে থাকে। ঐচ্ছিক <emph>CellText</emph> প্যারামিটারটি হলো একটি পাঠ্য অথবা সংখ্যা যা ঘরে প্রদর্শিত হয় এবং ফলাফল হিসেবে প্রদান করে থাকে। যদি <emph>CellText</emph> প্যারামিটারটি উল্লেখ করা না হয়, তাহলে <emph>URL</emph> টি একটি ঘরের পাঠ্যে প্রদর্শিত হয় এবং ফলাফল হিসেবে প্রদান হবে।"
+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
 #: 04060109.xhp
@@ -23047,32 +22876,104 @@ msgctxt ""
 msgid "WEEKS(StartDate; EndDate; Type)"
 msgstr "WEEKS(StartDate; EndDate; Type)"
 
-#. DGrw3
+#. uwhoB
 #: 04060111.xhp
 msgctxt ""
 "04060111.xhp\n"
 "par_id3151387\n"
 "help.text"
-msgid "<emph>StartDate</emph> is the first date"
-msgstr "<emph>StartDate</emph> হলো প্রথম তারিখ"
+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"
-msgstr "<emph>EndDate</emph> হলো দ্বিতীয় তারিখ"
+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)."
-msgstr "<emph>Type</emph> পার্থক্যের ধরন গণনা করে। সম্ভাব্য মান হলো ০ (বিরতি) এবং ১ (সপ্তাহের সংখ্যায়)।"
+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
 #: 04060111.xhp
@@ -33154,186 +33055,6 @@ msgctxt ""
 msgid "<emph>DataE</emph> is the range of the expected values."
 msgstr "<emph>DataE</emph> হলো কাঙ্খিত মানের পরিসর।"
 
-#. KmntJ
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3154096\n"
-"help.text"
-msgid "Data_B (observed)"
-msgstr "Data_B (পর্যবেক্ষণকৃত)"
-
-#. ByU5t
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3152948\n"
-"help.text"
-msgid "Data_E (expected)"
-msgstr "Data_E (প্রত্যাশিত)"
-
-#. 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\">১৯৫</item>"
-
-#. ZGbzD
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3149105\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">১৭০</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\">১৫১</item>"
-
-#. RVD5R
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3148987\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">১৭০</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\">১৪৮</item>"
-
-#. FMqUi
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3151128\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">১৭০</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\">১৮৯</item>"
-
-#. MSsKd
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3145304\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">১৭০</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\">১৮৩</item>"
-
-#. 4XAhh
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3150423\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">১৭০</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\">১৫৪</item>"
-
-#. WpLSG
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3153947\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">১৭০</item>"
-
 #. rEABj
 #: 04060181.xhp
 msgctxt ""
@@ -33424,168 +33145,6 @@ msgctxt ""
 msgid "Data_E (expected)"
 msgstr "Data_E (প্রত্যাশিত)"
 
-#. 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\">১৯৫</item>"
-
-#. dToZL
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2949105\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">১৭০</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\">১৫১</item>"
-
-#. DEGVA
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2948987\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">১৭০</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\">১৪৮</item>"
-
-#. Ked6Y
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2951128\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">১৭০</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\">১৮৯</item>"
-
-#. HHXxw
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2945304\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">১৭০</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\">১৮৩</item>"
-
-#. GCF9s
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2950423\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">১৭০</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\">১৫৪</item>"
-
-#. a278z
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id2953947\n"
-"help.text"
-msgid "<item type=\"input\">170</item>"
-msgstr "<item type=\"input\">১৭০</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 "বহিঃস্থ ডাটার লিংক"
+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\">বহিঃস্থ ডাটার লিংক</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 "শর্তযুক্ত বিন্যাস"
 
-#. 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>EASTERSUNDAY function</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 "<item type=\"input\">TODAY()</item> বর্তমান কম্পিউটার ব্যবস্থাপনা তারিখ ফলাফল হিসেবে প্রদান করে।"
 
+#. 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
diff --git a/source/bn-IN/helpcontent2/source/text/scalc/05.po b/source/bn-IN/helpcontent2/source/text/scalc/05.po
index 3d322dab599..b79d916cd18 100644
--- a/source/bn-IN/helpcontent2/source/text/scalc/05.po
+++ b/source/bn-IN/helpcontent2/source/text/scalc/05.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2020-10-27 12:31+0100\n"
+"POT-Creation-Date: 2022-01-31 18:19+0100\n"
 "PO-Revision-Date: 2018-09-03 12:40+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -430,13 +430,13 @@ msgctxt ""
 msgid "519<br/>#VALUE!"
 msgstr ""
 
-#. ESdqW
+#. c9Gyw
 #: 02140000.xhp
 msgctxt ""
 "02140000.xhp\n"
 "par_id3155954\n"
 "help.text"
-msgid "No result (instead of Err:519 cell displays #VALUE!)"
+msgid "No value (instead of Err:519 cell displays #VALUE!)"
 msgstr ""
 
 #. cf6oh
@@ -529,13 +529,13 @@ msgctxt ""
 msgid "524<br/>#REF!"
 msgstr ""
 
-#. ioqDF
+#. aHB3e
 #: 02140000.xhp
 msgctxt ""
 "02140000.xhp\n"
 "par_id3154634\n"
 "help.text"
-msgid "invalid references (instead of Err:524 cell displays #REF!)"
+msgid "Not a valid reference (instead of Err:524 cell displays #REF!)"
 msgstr ""
 
 #. iGGQE
diff --git a/source/bn-IN/helpcontent2/source/text/scalc/guide.po b/source/bn-IN/helpcontent2/source/text/scalc/guide.po
index ae4220bfe80..e6e45d513ba 100644
--- a/source/bn-IN/helpcontent2/source/text/scalc/guide.po
+++ b/source/bn-IN/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: 2021-10-25 12:48+0200\n"
+"POT-Creation-Date: 2022-01-31 18:19+0100\n"
 "PO-Revision-Date: 2018-11-14 11:52+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -1870,14 +1870,14 @@ msgctxt ""
 msgid "Area Selection"
 msgstr "এলাকা নির্বাচন"
 
-#. CB8nY
+#. y55CS
 #: cell_enter.xhp
 msgctxt ""
 "cell_enter.xhp\n"
 "par_id2011780\n"
 "help.text"
-msgid "Use drag-and-drop to select the area where you want to input values. But start dragging from the last cell of the area and release the mouse button when you have selected the first cell. Now you can start to input values. Always press the Tab key to advance to the next cell. You will not leave the selected area."
-msgstr "টেনে এনে ফেলা নির্বাচন করে আপনি যেখান"
+msgid "Select the area where you want to input values. Now you can start to input values from the cursor position in the selected area. Press the <keycode>Tab</keycode> key to advance to the next cell or <keycode>Shift</keycode> + <keycode>Tab</keycode> to move backward. At the edges of the selected area the tab key jumps inside the selected area. You will not leave the selected area."
+msgstr ""
 
 #. HbCtq
 #: cell_enter.xhp
@@ -1888,14 +1888,14 @@ msgctxt ""
 msgid "<image id=\"img_id2811365\" src=\"media/helpimg/area2.png\" width=\"4.8335in\" height=\"1.5937in\"><alt id=\"alt_id2811365\">area selection</alt></image>"
 msgstr "<image id=\"img_id2811365\" src=\"media/helpimg/area2.png\" width=\"4.8335in\" height=\"1.5937in\"><alt id=\"alt_id2811365\">এলাকা নির্বাচন</alt></image>"
 
-#. Lgtau
+#. CCcpp
 #: cell_enter.xhp
 msgctxt ""
 "cell_enter.xhp\n"
 "par_id3232520\n"
 "help.text"
-msgid "Select the area from E7 to B3. Now B3 is waiting for your input. Press Tab to advance to the next cell within the selected area."
-msgstr "E7 হতে B3 পর্যন্ত এলাকা নির্বাচন করুন। এখন B3 আপনার ইনপুটের জন্য অপেক্ষা করছে। নির্বাচিত এলাকায় পরবর্তী ঘরে অগ্রসর হতে Tab চাপুন।"
+msgid "Select the area from B3 to E7. Now B3 is waiting for your input. Press <keycode>Tab</keycode> to advance to the next cell within the selected area."
+msgstr ""
 
 #. pbEDF
 #: cell_enter.xhp
@@ -2635,13 +2635,13 @@ msgctxt ""
 msgid "In a $[officename] Calc document, position the cursor in the cell into which you want to insert the external data."
 msgstr "একটি $[officename] Calc নথিতে, কার্সারটি কক্ষে স্থাপন করুন যেখানে আপনি বহিঃস্থ ডাটা সন্নিবেশ করাতে চান।"
 
-#. HRaaG
+#. 5JKBf
 #: cellreferences_url.xhp
 msgctxt ""
 "cellreferences_url.xhp\n"
 "par_id3145384\n"
 "help.text"
-msgid "Choose <item type=\"menuitem\">Sheet - Link to External Data</item>. The <link href=\"text/scalc/01/04090000.xhp\" name=\"External Data\"><item type=\"menuitem\">External Data</item></link> dialog appears."
+msgid "Choose <item type=\"menuitem\">Sheet - External Links</item>. The <link href=\"text/scalc/01/04090000.xhp\" name=\"External Data\"><item type=\"menuitem\">External Data</item></link> dialog appears."
 msgstr ""
 
 #. EQzxX
@@ -13363,13 +13363,13 @@ msgctxt ""
 msgid "Set the cell cursor at the cell where the new content will be inserted."
 msgstr "কক্ষে ঘর কার্সার নির্ধারণ করুন যেখানে নতুন বিষয়বস্তু সন্নিবেশ করানো হবে।"
 
-#. AFBCH
+#. SCn3P
 #: webquery.xhp
 msgctxt ""
 "webquery.xhp\n"
 "par_id3145750\n"
 "help.text"
-msgid "Choose <emph>Sheet - Link to External Data</emph>. This opens the <link href=\"text/scalc/01/04090000.xhp\">External Data</link> dialog."
+msgid "Choose <emph>Sheet - External Links</emph>. This opens the <link href=\"text/scalc/01/04090000.xhp\">External Data</link> dialog."
 msgstr ""
 
 #. AGj3g