How to lock particular cell using phpspreadsheet

Question

Initially all cells in worksheet are locked. Then, I unlock all the cells and try to lock only some of the cells.

$spreadsheet->getActiveSheet()->getStyle('A1')->getLocked()->applyFromArray(
      [
          'locked' => TRUE,
          'hidden' => FALSE
     ]);

But, end up with this error.

Uncaught Error: Call to undefined method PhpOffice\PhpSpreadsheet\Style\Style::getLocked()

Thanks in advance.

Answer 1

This code able to lock the cell we want.

$sheet->getStyle('A1')->getProtection()->setLocked(\PhpOffice\PhpSpreadsheet\Style\Protection::PROTECTION_INHERIT);

or

 $sheet->getStyle('A1')->getProtection()->setLocked(\PhpOffice\PhpSpreadsheet\Style\Protection::PROTECTION_PROTECTED);

Still, I would like to know why applyFromArray not working to lock the cell. Anyone know the answer, can post your answer. Thanks.