This project has moved and is read-only. For the latest updates, please go here.

Styles.xml numFmts 2 instead of 1

Apr 12, 2016 at 3:56 PM
Edited Apr 12, 2016 at 4:19 PM

I'm facing a problem which a bit wierd:
When I a download my Excel generated by ClosedXML, 9 times on 10 it is ok.
1 time on 10, the design totally messed up.
So, I look closely to the generated file which has the design totally messed up:
The file in the folder "xl" called "styles.xml" has this:
<x:numFmts count="2"><x:numFmt numFmtId="0" formatCode="dd/mm/yyyy" /><x:numFmt numFmtId="1" formatCode="#,##0" /></x:numFmts>
Instead of:
<x:numFmts count="1"><x:numFmt numFmtId="0" formatCode="#,##0" /></x:numFmts>
<x:numFmts count="1"><x:numFmt numFmtId="0" formatCode="dd/mm/yyyy" /></x:numFmts>
When numFmts is at 2 => The design is K.O.

Is someone had the same issue?

As Data, I have some tables and pivot tables.

Thank you for reading.