dear fendik,
saran saya coba buka data yang anda input di open office dengan excel 2003
keatas alias excel 2007 atau yang terbaru. karena excel 2003 atau yang
terdahulunya masih sangat membatasi penggunaan fungsi IF. dan coba save As
dengan extensi .xlsx
untuk conditional formating sepertinya hanya kondisi yang sangat sederhana saja
yang mampu di baca oleh kedua jenis spradsheet tersebut, dan saran saya apa
bila anda bersih kukuh untuk menggunakan aplikasi gratis, dalam hal ini
spradsheet open office, maka gunakan WPS office / kingsoft office versi
terbaru, karena aplikasi gratis yang paling mendekati excel sepanjang
pengalaman saya ya hanya WPS office / kingsoft office. memang tidak semua
conditional formating yang di buat pada spredsheet WPS office / kingsoft office
dapat di buka dengan sempurna dengan excel, tapi saya yakin, bila kasusnya
seperti yang pak fendik lampirkan tersebet maka pembuatan conditional formating
pada WPS office / kingsoft office dapat dibuka dengan sempurna di excel pak
fendik.
note : aplikasi grasit WPS office / kingsoft office, tidak mendukung VBA macro.
thx,
odong nando
Pada Rabu, 12 Agustus 2015 18:49, "'Fendik Anton Wijaya'
[email protected] [belajar-excel]" <[email protected]>
menulis:
Dear Para suhu, Assalamuallaikum wr.wb. Mohon penjelasan & pencerahannya
kenapa ya database saya open office saat saya buka pake excel malah ada rumus
yg g kebaca...Jadi ada yg error atau #NA() dan kalo saya copy paste kan
rumusnya dari open office ke excel kebaca #value!... Trus rumus formula
conditional formatting saya jg berantakan saat database saya buka di
excel...Jadi saat data itu saya buka pake open office formula conditional
formating baik2 saja tpi saat saya buka pake excel malah g ngebaca
formulanya... Berikut terlampir database dlm excel & open office... Mohon
bantuannya Master... Terima kasih atas bantuan & pencerahannya para master...
Best regards,
Fendik Anton Wijaya
The information transmitted is intended only for the person or the entity to
which it is addressed and may contain confidential and/or privileged material.
If you have received it by mistake please notify the sender by return e-mail
and delete this message including any of its attachments from your system. Any
use, review, reliance or dissemination of this message/information in whole or
in part is strictly prohibited. Please note that e-mails are susceptible to
change. The views expressed/presented in this email are solely those of the
author and do not necessarily represent those of PT Toyota Astra Financial
Services and should not be construed as the views, offers or acceptances of PT
Toyota Astra Financial Services. The recipient should check this email/message
and any attachments for the presence of viruses. PT Toyota Astra Financial
Services accepts no liability for any damage caused by any viruses transmitted
by this email/message.
ýTowards a Sustainable Future - Please consider the environment before printing
this email.
#yiv7821588143 #yiv7821588143 -- #yiv7821588143ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7821588143
#yiv7821588143ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7821588143
#yiv7821588143ygrp-mkp #yiv7821588143hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7821588143 #yiv7821588143ygrp-mkp #yiv7821588143ads
{margin-bottom:10px;}#yiv7821588143 #yiv7821588143ygrp-mkp .yiv7821588143ad
{padding:0 0;}#yiv7821588143 #yiv7821588143ygrp-mkp .yiv7821588143ad p
{margin:0;}#yiv7821588143 #yiv7821588143ygrp-mkp .yiv7821588143ad a
{color:#0000ff;text-decoration:none;}#yiv7821588143 #yiv7821588143ygrp-sponsor
#yiv7821588143ygrp-lc {font-family:Arial;}#yiv7821588143
#yiv7821588143ygrp-sponsor #yiv7821588143ygrp-lc #yiv7821588143hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7821588143
#yiv7821588143ygrp-sponsor #yiv7821588143ygrp-lc .yiv7821588143ad
{margin-bottom:10px;padding:0 0;}#yiv7821588143 #yiv7821588143actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7821588143
#yiv7821588143activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7821588143
#yiv7821588143activity span {font-weight:700;}#yiv7821588143
#yiv7821588143activity span:first-child
{text-transform:uppercase;}#yiv7821588143 #yiv7821588143activity span a
{color:#5085b6;text-decoration:none;}#yiv7821588143 #yiv7821588143activity span
span {color:#ff7900;}#yiv7821588143 #yiv7821588143activity span
.yiv7821588143underline {text-decoration:underline;}#yiv7821588143
.yiv7821588143attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7821588143 .yiv7821588143attach div a
{text-decoration:none;}#yiv7821588143 .yiv7821588143attach img
{border:none;padding-right:5px;}#yiv7821588143 .yiv7821588143attach label
{display:block;margin-bottom:5px;}#yiv7821588143 .yiv7821588143attach label a
{text-decoration:none;}#yiv7821588143 blockquote {margin:0 0 0
4px;}#yiv7821588143 .yiv7821588143bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7821588143
.yiv7821588143bold a {text-decoration:none;}#yiv7821588143 dd.yiv7821588143last
p a {font-family:Verdana;font-weight:700;}#yiv7821588143 dd.yiv7821588143last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7821588143
dd.yiv7821588143last p span.yiv7821588143yshortcuts
{margin-right:0;}#yiv7821588143 div.yiv7821588143attach-table div div a
{text-decoration:none;}#yiv7821588143 div.yiv7821588143attach-table
{width:400px;}#yiv7821588143 div.yiv7821588143file-title a, #yiv7821588143
div.yiv7821588143file-title a:active, #yiv7821588143
div.yiv7821588143file-title a:hover, #yiv7821588143 div.yiv7821588143file-title
a:visited {text-decoration:none;}#yiv7821588143 div.yiv7821588143photo-title a,
#yiv7821588143 div.yiv7821588143photo-title a:active, #yiv7821588143
div.yiv7821588143photo-title a:hover, #yiv7821588143
div.yiv7821588143photo-title a:visited {text-decoration:none;}#yiv7821588143
div#yiv7821588143ygrp-mlmsg #yiv7821588143ygrp-msg p a
span.yiv7821588143yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7821588143
.yiv7821588143green {color:#628c2a;}#yiv7821588143 .yiv7821588143MsoNormal
{margin:0 0 0 0;}#yiv7821588143 o {font-size:0;}#yiv7821588143
#yiv7821588143photos div {float:left;width:72px;}#yiv7821588143
#yiv7821588143photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7821588143
#yiv7821588143photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7821588143
#yiv7821588143reco-category {font-size:77%;}#yiv7821588143
#yiv7821588143reco-desc {font-size:77%;}#yiv7821588143 .yiv7821588143replbq
{margin:4px;}#yiv7821588143 #yiv7821588143ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7821588143 #yiv7821588143ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7821588143
#yiv7821588143ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7821588143
#yiv7821588143ygrp-mlmsg select, #yiv7821588143 input, #yiv7821588143 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7821588143
#yiv7821588143ygrp-mlmsg pre, #yiv7821588143 code {font:115%
monospace;}#yiv7821588143 #yiv7821588143ygrp-mlmsg *
{line-height:1.22em;}#yiv7821588143 #yiv7821588143ygrp-mlmsg #yiv7821588143logo
{padding-bottom:10px;}#yiv7821588143 #yiv7821588143ygrp-msg p a
{font-family:Verdana;}#yiv7821588143 #yiv7821588143ygrp-msg
p#yiv7821588143attach-count span {color:#1E66AE;font-weight:700;}#yiv7821588143
#yiv7821588143ygrp-reco #yiv7821588143reco-head
{color:#ff7900;font-weight:700;}#yiv7821588143 #yiv7821588143ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7821588143 #yiv7821588143ygrp-sponsor
#yiv7821588143ov li a {font-size:130%;text-decoration:none;}#yiv7821588143
#yiv7821588143ygrp-sponsor #yiv7821588143ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7821588143
#yiv7821588143ygrp-sponsor #yiv7821588143ov ul {margin:0;padding:0 0 0
8px;}#yiv7821588143 #yiv7821588143ygrp-text
{font-family:Georgia;}#yiv7821588143 #yiv7821588143ygrp-text p {margin:0 0 1em
0;}#yiv7821588143 #yiv7821588143ygrp-text tt {font-size:120%;}#yiv7821588143
#yiv7821588143ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7821588143
