1+1 = 10

[samuelgmartins]

$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Teste 1')
                              ->setCellValue('B1', '=2*5')
                              ->setCellValue('C1', '=1+1');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'HTML');
$objWriter->save('php://output');

returns
Teste 1 10 10

---

The problem is in the cache control when writing HTML.
The function getCoordinate() returns the last location in the cache (_currentObjectID) and not the current cell.
I managed to solve the function "_genererateRow" in "Writer/HTML.php" line in 1112, but this is not the ultimate solution.

// Write cells
$colNum = 0;
foreach ($pValues as $cell) {
                $pSheet->getCellByColumnAndRow($colNum, $pRow);

[eplaut]

Hi,

done some research here.
The problem is cell->getCoordinate() using the cache, which is shared to all cells (it is actually part of $cell->_parent which is the worksheet itself)
meaning while generating the rows cell (Writer_HTML:430-436) the "pointer" of the current row is progressing to the last cell in the row. later (at Writer_HTML->_generateRow()) when trying $cell->getCalculateValue() (line 1174) it always get the calculate value from the last cell.

there are two solutions:

1. BAD ONE: for each cell on the constructor set $this->_parent as clone of the instance $parent. (will take a lot of memory, and will lose the ability of really get to the parent).
2. GOOD ONE: set the coordinate of the cell as new private parameter, and change getCoordinate/Row/Column (and maybe some more functions) to read from that parameter.

Please add your input.

Thanks,
Eli

[MarkBaker]

I've taken the approach of passing an array of cell addresses to the _generateRow() method rather than an array of cells, and selecting each cell within _generateRow() which eliminates this issue.

[MarkBaker]

Thanks for the investigation work @eplaut