Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 0.9.2
Bug #9604 Error encountered with valid formula
Submitted: 2006-12-12 23:34 UTC
From: jas_khwong at yahoo dot com dot sg Assigned:
Status: Open Package: Spreadsheet_Excel_Writer (version 0.9.1)
PHP Version: 5.0.5 OS: Linux
Roadmaps: (Not assigned)    
Subscription  
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes. If this is not your bug, you can add a comment by following this link. If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: jas_khwong at yahoo dot com dot sg
New email:
PHP Version: Package Version: OS:

 

 [2006-12-12 23: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