I am generating a spreadsheet with 4 data sheets and 4 chart sheets. When first creating a new excel xls file, I encounter the following error message 4 times when opening the spreadsheet. "File error: data may have been lost." The spreeadsheet looks OK once it is open except that the name of the first sheet generated is mangled. For instance, instead of being "download" it is, "#@$#awnload." At this point the only way I can change the name is to save the spreadsheet and exit excel. It will core dump with some nasty message when you do this. Then open the spreadsheet again. This time the error messages will not present and, once up, I can change the name of the managled sheet by right clicking on it and using the rename capability of excel.

> "File error: data may have been lost."

This error is explained in Step 11 of the Methodology in the Chart documentation. You can also see how it is dealt with in the example files. The charting documentation isn't exhaustive but it is important to try to follow it as closely as possible.

> For instance, instead of being "download" it is, "#@$#awnload."

I can't reproduce this. Upgrade to the latest version of Spreadsheet::WriteExcel and see if the problem persists. If it does, see if you can post an example based on the bug_report.pl program in the examples directory of the distro.

John.
--

Could you provide what formats have you add to solve this problem? Thanks!

Thanks John! How to set Excel chart axis labels or set the title with bold in perl? where should I find these functions or methods? Is there any documentation? Thanks!