public SchemeColor Build()
{
var schemaColor = new SchemeColor();
schemaColor.Val = this.Options.SchemeColor;
decimal decTint = this.Options.Tint;
// we don't have to do anything extra if the tint's zero.
if (decTint < 0.0m)
{
decTint += 1.0m;
decTint *= 100000m;
schemaColor.Append(new LuminanceModulation()
{
Val = Convert.ToInt32(decTint)
});
}
else if (decTint > 0.0m)
{
decTint *= 100000m;
decTint = decimal.Floor(decTint);
schemaColor.Append(new LuminanceModulation()
{
Val = Convert.ToInt32(100000m - decTint)
});
schemaColor.Append(new LuminanceOffset()
{
Val = Convert.ToInt32(decTint)
});
}
var alpha = CalculateAlpha();
if (alpha < 100000)
{
schemaColor.Append(new Alpha()
{
Val = alpha
});
}
return(schemaColor);
}
/// <summary>
/// Design settings for Y axis.
/// </summary>
public ValueAxis SetGanttValueAxis(PlotArea plotArea, TimeSpan minSpan, TimeSpan maxSpan)
{
MajorGridlines majorGridlines1 = new MajorGridlines();
ChartShapeProperties chartShapeProperties2 = new ChartShapeProperties();
Outline outline2 = new Outline();
SolidFill solidFill2 = new SolidFill();
SchemeColor schemeColor2 = new SchemeColor()
{
Val = SchemeColorValues.Accent1
};
Alpha alpha1 = new Alpha()
{
Val = 10000
};
schemeColor2.Append(alpha1);
solidFill2.Append(schemeColor2);
outline2.Append(solidFill2);
chartShapeProperties2.Append(outline2);
majorGridlines1.Append(chartShapeProperties2);
return(plotArea.AppendChild <ValueAxis>(new ValueAxis(new AxisId()
{
Val = new UInt32Value(48672768u)
},
new Scaling(new Orientation()
{
Val = new EnumValue <DocumentFormat.OpenXml.Drawing.Charts.OrientationValues>(
DocumentFormat.OpenXml.Drawing.Charts.OrientationValues.MinMax)
}, new MinAxisValue()
{
Val = 0
}, new MaxAxisValue()
{
Val = 0.99
}),
new Delete()
{
Val = false
},
new AxisPosition()
{
Val = new EnumValue <AxisPositionValues>(AxisPositionValues.Left)
},
majorGridlines1,
new MajorTickMark()
{
Val = TickMarkValues.None
},
new MinorTickMark()
{
Val = TickMarkValues.None
},
new MajorUnit()
{
Val = 4.1666666666666713E-2D
},
new DocumentFormat.OpenXml.Drawing.Charts.NumberingFormat()
{
FormatCode = "h:mm;@", SourceLinked = false
},
new TickLabelPosition()
{
Val = new EnumValue <TickLabelPositionValues>
(TickLabelPositionValues.NextTo)
}, new CrossingAxis()
{
Val = new UInt32Value(48650112U)
},
new Crosses()
{
Val = new EnumValue <CrossesValues>(CrossesValues.AutoZero)
},
new CrossBetween()
{
Val = new EnumValue <CrossBetweenValues>(CrossBetweenValues.Between)
})));
}
/// <summary>
/// Design settings for Y axis.
/// </summary>
public virtual ValueAxis SetValueAxis(PlotArea plotArea)
{
// Postavljanje Gridline-a.
MajorGridlines majorGridlines = new MajorGridlines();
ChartShapeProperties chartShapeProperties = new ChartShapeProperties();
Outline outline = new Outline();
SolidFill solidFill = new SolidFill();
SchemeColor schemeColor = new SchemeColor()
{
Val = SchemeColorValues.Accent1
};
Alpha alpha = new Alpha()
{
Val = 10000
};
schemeColor.Append(alpha);
solidFill.Append(schemeColor);
outline.Append(solidFill);
chartShapeProperties.Append(outline);
majorGridlines.Append(chartShapeProperties);
var valueAxis = plotArea.AppendChild <ValueAxis>(new ValueAxis(
new AxisId()
{
Val = new UInt32Value(48672768u)
},
new Scaling(new Orientation()
{
Val = new EnumValue <DocumentFormat.OpenXml.Drawing.Charts.OrientationValues>(
DocumentFormat.OpenXml.Drawing.Charts.OrientationValues.MinMax)
}),
new Delete()
{
Val = !ChartProperties.AxisY
},
new AxisPosition()
{
Val = new EnumValue <AxisPositionValues>(AxisPositionValues.Left)
},
majorGridlines,
SetTitle(ChartProperties.AxisYTitle),
new NumberingFormat()
{
FormatCode = ChartProperties.AxisYFormatCode,
SourceLinked = new BooleanValue(true)
},
new MajorTickMark()
{
Val = TickMarkValues.None
},
new MinorTickMark()
{
Val = TickMarkValues.None
},
new TickLabelPosition()
{
Val = new EnumValue <TickLabelPositionValues>
(TickLabelPositionValues.NextTo)
}, new CrossingAxis()
{
Val = new UInt32Value(48650112U)
},
new Crosses()
{
Val = new EnumValue <CrossesValues>(CrossesValues.AutoZero)
},
new CrossBetween()
{
Val = new EnumValue <CrossBetweenValues>(CrossBetweenValues.Between)
}));
if (ChartProperties.AxisYFormatCategory == "Time")
{
valueAxis.Append(new MajorUnit()
{
Val = getMajorUnitFromSeconds((int)yAxisValue)
});
}
return(valueAxis);
}
public ValueAxis Build()
{
var valueAxis = new ValueAxis();
valueAxis.AxisId = new AxisId {
Val = this.Options.Id
};
valueAxis.Scaling = new Scaling();
valueAxis.Scaling.Orientation = new Orientation {
Val = this.Options.Orientation
};
if (this.Options.MinMaxBounds.HasValue)
{
var minAxisValue = new MinAxisValue {
Val = this.Options.MinMaxBounds.Value.MinValue
};
var maxAxisValue = new MaxAxisValue {
Val = this.Options.MinMaxBounds.Value.MaxValue
};
valueAxis.Scaling.Append(minAxisValue);
valueAxis.Scaling.Append(maxAxisValue);
}
if (this.Options.MinMaxUnits.HasValue)
{
var minorUnit = new MinorUnit {
Val = this.Options.MinMaxUnits.Value.MinValue
};
var majorUnit = new MajorUnit {
Val = this.Options.MinMaxUnits.Value.MaxValue
};
valueAxis.Append(minorUnit);
valueAxis.Append(majorUnit);
}
valueAxis.Delete = new Delete {
Val = false
};
valueAxis.AxisPosition = new AxisPosition {
Val = this.Options.AxisPosition
};
if (this.Options.ShowMajorGridlines)
{
var majorGridlinesBuilder = new MajorGridlinesBuilder(this.Options.MajorGridlinesOptions);
valueAxis.MajorGridlines = majorGridlinesBuilder.Build();
}
if (this.Options.HasNumberingFormat)
{
valueAxis.NumberingFormat = new NumberingFormat
{
FormatCode = this.Options.FormatCode,
SourceLinked = this.Options.SourceLinked
};
}
valueAxis.MajorTickMark = new MajorTickMark {
Val = this.Options.MajorTickMark
};
valueAxis.MinorTickMark = new MinorTickMark {
Val = this.Options.MinorTickMark
};
valueAxis.TickLabelPosition = new TickLabelPosition {
Val = this.Options.TickLabelPosition
};
if (this.Options.HasChartShapeProperties)
{
var chartShapePropertiesBuilder = new ChartShapePropertiesBuilder(this.Options.ChartShapePropertiesOptions);
valueAxis.ChartShapeProperties = chartShapePropertiesBuilder.Build();
}
if (this.Options.IsTextStylish)
{
valueAxis.TextProperties = new TextProperties();
valueAxis.TextProperties.BodyProperties = new BodyProperties()
{
Rotation = -60000000,
UseParagraphSpacing = true,
VerticalOverflow = TextVerticalOverflowValues.Ellipsis,
Vertical = TextVerticalValues.Horizontal,
Wrap = TextWrappingValues.Square,
Anchor = TextAnchoringTypeValues.Center,
AnchorCenter = true
};
valueAxis.TextProperties.ListStyle = new ListStyle();
var para = new Paragraph();
para.ParagraphProperties = new ParagraphProperties();
var defrunprops = new DefaultRunProperties();
defrunprops.FontSize = 900;
defrunprops.Bold = false;
defrunprops.Italic = false;
defrunprops.Underline = TextUnderlineValues.None;
defrunprops.Strike = TextStrikeValues.NoStrike;
defrunprops.Kerning = 1200;
defrunprops.Baseline = 0;
var schclr = new SchemeColor()
{
Val = SchemeColorValues.Text1
};
schclr.Append(new LuminanceModulation()
{
Val = 65000
});
schclr.Append(new LuminanceOffset()
{
Val = 35000
});
defrunprops.Append(new SolidFill()
{
SchemeColor = schclr
});
defrunprops.Append(new LatinFont()
{
Typeface = "+mn-lt"
});
defrunprops.Append(new EastAsianFont()
{
Typeface = "+mn-ea"
});
defrunprops.Append(new ComplexScriptFont()
{
Typeface = "+mn-cs"
});
para.ParagraphProperties.Append(defrunprops);
para.Append(new EndParagraphRunProperties()
{
Language = System.Globalization.CultureInfo.CurrentCulture.Name
});
valueAxis.TextProperties.Append(para);
}
valueAxis.CrossingAxis = new CrossingAxis {
Val = this.Options.CrossingAxisVal
};
if (this.Options.Crosses.HasValue)
{
valueAxis.Append(new Crosses {
Val = this.Options.Crosses
});
}
else if (this.Options.CrossesAtVal.HasValue)
{
valueAxis.Append(new CrossesAt()
{
Val = this.Options.CrossesAtVal
});
}
valueAxis.Append(new CrossBetween {
Val = this.Options.CrossBetween
});
return(valueAxis);
}