Bug #9604

Error encountered with valid formula

Details

Submitted	2006-12-13 04:34 UTC
From	jas_khwong at yahoo dot com dot sg
Assigned	progi1984
Status	Bogus
Package	Spreadsheet_Excel_Writer
PHP Version	5.0.5
OS	Linux
Roadmaps	(Not assigned)

Comments

[2006-12-13 04:34 UTC] jas_khwong at yahoo dot com dot sg

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();
?>