{"action":"created","issue":{"url":"https://api.github.com/repos/Excel-DNA/ExcelDna/issues/84","repository_url":"https://api.github.com/repos/Excel-DNA/ExcelDna","labels_url":"https://api.github.com/repos/Excel-DNA/ExcelDna/issues/84/labels{/name}","comments_url":"https://api.github.com/repos/Excel-DNA/ExcelDna/issues/84/comments","events_url":"https://api.github.com/repos/Excel-DNA/ExcelDna/issues/84/events","html_url":"https://github.com/Excel-DNA/ExcelDna/issues/84","id":160267096,"number":84,"title":"Volatile function recalculation inside a reference passed to non-volatile func doesn't trigger UDF recalculate","user":{"login":"buybackoff","id":489852,"avatar_url":"https://avatars.githubusercontent.com/u/489852?v=3","gravatar_id":"","url":"https://api.github.com/users/buybackoff","html_url":"https://github.com/buybackoff","followers_url":"https://api.github.com/users/buybackoff/followers","following_url":"https://api.github.com/users/buybackoff/following{/other_user}","gists_url":"https://api.github.com/users/buybackoff/gists{/gist_id}","starred_url":"https://api.github.com/users/buybackoff/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/buybackoff/subscriptions","organizations_url":"https://api.github.com/users/buybackoff/orgs","repos_url":"https://api.github.com/users/buybackoff/repos","events_url":"https://api.github.com/users/buybackoff/events{/privacy}","received_events_url":"https://api.github.com/users/buybackoff/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":13,"created_at":"2016-06-14T19:44:08Z","updated_at":"2016-06-19T16:29:40Z","closed_at":null,"body":"If I pass a range to my non-volatile UDF and set `allowReference = true`, and then inside that range I have a volatile function, e.g. RAND(), then my non-volatile UDF is not recalculated when RAND() is recalculated. If `allowReference = false`, then recalculation is triggered as expected. Is it a bug or feature? I want to avoid turning my UDFs into volatile functions, but I miss data updates with the current behavior."},"comment":{"url":"https://api.github.com/repos/Excel-DNA/ExcelDna/issues/comments/227006440","html_url":"https://github.com/Excel-DNA/ExcelDna/issues/84#issuecomment-227006440","issue_url":"https://api.github.com/repos/Excel-DNA/ExcelDna/issues/84","id":227006440,"user":{"login":"buybackoff","id":489852,"avatar_url":"https://avatars.githubusercontent.com/u/489852?v=3","gravatar_id":"","url":"https://api.github.com/users/buybackoff","html_url":"https://github.com/buybackoff","followers_url":"https://api.github.com/users/buybackoff/followers","following_url":"https://api.github.com/users/buybackoff/following{/other_user}","gists_url":"https://api.github.com/users/buybackoff/gists{/gist_id}","starred_url":"https://api.github.com/users/buybackoff/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/buybackoff/subscriptions","organizations_url":"https://api.github.com/users/buybackoff/orgs","repos_url":"https://api.github.com/users/buybackoff/repos","events_url":"https://api.github.com/users/buybackoff/events{/privacy}","received_events_url":"https://api.github.com/users/buybackoff/received_events","type":"User","site_admin":false},"created_at":"2016-06-19T16:29:40Z","updated_at":"2016-06-19T16:29:40Z","body":"With `AllowReference=false` and with processing the input I had the same function working properly. My conclusion is just to avoid using `IsMacroType=true`, not sure if that is an issue or a feature..."}}
{"actor":{"display_login":"buybackoff"}}