in reply to Missing first row with formula

  for my $line (0..$row_count) {
     #this arguments are row, column, formula, format, first cell, sec
+ond cell
     $xWS5->repeat_formula($line, 6,  [...]

[download]

I didn't try the code, but I think this 0-based $line should be made 1-based, no? WriteExcel rows are 1-based.

UPDATE: ah, I stand corrected. WriteExcel rows are indeed 0-based. I did not carefully enough parse '1-based' from the this bit of documentation:

Row-column notation uses a zero based index for both row and column while A1 notation uses the standard Excel alphanumeric sequence of column letter and 1-based row.

Replies are listed 'Best First'.
Re^2: Missing first row with formula
by Kenosis (Priest) on Jan 10, 2014 at 07:29 UTC

    It's zero-based. From the documentation:

    $worksheet->write(0, 0, 'Hi Excel!');

    [download]

    and

    for my $row ( 0 .. 99 ) {
    $worksheet->repeat_formula( $row, 1, $formula, $format, 'A1', 'A' 
+. ( $row + 1 ) );
}

    [download]
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom