Perl OLE Excel - STDEVA function | Data Conversion
Home

Perl OLE Excel - STDEVA function

I try to calculate the standard deviation of average of C2:C35. But I get random range in the worksheet G$i. It's not showing as: D2 =STDEVA(C2:C35,D2) D3 =STDEVA(C2:C35,D3) ..... It's showing as: D2 =STDEVA(C2:C35,D2) D3 =STDEVA(C2:C31,D3) D4 =STDEVA(C2:C33,D4) ..... Any one know why? I tried with " " doesn't help and q { } show nothing

full article | source