PHPOffice / PhpSpreadsheet

     * @param int $beforeRow Number of the row we're inserting/deleting before

     * @param int $pNumRows Number of rows to insert/delete (negative values indicate deletion)

     */

    protected function adjustHyperlinks($pSheet, $pBefore, $beforeColumnIndex, $pNumCols, $beforeRow, $pNumRows)

    {

        $aHyperlinkCollection = $pSheet->getHyperlinkCollection();

        ($pNumCols > 0 || $pNumRows > 0) ?

            uksort($aHyperlinkCollection, ['self', 'cellReverseSort']) : uksort($aHyperlinkCollection, ['self', 'cellSort']);

        foreach ($aHyperlinkCollection as $key => $value) {

            $newReference = $this->updateCellReference($key, $pBefore, $pNumCols, $pNumRows);

            if ($key != $newReference) {

                $pSheet->setHyperlink($newReference, $value);

                $pSheet->setHyperlink($key, null);

            }

        }

    }

    /**

     * Update data validations when inserting/deleting rows/columns.

     *

     * @param int $beforeRow Number of the row we're inserting/deleting before

     * @param int $pNumRows Number of rows to insert/delete (negative values indicate deletion)

     */

    protected function adjustDataValidations($pSheet, $pBefore, $beforeColumnIndex, $pNumCols, $beforeRow, $pNumRows)

    {

        $aDataValidationCollection = $pSheet->getDataValidationCollection();

        ($pNumCols > 0 || $pNumRows > 0) ?

            uksort($aDataValidationCollection, ['self', 'cellReverseSort']) : uksort($aDataValidationCollection, ['self', 'cellSort']);

        foreach ($aDataValidationCollection as $key => $value) {

            $newReference = $this->updateCellReference($key, $pBefore, $pNumCols, $pNumRows);

            if ($key != $newReference) {

                $pSheet->setDataValidation($newReference, $value);

                $pSheet->setDataValidation($key, null);

            }

        }

    }

    /**

     * Update merged cells when inserting/deleting rows/columns.

     *