Formula Error

Topics: Developer Forum, Project Management Forum, User Forum
Jan 29, 2010 at 6:16 AM


At present i am using 1.7.2 version. It was working correct previously with the older version for hyperlink generation.

But , now it shows an error.

the code used is something like this,

$objPHPExcel->getActiveSheet()->setCellValue('C14', '=HYPERLINK("";"")');


Jan 29, 2010 at 7:50 AM

Are you sure that it was working with the previous version? The HYPERLINK() function itself has never been implemented within PHPExcel itself, but the formula should still be written correctly to any xls or xlsx files generated, although the pre-calculated value will be wrong. Forcing a recalculate when the spreadsheet is opened in Excel itself should still display the entry as a hyperlink.

Jan 29, 2010 at 11:11 AM

This appears to work quite correctly when writing to Excel5, but if I write to Excel2007 and Open the xlsx file using Excel 2003 with the compatibility pack, I get a file conversion error. Will experiment again tonight when I can try opening the file using a Excel 2007 itself.