{"action":"opened","number":41,"pull_request":{"url":"https://api.github.com/repos/hadley/readxl/pulls/41","id":32144046,"html_url":"https://github.com/hadley/readxl/pull/41","diff_url":"https://github.com/hadley/readxl/pull/41.diff","patch_url":"https://github.com/hadley/readxl/pull/41.patch","issue_url":"https://api.github.com/repos/hadley/readxl/issues/41","number":41,"state":"open","locked":false,"title":"Combine all rich-text formatted substrings when reading the string table (#39)","user":{"login":"jmarshallnz","id":406571,"avatar_url":"https://avatars.githubusercontent.com/u/406571?v=3","gravatar_id":"","url":"https://api.github.com/users/jmarshallnz","html_url":"https://github.com/jmarshallnz","followers_url":"https://api.github.com/users/jmarshallnz/followers","following_url":"https://api.github.com/users/jmarshallnz/following{/other_user}","gists_url":"https://api.github.com/users/jmarshallnz/gists{/gist_id}","starred_url":"https://api.github.com/users/jmarshallnz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmarshallnz/subscriptions","organizations_url":"https://api.github.com/users/jmarshallnz/orgs","repos_url":"https://api.github.com/users/jmarshallnz/repos","events_url":"https://api.github.com/users/jmarshallnz/events{/privacy}","received_events_url":"https://api.github.com/users/jmarshallnz/received_events","type":"User","site_admin":false},"body":"Ensures all separately formatted substrings in a cell are concatenated together as the CT_RElt cell type specifies.\r\n\r\nFixes issue with the spreadsheet here for example:\r\n\r\nhttps://dl.dropboxusercontent.com/u/41868071/Results%20Plate%20SF325.xlsx\r\n\r\nI suspect that strings specified inline (rather than in the stringtable) can also have similar richtext formatting, but haven't seen any such sheets.","created_at":"2015-03-27T20:54:14Z","updated_at":"2015-03-27T20:54:14Z","closed_at":null,"merged_at":null,"merge_commit_sha":null,"assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/hadley/readxl/pulls/41/commits","review_comments_url":"https://api.github.com/repos/hadley/readxl/pulls/41/comments","review_comment_url":"https://api.github.com/repos/hadley/readxl/pulls/comments{/number}","comments_url":"https://api.github.com/repos/hadley/readxl/issues/41/comments","statuses_url":"https://api.github.com/repos/hadley/readxl/statuses/bacf8a4c972c2489d4893100e121f085139e4377","head":{"label":"jmarshallnz:issue39","ref":"issue39","sha":"bacf8a4c972c2489d4893100e121f085139e4377","user":{"login":"jmarshallnz","id":406571,"avatar_url":"https://avatars.githubusercontent.com/u/406571?v=3","gravatar_id":"","url":"https://api.github.com/users/jmarshallnz","html_url":"https://github.com/jmarshallnz","followers_url":"https://api.github.com/users/jmarshallnz/followers","following_url":"https://api.github.com/users/jmarshallnz/following{/other_user}","gists_url":"https://api.github.com/users/jmarshallnz/gists{/gist_id}","starred_url":"https://api.github.com/users/jmarshallnz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmarshallnz/subscriptions","organizations_url":"https://api.github.com/users/jmarshallnz/orgs","repos_url":"https://api.github.com/users/jmarshallnz/repos","events_url":"https://api.github.com/users/jmarshallnz/events{/privacy}","received_events_url":"https://api.github.com/users/jmarshallnz/received_events","type":"User","site_admin":false},"repo":{"id":33007109,"name":"readxl","full_name":"jmarshallnz/readxl","owner":{"login":"jmarshallnz","id":406571,"avatar_url":"https://avatars.githubusercontent.com/u/406571?v=3","gravatar_id":"","url":"https://api.github.com/users/jmarshallnz","html_url":"https://github.com/jmarshallnz","followers_url":"https://api.github.com/users/jmarshallnz/followers","following_url":"https://api.github.com/users/jmarshallnz/following{/other_user}","gists_url":"https://api.github.com/users/jmarshallnz/gists{/gist_id}","starred_url":"https://api.github.com/users/jmarshallnz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmarshallnz/subscriptions","organizations_url":"https://api.github.com/users/jmarshallnz/orgs","repos_url":"https://api.github.com/users/jmarshallnz/repos","events_url":"https://api.github.com/users/jmarshallnz/events{/privacy}","received_events_url":"https://api.github.com/users/jmarshallnz/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/jmarshallnz/readxl","description":"Read excel files (.xls and .xlsx) into R","fork":true,"url":"https://api.github.com/repos/jmarshallnz/readxl","forks_url":"https://api.github.com/repos/jmarshallnz/readxl/forks","keys_url":"https://api.github.com/repos/jmarshallnz/readxl/keys{/key_id}","collaborators_url":"https://api.github.com/repos/jmarshallnz/readxl/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/jmarshallnz/readxl/teams","hooks_url":"https://api.github.com/repos/jmarshallnz/readxl/hooks","issue_events_url":"https://api.github.com/repos/jmarshallnz/readxl/issues/events{/number}","events_url":"https://api.github.com/repos/jmarshallnz/readxl/events","assignees_url":"https://api.github.com/repos/jmarshallnz/readxl/assignees{/user}","branches_url":"https://api.github.com/repos/jmarshallnz/readxl/branches{/branch}","tags_url":"https://api.github.com/repos/jmarshallnz/readxl/tags","blobs_url":"https://api.github.com/repos/jmarshallnz/readxl/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/jmarshallnz/readxl/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/jmarshallnz/readxl/git/refs{/sha}","trees_url":"https://api.github.com/repos/jmarshallnz/readxl/git/trees{/sha}","statuses_url":"https://api.github.com/repos/jmarshallnz/readxl/statuses/{sha}","languages_url":"https://api.github.com/repos/jmarshallnz/readxl/languages","stargazers_url":"https://api.github.com/repos/jmarshallnz/readxl/stargazers","contributors_url":"https://api.github.com/repos/jmarshallnz/readxl/contributors","subscribers_url":"https://api.github.com/repos/jmarshallnz/readxl/subscribers","subscription_url":"https://api.github.com/repos/jmarshallnz/readxl/subscription","commits_url":"https://api.github.com/repos/jmarshallnz/readxl/commits{/sha}","git_commits_url":"https://api.github.com/repos/jmarshallnz/readxl/git/commits{/sha}","comments_url":"https://api.github.com/repos/jmarshallnz/readxl/comments{/number}","issue_comment_url":"https://api.github.com/repos/jmarshallnz/readxl/issues/comments{/number}","contents_url":"https://api.github.com/repos/jmarshallnz/readxl/contents/{+path}","compare_url":"https://api.github.com/repos/jmarshallnz/readxl/compare/{base}...{head}","merges_url":"https://api.github.com/repos/jmarshallnz/readxl/merges","archive_url":"https://api.github.com/repos/jmarshallnz/readxl/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/jmarshallnz/readxl/downloads","issues_url":"https://api.github.com/repos/jmarshallnz/readxl/issues{/number}","pulls_url":"https://api.github.com/repos/jmarshallnz/readxl/pulls{/number}","milestones_url":"https://api.github.com/repos/jmarshallnz/readxl/milestones{/number}","notifications_url":"https://api.github.com/repos/jmarshallnz/readxl/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/jmarshallnz/readxl/labels{/name}","releases_url":"https://api.github.com/repos/jmarshallnz/readxl/releases{/id}","created_at":"2015-03-27T20:14:07Z","updated_at":"2015-03-27T20:51:12Z","pushed_at":"2015-03-27T20:51:57Z","git_url":"git://github.com/jmarshallnz/readxl.git","ssh_url":"git@github.com:jmarshallnz/readxl.git","clone_url":"https://github.com/jmarshallnz/readxl.git","svn_url":"https://github.com/jmarshallnz/readxl","homepage":null,"size":753,"stargazers_count":0,"watchers_count":0,"language":"C++","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"hadley:master","ref":"master","sha":"959feb39189bef4464d1296a9bd908079204d537","user":{"login":"hadley","id":4196,"avatar_url":"https://avatars.githubusercontent.com/u/4196?v=3","gravatar_id":"","url":"https://api.github.com/users/hadley","html_url":"https://github.com/hadley","followers_url":"https://api.github.com/users/hadley/followers","following_url":"https://api.github.com/users/hadley/following{/other_user}","gists_url":"https://api.github.com/users/hadley/gists{/gist_id}","starred_url":"https://api.github.com/users/hadley/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hadley/subscriptions","organizations_url":"https://api.github.com/users/hadley/orgs","repos_url":"https://api.github.com/users/hadley/repos","events_url":"https://api.github.com/users/hadley/events{/privacy}","received_events_url":"https://api.github.com/users/hadley/received_events","type":"User","site_admin":false},"repo":{"id":32161666,"name":"readxl","full_name":"hadley/readxl","owner":{"login":"hadley","id":4196,"avatar_url":"https://avatars.githubusercontent.com/u/4196?v=3","gravatar_id":"","url":"https://api.github.com/users/hadley","html_url":"https://github.com/hadley","followers_url":"https://api.github.com/users/hadley/followers","following_url":"https://api.github.com/users/hadley/following{/other_user}","gists_url":"https://api.github.com/users/hadley/gists{/gist_id}","starred_url":"https://api.github.com/users/hadley/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hadley/subscriptions","organizations_url":"https://api.github.com/users/hadley/orgs","repos_url":"https://api.github.com/users/hadley/repos","events_url":"https://api.github.com/users/hadley/events{/privacy}","received_events_url":"https://api.github.com/users/hadley/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/hadley/readxl","description":"Read excel files (.xls and .xlsx) into R","fork":false,"url":"https://api.github.com/repos/hadley/readxl","forks_url":"https://api.github.com/repos/hadley/readxl/forks","keys_url":"https://api.github.com/repos/hadley/readxl/keys{/key_id}","collaborators_url":"https://api.github.com/repos/hadley/readxl/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/hadley/readxl/teams","hooks_url":"https://api.github.com/repos/hadley/readxl/hooks","issue_events_url":"https://api.github.com/repos/hadley/readxl/issues/events{/number}","events_url":"https://api.github.com/repos/hadley/readxl/events","assignees_url":"https://api.github.com/repos/hadley/readxl/assignees{/user}","branches_url":"https://api.github.com/repos/hadley/readxl/branches{/branch}","tags_url":"https://api.github.com/repos/hadley/readxl/tags","blobs_url":"https://api.github.com/repos/hadley/readxl/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/hadley/readxl/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/hadley/readxl/git/refs{/sha}","trees_url":"https://api.github.com/repos/hadley/readxl/git/trees{/sha}","statuses_url":"https://api.github.com/repos/hadley/readxl/statuses/{sha}","languages_url":"https://api.github.com/repos/hadley/readxl/languages","stargazers_url":"https://api.github.com/repos/hadley/readxl/stargazers","contributors_url":"https://api.github.com/repos/hadley/readxl/contributors","subscribers_url":"https://api.github.com/repos/hadley/readxl/subscribers","subscription_url":"https://api.github.com/repos/hadley/readxl/subscription","commits_url":"https://api.github.com/repos/hadley/readxl/commits{/sha}","git_commits_url":"https://api.github.com/repos/hadley/readxl/git/commits{/sha}","comments_url":"https://api.github.com/repos/hadley/readxl/comments{/number}","issue_comment_url":"https://api.github.com/repos/hadley/readxl/issues/comments{/number}","contents_url":"https://api.github.com/repos/hadley/readxl/contents/{+path}","compare_url":"https://api.github.com/repos/hadley/readxl/compare/{base}...{head}","merges_url":"https://api.github.com/repos/hadley/readxl/merges","archive_url":"https://api.github.com/repos/hadley/readxl/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/hadley/readxl/downloads","issues_url":"https://api.github.com/repos/hadley/readxl/issues{/number}","pulls_url":"https://api.github.com/repos/hadley/readxl/pulls{/number}","milestones_url":"https://api.github.com/repos/hadley/readxl/milestones{/number}","notifications_url":"https://api.github.com/repos/hadley/readxl/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/hadley/readxl/labels{/name}","releases_url":"https://api.github.com/repos/hadley/readxl/releases{/id}","created_at":"2015-03-13T14:50:20Z","updated_at":"2015-03-27T15:48:21Z","pushed_at":"2015-03-27T20:54:14Z","git_url":"git://github.com/hadley/readxl.git","ssh_url":"git@github.com:hadley/readxl.git","clone_url":"https://github.com/hadley/readxl.git","svn_url":"https://github.com/hadley/readxl","homepage":null,"size":753,"stargazers_count":103,"watchers_count":103,"language":"C++","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":13,"mirror_url":null,"open_issues_count":13,"forks":13,"open_issues":13,"watchers":103,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/hadley/readxl/pulls/41"},"html":{"href":"https://github.com/hadley/readxl/pull/41"},"issue":{"href":"https://api.github.com/repos/hadley/readxl/issues/41"},"comments":{"href":"https://api.github.com/repos/hadley/readxl/issues/41/comments"},"review_comments":{"href":"https://api.github.com/repos/hadley/readxl/pulls/41/comments"},"review_comment":{"href":"https://api.github.com/repos/hadley/readxl/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/hadley/readxl/pulls/41/commits"},"statuses":{"href":"https://api.github.com/repos/hadley/readxl/statuses/bacf8a4c972c2489d4893100e121f085139e4377"}},"merged":false,"mergeable":null,"mergeable_state":"unknown","merged_by":null,"comments":0,"review_comments":0,"commits":1,"additions":8,"deletions":4,"changed_files":1}}