{"action":"created","issue":{"url":"https://api.github.com/repos/jmcnamara/XlsxWriter/issues/218","labels_url":"https://api.github.com/repos/jmcnamara/XlsxWriter/issues/218/labels{/name}","comments_url":"https://api.github.com/repos/jmcnamara/XlsxWriter/issues/218/comments","events_url":"https://api.github.com/repos/jmcnamara/XlsxWriter/issues/218/events","html_url":"https://github.com/jmcnamara/XlsxWriter/issues/218","id":56327938,"number":218,"title":"Data validation being overwritten on paste","user":{"login":"richiverse","id":2671102,"avatar_url":"https://avatars.githubusercontent.com/u/2671102?v=3","gravatar_id":"","url":"https://api.github.com/users/richiverse","html_url":"https://github.com/richiverse","followers_url":"https://api.github.com/users/richiverse/followers","following_url":"https://api.github.com/users/richiverse/following{/other_user}","gists_url":"https://api.github.com/users/richiverse/gists{/gist_id}","starred_url":"https://api.github.com/users/richiverse/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/richiverse/subscriptions","organizations_url":"https://api.github.com/users/richiverse/orgs","repos_url":"https://api.github.com/users/richiverse/repos","events_url":"https://api.github.com/users/richiverse/events{/privacy}","received_events_url":"https://api.github.com/users/richiverse/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/jmcnamara/XlsxWriter/labels/question","name":"question","color":"cc317c"},{"url":"https://api.github.com/repos/jmcnamara/XlsxWriter/labels/ready%20to%20close","name":"ready to close","color":"bfe5bf"}],"state":"open","locked":false,"assignee":{"login":"jmcnamara","id":94267,"avatar_url":"https://avatars.githubusercontent.com/u/94267?v=3","gravatar_id":"","url":"https://api.github.com/users/jmcnamara","html_url":"https://github.com/jmcnamara","followers_url":"https://api.github.com/users/jmcnamara/followers","following_url":"https://api.github.com/users/jmcnamara/following{/other_user}","gists_url":"https://api.github.com/users/jmcnamara/gists{/gist_id}","starred_url":"https://api.github.com/users/jmcnamara/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmcnamara/subscriptions","organizations_url":"https://api.github.com/users/jmcnamara/orgs","repos_url":"https://api.github.com/users/jmcnamara/repos","events_url":"https://api.github.com/users/jmcnamara/events{/privacy}","received_events_url":"https://api.github.com/users/jmcnamara/received_events","type":"User","site_admin":false},"milestone":null,"comments":3,"created_at":"2015-02-03T03:11:08Z","updated_at":"2015-02-03T17:25:20Z","closed_at":null,"body":"Awesome tool, btw. Super useful!\r\n\r\nSo I built a pretty decent \"excel form\" loaded with data validation. The problem is that when users copy a range and paste in others, they end up overwriting the validation. I've looked around for VBA workarounds to ensure:\r\n1) validation rules can't be modified from the cells in which they are set.\r\n2) validation is still applied on the targeted cells. So paste only works for values which pass validation and leave cells blank where they don't.\r\n\r\nAny ideas on how to proceed on this?"},"comment":{"url":"https://api.github.com/repos/jmcnamara/XlsxWriter/issues/comments/72694021","html_url":"https://github.com/jmcnamara/XlsxWriter/issues/218#issuecomment-72694021","issue_url":"https://api.github.com/repos/jmcnamara/XlsxWriter/issues/218","id":72694021,"user":{"login":"jmcnamara","id":94267,"avatar_url":"https://avatars.githubusercontent.com/u/94267?v=3","gravatar_id":"","url":"https://api.github.com/users/jmcnamara","html_url":"https://github.com/jmcnamara","followers_url":"https://api.github.com/users/jmcnamara/followers","following_url":"https://api.github.com/users/jmcnamara/following{/other_user}","gists_url":"https://api.github.com/users/jmcnamara/gists{/gist_id}","starred_url":"https://api.github.com/users/jmcnamara/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmcnamara/subscriptions","organizations_url":"https://api.github.com/users/jmcnamara/orgs","repos_url":"https://api.github.com/users/jmcnamara/repos","events_url":"https://api.github.com/users/jmcnamara/events{/privacy}","received_events_url":"https://api.github.com/users/jmcnamara/received_events","type":"User","site_admin":false},"created_at":"2015-02-03T17:25:20Z","updated_at":"2015-02-03T17:25:20Z","body":"Hi Richard,\r\n\r\n> well the problem is the cell can't be locked because it needs data entered into it.\r\n\r\nSo not an XlsxWriter issues then?\r\n\r\nJohn\r\n"}}