Uncaught exception 'Exception' with message 'Column string index can not be longer than 2 characters.

Topics: Developer Forum
May 29, 2008 at 9:01 AM

problem is that there is no colomn that is longer than 2 characters

Fatal error:
Uncaught exception 'Exception' with message 'Column string index can not be longer than 2 characters.'
in /xls_test/1.6.1/Classes/PHPExcel/Cell.php:479

Stack trace: #0 /xls_test/1.6.1/Classes/PHPExcel/ReferenceHelper.php(450):
PHPExcel_Cell::columnIndexFromString('$AM') #1 /xls_test/1.6.1/Classes/PHPExcel/ReferenceHelper.php(397):
PHPExcel_ReferenceHelper->_updateSingleCellReference('$AM$3', 'A1', 0, 1) #2 /xls_test/1.6.1/Classes/PHPExcel/ReferenceHelper.php(311):
PHPExcel_ReferenceHelper->updateCellReference('$AM$3', 'A1', 0, 1) #3 /xls_test/1.6.1/Classes/PHPExcel/Reader/Excel2007.php(327):
PHPExcel_ReferenceHelper->updateFormulaReferences('=IF(S4=$AM$3,"O...', 'A1', 0, 1) #4 /xls_test/test.php(17):
PHPExcel_Reader_Excel2007->load('tr_seuranta.xls...') #5 {main} thrown in /xls_test/1.6.1/Classes/PHPExcel/Cell.php on line 479