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('D12','=SUM(D9:D11)');
$objWorksheetres->setCellValue('D21',$objWorksheetres->getCell('D12')->getCalculatedValue());

but

$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

thx
Developer
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:
http://phpexcel.codeplex.com/WorkItem/View.aspx?WorkItemId=9748

Apr 14, 2009 at 2:53 AM
thx