Hi, The Apache POI project makes a claim that it can copy/clone information in and existing workbook/worksheet. BUT, when I try to copy a worksheet that contains a pre-existing chart (using this as a template) and put this into another worksheet, it does not copy it properly as far as I can tell. I tried Apache POI 3.9, 3.10, and 3.11, AND none of these worked. I hope this can be fixed soon. Regards, P
I support (In reply to palmerr_2002 from comment #0) > Hi, > The Apache POI project makes a claim that it can copy/clone information > in and existing workbook/worksheet. > > BUT, when I try to copy a worksheet that contains a pre-existing chart > (using this as a template) and put this into another worksheet, it does not > copy it properly as far as I can tell. > I tried Apache POI 3.9, 3.10, and 3.11, > AND none of these worked. > > I hope this can be fixed soon. > > Regards, > > P I second this as well, we resorted to JFreeChart as there's we didn't find any feasible way to copy the charts from one workbook to another.
This is already handled under bug 54470 which has some proposed changes, albeit they are likely not the full solution yet as e.g. the chart-source rows are not properly cloned over. Anyway, further discussion of this should be done in Bug 54470. *** This bug has been marked as a duplicate of bug 54470 ***