{"action":"closed","issue":{"url":"https://api.github.com/repos/telerik/kendo-ui-core/issues/1770","repository_url":"https://api.github.com/repos/telerik/kendo-ui-core","labels_url":"https://api.github.com/repos/telerik/kendo-ui-core/issues/1770/labels{/name}","comments_url":"https://api.github.com/repos/telerik/kendo-ui-core/issues/1770/comments","events_url":"https://api.github.com/repos/telerik/kendo-ui-core/issues/1770/events","html_url":"https://github.com/telerik/kendo-ui-core/issues/1770","id":158967545,"number":1770,"title":"Difference from Excel: interpreting numeric values should be delayed until evaluation","user":{"login":"mishoo","id":334725,"avatar_url":"https://avatars.githubusercontent.com/u/334725?v=3","gravatar_id":"","url":"https://api.github.com/users/mishoo","html_url":"https://github.com/mishoo","followers_url":"https://api.github.com/users/mishoo/followers","following_url":"https://api.github.com/users/mishoo/following{/other_user}","gists_url":"https://api.github.com/users/mishoo/gists{/gist_id}","starred_url":"https://api.github.com/users/mishoo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mishoo/subscriptions","organizations_url":"https://api.github.com/users/mishoo/orgs","repos_url":"https://api.github.com/users/mishoo/repos","events_url":"https://api.github.com/users/mishoo/events{/privacy}","received_events_url":"https://api.github.com/users/mishoo/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/telerik/kendo-ui-core/labels/Bug","name":"Bug","color":"e10c02"},{"url":"https://api.github.com/repos/telerik/kendo-ui-core/labels/C:%20Spreadsheet","name":"C: Spreadsheet","color":"444444"},{"url":"https://api.github.com/repos/telerik/kendo-ui-core/labels/SEV:%20Medium","name":"SEV: Medium","color":"FF9999"}],"state":"closed","locked":false,"assignee":{"login":"mishoo","id":334725,"avatar_url":"https://avatars.githubusercontent.com/u/334725?v=3","gravatar_id":"","url":"https://api.github.com/users/mishoo","html_url":"https://github.com/mishoo","followers_url":"https://api.github.com/users/mishoo/followers","following_url":"https://api.github.com/users/mishoo/following{/other_user}","gists_url":"https://api.github.com/users/mishoo/gists{/gist_id}","starred_url":"https://api.github.com/users/mishoo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mishoo/subscriptions","organizations_url":"https://api.github.com/users/mishoo/orgs","repos_url":"https://api.github.com/users/mishoo/repos","events_url":"https://api.github.com/users/mishoo/events{/privacy}","received_events_url":"https://api.github.com/users/mishoo/received_events","type":"User","site_admin":false},"milestone":null,"comments":0,"created_at":"2016-06-07T16:28:40Z","updated_at":"2016-06-10T10:02:38Z","closed_at":"2016-06-10T10:02:38Z","body":"Example (Excel): if you type in `A1`: `'1/2/2016`, the string `1/2/2016` will be stored as value.  Then if you type in `B1`: `=A1+1`, instead of getting a `#VALUE!` error (which is what we return when adding a string to a number), you get `42372` because Excel parses the string as numeric representation of the date, *at formula evaluation time*.\r\n\r\nMore directly stated, Excel is able to evaluate this formula: `=\"1/2/2016\" + 1` (returns `42372`), whereas we return a `#VALUE!` error."}}
{"actor":{"display_login":"mishoo"}}