Cell Protection Issues

Topics: Developer Forum
Jul 10, 2013 at 6:59 PM
I'm trying to protect a range of cells in my worksheet, but every cell in the worksheet becomes protected.
$objPHPExcel->getActiveSheet()->getProtection()->setSheet(true);
$objPHPExcel->getActiveSheet()->protectCells("K1:K987");
Instead of only protecting the cells in the K column it protects every cell in the document. Does anyone know how to fix this?

Even if there's just a way to disable cell protection for a range, that would work too.
Coordinator
Jul 10, 2013 at 10:14 PM
$objPHPExcel->getActiveSheet()->unprotectCells("A1:J987");