Do not read links from ODS

Topics: Developer Forum, Project Management Forum
Jun 4, 2015 at 12:46 PM
Edited Jun 4, 2015 at 12:47 PM
Hello.
Try to read this 2 same files:
https://www.dropbox.com/s/7kjnmji2kxo3f0x/Noname4.ods?dl=0
https://www.dropbox.com/s/miubcv8w52rct5e/Noname4.xls?dl=0

Use PHPExcel 1.8.0 and this code
$objPHPExcel = PHPExcel_IOFactory::load($inputFileName);
$objPHPExcel->setActiveSheetIndex(0);
$aSheet = $objPHPExcel->getActiveSheet();

$array = array();
foreach($aSheet->getRowIterator() as $j=>$row)
{
    $cellIterator = $row->getCellIterator();

    $item = array();
    foreach ($cellIterator as $i=>$cell)
        $item[$i] = $cell->getCalculatedValue();
    if (!empty($item))
        $array[$j-1] = $item;
}

print_r($array);
From XLS get:
Array
(
[0] => Array
    (
        [0] => 123123
        [2] => http://www.ddvhouse.ru/asd/
    )

[1] => Array
    (
        [0] => 78645
        [1] => 300
    )

[2] => Array
    (
        [0] => Phrase
        [1] => 500
    )
)

And from ODS:

Array
(
[0] => Array
    (
        [0] => 123123
        [2] =>
    )

[1] => Array
    (
        [0] => 78645
        [1] => 300
    )

[2] => Array
    (
        [0] => Phrase
        [1] => 500
    )
)


Link http://www.ddvhouse.ru/asd/ is gone.
PHPExcel 1.7.4 return link in both.