getValue returns null on specific sheet

Topics: User Forum
Apr 16, 2015 at 1:02 PM
What type of formating can prevent PHPExcel from reading dato from a cell?

I'm using the string
    $cellContent = $objPHPExcel->getActiveSheet()->getCell($cellID)->getValue();
    var_dump ($cellContent);
The var_dump returns null when $cellID has certain values even though I now the cell holds a string.

The cells are merged but I have reconstructed the sheet and there i have no trouble at all reading the exact same merged cells.

The production sheet is locked for editing but I don't think that it should give any trouble as I can read other cells in the sheet.
Apr 16, 2015 at 1:34 PM
I have no idea and have never encountered anything before that prevented PHPExcel from reading a cell's value without throwing at least some kind of exception.... but formatting won't have any affect on this whatsoever, because getValue() is reading the raw cell value

Is it possible to provide a spreadsheet file and reference to a cell in that file that demonstrates this problem?
Apr 16, 2015 at 2:09 PM
I just sent a private message to MarkBaker

The soloution if found will be posted here afterwards :)