def test_odf_create_chart_plot_area_style(self): s=odf_create_chart_plot_area_style("plot") expected=('<style:style style:family="chart" style:name="plot">' '<style:chart-properties ' 'chart:include-hidden-cells="false" ' 'chart:auto-size="true" chart:auto-position="true" ' 'chart:treat-empty-cells="leave-gap" ' 'chart:right-angled-axes="true"/>' '</style:style>') self.assertEqual(s.serialize(), expected)
#we need an access to the office:automatic-styles element from lpod.xmlpart import odf_xmlpart chart_content = odf_xmlpart(chart_directory+'/content.xml', doc) styles = chart_content.get_element("office:automatic-styles") #we add informations about style from chart_style import odf_create_chart_title_style from chart_style import odf_create_chart_legend_style from chart_style import odf_create_chart_plot_area_style from chart_style import odf_create_chart_axis_style from chart_style import odf_create_chart_axis_title_style from chart_style import odf_create_chart_wall_style, odf_create_chart_style styles.append(odf_create_chart_title_style("titre", "12pt")) plot_s=odf_create_chart_plot_area_style("plot") styles.append(plot_s) styles.append(odf_create_chart_axis_style("axe x")) styles.append(odf_create_chart_axis_style("axe y")) styles.append(odf_create_chart_wall_style("wall")) #we choose a color for each series palette=['#0000ff', '#bf00ff', '#ff0080', '#ff4000', '#ffff00', '#40ff00', '#00ff7f', '#00bfff', '#6000ff', '#ff00df', '#ff0020', '#ff9f00', '#9fff00', '#00ff20', '#00ffdf', '#0060ff'] from chart import divide_range cols_list = divide_range("Data.A1:Data.E5") for i in range(len(cols_list)): s = odf_create_chart_style("series"+str(i)) s.set_fill("solid", palette[i])
#we need an access to the office:automatic-styles element from lpod.xmlpart import odf_xmlpart chart_content = odf_xmlpart(chart_directory + '/content.xml', doc) styles = chart_content.get_element("office:automatic-styles") #we add informations about style from chart_style import odf_create_chart_title_style from chart_style import odf_create_chart_legend_style from chart_style import odf_create_chart_plot_area_style from chart_style import odf_create_chart_axis_style from chart_style import odf_create_chart_axis_title_style from chart_style import odf_create_chart_wall_style, odf_create_chart_style styles.append(odf_create_chart_title_style("titre", "12pt")) plot_s = odf_create_chart_plot_area_style("plot") styles.append(plot_s) styles.append(odf_create_chart_axis_style("axe x")) styles.append(odf_create_chart_axis_style("axe y")) styles.append(odf_create_chart_wall_style("wall")) #we choose a color for each series palette = [ '#0000ff', '#bf00ff', '#ff0080', '#ff4000', '#ffff00', '#40ff00', '#00ff7f', '#00bfff', '#6000ff', '#ff00df', '#ff0020', '#ff9f00', '#9fff00', '#00ff20', '#00ffdf', '#0060ff' ] from chart import divide_range cols_list = divide_range("Data.A1:Data.E5") for i in range(len(cols_list)):