Re^3: Excel editing perl

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)

Comment on Re^3: Excel editing perl

Replies are listed 'Best First'.
Re^4: Excel editing perl by tarunkhanna (Novice) on Sep 29, 2011 at 15:04 UTC
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]
Re^5: Excel editing perl by jethro (Monsignor) on Sep 30, 2011 at 09:43 UTC
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]