PHPOffice / PhpSpreadsheet

     *

     * @return Cell

     */

    public function setDataValidation(Cell\DataValidation $pDataValidation = null)

    {

        if (!isset($this->parent)) {

            throw new Exception('Cannot set data validation for cell that is not bound to a worksheet');

        }

        $this->getWorksheet()->setDataValidation($this->getCoordinate(), $pDataValidation);

        return $this->notifyCacheController();

    }

    /**

     *    Does this cell contain a Hyperlink?

     *

     * @return Cell

     */

    public function setHyperlink(Cell\Hyperlink $pHyperlink = null)

    {

        if (!isset($this->parent)) {

            throw new Exception('Cannot set hyperlink for cell that is not bound to a worksheet');

        }

        $this->getWorksheet()->setHyperlink($this->getCoordinate(), $pHyperlink);

        return $this->notifyCacheController();

    }

    /**

     * Get parent worksheet.