DO NOT REPLY [Bug 26862] New: - Clone Sheet with Charts...

[bu...@apache.org]

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: poi-dev@jakarta.apache.org
        ReportedBy: amolathavale@hotmail.com


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: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org