字段中的PHPExcel_Calculation_Exception插入公式

Question

我的代码：

$objPHPExcel->setActiveSheetIndex($index)->setCellValue('A1', '=SUM(2;2)');

错误：

(extensions\phpexcel\Classes\PHPExcel\Cell.php:300)发生的意外错误: PHPExcel_Calculation_ExceptionA1 ->公式错误 #0 \extensions\phpexcel\Classes\PHPExcel\Worksheet.php(754)：PHPExcel_Cell->getCalculatedValue() #1 extensions\phpexcel\Classes\PHPExcel\Writer\Excel2007\Worksheet.php(373)：PHPExcel_工作表->calculateColumnWidths() #2 \extensions\phpexcel\Classes\PHPExcel\Writer\Excel2007\Worksheet.php(80)：PHPExcel_Writer_Excel2007_Worksheet->_writeCols(Object(PHPExcel_Shared_XMLWriter)，Object(PHPExcel_Worksheet) #3 extensions\phpexcel\Classes\PHPExcel\Writer\Excel2007.php(304)：PHPExcel_Writer_Excel2007_Worksheet->writeWorksheet(Object(PHPExcel_Worksheet)，阵列，假) #4

Answer 1

in '= SUM (2;2)‘

改变；为了，

'=和(2,2)‘