Description: ------------ Attempting to write the following formula resulted in a "')' token expected" message appearing in the cell instead of the desired formula: =(0+SUMPRODUCT(M6:M14;$G6:$G14)+M15*$G15) Fortunately, this is easy to fix (after hours of debugging). Here is how to fix it: Open Parser.php and find every place that there is a regular expression for a range. Replace the double quotes that enclose the regular expression with single quotes. Then re-use a pair of the regular expressions you just updated (one for ":" and one for "..") in the _convertRange2d function. The off-the-shelf version of that function doesn't handle "$"s. You're all set! Test script: --------------- =(0+SUMPRODUCT(M6:M14;$G6:$G14)+M15*$G15) Expected result: ---------------- The formula should appear in the cell. Actual result: -------------- "')' token expected" appears in the cell.

I can verify this. Test script: <? require_once ("Spreadsheet/Excel/Writer.php"); $WB =& new Spreadsheet_Excel_Writer(); $sheet =& $WB->addWorksheet(); $sheet->write(0, 0, '=(0+SUMPRODUCT(M6:M14;$G6:$G14)+M15*$G15)'); $WB->send("test.xls"); $WB->Close(); ?>

Could you please post your corrected strings? I've tried to correct it, but I think I don't have the right regular expression. Thanks