reference problem

Topics: Developer Forum, Project Management Forum, User Forum
Jul 12, 2011 at 10:20 AM

Hope someone can help me with this.

I ran 05featuredemo.php and got an .xlsx file. I then edited the 05featuredemo.xlsx file and added a line of code to the second worksheet named 'terms and conditions'. I added "=Invoice.E11" and i get this error after I save it and run 07reader.php:

 

Warning: simplexml_load_string() [function.simplexml-load-string]: namespace error : Namespace prefix w10 for type on wrap is not defined in /var/www/xacute/excel/Classes/PHPExcel/Reader/Excel2007.php on line 1169
Warning: simplexml_load_string() [function.simplexml-load-string]: t;height:69.7pt;visibility:hidden" type="shapetype_75"><w10:wrap w10:type="none" in /var/www/xacute/excel/Classes/PHPExcel/Reader/Excel2007.php on line 1169
Warning: simplexml_load_string() [function.simplexml-load-string]: ^ in /var/www/xacute/excel/Classes/PHPExcel/Reader/Excel2007.php on line 1169
Warning: simplexml_load_string() [function.simplexml-load-string]: namespace error : Namespace prefix w10 on wrap is not defined in /var/www/xacute/excel/Classes/PHPExcel/Reader/Excel2007.php on line 1169
Warning: simplexml_load_string() [function.simplexml-load-string]: t;height:69.7pt;visibility:hidden" type="shapetype_75"><w10:wrap w10:type="none" in /var/www/xacute/excel/Classes/PHPExcel/Reader/Excel2007.php on line 1169
Warning: simplexml_load_string() [function.simplexml-load-string]: ^ in /var/www/xacute/excel/Classes/PHPExcel/Reader/Excel2007.php on line 1169
Warning: simplexml_load_string() [function.simplexml-load-string]: namespace error : Namespace prefix w10 for type on wrap is not defined in /var/www/xacute/excel/Classes/PHPExcel/Reader/Excel2007.php on line 1169
Warning: simplexml_load_string() [function.simplexml-load-string]: t;height:56.9pt;visibility:hidden" type="shapetype_75"><w10:wrap w10:type="none" in /var/www/xacute/excel/Classes/PHPExcel/Reader/Excel2007.php on line 1169
Warning: simplexml_load_string() [function.simplexml-load-string]: ^ in /var/www/xacute/excel/Classes/PHPExcel/Reader/Excel2007.php on line 1169
Warning: simplexml_load_string() [function.simplexml-load-string]: namespace error : Namespace prefix w10 on wrap is not defined in /var/www/xacute/excel/Classes/PHPExcel/Reader/Excel2007.php on line 1169
Warning: simplexml_load_string() [function.simplexml-load-string]: t;height:56.9pt;visibility:hidden" type="shapetype_75"><w10:wrap w10:type="none" in /var/www/xacute/excel/Classes/PHPExcel/Reader/Excel2007.php on line 1169
Warning: simplexml_load_string() [function.simplexml-load-string]: ^ in /var/www/xacute/excel/Classes/PHPExcel/Reader/Excel2007.php on line 1169
Warning: simplexml_load_string() [function.simplexml-load-string]: namespace error : Namespace prefix w10 for type on wrap is not defined in /var/www/xacute/excel/Classes/PHPExcel/Reader/Excel2007.php on line 1169
Warning: simplexml_load_string() [function.simplexml-load-string]: ;height:99.95pt;visibility:hidden" type="shapetype_75"><w10:wrap w10:type="none" in /var/www/xacute/excel/Classes/PHPExcel/Reader/Excel2007.php on line 1169
Warning: simplexml_load_string() [function.simplexml-load-string]: ^ in /var/www/xacute/excel/Classes/PHPExcel/Reader/Excel2007.php on line 1169
Warning: simplexml_load_string() [function.simplexml-load-string]: namespace error : Namespace prefix w10 on wrap is not defined in /var/www/xacute/excel/Classes/PHPExcel/Reader/Excel2007.php on line 1169
Warning: simplexml_load_string() [function.simplexml-load-string]: ;height:99.95pt;visibility:hidden" type="shapetype_75"><w10:wrap w10:type="none" in /var/www/xacute/excel/Classes/PHPExcel/Reader/Excel2007.php on line 1169
Warning: simplexml_load_string() [function.simplexml-load-string]: ^ in /var/www/xacute/excel/Classes/PHPExcel/Reader/Excel2007.php on line 1169

 

My main concern is that when I actually try this type of reference for an important .xls file that I want to work on, useing this line of code '=Cover.C7' I get an error like this:

 

Notice: Undefined offset: 12 in /var/www/xacute/excel/Classes/PHPExcel/Reader/Excel5.php on line 839
Fatal error: Call to a member function getNestingLevel() on a non-object in /var/www/xacute/excel/Classes/PHPExcel/Reader/Excel5.php on line 842


If I convert that same .xls file to a .ods, and run the same time reader, I get this

11:19:07 Write to Excel2007 format
Fatal error: Uncaught exception 'Exception' with message 'Page 1!C2 -> Formula Error: An unexpected error occured' in /var/www/xacute/excel/Classes/PHPExcel/Cell.php:288 Stack trace: #0 /var/www/xacute/excel/Classes/PHPExcel/Writer/Excel2007/Worksheet.php(984): PHPExcel_Cell->getCalculatedValue() #1 /var/www/xacute/excel/Classes/PHPExcel/Writer/Excel2007/Worksheet.php(930): PHPExcel_Writer_Excel2007_Worksheet->_writeCell(Object(PHPExcel_Shared_XMLWriter), Object(PHPExcel_Worksheet), 'C2', Array, Array) #2 /var/www/xacute/excel/Classes/PHPExcel/Writer/Excel2007/Worksheet.php(82): PHPExcel_Writer_Excel2007_Worksheet->_writeSheetData(Object(PHPExcel_Shared_XMLWriter), Object(PHPExcel_Worksheet), Array) #3 /var/www/xacute/excel/Classes/PHPExcel/Writer/Excel2007.php(266): PHPExcel_Writer_Excel2007_Worksheet->writeWorksheet(Object(PHPExcel_Worksheet), Array) #4 /var/www/xacute/excel/Tests/Adams4.php(42): PHPExcel_Writer_Excel2007->save('/var/www/xacute...') #5 {main} thrown in /var/www/xacute/excel/Classes/PHPExcel/Cell.php on line 288

 

Hope this makes sense. Would love some input or feedback on this :) Thank in advance.