{"id":362,"date":"2011-04-15T14:47:21","date_gmt":"2011-04-15T14:47:21","guid":{"rendered":"http:\/\/www.ericwhite.com\/home2\/bm8qcmjy\/public_html\/blog\/?p=362"},"modified":"2018-06-01T02:15:20","modified_gmt":"2018-06-01T02:15:20","slug":"creating-an-open-xml-protected-spreadsheet-with-locked-and-unlocked-cells","status":"publish","type":"post","link":"https:\/\/www.ericwhite.com\/blog\/2011\/04\/15\/creating-an-open-xml-protected-spreadsheet-with-locked-and-unlocked-cells\/","title":{"rendered":"Creating an Open XML Protected Spreadsheet with Locked and Unlocked Cells"},"content":{"rendered":"<p>Today, in response to a question at OpenXMLDeveloper.org, I put together a 7 minute screen-cast that shows how to create a protected spreadsheet with locked and unlocked cells.\u00a0 Similar to the screen-cast that I presented in <a href=\"https:\/\/www.ericwhite.com\/blog\/2011\/04\/01\/how-to-research-open-xml-markup\/\" target=\"_blank\">How to Research Open XML Markup<\/a>, this screen-cast also is a good example of the approach that I take to research Open XML markup.<\/p>\n<div id=\"scid:5737277B-5D6D-4f48-ABFC-DD9C333F4C5D:66d7d0cb-a13c-493c-82ce-62cc5f5ba75d\" class=\"wlWriterEditableSmartContent\" style=\"margin: 0px; display: inline; float: none; padding: 0px;\">\n<div><object classid=\"clsid:d27cdb6e-ae6d-11cf-96b8-444553540000\" width=\"448\" height=\"252\" codebase=\"http:\/\/download.macromedia.com\/pub\/shockwave\/cabs\/flash\/swflash.cab#version=6,0,40,0\"><param name=\"src\" value=\"http:\/\/www.youtube.com\/v\/KN2Q0vWMd8k?hl=en&amp;hd=1\" \/><embed type=\"application\/x-shockwave-flash\" width=\"448\" height=\"252\" src=\"http:\/\/www.youtube.com\/v\/KN2Q0vWMd8k?hl=en&amp;hd=1\"><\/embed><\/object><\/div>\n<div style=\"width: 448px; clear: both; font-size: .8em;\">Explores the markup necessary to create a protected spreadsheet with locked and unlocked cells.<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Explores the Open XML markup necessary to create an protected spreadsheet with locked and unlocked cells.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_s2mail":"","footnotes":""},"categories":[3,11],"tags":[],"class_list":["post-362","post","type-post","status-publish","format-standard","hentry","category-open-xml","category-spreadsheetml"],"_links":{"self":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/posts\/362","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/comments?post=362"}],"version-history":[{"count":2,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/posts\/362\/revisions"}],"predecessor-version":[{"id":7347,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/posts\/362\/revisions\/7347"}],"wp:attachment":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/media?parent=362"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/categories?post=362"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/tags?post=362"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}