Skip to content
This repository was archived by the owner on Jan 2, 2019. It is now read-only.
This repository was archived by the owner on Jan 2, 2019. It is now read-only.

Malformed chart output (Excel2007) #123

Open
@msbit

Description

@msbit

When opening an Excel spreadsheet with a chart, as per the following:

require_once('Classes/PHPExcel.php');

$objReader = PHPExcel_IOFactory::createReader('Excel2007');
$objReader->setIncludeCharts(TRUE);
$objPHPExcel = $objReader->load('Chart failure test.xlsx');

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->setIncludeCharts(TRUE);
$objWriter->save('Chart failure output.xlsx');

the charts are malformed on output.

Opening and attempting repair with Excel gives the following message:

"Removed Part: /xl/drawings/drawing1.xml part. (Drawing shape)"

Attached is the input file and output file for the above code (renamed to JPG so they can be added):

Input:
Chart failure test xlsx

Output:
Chart failure output xlsx

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions