aboutsummaryrefslogtreecommitdiff
path: root/source/id/helpcontent2/source/text/scalc/01.po
diff options
context:
space:
mode:
Diffstat (limited to 'source/id/helpcontent2/source/text/scalc/01.po')
-rw-r--r--source/id/helpcontent2/source/text/scalc/01.po1541
1 files changed, 1279 insertions, 262 deletions
diff --git a/source/id/helpcontent2/source/text/scalc/01.po b/source/id/helpcontent2/source/text/scalc/01.po
index f1cce31b27d..2fcf7f69616 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: 2022-07-04 18:04+0200\n"
+"POT-Creation-Date: 2022-10-10 13:35+0200\n"
"PO-Revision-Date: 2022-08-24 10:18+0000\n"
"Last-Translator: serval2412 <serval2412@yahoo.fr>\n"
"Language-Team: Indonesian <https://translations.documentfoundation.org/projects/libo_help-master/textscalc01/id/>\n"
@@ -13,7 +13,7 @@ msgstr ""
"Content-Transfer-Encoding: 8bit\n"
"Plural-Forms: nplurals=2; plural=n>1;\n"
"X-Accelerator-Marker: ~\n"
-"X-Generator: Weblate 4.12.2\n"
+"X-Generator: LibreOffice\n"
"X-POOTLE-MTIME: 1551149512.000000\n"
#. sZfWF
@@ -2842,22 +2842,22 @@ msgctxt ""
msgid "Go to Sheet"
msgstr "Pergi ke Lembar"
-#. W6vyo
+#. 88YoD
#: 02220000.xhp
msgctxt ""
"02220000.xhp\n"
"bm_id781654171314500\n"
"help.text"
-msgid "<bookmark_value>Go to sheet</bookmark_value><bookmark_value>jump; to given sheet</bookmark_value><bookmark_value>sheet; go to directly</bookmark_value><bookmark_value>sheet; search and go to</bookmark_value>"
+msgid "<bookmark_value>Go to sheet</bookmark_value> <bookmark_value>jump; to given sheet</bookmark_value> <bookmark_value>sheet; go to directly</bookmark_value> <bookmark_value>sheet; search and go to</bookmark_value>"
msgstr ""
-#. Af3Da
+#. svg9x
#: 02220000.xhp
msgctxt ""
"02220000.xhp\n"
"hd_id3156025\n"
"help.text"
-msgid "Go to Sheet"
+msgid "<variable id=\"GotoSheeth1\"><link href=\"text/scalc/01/02220000.xhp\" name=\"Go to Sheet\">Go to Sheet</link></variable>"
msgstr ""
#. UmffC
@@ -2869,6 +2869,15 @@ msgctxt ""
msgid "<variable id=\"gototable\"><ahelp hid=\".uno:JumpToTable\" visibility=\"visible\">Go to a specified sheet.</ahelp></variable>"
msgstr "<variable id=\"gototable\"><ahelp hid=\".uno:JumpToTable\" visibility=\"visible\">Buka lembar yang ditentukan.</ahelp></variable>"
+#. ghXGk
+#: 02220000.xhp
+msgctxt ""
+"02220000.xhp\n"
+"par_id231655657630178\n"
+"help.text"
+msgid "Choose <menuitem>Sheet - Navigate - Go To Sheet</menuitem>."
+msgstr ""
+
#. dPFgf
#: 02220000.xhp
msgctxt ""
@@ -2878,13 +2887,13 @@ msgctxt ""
msgid "Type a sheet name"
msgstr "Ketik nama lembar"
-#. hyRiU
+#. guUL9
#: 02220000.xhp
msgctxt ""
"02220000.xhp\n"
"par_id3153975\n"
"help.text"
-msgid "<ahelp hid=\"SC_HID_GOTOTABLEMASK\">Type some characters contained in the searched sheet name. List of sheets will be limited to the sheet names containing these characters.</ahelp>"
+msgid "<ahelp hid=\"SC_HID_GOTOTABLEMASK\">Type some characters contained in the searched sheet name. List of sheets will be limited to the sheet names containing these characters. Search is case-sensitive. If empty, all visible sheets are listed.</ahelp>"
msgstr ""
#. aCw4F
@@ -2896,13 +2905,13 @@ msgctxt ""
msgid "Sheets"
msgstr "Lembaran"
-#. XJVcD
+#. JEuum
#: 02220000.xhp
msgctxt ""
"02220000.xhp\n"
"par_id3153971\n"
"help.text"
-msgid "<ahelp hid=\"SC_HID_GOTOTABLE\">Lists the sheets in the current document. Hidden sheets are not listed. To select a sheet, press the up or down arrow keys to move to a sheet in the list. Double click on a name will directly jump to this sheet.</ahelp>"
+msgid "<ahelp hid=\"SC_HID_GOTOTABLE\">Lists the sheets in the current document. Hidden sheets are not listed. To select a sheet, press the up or down arrow keys to move to a sheet in the list. Double-clicking on a name will directly jump to this sheet.</ahelp>"
msgstr ""
#. eomCF
@@ -6298,13 +6307,13 @@ msgctxt ""
msgid "<input>=AMORDEGRC(2000; \"2020-02-01\"; \"2020-12-31\"; 10; 4; 0.1; 0)</input> returns a depreciation amount of 163 currency units."
msgstr ""
-#. AvpDv
+#. aG2TT
#: 04060103.xhp
msgctxt ""
"04060103.xhp\n"
"par_id851616615176815\n"
"help.text"
-msgid "Beware that Basis 2 is not supported by Microsoft Excel. Hence, if you use Basis 2 and export your document to XLSX format, it will return an error when opened in Excel."
+msgid "Be aware that Basis 2 is not supported by Microsoft Excel. Hence, if you use Basis 2 and export your document to XLSX format, it will return an error when opened in Excel."
msgstr ""
#. UCPgp
@@ -10546,14 +10555,14 @@ msgctxt ""
msgid "<item type=\"input\">=AND(12<13;14>12;7<6)</item> returns FALSE."
msgstr "<item type=\"input\">=AND(12<13;14>12;7<6)</item> mengembalikan FALSE."
-#. EuCHs
+#. 3MAQE
#: 04060105.xhp
msgctxt ""
"04060105.xhp\n"
"par_id3149946\n"
"help.text"
-msgid "<item type=\"input\">=AND (FALSE;TRUE)</item> returns FALSE."
-msgstr "<item type=\"input\">=AND (FALSE;TRUE)</item> mengembalikan FALSE."
+msgid "<item type=\"input\">=AND(FALSE();TRUE())</item> returns FALSE."
+msgstr ""
#. XXJC8
#: 04060105.xhp
@@ -10816,14 +10825,14 @@ msgctxt ""
msgid "<item type=\"input\">=OR(12<11;13>22;45=45)</item> returns TRUE."
msgstr "<item type=\"input\">=OR(12<11;13>22;45=45)</item> mengembalikan TRUE."
-#. ExAZa
+#. sqF5J
#: 04060105.xhp
msgctxt ""
"04060105.xhp\n"
"par_id3158412\n"
"help.text"
-msgid "<item type=\"input\">=OR(FALSE;TRUE)</item> returns TRUE."
-msgstr "<item type=\"input\">=OR(FALSE;TRUE)</item> mengembalikan TRUE."
+msgid "<item type=\"input\">=OR(FALSE();TRUE())</item> returns TRUE."
+msgstr ""
#. B2UcY
#: 04060105.xhp
@@ -10942,32 +10951,32 @@ msgctxt ""
msgid "XOR(<embedvar href=\"text/scalc/01/ful_func.xhp#logical255_1\" markup=\"keep\"/>)"
msgstr "XOR(<embedvar href=\"text/scalc/01/ful_func.xhp#logical255_1\" markup=\"keep\"/>)"
-#. qpsgo
+#. 2QMxz
#: 04060105.xhp
msgctxt ""
"04060105.xhp\n"
"par_id3083286\n"
"help.text"
-msgid "<item type=\"input\">=XOR(TRUE;TRUE)</item> returns FALSE"
-msgstr "<item type=\"input\">=XOR(TRUE;TRUE)</item> mengembalikan FALSE"
+msgid "<item type=\"input\">=XOR(TRUE();TRUE())</item> returns FALSE"
+msgstr ""
-#. dcNVj
+#. sACsD
#: 04060105.xhp
msgctxt ""
"04060105.xhp\n"
"par_id3083445\n"
"help.text"
-msgid "<item type=\"input\">=XOR(TRUE;TRUE;TRUE)</item> returns TRUE"
-msgstr "<item type=\"input\">=XOR(TRUE;TRUE;TRUE)</item> mengembalikan TRUE"
+msgid "<item type=\"input\">=XOR(TRUE();TRUE();TRUE())</item> returns TRUE"
+msgstr ""
-#. ewhWG
+#. Uhsea
#: 04060105.xhp
msgctxt ""
"04060105.xhp\n"
"par_id3154315\n"
"help.text"
-msgid "<item type=\"input\">=XOR(FALSE;TRUE)</item> returns TRUE"
-msgstr "<item type=\"input\">=XOR(FALSE;TRUE)</item> mengembalikan TRUE"
+msgid "<item type=\"input\">=XOR(FALSE();TRUE())</item> returns TRUE"
+msgstr ""
#. 3Ed6j
#: 04060106.xhp
@@ -20075,13 +20084,13 @@ msgctxt ""
msgid "You can use the CHAR function or the UNICHAR function to insert a double quotation mark. For example, the formula <input>=UNICHAR(34) & \"The Catcher in the Rye\" & UNICHAR(34) & \" is a famous book by J. D. Salinger.\"</input> displays the string <literal>\"The Catcher in the Rye\" is a famous book by J. D. Salinger.</literal>"
msgstr ""
-#. cpK3Z
+#. wDvCT
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
"par_id401624454547945\n"
"help.text"
-msgid "Beware that Calc's AutoCorrect function may modify double quotation marks. AutoCorrect should not change the double quotation marks within formula cells but may change those used in non-formula cells containing text. For example, if you copy a string that is surrounded by some other form of typographical double quotation marks, such as the left double quotation mark (U+201C) and the right double quotation mark (U+201D), and then paste into a formula cell, an error may result. Open the <emph>Double Quotes</emph> area of the <menuitem>Tools - AutoCorrect Options - Localized Options</menuitem> dialog to set the characters used to automatically correct the start and end typographical double quotation marks. Uncheck the <menuitem>Replace</menuitem> toggle button to disable the feature."
+msgid "Be aware that Calc's AutoCorrect function may modify double quotation marks. AutoCorrect should not change the double quotation marks within formula cells but may change those used in non-formula cells containing text. For example, if you copy a string that is surrounded by some other form of typographical double quotation marks, such as the left double quotation mark (U+201C) and the right double quotation mark (U+201D), and then paste into a formula cell, an error may result. Open the <emph>Double Quotes</emph> area of the <menuitem>Tools - AutoCorrect Options - Localized Options</menuitem> dialog to set the characters used to automatically correct the start and end typographical double quotation marks. Uncheck the <menuitem>Replace</menuitem> toggle button to disable the feature."
msgstr ""
#. rdzbS
@@ -45019,13 +45028,13 @@ msgctxt ""
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
+#. 9vjYD
#: 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."
+msgid "Conditional formats do not 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
@@ -45037,6 +45046,33 @@ msgctxt ""
msgid "To apply conditional formatting, AutoCalculate must be enabled. Choose <emph>Data - Calculate - AutoCalculate</emph> (you see a check mark next to the command when AutoCalculate is enabled)."
msgstr "Untuk menerapkan pemformatan kondisional, HitungOtomatis mesti diaktifkan. Pilih <emph>Data - Hitung - HitungOtomatis</emph> (Anda melihat contreng di sebelah perintah ketika HitungOtomatis difungsikan)."
+#. Kp2g2
+#: 05120000.xhp
+msgctxt ""
+"05120000.xhp\n"
+"hd_id961662926287139\n"
+"help.text"
+msgid "Cell range"
+msgstr ""
+
+#. Gv4oU
+#: 05120000.xhp
+msgctxt ""
+"05120000.xhp\n"
+"hd_id431662926282555\n"
+"help.text"
+msgid "Range"
+msgstr ""
+
+#. BoUXF
+#: 05120000.xhp
+msgctxt ""
+"05120000.xhp\n"
+"par_id31494138\n"
+"help.text"
+msgid "Defines the range of cells concerned by the conditional formatting. Click on the <emph>Shrink</emph> button to minimize the dialog box. Click again on the button to come back to the dialog box once the range is selected."
+msgstr ""
+
#. NvgCF
#: 05120000.xhp
msgctxt ""
@@ -45100,419 +45136,1400 @@ msgctxt ""
msgid "<ahelp hid=\".\">Decrease priority of the selected condition.</ahelp>"
msgstr ""
-#. FZJa2
+#. niBsF
#: 05120000.xhp
msgctxt ""
"05120000.xhp\n"
-"hd_id31531891\n"
+"hd_id71662926011736\n"
"help.text"
-msgid "Condition list entry"
+msgid "Add"
msgstr ""
-#. YLwyA
+#. NiRqU
#: 05120000.xhp
msgctxt ""
"05120000.xhp\n"
-"par_id31494132\n"
+"par_id721662926016039\n"
"help.text"
-msgid "Specify if conditional formatting is dependent on one of the entry listed on the drop down box:"
-msgstr "Tentukan apakah pemformatan kondisional bergantung pada salah satu entri yang tercantum di kotak tarik turun:"
+msgid "Adds the condition to the condition list."
+msgstr ""
-#. ApsPx
+#. EXu3U
#: 05120000.xhp
msgctxt ""
"05120000.xhp\n"
-"par_id31494133\n"
+"hd_id401662926020291\n"
"help.text"
-msgid "If you select <emph>All cells</emph>, see Color Scale, Data Bar or Icon Set explanations below, depending on which visual representation the conditional formatting should be represented."
-msgstr "Jika Anda memilih <emph> Semua sel </emph>, lihat Skala Warna, Bilah Data, atau Kumpulan Ikon di bawah ini, tergantung pada representasi visual yang mana pemformatan bersyarat yang harus diwakili."
+msgid "Delete"
+msgstr ""
-#. gtbEv
+#. njCNL
#: 05120000.xhp
msgctxt ""
"05120000.xhp\n"
-"par_id31494134\n"
+"par_id301662926026944\n"
"help.text"
-msgid "If you select <emph>Cell value is</emph>:"
-msgstr "Jika Anda memilih <emph>Nilai sel adalah</emph>:"
+msgid "Deletes the condition from the condition list."
+msgstr ""
-#. XgjY5
+#. ZSEod
#: 05120000.xhp
msgctxt ""
"05120000.xhp\n"
-"par_id31494135\n"
+"hd_id31531891\n"
"help.text"
-msgid "Select a condition in the drop down list for the format to be applied to the selected cells and enter the value."
-msgstr "Pilih kondisi dalam daftar tarik-turun agar format diterapkan ke sel yang dipilih dan masukkan nilainya."
+msgid "Condition list entries"
+msgstr ""
-#. VeDFA
+#. udAbc
#: 05120000.xhp
msgctxt ""
"05120000.xhp\n"
-"par_id31494136\n"
+"par_id31494132\n"
"help.text"
-msgid "In front of <emph>Apply Styles</emph>, select the desired style in the list or chose <emph>New Style</emph> to create one."
-msgstr "Di depan <emph>Penggunaan Gaya</emph>, Pilih gaya yang diinginkan dalam daftar atau pilih <emph>Gaya Baru</emph> untuk membuat satu."
+msgid "Specify if conditional formatting is dependent on one of the entry listed on the drop down box."
+msgstr ""
-#. FVRBc
+#. WsjTp
#: 05120000.xhp
msgctxt ""
"05120000.xhp\n"
-"par_id31494137\n"
+"hd_id431662938949798\n"
"help.text"
-msgid "<ahelp hid=\".\">Click the <emph>Add</emph> button to add another condition, click the <emph>Remove</emph> button to remove a condition.</ahelp>"
-msgstr "<ahelp hid=\".\">Klik tombol <emph>Tambah</emph> untuk menambahkan kondisi lain, klik tombol <emph>Hapus</emph> untuk menghapus suatu kondisi.</ahelp>"
+msgid "Apply Style"
+msgstr ""
-#. NV9Lr
+#. 8WfD4
#: 05120000.xhp
msgctxt ""
"05120000.xhp\n"
-"par_id31494138\n"
+"par_id971662939043786\n"
"help.text"
-msgid "<ahelp hid=\".\">In the <emph>Range</emph> field, define the range of cells concerned by the conditional formatting.</ahelp> Click on the <emph>Shrink</emph> button to minimize the dialog box. Click again on the button to come back to the dialog box once the range is selected."
-msgstr "<ahelp hid=\".\">Dalam <emph>Rentang</emph>ruas, menentukan rentang sel yang terkait dengan pemformatan bersyarat.</ahelp>Klik pada <emph>Menyusut</emph> tombol untuk memperkecil kotak dialog. Klik lagi pada tombol untuk kembali ke kotak dialog setelah rentang dipilih."
+msgid "Select the cell style to apply when the condition is verified. Select <emph>New Style</emph> to open the <link href=\"text/scalc/01/cell_styles.xhp\" name=\"cellstyledialog\">Cell Style dialog</link> and define the style properties."
+msgstr ""
-#. 3noEQ
-#: 05120000.xhp
+#. CHbab
+#: 05120100.xhp
msgctxt ""
-"05120000.xhp\n"
+"05120100.xhp\n"
+"tit\n"
+"help.text"
+msgid "Conditional Formatting - Cell value is"
+msgstr ""
+
+#. XZ4AV
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"hd_id431662935550205\n"
+"help.text"
+msgid "<variable id=\"h1\"><link href=\"text/scalc/01/05120100.xhp\" name=\"Cell Value\">Condition - Cell value is</link></variable>"
+msgstr ""
+
+#. RtY8f
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id11662915615351\n"
+"help.text"
+msgid "Applies a cell style on the cell or cell range controlled by the condition set in the drop down list. The formatting is applied to each cell individually and the condition may depend on other cells values of the selected range."
+msgstr ""
+
+#. fkuaH
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id181662913907279\n"
+"help.text"
+msgid "Condition"
+msgstr ""
+
+#. gJBMQ
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id221663406419144\n"
+"help.text"
+msgid "Applies on"
+msgstr ""
+
+#. Yd3xQ
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id941662913907280\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. nP5Ym
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id31662913907282\n"
+"help.text"
+msgid "is equal to"
+msgstr ""
+
+#. rWJoB
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id321663406539530\n"
+"help.text"
+msgid "<variable id=\"numbertext\">Numbers and text</variable>"
+msgstr ""
+
+#. bYfTW
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id881662913907284\n"
+"help.text"
+msgid "The cell value equals the user defined value in text box in the right. Use text inside quotes if you compare text values."
+msgstr ""
+
+#. ziYCE
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id271662914239763\n"
+"help.text"
+msgid "is less than"
+msgstr ""
+
+#. bS8eG
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id121663406585137\n"
+"help.text"
+msgid "<variable id=\"numbers\">Numbers</variable>"
+msgstr ""
+
+#. BdnvW
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id501662914239764\n"
+"help.text"
+msgid "The cell value is strictly less than the user defined value in the text box in the right."
+msgstr ""
+
+#. Zyiqi
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id701662914433053\n"
+"help.text"
+msgid "is greater than"
+msgstr ""
+
+#. PCZug
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id461662914433054\n"
+"help.text"
+msgid "The cell value is strictly greater than the user defined value in the text box in the right."
+msgstr ""
+
+#. zTBff
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id421662914480517\n"
+"help.text"
+msgid "is less than or equal to"
+msgstr ""
+
+#. Cy2T9
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id631662914480518\n"
+"help.text"
+msgid "The cell value is less than or equal to the user defined value in the text box in the right."
+msgstr ""
+
+#. cFMZa
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id651662914713102\n"
+"help.text"
+msgid "is greater than or equal to"
+msgstr ""
+
+#. YG9FG
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id251662914713103\n"
+"help.text"
+msgid "The cell value is greater than or equal to the user defined value in the text box in the right."
+msgstr ""
+
+#. Pbje6
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id831662914760085\n"
+"help.text"
+msgid "is not equal to"
+msgstr ""
+
+#. T8x2N
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id301662914760087\n"
+"help.text"
+msgid "The cell value is not equal (different) to the user defined value in the text box in the right. Use text inside quotes if you compare text values."
+msgstr ""
+
+#. B6eGh
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id81662914901503\n"
+"help.text"
+msgid "is between"
+msgstr ""
+
+#. ZmHDH
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id21662914901504\n"
+"help.text"
+msgid "The cell value is between the two values defined in the text boxes on the right - lower and upper values - including the boundary values themselves."
+msgstr ""
+
+#. PGH34
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id411662915178872\n"
+"help.text"
+msgid "is not between"
+msgstr ""
+
+#. dECpd
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id861662915178873\n"
+"help.text"
+msgid "The cell value is not between the two values defined in the text boxes on the right - lower and upper values - including the boundary values themselves."
+msgstr ""
+
+#. zqVSC
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id731662915275926\n"
+"help.text"
+msgid "is duplicate"
+msgstr ""
+
+#. 4DKbK
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id881662915275927\n"
+"help.text"
+msgid "The cell and at least one other cell in the range have equal contents."
+msgstr ""
+
+#. UC2gL
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id381662915857686\n"
+"help.text"
+msgid "is not duplicate"
+msgstr ""
+
+#. ZBUgm
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id341662915857687\n"
+"help.text"
+msgid "The cell contents is unique in the range."
+msgstr ""
+
+#. c8Bkp
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id1001662915996409\n"
+"help.text"
+msgid "is in top N elements"
+msgstr ""
+
+#. pDAGV
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id571662915996410\n"
+"help.text"
+msgid "The cell value is between the maximum value in the range and the N<sup>th</sup> greater element of the same. Enter the value of N in the text box on the right."
+msgstr ""
+
+#. V4FnF
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id341662916338175\n"
+"help.text"
+msgid "is in bottom N elements"
+msgstr ""
+
+#. UDdhD
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id11662916338177\n"
+"help.text"
+msgid "The cell value is between the minimum value in the range and the N<sup>th</sup> lower element of the same. Enter the value of N in the text box on the right."
+msgstr ""
+
+#. a9GoR
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id181662916407095\n"
+"help.text"
+msgid "is in top N percent"
+msgstr ""
+
+#. rgUnx
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id911662916407097\n"
+"help.text"
+msgid "The <emph>cell range index value is in the top N percent</emph> of the number of cells in the range. For example, in a 20 cells range and N equals 20, the style is applied to the 4 last cells of the range. Enter the value of N in the text box on the right."
+msgstr ""
+
+#. kfDTU
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id421662917285432\n"
+"help.text"
+msgid "is in bottom N percent"
+msgstr ""
+
+#. pphGh
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id111662917285433\n"
+"help.text"
+msgid "The <emph>cell range index value is in the bottom N percent</emph> of the number of cells in the range. For example, in a 20 cells range and N equals 20, the style is applied to the 4 first cells of the range. Enter the value of N in the text box on the right."
+msgstr ""
+
+#. W6QVL
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id861662917382735\n"
+"help.text"
+msgid "is above average"
+msgstr ""
+
+#. YM3iz
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id811662917382736\n"
+"help.text"
+msgid "The cell value is strictly greater than the average of the cell range values."
+msgstr ""
+
+#. AAKPP
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id421662919561954\n"
+"help.text"
+msgid "is below average"
+msgstr ""
+
+#. DAPwV
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id661662919561956\n"
+"help.text"
+msgid "The cell value is strictly less than the average of the cell range values."
+msgstr ""
+
+#. 5cN4q
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id831662919693474\n"
+"help.text"
+msgid "is above or equal average"
+msgstr ""
+
+#. dk8XB
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id71662919693475\n"
+"help.text"
+msgid "The cell value is greater or equal than the average of the cell range values."
+msgstr ""
+
+#. HuZ9i
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id521662919771410\n"
+"help.text"
+msgid "is below or equal average"
+msgstr ""
+
+#. GRFFh
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id131662919771411\n"
+"help.text"
+msgid "The cell value is less or equal than the average of the cell range values."
+msgstr ""
+
+#. vFFDn
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id451662919849856\n"
+"help.text"
+msgid "is error"
+msgstr ""
+
+#. d8WFb
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id911662919849857\n"
+"help.text"
+msgid "The cell is in the error condition defined in the text box on the right. <link href=\"text/scalc/05/02140000.xhp\" name=\"calc errors\">List of Calc errors</link>."
+msgstr ""
+
+#. DAG5B
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id61662920733334\n"
+"help.text"
+msgid "A cell that references another cell with an error condition is not in error itself."
+msgstr ""
+
+#. uUxWk
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id961662920774180\n"
+"help.text"
+msgid "is not error"
+msgstr ""
+
+#. BzFfB
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id381662920774181\n"
+"help.text"
+msgid "The cell is not in the error condition defined in the text box on the right. <link href=\"text/scalc/05/02140000.xhp\" name=\"calc errors\">List of Calc errors</link>"
+msgstr ""
+
+#. uEArp
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id151662920861587\n"
+"help.text"
+msgid "begins with"
+msgstr ""
+
+#. SrP9B
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id341662920861588\n"
+"help.text"
+msgid "The cell contents begins with the text or number defined in the text box on the right."
+msgstr ""
+
+#. yF6EV
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id801662922586796\n"
+"help.text"
+msgid "<variable id=\"text_comparison\">The condition applies to the internal text conversion of the cell contents. Numeric values are compared with their equivalent text representation. Numeric cell formats (currency, scientific, user-defined ... ) are not considered for comparisons.</variable>"
+msgstr ""
+
+#. v76zE
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id361662922600585\n"
+"help.text"
+msgid "ends with"
+msgstr ""
+
+#. Ag7VY
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id801662922600586\n"
+"help.text"
+msgid "The cell contents ends with the text or number defined in the right text box."
+msgstr ""
+
+#. kDJVK
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id151662922939292\n"
+"help.text"
+msgid "contains"
+msgstr ""
+
+#. b4MWb
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id251662922939293\n"
+"help.text"
+msgid "The cell contents contains the text or number defined in the right text box."
+msgstr ""
+
+#. ugaZe
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id291662923021542\n"
+"help.text"
+msgid "does not contain"
+msgstr ""
+
+#. CyQm8
+#: 05120100.xhp
+msgctxt ""
+"05120100.xhp\n"
+"par_id541662923021543\n"
+"help.text"
+msgid "The cell contents does not contains the text or number defined in the text box on the right."
+msgstr ""
+
+#. 4zHYR
+#: 05120200.xhp
+msgctxt ""
+"05120200.xhp\n"
+"tit\n"
+"help.text"
+msgid "Conditional Formatting - Formula is"
+msgstr ""
+
+#. pRBn3
+#: 05120200.xhp
+msgctxt ""
+"05120200.xhp\n"
+"hd_id471662936567369\n"
+"help.text"
+msgid "<variable id=\"h1\"><link href=\"text/scalc/01/05120200.xhp\" name=\"Formula is\">Condition - Formula is</link></variable>"
+msgstr ""
+
+#. WwqGv
+#: 05120200.xhp
+msgctxt ""
+"05120200.xhp\n"
"par_id31494139\n"
"help.text"
-msgid "If you select <emph>Formula is</emph> as a reference, enter a cell reference. If the cell reference is a value other than zero, the condition matches."
-msgstr "Jika anda memilih <emph>rumus adalah</emph> sebagai acuan, masukkan referensi sel. Jika referensi sel adalah nilai selain nol, kondisinya cocok."
+msgid "Applies the selected style to the cell when the formula expression in the text box in the right is <emph>not</emph> zero."
+msgstr ""
-#. bErXu
-#: 05120000.xhp
+#. S3dcs
+#: 05120200.xhp
msgctxt ""
-"05120000.xhp\n"
-"par_id3149413a\n"
+"05120200.xhp\n"
+"par_id1001662932287796\n"
"help.text"
-msgid "If you select <emph>Date is</emph>, see below explanations for Date."
-msgstr "Jika Anda memilih <emph>Tanggal adalah</emph>, lihat penjelasan di bawah ini untuk Tanggal."
+msgid "The formula is expressed similar to a test condition evaluating to <literal>TRUE</literal> or <literal>FALSE</literal>."
+msgstr ""
-#. GFxCV
-#: 05120000.xhp
+#. dAQYf
+#: 05120200.xhp
msgctxt ""
-"05120000.xhp\n"
+"05120200.xhp\n"
+"par_id111662936728630\n"
+"help.text"
+msgid "For example, if C29 has a conditional formatting which formula is <input>B1>=(DATE(2015;5;4)+TIME(18;0;0))</input> - a logical expression that evaluates true or false - the style applied to C29 depends on B1 contents."
+msgstr ""
+
+#. PJRcV
+#: 05120300.xhp
+msgctxt ""
+"05120300.xhp\n"
+"tit\n"
+"help.text"
+msgid "Conditional Formatting - Date is"
+msgstr ""
+
+#. 9mjQT
+#: 05120300.xhp
+msgctxt ""
+"05120300.xhp\n"
+"hd_id321662936831682\n"
+"help.text"
+msgid "<variable id=\"h1\"><link href=\"text/scalc/01/05120300.xhp\" name=\"Date is\">Condition - Date is</link></variable>"
+msgstr ""
+
+#. eZ8g9
+#: 05120300.xhp
+msgctxt ""
+"05120300.xhp\n"
+"par_id31662934883939\n"
+"help.text"
+msgid "Applies the selected style to the cell when the cell contents is formatted as date and the condition is one of the available date interval in the dropdown list."
+msgstr ""
+
+#. FuPW5
+#: 05120300.xhp
+msgctxt ""
+"05120300.xhp\n"
+"par_id231662933568615\n"
+"help.text"
+msgid "<emph>Today</emph>: applies the cell style if the cell date contents is today."
+msgstr ""
+
+#. Jp3xf
+#: 05120300.xhp
+msgctxt ""
+"05120300.xhp\n"
+"par_id891662933647849\n"
+"help.text"
+msgid "<emph>Yesterday</emph>: applies the cell style if the cell date contents is yesterday."
+msgstr ""
+
+#. kGKdd
+#: 05120300.xhp
+msgctxt ""
+"05120300.xhp\n"
+"par_id701662933702962\n"
+"help.text"
+msgid "<emph>Tomorrow</emph>: applies the cell style if the cell date contents is tomorrow."
+msgstr ""
+
+#. qiPQc
+#: 05120300.xhp
+msgctxt ""
+"05120300.xhp\n"
+"par_id291662933755624\n"
+"help.text"
+msgid "<emph>Last 7 days</emph>: applies the cell style if the cell date contents is in the last 7 calendar days."
+msgstr ""
+
+#. ReAps
+#: 05120300.xhp
+msgctxt ""
+"05120300.xhp\n"
+"par_id151662933849611\n"
+"help.text"
+msgid "<emph>This week, Last week and Next week</emph>: applies the cell style if the cell date contents is in this week, last week and next week respectively. The start and end of the week is locale dependent."
+msgstr ""
+
+#. 6bfmv
+#: 05120300.xhp
+msgctxt ""
+"05120300.xhp\n"
+"par_id421662934429482\n"
+"help.text"
+msgid "<emph>This month, Last month and Next month</emph>: applies the cell style if the cell date contents is in this month, last month and next month respectively."
+msgstr ""
+
+#. xduEr
+#: 05120300.xhp
+msgctxt ""
+"05120300.xhp\n"
+"par_id461662934605639\n"
+"help.text"
+msgid "<emph>This year, Last year and Next year</emph>: applies the cell style if the cell date contents is in this year, last year and next year respectively."
+msgstr ""
+
+#. ZANZR
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"tit\n"
+"help.text"
+msgid "Conditional Formatting - All cells"
+msgstr ""
+
+#. EcBzD
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"hd_id861662937013389\n"
+"help.text"
+msgid "<variable id=\"h1\"><link href=\"text/scalc/01/05120400.xhp\" name=\"All cells\">Condition - All cells</link></variable>"
+msgstr ""
+
+#. Bstud
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"par_id31662915586650\n"
+"help.text"
+msgid "Applies the conditional formatting to the set of cells defined in the selected range. The formatting is applied based on the contents of the whole range."
+msgstr ""
+
+#. UrbTk
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
"hd_id3147394\n"
"help.text"
-msgid "Color Scale"
-msgstr "Skala Warna"
+msgid "<link href=\"text/scalc/01/05120400.xhp#colorscale\" name=\"Color Scale\">Color Scale</link>"
+msgstr ""
-#. mbqvS
-#: 05120000.xhp
+#. VvAiE
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
+"05120400.xhp\n"
"par_id3155602\n"
"help.text"
-msgid "This is the same dialog box as if you select <emph>All cells</emph> in the first sub menu entry <emph>Condition</emph>.Apply a color scale to a range consist of displaying a bicolor or tricolor gradient on this range depending on the value of each cell. A typical example might be an array of temperatures, lower blue colored, warmer red with a gradient nuances to the intermediate values."
-msgstr "Ini adalah kotak dialog yang sama seperti jika anda memilih <emph>Semua sel</emph>dalam entri sub menu pertama<emph>Kondisi</emph>.Menerapkan skala warna untuk rentang terdiri dari menampilkan gradien dua warna atau tiga warna pada rentang ini tergantung pada nilai masing-masing sel. Contoh tipikalnya adalah susunan suhu, berwarna biru lebih rendah, merah lebih hangat dengan nuansa gradasi hingga nilai tengah."
+msgid "Applies a color scale to a range consisting of displaying a bicolor or tricolor gradient on this range depending on the value of each cell."
+msgstr ""
-#. DuNBp
-#: 05120000.xhp
+#. S9Btk
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
-"par_id3155603\n"
+"05120400.xhp\n"
+"hd_id541663598275609\n"
+"help.text"
+msgid "Conditions"
+msgstr ""
+
+#. zip59
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"par_id231663598294535\n"
"help.text"
-msgid "You must choose the two \"extreme\" colors indicate the method of calculation. The calculation of the color applied will be made in relation to: Min - Max - Percentile - Value - Percent - Formula."
-msgstr "Anda harus memilih dua warna \"ekstrim\" yang menunjukkan metode penghitungan. Perhitungan warna yang diterapkan akan dilakukan sehubungan dengan: Min - Max - Persentil - Nilai - Persen - Rumus."
+msgid "The calculation of the color scale depends on 2 or 3 conditions, defined as follows:"
+msgstr ""
-#. 6Ggqk
-#: 05120000.xhp
+#. XKMSV
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
-"par_id3155604\n"
+"05120400.xhp\n"
+"par_id701864449697771\n"
"help.text"
-msgid "The choices Min and Max are sufficient to themselves as found in the range. Other options need to be specified by a value (Percentile, Value, Percentage) or a cell reference or formula (Formula)."
-msgstr "Pilihan Min dan Max cukup untuk diri mereka sendiri seperti yang ditemukan dalam rentang. Opsi lain perlu ditentukan oleh suatu nilai (Persentil, Nilai, Persentase) atau referensi sel atau rumus (Rumus)."
+msgid "<emph>Min (Max)</emph>: calculates using the minimum (maximum) values in the range."
+msgstr ""
-#. 9jo8a
-#: 05120000.xhp
+#. eGYev
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
-"par_id3155605\n"
+"05120400.xhp\n"
+"par_id321663440728295\n"
"help.text"
-msgid "For a detailed explanation and examples, please visit <link href=\"https://wiki.documentfoundation.org/Faq/Calc/142\">How to apply a Color Scale Conditional Formatting page</link> in TDF Wiki."
-msgstr "Untuk penjelasan detail dan contoh, silahkan kunjungi <link href=\"https://wiki.documentfoundation.org/Faq/Calc/142\"> Cara menerapkan halaman Pemformatan Bersyarat Skala Warna</link> dalam TDF Wiki"
+msgid "<emph>Value</emph>: a fixed value. Enter the value in the text box."
+msgstr ""
-#. dACxH
-#: 05120000.xhp
+#. DZxAs
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
+"05120400.xhp\n"
+"par_id611663440697270\n"
+"help.text"
+msgid "<emph>Percentile</emph>: A percentile is each of the 99 values which divide the sorted data in 100 equal parts, so that each part represents 1/100 of the sample population. A percentile return the value for a data series going from the smallest to the largest value in a set of data. For P = 25, the percentile means the first quartile. P = 50 is also the MEDIAN of the data set. Enter the percentile value in the text box. Valid values are from 0 to 100."
+msgstr ""
+
+#. zwwLa
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"par_id211663440834104\n"
+"help.text"
+msgid "<emph>Percent</emph>: a fixed value representing the percentage of the minimum (maximum) of the length defined by minimum and maximum values in the range. A minimum of 10% selects the values below 10% of the segment [Min,Max]. A maximum of 80% select values above 80% of the segment [Min,Max]. Valid values are from 0 (zero) to 100. Do not enter a percent (%) sign."
+msgstr ""
+
+#. nF8iD
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"par_id961663440848168\n"
+"help.text"
+msgid "<emph>Formula</emph>: A formula expression starting with the equal sign (=) that calculates a numeric value. Values can be numbers, dates or time. Enter the formula expression in the text box."
+msgstr ""
+
+#. rDuW2
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
"par_id991609782427459\n"
"help.text"
-msgid "Data Bar"
+msgid "<link href=\"text/scalc/01/05120400.xhp#databar\" name=\"Data Bar\">Data Bar</link>"
msgstr ""
-#. xapwr
-#: 05120000.xhp
+#. ZEyNr
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
+"05120400.xhp\n"
"par_id41609780964157\n"
"help.text"
-msgid "Data bar option will fill the cell with solid or gradient color corresponding to the numeric value in the cell. Default is blue for positive and red for negative."
+msgid "Data bar option will fill the cell with solid or gradient color corresponding to the numeric value in the cell."
msgstr ""
-#. AKYoW
-#: 05120000.xhp
+#. WHWWc
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
+"05120400.xhp\n"
+"hd_id631663449553346\n"
+"help.text"
+msgid "Conditions"
+msgstr ""
+
+#. CENjM
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
"par_id931609781970981\n"
"help.text"
-msgid "The calculation of the area of fill is based on Min - Max - Percentile - Value - Percent - Formula."
+msgid "The calculation of the bar area fill is based on the conditions below:"
msgstr ""
-#. smxFL
-#: 05120000.xhp
+#. DzwrN
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
-"par_id981609782003841\n"
+"05120400.xhp\n"
+"par_id281663449673792\n"
"help.text"
-msgid "The choices Min and Max are sufficient to themselves as found in the range. Other options need to be specified by a value (Percentile, Value, Percentage) or a cell reference or formula (Formula)."
+msgid "<emph>Automatic</emph>: calculates using the minimum and maximum values in the range."
msgstr ""
-#. qBVjM
-#: 05120000.xhp
+#. 9aPGW
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
+"05120400.xhp\n"
+"par_id701663449697771\n"
+"help.text"
+msgid "<emph>Min (Max)</emph>: calculates using the minimum (maximum) values in the range."
+msgstr ""
+
+#. Yst5U
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
"par_id281609781729359\n"
"help.text"
-msgid "<emph>More Options...</emph> opens a dialog to:"
+msgid "More Options"
msgstr ""
-#. saDJA
-#: 05120000.xhp
+#. wB7B5
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
-"par_id271609781812913\n"
+"05120400.xhp\n"
+"par_id501663454998977\n"
"help.text"
-msgid "change colors"
+msgid "The Data Bar dialog opens to add details on the display of data bars."
msgstr ""
-#. uncF8
-#: 05120000.xhp
+#. Xi84x
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
-"par_id921609781838551\n"
+"05120400.xhp\n"
+"hd_id221663453502042\n"
"help.text"
-msgid "change position of vertical axis within the cell"
+msgid "Entry values"
msgstr ""
-#. wJNxE
-#: 05120000.xhp
+#. j4CZx
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
-"par_id631609781859971\n"
+"05120400.xhp\n"
+"par_id891663453681870\n"
"help.text"
-msgid "the bar's minimum and maximum length in percentage"
+msgid "Same as the conditions above."
msgstr ""
-#. de4nk
-#: 05120000.xhp
+#. qYC9D
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
+"05120400.xhp\n"
+"hd_id511663453530293\n"
+"help.text"
+msgid "Bar Colors"
+msgstr ""
+
+#. 3WvU9
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"par_id371663453564807\n"
+"help.text"
+msgid "Choose the color for positive and negative values."
+msgstr ""
+
+#. F7ADR
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"hd_id891663453607961\n"
+"help.text"
+msgid "Fill"
+msgstr ""
+
+#. NK7yv
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"par_id671663453639829\n"
+"help.text"
+msgid "<emph>Gradient</emph>: set a color scale between the color of positive (negative) values and white."
+msgstr ""
+
+#. UsHFm
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"par_id551663453647462\n"
+"help.text"
+msgid "<emph>Color</emph>: use the positive (negative) color for the entire data bar, no fade out gradient."
+msgstr ""
+
+#. 3XDGX
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"hd_id701663453750779\n"
+"help.text"
+msgid "Axis"
+msgstr ""
+
+#. SCFQf
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"par_id691663453763746\n"
+"help.text"
+msgid "Set the position of the vertical axis for the data bar. Values are"
+msgstr ""
+
+#. 7mCxG
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"par_id381663453792294\n"
+"help.text"
+msgid "<emph>Automatic:</emph> position the vertical axis in the middle of the maximum and minimum values."
+msgstr ""
+
+#. u9oCp
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"par_id791663453800602\n"
+"help.text"
+msgid "<emph>Middle:</emph> set the vertical axis in the middle of the column."
+msgstr ""
+
+#. NGqHG
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"par_id461663453808288\n"
+"help.text"
+msgid "<emph>None:</emph> do not display a vertical axis."
+msgstr ""
+
+#. MbcW9
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"hd_id511663453851599\n"
+"help.text"
+msgid "Bar Lengths"
+msgstr ""
+
+#. EcZWp
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"par_id601663453865023\n"
+"help.text"
+msgid "Sets the minimum (maximum) length of the data bars, as a percentage of the column width."
+msgstr ""
+
+#. 6iAs7
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"hd_id211663453914830\n"
+"help.text"
+msgid "Display bars only"
+msgstr ""
+
+#. zAE3C
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"par_id561663453936590\n"
+"help.text"
+msgid "Do not display values in the cell, only the data bars."
+msgstr ""
+
+#. EjewA
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
"hd_id3153709\n"
"help.text"
-msgid "Icon Set"
-msgstr "Set ikon"
+msgid "<link href=\"text/scalc/01/05120400.xhp#iconset\" name=\"Icon Set\">Icon Set</link>"
+msgstr ""
-#. 76M6e
-#: 05120000.xhp
+#. RjnfG
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
+"05120400.xhp\n"
"par_id3153764\n"
"help.text"
-msgid "It is desired to plot the position of a value relative to the thresholds. The set of icons will help to indicate the thresholds and choose the type of icons. Available icon sets are:"
-msgstr "Diharapkan untuk memetakan posisi nilai relatif terhadap ambang batas. Set ikon akan membantu untuk menunjukkan ambang batas dan memilih jenis ikon. Set ikon yang tersedia adalah:"
+msgid "Add an icon to the cell based on the value relative to the specified thresholds. Several icon sets are available."
+msgstr ""
-#. cv4WG
-#: 05120000.xhp
+#. 5EFt7
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
+"05120400.xhp\n"
+"hd_id191663440362309\n"
+"help.text"
+msgid "Available Icon Sets"
+msgstr ""
+
+#. 8cgd9
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
"par_id31494140\n"
"help.text"
msgid "3, 4 or 5 - arrows"
-msgstr "={1;2;3|4;5;6}"
+msgstr ""
-#. EmC6A
-#: 05120000.xhp
+#. Aoquj
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
+"05120400.xhp\n"
+"par_id91663429174806\n"
+"help.text"
+msgid "<image src=\"media/icon-themes/sc/res/icon-set-colorarrows-up.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id81663429174808\">Color arrow up</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-colorarrows-slightly-up.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id81663529174808\">Color arrow slightly up</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-colorarrows-same.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id81663529174808\">Color arrow same</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-colorarrows-slightly-down.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id81663729174808\">Color arrow slightly down</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-colorarrows-down.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id81663329174808\">Color arrow down</alt></image>"
+msgstr ""
+
+#. PxAE7
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
"par_id31494141\n"
"help.text"
msgid "3, 4 or 5 - gray arrows"
-msgstr "={1;2;3|4;5;6}"
+msgstr ""
-#. AtmUL
-#: 05120000.xhp
+#. 2Fk3v
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
+"05120400.xhp\n"
+"par_id91661429174806\n"
+"help.text"
+msgid "<image src=\"media/icon-themes/sc/res/icon-set-grayarrows-up.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Gray arrow up</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-grayarrows-slightly-up.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Gray arrow slightly up</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-grayarrows-same.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Gray arrow same</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-grayarrows-slightly-down.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663729174808\">Gray arrow slightly down</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-grayarrows-down.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663329174808\">Gray arrow down</alt></image>"
+msgstr ""
+
+#. jA8Sa
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
"par_id31494142\n"
"help.text"
msgid "3 - flags"
-msgstr "Flag"
+msgstr ""
-#. 4zJUW
-#: 05120000.xhp
+#. Bi9Tr
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
+"05120400.xhp\n"
+"par_id101663433624185\n"
+"help.text"
+msgid "<image src=\"media/icon-themes/sc/res/icon-set-flags-yellow.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Yellow flag</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-flags-red.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Red flag</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-flags-green.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Green flag</alt></image>"
+msgstr ""
+
+#. FCb5V
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
"par_id31494143\n"
"help.text"
msgid "3 - traffic lights 1 and 2 (two different designs)"
-msgstr "3 - lampu lalu lintas 1 dan 2 (dua desain berbeda)"
+msgstr ""
-#. HEF2o
-#: 05120000.xhp
+#. LugGg
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
+"05120400.xhp\n"
+"par_id721663433917655\n"
+"help.text"
+msgid "<image src=\"media/icon-themes/sc/res/icon-set-circles1-yellow.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Yellow traffic light 1</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-circles1-red.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Red traffic light 1</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-circles1-green.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Green traffic light 1</alt></image>"
+msgstr ""
+
+#. EBREt
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"par_id501663433925207\n"
+"help.text"
+msgid "<image src=\"media/icon-themes/sc/res/icon-set-trafficlights-yellow.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Yellow traffic light 2</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-trafficlights-red.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Red traffic light 2</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-trafficlights-green.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Green traffic light 2</alt></image>"
+msgstr ""
+
+#. itKqQ
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"par_id701663438522480\n"
+"help.text"
+msgid "3 - Smileys 1 and 2"
+msgstr ""
+
+#. GoDfk
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"par_id991663438568052\n"
+"help.text"
+msgid "<image src=\"media/icon-themes/sc/res/icon-set-positive-yellow-smilie.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Yellow positive smiley</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-neutral-yellow-smilie.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Yellow neutral smiley</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-negative-yellow-smilie.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Yellow negative smiley</alt></image>"
+msgstr ""
+
+#. ABksa
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"par_id991663438966721\n"
+"help.text"
+msgid "<image src=\"media/icon-themes/sc/res/icon-set-positive-green-smilie.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Green positive smiley</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-neutral-yellow-smilie.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Yellow neutral smiley</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-negative-red-smilie.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Red negative smiley</alt></image>"
+msgstr ""
+
+#. QdJxa
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
"par_id31494144\n"
"help.text"
-msgid "3 - symbols (square, triangle, circle)"
-msgstr "3 - simbol ( persegi, segitiga, lingkaran)"
+msgid "3 - symbols"
+msgstr ""
-#. V2vKf
-#: 05120000.xhp
+#. 3DDFG
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
+"05120400.xhp\n"
+"par_id421663434453517\n"
+"help.text"
+msgid "<image src=\"media/icon-themes/sc/res/icon-set-shapes-triangle.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Shape triangle</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-shapes-diamond.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Shape diamond</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-shapes-circle.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Shape circle</alt></image>"
+msgstr ""
+
+#. ndFCp
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"par_id961663439450424\n"
+"help.text"
+msgid "<image src=\"media/icon-themes/sc/res/icon-set-symbols1-exclamation-mark.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Exclamation mark</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-symbols1-cross.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Cross</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-symbols1-check.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Check mark</alt></image>"
+msgstr ""
+
+#. BQAHC
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"par_id1001663439805133\n"
+"help.text"
+msgid "<image src=\"media/icon-themes/sc/res/icon-set-stars-empty.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Empty star</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-stars-half.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Half star</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-stars-full.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Full star</alt></image>"
+msgstr ""
+
+#. dEQvx
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
+"par_id171663440020964\n"
+"help.text"
+msgid "<image src=\"media/icon-themes/sc/res/icon-set-triangles-up.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Triangle up</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-triangles-same.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Same</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-triangles-down.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Triangle down</alt></image>"
+msgstr ""
+
+#. MtGvd
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
"par_id31494145\n"
"help.text"
msgid "4 - circles from red to black"
-msgstr "4 - lingkaran dari merah ke hitam"
+msgstr ""
-#. GVUj9
-#: 05120000.xhp
+#. C9BEU
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
+"05120400.xhp\n"
+"par_id481663434995022\n"
+"help.text"
+msgid "<image src=\"media/icon-themes/sc/res/icon-set-circles2-dark-red.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Dark red</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-circles2-light-red.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Light red</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-circles2-light-gray.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Light gray</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-circles2-dark-gray.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Dark gray</alt></image>"
+msgstr ""
+
+#. AuYQx
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
"par_id31494146\n"
"help.text"
msgid "4 or 5 - ratings"
-msgstr "_Rating"
+msgstr ""
-#. BBEC7
-#: 05120000.xhp
+#. 8WLQP
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
+"05120400.xhp\n"
+"par_id631663435728155\n"
+"help.text"
+msgid "<image src=\"media/icon-themes/sc/res/icon-set-bars-empty.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Empty bars</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-bars-one-quarter.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">One quarters bars</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-bars-half.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Half bars</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-bars-three-quarters.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Three quarters bars</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-bars-full.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Full bars</alt></image>"
+msgstr ""
+
+#. FdJYa
+#: 05120400.xhp
+msgctxt ""
+"05120400.xhp\n"
"par_id31494147\n"
"help.text"
msgid "5 - quarters"
-msgstr "5"
+msgstr ""
-#. ToNq8
-#: 05120000.xhp
+#. Db9xw
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
-"par_id3153765\n"
+"05120400.xhp\n"
+"par_id741663436015689\n"
"help.text"
-msgid "Conditions to display each icon can be specified relative to a value (Value), a percentage of the number of values in the range (Percentage) as a percentage of range values (Percentile) or formula (Formula)."
-msgstr "Kondisi untuk menampilkan setiap ikon dapat ditentukan relatif terhadap nilai (Nilai), persentase jumlah nilai dalam rentang (Persentase) sebagai persentase nilai rentang (Persentil) atau rumus (Rumus)."
+msgid "<image src=\"media/icon-themes/sc/res/icon-set-pies-empty.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Empty</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-pies-one-quarter.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">One quarter</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-pies-half.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Half</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-pies-three-quarters.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Three quarters</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-pies-full.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Full</alt></image>"
+msgstr ""
-#. xD5yq
-#: 05120000.xhp
+#. 4Gyqu
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
-"par_id3155606\n"
+"05120400.xhp\n"
+"par_id821663436639070\n"
"help.text"
-msgid "For a detailed explanation and examples, please visit <link href=\"https://wiki.documentfoundation.org/Faq/Calc/141\">How to use Icon Set Conditional Formatting page</link> in TDF Wiki."
-msgstr "Untuk penjelasan detail dan contoh, silahkan kunjungi <link href=\"https://wiki.documentfoundation.org/Faq/Calc/141\">Cara menggunakan Ikon Set halaman Pemformatan Bersyarat</link> dalam TDF Wiki."
+msgid "5 - boxes"
+msgstr ""
-#. GJTU3
-#: 05120000.xhp
+#. QqwRQ
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
-"hd_id3156384\n"
+"05120400.xhp\n"
+"par_id811663438472751\n"
"help.text"
-msgid "Dates"
-msgstr "Tanggal"
+msgid "<image src=\"media/icon-themes/sc/res/icon-set-squares-empty.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Empty</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-squares-one-quarter.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">One quarter</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-squares-half.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Half</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-squares-three-quarters.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Three quarters</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-squares-full.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Full</alt></image>"
+msgstr ""
-#. WYB6t
-#: 05120000.xhp
+#. pB8zZ
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
-"par_id3145228\n"
+"05120400.xhp\n"
+"hd_id621663440395987\n"
"help.text"
-msgid "This option will apply a defined style depending on a date that you choose in the drop down box: Today - Yesterday - Tomorrow - Last 7 days - This week - Last week."
-msgstr "Pilihan ini akan menerapkan gaya yang ditentukan tergantung pada tanggal yang Anda pilih di kotak tarik turun: Hari ini - Kemarin - Besok - 7 hari terakhir - Pekan ini - Pekan lalu."
+msgid "Conditions for thresholds"
+msgstr ""
-#. WGPEW
-#: 05120000.xhp
+#. 7BkCL
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
-"par_id31494157\n"
+"05120400.xhp\n"
+"par_id3153765\n"
"help.text"
-msgid "In front of <emph>Apply Styles</emph>, select the desired style in the list or chose <emph>New Style</emph> to create one."
-msgstr "Di depan <emph>Penggunaan Gaya</emph>, Pilih gaya yang diinginkan dalam daftar atau pilih <emph>Gaya Baru</emph> untuk membuat satu."
+msgid "Conditions to set the thresholds for each icon can be specified as follows"
+msgstr ""
-#. XCEeu
-#: 05120000.xhp
+#. DdaUm
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
-"par_id31494167\n"
+"05120400.xhp\n"
+"par_id3155606\n"
"help.text"
-msgid "Click the <emph>Add</emph> button to add another condition, click the <emph>Remove</emph> button to remove a condition."
-msgstr "Klik <emph>Menambahkan</emph> tombol untuk menambahkan kondisi lain, klik <emph>Membuang</emph> tombol untuk membuang sebuah kondisi."
+msgid "<link href=\"https://wiki.documentfoundation.org/Faq/Calc/141\">How to use Icon Set Conditional Formatting page</link> in TDF Wiki."
+msgstr ""
-#. 5bcGZ
-#: 05120000.xhp
+#. s9tpC
+#: 05120400.xhp
msgctxt ""
-"05120000.xhp\n"
-"par_id31494177\n"
+"05120400.xhp\n"
+"par_id651663598549283\n"
"help.text"
-msgid "In the <emph>Range</emph> field, define the range of cells concerned by the conditional formatting. Click on the <emph>Shrink</emph> button to minimize the dialog box. Click again on the button to come back to the dialog box once the range is selected."
-msgstr "Dalam <emph>Rentang</emph> ruas, definisi rentang sel yang terkit dengan pemformatan bersyarat. Klik pada <emph>Menyusut</emph> tombol untuk memperkecil kotak dialog. Klik lagi pada tombol untuk kembali ke kotak dialog setelah rentang dipilih"
+msgid "<link href=\"https://wiki.documentfoundation.org/Faq/Calc/142\">How to apply a Color Scale Conditional Formatting page</link> in TDF Wiki."
+msgstr ""
-#. XrHd6
-#: 05120000.xhp
+#. AiUSf
+#: 05120500.xhp
msgctxt ""
-"05120000.xhp\n"
-"hd_id3153384\n"
+"05120500.xhp\n"
+"tit\n"
"help.text"
-msgid "Manage Conditional Formatting"
-msgstr "Pemformatan Kondisional"
+msgid "Conditional Formatting - Manage Conditions"
+msgstr ""
-#. KaFUh
-#: 05120000.xhp
+#. EJnPj
+#: 05120500.xhp
msgctxt ""
-"05120000.xhp\n"
-"par_id3155906\n"
+"05120500.xhp\n"
+"hd_id391662937414401\n"
"help.text"
-msgid "<ahelp hid=\".\">This dialog allows you to see all the conditional formatting defined in the spreadsheet.</ahelp>"
-msgstr "<ahelp hid=\".\">Dialog ini memungkinkan anda untuk melihat semua pemformatan bersyarat yang ditentukan dalam lembar sebar.</ahelp>"
+msgid "<variable id=\"h1\"><link href=\"text/scalc/01/05120500.xhp\" name=\"Manage Conditions\">Manage Conditions</link></variable>"
+msgstr ""
-#. oGo9V
-#: 05120000.xhp
+#. SdPis
+#: 05120500.xhp
msgctxt ""
-"05120000.xhp\n"
-"par_id31546818\n"
+"05120500.xhp\n"
+"par_id3155906\n"
"help.text"
-msgid "Choose <emph>Format - Conditional Formatting - Manage</emph>."
-msgstr "Pilih <emph>Format - Pemformatan Bersyarat - Kelola</emph>."
+msgid "Manage all the conditional formatting defined in the spreadsheet."
+msgstr ""
-#. PCf7v
-#: 05120000.xhp
+#. rMivF
+#: 05120500.xhp
msgctxt ""
-"05120000.xhp\n"
+"05120500.xhp\n"
"par_id3155907\n"
"help.text"
-msgid "The <emph>Manage Conditional Formatting</emph> dialog box opens. <ahelp hid=\".\">Here you can add, edit or remove one or several conditional formattings.</ahelp>"
-msgstr "Itu <emph> Pengelolaan Pemformatan Bersyarat</emph>kotak dialog terbuka. <ahelp hid=\".\"> Disini anda bisa menambah, menyunting atau membuang satu atau beberapa pemformatan bersyarat.</ahelp>"
+msgid "The <emph>Manage Conditional Formatting</emph> dialog is where you can add, edit or delete one or several conditional formattings."
+msgstr ""
-#. Q7xPu
-#: 05120000.xhp
+#. rFGM7
+#: 05120500.xhp
msgctxt ""
-"05120000.xhp\n"
+"05120500.xhp\n"
"par_id3155909\n"
"help.text"
-msgid "<ahelp hid=\".\">The <emph>Conditional Formats</emph> list displays the active conditional formatting rules set in the current spreadsheet.</ahelp> Only the first rule for each cell range is listed, even if there are multiple rules defined for a given range."
-msgstr "<ahelp hid=\".\">Itu <emph>Format Bersyarat</emph> daftar tampilan aturan pemformatan bersyarat aktif yang diatur dalam lembar sebar saat ini.</ahelp> Hanya aturan pertama untuk setiap rentang sel yang terdaftar, bahkan jika ada beberapa aturan yang ditentukan untuk rentang tertentu."
+msgid "The <emph>Conditional Formats</emph> list displays the active conditional formatting rules set in the current spreadsheet. Only the first rule for each cell range is listed, even if there are multiple rules defined for a given range."
+msgstr ""
-#. dTXQV
-#: 05120000.xhp
+#. dEeLT
+#: 05120500.xhp
msgctxt ""
-"05120000.xhp\n"
+"05120500.xhp\n"
"par_id3155908\n"
"help.text"
msgid "If you have defined a conditional formatting on a cell range and you try now to define a new conditional formatting on a part of this range, a warning message will be displayed, asking if you want to edit the existing conditional formatting (on the whole range) or define a new conditional formatting overlapping it (on the selected range)."
-msgstr "Jika anda telah menentukan pemformatan bersyarat pada rentang sel dan anda sekarang mencoba untuk menentukan pemformatan bersyarat pada bagian dari rentang ini, pesan peringatan akan ditampilkan, menanyakan apakah anda ingin mengedit pemformatan bersyarat yang ada (pada seluruh rentang ) atau mendefinisikan pemformatan bersyarat baru yang tumpang tindih (pada rentang yang dipilih)."
+msgstr ""
#. GXZBY
#: 06020000.xhp
@@ -56891,13 +57908,13 @@ msgctxt ""
msgid "Units of measurement"
msgstr ""
-#. oxx8A
+#. A7feF
#: func_convert.xhp
msgctxt ""
"func_convert.xhp\n"
"par_id481620428685029\n"
"help.text"
-msgid "Below are the unit measurement groups supported by the <literal>CONVERT</literal> function. Beware that conversions can only happen between units that belong to the same group."
+msgid "Below are the unit measurement groups supported by the <literal>CONVERT</literal> function. Be aware that conversions can only happen between units that belong to the same group."
msgstr ""
#. Rd9Fp
@@ -67998,13 +69015,13 @@ msgctxt ""
msgid "Bounds are specified by selecting one or more variables (as range) on the left side and entering a numerical value (not a cell or a formula) on the right side. That way you can also choose one or more variables to be <emph>Integer</emph> or <emph>Binary</emph> only."
msgstr ""
-#. ZUeCC
+#. RDcmq
#: solver.xhp
msgctxt ""
"solver.xhp\n"
"par_id271589981559367\n"
"help.text"
-msgid "<link href=\"https://wiki.documentfoundation.org/\" name=\"wikipage\">Wiki page on solvers and theirs algorithms</link>"
+msgid "<link href=\"https://wiki.documentfoundation.org/NLPSolver\" name=\"wikipage\">Wiki page on solvers and their algorithms</link>"
msgstr ""
#. akxrP
@@ -68133,13 +69150,13 @@ msgctxt ""
msgid "<ahelp hid=\".\">Enter or change the value of the selected setting.</ahelp>"
msgstr ""
-#. cYCVf
+#. FGS6a
#: solver_options.xhp
msgctxt ""
"solver_options.xhp\n"
"par_id271589981559367\n"
"help.text"
-msgid "<link href=\"https://wiki.documentfoundation.org/NLPSolver\" name=\"wikipage\">Wiki page on non-linear solvers and theirs algorithms</link>"
+msgid "<link href=\"https://wiki.documentfoundation.org/NLPSolver\" name=\"wikipage\">Wiki page on non-linear solvers and their algorithms</link>"
msgstr ""
#. A843R
@@ -68709,13 +69726,13 @@ msgctxt ""
msgid "Set the swarm algorithm. 0 for differential evolution and 1 for particle swarm optimization. Default is 0."
msgstr ""
-#. ugAZb
+#. wBxK6
#: solver_options_algo.xhp
msgctxt ""
"solver_options_algo.xhp\n"
"par_id271589981559367\n"
"help.text"
-msgid "<link href=\"https://wiki.documentfoundation.org/NLPSolver\" name=\"wikipage\">Wiki page on non-linear solvers and theirs algorithms</link>"
+msgid "<link href=\"https://wiki.documentfoundation.org/NLPSolver\" name=\"wikipage\">Wiki page on non-linear solvers and their algorithms</link>"
msgstr ""
#. D2nCR