after copy sheet(Workbook.cloneSheet()) chart linking to prev. page First sheet name : "report" (have a Chart) ater cloneSheet() Second page name : "report(2)"(have a Chart but datalink to "report")
Created attachment 10436 [details] Excel report with copied sheets and charts
Hi Sergey, This is currently functionality "as implemented", and i know for one that i dont have any time to change it. You are welcome to get your hands dirty and contribute a patch. Have a dig arround in the java\org\apache\poi\hssf\record area and look for where the series for charts are specified. Alternatively I believe that Andy can provide you with paid support I suspect that the best approach is to keep the clone functionality "as is" but expose a high level API to the chart in the new sheet to change its series. But this would require alot of work. Jason
*** This bug has been marked as a duplicate of bug 26862 ***