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] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send
MANUAL CONFIRMATION IS NOT POSSIBLE.  Write a message to pear-dev@lists.php.net
to request the confirmation link.  All bugs/comments/patches associated with this

email address will be deleted within 48 hours if the account request is not confirmed!