getCalculatedValue return 0

Topics: Developer Forum
Apr 13, 2009 at 10:52 PM
Edited Apr 13, 2009 at 10: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 1: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 2:53 AM