.
...
The largest impact from this relates to named styles. In Excel 2003, the default Normal style is Arial, size 10. In Excel 2007, the default Normal style is Calibri, size 11. Certain settings Settings that are based on the Normal style , such as default row heights or column widths, will be different between XLS and XLSX files:
- Default row height and column height in a file - These values are based on the font type and style of the Normal style.
- Setting
ColumnProperties.Width- ExcelWriter sets this to a fixed number (e.g. 38). Excel uses this number and the Normal style to when rendering the width of the column.
To ensure that output remains consistent while switching to XLSX, we recommend creating a blank XLSX file that has the Normal style set to Arial, size 10. Open that blank template file, rather than creating a template from scratch.
Computations and Rounding
Chart defaults
Some very small charting defaults have changed, such as:
- Distance between ticks on an axis
- Default text color for some areas of the chart is white
The workaround is to set these properties explicitly in ExcelWriter code. Most ExcelWriter-generated charts will appear the same regardless of whether they are in XLS or XLSX files.