in reply to Re: Excel editing perl
in thread Excel editing perl

Hi, I even tried keep that global variable as local and passing it as parameter to the required function. But it produces the same result. The problem is :-

If I generate 10 charts, 9 charts are correct.

But the last chart has problem. The labeling done at x-axis of last chart is missing every alternative attribute.

what shall i do to resolve this issue??

Regards

Replies are listed 'Best First'.
Re^3: Excel editing perl
by jethro (Monsignor) on Sep 29, 2011 at 12:48 UTC

    The advice from GrandFather about global variables was not about correcting your bug but making your script a) debuggable and b) readable by others.

    The next thing to do is either a) use print statements or the built-in debugger to tell you for example what data the subroutine gets per invocation and what it does with it or b) reproduce your refinded script on this website to let perlmonks help you with the search for the bug (ideally a minimal(!) runable(!) script that shows the problem)

[reply]
      Hey, I used the debugger and I did tracing too. The point is :-

      we have a graph in which we have x-axis. x-axis is labeled 1,2,3,4,5 and so on. When my script runs, it does labeling everytime the function is called. But it doesn't do labeling last time function is called.

      The point is those label values are there in the excel. If I right click on the x-axis attributes and click on select data, all the attributes can be seen. But all those attributes are not there if i see the graph.

      Right Clicking on the attributes of same graph and select data shows all the attributes but directly it doesn't show attributes.

[reply]

        You used the debugger? Excellent. What did you find out? I think one very interesting question would be: How does the function know it is called the last time? Is it because you are at the last "page" of your excel file and there is some closing data missing? Or is it because some final cleanup damages your data? What happens if you read that file into Excel, maybe append some data and save it again ?

        Can you rule out (through your debugging) the possibility that you feed the wrong data to the excel module on your last call of the function? If yes, the bug is not in the code you reproduced

        You could also change the parameters of your graphs to see if there is some condition necessary to activate the bug. What happens if you don't do the last insert_chart?

        PS: Did it occur to you that you didn't even tell us which CPAN module you use to create the graphs. Maybe there is only one and everybody knows it, but I wouldn't count on that.

[reply]

In Section Seekers of Perl Wisdom