aboutsummaryrefslogtreecommitdiff
path: root/source/id/helpcontent2/source/text/scalc
diff options
context:
space:
mode:
Diffstat (limited to 'source/id/helpcontent2/source/text/scalc')
-rw-r--r--source/id/helpcontent2/source/text/scalc/00.po26
-rw-r--r--source/id/helpcontent2/source/text/scalc/01.po234
-rw-r--r--source/id/helpcontent2/source/text/scalc/05.po8
-rw-r--r--source/id/helpcontent2/source/text/scalc/guide.po32
4 files changed, 195 insertions, 105 deletions
diff --git a/source/id/helpcontent2/source/text/scalc/00.po b/source/id/helpcontent2/source/text/scalc/00.po
index 13e201b4f77..fbb0f4d3707 100644
--- a/source/id/helpcontent2/source/text/scalc/00.po
+++ b/source/id/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: 2020-10-23 13:36+0200\n"
+"POT-Creation-Date: 2020-10-27 12:31+0100\n"
"PO-Revision-Date: 2020-04-18 12:21+0000\n"
"Last-Translator: Andika Triwidada <andika@gmail.com>\n"
"Language-Team: Indonesian <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc00/id/>\n"
@@ -664,14 +664,23 @@ msgctxt ""
msgid "Format Menu"
msgstr "Menu Format"
-#. HP9LA
+#. TmWCz
#: 00000405.xhp
msgctxt ""
"00000405.xhp\n"
"par_id3154685\n"
"help.text"
-msgid "<variable id=\"fozelle\">Choose <emph>Format - Cells</emph>.</variable>"
-msgstr "<variable id=\"fozelle\">Pilih <emph>Format - Sel</emph>.</variable>"
+msgid "Choose <menuitem>Format - Cells</menuitem>."
+msgstr ""
+
+#. DEPHV
+#: 00000405.xhp
+msgctxt ""
+"00000405.xhp\n"
+"par_id61593556839601\n"
+"help.text"
+msgid "Press <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+1</keycode>."
+msgstr ""
#. HR2kd
#: 00000405.xhp
@@ -1936,6 +1945,15 @@ msgctxt ""
msgid "This function is available since %PRODUCTNAME 7.0."
msgstr ""
+#. 3FGD2
+#: avail_release.xhp
+msgctxt ""
+"avail_release.xhp\n"
+"par_id651551401041666\n"
+"help.text"
+msgid "This function is available since %PRODUCTNAME 7.1."
+msgstr ""
+
#. LSPBz
#: sheet_menu.xhp
msgctxt ""
diff --git a/source/id/helpcontent2/source/text/scalc/01.po b/source/id/helpcontent2/source/text/scalc/01.po
index 265a6837670..53bb9a0c511 100644
--- a/source/id/helpcontent2/source/text/scalc/01.po
+++ b/source/id/helpcontent2/source/text/scalc/01.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: libo_help scalc 4.2\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-23 13:36+0200\n"
+"POT-Creation-Date: 2020-10-27 12:31+0100\n"
"PO-Revision-Date: 2020-04-16 16:16+0000\n"
"Last-Translator: Andika Triwidada <andika@gmail.com>\n"
"Language-Team: Indonesian <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc01/id/>\n"
@@ -12590,13 +12590,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_LOG\">Returns the logarithm of a number to the specified base.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_LOG\">Mengembalikan logaritma sebuah bilangan ke basis yang ditentukan.</ahelp>"
-#. ShWCR
+#. uDAq7
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3144732\n"
"help.text"
-msgid "LOG(Number[; Base])"
+msgid "LOG(Number [; Base])"
msgstr ""
#. Eiqiq
@@ -12843,6 +12843,15 @@ msgctxt ""
msgid "<item type=\"literal\">Base^Exponent</item>"
msgstr "<item type=\"literal\">bilangan^pangkat</item>"
+#. dRQh7
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id241599040594931\n"
+"help.text"
+msgid "<literal>=POWER(0,0)</literal> returns 1."
+msgstr ""
+
#. D3Ghv
#: 04060106.xhp
#, fuzzy
@@ -13252,13 +13261,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_RUNDEN\">Rounds a number to a certain number of decimal places.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_RUNDEN\">Membulatkan sebuah bilangan ke sejumlah bilangan tempat desimal tertentu.</ahelp>"
-#. p64i9
+#. kj4B7
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3158182\n"
"help.text"
-msgid "ROUND(Number[; Count])"
+msgid "ROUND(Number [; Count])"
msgstr ""
#. yE5Jb
@@ -13351,13 +13360,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_ABRUNDEN\">Rounds a number down, toward zero, to a certain precision.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_ABRUNDEN\">Membulatkan angka ke bawah, ke nol, ke presisi tertentu.</ahelp>"
-#. uqe8Y
+#. MnKJo
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3146051\n"
"help.text"
-msgid "ROUNDDOWN(Number[; Count])"
+msgid "ROUNDDOWN(Number [; Count])"
msgstr ""
#. EXn4P
@@ -13441,13 +13450,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_AUFRUNDEN\">Rounds a number up, away from zero, to a certain precision.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_AUFRUNDEN\">Membulatkan sebuah bilangan ke atas, jauh dari nol, presisi tertentu.</ahelp>"
-#. smgCC
+#. Gz3SM
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3163328\n"
"help.text"
-msgid "ROUNDUP(Number[; Count])"
+msgid "ROUNDUP(Number [; Count])"
msgstr ""
#. x59Ls
@@ -13918,13 +13927,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_SUMMEWENN\">Adds the cells specified by a given criteria.</ahelp> This function is used to browse a range when you search for a certain value."
msgstr "<ahelp hid=\"HID_FUNC_SUMMEWENN\">Menambahkan sel sel yang ditentukan oleh kriteria yang diberikan.</ahelp>Fungsi ini digunakan untuk menelusuri sebuah rentang ketika anda mencari untuk nilai tertentu."
-#. PcPNo
+#. KsFtX
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3152028\n"
"help.text"
-msgid "SUMIF(Range; Criteria[; SumRange])"
+msgid "SUMIF(Range; Criteria [; SumRange])"
msgstr ""
#. rYzXG
@@ -14440,13 +14449,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_UMRECHNEN\">Converts between old European national currency and to and from Euros.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_UMRECHNEN\">Konversi antara mata uang nasional Eropa lama dan ke dan dari Euro. </ahelp>"
-#. qh8S5
+#. G7CMF
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3143748\n"
"help.text"
-msgid "EUROCONVERT(Value; \"From_currency\"; \"To_currency\"[; full_precision][; triangulation_precision])"
+msgid "EUROCONVERT(Value; \"From_currency\"; \"To_currency\" [; full_precision [; triangulation_precision]])"
msgstr ""
#. 4KJUc
@@ -14548,14 +14557,14 @@ msgctxt ""
msgid "At one time the list of conversion factors included the legacy European currencies and the Euro (see examples below). We suggest using the new function EUROCONVERT for converting these currencies."
msgstr "Pada suatu waktu daftar faktor konversi termasuk mata uang Eropa warisan dan Euro (lihat contoh di bawah). Kami menyarankan menggunakan fungsi baru EUROCONVERT untuk mengonversi mata uang ini."
-#. GhdsH
+#. o7nsC
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id0908200902131191\n"
"help.text"
-msgid "CONVERT_OOO(value;\"text\";\"text\")"
-msgstr "CONVERT_OOO(nilai;\"teks\";\"teks\")"
+msgid "CONVERT_OOO(value; \"text\"; \"text\")"
+msgstr ""
#. egbGd
#: 04060106.xhp
@@ -17232,13 +17241,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_VARIATION\">Calculates the points of an exponential trend in an array.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_VARIATION\">Menghitung titik tren eksponensial dalam susunan.</ahelp>"
-#. 8VMBq
+#. GMVAK
#: 04060107.xhp
msgctxt ""
"04060107.xhp\n"
"par_id3166377\n"
"help.text"
-msgid "GROWTH(DataY [; DataX [; NewDataX [; FunctionType]]])"
+msgid "GROWTH(DataY [; [ DataX ] [; [ NewDataX ] [; FunctionType ] ] ])"
msgstr ""
#. CA3qD
@@ -18987,31 +18996,31 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_WAHL\">Uses an index to return a value from a list of up to 30 values.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_WAHL\">Menggunakan indeks untuk mengembalikan nilai dari daftar hingga 30 nilai.</ahelp>"
-#. r7bDk
+#. V8cAu
#: 04060109.xhp
msgctxt ""
"04060109.xhp\n"
"par_id3155425\n"
"help.text"
-msgid "CHOOSE(Index; Value1 [; Value2 [; ... [; Value254]]])"
+msgid "CHOOSE(Index; Value 1 [; Value 2 [; ... [; Value 30]]])"
msgstr ""
-#. dt8SY
+#. CNK7e
#: 04060109.xhp
msgctxt ""
"04060109.xhp\n"
"par_id3144755\n"
"help.text"
-msgid "<emph>Index</emph> is a reference or number between 1 and 254 indicating which value is to be taken from the list."
-msgstr ""
+msgid "<emph>Index</emph> is a reference or number between 1 and 30 indicating which value is to be taken from the list."
+msgstr "<emph>Index</emph> adalah referensi atau angka antara 1 dan 30 yang menunjukkan nilai mana yang harus diambil dari daftar."
-#. nR3mX
+#. GGWDt
#: 04060109.xhp
msgctxt ""
"04060109.xhp\n"
"par_id3149939\n"
"help.text"
-msgid "<emph>Value1, Value2, ..., Value254</emph> is the list of values entered as a reference to a cell or as individual values."
+msgid "<emph>Value 1, Value 2, ..., Value 30</emph> is the list of values entered as a reference to a cell or as individual values."
msgstr ""
#. s64Du
@@ -27971,13 +27980,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_VDB\">Returns the depreciation of an asset for a specified or partial period using a variable declining balance method.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_VDB\">Mengembalikan penyusutan aset untuk periode tertentu atau parsial menggunakan metode saldo menurun variabel.</ahelp>"
-#. DSd3v
+#. pUVVr
#: 04060118.xhp
msgctxt ""
"04060118.xhp\n"
"par_id3149025\n"
"help.text"
-msgid "VDB(Cost; Salvage; Life; S; End [; Factor [; NoSwitch]])"
+msgid "VDB(Cost; Salvage; Life; Start; End [; Factor [; NoSwitch]])"
msgstr ""
#. zGhDb
@@ -42275,6 +42284,15 @@ msgctxt ""
msgid "Name"
msgstr "Nama"
+#. 3juWm
+#: 04060199.xhp
+msgctxt ""
+"04060199.xhp\n"
+"par_id401599494815994\n"
+"help.text"
+msgid "Example"
+msgstr ""
+
#. PcMRq
#: 04060199.xhp
msgctxt ""
@@ -42500,6 +42518,15 @@ msgctxt ""
msgid "Name"
msgstr "Nama"
+#. CCsqC
+#: 04060199.xhp
+msgctxt ""
+"04060199.xhp\n"
+"par_id201599495083374\n"
+"help.text"
+msgid "Example"
+msgstr ""
+
#. AdNBV
#: 04060199.xhp
msgctxt ""
@@ -42698,6 +42725,15 @@ msgctxt ""
msgid "Name"
msgstr "Nama"
+#. Y4cRR
+#: 04060199.xhp
+msgctxt ""
+"04060199.xhp\n"
+"par_id201599494708332\n"
+"help.text"
+msgid "Example"
+msgstr ""
+
#. s2CGS
#: 04060199.xhp
msgctxt ""
@@ -42779,6 +42815,15 @@ msgctxt ""
msgid "Name"
msgstr "Nama"
+#. tfD9G
+#: 04060199.xhp
+msgctxt ""
+"04060199.xhp\n"
+"par_id521599494740206\n"
+"help.text"
+msgid "Example"
+msgstr ""
+
#. 52L2C
#: 04060199.xhp
msgctxt ""
@@ -43796,24 +43841,6 @@ msgctxt ""
msgid "<variable id=\"zellattributetext\"><ahelp hid=\".uno:FormatCellDialog\">Allows you to specify a variety of formatting options and to apply attributes to the selected cells.</ahelp></variable>"
msgstr "<variable id=\"zellattributetext\"><ahelp hid=\".uno:FormatCellDialog\">Memungkinkan Anda menentukan beragam opsi pemformatan dan menerapkan atribut ke sel yang dipilih.</ahelp></variable>"
-#. C3jH9
-#: 05020000.xhp
-msgctxt ""
-"05020000.xhp\n"
-"hd_id3145785\n"
-"help.text"
-msgid "<link href=\"text/shared/01/05020300.xhp\" name=\"Numbers\">Numbers</link>"
-msgstr "<link href=\"text/shared/01/05020300.xhp\" name=\"Angka\">Angka</link>"
-
-#. ZgrYD
-#: 05020000.xhp
-msgctxt ""
-"05020000.xhp\n"
-"hd_id3146119\n"
-"help.text"
-msgid "<link href=\"text/shared/01/05020100.xhp\" name=\"Font\">Font</link>"
-msgstr "<link href=\"text/shared/01/05020100.xhp\" name=\"Huruf\">Huruf</link>"
-
#. BW9bs
#: 05020600.xhp
msgctxt ""
@@ -44651,6 +44678,15 @@ msgctxt ""
msgid "Page Style"
msgstr "Gaya Halaman"
+#. vEZHA
+#: 05070000.xhp
+msgctxt ""
+"05070000.xhp\n"
+"bm_id651593596384469\n"
+"help.text"
+msgid "<bookmark_value>style;page</bookmark_value><bookmark_value>page;style</bookmark_value><bookmark_value>format;page</bookmark_value><bookmark_value>formatting;page</bookmark_value>"
+msgstr ""
+
#. YjqDi
#: 05070000.xhp
msgctxt ""
@@ -45380,32 +45416,32 @@ msgctxt ""
msgid "<ahelp hid=\".uno:AddPrintArea\">Adds the current selection to the defined print areas.</ahelp>"
msgstr "<ahelp hid=\".uno:AddPrintArea\">Menambahkan pilihan saat ini ke area cetak yang ditentukan.</ahelp>"
-#. fcvcu
+#. U9JPr
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
"tit\n"
"help.text"
-msgid "Styles"
-msgstr "Gaya"
+msgid "Styles in Calc"
+msgstr ""
-#. 3fyBn
+#. rJpRh
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
"bm_id3150447\n"
"help.text"
-msgid "<bookmark_value>Stylist, see Styles window</bookmark_value> <bookmark_value>Styles window</bookmark_value> <bookmark_value>formats; Styles window</bookmark_value> <bookmark_value>formatting; Styles window</bookmark_value> <bookmark_value>paint can for applying styles</bookmark_value>"
-msgstr "<bookmark_value>Corak, lihat Gaya jendela</bookmark_value> <bookmark_value>Gaya jendela</bookmark_value> <bookmark_value>format; Gaya jendela</bookmark_value> <bookmark_value>pemformatan; Gaya jendela</bookmark_value> <bookmark_value>tombol kaleng cat untuk menerapkan gaya</bookmark_value>"
+msgid "<bookmark_value>Stylist, see Styles window</bookmark_value><bookmark_value>Styles window</bookmark_value><bookmark_value>formats; Styles window</bookmark_value><bookmark_value>formatting; Styles window</bookmark_value><bookmark_value>paint can for applying styles</bookmark_value><bookmark_value>styles in spreadsheets</bookmark_value><bookmark_value>styles; in Calc</bookmark_value>"
+msgstr ""
-#. eA3vo
+#. WerNG
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
"hd_id3150447\n"
"help.text"
-msgid "<link href=\"text/scalc/01/05100000.xhp\" name=\"Styles\">Styles</link>"
-msgstr "<link href=\"text/scalc/01/05100000.xhp\" name=\"Styles\">Gaya</link>"
+msgid "<link href=\"text/scalc/01/05100000.xhp\" name=\"Styles\">Styles in Calc</link>"
+msgstr ""
#. bBG57
#: 05100000.xhp
@@ -45452,23 +45488,14 @@ msgctxt ""
msgid "Double-click the style in the Styles window."
msgstr "Klik ganda gaya pada jendela Gaya."
-#. DCJfB
-#: 05100000.xhp
-msgctxt ""
-"05100000.xhp\n"
-"hd_id3153877\n"
-"help.text"
-msgid "Cell Styles"
-msgstr ""
-
-#. DAX9B
+#. SbgEE
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
"par_id3145801\n"
"help.text"
-msgid "<ahelp hid=\".\">Displays the list of the available Cell Styles for <link href=\"text/shared/00/00000005.xhp#formatierung\" name=\"indirect cell formatting\">indirect cell formatting</link>.</ahelp>"
-msgstr "<ahelp hid=\".\">Menampilkan daftar Gaya Sel yang tersedia untuk<link href=\"text/shared/00/00000005.xhp#formatierung\" name=\"indirect cell formatting\">pemformatan sel tidak langsung</link>.</ahelp>"
+msgid "<ahelp hid=\".\">Displays the list of the available Cell Styles.</ahelp>"
+msgstr ""
#. JcMEc
#: 05100000.xhp
@@ -45488,23 +45515,23 @@ msgctxt ""
msgid "Cell Styles"
msgstr "Gaya Sel"
-#. hkDXo
+#. 7FwJf
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
-"hd_id3153963\n"
+"hd_id171593598056580\n"
"help.text"
-msgid "Page Styles"
+msgid "<link href=\"text/scalc/01/05070000.xhp\" name=\"page styles\">Page Styles</link>"
msgstr ""
-#. DxrsL
+#. 4XFww
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
"par_id3147003\n"
"help.text"
-msgid "<ahelp hid=\".\">Displays the Page Styles available for indirect page formatting.</ahelp>"
-msgstr "<ahelp hid=\".\">Menampilkan Gaya Halaman yang tersedia untuk pemformatan halaman tidak langsung.</ahelp>"
+msgid "<ahelp hid=\".\">Displays the Page Styles available.</ahelp>"
+msgstr ""
#. cM9f4
#: 05100000.xhp
@@ -52175,6 +52202,15 @@ msgctxt ""
msgid "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/hierarchy\">Select the hierarchy that you want to use. The pivot table must be based on an external source data that contains data hierarchies.</ahelp>"
msgstr "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/hierarchy\">Pilih hirarki yang ingin Anda gunakan. Tabel pivot harus berdasarkan pada sumber eksternal data yang mengandung hirarki data</ahelp>"
+#. ZjDq9
+#: 12090106.xhp
+msgctxt ""
+"12090106.xhp\n"
+"par_id681598453957935\n"
+"help.text"
+msgid "Calc does not provide multiple hierarchies for a single field and so this option is normally grayed. If you use a pivot table data source extension, that extension could define multiple hierarchies for some fields and then the option could become available. See the documentation supplied with that extension for more details\"."
+msgstr ""
+
#. B9FE5
#: 12090200.xhp
msgctxt ""
@@ -53165,6 +53201,15 @@ msgctxt ""
msgid "This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)"
msgstr "Fungsi ini adalah bagian dari Open Document Format untuk Aplikasi Perkantoran (OpenDocument) Versi 1.2. (ISO/IEC 26300:2-2015)"
+#. BFcB6
+#: ODFF.xhp
+msgctxt ""
+"ODFF.xhp\n"
+"hd_id1000013\n"
+"help.text"
+msgid "This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.3."
+msgstr ""
+
#. SGHPh
#: calculate.xhp
msgctxt ""
@@ -53192,6 +53237,24 @@ msgctxt ""
msgid "<ahelp hid=\".\">Commands to calculate formula cells.</ahelp>"
msgstr "<ahelp hid=\".\">Perintah untuk menghitung sel rumus.</ahelp>"
+#. J8xZD
+#: cell_styles.xhp
+msgctxt ""
+"cell_styles.xhp\n"
+"tit\n"
+"help.text"
+msgid "Cell Styles"
+msgstr ""
+
+#. 8o4Ez
+#: cell_styles.xhp
+msgctxt ""
+"cell_styles.xhp\n"
+"hd_id811593560413206\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/cell_styles.xhp\" name=\"Cell Style\">Cell Styles</link>"
+msgstr ""
+
#. AZNrM
#: common_func.xhp
msgctxt ""
@@ -54542,6 +54605,15 @@ msgctxt ""
msgid "<emph>Reference 1, Reference 2, … ,Reference 255</emph> are references to cells."
msgstr ""
+#. 4BGvn
+#: ful_func.xhp
+msgctxt ""
+"ful_func.xhp\n"
+"par_id1001601332672155\n"
+"help.text"
+msgid "This function is always recalculated whenever a recalculation occurs."
+msgstr ""
+
#. 8DbP2
#: func_aggregate.xhp
msgctxt ""
@@ -55182,15 +55254,6 @@ msgctxt ""
msgid "If a cell in a range of values for calculating the mean is empty or contains text, function AVERAGEIF ignores this cell.<br/>If the whole range is empty, contains only text or all values of the range do not satisfy the condition (or any combination of those), the function returns the #DIV/0! error."
msgstr "Jika sel dalam rentang nilai untuk menghitung rata-rata kosong atau berisi teks, fungsi AVERAGEIF mengabaikan sel ini. <br/>Jika seluruh rentang kosong, hanya berisi teks atau semua nilai rentang tidak memenuhi kondisi ( atau kombinasi dari semuanya), fungsi mengembalikan #DIV/0! kesalahan."
-#. HSE9d
-#: func_averageif.xhp
-msgctxt ""
-"func_averageif.xhp\n"
-"par_id38832436828097\n"
-"help.text"
-msgid "In all calculations below, range for average calculation contains the row #6, but it is ignored, because it contains text."
-msgstr "Dalam semua perhitungan di bawah ini, rentang untuk perhitungan rerata berisi baris #6, tetapi diabaikan, karena berisi teks."
-
#. u7E4B
#: func_averageif.xhp
msgctxt ""
@@ -64381,6 +64444,15 @@ msgctxt ""
msgid "Calculation"
msgstr "Kalkulasi"
+#. Q8ewH
+#: func_yearfrac.xhp
+msgctxt ""
+"func_yearfrac.xhp\n"
+"par_id3154502\n"
+"help.text"
+msgid "0 or missing"
+msgstr ""
+
#. CkPny
#: func_yearfrac.xhp
msgctxt ""
diff --git a/source/id/helpcontent2/source/text/scalc/05.po b/source/id/helpcontent2/source/text/scalc/05.po
index 11f8003a815..cb7d75d7771 100644
--- a/source/id/helpcontent2/source/text/scalc/05.po
+++ b/source/id/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-03-31 10:35+0200\n"
+"POT-Creation-Date: 2020-10-27 12:31+0100\n"
"PO-Revision-Date: 2020-03-29 19:16+0000\n"
"Last-Translator: Andika Triwidada <andika@gmail.com>\n"
"Language-Team: Indonesian <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc05/id/>\n"
@@ -322,14 +322,14 @@ msgctxt ""
msgid "String overflow"
msgstr "String tumpang tindih"
-#. h9Kok
+#. XbagT
#: 02140000.xhp
msgctxt ""
"02140000.xhp\n"
"par_id3145635\n"
"help.text"
-msgid "<emph>Compiler:</emph> an identifier in the formula exceeds 64 KB in size. <emph>Interpreter:</emph> a result of a string operation exceeds 64 KB in size."
-msgstr "<emph>Kompiler:</emph> sebuah pengenal di dalam formula yang melewati ukuran 64 KB. <emph>Interpreter:</emph> merupakan hasil dari operasi string yang melewati ukuran 64 KB."
+msgid "<emph>Compiler:</emph> an identifier in the formula exceeds 64 kB in size. <emph>Interpreter:</emph> a result of a string operation exceeds 64 kB in size."
+msgstr ""
#. E7ohJ
#: 02140000.xhp
diff --git a/source/id/helpcontent2/source/text/scalc/guide.po b/source/id/helpcontent2/source/text/scalc/guide.po
index 49738c91666..35757075fc3 100644
--- a/source/id/helpcontent2/source/text/scalc/guide.po
+++ b/source/id/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: 2020-10-23 13:36+0200\n"
+"POT-Creation-Date: 2020-10-27 12:31+0100\n"
"PO-Revision-Date: 2020-04-02 15:16+0000\n"
"Last-Translator: Andika Triwidada <andika@gmail.com>\n"
"Language-Team: Indonesian <https://weblate.documentfoundation.org/projects/libo_help-master/textscalcguide/id/>\n"
@@ -583,23 +583,23 @@ msgctxt ""
msgid "Defining Background Colors or Background Graphics"
msgstr "Menentukan Warna atau Gambar Latar Belakang"
-#. g2JnS
+#. PE8wQ
#: background.xhp
msgctxt ""
"background.xhp\n"
"bm_id3149346\n"
"help.text"
-msgid "<bookmark_value>spreadsheets; backgrounds</bookmark_value> <bookmark_value>backgrounds;cell ranges</bookmark_value> <bookmark_value>tables; backgrounds</bookmark_value> <bookmark_value>cells; backgrounds</bookmark_value> <bookmark_value>rows, see also cells</bookmark_value> <bookmark_value>columns, see also cells</bookmark_value>"
-msgstr "<bookmark_value>spreadsheet;latar belakang</bookmark_value> <bookmark_value>latar belakang;jarak sel</bookmark_value> <bookmark_value>tabel;latar belakang</bookmark_value> <bookmark_value>sel;latar belakang</bookmark_value> <bookmark_value>baris; lihat juga sel</bookmark_value> <bookmark_value>kolom, lihat juga sel</bookmark_value>"
+msgid "<bookmark_value>spreadsheets; backgrounds</bookmark_value><bookmark_value>backgrounds;cell ranges</bookmark_value><bookmark_value>tables; backgrounds</bookmark_value><bookmark_value>cells; backgrounds</bookmark_value><bookmark_value>rows, see also cells</bookmark_value><bookmark_value>columns, see also cells</bookmark_value>"
+msgstr ""
-#. CqqcG
+#. tMFWU
#: background.xhp
msgctxt ""
"background.xhp\n"
"hd_id3149346\n"
"help.text"
-msgid "<variable id=\"background\"><link href=\"text/scalc/guide/background.xhp\" name=\"Defining Background Colors or Background Graphics\">Defining Background Colors or Background Graphics</link></variable>"
-msgstr "<variable id=\"background\"><link href=\"text/scalc/guide/background.xhp\" name=\"Defining Background Colors or Background Graphics\">Mendefinisikan Warna Latar Belakang atau Latar Belakang Grafis</link></variable>"
+msgid "<variable id=\"background\"><link href=\"text/scalc/guide/background.xhp\" name=\"Defining Background Colors or Background Graphics\">Defining Background Colors or Background Graphics</link> </variable>"
+msgstr ""
#. gwwiM
#: background.xhp
@@ -673,14 +673,14 @@ msgctxt ""
msgid "Select the graphic and click <emph>Open</emph>."
msgstr "Pilih grafis dan klik <emph>Buka</emph>."
-#. SDYSQ
+#. 2BGVn
#: background.xhp
msgctxt ""
"background.xhp\n"
"par_id3153575\n"
"help.text"
-msgid "The graphic is inserted anchored to the current cell. You can move and scale the graphic as you want. In your context menu you can use the <emph>Arrange - To Background</emph> command to place this in the background. To select a graphic that has been placed in the background, use the <switchinline select=\"appl\"><caseinline select=\"CALC\"><link href=\"text/scalc/01/02110000.xhp\" name=\"Navigator\">Navigator</link></caseinline><defaultinline>Navigator</defaultinline></switchinline>."
-msgstr "Grafis disisipkan ke sel saat ini. Anda dapat memindahkan dan menentukan skala grafis yang anda inginkan. Dalam menu konteks anda dapat menggunakan <emph>Atur - Ke Latar Belakang</emph>perintahkan untuk meletakkan itu di Latar Belakang. Untuk memilih grafis yang telah diletakkan di Latar Belakang gunakan <switchinline select=\"appl\"><caseinline select=\"CALC\"><link href=\"text/scalc/01/02110000.xhp\" name=\"Navigator\">Navigasi</link></caseinline><defaultinline>Navigasi</defaultinline></switchinline>"
+msgid "The graphic is inserted anchored to the current cell. You can move and scale the graphic as you want. In your context menu you can use the <menuitem>Arrange - To Background</menuitem> command to place this in the background. To select a graphic that has been placed in the background, use the <link href=\"text/scalc/01/02110000.xhp\" name=\"Navigator\">Navigator</link>."
+msgstr ""
#. vTxFX
#: background.xhp
@@ -691,14 +691,14 @@ msgctxt ""
msgid "<link href=\"text/shared/guide/background.xhp\">Watermarks</link>"
msgstr "<link href=\"text/shared/guide/background.xhp\">Tanda Air</link>"
-#. jQFQC
+#. R8Ctk
#: background.xhp
msgctxt ""
"background.xhp\n"
"par_id3156180\n"
"help.text"
-msgid "<link href=\"text/shared/01/05030600.xhp\" name=\"Background tab page\"><emph>Background</emph> tab page</link>"
-msgstr "<link href=\"text/shared/01/05030600.xhp\" name=\"Background tab page\"><emph>Latar Belakang</emph>Halaman tab</link>"
+msgid "<link href=\"text/shared/01/05210100.xhp\" name=\"Background tab page\"><emph>Background</emph> tab page</link>"
+msgstr ""
#. owozX
#: background.xhp
@@ -5686,14 +5686,14 @@ msgctxt ""
msgid "With \"Values\" you will find the results of the calculations."
msgstr "Dengan \"Nilai-nilai\" anda akan menemukan hasil dari perhitungan."
-#. xQ5ou
+#. FMaXJ
#: finding.xhp
msgctxt ""
"finding.xhp\n"
"par_id3163853\n"
"help.text"
-msgid "Cell contents can be formatted in different ways. For example, a number can be formatted as a currency, to be displayed with a currency symbol. You see the currency symbol in the cell, but you cannot search for it."
-msgstr "Isi sel dapat diformat dengan berbagai cara. Misalnya, angka dapat diformat sebagai mata uang, untuk ditampilkan dengan simbol mata uang. Anda melihat simbol mata uang di dalam sel, tetapi anda tidak bisa mencarinya."
+msgid "Cell contents can be formatted in different ways. For example, a number can be formatted as a currency, to be displayed with a currency symbol. These symbols are included in searches when the Formatted Display search option is activated."
+msgstr ""
#. Z4ABm
#: finding.xhp