internal C.SeriesAxis ToSeriesAxis() { C.SeriesAxis sa = new C.SeriesAxis(); sa.AxisId = new C.AxisId() { Val = this.AxisId }; sa.Scaling = new C.Scaling(); sa.Scaling.Orientation = new C.Orientation() { Val = this.Orientation }; if (this.LogBase != null) sa.Scaling.LogBase = new C.LogBase() { Val = this.LogBase.Value }; if (this.MaxAxisValue != null) sa.Scaling.MaxAxisValue = new C.MaxAxisValue() { Val = this.MaxAxisValue.Value }; if (this.MinAxisValue != null) sa.Scaling.MinAxisValue = new C.MinAxisValue() { Val = this.MinAxisValue.Value }; sa.Delete = new C.Delete() { Val = this.Delete }; sa.AxisPosition = new C.AxisPosition() { Val = this.AxisPosition }; if (this.ShowMajorGridlines) { sa.MajorGridlines = this.MajorGridlines.ToMajorGridlines(); } if (this.ShowMinorGridlines) { sa.MinorGridlines = this.MinorGridlines.ToMinorGridlines(); } if (this.ShowTitle) { sa.Title = this.Title.ToTitle(); } if (this.HasNumberingFormat) { sa.NumberingFormat = new C.NumberingFormat() { FormatCode = this.FormatCode, SourceLinked = this.SourceLinked }; } sa.MajorTickMark = new C.MajorTickMark() { Val = this.MajorTickMark }; sa.MinorTickMark = new C.MinorTickMark() { Val = this.MinorTickMark }; sa.TickLabelPosition = new C.TickLabelPosition() { Val = this.TickLabelPosition }; if (this.ShapeProperties.HasShapeProperties) sa.ChartShapeProperties = this.ShapeProperties.ToChartShapeProperties(); if (this.Rotation != null || this.Vertical != null || this.Anchor != null || this.AnchorCenter != null) { sa.TextProperties = new C.TextProperties(); sa.TextProperties.BodyProperties = new A.BodyProperties(); if (this.Rotation != null) sa.TextProperties.BodyProperties.Rotation = (int)(this.Rotation.Value * SLConstants.DegreeToAngleRepresentation); if (this.Vertical != null) sa.TextProperties.BodyProperties.Vertical = this.Vertical.Value; if (this.Anchor != null) sa.TextProperties.BodyProperties.Anchor = this.Anchor.Value; if (this.AnchorCenter != null) sa.TextProperties.BodyProperties.AnchorCenter = this.AnchorCenter.Value; sa.TextProperties.ListStyle = new A.ListStyle(); A.Paragraph para = new A.Paragraph(); para.ParagraphProperties = new A.ParagraphProperties(); para.ParagraphProperties.Append(new A.DefaultRunProperties()); sa.TextProperties.Append(para); } sa.CrossingAxis = new C.CrossingAxis() { Val = this.CrossingAxis }; if (this.IsCrosses != null) { if (this.IsCrosses.Value) { sa.Append(new C.Crosses() { Val = this.Crosses }); } else { sa.Append(new C.CrossesAt() { Val = this.CrossesAt }); } } if (this.iTickLabelSkip > 1) sa.Append(new C.TickLabelSkip() { Val = this.TickLabelSkip }); if (this.iTickMarkSkip > 1) sa.Append(new C.TickMarkSkip() { Val = this.TickMarkSkip }); return sa; }
internal C.SeriesAxis ToSeriesAxis(bool IsStylish = false) { C.SeriesAxis sa = new C.SeriesAxis(); sa.AxisId = new C.AxisId() { Val = this.AxisId }; sa.Scaling = new C.Scaling(); sa.Scaling.Orientation = new C.Orientation() { Val = this.Orientation }; if (this.LogBase != null) { sa.Scaling.LogBase = new C.LogBase() { Val = this.LogBase.Value } } ; if (this.MaxAxisValue != null) { sa.Scaling.MaxAxisValue = new C.MaxAxisValue() { Val = this.MaxAxisValue.Value } } ; if (this.MinAxisValue != null) { sa.Scaling.MinAxisValue = new C.MinAxisValue() { Val = this.MinAxisValue.Value } } ; sa.Delete = new C.Delete() { Val = this.Delete }; sa.AxisPosition = new C.AxisPosition() { Val = this.AxisPosition }; if (this.ShowMajorGridlines) { sa.MajorGridlines = this.MajorGridlines.ToMajorGridlines(IsStylish); } if (this.ShowMinorGridlines) { sa.MinorGridlines = this.MinorGridlines.ToMinorGridlines(IsStylish); } if (this.ShowTitle) { sa.Title = this.Title.ToTitle(IsStylish); } if (this.HasNumberingFormat) { sa.NumberingFormat = new C.NumberingFormat() { FormatCode = this.FormatCode, SourceLinked = this.SourceLinked }; } sa.MajorTickMark = new C.MajorTickMark() { Val = this.MajorTickMark }; sa.MinorTickMark = new C.MinorTickMark() { Val = this.MinorTickMark }; sa.TickLabelPosition = new C.TickLabelPosition() { Val = this.TickLabelPosition }; if (this.ShapeProperties.HasShapeProperties) { sa.ChartShapeProperties = this.ShapeProperties.ToChartShapeProperties(); } if (this.Rotation != null || this.Vertical != null || this.Anchor != null || this.AnchorCenter != null) { sa.TextProperties = new C.TextProperties(); sa.TextProperties.BodyProperties = new A.BodyProperties(); if (this.Rotation != null) { sa.TextProperties.BodyProperties.Rotation = (int)(this.Rotation.Value * SLConstants.DegreeToAngleRepresentation); } if (this.Vertical != null) { sa.TextProperties.BodyProperties.Vertical = this.Vertical.Value; } if (this.Anchor != null) { sa.TextProperties.BodyProperties.Anchor = this.Anchor.Value; } if (this.AnchorCenter != null) { sa.TextProperties.BodyProperties.AnchorCenter = this.AnchorCenter.Value; } sa.TextProperties.ListStyle = new A.ListStyle(); A.Paragraph para = new A.Paragraph(); para.ParagraphProperties = new A.ParagraphProperties(); para.ParagraphProperties.Append(new A.DefaultRunProperties()); sa.TextProperties.Append(para); } else if (IsStylish) { sa.TextProperties = new C.TextProperties(); sa.TextProperties.BodyProperties = new A.BodyProperties() { Rotation = -60000000, UseParagraphSpacing = true, VerticalOverflow = A.TextVerticalOverflowValues.Ellipsis, Vertical = A.TextVerticalValues.Horizontal, Wrap = A.TextWrappingValues.Square, Anchor = A.TextAnchoringTypeValues.Center, AnchorCenter = true }; sa.TextProperties.ListStyle = new A.ListStyle(); A.Paragraph para = new A.Paragraph(); para.ParagraphProperties = new A.ParagraphProperties(); A.DefaultRunProperties defrunprops = new A.DefaultRunProperties(); defrunprops.FontSize = 900; defrunprops.Bold = false; defrunprops.Italic = false; defrunprops.Underline = A.TextUnderlineValues.None; defrunprops.Strike = A.TextStrikeValues.NoStrike; defrunprops.Kerning = 1200; defrunprops.Baseline = 0; A.SchemeColor schclr = new A.SchemeColor() { Val = A.SchemeColorValues.Text1 }; schclr.Append(new A.LuminanceModulation() { Val = 65000 }); schclr.Append(new A.LuminanceOffset() { Val = 35000 }); defrunprops.Append(new A.SolidFill() { SchemeColor = schclr }); defrunprops.Append(new A.LatinFont() { Typeface = "+mn-lt" }); defrunprops.Append(new A.EastAsianFont() { Typeface = "+mn-ea" }); defrunprops.Append(new A.ComplexScriptFont() { Typeface = "+mn-cs" }); para.ParagraphProperties.Append(defrunprops); para.Append(new A.EndParagraphRunProperties() { Language = System.Globalization.CultureInfo.CurrentCulture.Name }); sa.TextProperties.Append(para); } sa.CrossingAxis = new C.CrossingAxis() { Val = this.CrossingAxis }; if (this.IsCrosses != null) { if (this.IsCrosses.Value) { sa.Append(new C.Crosses() { Val = this.Crosses }); } else { sa.Append(new C.CrossesAt() { Val = this.CrossesAt }); } } if (this.iTickLabelSkip > 1) { sa.Append(new C.TickLabelSkip() { Val = this.TickLabelSkip }); } if (this.iTickMarkSkip > 1) { sa.Append(new C.TickMarkSkip() { Val = this.TickMarkSkip }); } return(sa); }