Tell Excel to refresh formula calculations as soon as the file is opened...

stephen-hardy / xlsx.js

XLSX.js is a JavaScript library for converting the data in base64 XLSX files into JavaScript objects - and back! Please note that this library is licensed under the Microsoft Office Extensible File License - a license NOT approved by the OSI. While this license is based off of the MS-PL, which is OSI-approved, there are significant differences.

http://blog.innovatejs.com/?tag=xlsx-js

Other

575 stars 122 forks source link

Tell Excel to refresh formula calculations as soon as the file is opened... #21

Closed eddiefletchernz closed 10 years ago

eddiefletchernz commented 10 years ago

....

If a formula is provided by JS, then JS should not be expected to also provide the initial result of that formula in order for the spreadsheet to look correct on open.

The attribute fullCalcOnLoad="1" tells excel that all formulas should be evaluated on open.

Solution taken from: http://stackoverflow.com/a/18447197/1413853

stephen-hardy commented 10 years ago

Thanks for the contribution!