{"id":49742,"date":"2016-06-11T15:52:47","date_gmt":"2016-06-11T14:52:47","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=49742"},"modified":"2016-06-08T16:35:05","modified_gmt":"2016-06-08T15:35:05","slug":"rekenblad-sorteert-niet-zoals-verwacht","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/rekenblad-sorteert-niet-zoals-verwacht\/","title":{"rendered":"Rekenblad sorteert niet zoals verwacht"},"content":{"rendered":"<p>V. Examentijd, dus puntenlijsten. Maar ik zie dat de spreadsheets in Google Drive niet sorteren zoals ik verwacht. Wat kan ik doen?<\/p>\n<p>A. Ja, het kan behoorlijk tricky zijn in Google Drive.<\/p>\n<ul>\n<li>Om te beginnen moet je de te sorteren gegevens selecteren. Maar dan nog. Als je &#8216;gewoon&#8217; sorteert via Gegevens, Blad sorteren<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-49746\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2016\/06\/googledrivesort1-300x191.png\" alt=\"googledrivesort1\" width=\"300\" height=\"191\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2016\/06\/googledrivesort1-300x191.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2016\/06\/googledrivesort1.png 674w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><br \/>\nkan je niet opgeven dat je kolomkoppen of veldnamen hebt, en dan krijg je iets als:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-49745\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2016\/06\/googledrivesort1b.png\" alt=\"googledrivesort1b\" width=\"222\" height=\"122\" \/><\/li>\n<li>Je moet kiezen voor Gegevens, bereik sorteren,<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-49748\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2016\/06\/googledrivesort2-300x222.png\" alt=\"googledrivesort2\" width=\"300\" height=\"222\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2016\/06\/googledrivesort2-300x222.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2016\/06\/googledrivesort2.png 361w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><br \/>\nen aangeven dat de eerste rij berichtkoppen bevat.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-49747\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2016\/06\/googledrivesort3-300x219.png\" alt=\"googledrivesort3\" width=\"300\" height=\"219\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2016\/06\/googledrivesort3-300x219.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2016\/06\/googledrivesort3.png 362w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/li>\n<li>Overigens: in Excel is het een stuk eenvoudiger: kies voor aangepast sorteren, zeg dat de gegevens data headers hebben,<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-49744\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2016\/06\/googledrivesort4-300x138.png\" alt=\"googledrivesort4\" width=\"300\" height=\"138\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2016\/06\/googledrivesort4-300x138.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2016\/06\/googledrivesort4.png 600w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><br \/>\nen duid aan in welke volgorde je ze gesorteerd wil hebben.<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-49743\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2016\/06\/googledrivesort5-300x138.png\" alt=\"googledrivesort5\" width=\"300\" height=\"138\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2016\/06\/googledrivesort5-300x138.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2016\/06\/googledrivesort5.png 600w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><br \/>\nExcel zal je sorteervoorkeuren mee opslaan.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Examentijd, dus puntenlijsten. Maar ik zie dat de spreadsheets in Google Drive niet sorteren zoals ik verwacht. Wat kan ik doen? A. Ja, het kan behoorlijk tricky zijn in Google Drive. Om te beginnen moet je de te sorteren gegevens selecteren. Maar dan nog. Als je &#8216;gewoon&#8217; sorteert via<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":0,"footnotes":""},"categories":[464,54,375,10,160],"tags":[304],"class_list":["post-49742","post","type-post","status-publish","format-standard","hentry","category-ebp","category-excel","category-excel-office-2010","category-office","category-tabellen","tag-google-docs"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 00:21:50","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\/49742","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=49742"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/49742\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=49742"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=49742"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=49742"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}