Protect Sheet But Allow Sort not working

[don-odyssey]

Hi,

When applying a filter and protecting the sheet, the Sort does not work

[don-odyssey]

Here is my PHP code

// set security
$protection = $spreadsheet->getActiveSheet()->getProtection();
$protection->setPassword($mslReportsPassword);
$protection->setSheet(true);
$protection->setInsertRows(true);
$protection->setFormatCells(true);
$protection->setObjects(true);
$protection->setAutoFilter(false);
$protection->setSort(true);

[oleibman]

Enabling sorting on a protected sheet in Excel seems more complicated than it ought to be. See https://www.extendoffice.com/documents/excel/4673-excel-sort-filter-protected-sheet.html. This means that you have to explicitly protect ranges that you want to be able to sort/filter on a protected sheet. PhpSpreadsheet supports protected ranges, except that it assumes they will always have a password (and does not support the name attribute, which I'm not sure is significant). I will treat this issue as a feature request, and start looking into that.