{"id":54276,"date":"2019-06-07T14:47:38","date_gmt":"2019-06-07T13:47:38","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/?p=54276"},"modified":"2020-11-08T10:52:49","modified_gmt":"2020-11-08T09:52:49","slug":"groene-driehoek-bij-cel","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/groene-driehoek-bij-cel\/","title":{"rendered":"Groene driehoek bij cel"},"content":{"rendered":"<p>V. Wat betekent die groene droehoek die ik soms krijg bij sommige cellen in Excel?<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-54277\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2019\/06\/xl-drdriehoeje1-300x104.png\" alt=\"\" width=\"300\" height=\"104\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2019\/06\/xl-drdriehoeje1-300x104.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2019\/06\/xl-drdriehoeje1.png 317w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>A. Klik op de knop naast de cel in kwestie om de melding te zien. Twee oorzaken komen veel voor:<\/p>\n<ul>\n<li>Je hebt een bewerking gemaakt waarvan \u00e9\u00e9n van de elementen aangrenzende cellen weglaat &#8211; meestal omwille van fouten in verwijzingen.<br \/>\nIn dit voorbeeld had de noemer vaste verwijzingen moeten hebben (dollartekens) zodat de noemer niet opschuift bij het kopi\u00ebren:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-54278\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2019\/06\/xl-drdriehoeje2-300x236.png\" alt=\"\" width=\"300\" height=\"236\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2019\/06\/xl-drdriehoeje2-300x236.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2019\/06\/xl-drdriehoeje2.png 378w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/li>\n<li>De inhoud van een cel is geen getal\u00a0 &#8211; maar Excel ziet dat het een getal zou kunnen \/ moeten zijn.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Wat betekent die groene droehoek die ik soms krijg bij sommige cellen in Excel? A. Klik op de knop naast de cel in kwestie om de melding te zien. Twee oorzaken komen veel voor: Je hebt een bewerking gemaakt waarvan \u00e9\u00e9n van de elementen aangrenzende cellen weglaat &#8211; meestal<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":34,"footnotes":""},"categories":[539,464,54,79,10],"tags":[],"class_list":["post-54276","post","type-post","status-publish","format-standard","hentry","category-berekeningen","category-ebp","category-excel","category-odisee","category-office"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 05:57:01","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/54276","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=54276"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/54276\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=54276"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=54276"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=54276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}