Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 0.9.4

Bug #9604 Error encountered with valid formula
Submitted: 2006-12-13 04:34 UTC
From: jas_khwong at yahoo dot com dot sg Assigned: progi1984
Status: Bogus Package: Spreadsheet_Excel_Writer (version 0.9.1)
PHP Version: 5.0.5 OS: Linux
Roadmaps: (Not assigned)    
Subscription  


 [2006-12-13 04:34 UTC] jas_khwong at yahoo dot com dot sg (Jason)
Description: ------------ Spreadsheet_Excel_Writer outputs the following Syntax error: , lookahead: , current char: 0 instead of the formula "=$'sheet2'.$A$0" which is a valid formula used for "Paste Special->Links" in Excel. Test script: --------------- <?php require_once "Spreadsheet_Excel_Writer/writer.php"; $xls =& new Spreadsheet_Excel_Writer(); $xls->send("test.xls"); $sheet1 =& $xls->addWorksheet('sheet1'); $sheet2 =& $xls->addWorksheet('sheet2'); $sheet1->write(0,0,"100"); $sheet2->writeFormula(0,0,"=\$'sheet1',\$A\$0"); $xls->close(); ?>

Comments

 [2010-04-06 17:13 UTC] progi1984 (Franck Lefevre)
-Status: Open +Status: Bogus -Assigned To: +Assigned To: progi1984
You don't use correctly the writeformula function. Thank you for taking the time to write to us, but this is not a bug. <?php require_once 'Spreadsheet/Excel/Writer.php'; $xls =& new Spreadsheet_Excel_Writer(); $sheet1 =& $xls->addWorksheet('sheet1'); $sheet2 =& $xls->addWorksheet('sheet2'); $sheet1->write(0,0,"100"); $sheet2->writeFormula(0,0,"=sheet1!A1"); $xls->close(); $xls->send('test'.date('His').'.xls'); ?>