PHPOffice / PHPExcel

ARCHIVED
Other
11.46k stars 4.19k forks source link

Uncaught PHPExcel_Exception: Invalid cell coordinate #1281

Open komorny opened 7 years ago

komorny commented 7 years ago

When I call PHPExcel_Worksheet->setCellValue('_my_label', 'value'), new version of phpExcel raise this error message: Uncaught PHPExcel_Exception: Invalid cell coordinate

I have in my worksheet labeled cells (define name) with lowercase names, but function setCellValue() in Worksheet.php convert name to uppercase version and raise error, because in worksheet is cell with lowercase label.

Worksheet.php - Row 1085: $cell = $this->getCell(strtoupper($pCoordinate))->setValue($pValue);