Print with MS Excel 2013 about js-xlsx HOT 5 OPEN

I found that the problem is generated by sheetViews node in worksheets/sheet1.xml file. When I comment out the lines that append this node to output file, everything seems to work just fine.

from js-xlsx.

@Ajolos Thank you for reporting this. I'm able to print fine in OSX Office 2011. Not a comprehensive test but i can run that quickly. Differencing the downloaded and saved files, the difference in that section is the saved file does not have the attribute showGridlines="1". It seems that "1" is the assumed value if not specified and should not be in the XML.

Can you try commenting out line xlsx.js:7843 (or 67_bits.js:311 then make) and tell me if the problem persists?

showGridLines: opts.showGridLines == false ? '0' : '1',

from js-xlsx.

Well, commenting out the line you pointed didn't change anything - Excel still crashes after pressing 'Print'. However, when I comment out the next line
tabSelected: opts.tabSelected === undefined ? '1' : opts.tabSelected,
(node sheetView in output file has no attribute tabSelected)
or change its default value to '0'
tabSelected: opts.tabSelected === undefined ? '0' : opts.tabSelected,
(node sheetView in output file has attribute tabSelected="0")
I can print the file successfully.
Does it make any sense to you? So far I found the tabSelected attribute definition:

Flag indicating whether this sheet is selected. When only 1 sheet is selected and active, this value should be in synch with the activeTab value. In case of a conflict, the Start Part setting wins and sets the active sheet tab.

I didn't debug the whole library, but in the source code activeTab is mentioned only once - in line 8352:
var WBViewDef = [ ['activeTab', '0'], ... //window{Height,Width}, {x,y}Window ];

It seems like the activeTab is set to '0' by default, but tabSelected is set to '1', which is in conflict with the definition (should be in sync).

from js-xlsx.

This is great. Working into next release.

from js-xlsx.

Same as #29? Will test 0.8.13 and let you know tomorrow if it fixed my issue.

from js-xlsx.