Re: Re: Couple of questions about Spreadsheet::WriteExcel

Thanks! Now I'm using

$worksheet->write($row, 6, "=SUM(C$row:E$row)"   );
[download]

however, it still produces a zero. even though like I said, the values in C$row through E$row _are_ there to be added!

Comment on Re: Re: Couple of questions about Spreadsheet::WriteExcel Download Code

Replies are listed 'Best First'.
Re: Re: Re: Couple of questions about Spreadsheet::WriteExcel by RMGir (Prior) on Aug 20, 2002 at 18:52 UTC
Sorry, I've never run into anything like that, unless I was putting the formula to the left of the cells it references, and even then, it got updated when I hit F9 in Excel... If you look at the contents of the cell in Excel, is it really 0, or is the formula there? -- Mike	[reply]