Excel workbook is generated using aspose cells. Generated workbook's styles.xml appears correct. However when the excel workbook is opened, the number format is no longer what it shows in styles.xml.
For example - in this case I would like to have comma as the decimal separator and dot as thousand separator, with one digit after decimal.
The workbook has following specified in the styles.xml :
<numFmt numFmtId="182" formatCode="#.##0,0;[Color3]-#.##0,0"/>
</numFmts>
When this workbook is opened, and when I look at the corresponding number format for the cell, it has been replaced with incorrect format string:
"#,##00;[Color3]-#,##00" which makes the numbers appear incorrect.
225511-workbook.xml
Number -40845,3 appears incorrectly as "-40845,300" - with no thousand separator and incorrect number of decimal places.
Excel options-->advanced options has been set to correctly match the format options.
Any idea what could be wrong here and why Excel is changing the format string?
225521-styles.xml