示例#1
0
    def __call__(self, doc):
        chartstyle = style.Style(name="chartstyle", family="chart")
        chartstyle.addElement(
            style.GraphicProperties(stroke="none", fillcolor="#ffffff"))
        doc.automaticstyles.addElement(chartstyle)

        mychart = chart.Chart(width=self.width,
                              height=self.height,
                              stylename=chartstyle,
                              attributes={'class': self.charttype})
        doc.chart.addElement(mychart)

        # Title
        if self.title:
            titlestyle = style.Style(name="titlestyle", family="chart")
            titlestyle.addElement(
                style.GraphicProperties(stroke="none", fill="none"))
            titlestyle.addElement(
                style.TextProperties(fontfamily="'Nimbus Sans L'",
                                     fontfamilygeneric="swiss",
                                     fontpitch="variable",
                                     fontsize="13pt"))
            doc.automaticstyles.addElement(titlestyle)
            mytitle = chart.Title(x="185pt", y="27pt", stylename=titlestyle)
            mytitle.addElement(text.P(text=self.title))
            mychart.addElement(mytitle)

        # Subtitle
        if self.subtitle:
            subtitlestyle = style.Style(name="subtitlestyle", family="chart")
            subtitlestyle.addElement(
                style.GraphicProperties(stroke="none", fill="none"))
            subtitlestyle.addElement(
                style.TextProperties(fontfamily="'Nimbus Sans L'",
                                     fontfamilygeneric="swiss",
                                     fontpitch="variable",
                                     fontsize="10pt"))
            doc.automaticstyles.addElement(subtitlestyle)
            subtitle = chart.Subtitle(x="50pt",
                                      y="50pt",
                                      stylename=subtitlestyle)
            subtitle.addElement(text.P(text=self.subtitle))
            mychart.addElement(subtitle)

        # Legend
        legendstyle = style.Style(name="legendstyle", family="chart")
        legendstyle.addElement(style.GraphicProperties(fill="none"))
        legendstyle.addElement(
            style.TextProperties(fontfamily="'Nimbus Sans L'",
                                 fontfamilygeneric="swiss",
                                 fontpitch="variable",
                                 fontsize="8pt"))
        doc.automaticstyles.addElement(legendstyle)

        mylegend = chart.Legend(legendposition="end",
                                legendalign="center",
                                stylename=legendstyle)
        mychart.addElement(mylegend)

        # Plot area
        plotstyle = style.Style(name="plotstyle", family="chart")
        if self.subtype == "stacked":
            percentage = "false"
            stacked = "true"
        elif self.subtype == "percentage":
            percentage = "true"
            stacked = "false"
        else:
            percentage = "false"
            stacked = "false"

        plotstyle.addElement(
            style.ChartProperties(seriessource="columns",
                                  percentage=percentage,
                                  stacked=stacked,
                                  threedimensional=self.threedimensional))
        doc.automaticstyles.addElement(plotstyle)

        plotarea = chart.PlotArea(datasourcehaslabels=self.datasourcehaslabels,
                                  stylename=plotstyle)
        mychart.addElement(plotarea)

        # Style for the X,Y axes
        axisstyle = style.Style(name="axisstyle", family="chart")
        axisstyle.addElement(style.ChartProperties(displaylabel="true"))
        axisstyle.addElement(
            style.TextProperties(fontfamily="'Nimbus Sans L'",
                                 fontfamilygeneric="swiss",
                                 fontpitch="variable",
                                 fontsize="8pt"))
        doc.automaticstyles.addElement(axisstyle)

        # Title for the X axis
        xaxis = chart.Axis(dimension="x",
                           name="primary-x",
                           stylename=axisstyle)
        plotarea.addElement(xaxis)
        xt = chart.Title()
        xaxis.addElement(xt)
        xt.addElement(text.P(text=self.x_axis))

        # Title for the Y axis
        yaxis = chart.Axis(dimension="y",
                           name="primary-y",
                           stylename=axisstyle)
        plotarea.addElement(yaxis)
        yt = chart.Title()
        yaxis.addElement(yt)
        yt.addElement(text.P(text=self.y_axis))

        # chart colors
        piestyle = style.Style(name="series", family="chart")
        piestyle.addElement(style.GraphicProperties(fillcolor="#000000"))
        doc.automaticstyles.addElement(piestyle)

        piestyle = style.Style(name="piestyle.critical", family="chart")
        piestyle.addElement(style.ChartProperties(solidtype="cuboid"))
        piestyle.addElement(style.GraphicProperties(fillcolor=riskCritical))
        doc.automaticstyles.addElement(piestyle)

        piestyle = style.Style(name="piestyle.high", family="chart")
        piestyle.addElement(style.ChartProperties(solidtype="cuboid"))
        piestyle.addElement(style.GraphicProperties(fillcolor=riskHigh))
        doc.automaticstyles.addElement(piestyle)

        piestyle = style.Style(name="piestyle.medium", family="chart")
        piestyle.addElement(style.ChartProperties(solidtype="cuboid"))
        piestyle.addElement(style.GraphicProperties(fillcolor=riskMedium))
        doc.automaticstyles.addElement(piestyle)

        piestyle = style.Style(name="piestyle.low", family="chart")
        piestyle.addElement(style.ChartProperties(solidtype="cuboid"))
        piestyle.addElement(style.GraphicProperties(fillcolor=riskLow))
        doc.automaticstyles.addElement(piestyle)

        piestyle = style.Style(name="piestyle.none", family="chart")
        piestyle.addElement(style.ChartProperties(solidtype="cuboid"))
        piestyle.addElement(style.GraphicProperties(fillcolor=riskNone))
        doc.automaticstyles.addElement(piestyle)

        # Set up the data series. OOo doesn't show correctly without them.
        s = chart.Series(valuescellrangeaddress="local-table.$B$2:.$B$6",
                         labelcelladdress="local-table.$B$1",
                         attributes={'class': self.charttype},
                         stylename="series")
        s.addElement(chart.DataPoint(stylename="piestyle.critical"))
        s.addElement(chart.DataPoint(stylename="piestyle.high"))
        s.addElement(chart.DataPoint(stylename="piestyle.medium"))
        s.addElement(chart.DataPoint(stylename="piestyle.low"))
        s.addElement(chart.DataPoint(stylename="piestyle.none"))
        plotarea.addElement(s)

        # The data are placed in a table inside the chart object - but could also be a
        # table in the main document
        datatable = DataTable(self.values)
        datatable.datasourcehaslabels = self.datasourcehaslabels
        mychart.addElement(datatable())
