protected DateAxis GenerateDateAxis(AxisId axisId, AxisPositionValues axisPosition, AxisId crossingAxisId, TickLabelPositionValues tickLabelPosition)
{
DateAxis dateAxis1 = new DateAxis();
AxisId axisId3 = 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 = dateAxisFormat, SourceLinked = true };
MajorTickMark majorTickMark1 = new MajorTickMark() { Val = TickMarkValues.None };
TickLabelPosition tickLabelPosition1 = new TickLabelPosition() { Val = tickLabelPosition };
TextProperties textProperties1 = new TextProperties();
A::BodyProperties bodyProperties2 = new A::BodyProperties() { Rotation = -5400000, Vertical = A::TextVerticalValues.Horizontal };
A::ListStyle listStyle2 = new A::ListStyle();
A::Paragraph paragraph2 = new A::Paragraph();
A::ParagraphProperties paragraphProperties2 = new A::ParagraphProperties();
A::DefaultRunProperties defaultRunProperties2 = new A::DefaultRunProperties() { Language = DEFAULT_LANG };
paragraphProperties2.Append(defaultRunProperties2);
A::EndParagraphRunProperties endParagraphRunProperties1 = new A::EndParagraphRunProperties() { Language = DEFAULT_LANG };
paragraph2.Append(paragraphProperties2);
paragraph2.Append(endParagraphRunProperties1);
textProperties1.Append(bodyProperties2);
textProperties1.Append(listStyle2);
textProperties1.Append(paragraph2);
CrossingAxis crossingAxis1 = new CrossingAxis() { Val = crossingAxisId.Val };
Crosses crosses1 = new Crosses() { Val = CrossesValues.AutoZero };
AutoLabeled autoLabeled1 = new AutoLabeled() { Val = true };
LabelOffset labelOffset1 = new LabelOffset() { Val = (UInt16Value)100U };
dateAxis1.Append(axisId3);
dateAxis1.Append(scaling1);
dateAxis1.Append(axisPosition1);
dateAxis1.Append(numberingFormat1);
dateAxis1.Append(majorTickMark1);
dateAxis1.Append(tickLabelPosition1);
dateAxis1.Append(textProperties1);
dateAxis1.Append(crossingAxis1);
dateAxis1.Append(crosses1);
dateAxis1.Append(autoLabeled1);
dateAxis1.Append(labelOffset1);
return dateAxis1;
}
internal C.DateAxis ToDateAxis(bool IsStylish = false)
{
C.DateAxis da = new C.DateAxis();
da.AxisId = new C.AxisId() { Val = this.AxisId };
da.Scaling = new C.Scaling();
da.Scaling.Orientation = new C.Orientation() { Val = this.Orientation };
if (this.LogBase != null) da.Scaling.LogBase = new C.LogBase() { Val = this.LogBase.Value };
if (this.MaxAxisValue != null) da.Scaling.MaxAxisValue = new C.MaxAxisValue() { Val = this.MaxAxisValue.Value };
if (this.MinAxisValue != null) da.Scaling.MinAxisValue = new C.MinAxisValue() { Val = this.MinAxisValue.Value };
da.Delete = new C.Delete() { Val = this.Delete };
C.AxisPositionValues axpos = this.AxisPosition;
if (!this.ForceAxisPosition)
{
if (this.OtherAxisIsInReverseOrder) axpos = SLChartTool.GetOppositePosition(axpos);
if (this.OtherAxisCrossedAtMaximum) axpos = SLChartTool.GetOppositePosition(axpos);
}
da.AxisPosition = new C.AxisPosition() { Val = axpos };
if (this.ShowMajorGridlines)
{
da.MajorGridlines = this.MajorGridlines.ToMajorGridlines(IsStylish);
}
if (this.ShowMinorGridlines)
{
da.MinorGridlines = this.MinorGridlines.ToMinorGridlines(IsStylish);
}
if (this.ShowTitle)
{
da.Title = this.Title.ToTitle(IsStylish);
}
if (this.HasNumberingFormat)
{
da.NumberingFormat = new C.NumberingFormat()
{
FormatCode = this.FormatCode,
SourceLinked = this.SourceLinked
};
}
da.MajorTickMark = new C.MajorTickMark() { Val = this.MajorTickMark };
da.MinorTickMark = new C.MinorTickMark() { Val = this.MinorTickMark };
da.TickLabelPosition = new C.TickLabelPosition() { Val = this.TickLabelPosition };
if (this.ShapeProperties.HasShapeProperties) da.ChartShapeProperties = this.ShapeProperties.ToChartShapeProperties(IsStylish);
if (this.Rotation != null || this.Vertical != null || this.Anchor != null || this.AnchorCenter != null)
{
da.TextProperties = new C.TextProperties();
da.TextProperties.BodyProperties = new A.BodyProperties();
if (this.Rotation != null) da.TextProperties.BodyProperties.Rotation = (int)(this.Rotation.Value * SLConstants.DegreeToAngleRepresentation);
if (this.Vertical != null) da.TextProperties.BodyProperties.Vertical = this.Vertical.Value;
if (this.Anchor != null) da.TextProperties.BodyProperties.Anchor = this.Anchor.Value;
if (this.AnchorCenter != null) da.TextProperties.BodyProperties.AnchorCenter = this.AnchorCenter.Value;
da.TextProperties.ListStyle = new A.ListStyle();
A.Paragraph para = new A.Paragraph();
para.ParagraphProperties = new A.ParagraphProperties();
para.ParagraphProperties.Append(new A.DefaultRunProperties());
da.TextProperties.Append(para);
}
else if (IsStylish)
{
da.TextProperties = new C.TextProperties();
da.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
};
da.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 });
da.TextProperties.Append(para);
}
da.CrossingAxis = new C.CrossingAxis() { Val = this.CrossingAxis };
if (this.IsCrosses != null)
{
if (this.IsCrosses.Value)
{
da.Append(new C.Crosses() { Val = this.Crosses });
}
else
{
da.Append(new C.CrossesAt() { Val = this.CrossesAt });
}
}
da.Append(new C.AutoLabeled() { Val = this.AutoLabeled });
da.Append(new C.LabelOffset() { Val = this.LabelOffset });
if (this.BaseUnit != null) da.Append(new C.BaseTimeUnit() { Val = this.BaseUnit.Value });
if (this.iMajorUnit != null)
{
da.Append(new C.MajorUnit() { Val = this.iMajorUnit.Value });
da.Append(new C.MajorTimeUnit() { Val = this.vMajorTimeUnit });
}
if (this.iMinorUnit != null)
{
da.Append(new C.MinorUnit() { Val = this.iMinorUnit.Value });
da.Append(new C.MinorTimeUnit() { Val = this.vMinorTimeUnit });
}
return da;
}
internal C.DateAxis ToDateAxis(bool IsStylish)
{
C.DateAxis da = new C.DateAxis();
da.AxisId = new C.AxisId()
{
Val = this.AxisId
};
da.Scaling = new C.Scaling();
da.Scaling.Orientation = new C.Orientation()
{
Val = this.Orientation
};
if (this.LogBase != null)
{
da.Scaling.LogBase = new C.LogBase()
{
Val = this.LogBase.Value
}
}
;
if (this.MaxAxisValue != null)
{
da.Scaling.MaxAxisValue = new C.MaxAxisValue()
{
Val = this.MaxAxisValue.Value
}
}
;
if (this.MinAxisValue != null)
{
da.Scaling.MinAxisValue = new C.MinAxisValue()
{
Val = this.MinAxisValue.Value
}
}
;
da.Delete = new C.Delete()
{
Val = this.Delete
};
C.AxisPositionValues axpos = this.AxisPosition;
if (!this.ForceAxisPosition)
{
if (this.OtherAxisIsInReverseOrder)
{
axpos = SLChartTool.GetOppositePosition(axpos);
}
if (this.OtherAxisCrossedAtMaximum)
{
axpos = SLChartTool.GetOppositePosition(axpos);
}
}
da.AxisPosition = new C.AxisPosition()
{
Val = axpos
};
if (this.ShowMajorGridlines)
{
da.MajorGridlines = this.MajorGridlines.ToMajorGridlines(IsStylish);
}
if (this.ShowMinorGridlines)
{
da.MinorGridlines = this.MinorGridlines.ToMinorGridlines(IsStylish);
}
if (this.ShowTitle)
{
da.Title = this.Title.ToTitle(IsStylish);
}
if (this.HasNumberingFormat)
{
da.NumberingFormat = new C.NumberingFormat()
{
FormatCode = this.FormatCode,
SourceLinked = this.SourceLinked
};
}
da.MajorTickMark = new C.MajorTickMark()
{
Val = this.MajorTickMark
};
da.MinorTickMark = new C.MinorTickMark()
{
Val = this.MinorTickMark
};
da.TickLabelPosition = new C.TickLabelPosition()
{
Val = this.TickLabelPosition
};
if (this.ShapeProperties.HasShapeProperties)
{
da.ChartShapeProperties = this.ShapeProperties.ToChartShapeProperties(IsStylish);
}
if (this.Rotation != null || this.Vertical != null || this.Anchor != null || this.AnchorCenter != null)
{
da.TextProperties = new C.TextProperties();
da.TextProperties.BodyProperties = new A.BodyProperties();
if (this.Rotation != null)
{
da.TextProperties.BodyProperties.Rotation = (int)(this.Rotation.Value * SLConstants.DegreeToAngleRepresentation);
}
if (this.Vertical != null)
{
da.TextProperties.BodyProperties.Vertical = this.Vertical.Value;
}
if (this.Anchor != null)
{
da.TextProperties.BodyProperties.Anchor = this.Anchor.Value;
}
if (this.AnchorCenter != null)
{
da.TextProperties.BodyProperties.AnchorCenter = this.AnchorCenter.Value;
}
da.TextProperties.ListStyle = new A.ListStyle();
A.Paragraph para = new A.Paragraph();
para.ParagraphProperties = new A.ParagraphProperties();
para.ParagraphProperties.Append(new A.DefaultRunProperties());
da.TextProperties.Append(para);
}
else if (IsStylish)
{
da.TextProperties = new C.TextProperties();
da.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
};
da.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
});
da.TextProperties.Append(para);
}
da.CrossingAxis = new C.CrossingAxis()
{
Val = this.CrossingAxis
};
if (this.IsCrosses != null)
{
if (this.IsCrosses.Value)
{
da.Append(new C.Crosses()
{
Val = this.Crosses
});
}
else
{
da.Append(new C.CrossesAt()
{
Val = this.CrossesAt
});
}
}
da.Append(new C.AutoLabeled()
{
Val = this.AutoLabeled
});
da.Append(new C.LabelOffset()
{
Val = this.LabelOffset
});
if (this.BaseUnit != null)
{
da.Append(new C.BaseTimeUnit()
{
Val = this.BaseUnit.Value
});
}
if (this.iMajorUnit != null)
{
da.Append(new C.MajorUnit()
{
Val = this.iMajorUnit.Value
});
da.Append(new C.MajorTimeUnit()
{
Val = this.vMajorTimeUnit
});
}
if (this.iMinorUnit != null)
{
da.Append(new C.MinorUnit()
{
Val = this.iMinorUnit.Value
});
da.Append(new C.MinorTimeUnit()
{
Val = this.vMinorTimeUnit
});
}
return(da);
}
internal C.DateAxis ToDateAxis()
{
C.DateAxis da = new C.DateAxis();
da.AxisId = new C.AxisId() { Val = this.AxisId };
da.Scaling = new C.Scaling();
da.Scaling.Orientation = new C.Orientation() { Val = this.Orientation };
if (this.LogBase != null) da.Scaling.LogBase = new C.LogBase() { Val = this.LogBase.Value };
if (this.MaxAxisValue != null) da.Scaling.MaxAxisValue = new C.MaxAxisValue() { Val = this.MaxAxisValue.Value };
if (this.MinAxisValue != null) da.Scaling.MinAxisValue = new C.MinAxisValue() { Val = this.MinAxisValue.Value };
da.Delete = new C.Delete() { Val = this.Delete };
C.AxisPositionValues axpos = this.AxisPosition;
if (this.OtherAxisIsInReverseOrder) axpos = SLChartTool.GetOppositePosition(axpos);
if (this.OtherAxisCrossedAtMaximum) axpos = SLChartTool.GetOppositePosition(axpos);
da.AxisPosition = new C.AxisPosition() { Val = axpos };
if (this.ShowMajorGridlines)
{
da.MajorGridlines = this.MajorGridlines.ToMajorGridlines();
}
if (this.ShowMinorGridlines)
{
da.MinorGridlines = this.MinorGridlines.ToMinorGridlines();
}
if (this.ShowTitle)
{
da.Title = this.Title.ToTitle();
}
if (this.HasNumberingFormat)
{
da.NumberingFormat = new C.NumberingFormat()
{
FormatCode = this.FormatCode,
SourceLinked = this.SourceLinked
};
}
da.MajorTickMark = new C.MajorTickMark() { Val = this.MajorTickMark };
da.MinorTickMark = new C.MinorTickMark() { Val = this.MinorTickMark };
da.TickLabelPosition = new C.TickLabelPosition() { Val = this.TickLabelPosition };
if (this.ShapeProperties.HasShapeProperties) da.ChartShapeProperties = this.ShapeProperties.ToChartShapeProperties();
if (this.Rotation != null || this.Vertical != null || this.Anchor != null || this.AnchorCenter != null)
{
da.TextProperties = new C.TextProperties();
da.TextProperties.BodyProperties = new A.BodyProperties();
if (this.Rotation != null) da.TextProperties.BodyProperties.Rotation = (int)(this.Rotation.Value * SLConstants.DegreeToAngleRepresentation);
if (this.Vertical != null) da.TextProperties.BodyProperties.Vertical = this.Vertical.Value;
if (this.Anchor != null) da.TextProperties.BodyProperties.Anchor = this.Anchor.Value;
if (this.AnchorCenter != null) da.TextProperties.BodyProperties.AnchorCenter = this.AnchorCenter.Value;
da.TextProperties.ListStyle = new A.ListStyle();
A.Paragraph para = new A.Paragraph();
para.ParagraphProperties = new A.ParagraphProperties();
para.ParagraphProperties.Append(new A.DefaultRunProperties());
da.TextProperties.Append(para);
}
da.CrossingAxis = new C.CrossingAxis() { Val = this.CrossingAxis };
if (this.IsCrosses != null)
{
if (this.IsCrosses.Value)
{
da.Append(new C.Crosses() { Val = this.Crosses });
}
else
{
da.Append(new C.CrossesAt() { Val = this.CrossesAt });
}
}
da.Append(new C.AutoLabeled() { Val = true });
da.Append(new C.LabelOffset() { Val = this.LabelOffset });
if (this.BaseUnit != null) da.Append(new C.BaseTimeUnit() { Val = this.BaseUnit.Value });
if (this.iMajorUnit != null)
{
da.Append(new C.MajorUnit() { Val = this.iMajorUnit.Value });
da.Append(new C.MajorTimeUnit() { Val = this.vMajorTimeUnit });
}
if (this.iMinorUnit != null)
{
da.Append(new C.MinorUnit() { Val = this.iMinorUnit.Value });
da.Append(new C.MinorTimeUnit() { Val = this.vMinorTimeUnit });
}
return da;
}