Description: ------------ Using quoted references in formulas seems to cause a stack overflow. eg =SUM('Japanese Book - Rollovers'!A10:A11)

Similar issue, but slightly different results. This statement $worksheet->writeFormula(3, 1, "=SUM('AP Capital'!T:T)", $formatNumber); Causes a stack overflow and SEGV, while the statement $worksheet->writeFormula(3, 1, "=VLOOKUP(\$A\${$excelRow},'APCapitalAPDISTRIB'!{$apDistRange},{$pickCol},0)", $formatNumber); does not. I have tested several combinations and it does not appear to matter if there are embedded spaces in the quoted sheet identifier. Perhaps this is a a bug in only in the SUM formula implementation?

I am using similar forumla in some spreadsheets and I can reference values from other sheets. e.g. $calc_worksheet-> writeFormula($lookup_row_id, 8, "=SUM ('Advance Worksheet'!J22:K" . $lookup_row_id . ")"); Works on our server (SUSE) so the problem may not be something completely inherent to the package. But I do have to increase the script timeout for the package to run when creating a number of complex formula and multiple sheets. VLOOKUP works when referencing other sheets as well. Not really helping your issue, sorry. Just trying to give the maintainer more information to address possible problems

We are unable to reproduce the bug as reported. Please provide a simple script (10 lines or less) or a link to an external script that can be used to reproduce the bug. If you can provide the script, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PEAR.