how to get the value of sheet1 in sheet2 with the document method?

Topics: Developer Forum, User Forum
Oct 15, 2009 at 6:58 AM

i know we can use name range to set a global variable in sheet1, and use it in sheet. can we use below way to get the values like the excel code?

openoffice:

=sum($Sheet1.A1:$Sheet1.A1000)

ms excel:

=sum(Sheet1!A1:$Sheet1.A1000)

 

anyone can help me? many thanks!

Developer
Oct 15, 2009 at 11:44 AM

Try to set this formula in sheet2:

$sheet->getCell('B1')->setValue('=SUM(Sheet1!A1:A1000)');
var_dump($sheet->getCell('B1')->getCalculatedValue());