Styles not cloned properly for Excel5 when insert new rows using PHPExcel version 1.7.1

Topics: Developer Forum, User Forum
Nov 4, 2009 at 10:29 AM
Edited Nov 4, 2009 at 10:31 AM


We currently using PHPExcel version 1.7.0 and we have no issue in styles when we insert new rows before any rows that already have styles. However, when we switched to version 1.7.1, in Excel5 writer, the background color of rows changed when we insert new rows before the rows have some background color. Also, When we used Excel2007 writer, the borders and default font not set properly. We have no issue with the discussed items in version 1.7.0 but we need to use some features and bug fixes of 1.7.1. As, the code is proprietary, so I am unable to send or create some sample, however, I have attached screenshots:

Thanks in advance.


Nov 5, 2009 at 1:16 AM

Thanks for your report. This is something we very much would like to get fixed.

Unfortunately, I am not able to reproduce this by running some simple tests locally. So I ask you to send me those files from your screen shots for closer examination.

Please send me the files to this email address: (erik at phpexcel dot net)

Nov 5, 2009 at 4:52 AM

Thanks Koyama! Let me get some free and try to create some sample. I will hopefully re-contact you.

Thanks again and Regards.

Nov 8, 2009 at 3:06 AM

Files received via email. Bug verified.

Download latest source code tomorrow from here:

Nov 11, 2009 at 9:02 AM

Problems were only partially solved. New work item created:


Nov 12, 2009 at 2:40 AM

Can you check again with latest source code tomorrow:

Nov 14, 2009 at 7:27 AM

Thanks Koyama! my problems have been solved. We have reset the font by giving the rang of cells.

Once again thanks.