Excel file needs to be repaired after saving about js-xlsx HOT 3 OPEN

Have the same issue. Although it appears that it is available on windows excel 2013, but doesn't appear on Excel 2008 for Mac.
For me reproduce it on windows i need to add new cells and migrate merges using !ref and !merges sheet properties. If i touch just one property no repair warning. Resulting file is too large. 15mb before repair and 5mb after. On repair it removed all line breaks. It creates SharedStrings xml and compresses data using dictionary. Excel 2008 for Mac doesn't do this. So i think this is some format issue. Recovered file add some new namespaces. So i think this issue can be hard to find the solution.

from js-xlsx.

Small addition. This somehow correlates with /r symbols in the cells.

from js-xlsx.

Everytime I have gotten this issue it's been something on my end; in my case the most common is to give a string and try and format it as a number.

It's a huge pain but you can debug this -- if you can't figure it out -- by breaking up the xlsx file (it's just a zip file of mostly xml files) and the diffing the repaired and unrepaired versions that show up in the log file.

If you can show exactly what is breaking and how it will be easier to figure out your problem and get a fix into the repo, if it is indeed a problem of the library.

from js-xlsx.