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

Apr 14, 2009 at 1:53 AM
thx