{"action":"created","issue":{"url":"https://api.github.com/repos/gorn/rspreadsheet/issues/21","repository_url":"https://api.github.com/repos/gorn/rspreadsheet","labels_url":"https://api.github.com/repos/gorn/rspreadsheet/issues/21/labels{/name}","comments_url":"https://api.github.com/repos/gorn/rspreadsheet/issues/21/comments","events_url":"https://api.github.com/repos/gorn/rspreadsheet/issues/21/events","html_url":"https://github.com/gorn/rspreadsheet/issues/21","id":193515951,"number":21,"title":"Working with Time","user":{"login":"whitehat101","id":1093593,"avatar_url":"https://avatars.githubusercontent.com/u/1093593?v=3","gravatar_id":"","url":"https://api.github.com/users/whitehat101","html_url":"https://github.com/whitehat101","followers_url":"https://api.github.com/users/whitehat101/followers","following_url":"https://api.github.com/users/whitehat101/following{/other_user}","gists_url":"https://api.github.com/users/whitehat101/gists{/gist_id}","starred_url":"https://api.github.com/users/whitehat101/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/whitehat101/subscriptions","organizations_url":"https://api.github.com/users/whitehat101/orgs","repos_url":"https://api.github.com/users/whitehat101/repos","events_url":"https://api.github.com/users/whitehat101/events{/privacy}","received_events_url":"https://api.github.com/users/whitehat101/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-12-05T14:44:02Z","updated_at":"2016-12-05T15:08:03Z","closed_at":null,"body":"I was looking into setting a Time (without a date) value into a sheet. I couldn't find an example of this, so I set a time using a desktop app, and attempted to read it back (to ultimately figure out how to set it), and received an exception.\r\n\r\n```\r\nirb(main):005:0> sheet.C7\r\nRuntimeError: Unknown type at [7, 3] from <table:table-cell table:style-name=\"ce13\" office:value-type=\"time\" office:time-value=\"PT02H00M00S\" calcext:value-type=\"time\">\r\n  <text:p>2:00</text:p>\r\n</table:table-cell> / children size=1 / type=time\r\n  from /Users/xx/.rbenv/versions/2.3.3/lib/ruby/gems/2.3.0/gems/rspreadsheet-0.2.15/lib/rspreadsheet/cell.rb:156:in `guess_cell_type'\r\n  from /Users/xx/.rbenv/versions/2.3.3/lib/ruby/gems/2.3.0/gems/rspreadsheet-0.2.15/lib/rspreadsheet/cell.rb:55:in `value'\r\n  from /Users/xx/.rbenv/versions/2.3.3/lib/ruby/gems/2.3.0/gems/rspreadsheet-0.2.15/lib/rspreadsheet/worksheet.rb:104:in `method_missing'\r\n  from (irb):5\r\n  from /Users/xx/.rbenv/versions/2.3.3/bin/irb:11:in `<main>'\r\n```"},"comment":{"url":"https://api.github.com/repos/gorn/rspreadsheet/issues/comments/264877874","html_url":"https://github.com/gorn/rspreadsheet/issues/21#issuecomment-264877874","issue_url":"https://api.github.com/repos/gorn/rspreadsheet/issues/21","id":264877874,"user":{"login":"gorn","id":19652,"avatar_url":"https://avatars.githubusercontent.com/u/19652?v=3","gravatar_id":"","url":"https://api.github.com/users/gorn","html_url":"https://github.com/gorn","followers_url":"https://api.github.com/users/gorn/followers","following_url":"https://api.github.com/users/gorn/following{/other_user}","gists_url":"https://api.github.com/users/gorn/gists{/gist_id}","starred_url":"https://api.github.com/users/gorn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gorn/subscriptions","organizations_url":"https://api.github.com/users/gorn/orgs","repos_url":"https://api.github.com/users/gorn/repos","events_url":"https://api.github.com/users/gorn/events{/privacy}","received_events_url":"https://api.github.com/users/gorn/received_events","type":"User","site_admin":false},"created_at":"2016-12-05T15:08:03Z","updated_at":"2016-12-05T15:08:03Z","body":"@whitehat101 Thanks. I will have a look at it."}}
{"actor":{"display_login":"gorn"}}