Description: ------------ When using a space or - (maybee there are other chars?) in worksheet-name and refer by a formula to a cell in such a worksheed I got following content in my formula-cell: Syntax error: , lookahead: , current char: 0 If the name is without space or - it works pretty fine. In Version 4 (http://pear.php.net/package/Spreadsheet_Excel_Writer/download/0.4) there seems to be an update for such bug (?), but it doesn't seems to work and I can't open the bugreport (anymore?) Cu Jan Reproduce code: --------------- <?php require_once 'Spreadsheet/Excel/Writer.php'; $workbook = new Spreadsheet_Excel_Writer(); $worksheet =& $workbook->addWorkSheet("Test-Data"); $worksheet->write(0,0,100); $worksheet2 =& $workbook->addWorkSheet("Test Data"); $worksheet2->writeFormula(0,0,"='Test-Data'!A1"); $worksheet2->write(0,1,200); $worksheet3 =& $workbook->addWorkSheet(); $worksheet3->writeFormula(0,0,"='Test Data'!B1"); $workbook->send('test.xls'); $workbook->close(); ?>

I'm getting the Syntax error: ), lookahead: , current char: 0 also when I send a bad formula using writeFormula (or write) The line: $sheet->write(2, 1, "='SNTP'H47"); //missing the ! before the H// will also generate that syntax error (note SNTP doesn't have spaces or special characters)...don't know if this clue will help any of the coders or not...

my excel hang up (I am using the send function) if I try to use the formula function with this code: $worksheet->write(0,0, "=worksheet1!B1", $test); Same result by using writeFormula(); The PHP Script itself generates no error. Hope that helps.

This bug has been fixed in CVS. If this was a documentation problem, the fix will appear on pear.php.net by the end of next Sunday (CET). If this was a problem with the pear.php.net website, the change should be live shortly. Otherwise, the fix will appear in the package's next release. Thank you for the report and for helping us make PEAR better.