| 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] 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');
?>