Using graphs results in corrupt work book
Created originally on Bitbucket by Anonymous
Running openpyxl-1.8.4 (parent: 1787:9af5e1ccc0d0 ) and python 2.7.4
Issues are experienced only when adding charts of any type to a work book. Excel 2007 complaints that it contains unreadable content but is still able to open the file. iOS devices are not able to open it at all. Although Mac office 2011 does not have any issues. DiffMerge (mac diff application) complains there is a null character and can not view the contents.
Have attached an example.
code example to generate the chart
#!python
from openpyxl.chart import BarChart, Reference, Series
values = Reference(ws, (1, 1), (9, 1))
series = Series(values, title="First series of values")
chart = BarChart()
chart.append(series)
ws.add_chart(chart)