>> The below sample prints the row and column labels in Arial in PHPExcel 1.6.7,
>> but in the latest SVN version, it prints them in Calibri. Is this an intentional change?
This was not an intentional change. Will be fixed in tomorrows source code release.
It is intentional in PHPExcel 1.7.0 that Calibri 11 is used as the default font for (row/column labels and cells) for both the Excel2007 and Excel5 writer. In PHPExcel 1.6.7 Arial 10 was used by Excel5 writer and Calibri 10 was used by Excel2007 writer.
Another change in PHPExcel 1.7.0 compared to 1.6.7 is the default font (used for row/column lables and cells).
In PHPExcel 1.7.0 you set the default font like this:
In MS Office Excel 2007, this corresponds to
Excel Options > Popular > When creating new workbooks > Use this font
In PHPExcel 1.6.7 there was a default style for each sheet. This concept has been dropped in PHPExcel 1.7.0. The reason for this is that the Excel file format does not support such a default sheet style and it was giving problems during further development
of the library. In PHPExcel 1.7.0, when you try to set the default style for any sheet, it will be set for the entire workbook. (Therefore, I suggest that you update your code as shown above)
When you generate Excel files from a template (xls or xlsx) using PHPExcel, default font should of course survive. That means if you for example read an xls template that has Verdana 20 as default workbook font, it will still have that default font after
a plain read/write.