| 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) | ||
[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!