{"action":"created","issue":{"url":"https://api.github.com/repos/roo-rb/roo/issues/139","labels_url":"https://api.github.com/repos/roo-rb/roo/issues/139/labels{/name}","comments_url":"https://api.github.com/repos/roo-rb/roo/issues/139/comments","events_url":"https://api.github.com/repos/roo-rb/roo/issues/139/events","html_url":"https://github.com/roo-rb/roo/issues/139","id":36083834,"number":139,"title":"Read the numeric field","user":{"login":"asiniy","id":1296472,"avatar_url":"https://avatars.githubusercontent.com/u/1296472?v=3","gravatar_id":"","url":"https://api.github.com/users/asiniy","html_url":"https://github.com/asiniy","followers_url":"https://api.github.com/users/asiniy/followers","following_url":"https://api.github.com/users/asiniy/following{/other_user}","gists_url":"https://api.github.com/users/asiniy/gists{/gist_id}","starred_url":"https://api.github.com/users/asiniy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/asiniy/subscriptions","organizations_url":"https://api.github.com/users/asiniy/orgs","repos_url":"https://api.github.com/users/asiniy/repos","events_url":"https://api.github.com/users/asiniy/events{/privacy}","received_events_url":"https://api.github.com/users/asiniy/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":10,"created_at":"2014-06-19T14:34:47Z","updated_at":"2015-05-21T05:22:30Z","closed_at":null,"body":"I have trouble with roo and don't know how to solve it. I need help\r\n\r\nI have a table with values like (in OpenOffice)\r\n\r\n![http://s1.postimg.org/5bdolh333/scr.png](http://s1.postimg.org/5bdolh333/scr.png)\r\n\r\n1st column is numeric. When I try to get the value from `(2,1)` I get this value without '0' value (`600000383.0` instead of `0600000383`). Is there any way to get the numeric value as string without any formatting with roo?"},"comment":{"url":"https://api.github.com/repos/roo-rb/roo/issues/comments/104140327","html_url":"https://github.com/roo-rb/roo/issues/139#issuecomment-104140327","issue_url":"https://api.github.com/repos/roo-rb/roo/issues/139","id":104140327,"user":{"login":"MrHubble","id":2251631,"avatar_url":"https://avatars.githubusercontent.com/u/2251631?v=3","gravatar_id":"","url":"https://api.github.com/users/MrHubble","html_url":"https://github.com/MrHubble","followers_url":"https://api.github.com/users/MrHubble/followers","following_url":"https://api.github.com/users/MrHubble/following{/other_user}","gists_url":"https://api.github.com/users/MrHubble/gists{/gist_id}","starred_url":"https://api.github.com/users/MrHubble/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MrHubble/subscriptions","organizations_url":"https://api.github.com/users/MrHubble/orgs","repos_url":"https://api.github.com/users/MrHubble/repos","events_url":"https://api.github.com/users/MrHubble/events{/privacy}","received_events_url":"https://api.github.com/users/MrHubble/received_events","type":"User","site_admin":false},"created_at":"2015-05-21T05:22:30Z","updated_at":"2015-05-21T05:22:30Z","body":"@nicolasgarnil I'm not sure if the fix by @emerson-h was merged, but the workaround by @andymeneely (shown below) worked for me.\r\n\r\n````\r\ncell = s.cell(row,col)\r\ncell = s.excelx_value(row,col) if s.excelx_type(row,col) == [:numeric_or_formula, \"General\"]\r\n````"}}