コード例 #1
0
ファイル: BarGraph.cs プロジェクト: garsiden/Report-Generator
        protected ChartShapeProperties GenerateChartShapeProperties(string colourHex, int width)
        {
            ChartShapeProperties chartShapeProperties2 = new ChartShapeProperties();

            A::SolidFill solidFill1 = new A::SolidFill();
            A::RgbColorModelHex rgbColorModelHex1 = new A::RgbColorModelHex() { Val = colourHex };
            solidFill1.Append(rgbColorModelHex1);

            A::Outline outline2 = new A::Outline() { Width = width };
            A::SolidFill solidFill2 = new A::SolidFill();
            A::RgbColorModelHex rgbColorModelHex2 = new A::RgbColorModelHex() { Val = "000000" };

            solidFill2.Append(rgbColorModelHex2);
            A::PresetDash presetDash1 = new A::PresetDash() { Val = A::PresetLineDashValues.Solid };

            outline2.Append(solidFill2);
            outline2.Append(presetDash1);

            chartShapeProperties2.Append(solidFill1);
            chartShapeProperties2.Append(outline2);

            return chartShapeProperties2;
        }
コード例 #2
0
        protected override Legend GenerateLegend(LegendPositionValues position)
        {
            Legend legend1 = new Legend();
            LegendPosition legendPosition1 = new LegendPosition() { Val = position };

            Layout layout3 = GenerateLegendLayout();

            ChartShapeProperties chartShapeProperties8 = new ChartShapeProperties();

            A::SolidFill solidFill10 = new A::SolidFill();
            A::RgbColorModelHex rgbColorModelHex10 = new A::RgbColorModelHex() { Val = "FFFFFF" };

            solidFill10.Append(rgbColorModelHex10);

            A::Outline outline9 = new A::Outline() { Width = 3175 };

            A::SolidFill solidFill11 = new A::SolidFill();
            A::RgbColorModelHex rgbColorModelHex11 = new A::RgbColorModelHex() { Val = "000000" };

            solidFill11.Append(rgbColorModelHex11);
            A::PresetDash presetDash7 = new A::PresetDash() { Val = A::PresetLineDashValues.Solid };

            outline9.Append(solidFill11);
            outline9.Append(presetDash7);

            chartShapeProperties8.Append(solidFill10);
            chartShapeProperties8.Append(outline9);

            legend1.Append(legendPosition1);
            legend1.Append(layout3);
            legend1.Append(chartShapeProperties8);

            return legend1;
        }
コード例 #3
0
ファイル: Graph.cs プロジェクト: garsiden/Report-Generator
        protected ChartShapeProperties GenerateChartShapeProperties(string colourHex)
        {
            ChartShapeProperties chartShapeProperties1 = new ChartShapeProperties();

            A::Outline outline1 = new A::Outline();
            A::SolidFill solidFill1 = new A::SolidFill();
            A::RgbColorModelHex rgbColorModelHex1 = new A::RgbColorModelHex() { Val = colourHex };
            solidFill1.Append(rgbColorModelHex1);
            outline1.Append(solidFill1);
            chartShapeProperties1.Append(outline1);

            return chartShapeProperties1;
        }
コード例 #4
0
ファイル: Graph.cs プロジェクト: garsiden/Report-Generator
        protected ChartShapeProperties GenerateChartShapeProperties(int width)
        {
            ChartShapeProperties chartShapeProperties5 = new ChartShapeProperties();

            A::Outline outline5 = new A::Outline() { Width = width };

            A::SolidFill solidFill7 = new A::SolidFill();
            A::RgbColorModelHex rgbColorModelHex7 = new A::RgbColorModelHex() { Val = "000000" };

            solidFill7.Append(rgbColorModelHex7);
            A::PresetDash presetDash4 = new A::PresetDash() { Val = A::PresetLineDashValues.Solid };

            outline5.Append(solidFill7);
            outline5.Append(presetDash4);

            chartShapeProperties5.Append(outline5);

            return chartShapeProperties5;
        }
