{"action":"opened","issue":{"url":"https://api.github.com/repos/dragua/xlsx/issues/75","repository_url":"https://api.github.com/repos/dragua/xlsx","labels_url":"https://api.github.com/repos/dragua/xlsx/issues/75/labels{/name}","comments_url":"https://api.github.com/repos/dragua/xlsx/issues/75/comments","events_url":"https://api.github.com/repos/dragua/xlsx/issues/75/events","html_url":"https://github.com/dragua/xlsx/issues/75","id":187953529,"number":75,"title":"Excel rises an error of there are more than 32.767 saved into one single cell","user":{"login":"Schandarck","id":23333840,"avatar_url":"https://avatars.githubusercontent.com/u/23333840?v=3","gravatar_id":"","url":"https://api.github.com/users/Schandarck","html_url":"https://github.com/Schandarck","followers_url":"https://api.github.com/users/Schandarck/followers","following_url":"https://api.github.com/users/Schandarck/following{/other_user}","gists_url":"https://api.github.com/users/Schandarck/gists{/gist_id}","starred_url":"https://api.github.com/users/Schandarck/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Schandarck/subscriptions","organizations_url":"https://api.github.com/users/Schandarck/orgs","repos_url":"https://api.github.com/users/Schandarck/repos","events_url":"https://api.github.com/users/Schandarck/events{/privacy}","received_events_url":"https://api.github.com/users/Schandarck/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-11-08T10:21:25Z","updated_at":"2016-11-08T10:21:25Z","closed_at":null,"body":"Saving dataframes with more then 32.767 signs per one single cell you are going to get an error from Exxel on loading that file. It's a contraint by Excel.\r\n\r\nwrite.xlsx2(data.frame(c1=strrep(\"A\",32767)),file=\"test.xlsx\") # that works perfectly\r\nwrite.xlsx2(data.frame(c1=strrep(\"A\",32768)),file=\"test.xlsx\") # that doesn't work\r\n\r\nfix it: use strtrim(()\r\nwrite.xlsx2(data.frame(c1=strtrim(strrep(\"A\",32768),32767)),file=\"test.xlsx\") # that works"}}
{"actor":{"display_login":"Schandarck"}}