Uncaught exception 'PHPExcel_Calculation_Exception'

Topics: Developer Forum
May 16, 2014 at 4:12 PM
I recently started receiving the following error. Turning off calculations did not seem to help. Any ideas?
[16-May-2014 10:42:47 America/Chicago] PHP Fatal error:  Uncaught exception 'PHPExcel_Calculation_Exception' with message 'Worksheet!AB2 -> Worksheet!AB2 -> Worksheet!AB2 -> internal error' in /var/www/html/barcode/PHPExcel/Cell.php:300
Stack trace:
#0 /var/www/html/barcode/PHPExcel/Worksheet.php(754): PHPExcel_Cell->getCalculatedValue()
#1 /var/www/html/barcode/PHPExcel/Writer/Excel5/Worksheet.php(295): PHPExcel_Worksheet->calculateColumnWidths()
#2 /var/www/html/barcode/PHPExcel/Writer/Excel5.php(187): PHPExcel_Writer_Excel5_Worksheet->close()
#3 /var/www/html/barcode/export.php(1940): PHPExcel_Writer_Excel5->save('php://output')
#4 {main}
  thrown in /var/www/html/barcode/PHPExcel/Cell.php on line 300
May 16, 2014 at 4:26 PM
If you have columns that are set to autocalculate width, then PHPExcel has to calculate any formulae in cells in those columns in order to calculate the required width; you can't turn calculation off in that circumstance
May 16, 2014 at 5:12 PM
Thanks, Mark! Turning off autocalculation of the width did the trick.