Re: [Spreadsheet::WriteExcel] Re: Excel Formula Issue

[John McNamara]

On Mon, Jun 1, 2009 at 3:14 PM, Priscilla Roopal Daniel <roop...@gmail.com> wrote:

Also I forgot to mention in my earlier post that  I also use repeat_formula

 

                  $tstsheet->repeat_formula($subrow,19,,$formula_datetomin,$dateformat,'Q10','Q'.($subrow+1),'P10','P'.($subrow+1),'P10','P'.($subrow+1));

 

Hi,

It looks like you are making a substitution to the same P10 variable twice in a row. This type of error is explained in the repeat_formula() section of the docs:

http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel/lib/Spreadsheet/WriteExcel.pm#repeat_formula($row,_$col,_$formula,_$format,_($pattern_=%3E_$replace,_...))

Look for the part with the example that changes =A1 + SIN(A1) to =A10 + SIN(A10) but be sure to read the whole thing.

John.
--