getCalculatedValue return 0

Topics: Developer Forum
Apr 13, 2009 at 9:52 PM
Edited Apr 13, 2009 at 9:56 PM
Hello, this work


$objWorksheetres->setCellValue('D10',"=IFERROR(MATCH(C10,'Avance de usuarios'!Q2:Q20),0)"); // cell value = 20
$objWorksheetres->setCellValue('D22',$objWorksheetres->getCell('D10')->getCalculatedValue()); // return 0

no work, return 0

any help plz

Apr 14, 2009 at 12:20 AM
Hmm... It looks like the MATCH() function isn't working with PHPExcel's calculation engine although it is listed as implemented in the "PHPExcel Function Reference Developer Documentation".

Posting this in the issue tracker so Mark or Maarten can inspect:

Apr 14, 2009 at 1:53 AM