-
Bug
-
Resolution: Fixed
-
None
-
Medium
-
investigate a submitted report. But there is no problem in Translate5. Look like user "destroyed" Excel by deleting the "meta-sheet"
-
Emptyshow more show less
Aleks note in Slack
can you check this problem:
ERROR in core: E9999 - Workbook does not contain sheet:meta data
Exception: PhpOffice\PhpSpreadsheet\Exception
Level: ERROR
Errorcode: E9999
Message: Workbook does not contain sheet:meta data
Domain: core
Version: 6.8.1
File (Line): /var/www/instances-local/instance-1031/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Spreadsheet.php (822)
User: xxxx
Request: POST https://xxxx/editor/task/22756/excelreimport
Trace:#0 /var/www/instances-local/instance-1031/application/modules/editor/Models/Excel/ExImport.php(287): PhpOffice\PhpSpreadsheet\Spreadsheet->setActiveSheetIndexByName()
#1 /var/www/instances-local/instance-1031/application/modules/editor/Models/Excel/ExImport.php(189): editor_Models_Excel_ExImport->getSheetMeta()
#2 /var/www/instances-local/instance-1031/application/modules/editor/Models/Import/Excel.php(90): editor_Models_Excel_ExImport::loadFromExcel()
#3 [internal function]: editor_Models_Import_Excel->__construct()
#4 /var/www/instances-local/instance-1031/library/ZfExtended/Factory.php(56): ReflectionClass->newInstanceArgs()
#5 /var/www/instances-local/instance-1031/application/modules/editor/Controllers/TaskController.php(840): ZfExtended_Factory::get()
#6 /var/www/instances-local/instance-1031/vendor/shardj/zf1-future/library/Zend/Controller/Action.php(516): editor_TaskController->excelreimportAction()
#7 /var/www/instances-local/instance-1031/library/ZfExtended/Controllers/AAARestController.php(349): Zend_Controller_Action->dispatch()
#8 /var/www/instances-local/instance-1031/vendor/shardj/zf1-future/library/Zend/Controller/Dispatcher/Standard.php(308): ZfExtended_RestController->dispatch()
#9 /var/www/instances-local/instance-1031/vendor/shardj/zf1-future/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch()
#10 /var/www/instances-local/instance-1031/vendor/shardj/zf1-future/library/Zend/Application/Bootstrap/Bootstrap.php(106): Zend_Controller_Front->dispatch()
#11 /var/www/instances-local/instance-1031/vendor/shardj/zf1-future/library/Zend/Application.php(400): Zend_Application_Bootstrap_Bootstrap->run()
#12 /var/www/instances-local/instance-1031/library/ZfExtended/Application.php(74): Zend_Application->run()
#13 /var/www/instances-local/instance-1031/library/ZfExtended/BaseIndex.php(174): ZfExtended_Application->run()
#14 /var/www/instances-local/instance-1031/public/index.php(35): ZfExtended_BaseIndex->startApplication()
#15Unknown macro: {main}Request:
Array
(
[format] => jsontext
[autoStartImport] => 0
[CsrfToken] => xxx
)
I traced the above error. Looks like user deleted the "meta-sheet" this sheet is important, cause it contains Task-Guid etc.
I also tested to.. export the task as excel and reimport it again. Works fine. I made that with the task in the customer installation from above.
So user "destroyed" the excel, and my suggestion is, he deleted the "meta-sheet". Should be able to repair it by simply export it again as excel and transfer the meta-sheet from this export to the edited Excel.