PHPOffice / PhpSpreadsheet

                // Loop through columns, rows, or cells again and update the XF index

                switch ($selectionType) {

                    case 'COLUMN':

                        for ($col = $rangeStart[0]; $col <= $rangeEnd[0]; ++$col) {

                            $columnDimension = $this->getActiveSheet()->getColumnDimensionByColumn($col);

                            $oldXfIndex = $columnDimension->getXfIndex();

                            $columnDimension->setXfIndex($newXfIndexes[$oldXfIndex]);

                        }

                        break;

                    case 'ROW':

                        for ($row = $rangeStart[1]; $row <= $rangeEnd[1]; ++$row) {

                        }

                        break;

                    case 'ROW':

                        for ($row = $rangeStart[1]; $row <= $rangeEnd[1]; ++$row) {

                            $rowDimension = $this->getActiveSheet()->getRowDimension($row);

                            $oldXfIndex = $rowDimension->getXfIndex() === null ?

                                0 : $rowDimension->getXfIndex(); // row without explicit style should be formatted based on default style

                            $rowDimension->setXfIndex($newXfIndexes[$oldXfIndex]);

                        }

                        break;

                    case 'CELL':

                        for ($col = $rangeStart[0]; $col <= $rangeEnd[0]; ++$col) {