Multiple Charts in a same sheet : Problem with the position (bug ?).

Topics: Developer Forum
Nov 26, 2014 at 11:08 AM
Edited Nov 26, 2014 at 11:12 AM
Hi all !
I think I've found a problem when I put multiples chart in the same sheet...
If I modify the example : 33chartcreate-bar.php
By creating $chart1, $chart2, $chart3 : same graph than $chart
And setting different position...



If I open the file xlsx result :
$chart =>Positionned on A7 : OK
$chart1=>Positionned on A34 : Not OK, not A37 : Difference : 3 cells
$chart2=>Positionned approx. on A61 : : Not OK, not A67 : Difference : 6 cells
$chart3=>Positionned approx. on A89 : Not OK, not A97: Difference : about 9 cells

and so on !

If you can help me, thanks... I will create an incremental delta to walkaround this...
Nov 27, 2014 at 10:39 AM
Ok, I've found where the problem is...
PhpExcel work fine ! Excel work Fine too. The position of the graphs are correct.
But OpenOffice Calc has the problem... It put the graphs in incorrect positions.
Marked as answer by kinounet on 11/27/2014 at 2:39 AM