I am using PHPExcel to generate XLS files. Until now I was using 'Excel5' (xls) to generate xls files and I was setting cell value like this:
$excelFile->getActiveSheet()->setCellValue('B'. $counter, $name);
Now, I upgraded to 'Excel2007' (xlsx) and I started to get following errors:
Fatal error: Uncaught exception 'Exception' with message 'Invalid cell coordinate LIST1!B2'
in /nfsmnt/hosting2_1/9/d/9d99e7c0-d532-400a-909f-9c348da3c869/isir.info/web/tp_libs/phpexcel/PHPExcel/Cell.php:508
Stack trace:
#0 /tp_libs/phpexcel/PHPExcel/Cell.php(545): PHPExcel_Cell::coordinateFromString('LIST1!B2')
#1 /tp_libs/phpexcel/PHPExcel/Writer/Excel2007/Workbook.php(356): PHPExcel_Cell::absoluteCoordinate('LIST1!B2')
#2 /tp_libs/phpexcel/PHPExcel/Writer/Excel2007/Workbook.php(277): PHPExcel_Writer_Excel2007_Workbook->_writeDefinedNameForAutofilter(Object(PHPExcel_Shared_XMLWriter), Object(PHPExcel_Worksheet), 0)
#3 /tp_libs/phpexcel/PHPExcel/Writer/Excel2007/Workbook.php(82): PHPExcel_Writer_Excel2007_Workbook->_writeDefinedNames( in /nfsmnt/hosting2_1/9/d/9d99e7c0-d532-400a-909f-9c348da3c869/isir.info/web/tp_libs/phpexcel/PHPExcel/Cell.php on line 508
Usually upgrade to 'Excel2007' was smooth. What might be the cause of this issue?