Alasql: XLS file format and Excel 2013

[mathiasrw]

_Spawned from #484_

When I try to open an exported .XLS Excel 2013 gives me this popup message:

I can continue by clicking yes. The issue is replicated in http://jsfiddle.net/2f1vz2cm/ for .XLS files.

[nickdeis]

Apparently this a common issue requiring registry changes:
http://stackoverflow.com/questions/940045/how-to-suppress-the-file-corrupt-warning-at-excel-download

[mathiasrw]

@nickdeis Hmmm - interesting. Thanks for putting it out there. Its always good to know its not only your own code that generates some sort of bad user experience with Excel

[nickdeis]

I think the best solution here might be a clear wiki entry, and a console.warn statement in the unminified code.
React does this, and I love it.
Something along the lines of

console.warn("XLS format may throw a warning when opened in Excel, see ");

This issue caught my eye because I've had this issue with other products like BIRT reports.

[chaitujil]

Cool. Followed that link above and did this below

Insert this key in your registry to suppress the notification:

[HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Excel\Security] “ExtensionHardening”=dword:00000000

You can accomplish the above by doing the following:

1. Open your Registry (Start -> Run -> regedit.exe)
2. Navigate to HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\15.0\EXCEL\SECURITY
3. Right click in the right window and choose New -> DWORD
4. Type “ExtensionHardening” as the name (without the quotes)
5. Verify that the data has the value “0″

Warning popup won't show anymore.

[mathiasrw]

:+1: