Alternatively, you could use the "xl_rowcol_to_cell" function in Spreadsheet::WriteExcel::Utility to convert the row and column values to "A1" notation

ex:

my $jloc = xl_rowcol_to_cell($row+2, 12);
my $kloc = xl_rowcol_to_cell($row+2, 12);

$worksheet->write_formula($row+2, 12, '=1-('.$kloc.'/'.$jloc.')',$alig
+nPerc);
[download]