php - How to use semicolon in excel formula
I am using PHPExcel_Worksheet and trying to fill a cell with a formula
$formula = '=SUMPRODUCT(A5:A7;D5:D7)' $objSheet->setCellValue('D8', $formula);
But in my worksheet I have a wrong thing in the D8
Who knows why semicolon is changes into a vertical line and how to avoid this?
I also tried to use setCellValueExplicit
but in this case I get the right text but it is not read like formula in the sheet