/// <summary>
/// Updates the chart.
/// </summary>
/// <param name="chart">The chart.</param>
/// <param name="sheetName">Name of the sheet.</param>
protected override void UpdateChart(OpenXmlCompositeElement chart, string sheetName)
{
if (chart != null)
{
chart.RemoveAllChildren <ScatterChartSeries>();
ScatterChartSeries scatterChartSeries = chart.AppendChild <ScatterChartSeries>(new ScatterChartSeries());
Outline outline = new Outline()
{
Width = 28575
};
NoFill noFill = new NoFill();
outline.Append(noFill);
scatterChartSeries.ChartShapeProperties = new ChartShapeProperties(outline);
UpdateSeriesText(sheetName, scatterChartSeries, "B", 1, chartData.yColumnName);
XValues xValues = scatterChartSeries.AppendChild <XValues>(new XValues());
YValues yValues = scatterChartSeries.AppendChild <YValues>(new YValues());
NumberReference referenceX = CreateNumberReference(xValues, sheetName + "!$A$2:$A$" + (chartData.Count + 1).ToString());
NumberReference referenceY = CreateNumberReference(yValues, sheetName + "!$B$2:$B$" + (chartData.Count + 1).ToString());
NumberingCache ncX;
PointCount ptXCount;
NumberingCache ncY;
PointCount ptYCount;
SetNumberingCache(referenceX, out ncX, out ptXCount);
SetNumberingCache(referenceY, out ncY, out ptYCount);
int rowIndex = 0;
foreach (var xToY in chartData.xValToYValMap)
{
AddNumericPoint(ncX, ptXCount, rowIndex, xToY.Key.ToString());
AddNumericPoint(ncY, ptYCount, rowIndex, xToY.Value.ToString());
rowIndex += 1;
}
}
}
/// <summary>
/// Creates an image paragraph.
/// </summary>
/// <param name="relationshipId">The relationship id.</param>
/// <param name="name">The name.</param>
/// <param name="description">The description.</param>
/// <param name="width">The width.</param>
/// <param name="height">The height.</param>
/// <returns>The <see cref="Paragraph" /> containing the image.</returns>
private DocumentFormat.OpenXml.Wordprocessing.Paragraph CreateImageParagraph(
string relationshipId, string name, string description, double width, double height)
{
// http://msdn.microsoft.com/en-us/library/documentformat.openxml.drawing.extents.aspx
// http://polymathprogrammer.com/2009/10/22/english-metric-units-and-open-xml/
// cx (Extent Length)
// Specifies the length of the extents rectangle in EMUs. This rectangle shall dictate the size of the object as displayed (the result of any scaling to the original object).
// Example: Consider a DrawingML object specified as follows:
// <… cx="1828800" cy="200000"/>
// The cx attributes specifies that this object has a height of 1828800 EMUs (English Metric Units). end example]
// The possible values for this attribute are defined by the ST_PositiveCoordinate simple type (§20.1.10.42).
// cy (Extent Width)
// Specifies the width of the extents rectangle in EMUs. This rectangle shall dictate the size of the object as displayed (the result of any scaling to the original object).
// Example: Consider a DrawingML object specified as follows:
// < … cx="1828800" cy="200000"/>
// The cy attribute specifies that this object has a width of 200000 EMUs (English Metric Units). end example]
// The possible values for this attribute are defined by the ST_PositiveCoordinate simple type (§20.1.10.42).
var paragraph1 = new DocumentFormat.OpenXml.Wordprocessing.Paragraph
{
RsidParagraphAddition = "00D91137",
RsidRunAdditionDefault = "00AC08EB"
};
var run1 = new Run();
var runProperties1 = new RunProperties();
var noProof1 = new NoProof();
runProperties1.AppendChild(noProof1);
var drawing1 = new Drawing();
var inline1 = new Inline
{
DistanceFromTop = 0U,
DistanceFromBottom = 0U,
DistanceFromLeft = 0U,
DistanceFromRight = 0U
};
var extent1 = new Extent {
Cx = 5753100L, Cy = 3600450L
};
extent1.Cx = (long)(width * 914400);
extent1.Cy = (long)(height * 914400);
var effectExtent1 = new EffectExtent {
LeftEdge = 0L, TopEdge = 0L, RightEdge = 0L, BottomEdge = 0L
};
var docProperties1 = new DocProperties {
Id = 1U, Name = name, Description = description
};
var nonVisualGraphicFrameDrawingProperties1 = new NonVisualGraphicFrameDrawingProperties();
var graphicFrameLocks1 = new GraphicFrameLocks {
NoChangeAspect = true
};
graphicFrameLocks1.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main");
nonVisualGraphicFrameDrawingProperties1.AppendChild(graphicFrameLocks1);
var graphic1 = new Graphic();
graphic1.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main");
var graphicData1 = new GraphicData {
Uri = "http://schemas.openxmlformats.org/drawingml/2006/picture"
};
var picture1 = new Picture();
picture1.AddNamespaceDeclaration("pic", "http://schemas.openxmlformats.org/drawingml/2006/picture");
var nonVisualPictureProperties1 = new NonVisualPictureProperties();
var nonVisualDrawingProperties1 = new NonVisualDrawingProperties
{
Id = 0U,
Name = name,
Description = description
};
var nonVisualPictureDrawingProperties1 = new NonVisualPictureDrawingProperties();
var pictureLocks1 = new PictureLocks {
NoChangeAspect = true, NoChangeArrowheads = true
};
nonVisualPictureDrawingProperties1.AppendChild(pictureLocks1);
nonVisualPictureProperties1.AppendChild(nonVisualDrawingProperties1);
nonVisualPictureProperties1.AppendChild(nonVisualPictureDrawingProperties1);
var blipFill1 = new BlipFill();
var blip1 = new Blip {
Embed = relationshipId
};
var blipExtensionList1 = new BlipExtensionList();
var blipExtension1 = new BlipExtension {
Uri = "{28A0092B-C50C-407E-A947-70E740481C1C}"
};
var useLocalDpi1 = new UseLocalDpi {
Val = false
};
useLocalDpi1.AddNamespaceDeclaration("a14", "http://schemas.microsoft.com/office/drawing/2010/main");
blipExtension1.AppendChild(useLocalDpi1);
blipExtensionList1.AppendChild(blipExtension1);
blip1.AppendChild(blipExtensionList1);
var sourceRectangle1 = new SourceRectangle();
var stretch1 = new Stretch();
var fillRectangle1 = new FillRectangle();
stretch1.AppendChild(fillRectangle1);
blipFill1.AppendChild(blip1);
blipFill1.AppendChild(sourceRectangle1);
blipFill1.AppendChild(stretch1);
var shapeProperties1 = new ShapeProperties {
BlackWhiteMode = BlackWhiteModeValues.Auto
};
var transform2D1 = new Transform2D();
var offset1 = new Offset {
X = 0L, Y = 0L
};
var extents1 = new Extents {
Cx = extent1.Cx, Cy = extent1.Cy
};
transform2D1.AppendChild(offset1);
transform2D1.AppendChild(extents1);
var presetGeometry1 = new PresetGeometry {
Preset = ShapeTypeValues.Rectangle
};
var adjustValueList1 = new AdjustValueList();
presetGeometry1.AppendChild(adjustValueList1);
var noFill1 = new NoFill();
var outline1 = new Outline();
var noFill2 = new NoFill();
outline1.AppendChild(noFill2);
shapeProperties1.AppendChild(transform2D1);
shapeProperties1.AppendChild(presetGeometry1);
shapeProperties1.AppendChild(noFill1);
shapeProperties1.AppendChild(outline1);
picture1.AppendChild(nonVisualPictureProperties1);
picture1.AppendChild(blipFill1);
picture1.AppendChild(shapeProperties1);
graphicData1.AppendChild(picture1);
graphic1.AppendChild(graphicData1);
inline1.AppendChild(extent1);
inline1.AppendChild(effectExtent1);
inline1.AppendChild(docProperties1);
inline1.AppendChild(nonVisualGraphicFrameDrawingProperties1);
inline1.AppendChild(graphic1);
drawing1.AppendChild(inline1);
run1.AppendChild(runProperties1);
run1.AppendChild(drawing1);
paragraph1.AppendChild(run1);
return(paragraph1);
}