示例#2
0
    def __call__(self, doc):
        chartstyle  = style.Style(name="chartstyle", family="chart")
        chartstyle.addElement( style.GraphicProperties(stroke="none", fillcolor="#ffffff"))
        doc.automaticstyles.addElement(chartstyle)

        mychart = chart.Chart( width="576pt", height="504pt", stylename=chartstyle, attributes={'class':self.charttype})
        doc.chart.addElement(mychart)

        # Title
        if self.title:
            titlestyle = style.Style(name="titlestyle", family="chart")
            titlestyle.addElement( style.GraphicProperties(stroke="none", fill="none"))
            titlestyle.addElement( style.TextProperties(fontfamily="'Nimbus Sans L'",
                    fontfamilygeneric="swiss", fontpitch="variable", fontsize="13pt"))
            doc.automaticstyles.addElement(titlestyle)

            mytitle = chart.Title(x="385pt", y="27pt", stylename=titlestyle)
            mytitle.addElement( text.P(text=self.title))
            mychart.addElement(mytitle)

        # Subtitle
        if self.subtitle:
            subtitlestyle = style.Style(name="subtitlestyle", family="chart")
            subtitlestyle.addElement( style.GraphicProperties(stroke="none", fill="none"))
            subtitlestyle.addElement( style.TextProperties(fontfamily="'Nimbus Sans L'",
                    fontfamilygeneric="swiss", fontpitch="variable", fontsize="10pt"))
            doc.automaticstyles.addElement(subtitlestyle)

            subtitle = chart.Subtitle(x="0pt", y="123pt", stylename=subtitlestyle)
            subtitle.addElement( text.P(text= self.subtitle))
            mychart.addElement(subtitle)

        # Legend
        legendstyle = style.Style(name="legendstyle", family="chart")
        legendstyle.addElement( style.GraphicProperties(fill="none"))
        legendstyle.addElement( style.TextProperties(fontfamily="'Nimbus Sans L'",
                fontfamilygeneric="swiss", fontpitch="variable", fontsize="6pt"))
        doc.automaticstyles.addElement(legendstyle)

        mylegend = chart.Legend(legendposition="end", legendalign="center", stylename=legendstyle)
        mychart.addElement(mylegend)

        # Plot area
        plotstyle = style.Style(name="plotstyle", family="chart")
        if self.subtype == "stacked": percentage="false"; stacked="true"
        elif self.subtype == "percentage": percentage="true"; stacked="false"
        else: percentage="false"; stacked="false"
        plotstyle.addElement( style.ChartProperties(seriessource="columns",
                percentage=percentage, stacked=stacked,
                threedimensional=self.threedimensional))
        doc.automaticstyles.addElement(plotstyle)

        plotarea = chart.PlotArea(datasourcehaslabels=self.datasourcehaslabels, stylename=plotstyle)
        mychart.addElement(plotarea)

        # Style for the X,Y axes
        axisstyle = style.Style(name="axisstyle", family="chart")
        axisstyle.addElement( style.ChartProperties(displaylabel="true"))
        doc.automaticstyles.addElement(axisstyle)

        # Title for the X axis
        xaxis = chart.Axis(dimension="x", name="primary-x", stylename=axisstyle)
        plotarea.addElement(xaxis)
        xt = chart.Title()
        xaxis.addElement(xt)
        xt.addElement(text.P(text=self.x_axis))

        # Title for the Y axis
        yaxis = chart.Axis(dimension="y", name="primary-y", stylename=axisstyle)
        plotarea.addElement(yaxis)
        yt = chart.Title()
        yaxis.addElement(yt)
        yt.addElement(text.P(text=self.y_axis))

        # Data area
        datatable = DataTable( self.values )
        datatable.datasourcehaslabels = self.datasourcehaslabels
        mychart.addElement(datatable())
	def __call__(self, doc):
		chartstyle  = style.Style(name="chartstyle", family="chart")
		chartstyle.addElement( style.GraphicProperties(stroke="none", fillcolor="#ffffff"))
		doc.automaticstyles.addElement(chartstyle)

		mychart = chart.Chart(width=self.width, height=self.height,stylename=chartstyle, attributes={'class':self.charttype})
		doc.chart.addElement(mychart)

		# Title
		if self.title:
			titlestyle = style.Style(name="titlestyle", family="chart")
			titlestyle.addElement( style.GraphicProperties(stroke="none", fill="none"))
			titlestyle.addElement( style.TextProperties(fontfamily="'Nimbus Sans L'",fontfamilygeneric="swiss", fontpitch="variable", fontsize="13pt"))
			doc.automaticstyles.addElement(titlestyle)
			mytitle = chart.Title(x="185pt", y="27pt", stylename=titlestyle)
			mytitle.addElement( text.P(text=self.title))
			mychart.addElement(mytitle)

		# Subtitle
		if self.subtitle:
			subtitlestyle = style.Style(name="subtitlestyle", family="chart")
			subtitlestyle.addElement( style.GraphicProperties(stroke="none", fill="none"))
			subtitlestyle.addElement( style.TextProperties(fontfamily="'Nimbus Sans L'",fontfamilygeneric="swiss", fontpitch="variable", fontsize="10pt"))
			doc.automaticstyles.addElement(subtitlestyle)
			subtitle = chart.Subtitle(x="50pt", y="50pt", stylename=subtitlestyle)
			subtitle.addElement( text.P(text= self.subtitle))	
			mychart.addElement(subtitle)

		# Legend
		legendstyle = style.Style(name="legendstyle", family="chart")
		legendstyle.addElement( style.GraphicProperties(fill="none"))
		legendstyle.addElement( style.TextProperties(fontfamily="'Nimbus Sans L'",fontfamilygeneric="swiss", fontpitch="variable", fontsize="8pt"))
		doc.automaticstyles.addElement(legendstyle)

		mylegend = chart.Legend(legendposition="end", legendalign="center", stylename=legendstyle)
		mychart.addElement(mylegend)

		# Plot area
		plotstyle = style.Style(name="plotstyle", family="chart")
		if self.subtype == "stacked": 
			percentage="false"; stacked="true"
		elif self.subtype == "percentage": 
			percentage="true"; stacked="false"
		else: 
			percentage="false"; stacked="false"
	
		plotstyle.addElement( style.ChartProperties(seriessource="columns",percentage=percentage, stacked=stacked,threedimensional=self.threedimensional))
		doc.automaticstyles.addElement(plotstyle)
 
		plotarea = chart.PlotArea(datasourcehaslabels=self.datasourcehaslabels, stylename=plotstyle)
		mychart.addElement(plotarea)

		# Style for the X,Y axes
		axisstyle = style.Style(name="axisstyle", family="chart")
		axisstyle.addElement( style.ChartProperties(displaylabel="true"))
		axisstyle.addElement( style.TextProperties(fontfamily="'Nimbus Sans L'",
		fontfamilygeneric="swiss", fontpitch="variable", fontsize="8pt"))
		doc.automaticstyles.addElement(axisstyle)

		# Title for the X axis
		xaxis = chart.Axis(dimension="x", name="primary-x", stylename=axisstyle)
		plotarea.addElement(xaxis)
		xt = chart.Title()
		xaxis.addElement(xt)
		xt.addElement(text.P(text=self.x_axis))

		# Title for the Y axis
		yaxis = chart.Axis(dimension="y", name="primary-y", stylename=axisstyle)
		plotarea.addElement(yaxis)
		yt = chart.Title()
		yaxis.addElement(yt)
		yt.addElement(text.P(text=self.y_axis))

		# chart colors
		piestyle = style.Style(name="series", family="chart")
		piestyle.addElement( style.GraphicProperties(fillcolor="#000000"))
		doc.automaticstyles.addElement(piestyle)

		piestyle = style.Style(name="piestyle.critical", family="chart")
		piestyle.addElement( style.ChartProperties(solidtype="cuboid"))
		piestyle.addElement( style.GraphicProperties(fillcolor=riskCritical))
		doc.automaticstyles.addElement(piestyle)

		piestyle = style.Style(name="piestyle.high", family="chart")
		piestyle.addElement( style.ChartProperties(solidtype="cuboid"))
		piestyle.addElement( style.GraphicProperties(fillcolor=riskHigh))
		doc.automaticstyles.addElement(piestyle)

		piestyle = style.Style(name="piestyle.medium", family="chart")
		piestyle.addElement( style.ChartProperties(solidtype="cuboid"))
		piestyle.addElement( style.GraphicProperties(fillcolor=riskMedium))
		doc.automaticstyles.addElement(piestyle)

		piestyle = style.Style(name="piestyle.low", family="chart")
		piestyle.addElement( style.ChartProperties(solidtype="cuboid"))
		piestyle.addElement( style.GraphicProperties(fillcolor=riskLow))
		doc.automaticstyles.addElement(piestyle)

		piestyle = style.Style(name="piestyle.none", family="chart")
		piestyle.addElement( style.ChartProperties(solidtype="cuboid"))
		piestyle.addElement( style.GraphicProperties(fillcolor=riskNone))
		doc.automaticstyles.addElement(piestyle)

		# Set up the data series. OOo doesn't show correctly without them.
		s = chart.Series(valuescellrangeaddress="local-table.$B$2:.$B$6", labelcelladdress="local-table.$B$1",attributes={'class':self.charttype}, stylename="series")
		s.addElement(chart.DataPoint(stylename="piestyle.critical"))
		s.addElement(chart.DataPoint(stylename="piestyle.high"))
		s.addElement(chart.DataPoint(stylename="piestyle.medium"))
		s.addElement(chart.DataPoint(stylename="piestyle.low"))
		s.addElement(chart.DataPoint(stylename="piestyle.none"))
		plotarea.addElement(s)

		# The data are placed in a table inside the chart object - but could also be a
		# table in the main document
		datatable = DataTable(self.values)
		datatable.datasourcehaslabels = self.datasourcehaslabels
		mychart.addElement(datatable())