Re^4: Excel editing perl

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.

Comment on Re^4: Excel editing perl

Replies are listed 'Best First'.
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]

Replies are listed 'Best First'.

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]