Bug #6725

quoted offsheet references cause stack overflow

Details

Submitted	2006-02-08 11:08 UTC
From	steveh at brendata dot co dot uk
Status	No Feedback
Package	Spreadsheet_Excel_Writer
PHP Version	5.1.2
OS	Windows 2003
Roadmaps	(Not assigned)

Comments

[2006-02-08 11:08 UTC] steveh at brendata dot co dot uk

Description:
------------
Using quoted references in formulas seems to cause a stack overflow.

eg =SUM('Japanese Book - Rollovers'!A10:A11)

[2006-02-28 18:10 UTC] pear at bugmenot dot com

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?

[2006-03-24 16:16 UTC] jon dot bertsch at ucop dot edu

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