DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=26862>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=26862 Clone Sheet with Charts... Summary: Clone Sheet with Charts... Product: POI Version: unspecified Platform: Other OS/Version: Other Status: NEW Severity: Normal Priority: Other Component: HSSF AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] Hi there, I am trying to create a report in Excel using POI. I read an Excel file as a template which also contins formulaes. Then I have to create around 15 Sheets dynamically for the report, in the same workbook. I create the first sheet successfully, and for the next on, I simply clone the first one. I found that if the template (and hence first sheet) draws the chart correctly. And for the cloned sheets, it clones the chart as it is, means it just places the same view on all the sheets. The reason is that, the value range and series still referes to the first sheet, and does not dynamically update the sheet reference. I think this should be a small bug where the sheet name is not provided dynamically to the chart values.. Cheers - Amol Athavale --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
