Excel objects will be disappear...

Topics: Developer Forum, Project Management Forum, User Forum
May 13, 2013 at 6:50 PM
Hello,

I have a problem with phpexcel.
I wrote a code (teszt_phpExcel) which open excel file. After create a new worksheet and finally save as a new excel file. The problem is that excel file will be disappear a few things. For example lines with arrows, picrutes...
I use the latest phpExcel version.

Why is this happening? Can anybody help me?

Thanks for your help!
May 14, 2013 at 3:06 PM
A bit of divination... If forms are anchored on two cells but these are not images, it seems as a chart .. So call setIncludeCharts(true) on the reader and the writer could solve the problem.
May 14, 2013 at 4:29 PM
It does not resolve the problem...
$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objReader->setIncludeCharts(true);
$objPHPExcel = $objReader->load($inputFileName);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, $inputFileType);
$objWriter->setIncludeCharts(true);
May 15, 2013 at 7:44 AM
Hum... You will find in the reader comment: "TODO: Autoshapes from twoCellAnchors!" so I guess you fall in this case.
May 15, 2013 at 2:25 PM
So there is no solution? It is a bug?
Coordinator
May 15, 2013 at 2:38 PM
Features that aren't supported by PHPExcel are discarded when a file is loaded, because PHPExcel doesn't know how they should be handled. This included form elements, autoshapes, pivot tables.