Jon Hairr wrote:
> I would be interested in the postparser workaround
Thanks for the detailed bug report.
The best way to workaround this is to use store_formula() and
repeat_formula() and massage the parsed tokens.
So using your example, adding the following substitution to the end
will fix the problem:
...
$worksheet>repeat_formula(
$ref_row
,$column+6
,$formula
,$format
,"A1"
,"A".$formula_row
,'_ref2d' => '_ref2dV'
);
...
Hopefully, I will get the parser fixed soon so that this type of
hackery isn't required.
Drop me a line if you need further information.
John.

# Sum the numbers in the first column of a file
perl lpe '$,+=$_}{$_=+$,' file
