Cell coordinate can not be zero-length string about phpexcel HOT 10 CLOSED

So I tried older commits until one worked again which is dae5296.

from phpexcel.

As I remember it appears only in the development branch. No?

from phpexcel.

Yes.

from phpexcel.

Is this opening and saving an xls or opening and saving an xlsx?

from phpexcel.

It seems fixed here: #29

I tried opening XLS, XLSX, and ODS and saving to XLS or XLSX.

from phpexcel.

Resolved in my local version and will commit/merge to develop later today

from phpexcel.

Full fix should now be committed and merged to develop branch

from phpexcel.

Got the this traceback with PHPExcel 1.7.8. It is not the same line as above but the message and trace looks otherwise very much the same. I am wondering if the problem is supposed to be fixed with this version as it was released in December 2012.

Well, I looked at the initial trace dump and yes, mine and the initial are quite different. Nevertheless, the software crashes and it appears that it happens if there is graphics in the .xls Excel file.

Remark: I need to use a slightly different path because the software I am writing for has decided to use a non-standard path.

PHP Fatal error:  Uncaught exception 'PHPExcel_Exception' with message 'Cell coordinate can not be zero-length string' in /data/home/dcim/openDCIM-2.0.2/PHPExcel/PHPExcel/Cell.php:536
Stack trace:
#0 /data/home/dcim/openDCIM-2.0.2/PHPExcel/PHPExcel/Reader/Excel5.php(956): PHPExcel_Cell::coordinateFromString(NULL)
#1 /data/home/dcim/openDCIM-2.0.2/extras/read_a-f_rack_content.php(396): PHPExcel_Reader_Excel5->load(Object(SplFileInfo))
#2 /data/home/dcim/openDCIM-2.0.2/extras/read_a-f_rack_content.php(544): ExcelContentProcessing->read_rack_content(Object(SplFileInfo))
#3 /data/home/dcim/openDCIM-2.0.2/extras/read_a-f_rack_content.php(558): traverse_rack_content_repo(Object(Configuration), Object(ExcelContentProcessing))
#4 {main}
  thrown in /data/home/dcim/openDCIM-2.0.2/PHPExcel/PHPExcel/Cell.php on line 536

from phpexcel.

Obviously a different problem: This is in the Excel5 Reader when reading objects such as cell comments or images, the closed issue was with the Excel2007 Writer when using defined names in AutoFilter ranges. Don't know what object type it's located in your file without examining the file

from phpexcel.

＋1 😂

Version Info

 * @category   PHPExcel
 * @package    PHPExcel
 * @copyright  Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)
 * @license    http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt	LGPL
 * @version    1.7.8, 2012-10-12

Error

2016/12/20 09:33:29 [error] 48562#0: *59826 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught exception 'PHPExcel_Exception' with message 'Cell coordinate can not be zero-length string' in /Users/.../util/excel_new/PHPExcel/Cell.php:536
Stack trace:
#0 /Users/.../util/excel_new/PHPExcel/Worksheet.php(1121): PHPExcel_Cell::coordinateFromString('')
#1 /Users/.../util/excel_new/PHPExcel/Reader/Excel2007.php(1352): PHPExcel_Worksheet->getCell('')
#2 /Users/.../util/excel_new/PHPExcel/IOFactory.php(192): PHPExcel_Reader_Excel2007->load('/Users/...')
#3 /Users/.../controllers/erp/ajax/erp_batch_import.php(47): PHPExcel_IOFactory::load('/Users/...')

from phpexcel.