AddExternalSheet doesn't copy styles

Jul 19, 2011 at 1:08 PM

I want to use Sheet as Template for multiple generated sheets.

1. I need to open source excel for each generated sheet, because parent sheet in copy() and also in addExternalSheet is removed

2. When I copy external sheet from source to new PHPExcel object, it copy everything, data, formular, images, but it doesn't copy font-sizes.

Any idea?

Jul 19, 2011 at 1:22 PM

Hi, here is corrections: When font-size is larget or equal 10, font family and font size is set also in new file.

But I have cell with Arial 8 in source file, in output file it's Calibri 11.