internal C.ValueAxis ToValueAxis(bool IsStylish = false)
{
var va = new C.ValueAxis();
va.AxisId = new C.AxisId {
Val = AxisId
};
va.Scaling = new C.Scaling();
va.Scaling.Orientation = new C.Orientation {
Val = Orientation
};
if (LogBase != null)
{
va.Scaling.LogBase = new C.LogBase {
Val = LogBase.Value
}
}
;
if (MaxAxisValue != null)
{
va.Scaling.MaxAxisValue = new C.MaxAxisValue {
Val = MaxAxisValue.Value
}
}
;
if (MinAxisValue != null)
{
va.Scaling.MinAxisValue = new C.MinAxisValue {
Val = MinAxisValue.Value
}
}
;
va.Delete = new C.Delete {
Val = Delete
};
var axpos = AxisPosition;
if (!ForceAxisPosition)
{
if (OtherAxisIsInReverseOrder)
{
axpos = SLChartTool.GetOppositePosition(axpos);
}
if (OtherAxisCrossedAtMaximum)
{
axpos = SLChartTool.GetOppositePosition(axpos);
}
}
va.AxisPosition = new C.AxisPosition {
Val = axpos
};
if (ShowMajorGridlines)
{
va.MajorGridlines = MajorGridlines.ToMajorGridlines(IsStylish);
}
if (ShowMinorGridlines)
{
va.MinorGridlines = MinorGridlines.ToMinorGridlines(IsStylish);
}
if (ShowTitle)
{
va.Title = Title.ToTitle(IsStylish);
}
if (HasNumberingFormat)
{
va.NumberingFormat = new C.NumberingFormat
{
FormatCode = FormatCode,
SourceLinked = SourceLinked
}
}
;
va.MajorTickMark = new C.MajorTickMark {
Val = MajorTickMark
};
va.MinorTickMark = new C.MinorTickMark {
Val = MinorTickMark
};
va.TickLabelPosition = new C.TickLabelPosition {
Val = TickLabelPosition
};
if (ShapeProperties.HasShapeProperties)
{
va.ChartShapeProperties = ShapeProperties.ToChartShapeProperties(IsStylish);
}
if ((Rotation != null) || (Vertical != null) || (Anchor != null) || (AnchorCenter != null))
{
va.TextProperties = new C.TextProperties();
va.TextProperties.BodyProperties = new A.BodyProperties();
if (Rotation != null)
{
va.TextProperties.BodyProperties.Rotation =
(int)(Rotation.Value * SLConstants.DegreeToAngleRepresentation);
}
if (Vertical != null)
{
va.TextProperties.BodyProperties.Vertical = Vertical.Value;
}
if (Anchor != null)
{
va.TextProperties.BodyProperties.Anchor = Anchor.Value;
}
if (AnchorCenter != null)
{
va.TextProperties.BodyProperties.AnchorCenter = AnchorCenter.Value;
}
va.TextProperties.ListStyle = new A.ListStyle();
var para = new A.Paragraph();
para.ParagraphProperties = new A.ParagraphProperties();
para.ParagraphProperties.Append(new A.DefaultRunProperties());
va.TextProperties.Append(para);
}
else if (IsStylish)
{
va.TextProperties = new C.TextProperties();
va.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
};
va.TextProperties.ListStyle = new A.ListStyle();
var para = new A.Paragraph();
para.ParagraphProperties = new A.ParagraphProperties();
var 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;
var 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 = CultureInfo.CurrentCulture.Name
});
va.TextProperties.Append(para);
}
va.CrossingAxis = new C.CrossingAxis {
Val = CrossingAxis
};
if (IsCrosses != null)
{
if (IsCrosses.Value)
{
va.Append(new C.Crosses {
Val = Crosses
});
}
else
{
va.Append(new C.CrossesAt {
Val = CrossesAt
});
}
}
va.Append(new C.CrossBetween {
Val = CrossBetween
});
if (MajorUnit != null)
{
va.Append(new C.MajorUnit {
Val = MajorUnit.Value
});
}
if (MinorUnit != null)
{
va.Append(new C.MinorUnit {
Val = MinorUnit.Value
});
}
if (BuiltInUnitValues != null)
{
var du = new C.DisplayUnits();
du.Append(new C.BuiltInUnit {
Val = BuiltInUnitValues.Value
});
if (ShowDisplayUnitsLabel)
{
var dul = new C.DisplayUnitsLabel();
dul.Layout = new C.Layout();
du.Append(dul);
}
va.Append(du);
}
return(va);
}
internal void RefreshFormula()
{
Formula = SLChartTool.GetChartReferenceFormula(WorksheetName, StartRowIndex, StartColumnIndex, EndRowIndex,
EndColumnIndex);
}