PHPOffice / PhpSpreadsheet

        self::assertEquals("test with new \nLines", $firstSheet->getCell('A11')->getValue());

    }

    public function testReadHyperlinks()

    {

        $spreadsheet = $this->loadOOCalcTestFile();

        $firstSheet = $spreadsheet->getSheet(0);

        $hyperlink = $firstSheet->getCell('A29');

        self::assertEquals(DataType::TYPE_STRING, $hyperlink->getDataType());

        self::assertEquals('PHPExcel', $hyperlink->getValue());

        self::assertEquals('http://www.phpexcel.net/', $hyperlink->getHyperlink()->getUrl());

    }

    /*

     * Below some test for features not implemented yet

    /**

     * Check if it can read XML Hyperlink correctly.

     */

    public function testReadHyperlinks()

    {

        $spreadsheet = $this->loadXEETestFile();

        $firstSheet = $spreadsheet->getSheet(0);

        $hyperlink = $firstSheet->getCell('L1');

        self::assertEquals(DataType::TYPE_STRING, $hyperlink->getDataType());

        self::assertEquals('PhpSpreadsheet', $hyperlink->getValue());

        self::assertEquals('http://phpspreadsheet.readthedocs.io/', $hyperlink->getHyperlink()->getUrl());

    }

}