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:strCache><c:ptCount val="10"/><c:pt idx="0"><c:v>A</c:v></c:pt><c:pt idx="1"><c:v>B</c:v></c:pt><c:pt idx="2"><c:v>C</c:v></c:pt><c:pt idx="3"><c:v>D</c:v></c:pt><c:pt idx="4"><c:v>E</c:v></c:pt><c:pt idx="5"><c:v>F</c:v></c:pt><c:pt idx="6"><c:v>6</c:v></c:pt><c:pt idx="7"><c:v>7</c:v></c:pt><c:pt idx="8"><c:v>8</c:v></c:pt><c:pt idx="9"><c:v>9</c:v></c:pt></c:strCache></c:strRef></c:chartSpace>"""
    diff = compare_xml(xml, expected)
    assert diff is None, diff
 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:numCache><c:formatCode>General</c:formatCode><c:ptCount val="10"/><c:pt idx="0"><c:v>0</c:v></c:pt><c:pt idx="1"><c:v></c:v></c:pt><c:pt idx="2"><c:v></c:v></c:pt><c:pt idx="3"><c:v></c:v></c:pt><c:pt idx="4"><c:v></c:v></c:pt><c:pt idx="5"><c:v></c:v></c:pt><c:pt idx="6"><c:v></c:v></c:pt><c:pt idx="7"><c:v></c:v></c:pt><c:pt idx="8"><c:v></c:v></c:pt><c:pt idx="9"><c:v></c:v></c:pt></c:numCache></c:numRef></c:val></c:ser></test>"""
     diff = compare_xml(xml, expected)
     assert diff is None, diff