State_Space has asked for the wisdom of the Perl Monks concerning the following question:

Hi Monks,

Was wondering if anyone ran into this problem. I'm using Spreadsheet::WriteExcel. I run a .pl in Padre it works great. I package it with its modules using pp search.cpan.org/~rschupp/PAR-Packer-1.028/lib/pp.pm/into an exe. the exe runs until it has to write a formula i.e. '=A1-A2' into excel. It writes all none formulas cells before that point, but as soon as it uses a
$worksheet->write($row, $col, $value, $format); or
$worksheet->write_formula($row, $col, $value, $format);
where $value is a string like '=A1-A2'. the exe errors and closes the gui console window. to reiterate if I run it from Padre it doesn't happen. I don't know how to get the gui console from stop disappearing if someone tells me how I try to paste what the error is.

Replies are listed 'Best First'.
Re: Spreadsheet::WriteExcel packaged with pp
by Anonymous Monk on Dec 30, 2015 at 18:28 UTC
    turn on debugging, don't use --gui option
      How do I turn on debugging within the exe? I don't use -gui when packaging so the console is available, but when it crashes the window closes.