in reply to add_chart_ext does not work when compressed

That is a little odd,

The warning message comes from the add_chart() method but the program is using the add_chart_ext() method which doesn't throw a warning like that.

Are you using add_chart() and add_chart_ext() in the same program?

In order to investigate this you will probably need to post a cut down version of the program that demonstrates the issue. Or at least show the sections of the program that generate charts.

--
John.

  • Comment on Re: add_chart_ext does not work when compressed

Replies are listed 'Best First'.
Re^2: add_chart_ext does not work when compressed
by samuelalfred (Sexton) on Apr 21, 2011 at 07:01 UTC

    Thanks for your reply! Below is the code that generates the error, if the user selects not to include a graph in the excel file (i.e. $graph==0) the error does not appear. I guess that means that it has to be the add_chart_ext command that generates the error

        if ($graph==1)
    {
        #Write values for run chart
        $hidden_worksheet->write(0,$stab_column_end+1,"Time");
        $hidden_worksheet->write_col(1,$stab_column_end+1,\@time_data)
+;
        $hidden_worksheet->write(0,$stab_column_end+2,"Speed 1");
        $hidden_worksheet->write_col(1,$stab_column_end+2,\@speed_1_da
+ta);
        $hidden_worksheet->write(0,$stab_column_end+3,"Speed 2");
        $hidden_worksheet->write_col(1,$stab_column_end+3,\@speed_2_da
+ta);
        $hidden_worksheet->write(0,$stab_column_end+4,"Speed 3");
        $hidden_worksheet->write_col(1,$stab_column_end+4,\@Speed_3_da
+ta);
    
        #Add run chart
        my $run_chart = $workbook->add_chart_ext('.\charts\run_chart.b
+in',"Step response run");
        $worksheet->store_formula('=Hidden data sheet!A1');
    }

    [download]

    There's alot more code generating a bunch information in the excel sheet before this snippet is executed, I don't know if that could affect anything. Furtheron, I have ensured that I have the bin-file run_chart at the indicated path.

    Is there anything I'm doing wrong here?

    Thank you in advance!

[reply]
[d/l]
      I'm at a loss to see how this is happening in Spreadsheet::WriteExcel, either inside or outside of a Cava package.

      Could you add Devel::SimpleTrace to your program and post the stack trace of the failing code.

      --
      John.

[reply]
        maybe his $cwd isn't meshing with add_chart_ext('.\charts\run_chart.bin' or maybe he is filtering the packed modules through PodStrip or another one
[reply]
[d/l]

In Section Seekers of Perl Wisdom