{"action":"created","issue":{"url":"https://api.github.com/repos/Excel-DNA/ExcelDna/issues/212","repository_url":"https://api.github.com/repos/Excel-DNA/ExcelDna","labels_url":"https://api.github.com/repos/Excel-DNA/ExcelDna/issues/212/labels{/name}","comments_url":"https://api.github.com/repos/Excel-DNA/ExcelDna/issues/212/comments","events_url":"https://api.github.com/repos/Excel-DNA/ExcelDna/issues/212/events","html_url":"https://github.com/Excel-DNA/ExcelDna/issues/212","id":363618096,"node_id":"MDU6SXNzdWUzNjM2MTgwOTY=","number":212,"title":"UpdateNotify/UpdateValue not triggering Cell to update while Excel window is minimized","user":{"login":"Rand-Random","id":9868626,"node_id":"MDQ6VXNlcjk4Njg2MjY=","avatar_url":"https://avatars0.githubusercontent.com/u/9868626?v=4","gravatar_id":"","url":"https://api.github.com/users/Rand-Random","html_url":"https://github.com/Rand-Random","followers_url":"https://api.github.com/users/Rand-Random/followers","following_url":"https://api.github.com/users/Rand-Random/following{/other_user}","gists_url":"https://api.github.com/users/Rand-Random/gists{/gist_id}","starred_url":"https://api.github.com/users/Rand-Random/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Rand-Random/subscriptions","organizations_url":"https://api.github.com/users/Rand-Random/orgs","repos_url":"https://api.github.com/users/Rand-Random/repos","events_url":"https://api.github.com/users/Rand-Random/events{/privacy}","received_events_url":"https://api.github.com/users/Rand-Random/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-09-25T14:49:10Z","updated_at":"2018-09-25T19:10:55Z","closed_at":null,"author_association":"NONE","body":"Hi.\r\n\r\nThe title basically says it all, sadly we noticed today that our UpdateNotify/UpdateValue calls won't trigger the Cell to reflect those changes while the Excel window is minimized.\r\n\r\nWe tested this behaviour with different Excel Versions, and this is reproducalbe in Excel 2013/2016 in Excel 2010 it is working as expected and the values do get updated correctly.\r\n\r\nIs there a way to fix it, and let the cell update while minimized?"},"comment":{"url":"https://api.github.com/repos/Excel-DNA/ExcelDna/issues/comments/424465455","html_url":"https://github.com/Excel-DNA/ExcelDna/issues/212#issuecomment-424465455","issue_url":"https://api.github.com/repos/Excel-DNA/ExcelDna/issues/212","id":424465455,"node_id":"MDEyOklzc3VlQ29tbWVudDQyNDQ2NTQ1NQ==","user":{"login":"Rand-Random","id":9868626,"node_id":"MDQ6VXNlcjk4Njg2MjY=","avatar_url":"https://avatars0.githubusercontent.com/u/9868626?v=4","gravatar_id":"","url":"https://api.github.com/users/Rand-Random","html_url":"https://github.com/Rand-Random","followers_url":"https://api.github.com/users/Rand-Random/followers","following_url":"https://api.github.com/users/Rand-Random/following{/other_user}","gists_url":"https://api.github.com/users/Rand-Random/gists{/gist_id}","starred_url":"https://api.github.com/users/Rand-Random/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Rand-Random/subscriptions","organizations_url":"https://api.github.com/users/Rand-Random/orgs","repos_url":"https://api.github.com/users/Rand-Random/repos","events_url":"https://api.github.com/users/Rand-Random/events{/privacy}","received_events_url":"https://api.github.com/users/Rand-Random/received_events","type":"User","site_admin":false},"created_at":"2018-09-25T19:10:55Z","updated_at":"2018-09-25T19:10:55Z","author_association":"NONE","body":"Sooo….\r\n\r\nAfter finding that adding a sheet triggers the cell to update.\r\n\r\nI played around to see what else triggers the cell to update and display the new value.\r\n\r\nI basically clicked on every button that I thought \"Hey, maybe this.\" and noticed for exmple changing the View triggers it or chaning the Display ruler, grid lines, headers and so on - they all trigger the cell to update.\r\n\r\nThan, a thought came up - hey, all those have one thing in common they all update the screen.\r\n\r\nSo my current solution is just simply, \r\n\r\n```\r\nvar oldValue = xlApp.ScreenUpdating;\r\nxlApp.ScreenUpdating = !oldValue;\r\nxlApp.ScreenUpdating = oldValue;\r\n```\r\n\r\n\r\nThis works and is a way better solution than adding a random sheet.\r\n\r\nAdding a sheet also had the downside that it would fail on locked workbooks.\r\n\r\n\r\n\r\nThat the issue is a screenupdate issue also fits with this finding:\r\n![image](https://user-images.githubusercontent.com/9868626/46037033-4fa5d500-c107-11e8-98ec-25e16cccc6f2.png)\r\n\r\nNotice that in this Image the value of the cell is still 0 but the \"Example\" in cell formatting already shows the \"actual\" value of 10, so Excel already has the value but just doesnt display it correctly.\r\n\r\n"}}
{"actor":{"display_login":"Rand-Random"}}