{"id":1641,"date":"2020-10-11T21:21:24","date_gmt":"2020-10-12T02:21:24","guid":{"rendered":"http:\/\/xlfxs.com\/?p=1641"},"modified":"2020-10-11T21:21:24","modified_gmt":"2020-10-12T02:21:24","slug":"lesson-learned-do-not-trust-google-sheets-function","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=1641","title":{"rendered":"Lesson learned: Do not trust Google Sheets function"},"content":{"rendered":"\n<p>It wasted few days, hitting my head at the wall.<br>My mistake &#8230;.<\/p>\n\n\n\n<p>I trusted that Google Sheets function called GoogleTranslate is working as it is expected.<\/p>\n\n\n\n<p class=\"has-large-font-size\"><strong>Which is not<\/strong><\/p>\n\n\n\n<p>You just hate when that happens.<br>We all know that Google is still a child in worksheet world, comparing to Microsoft, they are kids, but I wouldn&#8217;t expect a large company like Google to mess up a formula that made it available to public. not good Google, not good.<\/p>\n\n\n\n<p>Again, googletranslate that is supposed to change the date from Europe format into US format is not working, do not build on that<\/p>\n","protected":false},"excerpt":{"rendered":"<p>It wasted few days, hitting my head at the wall.My mistake &#8230;. I trusted that Google Sheets function called GoogleTranslate is working as it is expected. Which is not You just hate when that happens.We all know that Google is still a child in worksheet world, comparing to Microsoft, they are kids, but I wouldn&#8217;t&#8230;<\/p>\n<p class=\"more-link-wrap\"><a href=\"https:\/\/xlfxs.com\/?p=1641\" class=\"more-link\">Read More<span class=\"screen-reader-text\"> &ldquo;Lesson learned: Do not trust Google Sheets function&rdquo;<\/span> &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":1642,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,12],"tags":[121,128,140,142,199,202],"class_list":["post-1641","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets","category-worksheet","tag-date","tag-eu","tag-google","tag-googletranslate","tag-translate","tag-us"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1641","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1641"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1641\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/1642"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1641"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1641"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1641"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}