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) {

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

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

                    }

                    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) {

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