My client only has Excel 2003, so I thought I could use setOffice2003Compatibility to dumb down my 2007 file a bit. I was having issues, so I created this simple test:
$objPHPExcel = new PHPExcel();
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
It creates the file just fine, but when you try and open the file in Excel 2003 I get the error message " This file is not in a recognizable format." If I open it anyway, it's all jiberish. When I open the same file in 2007 I get the following
message: "The file you are trying to open is in a different format than specified by the file extension..." however if I open it it's as expected. I'm I totally miss understanding how this works?