Excel objects will be disappear...

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

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 2: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 3:29 PM
It does not resolve the problem...
$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objPHPExcel = $objReader->load($inputFileName);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, $inputFileType);
May 15, 2013 at 6: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 1:25 PM
So there is no solution? It is a bug?
May 15, 2013 at 1: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.