コード例 #5
0
ファイル: BarGraph.cs プロジェクト: garsiden/Report-Generator
        protected ValueAxis GenerateValueAxis(AxisId axisId, AxisPositionValues position, string formatCode, AxisId crossingAxisId)
        {
            ValueAxis valueAxis1 = new ValueAxis();
            AxisId axisId4 = new AxisId() { Val = (UInt32Value)axisId.Val };

            Scaling scaling2 = new Scaling();
            Orientation orientation2 = new Orientation() { Val = OrientationValues.MinMax };

            scaling2.Append(orientation2);
            AxisPosition axisPosition2 = new AxisPosition() { Val = position };

            MajorGridlines majorGridlines1 = new MajorGridlines();

            ChartShapeProperties chartShapeProperties4 = GenerateChartShapeProperties(3175);

            majorGridlines1.Append(chartShapeProperties4);
            NumberingFormat numberingFormat2 = new NumberingFormat() { FormatCode = formatCode, SourceLinked = false };
            TickLabelPosition tickLabelPosition2 = new TickLabelPosition() { Val = TickLabelPositionValues.NextTo };

            ChartShapeProperties chartShapeProperties5 = GenerateChartShapeProperties(3175);

            TextProperties textProperties2 = new TextProperties();
            A::BodyProperties bodyProperties3 = new A::BodyProperties() { Rotation = 0, Vertical = A::TextVerticalValues.Horizontal };
            A::ListStyle listStyle3 = new A::ListStyle();

            A::Paragraph paragraph3 = new A::Paragraph();

            A::ParagraphProperties paragraphProperties3 = new A::ParagraphProperties();

            A::DefaultRunProperties defaultRunProperties3 = new A::DefaultRunProperties() { Language = DEFAULT_LANG };

            A::SolidFill solidFill8 = new A::SolidFill();
            A::RgbColorModelHex rgbColorModelHex8 = new A::RgbColorModelHex() { Val = "000000" };

            solidFill8.Append(rgbColorModelHex8);

            paragraphProperties3.Append(defaultRunProperties3);
            A::EndParagraphRunProperties endParagraphRunProperties2 = new A::EndParagraphRunProperties() { Language = DEFAULT_LANG };

            paragraph3.Append(paragraphProperties3);
            paragraph3.Append(endParagraphRunProperties2);

            textProperties2.Append(bodyProperties3);
            textProperties2.Append(listStyle3);
            textProperties2.Append(paragraph3);
            CrossingAxis crossingAxis2 = new CrossingAxis() { Val = (UInt32Value)crossingAxisId.Val };
            Crosses crosses2 = new Crosses() { Val = CrossesValues.AutoZero };
            CrossBetween crossBetween1 = new CrossBetween() { Val = CrossBetweenValues.Between };

            valueAxis1.Append(axisId4);
            valueAxis1.Append(scaling2);
            valueAxis1.Append(axisPosition2);
            valueAxis1.Append(majorGridlines1);
            valueAxis1.Append(numberingFormat2);
            valueAxis1.Append(tickLabelPosition2);
            valueAxis1.Append(chartShapeProperties5);
            valueAxis1.Append(textProperties2);
            valueAxis1.Append(crossingAxis2);
            valueAxis1.Append(crosses2);
            valueAxis1.Append(crossBetween1);

            return valueAxis1;
        }
コード例 #6
0
        protected CategoryAxis GenerateCategoryAxis(AxisId axisId, AxisPositionValues axisPosition, string formatCode, AxisId crossingAxisId)
        {
            CategoryAxis categoryAxis1 = new CategoryAxis();
            AxisId axisId1 = new AxisId() { Val = axisId.Val };

            Scaling scaling1 = new Scaling();
            Orientation orientation1 = new Orientation() { Val = OrientationValues.MinMax };

            scaling1.Append(orientation1);
            AxisPosition axisPosition1 = new AxisPosition() { Val = AxisPositionValues.Bottom };
            NumberingFormat numberingFormat1 = new NumberingFormat() { FormatCode = formatCode, SourceLinked = true };
            TickLabelPosition tickLabelPosition1 = new TickLabelPosition() { Val = TickLabelPositionValues.Low };

            ChartShapeProperties chartShapeProperties1 = GenerateChartShapeProperties(3175);

            TextProperties textProperties1 = new TextProperties();
            A::BodyProperties bodyProperties1 = new A::BodyProperties() { Rotation = -1800000, Vertical = A::TextVerticalValues.Horizontal };
            A::ListStyle listStyle1 = new A::ListStyle();

            A::Paragraph paragraph1 = new A::Paragraph();

            A::ParagraphProperties paragraphProperties1 = new A::ParagraphProperties();

            A::DefaultRunProperties defaultRunProperties1 = new A::DefaultRunProperties() { Language = DEFAULT_LANG, FontSize = 1000, Bold = false, Italic = false, Underline = A::TextUnderlineValues.None, Strike = A::TextStrikeValues.NoStrike, Baseline = 0 };

            A::SolidFill solidFill2 = new A::SolidFill();
            A::RgbColorModelHex rgbColorModelHex2 = new A::RgbColorModelHex() { Val = "000000" };

            solidFill2.Append(rgbColorModelHex2);

            defaultRunProperties1.Append(solidFill2);

            paragraphProperties1.Append(defaultRunProperties1);
            A::EndParagraphRunProperties endParagraphRunProperties1 = new A::EndParagraphRunProperties() { Language = DEFAULT_LANG };

            paragraph1.Append(paragraphProperties1);
            paragraph1.Append(endParagraphRunProperties1);

            textProperties1.Append(bodyProperties1);
            textProperties1.Append(listStyle1);
            textProperties1.Append(paragraph1);
            CrossingAxis crossingAxis1 = new CrossingAxis() { Val = (UInt32Value)crossingAxisId.Val };
            Crosses crosses1 = new Crosses() { Val = CrossesValues.AutoZero };
            AutoLabeled autoLabeled1 = new AutoLabeled() { Val = true };
            LabelAlignment labelAlignment1 = new LabelAlignment() { Val = LabelAlignmentValues.Center };
            LabelOffset labelOffset1 = new LabelOffset() { Val = (UInt16Value)100U };
            TickLabelSkip tickLabelSkip1 = new TickLabelSkip() { Val = 1 };
            TickMarkSkip tickMarkSkip1 = new TickMarkSkip() { Val = 1 };

            categoryAxis1.Append(axisId1);
            categoryAxis1.Append(scaling1);
            categoryAxis1.Append(axisPosition1);
            categoryAxis1.Append(numberingFormat1);
            categoryAxis1.Append(tickLabelPosition1);
            categoryAxis1.Append(chartShapeProperties1);
            categoryAxis1.Append(textProperties1);
            categoryAxis1.Append(crossingAxis1);
            categoryAxis1.Append(crosses1);
            categoryAxis1.Append(autoLabeled1);
            categoryAxis1.Append(labelAlignment1);
            categoryAxis1.Append(labelOffset1);
            categoryAxis1.Append(tickLabelSkip1);
            categoryAxis1.Append(tickMarkSkip1);

            return categoryAxis1;
        }