Copying a worksheet makes charts disappear

Jul 2, 2011 at 7:01 PM
Edited Jul 2, 2011 at 7:37 PM

Hi,

One thing I just can't get to work is to copy an existing worksheet and keep the chart on it.

What I do right now is this:

 

$template_sheet = $excel->getSheetByName("template");
$sheet = $template_sheet->copy();
$sheet->setTitle("new");
$excel->addSheet($sheet,0);

The idea is to copy existing template with 'fancy' charts and only change the data in the new sheet, which should update the charts, right?

As far as I can see copying the template sheet clears all charts. Is there something I can do?

Thanks,

DD

PS. I read that creating charts is not supported yet, does this meat that copying existing charts doesn't work either?