1

I has a big problem. I read a xlsx to fill out it with data. If I save it as xlsx and load it in Excel there is a problem with the color of some cells.

A cell with the value a or n should be red. With x oder e it should be white.

If I load the original xlsx in Excel it works. But the xlsx from phpspreadsheet dont work correct. The cells under a or n get red not the cell itselfe.

Is there a way to remove the conditinal formatting? The sheet is protected. If I can remove the protection and formatting I can set the color while I fill out the sheet.

0 Answers0