{"action":"opened","issue":{"url":"https://api.github.com/repos/mk-j/PHP_XLSXWriter/issues/54","repository_url":"https://api.github.com/repos/mk-j/PHP_XLSXWriter","labels_url":"https://api.github.com/repos/mk-j/PHP_XLSXWriter/issues/54/labels{/name}","comments_url":"https://api.github.com/repos/mk-j/PHP_XLSXWriter/issues/54/comments","events_url":"https://api.github.com/repos/mk-j/PHP_XLSXWriter/issues/54/events","html_url":"https://github.com/mk-j/PHP_XLSXWriter/issues/54","id":133549057,"number":54,"title":"tab","user":{"login":"chatis","id":4694026,"avatar_url":"https://avatars.githubusercontent.com/u/4694026?v=3","gravatar_id":"","url":"https://api.github.com/users/chatis","html_url":"https://github.com/chatis","followers_url":"https://api.github.com/users/chatis/followers","following_url":"https://api.github.com/users/chatis/following{/other_user}","gists_url":"https://api.github.com/users/chatis/gists{/gist_id}","starred_url":"https://api.github.com/users/chatis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chatis/subscriptions","organizations_url":"https://api.github.com/users/chatis/orgs","repos_url":"https://api.github.com/users/chatis/repos","events_url":"https://api.github.com/users/chatis/events{/privacy}","received_events_url":"https://api.github.com/users/chatis/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-02-14T15:52:00Z","updated_at":"2016-02-14T15:52:00Z","closed_at":null,"body":"You our data has chr(11), your excel while open with error... we need to change chr(11) to chr(13) to won't have any error...\r\n\r\nI juste change your code like this :\r\n\r\n$this->writeCell($sheet->file_writer, $sheet->row_count, $column_count, $v, $sheet->columns[$column_count]);\r\n\r\nto\r\n\r\n$this->writeCell($sheet->file_writer, $sheet->row_count, $column_count, str_replace(chr(11), chr(13), $v), $sheet->columns[$column_count]);"}}