{"id":5209,"date":"2014-06-16T22:06:22","date_gmt":"2014-06-16T15:06:22","guid":{"rendered":"http:\/\/sinaulinux.martianuswb.com\/?p=2514"},"modified":"2014-06-16T22:06:22","modified_gmt":"2014-06-16T15:06:22","slug":"libreoffice-calc-menandai-sel-dengan-konten-yang-sama","status":"publish","type":"post","link":"https:\/\/martianuswb.com\/?p=5209","title":{"rendered":"LibreOffice Calc: menandai sel dengan konten yang sama"},"content":{"rendered":"<p>Katakanlah kita mempunyai sebuah file .odt dengan kemungkinan ada banyak konten yang sama, ada banyak duplikasi isi sel. Apakah ada cara untuk mencari tahu yang mana saja yang terduplikasi tanpa harus meneliti secara manual? Ada. Bisa diikuti langkah-langkah berikut ini.<\/p>\n<p>Blok terlebih dahulu sel atau range yang ingin diteliti.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2515\" src=\"http:\/\/martianuswb.com\/wp-content\/uploads\/2014\/06\/Conditional01.png\" alt=\"Conditional01\" width=\"450\" height=\"348\" \/><\/p>\n<p>Klik Format &gt; Conditional Formating &gt; Condition&#8230;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2516\" src=\"http:\/\/martianuswb.com\/wp-content\/uploads\/2014\/06\/Conditional02.png\" alt=\"Conditional02\" width=\"450\" height=\"348\" \/><\/p>\n<p>Perhatikan gambar di bawah ini, pada bagian yang saya tandai. Pastikan Cell value is duplicate.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2517\" src=\"http:\/\/martianuswb.com\/wp-content\/uploads\/2014\/06\/Conditional03.png\" alt=\"Conditional03\" width=\"450\" height=\"338\" \/><\/p>\n<p>Pilih New Style&#8230; untuk membuat penanda baru bagi konten yang terduplikasi.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2518\" src=\"http:\/\/martianuswb.com\/wp-content\/uploads\/2014\/06\/Conditional04.png\" alt=\"Conditional04\" width=\"450\" height=\"338\" srcset=\"https:\/\/martianuswb.com\/wp-content\/uploads\/2014\/06\/Conditional04.png 450w, https:\/\/martianuswb.com\/wp-content\/uploads\/2014\/06\/Conditional04-300x225.png 300w, https:\/\/martianuswb.com\/wp-content\/uploads\/2014\/06\/Conditional04-150x113.png 150w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/p>\n<p>Dalam contoh ini, sel yang terduplikasi akan dibuat memiliki warna kuning. Jadi pilih tab Background, kemudian pilih warnanya. Aturannya bisa Anda buat sekehendak hati. Bisa jenis font yang dibuat berbeda, atau warna font yang dibuat berbeda, silakan saja.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2519\" src=\"http:\/\/martianuswb.com\/wp-content\/uploads\/2014\/06\/Conditional05.png\" alt=\"Conditional05\" width=\"450\" height=\"275\" \/><\/p>\n<p>Klik OK, maka bisa kita lihat hasilnya.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2520\" src=\"http:\/\/martianuswb.com\/wp-content\/uploads\/2014\/06\/Conditional06.png\" alt=\"Conditional06\" width=\"450\" height=\"348\" \/><\/p>\n<p>Sel-sel dengan isi yang sama otomatis ditandai. Mudah kan, selamat mencoba!<\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>Katakanlah kita mempunyai sebuah file .odt dengan kemungkinan ada banyak konten yang sama, ada banyak duplikasi isi sel. Apakah ada cara untuk mencari tahu yang mana saja yang terduplikasi tanpa&#8230; <a href=\"https:\/\/martianuswb.com\/?p=5209\">Read more &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[1403],"tags":[1486,1507,1548,1678,1719,1854,1859],"class_list":["post-5209","post","type-post","status-publish","format-standard","hentry","category-libreoffice","tag-calc","tag-conditional-formatting","tag-duplikat","tag-libreoffice","tag-menandai","tag-sama","tag-sel"],"_links":{"self":[{"href":"https:\/\/martianuswb.com\/index.php?rest_route=\/wp\/v2\/posts\/5209","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/martianuswb.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/martianuswb.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/martianuswb.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/martianuswb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5209"}],"version-history":[{"count":0,"href":"https:\/\/martianuswb.com\/index.php?rest_route=\/wp\/v2\/posts\/5209\/revisions"}],"wp:attachment":[{"href":"https:\/\/martianuswb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/martianuswb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/martianuswb.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}