Description: ------------ setBgColor seems to create a problem for formatting the cell content. See below. Reproduce code: --------------- $total =& $workbook->addFormat(); $total->setNumFormat('#,##0.00 "€";-#,##0.00 "€"'); $total->setBgColor('Gray'); // take this line out and all OK $worksheet->writeFormula(31, 1, "=SUM(B27:B31)", $total); Expected result: ---------------- cell B32 should sum the cells above it, be formatted and have a gray background. Actual result: -------------- It seems OK until values are entered into the cells above at which point the bg goes black. The cell's content format (Format->Cells) can't be accessed from Excel when setBgColor is set, regardless of whether setNumFormat is set.

Change the example into $total->setFgColor('gray'); and everything works fine, the documentation of setBgColor mentions set most users really want setFgColor. I really can't see an open bug here, this should be closed.

Thank you for taking the time to write to us, but this is not a bug. The function makes its job :)