it doesn't work! problems with OOorg3

Jan 6, 2009 at 4:58 PM
hi
i've openoffice3, and installed phpexcel 1.6.4 and now 1.6.5

if i use excel5 i can't view images, and if i use excel2007 i can't open file !!

i tried 14excel5.php and 05featuredemo.php, i tried my own test, i checked for extensions (zip, xml, gd2), i tried easyphp2b2 and wampserver2, and tried on 2 pc
ALL with the SAME problems!!!!

what i need to see images in my xls or open xlsx???

thank you very much
Developer
Jan 6, 2009 at 6:31 PM
As for the images that cannot be seen in OpenOffice.org 3.0.0, this is a known issue, I am trying to get that solved.
http://www.codeplex.com/PHPExcel/WorkItem/View.aspx?WorkItemId=7994

As for the Excel 2007 test files that cannot be opened in OpenOffice.org 3.0.0, I don't know what the problem is. When I run the 05featuredemo.php and open 05featuredemo.xlsx in OpenOffice.org 3.0.0, I have no problems. Can you send me your result for that test (05featuredemo.xlsx) and I will try to see what the problem is (erik at phpexcel dot net)



Developer
Jan 7, 2009 at 7:03 PM
Thanks for sending me the files, the xlsx files are indeed corrupt. Looks like yet another case of bad zip extension.
http://www.codeplex.com/PHPExcel/Thread/View.aspx?ThreadId=42854

Jan 21, 2009 at 1:17 PM
1) solved xlsx using linux!

2) but with xls i've problem. i see this: http://www.codeplex.com/PHPExcel/WorkItem/View.aspx?WorkItemId=7994 but using SVN i've an error:

15:11:01 Create new PHPExcel object 15:11:01 Load Excel2007 template file
Fatal error: Class 'PHPExcel_Shared_Excel5' not found in /var/www/test/PHPExcel-24480/Classes/PHPExcel/Reader/Excel5.php on line 694
Developer
Jan 21, 2009 at 1:34 PM
Yeah, there was unfortunately missing class reference in PHPExcel_Reader_Excel5 in the recent sources, and you would get that error when reading xls files with images! (PHPExcel 1.6.5 not affected). This has just been fixed now. Thanks!

As for work item #7994, this was also fixed today and it will appear in the next automatic daily "Source Code" check-in. Please try it out then!


Jan 22, 2009 at 7:55 AM
using souce code 24512

09:50:15 Create new PHPExcel object 09:50:15 Load Excel2007 template file 09:50:15 Write to Excel5 format 09:50:15 Write to Excel5 format
Fatal error: Nesting level too deep - recursive dependency? in /var/www/test/PHPExcel-24512/Classes/PHPExcel/Writer/Excel5/Worksheet.php on line 2923
Developer
Jan 22, 2009 at 7:58 AM
Hmm... will examine this!
Developer
Jan 22, 2009 at 8:07 AM
Ouch! Coding error. This had escaped me. Maybe something to do with php version? Can you please replace line 2923 in PHPExcel/Writer/Excel5/Worksheet.php

Please change this
if ($sheet == $this->_phpSheet) {

to this:
if ($sheet === $this->_phpSheet) {

Will fix this in the source too. Thank you!

Jan 22, 2009 at 9:22 AM
OK! now ALL works PERFECTLY!! THANKS very much