[2.4.0+] Excel repair warning

[sylvainbx]

Opening this as an information notice for users who encounter the following problem:

When opening an Excel export with Excel 2016 (Windows) or Excel Mac 2011 (OSX), a warning dialog appears, asking to repair the file before opening.

This does not affect the export content: data integrity is guaranteed but this can be boring if you export frequently.

This issue is very probably due to a bug in a third party library (axlsx) and was already reported there
(see randym/axlsx#489).

No fixes are expected until axlsx fixes the issue.

As a workaround, you can use LibreOffice Calc (here in french) to open your exports files without any warning.

[alexcvcoelho]

Hi @sylvainbx.

Searching in issues of the axlsx_rails i found this solution here, that worked for me.

In fact, lib rails_axlsx returns a content with encoding error, what I do is use the write method that corrects the encode to write to the file.
I am using the following configuration in Gemfile:

gem 'rubyzip', '= 1.0.0'
gem 'axlsx', '= 2.0.1'
gem 'axlsx_rails', '=0.4.0'

The old code:

File.open(export.file,"w+b") {|f| f.puts content }

The new code:

File.open(export.file,"w+b") {|f| f.write content }

[sylvainbx]

Hi @alexcvcoelho, I've updated the code to use f.write as you suggested. I've also updated the gems dependencies to the last versions. This applies starting from release 4.2.1. Feel free to give it a try and make a feedback here if you have Excel.

[sylvainbx]

Office 365 seems to be totally unable to open the exported files.

[sylvainbx]

Fixed in release 5.3.1