Phpexcel - loosing attached graph

Topics: User Forum
Jan 28, 2016 at 11:25 AM
I load a template containing a list of values in the first sheet and a simple line graph in second sheet.
I feed some values into the first sheet.
I save the workbook.
When I open the workbook in Excel, I have lost the graph.
The values written by php in the first sheet are OK.

What did I miss ?
I am quite a newbie (just made some basic exports 2 years ago).
php 5.3.3 on linux/apache and PhpExcel 1.7.4
Jan 28, 2016 at 12:25 PM
Are you telling the Reader to include graphs when you load the template?
Are you telling the Writer to include graphs when you save the file?
Jan 28, 2016 at 1:35 PM
Edited Jan 28, 2016 at 1:44 PM
thanks for you quick answer
Yes of course I used the magic functions....
But in version 1.7.4, $objWriter->setIncludeCharts(true); makes php to fail (white page).
As I was using a quite old version of the library, I just upgraded to 1.8.
Now it works ... but the graph is altered. It has lost its title (which is a dynamic title refering to the first sheet).
The look and feel was also altered (see attached picture)
Note that Excel tells that the generated file is not correct and it has to recover it....(you know what I mean).
I thought this bug was fixed in the last versions of PHP Excel....Image


I also loose the background color of the graph if ever I defined one...