{"action":"created","issue":{"url":"https://api.github.com/repos/straydogstudio/axlsx_rails/issues/55","repository_url":"https://api.github.com/repos/straydogstudio/axlsx_rails","labels_url":"https://api.github.com/repos/straydogstudio/axlsx_rails/issues/55/labels{/name}","comments_url":"https://api.github.com/repos/straydogstudio/axlsx_rails/issues/55/comments","events_url":"https://api.github.com/repos/straydogstudio/axlsx_rails/issues/55/events","html_url":"https://github.com/straydogstudio/axlsx_rails/issues/55","id":158113154,"number":55,"title":"Excel 2016 unable to open generated document ","user":{"login":"damienh","id":810107,"avatar_url":"https://avatars.githubusercontent.com/u/810107?v=3","gravatar_id":"","url":"https://api.github.com/users/damienh","html_url":"https://github.com/damienh","followers_url":"https://api.github.com/users/damienh/followers","following_url":"https://api.github.com/users/damienh/following{/other_user}","gists_url":"https://api.github.com/users/damienh/gists{/gist_id}","starred_url":"https://api.github.com/users/damienh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/damienh/subscriptions","organizations_url":"https://api.github.com/users/damienh/orgs","repos_url":"https://api.github.com/users/damienh/repos","events_url":"https://api.github.com/users/damienh/events{/privacy}","received_events_url":"https://api.github.com/users/damienh/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/straydogstudio/axlsx_rails/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":14,"created_at":"2016-06-02T10:54:23Z","updated_at":"2016-09-26T18:02:18Z","closed_at":null,"body":"I have been experiencing issues with opening generated documents with Excel 2016. Excel presents the following message:\r\n![2c127a76-27e4-11e6-8391-eb113ec8df7c](https://cloud.githubusercontent.com/assets/810107/15742612/f78c2638-28b7-11e6-8422-3ef8ccce4141.png)\r\nIf I \"Open and Repair\" I'm offered the chance to see the log file of what was removed, and the repaired sheet is opened. It's not very helpful...\r\n\r\n```xml\r\n<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\r\n<recoveryLog xmlns=\"http://schemas.openxmlformats.org/spreadsheetml/2006/main\"><logFileName>Repair Result to generated_report_30.xml</logFileName><summary>Errors were detected in file '/Users/martinpeck/Library/Containers/it.bloop.airmail2/Data/Library/Application Support/Airmail/General/Tmp/generated_report_3.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\n\r\nIt appears OSX Numbers has an issue with fonts:\r\n![0868f612-27e5-11e6-8ea9-6ff90fa148c4](https://cloud.githubusercontent.com/assets/810107/15742645/29a171f0-28b8-11e6-8b83-1ae587de5413.png)\r\n\r\nOSX OpenOffice opens it fine without issue.\r\n\r\nThe report is generated via a rake task. Here is the code that I am generating the doc:\r\n\r\n```ruby\r\nview_assigns = {users: User.all, referrals: ReferralTracker.all, reporting_regions: ReportingRegion.all}\r\nav = ActionView::Base.new(ActionController::Base.view_paths, view_assigns)\r\n\r\ncontent = av.render template: 'dashboard/generate_report.xlsx.axlsx'\r\n\r\nreport = File.open(\"./tmp/codeclub-numbers-report-#{Date.today}.xlsx\",\"w+b\") {|f| f.puts content }\r\n```\r\n\r\nThe template is fairly large so here is the main call:\r\n```ruby\r\nwb = xlsx_package.workbook\r\nwb.styles do |s|\r\n\r\nheader_title =  s.add_style  :bg_color => \"ff9900\", :fg_color => \"FF\", :sz => 11, :alignment => { :horizontal=> :left }\r\ndate_header =  s.add_style :sz => 18, :alignment => { :horizontal=> :left }\r\nsection =  s.add_style :sz => 10, :alignment => { :horizontal=> :left }\r\n\r\n\r\nwb.add_worksheet(name: \"Reporting Sheet\") do |sheet|\r\n    sheet.add_row [\"Report ran for #{1.month.ago.beginning_of_month.strftime(\"%B\")}\"], :style => [date_header]\r\n.....\r\n....\r\n    end\r\nend\r\n```\r\n\r\n\r\nAnyone have any ideas what might be causing this?"},"comment":{"url":"https://api.github.com/repos/straydogstudio/axlsx_rails/issues/comments/249647797","html_url":"https://github.com/straydogstudio/axlsx_rails/issues/55#issuecomment-249647797","issue_url":"https://api.github.com/repos/straydogstudio/axlsx_rails/issues/55","id":249647797,"user":{"login":"straydogstudio","id":1423683,"avatar_url":"https://avatars.githubusercontent.com/u/1423683?v=3","gravatar_id":"","url":"https://api.github.com/users/straydogstudio","html_url":"https://github.com/straydogstudio","followers_url":"https://api.github.com/users/straydogstudio/followers","following_url":"https://api.github.com/users/straydogstudio/following{/other_user}","gists_url":"https://api.github.com/users/straydogstudio/gists{/gist_id}","starred_url":"https://api.github.com/users/straydogstudio/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/straydogstudio/subscriptions","organizations_url":"https://api.github.com/users/straydogstudio/orgs","repos_url":"https://api.github.com/users/straydogstudio/repos","events_url":"https://api.github.com/users/straydogstudio/events{/privacy}","received_events_url":"https://api.github.com/users/straydogstudio/received_events","type":"User","site_admin":false},"created_at":"2016-09-26T18:02:18Z","updated_at":"2016-09-26T18:02:18Z","body":"@jayshepherd Was that with 0.5.0?"}}
{"actor":{"display_login":"straydogstudio"}}