I have an excel file with 2 sheets. One for some raw data and the other one is a dashboard with only formulas. Some cells from the dashboard sheet are set up to with a conditional formatting.
I use PHPExcel to open this file and then to feel up the raw data sheet. But when the work is done the whole format of my dashboard sheet is bugged. For example the cells set up with a % format are shown in a decimal format and Excel doesn't want to change it back to a % format.
To fill up my raw data sheet I use the exact same code as read and write using phpexcel while using listWorksheetNames()
When I remove the Conditional Formatting formula everything works fine and I don't have any bug.
