def test_write_no_ascii(self, ten_row_sheet, Series, BarChart, Reference, root_xml):
ws = ten_row_sheet
ws.append([b"D\xc3\xbcsseldorf"]*10)
serie = Series(values=Reference(ws, (1,1), (1,10)),
title=(ws.cell(row=1, column=1).value)
)
c = BarChart()
c.add_serie(serie)
cw = BaseChartWriter(c)
cw._write_series(root_xml)
xml = tostring(root_xml)
expected = """
<test>
<c:ser xmlns:c="http://schemas.openxmlformats.org/drawingml/2006/chart">
<c:idx val="0"/>
<c:order val="0"/>
<c:val>
<c:numRef>
<c:f>'data'!$A$1:$J$1</c:f>
</c:numRef>
</c:val>
</c:ser>
</test>
"""
diff = compare_xml(xml, expected)
assert diff is None, diff
def test_write_serial(ten_row_sheet, LineChart, Series, Reference, root_xml):
ws = ten_row_sheet
chart = LineChart()
for idx, l in enumerate("ABCDEF", 1):
ws.cell(row=idx, column=1).value = l
ref = Reference(ws, (1, 1), (10, 1))
series = Series(ref)
chart.add_serie(series)
cw = BaseChartWriter(chart)
cw._write_serial(cw.root, ref)
xml = tostring(cw.root)
expected = """
<c:chartSpace xmlns:c="http://schemas.openxmlformats.org/drawingml/2006/chart">
<c:strRef>
<c:f>'data'!$A$1:$A$10</c:f>
</c:strRef>
</c:chartSpace>
"""
diff = compare_xml(xml, expected)
assert diff is None, diff
