{"action":"created","issue":{"url":"https://api.github.com/repos/randym/axlsx/issues/489","repository_url":"https://api.github.com/repos/randym/axlsx","labels_url":"https://api.github.com/repos/randym/axlsx/issues/489/labels{/name}","comments_url":"https://api.github.com/repos/randym/axlsx/issues/489/comments","events_url":"https://api.github.com/repos/randym/axlsx/issues/489/events","html_url":"https://github.com/randym/axlsx/issues/489","id":179798105,"number":489,"title":"Excel repair warning","user":{"login":"sylvainbx","id":5102799,"avatar_url":"https://avatars.githubusercontent.com/u/5102799?v=3","gravatar_id":"","url":"https://api.github.com/users/sylvainbx","html_url":"https://github.com/sylvainbx","followers_url":"https://api.github.com/users/sylvainbx/followers","following_url":"https://api.github.com/users/sylvainbx/following{/other_user}","gists_url":"https://api.github.com/users/sylvainbx/gists{/gist_id}","starred_url":"https://api.github.com/users/sylvainbx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sylvainbx/subscriptions","organizations_url":"https://api.github.com/users/sylvainbx/orgs","repos_url":"https://api.github.com/users/sylvainbx/repos","events_url":"https://api.github.com/users/sylvainbx/events{/privacy}","received_events_url":"https://api.github.com/users/sylvainbx/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-09-28T14:58:47Z","updated_at":"2016-09-28T16:34:19Z","closed_at":null,"body":"Hi,\r\nI have an issue with excel files generated with the gem.\r\nWhen opening them with Excel 2016 (Windows) or Excel Mac 2011 (Os X), I have the following error when opening the file:\r\n\r\n![excel2011](https://cloud.githubusercontent.com/assets/5102799/18918635/bf9eb5b0-859b-11e6-984c-1dbfd6a6f74a.png)\r\n\r\nThe error log contains the following:\r\n\r\n```\r\n<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\r\n\r\n<recoveryLog xmlns=\"http://schemas.openxmlformats.org/spreadsheetml/2006/main\"><logFileName>Repair Result to subscriptions-11_28092016 02466.xml</logFileName><summary>Errors were detected in file 'Macintosh HD:Users:jarod:Downloads:subscriptions-11_28092016.xlsx'</summary><additionalInfo><info>Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.</info></additionalInfo></recoveryLog>\r\n```\r\nHere is a sample file witch generates the problem:\r\n[subscription-58_28092016.xlsx](https://github.com/randym/axlsx/files/498608/subscription-58_28092016.xlsx)\r\n\r\nThe code used to build the file can be found here : https://github.com/LaCasemate/fab-manager/blob/dev/app/views/exports/statistics_current.xlsx.axlsx\r\n\r\nI've tried many upgrades/downgrades of the gems (axlsx, rubyzip, axlsx_rails) as I've seen that some similar issues were already reported (eg. #1, #236) but none of them solved the issue.\r\n\r\nNote also:\r\n- I was able to open it with LibreOffice 5.1, on Ubuntu without any problem.\r\n- If I choose \"Open and Repair\", after many warnings, the file opens and contains all the data."},"comment":{"url":"https://api.github.com/repos/randym/axlsx/issues/comments/250222228","html_url":"https://github.com/randym/axlsx/issues/489#issuecomment-250222228","issue_url":"https://api.github.com/repos/randym/axlsx/issues/489","id":250222228,"user":{"login":"arkadiybutermanov","id":947165,"avatar_url":"https://avatars.githubusercontent.com/u/947165?v=3","gravatar_id":"","url":"https://api.github.com/users/arkadiybutermanov","html_url":"https://github.com/arkadiybutermanov","followers_url":"https://api.github.com/users/arkadiybutermanov/followers","following_url":"https://api.github.com/users/arkadiybutermanov/following{/other_user}","gists_url":"https://api.github.com/users/arkadiybutermanov/gists{/gist_id}","starred_url":"https://api.github.com/users/arkadiybutermanov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/arkadiybutermanov/subscriptions","organizations_url":"https://api.github.com/users/arkadiybutermanov/orgs","repos_url":"https://api.github.com/users/arkadiybutermanov/repos","events_url":"https://api.github.com/users/arkadiybutermanov/events{/privacy}","received_events_url":"https://api.github.com/users/arkadiybutermanov/received_events","type":"User","site_admin":false},"created_at":"2016-09-28T16:34:19Z","updated_at":"2016-09-28T16:34:19Z","body":"@sylvainbx I did encounter the same issues. Ensure that you're not using unescaped special characters in list names, validation formulas/errors and hints."}}
{"actor":{"display_login":"arkadiybutermanov"}}