{"action":"created","issue":{"url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/796","repository_url":"https://api.github.com/repos/PHPOffice/PHPExcel","labels_url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/796/labels{/name}","comments_url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/796/comments","events_url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/796/events","html_url":"https://github.com/PHPOffice/PHPExcel/issues/796","id":128159243,"number":796,"title":"PHPExcel changes Templatestyles","user":{"login":"Norcoen","id":1840514,"avatar_url":"https://avatars.githubusercontent.com/u/1840514?v=3","gravatar_id":"","url":"https://api.github.com/users/Norcoen","html_url":"https://github.com/Norcoen","followers_url":"https://api.github.com/users/Norcoen/followers","following_url":"https://api.github.com/users/Norcoen/following{/other_user}","gists_url":"https://api.github.com/users/Norcoen/gists{/gist_id}","starred_url":"https://api.github.com/users/Norcoen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Norcoen/subscriptions","organizations_url":"https://api.github.com/users/Norcoen/orgs","repos_url":"https://api.github.com/users/Norcoen/repos","events_url":"https://api.github.com/users/Norcoen/events{/privacy}","received_events_url":"https://api.github.com/users/Norcoen/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-01-22T13:42:58Z","updated_at":"2016-04-11T18:09:21Z","closed_at":null,"body":"I read a template.xslx with some headers and styling in the first 2 rows and fill it from an array, starting at A3.\r\nPHPExcel changes the style of the header, in my case from lightblue background to a light-blueish-grey.\r\nOn merged cells he drops the white text color back to black.\r\n[tpl_ecoparts.xlsx](https://github.com/PHPOffice/PHPExcel/files/100834/tpl_ecoparts.xlsx)\r\n"},"comment":{"url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/comments/208481636","html_url":"https://github.com/PHPOffice/PHPExcel/issues/796#issuecomment-208481636","issue_url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/796","id":208481636,"user":{"login":"KoulSlou","id":5540550,"avatar_url":"https://avatars.githubusercontent.com/u/5540550?v=3","gravatar_id":"","url":"https://api.github.com/users/KoulSlou","html_url":"https://github.com/KoulSlou","followers_url":"https://api.github.com/users/KoulSlou/followers","following_url":"https://api.github.com/users/KoulSlou/following{/other_user}","gists_url":"https://api.github.com/users/KoulSlou/gists{/gist_id}","starred_url":"https://api.github.com/users/KoulSlou/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KoulSlou/subscriptions","organizations_url":"https://api.github.com/users/KoulSlou/orgs","repos_url":"https://api.github.com/users/KoulSlou/repos","events_url":"https://api.github.com/users/KoulSlou/events{/privacy}","received_events_url":"https://api.github.com/users/KoulSlou/received_events","type":"User","site_admin":false},"created_at":"2016-04-11T18:09:21Z","updated_at":"2016-04-11T18:09:21Z","body":"I think I have faced with the same issue. In code I read template file that have background colors for the first 3 rows. This is how original template looks like:\r\n\r\n![original_template](https://cloud.githubusercontent.com/assets/5540550/14437240/4e78408c-ffee-11e5-9563-5af8dac4781b.png)\r\n\r\nHere is a sample code - I just open and save file:\r\n\r\n    `  //Template from VitalSource\r\n        $template = APPLICATION_PATH.'/../public/VitalSourceTemplate.xlsx';\r\n\r\n        // Read the file\r\n        $fileType = PHPExcel_IOFactory::identify($template);\r\n        $objReader = PHPExcel_IOFactory::createReader($fileType);\r\n        $objPHPExcel = $objReader->load($template);\r\n\r\n        $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, $fileType);\r\n        $objWriter->save('checkColor.xlsx');\r\n        die('finish');`\r\n\r\nAnd now if you look into created file - checkColor.xlxs - you will see that colors are totally different. \r\n\r\n\r\n![after open](https://cloud.githubusercontent.com/assets/5540550/14437344/c752b5aa-ffee-11e5-950c-1817b1f534f8.png)\r\n\r\nMy question is why colors are changing? Is there any way to prevent it? So far all I can do is specify correct colors before calling \"createWriter\"\r\n"}}