Internal error

Topics: Developer Forum
Jun 24, 2013 at 12:42 PM
Hello, I got a message of internal error:
Fatal error: Uncaught exception 'PHPExcel_Calculation_Exception' with message 'CForts!D334 -> internal error' in F:\Dropbox\htdocs\includes\PHPExcel_1.7.9\Classes\PHPExcel\Cell.php:298 Stack trace: #0 F:\Dropbox\htdocs\includes\PHPExcel_1.7.9\Classes\PHPExcel\Writer\Excel2007\Worksheet.php(1078): PHPExcel_Cell->getCalculatedValue() #1 F:\Dropbox\htdocs\includes\PHPExcel_1.7.9\Classes\PHPExcel\Writer\Excel2007\Worksheet.php(1025): PHPExcel_Writer_Excel2007_Worksheet->_writeCell(Object(PHPExcel_Shared_XMLWriter), Object(PHPExcel_Worksheet), 'D334', Array, Array) #2 F:\Dropbox\htdocs\includes\PHPExcel_1.7.9\Classes\PHPExcel\Writer\Excel2007\Worksheet.php(83): PHPExcel_Writer_Excel2007_Worksheet->_writeSheetData(Object(PHPExcel_Shared_XMLWriter), Object(PHPExcel_Worksheet), Array) #3 F:\Dropbox\htdocs\includes\PHPExcel_1.7.9\Classes\PHPExcel\Writer\Excel2007.php(253): PHPExcel_Writer_Excel2007_Worksheet->writeWorksheet(Object(PHPExcel_Worksheet), Array, false) #4 F:\Dropbox\htdocs\princip\DPGE2.php(35): PHPExcel_Writer_Excel2 in F:\Dropbox\htdocs\includes\PHPExcel_1.7.9\Classes\PHPExcel\Cell.php on line 298

Someone could tell me what is the main problem of this error?
Coordinator
Jun 24, 2013 at 1:39 PM
Perhaps knowing what's in cell CForts!D334 might help (I'm assuming that it's a formula), otherwise it's impossible to give you any answer other than "don't know"
Jun 26, 2013 at 9:56 AM
It is just a name of another cell of another worksheet(. I solved this problem by setPreCalculateFormulas(false) : )
Coordinator
Jun 27, 2013 at 10:33 AM
If it was that simple, it should have worked.... I can't help or solve problems without knowing the details that cause the problem
Jun 27, 2013 at 12:24 PM
It works now when I put setPreCalculateFormula.
Jun 10, 2014 at 7:39 PM
Hey I am seeking a solution for PHPExcel for my problem:

The error I got is:

Fatal error: Uncaught exception 'PHPExcel_Calculation_Exception' with message 'D
ata Collection!H2 -> internal error' in C:\common_lib\PHPExcel_1.8.0\Classes\PHP
Excel\Cell.php:300
Stack trace:

0 C:\xampp\htdocs\nosa\myclasses\dbmigration\ValueTreeMigrate.php(3454): PHPExc

el_Cell->getCalculatedValue()

1 C:\xampp\htdocs\nosa\myclasses\dbmigration\ValueTreeMigrate.php(3434): ValueT

reeMigrate->loadWorkSheetData(Object(PHPExcel_Worksheet))

The data in cell is "=KPS1_Name" which reference to a cell in another sheet and it should be simple, the phpexcel is 1.8.

Thanks a lot for your kind help.

Goshen
Jun 10, 2014 at 7:41 PM
The code is:

$origVal = trim($worksheet->getCellByColumnAndRow($colIndex, $rowIndex)->getCalculatedValue());