// Generates content of drawingsPart1. private void GenerateDrawingsPart1Content(DrawingsPart drawingsPart1) { Xdr.WorksheetDrawing worksheetDrawing1 = new Xdr.WorksheetDrawing(); worksheetDrawing1.AddNamespaceDeclaration("xdr", "http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing"); worksheetDrawing1.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main"); Xdr.TwoCellAnchor twoCellAnchor1 = new Xdr.TwoCellAnchor(); Xdr.FromMarker fromMarker1 = new Xdr.FromMarker(); Xdr.ColumnId columnId1 = new Xdr.ColumnId(); columnId1.Text = "2"; Xdr.ColumnOffset columnOffset1 = new Xdr.ColumnOffset(); columnOffset1.Text = "185737"; Xdr.RowId rowId1 = new Xdr.RowId(); rowId1.Text = "0"; Xdr.RowOffset rowOffset1 = new Xdr.RowOffset(); rowOffset1.Text = "0"; fromMarker1.Append(columnId1); fromMarker1.Append(columnOffset1); fromMarker1.Append(rowId1); fromMarker1.Append(rowOffset1); Xdr.ToMarker toMarker1 = new Xdr.ToMarker(); Xdr.ColumnId columnId2 = new Xdr.ColumnId(); columnId2.Text = "9"; Xdr.ColumnOffset columnOffset2 = new Xdr.ColumnOffset(); columnOffset2.Text = "90487"; Xdr.RowId rowId2 = new Xdr.RowId(); rowId2.Text = "14"; Xdr.RowOffset rowOffset2 = new Xdr.RowOffset(); rowOffset2.Text = "76200"; toMarker1.Append(columnId2); toMarker1.Append(columnOffset2); toMarker1.Append(rowId2); toMarker1.Append(rowOffset2); Xdr.GraphicFrame graphicFrame1 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties1 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties1 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)2U, Name = "Chart 1" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties1 = new Xdr.NonVisualGraphicFrameDrawingProperties(); A.GraphicFrameLocks graphicFrameLocks1 = new A.GraphicFrameLocks(); nonVisualGraphicFrameDrawingProperties1.Append(graphicFrameLocks1); nonVisualGraphicFrameProperties1.Append(nonVisualDrawingProperties1); nonVisualGraphicFrameProperties1.Append(nonVisualGraphicFrameDrawingProperties1); Xdr.Transform transform1 = new Xdr.Transform(); A.Offset offset1 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents1 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform1.Append(offset1); transform1.Append(extents1); A.Graphic graphic1 = new A.Graphic(); A.GraphicData graphicData1 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" }; C.ChartReference chartReference1 = new C.ChartReference(){ Id = "rId1" }; chartReference1.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); chartReference1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); graphicData1.Append(chartReference1); graphic1.Append(graphicData1); graphicFrame1.Append(nonVisualGraphicFrameProperties1); graphicFrame1.Append(transform1); graphicFrame1.Append(graphic1); Xdr.ClientData clientData1 = new Xdr.ClientData(); twoCellAnchor1.Append(fromMarker1); twoCellAnchor1.Append(toMarker1); twoCellAnchor1.Append(graphicFrame1); twoCellAnchor1.Append(clientData1); Xdr.TwoCellAnchor twoCellAnchor2 = new Xdr.TwoCellAnchor(); Xdr.FromMarker fromMarker2 = new Xdr.FromMarker(); Xdr.ColumnId columnId3 = new Xdr.ColumnId(); columnId3.Text = "2"; Xdr.ColumnOffset columnOffset3 = new Xdr.ColumnOffset(); columnOffset3.Text = "200025"; Xdr.RowId rowId3 = new Xdr.RowId(); rowId3.Text = "14"; Xdr.RowOffset rowOffset3 = new Xdr.RowOffset(); rowOffset3.Text = "147637"; fromMarker2.Append(columnId3); fromMarker2.Append(columnOffset3); fromMarker2.Append(rowId3); fromMarker2.Append(rowOffset3); Xdr.ToMarker toMarker2 = new Xdr.ToMarker(); Xdr.ColumnId columnId4 = new Xdr.ColumnId(); columnId4.Text = "7"; Xdr.ColumnOffset columnOffset4 = new Xdr.ColumnOffset(); columnOffset4.Text = "476250"; Xdr.RowId rowId4 = new Xdr.RowId(); rowId4.Text = "29"; Xdr.RowOffset rowOffset4 = new Xdr.RowOffset(); rowOffset4.Text = "33337"; toMarker2.Append(columnId4); toMarker2.Append(columnOffset4); toMarker2.Append(rowId4); toMarker2.Append(rowOffset4); Xdr.GraphicFrame graphicFrame2 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties2 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties2 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)3U, Name = "グラフ 2" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties2 = new Xdr.NonVisualGraphicFrameDrawingProperties(); A.GraphicFrameLocks graphicFrameLocks2 = new A.GraphicFrameLocks(); nonVisualGraphicFrameDrawingProperties2.Append(graphicFrameLocks2); nonVisualGraphicFrameProperties2.Append(nonVisualDrawingProperties2); nonVisualGraphicFrameProperties2.Append(nonVisualGraphicFrameDrawingProperties2); Xdr.Transform transform2 = new Xdr.Transform(); A.Offset offset2 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents2 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform2.Append(offset2); transform2.Append(extents2); A.Graphic graphic2 = new A.Graphic(); A.GraphicData graphicData2 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" }; C.ChartReference chartReference2 = new C.ChartReference(){ Id = "rId2" }; chartReference2.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); chartReference2.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); graphicData2.Append(chartReference2); graphic2.Append(graphicData2); graphicFrame2.Append(nonVisualGraphicFrameProperties2); graphicFrame2.Append(transform2); graphicFrame2.Append(graphic2); Xdr.ClientData clientData2 = new Xdr.ClientData(); twoCellAnchor2.Append(fromMarker2); twoCellAnchor2.Append(toMarker2); twoCellAnchor2.Append(graphicFrame2); twoCellAnchor2.Append(clientData2); Xdr.TwoCellAnchor twoCellAnchor3 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell }; Xdr.FromMarker fromMarker3 = new Xdr.FromMarker(); Xdr.ColumnId columnId5 = new Xdr.ColumnId(); columnId5.Text = "10"; Xdr.ColumnOffset columnOffset5 = new Xdr.ColumnOffset(); columnOffset5.Text = "9525"; Xdr.RowId rowId5 = new Xdr.RowId(); rowId5.Text = "0"; Xdr.RowOffset rowOffset5 = new Xdr.RowOffset(); rowOffset5.Text = "171450"; fromMarker3.Append(columnId5); fromMarker3.Append(columnOffset5); fromMarker3.Append(rowId5); fromMarker3.Append(rowOffset5); Xdr.ToMarker toMarker3 = new Xdr.ToMarker(); Xdr.ColumnId columnId6 = new Xdr.ColumnId(); columnId6.Text = "13"; Xdr.ColumnOffset columnOffset6 = new Xdr.ColumnOffset(); columnOffset6.Text = "742950"; Xdr.RowId rowId6 = new Xdr.RowId(); rowId6.Text = "7"; Xdr.RowOffset rowOffset6 = new Xdr.RowOffset(); rowOffset6.Text = "28575"; toMarker3.Append(columnId6); toMarker3.Append(columnOffset6); toMarker3.Append(rowId6); toMarker3.Append(rowOffset6); AlternateContent alternateContent2 = new AlternateContent(); alternateContent2.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); alternateContent2.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main"); AlternateContentChoice alternateContentChoice2 = new AlternateContentChoice(){ Requires = "a15" }; Xdr.GraphicFrame graphicFrame3 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties3 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties3 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)4U, Name = "DeliveryDate 10" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties3 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties3.Append(nonVisualDrawingProperties3); nonVisualGraphicFrameProperties3.Append(nonVisualGraphicFrameDrawingProperties3); Xdr.Transform transform3 = new Xdr.Transform(); A.Offset offset3 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents3 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform3.Append(offset3); transform3.Append(extents3); A.Graphic graphic3 = new A.Graphic(); A.GraphicData graphicData3 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" }; Tsle.TimeSlicer timeSlicer1 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 10" }; timeSlicer1.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer"); graphicData3.Append(timeSlicer1); graphic3.Append(graphicData3); graphicFrame3.Append(nonVisualGraphicFrameProperties3); graphicFrame3.Append(transform3); graphicFrame3.Append(graphic3); alternateContentChoice2.Append(graphicFrame3); AlternateContentFallback alternateContentFallback1 = new AlternateContentFallback(); alternateContentFallback1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); alternateContentFallback1.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); Xdr.Shape shape1 = new Xdr.Shape(){ Macro = "", TextLink = "" }; Xdr.NonVisualShapeProperties nonVisualShapeProperties1 = new Xdr.NonVisualShapeProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties4 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" }; Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties1 = new Xdr.NonVisualShapeDrawingProperties(); A.ShapeLocks shapeLocks1 = new A.ShapeLocks(){ NoTextEdit = true }; nonVisualShapeDrawingProperties1.Append(shapeLocks1); nonVisualShapeProperties1.Append(nonVisualDrawingProperties4); nonVisualShapeProperties1.Append(nonVisualShapeDrawingProperties1); Xdr.ShapeProperties shapeProperties1 = new Xdr.ShapeProperties(); A.Transform2D transform2D1 = new A.Transform2D(); A.Offset offset4 = new A.Offset(){ X = 8610600L, Y = 171450L }; A.Extents extents4 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L }; transform2D1.Append(offset4); transform2D1.Append(extents4); A.PresetGeometry presetGeometry1 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle }; A.AdjustValueList adjustValueList1 = new A.AdjustValueList(); presetGeometry1.Append(adjustValueList1); A.SolidFill solidFill1 = new A.SolidFill(); A.PresetColor presetColor1 = new A.PresetColor(){ Val = A.PresetColorValues.White }; solidFill1.Append(presetColor1); A.Outline outline1 = new A.Outline(){ Width = 1 }; A.SolidFill solidFill2 = new A.SolidFill(); A.PresetColor presetColor2 = new A.PresetColor(){ Val = A.PresetColorValues.Green }; solidFill2.Append(presetColor2); outline1.Append(solidFill2); shapeProperties1.Append(transform2D1); shapeProperties1.Append(presetGeometry1); shapeProperties1.Append(solidFill1); shapeProperties1.Append(outline1); Xdr.TextBody textBody1 = new Xdr.TextBody(); A.BodyProperties bodyProperties1 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip }; A.ListStyle listStyle1 = new A.ListStyle(); A.Paragraph paragraph1 = new A.Paragraph(); A.Run run1 = new A.Run(); A.RunProperties runProperties1 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 }; A.Text text1 = new A.Text(); text1.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize."; run1.Append(runProperties1); run1.Append(text1); paragraph1.Append(run1); textBody1.Append(bodyProperties1); textBody1.Append(listStyle1); textBody1.Append(paragraph1); shape1.Append(nonVisualShapeProperties1); shape1.Append(shapeProperties1); shape1.Append(textBody1); alternateContentFallback1.Append(shape1); alternateContent2.Append(alternateContentChoice2); alternateContent2.Append(alternateContentFallback1); Xdr.ClientData clientData3 = new Xdr.ClientData(); twoCellAnchor3.Append(fromMarker3); twoCellAnchor3.Append(toMarker3); twoCellAnchor3.Append(alternateContent2); twoCellAnchor3.Append(clientData3); Xdr.TwoCellAnchor twoCellAnchor4 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell }; Xdr.FromMarker fromMarker4 = new Xdr.FromMarker(); Xdr.ColumnId columnId7 = new Xdr.ColumnId(); columnId7.Text = "10"; Xdr.ColumnOffset columnOffset7 = new Xdr.ColumnOffset(); columnOffset7.Text = "9525"; Xdr.RowId rowId7 = new Xdr.RowId(); rowId7.Text = "8"; Xdr.RowOffset rowOffset7 = new Xdr.RowOffset(); rowOffset7.Text = "57150"; fromMarker4.Append(columnId7); fromMarker4.Append(columnOffset7); fromMarker4.Append(rowId7); fromMarker4.Append(rowOffset7); Xdr.ToMarker toMarker4 = new Xdr.ToMarker(); Xdr.ColumnId columnId8 = new Xdr.ColumnId(); columnId8.Text = "13"; Xdr.ColumnOffset columnOffset8 = new Xdr.ColumnOffset(); columnOffset8.Text = "866775"; Xdr.RowId rowId8 = new Xdr.RowId(); rowId8.Text = "14"; Xdr.RowOffset rowOffset8 = new Xdr.RowOffset(); rowOffset8.Text = "85725"; toMarker4.Append(columnId8); toMarker4.Append(columnOffset8); toMarker4.Append(rowId8); toMarker4.Append(rowOffset8); AlternateContent alternateContent3 = new AlternateContent(); alternateContent3.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); alternateContent3.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main"); AlternateContentChoice alternateContentChoice3 = new AlternateContentChoice(){ Requires = "a15" }; Xdr.GraphicFrame graphicFrame4 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties4 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties5 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)5U, Name = "DeliveryDate 11" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties4 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties4.Append(nonVisualDrawingProperties5); nonVisualGraphicFrameProperties4.Append(nonVisualGraphicFrameDrawingProperties4); Xdr.Transform transform4 = new Xdr.Transform(); A.Offset offset5 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents5 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform4.Append(offset5); transform4.Append(extents5); A.Graphic graphic4 = new A.Graphic(); A.GraphicData graphicData4 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" }; Tsle.TimeSlicer timeSlicer2 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 11" }; timeSlicer2.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer"); graphicData4.Append(timeSlicer2); graphic4.Append(graphicData4); graphicFrame4.Append(nonVisualGraphicFrameProperties4); graphicFrame4.Append(transform4); graphicFrame4.Append(graphic4); alternateContentChoice3.Append(graphicFrame4); AlternateContentFallback alternateContentFallback2 = new AlternateContentFallback(); Xdr.Shape shape2 = new Xdr.Shape(){ Macro = "", TextLink = "" }; Xdr.NonVisualShapeProperties nonVisualShapeProperties2 = new Xdr.NonVisualShapeProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties6 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" }; Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties2 = new Xdr.NonVisualShapeDrawingProperties(); A.ShapeLocks shapeLocks2 = new A.ShapeLocks(){ NoTextEdit = true }; nonVisualShapeDrawingProperties2.Append(shapeLocks2); nonVisualShapeProperties2.Append(nonVisualDrawingProperties6); nonVisualShapeProperties2.Append(nonVisualShapeDrawingProperties2); Xdr.ShapeProperties shapeProperties2 = new Xdr.ShapeProperties(); A.Transform2D transform2D2 = new A.Transform2D(); A.Offset offset6 = new A.Offset(){ X = 10296525L, Y = 1428750L }; A.Extents extents6 = new A.Extents(){ Cx = 3829050L, Cy = 1057275L }; transform2D2.Append(offset6); transform2D2.Append(extents6); A.PresetGeometry presetGeometry2 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle }; A.AdjustValueList adjustValueList2 = new A.AdjustValueList(); presetGeometry2.Append(adjustValueList2); A.SolidFill solidFill3 = new A.SolidFill(); A.PresetColor presetColor3 = new A.PresetColor(){ Val = A.PresetColorValues.White }; solidFill3.Append(presetColor3); A.Outline outline2 = new A.Outline(){ Width = 1 }; A.SolidFill solidFill4 = new A.SolidFill(); A.PresetColor presetColor4 = new A.PresetColor(){ Val = A.PresetColorValues.Green }; solidFill4.Append(presetColor4); outline2.Append(solidFill4); shapeProperties2.Append(transform2D2); shapeProperties2.Append(presetGeometry2); shapeProperties2.Append(solidFill3); shapeProperties2.Append(outline2); Xdr.TextBody textBody2 = new Xdr.TextBody(); A.BodyProperties bodyProperties2 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip }; A.ListStyle listStyle2 = new A.ListStyle(); A.Paragraph paragraph2 = new A.Paragraph(); A.Run run2 = new A.Run(); A.RunProperties runProperties2 = new A.RunProperties(){ Language = "ja-JP", AlternativeLanguage = "en-US", FontSize = 1100 }; A.Text text2 = new A.Text(); text2.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize."; run2.Append(runProperties2); run2.Append(text2); paragraph2.Append(run2); textBody2.Append(bodyProperties2); textBody2.Append(listStyle2); textBody2.Append(paragraph2); shape2.Append(nonVisualShapeProperties2); shape2.Append(shapeProperties2); shape2.Append(textBody2); alternateContentFallback2.Append(shape2); alternateContent3.Append(alternateContentChoice3); alternateContent3.Append(alternateContentFallback2); Xdr.ClientData clientData4 = new Xdr.ClientData(); twoCellAnchor4.Append(fromMarker4); twoCellAnchor4.Append(toMarker4); twoCellAnchor4.Append(alternateContent3); twoCellAnchor4.Append(clientData4); worksheetDrawing1.Append(twoCellAnchor1); worksheetDrawing1.Append(twoCellAnchor2); worksheetDrawing1.Append(twoCellAnchor3); worksheetDrawing1.Append(twoCellAnchor4); drawingsPart1.WorksheetDrawing = worksheetDrawing1; }
// Generates content of drawingsPart4. private void GenerateDrawingsPart4Content(DrawingsPart drawingsPart4) { Xdr.WorksheetDrawing worksheetDrawing4 = new Xdr.WorksheetDrawing(); worksheetDrawing4.AddNamespaceDeclaration("xdr", "http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing"); worksheetDrawing4.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main"); Xdr.TwoCellAnchor twoCellAnchor13 = new Xdr.TwoCellAnchor(); Xdr.FromMarker fromMarker13 = new Xdr.FromMarker(); Xdr.ColumnId columnId25 = new Xdr.ColumnId(); columnId25.Text = "2"; Xdr.ColumnOffset columnOffset25 = new Xdr.ColumnOffset(); columnOffset25.Text = "185737"; Xdr.RowId rowId25 = new Xdr.RowId(); rowId25.Text = "0"; Xdr.RowOffset rowOffset25 = new Xdr.RowOffset(); rowOffset25.Text = "0"; fromMarker13.Append(columnId25); fromMarker13.Append(columnOffset25); fromMarker13.Append(rowId25); fromMarker13.Append(rowOffset25); Xdr.ToMarker toMarker13 = new Xdr.ToMarker(); Xdr.ColumnId columnId26 = new Xdr.ColumnId(); columnId26.Text = "9"; Xdr.ColumnOffset columnOffset26 = new Xdr.ColumnOffset(); columnOffset26.Text = "90487"; Xdr.RowId rowId26 = new Xdr.RowId(); rowId26.Text = "14"; Xdr.RowOffset rowOffset26 = new Xdr.RowOffset(); rowOffset26.Text = "76200"; toMarker13.Append(columnId26); toMarker13.Append(columnOffset26); toMarker13.Append(rowId26); toMarker13.Append(rowOffset26); Xdr.GraphicFrame graphicFrame13 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties13 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties19 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)2U, Name = "Chart 1" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties13 = new Xdr.NonVisualGraphicFrameDrawingProperties(); A.GraphicFrameLocks graphicFrameLocks5 = new A.GraphicFrameLocks(); nonVisualGraphicFrameDrawingProperties13.Append(graphicFrameLocks5); nonVisualGraphicFrameProperties13.Append(nonVisualDrawingProperties19); nonVisualGraphicFrameProperties13.Append(nonVisualGraphicFrameDrawingProperties13); Xdr.Transform transform13 = new Xdr.Transform(); A.Offset offset19 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents19 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform13.Append(offset19); transform13.Append(extents19); A.Graphic graphic13 = new A.Graphic(); A.GraphicData graphicData13 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" }; C.ChartReference chartReference7 = new C.ChartReference(){ Id = "rId1" }; chartReference7.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); chartReference7.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); graphicData13.Append(chartReference7); graphic13.Append(graphicData13); graphicFrame13.Append(nonVisualGraphicFrameProperties13); graphicFrame13.Append(transform13); graphicFrame13.Append(graphic13); Xdr.ClientData clientData13 = new Xdr.ClientData(); twoCellAnchor13.Append(fromMarker13); twoCellAnchor13.Append(toMarker13); twoCellAnchor13.Append(graphicFrame13); twoCellAnchor13.Append(clientData13); Xdr.TwoCellAnchor twoCellAnchor14 = new Xdr.TwoCellAnchor(); Xdr.FromMarker fromMarker14 = new Xdr.FromMarker(); Xdr.ColumnId columnId27 = new Xdr.ColumnId(); columnId27.Text = "2"; Xdr.ColumnOffset columnOffset27 = new Xdr.ColumnOffset(); columnOffset27.Text = "200025"; Xdr.RowId rowId27 = new Xdr.RowId(); rowId27.Text = "14"; Xdr.RowOffset rowOffset27 = new Xdr.RowOffset(); rowOffset27.Text = "147637"; fromMarker14.Append(columnId27); fromMarker14.Append(columnOffset27); fromMarker14.Append(rowId27); fromMarker14.Append(rowOffset27); Xdr.ToMarker toMarker14 = new Xdr.ToMarker(); Xdr.ColumnId columnId28 = new Xdr.ColumnId(); columnId28.Text = "7"; Xdr.ColumnOffset columnOffset28 = new Xdr.ColumnOffset(); columnOffset28.Text = "476250"; Xdr.RowId rowId28 = new Xdr.RowId(); rowId28.Text = "29"; Xdr.RowOffset rowOffset28 = new Xdr.RowOffset(); rowOffset28.Text = "33337"; toMarker14.Append(columnId28); toMarker14.Append(columnOffset28); toMarker14.Append(rowId28); toMarker14.Append(rowOffset28); Xdr.GraphicFrame graphicFrame14 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties14 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties20 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)3U, Name = "グラフ 2" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties14 = new Xdr.NonVisualGraphicFrameDrawingProperties(); A.GraphicFrameLocks graphicFrameLocks6 = new A.GraphicFrameLocks(); nonVisualGraphicFrameDrawingProperties14.Append(graphicFrameLocks6); nonVisualGraphicFrameProperties14.Append(nonVisualDrawingProperties20); nonVisualGraphicFrameProperties14.Append(nonVisualGraphicFrameDrawingProperties14); Xdr.Transform transform14 = new Xdr.Transform(); A.Offset offset20 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents20 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform14.Append(offset20); transform14.Append(extents20); A.Graphic graphic14 = new A.Graphic(); A.GraphicData graphicData14 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" }; C.ChartReference chartReference8 = new C.ChartReference(){ Id = "rId2" }; chartReference8.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); chartReference8.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); graphicData14.Append(chartReference8); graphic14.Append(graphicData14); graphicFrame14.Append(nonVisualGraphicFrameProperties14); graphicFrame14.Append(transform14); graphicFrame14.Append(graphic14); Xdr.ClientData clientData14 = new Xdr.ClientData(); twoCellAnchor14.Append(fromMarker14); twoCellAnchor14.Append(toMarker14); twoCellAnchor14.Append(graphicFrame14); twoCellAnchor14.Append(clientData14); Xdr.TwoCellAnchor twoCellAnchor15 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell }; Xdr.FromMarker fromMarker15 = new Xdr.FromMarker(); Xdr.ColumnId columnId29 = new Xdr.ColumnId(); columnId29.Text = "10"; Xdr.ColumnOffset columnOffset29 = new Xdr.ColumnOffset(); columnOffset29.Text = "19050"; Xdr.RowId rowId29 = new Xdr.RowId(); rowId29.Text = "1"; Xdr.RowOffset rowOffset29 = new Xdr.RowOffset(); rowOffset29.Text = "19050"; fromMarker15.Append(columnId29); fromMarker15.Append(columnOffset29); fromMarker15.Append(rowId29); fromMarker15.Append(rowOffset29); Xdr.ToMarker toMarker15 = new Xdr.ToMarker(); Xdr.ColumnId columnId30 = new Xdr.ColumnId(); columnId30.Text = "13"; Xdr.ColumnOffset columnOffset30 = new Xdr.ColumnOffset(); columnOffset30.Text = "752475"; Xdr.RowId rowId30 = new Xdr.RowId(); rowId30.Text = "7"; Xdr.RowOffset rowOffset30 = new Xdr.RowOffset(); rowOffset30.Text = "66675"; toMarker15.Append(columnId30); toMarker15.Append(columnOffset30); toMarker15.Append(rowId30); toMarker15.Append(rowOffset30); AlternateContent alternateContent14 = new AlternateContent(); alternateContent14.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); alternateContent14.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main"); AlternateContentChoice alternateContentChoice14 = new AlternateContentChoice(){ Requires = "a15" }; Xdr.GraphicFrame graphicFrame15 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties15 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties21 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)4U, Name = "DeliveryDate 6" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties15 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties15.Append(nonVisualDrawingProperties21); nonVisualGraphicFrameProperties15.Append(nonVisualGraphicFrameDrawingProperties15); Xdr.Transform transform15 = new Xdr.Transform(); A.Offset offset21 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents21 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform15.Append(offset21); transform15.Append(extents21); A.Graphic graphic15 = new A.Graphic(); A.GraphicData graphicData15 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" }; Tsle.TimeSlicer timeSlicer7 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 6" }; timeSlicer7.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer"); graphicData15.Append(timeSlicer7); graphic15.Append(graphicData15); graphicFrame15.Append(nonVisualGraphicFrameProperties15); graphicFrame15.Append(transform15); graphicFrame15.Append(graphic15); alternateContentChoice14.Append(graphicFrame15); AlternateContentFallback alternateContentFallback13 = new AlternateContentFallback(); alternateContentFallback13.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); alternateContentFallback13.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); Xdr.Shape shape7 = new Xdr.Shape(){ Macro = "", TextLink = "" }; Xdr.NonVisualShapeProperties nonVisualShapeProperties7 = new Xdr.NonVisualShapeProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties22 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" }; Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties7 = new Xdr.NonVisualShapeDrawingProperties(); A.ShapeLocks shapeLocks7 = new A.ShapeLocks(){ NoTextEdit = true }; nonVisualShapeDrawingProperties7.Append(shapeLocks7); nonVisualShapeProperties7.Append(nonVisualDrawingProperties22); nonVisualShapeProperties7.Append(nonVisualShapeDrawingProperties7); Xdr.ShapeProperties shapeProperties22 = new Xdr.ShapeProperties(); A.Transform2D transform2D7 = new A.Transform2D(); A.Offset offset22 = new A.Offset(){ X = 8620125L, Y = 209550L }; A.Extents extents22 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L }; transform2D7.Append(offset22); transform2D7.Append(extents22); A.PresetGeometry presetGeometry7 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle }; A.AdjustValueList adjustValueList7 = new A.AdjustValueList(); presetGeometry7.Append(adjustValueList7); A.SolidFill solidFill40 = new A.SolidFill(); A.PresetColor presetColor13 = new A.PresetColor(){ Val = A.PresetColorValues.White }; solidFill40.Append(presetColor13); A.Outline outline32 = new A.Outline(){ Width = 1 }; A.SolidFill solidFill41 = new A.SolidFill(); A.PresetColor presetColor14 = new A.PresetColor(){ Val = A.PresetColorValues.Green }; solidFill41.Append(presetColor14); outline32.Append(solidFill41); shapeProperties22.Append(transform2D7); shapeProperties22.Append(presetGeometry7); shapeProperties22.Append(solidFill40); shapeProperties22.Append(outline32); Xdr.TextBody textBody7 = new Xdr.TextBody(); A.BodyProperties bodyProperties15 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip }; A.ListStyle listStyle15 = new A.ListStyle(); A.Paragraph paragraph15 = new A.Paragraph(); A.Run run7 = new A.Run(); A.RunProperties runProperties7 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 }; A.Text text45 = new A.Text(); text45.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize."; run7.Append(runProperties7); run7.Append(text45); paragraph15.Append(run7); textBody7.Append(bodyProperties15); textBody7.Append(listStyle15); textBody7.Append(paragraph15); shape7.Append(nonVisualShapeProperties7); shape7.Append(shapeProperties22); shape7.Append(textBody7); alternateContentFallback13.Append(shape7); alternateContent14.Append(alternateContentChoice14); alternateContent14.Append(alternateContentFallback13); Xdr.ClientData clientData15 = new Xdr.ClientData(); twoCellAnchor15.Append(fromMarker15); twoCellAnchor15.Append(toMarker15); twoCellAnchor15.Append(alternateContent14); twoCellAnchor15.Append(clientData15); Xdr.TwoCellAnchor twoCellAnchor16 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell }; Xdr.FromMarker fromMarker16 = new Xdr.FromMarker(); Xdr.ColumnId columnId31 = new Xdr.ColumnId(); columnId31.Text = "10"; Xdr.ColumnOffset columnOffset31 = new Xdr.ColumnOffset(); columnOffset31.Text = "28575"; Xdr.RowId rowId31 = new Xdr.RowId(); rowId31.Text = "9"; Xdr.RowOffset rowOffset31 = new Xdr.RowOffset(); rowOffset31.Text = "19050"; fromMarker16.Append(columnId31); fromMarker16.Append(columnOffset31); fromMarker16.Append(rowId31); fromMarker16.Append(rowOffset31); Xdr.ToMarker toMarker16 = new Xdr.ToMarker(); Xdr.ColumnId columnId32 = new Xdr.ColumnId(); columnId32.Text = "13"; Xdr.ColumnOffset columnOffset32 = new Xdr.ColumnOffset(); columnOffset32.Text = "762000"; Xdr.RowId rowId32 = new Xdr.RowId(); rowId32.Text = "15"; Xdr.RowOffset rowOffset32 = new Xdr.RowOffset(); rowOffset32.Text = "66675"; toMarker16.Append(columnId32); toMarker16.Append(columnOffset32); toMarker16.Append(rowId32); toMarker16.Append(rowOffset32); AlternateContent alternateContent15 = new AlternateContent(); alternateContent15.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); alternateContent15.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main"); AlternateContentChoice alternateContentChoice15 = new AlternateContentChoice(){ Requires = "a15" }; Xdr.GraphicFrame graphicFrame16 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties16 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties23 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)5U, Name = "DeliveryDate 7" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties16 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties16.Append(nonVisualDrawingProperties23); nonVisualGraphicFrameProperties16.Append(nonVisualGraphicFrameDrawingProperties16); Xdr.Transform transform16 = new Xdr.Transform(); A.Offset offset23 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents23 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform16.Append(offset23); transform16.Append(extents23); A.Graphic graphic16 = new A.Graphic(); A.GraphicData graphicData16 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" }; Tsle.TimeSlicer timeSlicer8 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 7" }; timeSlicer8.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer"); graphicData16.Append(timeSlicer8); graphic16.Append(graphicData16); graphicFrame16.Append(nonVisualGraphicFrameProperties16); graphicFrame16.Append(transform16); graphicFrame16.Append(graphic16); alternateContentChoice15.Append(graphicFrame16); AlternateContentFallback alternateContentFallback14 = new AlternateContentFallback(); alternateContentFallback14.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); alternateContentFallback14.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); Xdr.Shape shape8 = new Xdr.Shape(){ Macro = "", TextLink = "" }; Xdr.NonVisualShapeProperties nonVisualShapeProperties8 = new Xdr.NonVisualShapeProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties24 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" }; Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties8 = new Xdr.NonVisualShapeDrawingProperties(); A.ShapeLocks shapeLocks8 = new A.ShapeLocks(){ NoTextEdit = true }; nonVisualShapeDrawingProperties8.Append(shapeLocks8); nonVisualShapeProperties8.Append(nonVisualDrawingProperties24); nonVisualShapeProperties8.Append(nonVisualShapeDrawingProperties8); Xdr.ShapeProperties shapeProperties23 = new Xdr.ShapeProperties(); A.Transform2D transform2D8 = new A.Transform2D(); A.Offset offset24 = new A.Offset(){ X = 8629650L, Y = 1733550L }; A.Extents extents24 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L }; transform2D8.Append(offset24); transform2D8.Append(extents24); A.PresetGeometry presetGeometry8 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle }; A.AdjustValueList adjustValueList8 = new A.AdjustValueList(); presetGeometry8.Append(adjustValueList8); A.SolidFill solidFill42 = new A.SolidFill(); A.PresetColor presetColor15 = new A.PresetColor(){ Val = A.PresetColorValues.White }; solidFill42.Append(presetColor15); A.Outline outline33 = new A.Outline(){ Width = 1 }; A.SolidFill solidFill43 = new A.SolidFill(); A.PresetColor presetColor16 = new A.PresetColor(){ Val = A.PresetColorValues.Green }; solidFill43.Append(presetColor16); outline33.Append(solidFill43); shapeProperties23.Append(transform2D8); shapeProperties23.Append(presetGeometry8); shapeProperties23.Append(solidFill42); shapeProperties23.Append(outline33); Xdr.TextBody textBody8 = new Xdr.TextBody(); A.BodyProperties bodyProperties16 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip }; A.ListStyle listStyle16 = new A.ListStyle(); A.Paragraph paragraph16 = new A.Paragraph(); A.Run run8 = new A.Run(); A.RunProperties runProperties8 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 }; A.Text text46 = new A.Text(); text46.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize."; run8.Append(runProperties8); run8.Append(text46); paragraph16.Append(run8); textBody8.Append(bodyProperties16); textBody8.Append(listStyle16); textBody8.Append(paragraph16); shape8.Append(nonVisualShapeProperties8); shape8.Append(shapeProperties23); shape8.Append(textBody8); alternateContentFallback14.Append(shape8); alternateContent15.Append(alternateContentChoice15); alternateContent15.Append(alternateContentFallback14); Xdr.ClientData clientData16 = new Xdr.ClientData(); twoCellAnchor16.Append(fromMarker16); twoCellAnchor16.Append(toMarker16); twoCellAnchor16.Append(alternateContent15); twoCellAnchor16.Append(clientData16); worksheetDrawing4.Append(twoCellAnchor13); worksheetDrawing4.Append(twoCellAnchor14); worksheetDrawing4.Append(twoCellAnchor15); worksheetDrawing4.Append(twoCellAnchor16); drawingsPart4.WorksheetDrawing = worksheetDrawing4; }
// Generates content of drawingsPart2. private void GenerateDrawingsPart2Content(DrawingsPart drawingsPart2) { Xdr.WorksheetDrawing worksheetDrawing2 = new Xdr.WorksheetDrawing(); worksheetDrawing2.AddNamespaceDeclaration("xdr", "http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing"); worksheetDrawing2.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main"); Xdr.TwoCellAnchor twoCellAnchor5 = new Xdr.TwoCellAnchor(); Xdr.FromMarker fromMarker5 = new Xdr.FromMarker(); Xdr.ColumnId columnId9 = new Xdr.ColumnId(); columnId9.Text = "3"; Xdr.ColumnOffset columnOffset9 = new Xdr.ColumnOffset(); columnOffset9.Text = "257175"; Xdr.RowId rowId9 = new Xdr.RowId(); rowId9.Text = "0"; Xdr.RowOffset rowOffset9 = new Xdr.RowOffset(); rowOffset9.Text = "23812"; fromMarker5.Append(columnId9); fromMarker5.Append(columnOffset9); fromMarker5.Append(rowId9); fromMarker5.Append(rowOffset9); Xdr.ToMarker toMarker5 = new Xdr.ToMarker(); Xdr.ColumnId columnId10 = new Xdr.ColumnId(); columnId10.Text = "10"; Xdr.ColumnOffset columnOffset10 = new Xdr.ColumnOffset(); columnOffset10.Text = "561975"; Xdr.RowId rowId10 = new Xdr.RowId(); rowId10.Text = "14"; Xdr.RowOffset rowOffset10 = new Xdr.RowOffset(); rowOffset10.Text = "100012"; toMarker5.Append(columnId10); toMarker5.Append(columnOffset10); toMarker5.Append(rowId10); toMarker5.Append(rowOffset10); Xdr.GraphicFrame graphicFrame5 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties5 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties7 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)2U, Name = "グラフ 1" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties5 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties5.Append(nonVisualDrawingProperties7); nonVisualGraphicFrameProperties5.Append(nonVisualGraphicFrameDrawingProperties5); Xdr.Transform transform5 = new Xdr.Transform(); A.Offset offset7 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents7 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform5.Append(offset7); transform5.Append(extents7); A.Graphic graphic5 = new A.Graphic(); A.GraphicData graphicData5 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" }; C.ChartReference chartReference3 = new C.ChartReference(){ Id = "rId1" }; chartReference3.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); chartReference3.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); graphicData5.Append(chartReference3); graphic5.Append(graphicData5); graphicFrame5.Append(nonVisualGraphicFrameProperties5); graphicFrame5.Append(transform5); graphicFrame5.Append(graphic5); Xdr.ClientData clientData5 = new Xdr.ClientData(); twoCellAnchor5.Append(fromMarker5); twoCellAnchor5.Append(toMarker5); twoCellAnchor5.Append(graphicFrame5); twoCellAnchor5.Append(clientData5); Xdr.TwoCellAnchor twoCellAnchor6 = new Xdr.TwoCellAnchor(); Xdr.FromMarker fromMarker6 = new Xdr.FromMarker(); Xdr.ColumnId columnId11 = new Xdr.ColumnId(); columnId11.Text = "3"; Xdr.ColumnOffset columnOffset11 = new Xdr.ColumnOffset(); columnOffset11.Text = "257175"; Xdr.RowId rowId11 = new Xdr.RowId(); rowId11.Text = "15"; Xdr.RowOffset rowOffset11 = new Xdr.RowOffset(); rowOffset11.Text = "80962"; fromMarker6.Append(columnId11); fromMarker6.Append(columnOffset11); fromMarker6.Append(rowId11); fromMarker6.Append(rowOffset11); Xdr.ToMarker toMarker6 = new Xdr.ToMarker(); Xdr.ColumnId columnId12 = new Xdr.ColumnId(); columnId12.Text = "10"; Xdr.ColumnOffset columnOffset12 = new Xdr.ColumnOffset(); columnOffset12.Text = "561975"; Xdr.RowId rowId12 = new Xdr.RowId(); rowId12.Text = "29"; Xdr.RowOffset rowOffset12 = new Xdr.RowOffset(); rowOffset12.Text = "157162"; toMarker6.Append(columnId12); toMarker6.Append(columnOffset12); toMarker6.Append(rowId12); toMarker6.Append(rowOffset12); Xdr.GraphicFrame graphicFrame6 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties6 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties8 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)3U, Name = "グラフ 2" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties6 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties6.Append(nonVisualDrawingProperties8); nonVisualGraphicFrameProperties6.Append(nonVisualGraphicFrameDrawingProperties6); Xdr.Transform transform6 = new Xdr.Transform(); A.Offset offset8 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents8 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform6.Append(offset8); transform6.Append(extents8); A.Graphic graphic6 = new A.Graphic(); A.GraphicData graphicData6 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" }; C.ChartReference chartReference4 = new C.ChartReference(){ Id = "rId2" }; chartReference4.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); chartReference4.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); graphicData6.Append(chartReference4); graphic6.Append(graphicData6); graphicFrame6.Append(nonVisualGraphicFrameProperties6); graphicFrame6.Append(transform6); graphicFrame6.Append(graphic6); Xdr.ClientData clientData6 = new Xdr.ClientData(); twoCellAnchor6.Append(fromMarker6); twoCellAnchor6.Append(toMarker6); twoCellAnchor6.Append(graphicFrame6); twoCellAnchor6.Append(clientData6); Xdr.TwoCellAnchor twoCellAnchor7 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell }; Xdr.FromMarker fromMarker7 = new Xdr.FromMarker(); Xdr.ColumnId columnId13 = new Xdr.ColumnId(); columnId13.Text = "12"; Xdr.ColumnOffset columnOffset13 = new Xdr.ColumnOffset(); columnOffset13.Text = "19050"; Xdr.RowId rowId13 = new Xdr.RowId(); rowId13.Text = "0"; Xdr.RowOffset rowOffset13 = new Xdr.RowOffset(); rowOffset13.Text = "19050"; fromMarker7.Append(columnId13); fromMarker7.Append(columnOffset13); fromMarker7.Append(rowId13); fromMarker7.Append(rowOffset13); Xdr.ToMarker toMarker7 = new Xdr.ToMarker(); Xdr.ColumnId columnId14 = new Xdr.ColumnId(); columnId14.Text = "17"; Xdr.ColumnOffset columnOffset14 = new Xdr.ColumnOffset(); columnOffset14.Text = "304800"; Xdr.RowId rowId14 = new Xdr.RowId(); rowId14.Text = "6"; Xdr.RowOffset rowOffset14 = new Xdr.RowOffset(); rowOffset14.Text = "66675"; toMarker7.Append(columnId14); toMarker7.Append(columnOffset14); toMarker7.Append(rowId14); toMarker7.Append(rowOffset14); AlternateContent alternateContent6 = new AlternateContent(); alternateContent6.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); alternateContent6.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main"); AlternateContentChoice alternateContentChoice6 = new AlternateContentChoice(){ Requires = "a15" }; Xdr.GraphicFrame graphicFrame7 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties7 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties9 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)4U, Name = "Date" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties7 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties7.Append(nonVisualDrawingProperties9); nonVisualGraphicFrameProperties7.Append(nonVisualGraphicFrameDrawingProperties7); Xdr.Transform transform7 = new Xdr.Transform(); A.Offset offset9 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents9 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform7.Append(offset9); transform7.Append(extents9); A.Graphic graphic7 = new A.Graphic(); A.GraphicData graphicData7 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" }; Tsle.TimeSlicer timeSlicer3 = new Tsle.TimeSlicer(){ Name = "Date" }; timeSlicer3.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer"); graphicData7.Append(timeSlicer3); graphic7.Append(graphicData7); graphicFrame7.Append(nonVisualGraphicFrameProperties7); graphicFrame7.Append(transform7); graphicFrame7.Append(graphic7); alternateContentChoice6.Append(graphicFrame7); AlternateContentFallback alternateContentFallback5 = new AlternateContentFallback(); alternateContentFallback5.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); alternateContentFallback5.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); Xdr.Shape shape3 = new Xdr.Shape(){ Macro = "", TextLink = "" }; Xdr.NonVisualShapeProperties nonVisualShapeProperties3 = new Xdr.NonVisualShapeProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties10 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" }; Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties3 = new Xdr.NonVisualShapeDrawingProperties(); A.ShapeLocks shapeLocks3 = new A.ShapeLocks(){ NoTextEdit = true }; nonVisualShapeDrawingProperties3.Append(shapeLocks3); nonVisualShapeProperties3.Append(nonVisualDrawingProperties10); nonVisualShapeProperties3.Append(nonVisualShapeDrawingProperties3); Xdr.ShapeProperties shapeProperties11 = new Xdr.ShapeProperties(); A.Transform2D transform2D3 = new A.Transform2D(); A.Offset offset10 = new A.Offset(){ X = 7820025L, Y = 19050L }; A.Extents extents10 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L }; transform2D3.Append(offset10); transform2D3.Append(extents10); A.PresetGeometry presetGeometry3 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle }; A.AdjustValueList adjustValueList3 = new A.AdjustValueList(); presetGeometry3.Append(adjustValueList3); A.SolidFill solidFill19 = new A.SolidFill(); A.PresetColor presetColor5 = new A.PresetColor(){ Val = A.PresetColorValues.White }; solidFill19.Append(presetColor5); A.Outline outline16 = new A.Outline(){ Width = 1 }; A.SolidFill solidFill20 = new A.SolidFill(); A.PresetColor presetColor6 = new A.PresetColor(){ Val = A.PresetColorValues.Green }; solidFill20.Append(presetColor6); outline16.Append(solidFill20); shapeProperties11.Append(transform2D3); shapeProperties11.Append(presetGeometry3); shapeProperties11.Append(solidFill19); shapeProperties11.Append(outline16); Xdr.TextBody textBody3 = new Xdr.TextBody(); A.BodyProperties bodyProperties7 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip }; A.ListStyle listStyle7 = new A.ListStyle(); A.Paragraph paragraph7 = new A.Paragraph(); A.Run run3 = new A.Run(); A.RunProperties runProperties3 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 }; A.Text text3 = new A.Text(); text3.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize."; run3.Append(runProperties3); run3.Append(text3); paragraph7.Append(run3); textBody3.Append(bodyProperties7); textBody3.Append(listStyle7); textBody3.Append(paragraph7); shape3.Append(nonVisualShapeProperties3); shape3.Append(shapeProperties11); shape3.Append(textBody3); alternateContentFallback5.Append(shape3); alternateContent6.Append(alternateContentChoice6); alternateContent6.Append(alternateContentFallback5); Xdr.ClientData clientData7 = new Xdr.ClientData(); twoCellAnchor7.Append(fromMarker7); twoCellAnchor7.Append(toMarker7); twoCellAnchor7.Append(alternateContent6); twoCellAnchor7.Append(clientData7); Xdr.TwoCellAnchor twoCellAnchor8 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell }; Xdr.FromMarker fromMarker8 = new Xdr.FromMarker(); Xdr.ColumnId columnId15 = new Xdr.ColumnId(); columnId15.Text = "12"; Xdr.ColumnOffset columnOffset15 = new Xdr.ColumnOffset(); columnOffset15.Text = "9525"; Xdr.RowId rowId15 = new Xdr.RowId(); rowId15.Text = "7"; Xdr.RowOffset rowOffset15 = new Xdr.RowOffset(); rowOffset15.Text = "19050"; fromMarker8.Append(columnId15); fromMarker8.Append(columnOffset15); fromMarker8.Append(rowId15); fromMarker8.Append(rowOffset15); Xdr.ToMarker toMarker8 = new Xdr.ToMarker(); Xdr.ColumnId columnId16 = new Xdr.ColumnId(); columnId16.Text = "17"; Xdr.ColumnOffset columnOffset16 = new Xdr.ColumnOffset(); columnOffset16.Text = "371475"; Xdr.RowId rowId16 = new Xdr.RowId(); rowId16.Text = "13"; Xdr.RowOffset rowOffset16 = new Xdr.RowOffset(); rowOffset16.Text = "66675"; toMarker8.Append(columnId16); toMarker8.Append(columnOffset16); toMarker8.Append(rowId16); toMarker8.Append(rowOffset16); AlternateContent alternateContent7 = new AlternateContent(); alternateContent7.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); alternateContent7.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main"); AlternateContentChoice alternateContentChoice7 = new AlternateContentChoice(){ Requires = "a15" }; Xdr.GraphicFrame graphicFrame8 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties8 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties11 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)7U, Name = "Date 1" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties8 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties8.Append(nonVisualDrawingProperties11); nonVisualGraphicFrameProperties8.Append(nonVisualGraphicFrameDrawingProperties8); Xdr.Transform transform8 = new Xdr.Transform(); A.Offset offset11 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents11 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform8.Append(offset11); transform8.Append(extents11); A.Graphic graphic8 = new A.Graphic(); A.GraphicData graphicData8 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" }; Tsle.TimeSlicer timeSlicer4 = new Tsle.TimeSlicer(){ Name = "Date 1" }; timeSlicer4.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer"); graphicData8.Append(timeSlicer4); graphic8.Append(graphicData8); graphicFrame8.Append(nonVisualGraphicFrameProperties8); graphicFrame8.Append(transform8); graphicFrame8.Append(graphic8); alternateContentChoice7.Append(graphicFrame8); AlternateContentFallback alternateContentFallback6 = new AlternateContentFallback(); Xdr.Shape shape4 = new Xdr.Shape(){ Macro = "", TextLink = "" }; Xdr.NonVisualShapeProperties nonVisualShapeProperties4 = new Xdr.NonVisualShapeProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties12 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" }; Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties4 = new Xdr.NonVisualShapeDrawingProperties(); A.ShapeLocks shapeLocks4 = new A.ShapeLocks(){ NoTextEdit = true }; nonVisualShapeDrawingProperties4.Append(shapeLocks4); nonVisualShapeProperties4.Append(nonVisualDrawingProperties12); nonVisualShapeProperties4.Append(nonVisualShapeDrawingProperties4); Xdr.ShapeProperties shapeProperties12 = new Xdr.ShapeProperties(); A.Transform2D transform2D4 = new A.Transform2D(); A.Offset offset12 = new A.Offset(){ X = 9020175L, Y = 1219200L }; A.Extents extents12 = new A.Extents(){ Cx = 3790950L, Cy = 1076325L }; transform2D4.Append(offset12); transform2D4.Append(extents12); A.PresetGeometry presetGeometry4 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle }; A.AdjustValueList adjustValueList4 = new A.AdjustValueList(); presetGeometry4.Append(adjustValueList4); A.SolidFill solidFill21 = new A.SolidFill(); A.PresetColor presetColor7 = new A.PresetColor(){ Val = A.PresetColorValues.White }; solidFill21.Append(presetColor7); A.Outline outline17 = new A.Outline(){ Width = 1 }; A.SolidFill solidFill22 = new A.SolidFill(); A.PresetColor presetColor8 = new A.PresetColor(){ Val = A.PresetColorValues.Green }; solidFill22.Append(presetColor8); outline17.Append(solidFill22); shapeProperties12.Append(transform2D4); shapeProperties12.Append(presetGeometry4); shapeProperties12.Append(solidFill21); shapeProperties12.Append(outline17); Xdr.TextBody textBody4 = new Xdr.TextBody(); A.BodyProperties bodyProperties8 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip }; A.ListStyle listStyle8 = new A.ListStyle(); A.Paragraph paragraph8 = new A.Paragraph(); A.Run run4 = new A.Run(); A.RunProperties runProperties4 = new A.RunProperties(){ Language = "ja-JP", AlternativeLanguage = "en-US", FontSize = 1100 }; A.Text text4 = new A.Text(); text4.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize."; run4.Append(runProperties4); run4.Append(text4); paragraph8.Append(run4); textBody4.Append(bodyProperties8); textBody4.Append(listStyle8); textBody4.Append(paragraph8); shape4.Append(nonVisualShapeProperties4); shape4.Append(shapeProperties12); shape4.Append(textBody4); alternateContentFallback6.Append(shape4); alternateContent7.Append(alternateContentChoice7); alternateContent7.Append(alternateContentFallback6); Xdr.ClientData clientData8 = new Xdr.ClientData(); twoCellAnchor8.Append(fromMarker8); twoCellAnchor8.Append(toMarker8); twoCellAnchor8.Append(alternateContent7); twoCellAnchor8.Append(clientData8); worksheetDrawing2.Append(twoCellAnchor5); worksheetDrawing2.Append(twoCellAnchor6); worksheetDrawing2.Append(twoCellAnchor7); worksheetDrawing2.Append(twoCellAnchor8); drawingsPart2.WorksheetDrawing = worksheetDrawing2; }
// Generates content of drawingsPart3. private void GenerateDrawingsPart3Content(DrawingsPart drawingsPart3) { Xdr.WorksheetDrawing worksheetDrawing3 = new Xdr.WorksheetDrawing(); worksheetDrawing3.AddNamespaceDeclaration("xdr", "http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing"); worksheetDrawing3.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main"); Xdr.TwoCellAnchor twoCellAnchor9 = new Xdr.TwoCellAnchor(); Xdr.FromMarker fromMarker9 = new Xdr.FromMarker(); Xdr.ColumnId columnId17 = new Xdr.ColumnId(); columnId17.Text = "2"; Xdr.ColumnOffset columnOffset17 = new Xdr.ColumnOffset(); columnOffset17.Text = "185737"; Xdr.RowId rowId17 = new Xdr.RowId(); rowId17.Text = "0"; Xdr.RowOffset rowOffset17 = new Xdr.RowOffset(); rowOffset17.Text = "0"; fromMarker9.Append(columnId17); fromMarker9.Append(columnOffset17); fromMarker9.Append(rowId17); fromMarker9.Append(rowOffset17); Xdr.ToMarker toMarker9 = new Xdr.ToMarker(); Xdr.ColumnId columnId18 = new Xdr.ColumnId(); columnId18.Text = "9"; Xdr.ColumnOffset columnOffset18 = new Xdr.ColumnOffset(); columnOffset18.Text = "90487"; Xdr.RowId rowId18 = new Xdr.RowId(); rowId18.Text = "14"; Xdr.RowOffset rowOffset18 = new Xdr.RowOffset(); rowOffset18.Text = "76200"; toMarker9.Append(columnId18); toMarker9.Append(columnOffset18); toMarker9.Append(rowId18); toMarker9.Append(rowOffset18); Xdr.GraphicFrame graphicFrame9 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties9 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties13 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)2U, Name = "Chart 1" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties9 = new Xdr.NonVisualGraphicFrameDrawingProperties(); A.GraphicFrameLocks graphicFrameLocks3 = new A.GraphicFrameLocks(); nonVisualGraphicFrameDrawingProperties9.Append(graphicFrameLocks3); nonVisualGraphicFrameProperties9.Append(nonVisualDrawingProperties13); nonVisualGraphicFrameProperties9.Append(nonVisualGraphicFrameDrawingProperties9); Xdr.Transform transform9 = new Xdr.Transform(); A.Offset offset13 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents13 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform9.Append(offset13); transform9.Append(extents13); A.Graphic graphic9 = new A.Graphic(); A.GraphicData graphicData9 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" }; C.ChartReference chartReference5 = new C.ChartReference(){ Id = "rId1" }; chartReference5.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); chartReference5.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); graphicData9.Append(chartReference5); graphic9.Append(graphicData9); graphicFrame9.Append(nonVisualGraphicFrameProperties9); graphicFrame9.Append(transform9); graphicFrame9.Append(graphic9); Xdr.ClientData clientData9 = new Xdr.ClientData(); twoCellAnchor9.Append(fromMarker9); twoCellAnchor9.Append(toMarker9); twoCellAnchor9.Append(graphicFrame9); twoCellAnchor9.Append(clientData9); Xdr.TwoCellAnchor twoCellAnchor10 = new Xdr.TwoCellAnchor(); Xdr.FromMarker fromMarker10 = new Xdr.FromMarker(); Xdr.ColumnId columnId19 = new Xdr.ColumnId(); columnId19.Text = "2"; Xdr.ColumnOffset columnOffset19 = new Xdr.ColumnOffset(); columnOffset19.Text = "200025"; Xdr.RowId rowId19 = new Xdr.RowId(); rowId19.Text = "14"; Xdr.RowOffset rowOffset19 = new Xdr.RowOffset(); rowOffset19.Text = "147637"; fromMarker10.Append(columnId19); fromMarker10.Append(columnOffset19); fromMarker10.Append(rowId19); fromMarker10.Append(rowOffset19); Xdr.ToMarker toMarker10 = new Xdr.ToMarker(); Xdr.ColumnId columnId20 = new Xdr.ColumnId(); columnId20.Text = "7"; Xdr.ColumnOffset columnOffset20 = new Xdr.ColumnOffset(); columnOffset20.Text = "476250"; Xdr.RowId rowId20 = new Xdr.RowId(); rowId20.Text = "29"; Xdr.RowOffset rowOffset20 = new Xdr.RowOffset(); rowOffset20.Text = "33337"; toMarker10.Append(columnId20); toMarker10.Append(columnOffset20); toMarker10.Append(rowId20); toMarker10.Append(rowOffset20); Xdr.GraphicFrame graphicFrame10 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties10 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties14 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)3U, Name = "グラフ 2" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties10 = new Xdr.NonVisualGraphicFrameDrawingProperties(); A.GraphicFrameLocks graphicFrameLocks4 = new A.GraphicFrameLocks(); nonVisualGraphicFrameDrawingProperties10.Append(graphicFrameLocks4); nonVisualGraphicFrameProperties10.Append(nonVisualDrawingProperties14); nonVisualGraphicFrameProperties10.Append(nonVisualGraphicFrameDrawingProperties10); Xdr.Transform transform10 = new Xdr.Transform(); A.Offset offset14 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents14 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform10.Append(offset14); transform10.Append(extents14); A.Graphic graphic10 = new A.Graphic(); A.GraphicData graphicData10 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" }; C.ChartReference chartReference6 = new C.ChartReference(){ Id = "rId2" }; chartReference6.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); chartReference6.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); graphicData10.Append(chartReference6); graphic10.Append(graphicData10); graphicFrame10.Append(nonVisualGraphicFrameProperties10); graphicFrame10.Append(transform10); graphicFrame10.Append(graphic10); Xdr.ClientData clientData10 = new Xdr.ClientData(); twoCellAnchor10.Append(fromMarker10); twoCellAnchor10.Append(toMarker10); twoCellAnchor10.Append(graphicFrame10); twoCellAnchor10.Append(clientData10); Xdr.TwoCellAnchor twoCellAnchor11 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell }; Xdr.FromMarker fromMarker11 = new Xdr.FromMarker(); Xdr.ColumnId columnId21 = new Xdr.ColumnId(); columnId21.Text = "10"; Xdr.ColumnOffset columnOffset21 = new Xdr.ColumnOffset(); columnOffset21.Text = "28575"; Xdr.RowId rowId21 = new Xdr.RowId(); rowId21.Text = "1"; Xdr.RowOffset rowOffset21 = new Xdr.RowOffset(); rowOffset21.Text = "9525"; fromMarker11.Append(columnId21); fromMarker11.Append(columnOffset21); fromMarker11.Append(rowId21); fromMarker11.Append(rowOffset21); Xdr.ToMarker toMarker11 = new Xdr.ToMarker(); Xdr.ColumnId columnId22 = new Xdr.ColumnId(); columnId22.Text = "13"; Xdr.ColumnOffset columnOffset22 = new Xdr.ColumnOffset(); columnOffset22.Text = "762000"; Xdr.RowId rowId22 = new Xdr.RowId(); rowId22.Text = "7"; Xdr.RowOffset rowOffset22 = new Xdr.RowOffset(); rowOffset22.Text = "57150"; toMarker11.Append(columnId22); toMarker11.Append(columnOffset22); toMarker11.Append(rowId22); toMarker11.Append(rowOffset22); AlternateContent alternateContent10 = new AlternateContent(); alternateContent10.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); alternateContent10.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main"); AlternateContentChoice alternateContentChoice10 = new AlternateContentChoice(){ Requires = "a15" }; Xdr.GraphicFrame graphicFrame11 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties11 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties15 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)4U, Name = "DeliveryDate 8" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties11 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties11.Append(nonVisualDrawingProperties15); nonVisualGraphicFrameProperties11.Append(nonVisualGraphicFrameDrawingProperties11); Xdr.Transform transform11 = new Xdr.Transform(); A.Offset offset15 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents15 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform11.Append(offset15); transform11.Append(extents15); A.Graphic graphic11 = new A.Graphic(); A.GraphicData graphicData11 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" }; Tsle.TimeSlicer timeSlicer5 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 8" }; timeSlicer5.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer"); graphicData11.Append(timeSlicer5); graphic11.Append(graphicData11); graphicFrame11.Append(nonVisualGraphicFrameProperties11); graphicFrame11.Append(transform11); graphicFrame11.Append(graphic11); alternateContentChoice10.Append(graphicFrame11); AlternateContentFallback alternateContentFallback9 = new AlternateContentFallback(); alternateContentFallback9.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); alternateContentFallback9.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); Xdr.Shape shape5 = new Xdr.Shape(){ Macro = "", TextLink = "" }; Xdr.NonVisualShapeProperties nonVisualShapeProperties5 = new Xdr.NonVisualShapeProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties16 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" }; Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties5 = new Xdr.NonVisualShapeDrawingProperties(); A.ShapeLocks shapeLocks5 = new A.ShapeLocks(){ NoTextEdit = true }; nonVisualShapeDrawingProperties5.Append(shapeLocks5); nonVisualShapeProperties5.Append(nonVisualDrawingProperties16); nonVisualShapeProperties5.Append(nonVisualShapeDrawingProperties5); Xdr.ShapeProperties shapeProperties13 = new Xdr.ShapeProperties(); A.Transform2D transform2D5 = new A.Transform2D(); A.Offset offset16 = new A.Offset(){ X = 8629650L, Y = 200025L }; A.Extents extents16 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L }; transform2D5.Append(offset16); transform2D5.Append(extents16); A.PresetGeometry presetGeometry5 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle }; A.AdjustValueList adjustValueList5 = new A.AdjustValueList(); presetGeometry5.Append(adjustValueList5); A.SolidFill solidFill23 = new A.SolidFill(); A.PresetColor presetColor9 = new A.PresetColor(){ Val = A.PresetColorValues.White }; solidFill23.Append(presetColor9); A.Outline outline18 = new A.Outline(){ Width = 1 }; A.SolidFill solidFill24 = new A.SolidFill(); A.PresetColor presetColor10 = new A.PresetColor(){ Val = A.PresetColorValues.Green }; solidFill24.Append(presetColor10); outline18.Append(solidFill24); shapeProperties13.Append(transform2D5); shapeProperties13.Append(presetGeometry5); shapeProperties13.Append(solidFill23); shapeProperties13.Append(outline18); Xdr.TextBody textBody5 = new Xdr.TextBody(); A.BodyProperties bodyProperties9 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip }; A.ListStyle listStyle9 = new A.ListStyle(); A.Paragraph paragraph9 = new A.Paragraph(); A.Run run5 = new A.Run(); A.RunProperties runProperties5 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 }; A.Text text5 = new A.Text(); text5.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize."; run5.Append(runProperties5); run5.Append(text5); paragraph9.Append(run5); textBody5.Append(bodyProperties9); textBody5.Append(listStyle9); textBody5.Append(paragraph9); shape5.Append(nonVisualShapeProperties5); shape5.Append(shapeProperties13); shape5.Append(textBody5); alternateContentFallback9.Append(shape5); alternateContent10.Append(alternateContentChoice10); alternateContent10.Append(alternateContentFallback9); Xdr.ClientData clientData11 = new Xdr.ClientData(); twoCellAnchor11.Append(fromMarker11); twoCellAnchor11.Append(toMarker11); twoCellAnchor11.Append(alternateContent10); twoCellAnchor11.Append(clientData11); Xdr.TwoCellAnchor twoCellAnchor12 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell }; Xdr.FromMarker fromMarker12 = new Xdr.FromMarker(); Xdr.ColumnId columnId23 = new Xdr.ColumnId(); columnId23.Text = "10"; Xdr.ColumnOffset columnOffset23 = new Xdr.ColumnOffset(); columnOffset23.Text = "28575"; Xdr.RowId rowId23 = new Xdr.RowId(); rowId23.Text = "8"; Xdr.RowOffset rowOffset23 = new Xdr.RowOffset(); rowOffset23.Text = "114300"; fromMarker12.Append(columnId23); fromMarker12.Append(columnOffset23); fromMarker12.Append(rowId23); fromMarker12.Append(rowOffset23); Xdr.ToMarker toMarker12 = new Xdr.ToMarker(); Xdr.ColumnId columnId24 = new Xdr.ColumnId(); columnId24.Text = "13"; Xdr.ColumnOffset columnOffset24 = new Xdr.ColumnOffset(); columnOffset24.Text = "762000"; Xdr.RowId rowId24 = new Xdr.RowId(); rowId24.Text = "14"; Xdr.RowOffset rowOffset24 = new Xdr.RowOffset(); rowOffset24.Text = "161925"; toMarker12.Append(columnId24); toMarker12.Append(columnOffset24); toMarker12.Append(rowId24); toMarker12.Append(rowOffset24); AlternateContent alternateContent11 = new AlternateContent(); alternateContent11.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); alternateContent11.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main"); AlternateContentChoice alternateContentChoice11 = new AlternateContentChoice(){ Requires = "a15" }; Xdr.GraphicFrame graphicFrame12 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties12 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties17 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)5U, Name = "DeliveryDate 9" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties12 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties12.Append(nonVisualDrawingProperties17); nonVisualGraphicFrameProperties12.Append(nonVisualGraphicFrameDrawingProperties12); Xdr.Transform transform12 = new Xdr.Transform(); A.Offset offset17 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents17 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform12.Append(offset17); transform12.Append(extents17); A.Graphic graphic12 = new A.Graphic(); A.GraphicData graphicData12 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" }; Tsle.TimeSlicer timeSlicer6 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 9" }; timeSlicer6.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer"); graphicData12.Append(timeSlicer6); graphic12.Append(graphicData12); graphicFrame12.Append(nonVisualGraphicFrameProperties12); graphicFrame12.Append(transform12); graphicFrame12.Append(graphic12); alternateContentChoice11.Append(graphicFrame12); AlternateContentFallback alternateContentFallback10 = new AlternateContentFallback(); alternateContentFallback10.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); alternateContentFallback10.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); Xdr.Shape shape6 = new Xdr.Shape(){ Macro = "", TextLink = "" }; Xdr.NonVisualShapeProperties nonVisualShapeProperties6 = new Xdr.NonVisualShapeProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties18 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" }; Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties6 = new Xdr.NonVisualShapeDrawingProperties(); A.ShapeLocks shapeLocks6 = new A.ShapeLocks(){ NoTextEdit = true }; nonVisualShapeDrawingProperties6.Append(shapeLocks6); nonVisualShapeProperties6.Append(nonVisualDrawingProperties18); nonVisualShapeProperties6.Append(nonVisualShapeDrawingProperties6); Xdr.ShapeProperties shapeProperties14 = new Xdr.ShapeProperties(); A.Transform2D transform2D6 = new A.Transform2D(); A.Offset offset18 = new A.Offset(){ X = 8629650L, Y = 1638300L }; A.Extents extents18 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L }; transform2D6.Append(offset18); transform2D6.Append(extents18); A.PresetGeometry presetGeometry6 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle }; A.AdjustValueList adjustValueList6 = new A.AdjustValueList(); presetGeometry6.Append(adjustValueList6); A.SolidFill solidFill25 = new A.SolidFill(); A.PresetColor presetColor11 = new A.PresetColor(){ Val = A.PresetColorValues.White }; solidFill25.Append(presetColor11); A.Outline outline19 = new A.Outline(){ Width = 1 }; A.SolidFill solidFill26 = new A.SolidFill(); A.PresetColor presetColor12 = new A.PresetColor(){ Val = A.PresetColorValues.Green }; solidFill26.Append(presetColor12); outline19.Append(solidFill26); shapeProperties14.Append(transform2D6); shapeProperties14.Append(presetGeometry6); shapeProperties14.Append(solidFill25); shapeProperties14.Append(outline19); Xdr.TextBody textBody6 = new Xdr.TextBody(); A.BodyProperties bodyProperties10 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip }; A.ListStyle listStyle10 = new A.ListStyle(); A.Paragraph paragraph10 = new A.Paragraph(); A.Run run6 = new A.Run(); A.RunProperties runProperties6 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 }; A.Text text6 = new A.Text(); text6.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize."; run6.Append(runProperties6); run6.Append(text6); paragraph10.Append(run6); textBody6.Append(bodyProperties10); textBody6.Append(listStyle10); textBody6.Append(paragraph10); shape6.Append(nonVisualShapeProperties6); shape6.Append(shapeProperties14); shape6.Append(textBody6); alternateContentFallback10.Append(shape6); alternateContent11.Append(alternateContentChoice11); alternateContent11.Append(alternateContentFallback10); Xdr.ClientData clientData12 = new Xdr.ClientData(); twoCellAnchor12.Append(fromMarker12); twoCellAnchor12.Append(toMarker12); twoCellAnchor12.Append(alternateContent11); twoCellAnchor12.Append(clientData12); worksheetDrawing3.Append(twoCellAnchor9); worksheetDrawing3.Append(twoCellAnchor10); worksheetDrawing3.Append(twoCellAnchor11); worksheetDrawing3.Append(twoCellAnchor12); drawingsPart3.WorksheetDrawing = worksheetDrawing3; }
// Generates content of drawingsPart9. private void GenerateDrawingsPart9Content(DrawingsPart drawingsPart9) { Xdr.WorksheetDrawing worksheetDrawing9 = new Xdr.WorksheetDrawing(); worksheetDrawing9.AddNamespaceDeclaration("xdr", "http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing"); worksheetDrawing9.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main"); Xdr.TwoCellAnchor twoCellAnchor35 = new Xdr.TwoCellAnchor(); Xdr.FromMarker fromMarker35 = new Xdr.FromMarker(); Xdr.ColumnId columnId69 = new Xdr.ColumnId(); columnId69.Text = "2"; Xdr.ColumnOffset columnOffset69 = new Xdr.ColumnOffset(); columnOffset69.Text = "185737"; Xdr.RowId rowId69 = new Xdr.RowId(); rowId69.Text = "0"; Xdr.RowOffset rowOffset69 = new Xdr.RowOffset(); rowOffset69.Text = "0"; fromMarker35.Append(columnId69); fromMarker35.Append(columnOffset69); fromMarker35.Append(rowId69); fromMarker35.Append(rowOffset69); Xdr.ToMarker toMarker35 = new Xdr.ToMarker(); Xdr.ColumnId columnId70 = new Xdr.ColumnId(); columnId70.Text = "9"; Xdr.ColumnOffset columnOffset70 = new Xdr.ColumnOffset(); columnOffset70.Text = "90487"; Xdr.RowId rowId70 = new Xdr.RowId(); rowId70.Text = "14"; Xdr.RowOffset rowOffset70 = new Xdr.RowOffset(); rowOffset70.Text = "76200"; toMarker35.Append(columnId70); toMarker35.Append(columnOffset70); toMarker35.Append(rowId70); toMarker35.Append(rowOffset70); Xdr.GraphicFrame graphicFrame35 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties35 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties53 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)2U, Name = "Chart 1" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties35 = new Xdr.NonVisualGraphicFrameDrawingProperties(); A.GraphicFrameLocks graphicFrameLocks13 = new A.GraphicFrameLocks(); nonVisualGraphicFrameDrawingProperties35.Append(graphicFrameLocks13); nonVisualGraphicFrameProperties35.Append(nonVisualDrawingProperties53); nonVisualGraphicFrameProperties35.Append(nonVisualGraphicFrameDrawingProperties35); Xdr.Transform transform35 = new Xdr.Transform(); A.Offset offset53 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents53 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform35.Append(offset53); transform35.Append(extents53); A.Graphic graphic35 = new A.Graphic(); A.GraphicData graphicData35 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" }; C.ChartReference chartReference17 = new C.ChartReference(){ Id = "rId1" }; chartReference17.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); chartReference17.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); graphicData35.Append(chartReference17); graphic35.Append(graphicData35); graphicFrame35.Append(nonVisualGraphicFrameProperties35); graphicFrame35.Append(transform35); graphicFrame35.Append(graphic35); Xdr.ClientData clientData35 = new Xdr.ClientData(); twoCellAnchor35.Append(fromMarker35); twoCellAnchor35.Append(toMarker35); twoCellAnchor35.Append(graphicFrame35); twoCellAnchor35.Append(clientData35); Xdr.TwoCellAnchor twoCellAnchor36 = new Xdr.TwoCellAnchor(); Xdr.FromMarker fromMarker36 = new Xdr.FromMarker(); Xdr.ColumnId columnId71 = new Xdr.ColumnId(); columnId71.Text = "2"; Xdr.ColumnOffset columnOffset71 = new Xdr.ColumnOffset(); columnOffset71.Text = "200025"; Xdr.RowId rowId71 = new Xdr.RowId(); rowId71.Text = "14"; Xdr.RowOffset rowOffset71 = new Xdr.RowOffset(); rowOffset71.Text = "147637"; fromMarker36.Append(columnId71); fromMarker36.Append(columnOffset71); fromMarker36.Append(rowId71); fromMarker36.Append(rowOffset71); Xdr.ToMarker toMarker36 = new Xdr.ToMarker(); Xdr.ColumnId columnId72 = new Xdr.ColumnId(); columnId72.Text = "7"; Xdr.ColumnOffset columnOffset72 = new Xdr.ColumnOffset(); columnOffset72.Text = "476250"; Xdr.RowId rowId72 = new Xdr.RowId(); rowId72.Text = "29"; Xdr.RowOffset rowOffset72 = new Xdr.RowOffset(); rowOffset72.Text = "33337"; toMarker36.Append(columnId72); toMarker36.Append(columnOffset72); toMarker36.Append(rowId72); toMarker36.Append(rowOffset72); Xdr.GraphicFrame graphicFrame36 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties36 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties54 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)3U, Name = "グラフ 2" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties36 = new Xdr.NonVisualGraphicFrameDrawingProperties(); A.GraphicFrameLocks graphicFrameLocks14 = new A.GraphicFrameLocks(); nonVisualGraphicFrameDrawingProperties36.Append(graphicFrameLocks14); nonVisualGraphicFrameProperties36.Append(nonVisualDrawingProperties54); nonVisualGraphicFrameProperties36.Append(nonVisualGraphicFrameDrawingProperties36); Xdr.Transform transform36 = new Xdr.Transform(); A.Offset offset54 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents54 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform36.Append(offset54); transform36.Append(extents54); A.Graphic graphic36 = new A.Graphic(); A.GraphicData graphicData36 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" }; C.ChartReference chartReference18 = new C.ChartReference(){ Id = "rId2" }; chartReference18.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); chartReference18.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); graphicData36.Append(chartReference18); graphic36.Append(graphicData36); graphicFrame36.Append(nonVisualGraphicFrameProperties36); graphicFrame36.Append(transform36); graphicFrame36.Append(graphic36); Xdr.ClientData clientData36 = new Xdr.ClientData(); twoCellAnchor36.Append(fromMarker36); twoCellAnchor36.Append(toMarker36); twoCellAnchor36.Append(graphicFrame36); twoCellAnchor36.Append(clientData36); Xdr.TwoCellAnchor twoCellAnchor37 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell }; Xdr.FromMarker fromMarker37 = new Xdr.FromMarker(); Xdr.ColumnId columnId73 = new Xdr.ColumnId(); columnId73.Text = "9"; Xdr.ColumnOffset columnOffset73 = new Xdr.ColumnOffset(); columnOffset73.Text = "847725"; Xdr.RowId rowId73 = new Xdr.RowId(); rowId73.Text = "0"; Xdr.RowOffset rowOffset73 = new Xdr.RowOffset(); rowOffset73.Text = "161925"; fromMarker37.Append(columnId73); fromMarker37.Append(columnOffset73); fromMarker37.Append(rowId73); fromMarker37.Append(rowOffset73); Xdr.ToMarker toMarker37 = new Xdr.ToMarker(); Xdr.ColumnId columnId74 = new Xdr.ColumnId(); columnId74.Text = "13"; Xdr.ColumnOffset columnOffset74 = new Xdr.ColumnOffset(); columnOffset74.Text = "714375"; Xdr.RowId rowId74 = new Xdr.RowId(); rowId74.Text = "7"; Xdr.RowOffset rowOffset74 = new Xdr.RowOffset(); rowOffset74.Text = "19050"; toMarker37.Append(columnId74); toMarker37.Append(columnOffset74); toMarker37.Append(rowId74); toMarker37.Append(rowOffset74); AlternateContent alternateContent35 = new AlternateContent(); alternateContent35.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); alternateContent35.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main"); AlternateContentChoice alternateContentChoice35 = new AlternateContentChoice(){ Requires = "a15" }; Xdr.GraphicFrame graphicFrame37 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties37 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties55 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)4U, Name = "DeliveryDate 12" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties37 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties37.Append(nonVisualDrawingProperties55); nonVisualGraphicFrameProperties37.Append(nonVisualGraphicFrameDrawingProperties37); Xdr.Transform transform37 = new Xdr.Transform(); A.Offset offset55 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents55 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform37.Append(offset55); transform37.Append(extents55); A.Graphic graphic37 = new A.Graphic(); A.GraphicData graphicData37 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" }; Tsle.TimeSlicer timeSlicer19 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 12" }; timeSlicer19.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer"); graphicData37.Append(timeSlicer19); graphic37.Append(graphicData37); graphicFrame37.Append(nonVisualGraphicFrameProperties37); graphicFrame37.Append(transform37); graphicFrame37.Append(graphic37); alternateContentChoice35.Append(graphicFrame37); AlternateContentFallback alternateContentFallback34 = new AlternateContentFallback(); alternateContentFallback34.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); alternateContentFallback34.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); Xdr.Shape shape19 = new Xdr.Shape(){ Macro = "", TextLink = "" }; Xdr.NonVisualShapeProperties nonVisualShapeProperties19 = new Xdr.NonVisualShapeProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties56 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" }; Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties19 = new Xdr.NonVisualShapeDrawingProperties(); A.ShapeLocks shapeLocks19 = new A.ShapeLocks(){ NoTextEdit = true }; nonVisualShapeDrawingProperties19.Append(shapeLocks19); nonVisualShapeProperties19.Append(nonVisualDrawingProperties56); nonVisualShapeProperties19.Append(nonVisualShapeDrawingProperties19); Xdr.ShapeProperties shapeProperties70 = new Xdr.ShapeProperties(); A.Transform2D transform2D19 = new A.Transform2D(); A.Offset offset56 = new A.Offset(){ X = 8582025L, Y = 161925L }; A.Extents extents56 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L }; transform2D19.Append(offset56); transform2D19.Append(extents56); A.PresetGeometry presetGeometry19 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle }; A.AdjustValueList adjustValueList19 = new A.AdjustValueList(); presetGeometry19.Append(adjustValueList19); A.SolidFill solidFill135 = new A.SolidFill(); A.PresetColor presetColor37 = new A.PresetColor(){ Val = A.PresetColorValues.White }; solidFill135.Append(presetColor37); A.Outline outline108 = new A.Outline(){ Width = 1 }; A.SolidFill solidFill136 = new A.SolidFill(); A.PresetColor presetColor38 = new A.PresetColor(){ Val = A.PresetColorValues.Green }; solidFill136.Append(presetColor38); outline108.Append(solidFill136); shapeProperties70.Append(transform2D19); shapeProperties70.Append(presetGeometry19); shapeProperties70.Append(solidFill135); shapeProperties70.Append(outline108); Xdr.TextBody textBody19 = new Xdr.TextBody(); A.BodyProperties bodyProperties47 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip }; A.ListStyle listStyle47 = new A.ListStyle(); A.Paragraph paragraph47 = new A.Paragraph(); A.Run run19 = new A.Run(); A.RunProperties runProperties19 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 }; A.Text text57 = new A.Text(); text57.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize."; run19.Append(runProperties19); run19.Append(text57); paragraph47.Append(run19); textBody19.Append(bodyProperties47); textBody19.Append(listStyle47); textBody19.Append(paragraph47); shape19.Append(nonVisualShapeProperties19); shape19.Append(shapeProperties70); shape19.Append(textBody19); alternateContentFallback34.Append(shape19); alternateContent35.Append(alternateContentChoice35); alternateContent35.Append(alternateContentFallback34); Xdr.ClientData clientData37 = new Xdr.ClientData(); twoCellAnchor37.Append(fromMarker37); twoCellAnchor37.Append(toMarker37); twoCellAnchor37.Append(alternateContent35); twoCellAnchor37.Append(clientData37); Xdr.TwoCellAnchor twoCellAnchor38 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell }; Xdr.FromMarker fromMarker38 = new Xdr.FromMarker(); Xdr.ColumnId columnId75 = new Xdr.ColumnId(); columnId75.Text = "9"; Xdr.ColumnOffset columnOffset75 = new Xdr.ColumnOffset(); columnOffset75.Text = "847725"; Xdr.RowId rowId75 = new Xdr.RowId(); rowId75.Text = "8"; Xdr.RowOffset rowOffset75 = new Xdr.RowOffset(); rowOffset75.Text = "28575"; fromMarker38.Append(columnId75); fromMarker38.Append(columnOffset75); fromMarker38.Append(rowId75); fromMarker38.Append(rowOffset75); Xdr.ToMarker toMarker38 = new Xdr.ToMarker(); Xdr.ColumnId columnId76 = new Xdr.ColumnId(); columnId76.Text = "13"; Xdr.ColumnOffset columnOffset76 = new Xdr.ColumnOffset(); columnOffset76.Text = "590550"; Xdr.RowId rowId76 = new Xdr.RowId(); rowId76.Text = "14"; Xdr.RowOffset rowOffset76 = new Xdr.RowOffset(); rowOffset76.Text = "76200"; toMarker38.Append(columnId76); toMarker38.Append(columnOffset76); toMarker38.Append(rowId76); toMarker38.Append(rowOffset76); AlternateContent alternateContent36 = new AlternateContent(); alternateContent36.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); alternateContent36.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main"); AlternateContentChoice alternateContentChoice36 = new AlternateContentChoice(){ Requires = "a15" }; Xdr.GraphicFrame graphicFrame38 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties38 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties57 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)5U, Name = "DeliveryDate 13" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties38 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties38.Append(nonVisualDrawingProperties57); nonVisualGraphicFrameProperties38.Append(nonVisualGraphicFrameDrawingProperties38); Xdr.Transform transform38 = new Xdr.Transform(); A.Offset offset57 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents57 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform38.Append(offset57); transform38.Append(extents57); A.Graphic graphic38 = new A.Graphic(); A.GraphicData graphicData38 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" }; Tsle.TimeSlicer timeSlicer20 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 13" }; timeSlicer20.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer"); graphicData38.Append(timeSlicer20); graphic38.Append(graphicData38); graphicFrame38.Append(nonVisualGraphicFrameProperties38); graphicFrame38.Append(transform38); graphicFrame38.Append(graphic38); alternateContentChoice36.Append(graphicFrame38); AlternateContentFallback alternateContentFallback35 = new AlternateContentFallback(); Xdr.Shape shape20 = new Xdr.Shape(){ Macro = "", TextLink = "" }; Xdr.NonVisualShapeProperties nonVisualShapeProperties20 = new Xdr.NonVisualShapeProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties58 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" }; Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties20 = new Xdr.NonVisualShapeDrawingProperties(); A.ShapeLocks shapeLocks20 = new A.ShapeLocks(){ NoTextEdit = true }; nonVisualShapeDrawingProperties20.Append(shapeLocks20); nonVisualShapeProperties20.Append(nonVisualDrawingProperties58); nonVisualShapeProperties20.Append(nonVisualShapeDrawingProperties20); Xdr.ShapeProperties shapeProperties71 = new Xdr.ShapeProperties(); A.Transform2D transform2D20 = new A.Transform2D(); A.Offset offset58 = new A.Offset(){ X = 10144125L, Y = 1400175L }; A.Extents extents58 = new A.Extents(){ Cx = 3705225L, Cy = 1076325L }; transform2D20.Append(offset58); transform2D20.Append(extents58); A.PresetGeometry presetGeometry20 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle }; A.AdjustValueList adjustValueList20 = new A.AdjustValueList(); presetGeometry20.Append(adjustValueList20); A.SolidFill solidFill137 = new A.SolidFill(); A.PresetColor presetColor39 = new A.PresetColor(){ Val = A.PresetColorValues.White }; solidFill137.Append(presetColor39); A.Outline outline109 = new A.Outline(){ Width = 1 }; A.SolidFill solidFill138 = new A.SolidFill(); A.PresetColor presetColor40 = new A.PresetColor(){ Val = A.PresetColorValues.Green }; solidFill138.Append(presetColor40); outline109.Append(solidFill138); shapeProperties71.Append(transform2D20); shapeProperties71.Append(presetGeometry20); shapeProperties71.Append(solidFill137); shapeProperties71.Append(outline109); Xdr.TextBody textBody20 = new Xdr.TextBody(); A.BodyProperties bodyProperties48 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip }; A.ListStyle listStyle48 = new A.ListStyle(); A.Paragraph paragraph48 = new A.Paragraph(); A.Run run20 = new A.Run(); A.RunProperties runProperties20 = new A.RunProperties(){ Language = "ja-JP", AlternativeLanguage = "en-US", FontSize = 1100 }; A.Text text58 = new A.Text(); text58.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize."; run20.Append(runProperties20); run20.Append(text58); paragraph48.Append(run20); textBody20.Append(bodyProperties48); textBody20.Append(listStyle48); textBody20.Append(paragraph48); shape20.Append(nonVisualShapeProperties20); shape20.Append(shapeProperties71); shape20.Append(textBody20); alternateContentFallback35.Append(shape20); alternateContent36.Append(alternateContentChoice36); alternateContent36.Append(alternateContentFallback35); Xdr.ClientData clientData38 = new Xdr.ClientData(); twoCellAnchor38.Append(fromMarker38); twoCellAnchor38.Append(toMarker38); twoCellAnchor38.Append(alternateContent36); twoCellAnchor38.Append(clientData38); worksheetDrawing9.Append(twoCellAnchor35); worksheetDrawing9.Append(twoCellAnchor36); worksheetDrawing9.Append(twoCellAnchor37); worksheetDrawing9.Append(twoCellAnchor38); drawingsPart9.WorksheetDrawing = worksheetDrawing9; }
// Generates content of drawingsPart8. private void GenerateDrawingsPart8Content(DrawingsPart drawingsPart8) { Xdr.WorksheetDrawing worksheetDrawing8 = new Xdr.WorksheetDrawing(); worksheetDrawing8.AddNamespaceDeclaration("xdr", "http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing"); worksheetDrawing8.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main"); Xdr.TwoCellAnchor twoCellAnchor29 = new Xdr.TwoCellAnchor(); Xdr.FromMarker fromMarker29 = new Xdr.FromMarker(); Xdr.ColumnId columnId57 = new Xdr.ColumnId(); columnId57.Text = "2"; Xdr.ColumnOffset columnOffset57 = new Xdr.ColumnOffset(); columnOffset57.Text = "185737"; Xdr.RowId rowId57 = new Xdr.RowId(); rowId57.Text = "0"; Xdr.RowOffset rowOffset57 = new Xdr.RowOffset(); rowOffset57.Text = "0"; fromMarker29.Append(columnId57); fromMarker29.Append(columnOffset57); fromMarker29.Append(rowId57); fromMarker29.Append(rowOffset57); Xdr.ToMarker toMarker29 = new Xdr.ToMarker(); Xdr.ColumnId columnId58 = new Xdr.ColumnId(); columnId58.Text = "9"; Xdr.ColumnOffset columnOffset58 = new Xdr.ColumnOffset(); columnOffset58.Text = "90487"; Xdr.RowId rowId58 = new Xdr.RowId(); rowId58.Text = "14"; Xdr.RowOffset rowOffset58 = new Xdr.RowOffset(); rowOffset58.Text = "76200"; toMarker29.Append(columnId58); toMarker29.Append(columnOffset58); toMarker29.Append(rowId58); toMarker29.Append(rowOffset58); Xdr.GraphicFrame graphicFrame29 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties29 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties43 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)2U, Name = "Chart 1" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties29 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties29.Append(nonVisualDrawingProperties43); nonVisualGraphicFrameProperties29.Append(nonVisualGraphicFrameDrawingProperties29); Xdr.Transform transform29 = new Xdr.Transform(); A.Offset offset43 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents43 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform29.Append(offset43); transform29.Append(extents43); A.Graphic graphic29 = new A.Graphic(); A.GraphicData graphicData29 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" }; C.ChartReference chartReference15 = new C.ChartReference(){ Id = "rId1" }; chartReference15.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); chartReference15.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); graphicData29.Append(chartReference15); graphic29.Append(graphicData29); graphicFrame29.Append(nonVisualGraphicFrameProperties29); graphicFrame29.Append(transform29); graphicFrame29.Append(graphic29); Xdr.ClientData clientData29 = new Xdr.ClientData(); twoCellAnchor29.Append(fromMarker29); twoCellAnchor29.Append(toMarker29); twoCellAnchor29.Append(graphicFrame29); twoCellAnchor29.Append(clientData29); Xdr.TwoCellAnchor twoCellAnchor30 = new Xdr.TwoCellAnchor(); Xdr.FromMarker fromMarker30 = new Xdr.FromMarker(); Xdr.ColumnId columnId59 = new Xdr.ColumnId(); columnId59.Text = "2"; Xdr.ColumnOffset columnOffset59 = new Xdr.ColumnOffset(); columnOffset59.Text = "200025"; Xdr.RowId rowId59 = new Xdr.RowId(); rowId59.Text = "14"; Xdr.RowOffset rowOffset59 = new Xdr.RowOffset(); rowOffset59.Text = "147637"; fromMarker30.Append(columnId59); fromMarker30.Append(columnOffset59); fromMarker30.Append(rowId59); fromMarker30.Append(rowOffset59); Xdr.ToMarker toMarker30 = new Xdr.ToMarker(); Xdr.ColumnId columnId60 = new Xdr.ColumnId(); columnId60.Text = "7"; Xdr.ColumnOffset columnOffset60 = new Xdr.ColumnOffset(); columnOffset60.Text = "476250"; Xdr.RowId rowId60 = new Xdr.RowId(); rowId60.Text = "29"; Xdr.RowOffset rowOffset60 = new Xdr.RowOffset(); rowOffset60.Text = "33337"; toMarker30.Append(columnId60); toMarker30.Append(columnOffset60); toMarker30.Append(rowId60); toMarker30.Append(rowOffset60); Xdr.GraphicFrame graphicFrame30 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties30 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties44 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)3U, Name = "グラフ 2" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties30 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties30.Append(nonVisualDrawingProperties44); nonVisualGraphicFrameProperties30.Append(nonVisualGraphicFrameDrawingProperties30); Xdr.Transform transform30 = new Xdr.Transform(); A.Offset offset44 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents44 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform30.Append(offset44); transform30.Append(extents44); A.Graphic graphic30 = new A.Graphic(); A.GraphicData graphicData30 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" }; C.ChartReference chartReference16 = new C.ChartReference(){ Id = "rId2" }; chartReference16.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); chartReference16.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); graphicData30.Append(chartReference16); graphic30.Append(graphicData30); graphicFrame30.Append(nonVisualGraphicFrameProperties30); graphicFrame30.Append(transform30); graphicFrame30.Append(graphic30); Xdr.ClientData clientData30 = new Xdr.ClientData(); twoCellAnchor30.Append(fromMarker30); twoCellAnchor30.Append(toMarker30); twoCellAnchor30.Append(graphicFrame30); twoCellAnchor30.Append(clientData30); Xdr.TwoCellAnchor twoCellAnchor31 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell }; Xdr.FromMarker fromMarker31 = new Xdr.FromMarker(); Xdr.ColumnId columnId61 = new Xdr.ColumnId(); columnId61.Text = "10"; Xdr.ColumnOffset columnOffset61 = new Xdr.ColumnOffset(); columnOffset61.Text = "28575"; Xdr.RowId rowId61 = new Xdr.RowId(); rowId61.Text = "0"; Xdr.RowOffset rowOffset61 = new Xdr.RowOffset(); rowOffset61.Text = "38100"; fromMarker31.Append(columnId61); fromMarker31.Append(columnOffset61); fromMarker31.Append(rowId61); fromMarker31.Append(rowOffset61); Xdr.ToMarker toMarker31 = new Xdr.ToMarker(); Xdr.ColumnId columnId62 = new Xdr.ColumnId(); columnId62.Text = "13"; Xdr.ColumnOffset columnOffset62 = new Xdr.ColumnOffset(); columnOffset62.Text = "762000"; Xdr.RowId rowId62 = new Xdr.RowId(); rowId62.Text = "6"; Xdr.RowOffset rowOffset62 = new Xdr.RowOffset(); rowOffset62.Text = "85725"; toMarker31.Append(columnId62); toMarker31.Append(columnOffset62); toMarker31.Append(rowId62); toMarker31.Append(rowOffset62); AlternateContent alternateContent30 = new AlternateContent(); alternateContent30.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); alternateContent30.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main"); AlternateContentChoice alternateContentChoice30 = new AlternateContentChoice(){ Requires = "a15" }; Xdr.GraphicFrame graphicFrame31 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties31 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties45 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)5U, Name = "DeliveryDate" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties31 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties31.Append(nonVisualDrawingProperties45); nonVisualGraphicFrameProperties31.Append(nonVisualGraphicFrameDrawingProperties31); Xdr.Transform transform31 = new Xdr.Transform(); A.Offset offset45 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents45 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform31.Append(offset45); transform31.Append(extents45); A.Graphic graphic31 = new A.Graphic(); A.GraphicData graphicData31 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" }; Tsle.TimeSlicer timeSlicer15 = new Tsle.TimeSlicer(){ Name = "DeliveryDate" }; timeSlicer15.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer"); graphicData31.Append(timeSlicer15); graphic31.Append(graphicData31); graphicFrame31.Append(nonVisualGraphicFrameProperties31); graphicFrame31.Append(transform31); graphicFrame31.Append(graphic31); alternateContentChoice30.Append(graphicFrame31); AlternateContentFallback alternateContentFallback29 = new AlternateContentFallback(); alternateContentFallback29.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); alternateContentFallback29.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); Xdr.Shape shape15 = new Xdr.Shape(){ Macro = "", TextLink = "" }; Xdr.NonVisualShapeProperties nonVisualShapeProperties15 = new Xdr.NonVisualShapeProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties46 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" }; Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties15 = new Xdr.NonVisualShapeDrawingProperties(); A.ShapeLocks shapeLocks15 = new A.ShapeLocks(){ NoTextEdit = true }; nonVisualShapeDrawingProperties15.Append(shapeLocks15); nonVisualShapeProperties15.Append(nonVisualDrawingProperties46); nonVisualShapeProperties15.Append(nonVisualShapeDrawingProperties15); Xdr.ShapeProperties shapeProperties62 = new Xdr.ShapeProperties(); A.Transform2D transform2D15 = new A.Transform2D(); A.Offset offset46 = new A.Offset(){ X = 8629650L, Y = 38100L }; A.Extents extents46 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L }; transform2D15.Append(offset46); transform2D15.Append(extents46); A.PresetGeometry presetGeometry15 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle }; A.AdjustValueList adjustValueList15 = new A.AdjustValueList(); presetGeometry15.Append(adjustValueList15); A.SolidFill solidFill117 = new A.SolidFill(); A.PresetColor presetColor29 = new A.PresetColor(){ Val = A.PresetColorValues.White }; solidFill117.Append(presetColor29); A.Outline outline95 = new A.Outline(){ Width = 1 }; A.SolidFill solidFill118 = new A.SolidFill(); A.PresetColor presetColor30 = new A.PresetColor(){ Val = A.PresetColorValues.Green }; solidFill118.Append(presetColor30); outline95.Append(solidFill118); shapeProperties62.Append(transform2D15); shapeProperties62.Append(presetGeometry15); shapeProperties62.Append(solidFill117); shapeProperties62.Append(outline95); Xdr.TextBody textBody15 = new Xdr.TextBody(); A.BodyProperties bodyProperties39 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip }; A.ListStyle listStyle39 = new A.ListStyle(); A.Paragraph paragraph39 = new A.Paragraph(); A.Run run15 = new A.Run(); A.RunProperties runProperties15 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 }; A.Text text53 = new A.Text(); text53.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize."; run15.Append(runProperties15); run15.Append(text53); paragraph39.Append(run15); textBody15.Append(bodyProperties39); textBody15.Append(listStyle39); textBody15.Append(paragraph39); shape15.Append(nonVisualShapeProperties15); shape15.Append(shapeProperties62); shape15.Append(textBody15); alternateContentFallback29.Append(shape15); alternateContent30.Append(alternateContentChoice30); alternateContent30.Append(alternateContentFallback29); Xdr.ClientData clientData31 = new Xdr.ClientData(); twoCellAnchor31.Append(fromMarker31); twoCellAnchor31.Append(toMarker31); twoCellAnchor31.Append(alternateContent30); twoCellAnchor31.Append(clientData31); Xdr.TwoCellAnchor twoCellAnchor32 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell }; Xdr.FromMarker fromMarker32 = new Xdr.FromMarker(); Xdr.ColumnId columnId63 = new Xdr.ColumnId(); columnId63.Text = "9"; Xdr.ColumnOffset columnOffset63 = new Xdr.ColumnOffset(); columnOffset63.Text = "857250"; Xdr.RowId rowId63 = new Xdr.RowId(); rowId63.Text = "8"; Xdr.RowOffset rowOffset63 = new Xdr.RowOffset(); rowOffset63.Text = "19050"; fromMarker32.Append(columnId63); fromMarker32.Append(columnOffset63); fromMarker32.Append(rowId63); fromMarker32.Append(rowOffset63); Xdr.ToMarker toMarker32 = new Xdr.ToMarker(); Xdr.ColumnId columnId64 = new Xdr.ColumnId(); columnId64.Text = "13"; Xdr.ColumnOffset columnOffset64 = new Xdr.ColumnOffset(); columnOffset64.Text = "723900"; Xdr.RowId rowId64 = new Xdr.RowId(); rowId64.Text = "14"; Xdr.RowOffset rowOffset64 = new Xdr.RowOffset(); rowOffset64.Text = "66675"; toMarker32.Append(columnId64); toMarker32.Append(columnOffset64); toMarker32.Append(rowId64); toMarker32.Append(rowOffset64); AlternateContent alternateContent31 = new AlternateContent(); alternateContent31.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); alternateContent31.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main"); AlternateContentChoice alternateContentChoice31 = new AlternateContentChoice(){ Requires = "a15" }; Xdr.GraphicFrame graphicFrame32 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties32 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties47 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)6U, Name = "DeliveryDate 1" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties32 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties32.Append(nonVisualDrawingProperties47); nonVisualGraphicFrameProperties32.Append(nonVisualGraphicFrameDrawingProperties32); Xdr.Transform transform32 = new Xdr.Transform(); A.Offset offset47 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents47 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform32.Append(offset47); transform32.Append(extents47); A.Graphic graphic32 = new A.Graphic(); A.GraphicData graphicData32 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" }; Tsle.TimeSlicer timeSlicer16 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 1" }; timeSlicer16.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer"); graphicData32.Append(timeSlicer16); graphic32.Append(graphicData32); graphicFrame32.Append(nonVisualGraphicFrameProperties32); graphicFrame32.Append(transform32); graphicFrame32.Append(graphic32); alternateContentChoice31.Append(graphicFrame32); AlternateContentFallback alternateContentFallback30 = new AlternateContentFallback(); alternateContentFallback30.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); alternateContentFallback30.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); Xdr.Shape shape16 = new Xdr.Shape(){ Macro = "", TextLink = "" }; Xdr.NonVisualShapeProperties nonVisualShapeProperties16 = new Xdr.NonVisualShapeProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties48 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" }; Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties16 = new Xdr.NonVisualShapeDrawingProperties(); A.ShapeLocks shapeLocks16 = new A.ShapeLocks(){ NoTextEdit = true }; nonVisualShapeDrawingProperties16.Append(shapeLocks16); nonVisualShapeProperties16.Append(nonVisualDrawingProperties48); nonVisualShapeProperties16.Append(nonVisualShapeDrawingProperties16); Xdr.ShapeProperties shapeProperties63 = new Xdr.ShapeProperties(); A.Transform2D transform2D16 = new A.Transform2D(); A.Offset offset48 = new A.Offset(){ X = 8591550L, Y = 1543050L }; A.Extents extents48 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L }; transform2D16.Append(offset48); transform2D16.Append(extents48); A.PresetGeometry presetGeometry16 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle }; A.AdjustValueList adjustValueList16 = new A.AdjustValueList(); presetGeometry16.Append(adjustValueList16); A.SolidFill solidFill119 = new A.SolidFill(); A.PresetColor presetColor31 = new A.PresetColor(){ Val = A.PresetColorValues.White }; solidFill119.Append(presetColor31); A.Outline outline96 = new A.Outline(){ Width = 1 }; A.SolidFill solidFill120 = new A.SolidFill(); A.PresetColor presetColor32 = new A.PresetColor(){ Val = A.PresetColorValues.Green }; solidFill120.Append(presetColor32); outline96.Append(solidFill120); shapeProperties63.Append(transform2D16); shapeProperties63.Append(presetGeometry16); shapeProperties63.Append(solidFill119); shapeProperties63.Append(outline96); Xdr.TextBody textBody16 = new Xdr.TextBody(); A.BodyProperties bodyProperties40 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip }; A.ListStyle listStyle40 = new A.ListStyle(); A.Paragraph paragraph40 = new A.Paragraph(); A.Run run16 = new A.Run(); A.RunProperties runProperties16 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 }; A.Text text54 = new A.Text(); text54.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize."; run16.Append(runProperties16); run16.Append(text54); paragraph40.Append(run16); textBody16.Append(bodyProperties40); textBody16.Append(listStyle40); textBody16.Append(paragraph40); shape16.Append(nonVisualShapeProperties16); shape16.Append(shapeProperties63); shape16.Append(textBody16); alternateContentFallback30.Append(shape16); alternateContent31.Append(alternateContentChoice31); alternateContent31.Append(alternateContentFallback30); Xdr.ClientData clientData32 = new Xdr.ClientData(); twoCellAnchor32.Append(fromMarker32); twoCellAnchor32.Append(toMarker32); twoCellAnchor32.Append(alternateContent31); twoCellAnchor32.Append(clientData32); Xdr.TwoCellAnchor twoCellAnchor33 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell }; Xdr.FromMarker fromMarker33 = new Xdr.FromMarker(); Xdr.ColumnId columnId65 = new Xdr.ColumnId(); columnId65.Text = "10"; Xdr.ColumnOffset columnOffset65 = new Xdr.ColumnOffset(); columnOffset65.Text = "9525"; Xdr.RowId rowId65 = new Xdr.RowId(); rowId65.Text = "16"; Xdr.RowOffset rowOffset65 = new Xdr.RowOffset(); rowOffset65.Text = "0"; fromMarker33.Append(columnId65); fromMarker33.Append(columnOffset65); fromMarker33.Append(rowId65); fromMarker33.Append(rowOffset65); Xdr.ToMarker toMarker33 = new Xdr.ToMarker(); Xdr.ColumnId columnId66 = new Xdr.ColumnId(); columnId66.Text = "13"; Xdr.ColumnOffset columnOffset66 = new Xdr.ColumnOffset(); columnOffset66.Text = "742950"; Xdr.RowId rowId66 = new Xdr.RowId(); rowId66.Text = "22"; Xdr.RowOffset rowOffset66 = new Xdr.RowOffset(); rowOffset66.Text = "47625"; toMarker33.Append(columnId66); toMarker33.Append(columnOffset66); toMarker33.Append(rowId66); toMarker33.Append(rowOffset66); AlternateContent alternateContent32 = new AlternateContent(); alternateContent32.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); alternateContent32.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main"); AlternateContentChoice alternateContentChoice32 = new AlternateContentChoice(){ Requires = "a15" }; Xdr.GraphicFrame graphicFrame33 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties33 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties49 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)7U, Name = "DeliveryDate 2" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties33 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties33.Append(nonVisualDrawingProperties49); nonVisualGraphicFrameProperties33.Append(nonVisualGraphicFrameDrawingProperties33); Xdr.Transform transform33 = new Xdr.Transform(); A.Offset offset49 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents49 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform33.Append(offset49); transform33.Append(extents49); A.Graphic graphic33 = new A.Graphic(); A.GraphicData graphicData33 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" }; Tsle.TimeSlicer timeSlicer17 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 2" }; timeSlicer17.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer"); graphicData33.Append(timeSlicer17); graphic33.Append(graphicData33); graphicFrame33.Append(nonVisualGraphicFrameProperties33); graphicFrame33.Append(transform33); graphicFrame33.Append(graphic33); alternateContentChoice32.Append(graphicFrame33); AlternateContentFallback alternateContentFallback31 = new AlternateContentFallback(); alternateContentFallback31.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); alternateContentFallback31.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); Xdr.Shape shape17 = new Xdr.Shape(){ Macro = "", TextLink = "" }; Xdr.NonVisualShapeProperties nonVisualShapeProperties17 = new Xdr.NonVisualShapeProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties50 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" }; Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties17 = new Xdr.NonVisualShapeDrawingProperties(); A.ShapeLocks shapeLocks17 = new A.ShapeLocks(){ NoTextEdit = true }; nonVisualShapeDrawingProperties17.Append(shapeLocks17); nonVisualShapeProperties17.Append(nonVisualDrawingProperties50); nonVisualShapeProperties17.Append(nonVisualShapeDrawingProperties17); Xdr.ShapeProperties shapeProperties64 = new Xdr.ShapeProperties(); A.Transform2D transform2D17 = new A.Transform2D(); A.Offset offset50 = new A.Offset(){ X = 8610600L, Y = 3048000L }; A.Extents extents50 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L }; transform2D17.Append(offset50); transform2D17.Append(extents50); A.PresetGeometry presetGeometry17 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle }; A.AdjustValueList adjustValueList17 = new A.AdjustValueList(); presetGeometry17.Append(adjustValueList17); A.SolidFill solidFill121 = new A.SolidFill(); A.PresetColor presetColor33 = new A.PresetColor(){ Val = A.PresetColorValues.White }; solidFill121.Append(presetColor33); A.Outline outline97 = new A.Outline(){ Width = 1 }; A.SolidFill solidFill122 = new A.SolidFill(); A.PresetColor presetColor34 = new A.PresetColor(){ Val = A.PresetColorValues.Green }; solidFill122.Append(presetColor34); outline97.Append(solidFill122); shapeProperties64.Append(transform2D17); shapeProperties64.Append(presetGeometry17); shapeProperties64.Append(solidFill121); shapeProperties64.Append(outline97); Xdr.TextBody textBody17 = new Xdr.TextBody(); A.BodyProperties bodyProperties41 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip }; A.ListStyle listStyle41 = new A.ListStyle(); A.Paragraph paragraph41 = new A.Paragraph(); A.Run run17 = new A.Run(); A.RunProperties runProperties17 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 }; A.Text text55 = new A.Text(); text55.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize."; run17.Append(runProperties17); run17.Append(text55); paragraph41.Append(run17); textBody17.Append(bodyProperties41); textBody17.Append(listStyle41); textBody17.Append(paragraph41); shape17.Append(nonVisualShapeProperties17); shape17.Append(shapeProperties64); shape17.Append(textBody17); alternateContentFallback31.Append(shape17); alternateContent32.Append(alternateContentChoice32); alternateContent32.Append(alternateContentFallback31); Xdr.ClientData clientData33 = new Xdr.ClientData(); twoCellAnchor33.Append(fromMarker33); twoCellAnchor33.Append(toMarker33); twoCellAnchor33.Append(alternateContent32); twoCellAnchor33.Append(clientData33); Xdr.TwoCellAnchor twoCellAnchor34 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell }; Xdr.FromMarker fromMarker34 = new Xdr.FromMarker(); Xdr.ColumnId columnId67 = new Xdr.ColumnId(); columnId67.Text = "10"; Xdr.ColumnOffset columnOffset67 = new Xdr.ColumnOffset(); columnOffset67.Text = "0"; Xdr.RowId rowId67 = new Xdr.RowId(); rowId67.Text = "23"; Xdr.RowOffset rowOffset67 = new Xdr.RowOffset(); rowOffset67.Text = "85725"; fromMarker34.Append(columnId67); fromMarker34.Append(columnOffset67); fromMarker34.Append(rowId67); fromMarker34.Append(rowOffset67); Xdr.ToMarker toMarker34 = new Xdr.ToMarker(); Xdr.ColumnId columnId68 = new Xdr.ColumnId(); columnId68.Text = "13"; Xdr.ColumnOffset columnOffset68 = new Xdr.ColumnOffset(); columnOffset68.Text = "733425"; Xdr.RowId rowId68 = new Xdr.RowId(); rowId68.Text = "29"; Xdr.RowOffset rowOffset68 = new Xdr.RowOffset(); rowOffset68.Text = "133350"; toMarker34.Append(columnId68); toMarker34.Append(columnOffset68); toMarker34.Append(rowId68); toMarker34.Append(rowOffset68); AlternateContent alternateContent33 = new AlternateContent(); alternateContent33.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); alternateContent33.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main"); AlternateContentChoice alternateContentChoice33 = new AlternateContentChoice(){ Requires = "a15" }; Xdr.GraphicFrame graphicFrame34 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties34 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties51 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)8U, Name = "DeliveryDate 3" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties34 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties34.Append(nonVisualDrawingProperties51); nonVisualGraphicFrameProperties34.Append(nonVisualGraphicFrameDrawingProperties34); Xdr.Transform transform34 = new Xdr.Transform(); A.Offset offset51 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents51 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform34.Append(offset51); transform34.Append(extents51); A.Graphic graphic34 = new A.Graphic(); A.GraphicData graphicData34 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" }; Tsle.TimeSlicer timeSlicer18 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 3" }; timeSlicer18.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer"); graphicData34.Append(timeSlicer18); graphic34.Append(graphicData34); graphicFrame34.Append(nonVisualGraphicFrameProperties34); graphicFrame34.Append(transform34); graphicFrame34.Append(graphic34); alternateContentChoice33.Append(graphicFrame34); AlternateContentFallback alternateContentFallback32 = new AlternateContentFallback(); alternateContentFallback32.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); alternateContentFallback32.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); Xdr.Shape shape18 = new Xdr.Shape(){ Macro = "", TextLink = "" }; Xdr.NonVisualShapeProperties nonVisualShapeProperties18 = new Xdr.NonVisualShapeProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties52 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" }; Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties18 = new Xdr.NonVisualShapeDrawingProperties(); A.ShapeLocks shapeLocks18 = new A.ShapeLocks(){ NoTextEdit = true }; nonVisualShapeDrawingProperties18.Append(shapeLocks18); nonVisualShapeProperties18.Append(nonVisualDrawingProperties52); nonVisualShapeProperties18.Append(nonVisualShapeDrawingProperties18); Xdr.ShapeProperties shapeProperties65 = new Xdr.ShapeProperties(); A.Transform2D transform2D18 = new A.Transform2D(); A.Offset offset52 = new A.Offset(){ X = 8601075L, Y = 4467225L }; A.Extents extents52 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L }; transform2D18.Append(offset52); transform2D18.Append(extents52); A.PresetGeometry presetGeometry18 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle }; A.AdjustValueList adjustValueList18 = new A.AdjustValueList(); presetGeometry18.Append(adjustValueList18); A.SolidFill solidFill123 = new A.SolidFill(); A.PresetColor presetColor35 = new A.PresetColor(){ Val = A.PresetColorValues.White }; solidFill123.Append(presetColor35); A.Outline outline98 = new A.Outline(){ Width = 1 }; A.SolidFill solidFill124 = new A.SolidFill(); A.PresetColor presetColor36 = new A.PresetColor(){ Val = A.PresetColorValues.Green }; solidFill124.Append(presetColor36); outline98.Append(solidFill124); shapeProperties65.Append(transform2D18); shapeProperties65.Append(presetGeometry18); shapeProperties65.Append(solidFill123); shapeProperties65.Append(outline98); Xdr.TextBody textBody18 = new Xdr.TextBody(); A.BodyProperties bodyProperties42 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip }; A.ListStyle listStyle42 = new A.ListStyle(); A.Paragraph paragraph42 = new A.Paragraph(); A.Run run18 = new A.Run(); A.RunProperties runProperties18 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 }; A.Text text56 = new A.Text(); text56.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize."; run18.Append(runProperties18); run18.Append(text56); paragraph42.Append(run18); textBody18.Append(bodyProperties42); textBody18.Append(listStyle42); textBody18.Append(paragraph42); shape18.Append(nonVisualShapeProperties18); shape18.Append(shapeProperties65); shape18.Append(textBody18); alternateContentFallback32.Append(shape18); alternateContent33.Append(alternateContentChoice33); alternateContent33.Append(alternateContentFallback32); Xdr.ClientData clientData34 = new Xdr.ClientData(); twoCellAnchor34.Append(fromMarker34); twoCellAnchor34.Append(toMarker34); twoCellAnchor34.Append(alternateContent33); twoCellAnchor34.Append(clientData34); worksheetDrawing8.Append(twoCellAnchor29); worksheetDrawing8.Append(twoCellAnchor30); worksheetDrawing8.Append(twoCellAnchor31); worksheetDrawing8.Append(twoCellAnchor32); worksheetDrawing8.Append(twoCellAnchor33); worksheetDrawing8.Append(twoCellAnchor34); drawingsPart8.WorksheetDrawing = worksheetDrawing8; }
// Generates content of drawingsPart7. private void GenerateDrawingsPart7Content(DrawingsPart drawingsPart7) { Xdr.WorksheetDrawing worksheetDrawing7 = new Xdr.WorksheetDrawing(); worksheetDrawing7.AddNamespaceDeclaration("xdr", "http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing"); worksheetDrawing7.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main"); Xdr.TwoCellAnchor twoCellAnchor25 = new Xdr.TwoCellAnchor(); Xdr.FromMarker fromMarker25 = new Xdr.FromMarker(); Xdr.ColumnId columnId49 = new Xdr.ColumnId(); columnId49.Text = "2"; Xdr.ColumnOffset columnOffset49 = new Xdr.ColumnOffset(); columnOffset49.Text = "185737"; Xdr.RowId rowId49 = new Xdr.RowId(); rowId49.Text = "0"; Xdr.RowOffset rowOffset49 = new Xdr.RowOffset(); rowOffset49.Text = "0"; fromMarker25.Append(columnId49); fromMarker25.Append(columnOffset49); fromMarker25.Append(rowId49); fromMarker25.Append(rowOffset49); Xdr.ToMarker toMarker25 = new Xdr.ToMarker(); Xdr.ColumnId columnId50 = new Xdr.ColumnId(); columnId50.Text = "9"; Xdr.ColumnOffset columnOffset50 = new Xdr.ColumnOffset(); columnOffset50.Text = "90487"; Xdr.RowId rowId50 = new Xdr.RowId(); rowId50.Text = "14"; Xdr.RowOffset rowOffset50 = new Xdr.RowOffset(); rowOffset50.Text = "76200"; toMarker25.Append(columnId50); toMarker25.Append(columnOffset50); toMarker25.Append(rowId50); toMarker25.Append(rowOffset50); Xdr.GraphicFrame graphicFrame25 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties25 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties37 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)2U, Name = "Chart 1" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties25 = new Xdr.NonVisualGraphicFrameDrawingProperties(); A.GraphicFrameLocks graphicFrameLocks11 = new A.GraphicFrameLocks(); nonVisualGraphicFrameDrawingProperties25.Append(graphicFrameLocks11); nonVisualGraphicFrameProperties25.Append(nonVisualDrawingProperties37); nonVisualGraphicFrameProperties25.Append(nonVisualGraphicFrameDrawingProperties25); Xdr.Transform transform25 = new Xdr.Transform(); A.Offset offset37 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents37 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform25.Append(offset37); transform25.Append(extents37); A.Graphic graphic25 = new A.Graphic(); A.GraphicData graphicData25 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" }; C.ChartReference chartReference13 = new C.ChartReference(){ Id = "rId1" }; chartReference13.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); chartReference13.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); graphicData25.Append(chartReference13); graphic25.Append(graphicData25); graphicFrame25.Append(nonVisualGraphicFrameProperties25); graphicFrame25.Append(transform25); graphicFrame25.Append(graphic25); Xdr.ClientData clientData25 = new Xdr.ClientData(); twoCellAnchor25.Append(fromMarker25); twoCellAnchor25.Append(toMarker25); twoCellAnchor25.Append(graphicFrame25); twoCellAnchor25.Append(clientData25); Xdr.TwoCellAnchor twoCellAnchor26 = new Xdr.TwoCellAnchor(); Xdr.FromMarker fromMarker26 = new Xdr.FromMarker(); Xdr.ColumnId columnId51 = new Xdr.ColumnId(); columnId51.Text = "2"; Xdr.ColumnOffset columnOffset51 = new Xdr.ColumnOffset(); columnOffset51.Text = "200025"; Xdr.RowId rowId51 = new Xdr.RowId(); rowId51.Text = "14"; Xdr.RowOffset rowOffset51 = new Xdr.RowOffset(); rowOffset51.Text = "147637"; fromMarker26.Append(columnId51); fromMarker26.Append(columnOffset51); fromMarker26.Append(rowId51); fromMarker26.Append(rowOffset51); Xdr.ToMarker toMarker26 = new Xdr.ToMarker(); Xdr.ColumnId columnId52 = new Xdr.ColumnId(); columnId52.Text = "7"; Xdr.ColumnOffset columnOffset52 = new Xdr.ColumnOffset(); columnOffset52.Text = "476250"; Xdr.RowId rowId52 = new Xdr.RowId(); rowId52.Text = "29"; Xdr.RowOffset rowOffset52 = new Xdr.RowOffset(); rowOffset52.Text = "33337"; toMarker26.Append(columnId52); toMarker26.Append(columnOffset52); toMarker26.Append(rowId52); toMarker26.Append(rowOffset52); Xdr.GraphicFrame graphicFrame26 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties26 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties38 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)3U, Name = "グラフ 2" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties26 = new Xdr.NonVisualGraphicFrameDrawingProperties(); A.GraphicFrameLocks graphicFrameLocks12 = new A.GraphicFrameLocks(); nonVisualGraphicFrameDrawingProperties26.Append(graphicFrameLocks12); nonVisualGraphicFrameProperties26.Append(nonVisualDrawingProperties38); nonVisualGraphicFrameProperties26.Append(nonVisualGraphicFrameDrawingProperties26); Xdr.Transform transform26 = new Xdr.Transform(); A.Offset offset38 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents38 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform26.Append(offset38); transform26.Append(extents38); A.Graphic graphic26 = new A.Graphic(); A.GraphicData graphicData26 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" }; C.ChartReference chartReference14 = new C.ChartReference(){ Id = "rId2" }; chartReference14.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); chartReference14.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); graphicData26.Append(chartReference14); graphic26.Append(graphicData26); graphicFrame26.Append(nonVisualGraphicFrameProperties26); graphicFrame26.Append(transform26); graphicFrame26.Append(graphic26); Xdr.ClientData clientData26 = new Xdr.ClientData(); twoCellAnchor26.Append(fromMarker26); twoCellAnchor26.Append(toMarker26); twoCellAnchor26.Append(graphicFrame26); twoCellAnchor26.Append(clientData26); Xdr.TwoCellAnchor twoCellAnchor27 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell }; Xdr.FromMarker fromMarker27 = new Xdr.FromMarker(); Xdr.ColumnId columnId53 = new Xdr.ColumnId(); columnId53.Text = "10"; Xdr.ColumnOffset columnOffset53 = new Xdr.ColumnOffset(); columnOffset53.Text = "9525"; Xdr.RowId rowId53 = new Xdr.RowId(); rowId53.Text = "1"; Xdr.RowOffset rowOffset53 = new Xdr.RowOffset(); rowOffset53.Text = "0"; fromMarker27.Append(columnId53); fromMarker27.Append(columnOffset53); fromMarker27.Append(rowId53); fromMarker27.Append(rowOffset53); Xdr.ToMarker toMarker27 = new Xdr.ToMarker(); Xdr.ColumnId columnId54 = new Xdr.ColumnId(); columnId54.Text = "13"; Xdr.ColumnOffset columnOffset54 = new Xdr.ColumnOffset(); columnOffset54.Text = "742950"; Xdr.RowId rowId54 = new Xdr.RowId(); rowId54.Text = "7"; Xdr.RowOffset rowOffset54 = new Xdr.RowOffset(); rowOffset54.Text = "47625"; toMarker27.Append(columnId54); toMarker27.Append(columnOffset54); toMarker27.Append(rowId54); toMarker27.Append(rowOffset54); AlternateContent alternateContent26 = new AlternateContent(); alternateContent26.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); alternateContent26.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main"); AlternateContentChoice alternateContentChoice26 = new AlternateContentChoice(){ Requires = "a15" }; Xdr.GraphicFrame graphicFrame27 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties27 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties39 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)4U, Name = "DeliveryDate 14" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties27 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties27.Append(nonVisualDrawingProperties39); nonVisualGraphicFrameProperties27.Append(nonVisualGraphicFrameDrawingProperties27); Xdr.Transform transform27 = new Xdr.Transform(); A.Offset offset39 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents39 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform27.Append(offset39); transform27.Append(extents39); A.Graphic graphic27 = new A.Graphic(); A.GraphicData graphicData27 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" }; Tsle.TimeSlicer timeSlicer13 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 14" }; timeSlicer13.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer"); graphicData27.Append(timeSlicer13); graphic27.Append(graphicData27); graphicFrame27.Append(nonVisualGraphicFrameProperties27); graphicFrame27.Append(transform27); graphicFrame27.Append(graphic27); alternateContentChoice26.Append(graphicFrame27); AlternateContentFallback alternateContentFallback25 = new AlternateContentFallback(); alternateContentFallback25.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); alternateContentFallback25.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); Xdr.Shape shape13 = new Xdr.Shape(){ Macro = "", TextLink = "" }; Xdr.NonVisualShapeProperties nonVisualShapeProperties13 = new Xdr.NonVisualShapeProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties40 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" }; Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties13 = new Xdr.NonVisualShapeDrawingProperties(); A.ShapeLocks shapeLocks13 = new A.ShapeLocks(){ NoTextEdit = true }; nonVisualShapeDrawingProperties13.Append(shapeLocks13); nonVisualShapeProperties13.Append(nonVisualDrawingProperties40); nonVisualShapeProperties13.Append(nonVisualShapeDrawingProperties13); Xdr.ShapeProperties shapeProperties50 = new Xdr.ShapeProperties(); A.Transform2D transform2D13 = new A.Transform2D(); A.Offset offset40 = new A.Offset(){ X = 8610600L, Y = 190500L }; A.Extents extents40 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L }; transform2D13.Append(offset40); transform2D13.Append(extents40); A.PresetGeometry presetGeometry13 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle }; A.AdjustValueList adjustValueList13 = new A.AdjustValueList(); presetGeometry13.Append(adjustValueList13); A.SolidFill solidFill97 = new A.SolidFill(); A.PresetColor presetColor25 = new A.PresetColor(){ Val = A.PresetColorValues.White }; solidFill97.Append(presetColor25); A.Outline outline78 = new A.Outline(){ Width = 1 }; A.SolidFill solidFill98 = new A.SolidFill(); A.PresetColor presetColor26 = new A.PresetColor(){ Val = A.PresetColorValues.Green }; solidFill98.Append(presetColor26); outline78.Append(solidFill98); shapeProperties50.Append(transform2D13); shapeProperties50.Append(presetGeometry13); shapeProperties50.Append(solidFill97); shapeProperties50.Append(outline78); Xdr.TextBody textBody13 = new Xdr.TextBody(); A.BodyProperties bodyProperties33 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip }; A.ListStyle listStyle33 = new A.ListStyle(); A.Paragraph paragraph33 = new A.Paragraph(); A.Run run13 = new A.Run(); A.RunProperties runProperties13 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 }; A.Text text51 = new A.Text(); text51.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize."; run13.Append(runProperties13); run13.Append(text51); paragraph33.Append(run13); textBody13.Append(bodyProperties33); textBody13.Append(listStyle33); textBody13.Append(paragraph33); shape13.Append(nonVisualShapeProperties13); shape13.Append(shapeProperties50); shape13.Append(textBody13); alternateContentFallback25.Append(shape13); alternateContent26.Append(alternateContentChoice26); alternateContent26.Append(alternateContentFallback25); Xdr.ClientData clientData27 = new Xdr.ClientData(); twoCellAnchor27.Append(fromMarker27); twoCellAnchor27.Append(toMarker27); twoCellAnchor27.Append(alternateContent26); twoCellAnchor27.Append(clientData27); Xdr.TwoCellAnchor twoCellAnchor28 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell }; Xdr.FromMarker fromMarker28 = new Xdr.FromMarker(); Xdr.ColumnId columnId55 = new Xdr.ColumnId(); columnId55.Text = "10"; Xdr.ColumnOffset columnOffset55 = new Xdr.ColumnOffset(); columnOffset55.Text = "19050"; Xdr.RowId rowId55 = new Xdr.RowId(); rowId55.Text = "9"; Xdr.RowOffset rowOffset55 = new Xdr.RowOffset(); rowOffset55.Text = "9525"; fromMarker28.Append(columnId55); fromMarker28.Append(columnOffset55); fromMarker28.Append(rowId55); fromMarker28.Append(rowOffset55); Xdr.ToMarker toMarker28 = new Xdr.ToMarker(); Xdr.ColumnId columnId56 = new Xdr.ColumnId(); columnId56.Text = "13"; Xdr.ColumnOffset columnOffset56 = new Xdr.ColumnOffset(); columnOffset56.Text = "752475"; Xdr.RowId rowId56 = new Xdr.RowId(); rowId56.Text = "15"; Xdr.RowOffset rowOffset56 = new Xdr.RowOffset(); rowOffset56.Text = "57150"; toMarker28.Append(columnId56); toMarker28.Append(columnOffset56); toMarker28.Append(rowId56); toMarker28.Append(rowOffset56); AlternateContent alternateContent27 = new AlternateContent(); alternateContent27.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); alternateContent27.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main"); AlternateContentChoice alternateContentChoice27 = new AlternateContentChoice(){ Requires = "a15" }; Xdr.GraphicFrame graphicFrame28 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties28 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties41 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)5U, Name = "DeliveryDate 15" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties28 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties28.Append(nonVisualDrawingProperties41); nonVisualGraphicFrameProperties28.Append(nonVisualGraphicFrameDrawingProperties28); Xdr.Transform transform28 = new Xdr.Transform(); A.Offset offset41 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents41 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform28.Append(offset41); transform28.Append(extents41); A.Graphic graphic28 = new A.Graphic(); A.GraphicData graphicData28 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" }; Tsle.TimeSlicer timeSlicer14 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 15" }; timeSlicer14.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer"); graphicData28.Append(timeSlicer14); graphic28.Append(graphicData28); graphicFrame28.Append(nonVisualGraphicFrameProperties28); graphicFrame28.Append(transform28); graphicFrame28.Append(graphic28); alternateContentChoice27.Append(graphicFrame28); AlternateContentFallback alternateContentFallback26 = new AlternateContentFallback(); alternateContentFallback26.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); alternateContentFallback26.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); Xdr.Shape shape14 = new Xdr.Shape(){ Macro = "", TextLink = "" }; Xdr.NonVisualShapeProperties nonVisualShapeProperties14 = new Xdr.NonVisualShapeProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties42 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" }; Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties14 = new Xdr.NonVisualShapeDrawingProperties(); A.ShapeLocks shapeLocks14 = new A.ShapeLocks(){ NoTextEdit = true }; nonVisualShapeDrawingProperties14.Append(shapeLocks14); nonVisualShapeProperties14.Append(nonVisualDrawingProperties42); nonVisualShapeProperties14.Append(nonVisualShapeDrawingProperties14); Xdr.ShapeProperties shapeProperties51 = new Xdr.ShapeProperties(); A.Transform2D transform2D14 = new A.Transform2D(); A.Offset offset42 = new A.Offset(){ X = 8620125L, Y = 1724025L }; A.Extents extents42 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L }; transform2D14.Append(offset42); transform2D14.Append(extents42); A.PresetGeometry presetGeometry14 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle }; A.AdjustValueList adjustValueList14 = new A.AdjustValueList(); presetGeometry14.Append(adjustValueList14); A.SolidFill solidFill99 = new A.SolidFill(); A.PresetColor presetColor27 = new A.PresetColor(){ Val = A.PresetColorValues.White }; solidFill99.Append(presetColor27); A.Outline outline79 = new A.Outline(){ Width = 1 }; A.SolidFill solidFill100 = new A.SolidFill(); A.PresetColor presetColor28 = new A.PresetColor(){ Val = A.PresetColorValues.Green }; solidFill100.Append(presetColor28); outline79.Append(solidFill100); shapeProperties51.Append(transform2D14); shapeProperties51.Append(presetGeometry14); shapeProperties51.Append(solidFill99); shapeProperties51.Append(outline79); Xdr.TextBody textBody14 = new Xdr.TextBody(); A.BodyProperties bodyProperties34 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip }; A.ListStyle listStyle34 = new A.ListStyle(); A.Paragraph paragraph34 = new A.Paragraph(); A.Run run14 = new A.Run(); A.RunProperties runProperties14 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 }; A.Text text52 = new A.Text(); text52.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize."; run14.Append(runProperties14); run14.Append(text52); paragraph34.Append(run14); textBody14.Append(bodyProperties34); textBody14.Append(listStyle34); textBody14.Append(paragraph34); shape14.Append(nonVisualShapeProperties14); shape14.Append(shapeProperties51); shape14.Append(textBody14); alternateContentFallback26.Append(shape14); alternateContent27.Append(alternateContentChoice27); alternateContent27.Append(alternateContentFallback26); Xdr.ClientData clientData28 = new Xdr.ClientData(); twoCellAnchor28.Append(fromMarker28); twoCellAnchor28.Append(toMarker28); twoCellAnchor28.Append(alternateContent27); twoCellAnchor28.Append(clientData28); worksheetDrawing7.Append(twoCellAnchor25); worksheetDrawing7.Append(twoCellAnchor26); worksheetDrawing7.Append(twoCellAnchor27); worksheetDrawing7.Append(twoCellAnchor28); drawingsPart7.WorksheetDrawing = worksheetDrawing7; }
// Generates content of drawingsPart6. private void GenerateDrawingsPart6Content(DrawingsPart drawingsPart6) { Xdr.WorksheetDrawing worksheetDrawing6 = new Xdr.WorksheetDrawing(); worksheetDrawing6.AddNamespaceDeclaration("xdr", "http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing"); worksheetDrawing6.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main"); Xdr.TwoCellAnchor twoCellAnchor21 = new Xdr.TwoCellAnchor(); Xdr.FromMarker fromMarker21 = new Xdr.FromMarker(); Xdr.ColumnId columnId41 = new Xdr.ColumnId(); columnId41.Text = "2"; Xdr.ColumnOffset columnOffset41 = new Xdr.ColumnOffset(); columnOffset41.Text = "185737"; Xdr.RowId rowId41 = new Xdr.RowId(); rowId41.Text = "0"; Xdr.RowOffset rowOffset41 = new Xdr.RowOffset(); rowOffset41.Text = "0"; fromMarker21.Append(columnId41); fromMarker21.Append(columnOffset41); fromMarker21.Append(rowId41); fromMarker21.Append(rowOffset41); Xdr.ToMarker toMarker21 = new Xdr.ToMarker(); Xdr.ColumnId columnId42 = new Xdr.ColumnId(); columnId42.Text = "9"; Xdr.ColumnOffset columnOffset42 = new Xdr.ColumnOffset(); columnOffset42.Text = "90487"; Xdr.RowId rowId42 = new Xdr.RowId(); rowId42.Text = "14"; Xdr.RowOffset rowOffset42 = new Xdr.RowOffset(); rowOffset42.Text = "76200"; toMarker21.Append(columnId42); toMarker21.Append(columnOffset42); toMarker21.Append(rowId42); toMarker21.Append(rowOffset42); Xdr.GraphicFrame graphicFrame21 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties21 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties31 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)2U, Name = "Chart 1" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties21 = new Xdr.NonVisualGraphicFrameDrawingProperties(); A.GraphicFrameLocks graphicFrameLocks9 = new A.GraphicFrameLocks(); nonVisualGraphicFrameDrawingProperties21.Append(graphicFrameLocks9); nonVisualGraphicFrameProperties21.Append(nonVisualDrawingProperties31); nonVisualGraphicFrameProperties21.Append(nonVisualGraphicFrameDrawingProperties21); Xdr.Transform transform21 = new Xdr.Transform(); A.Offset offset31 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents31 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform21.Append(offset31); transform21.Append(extents31); A.Graphic graphic21 = new A.Graphic(); A.GraphicData graphicData21 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" }; C.ChartReference chartReference11 = new C.ChartReference(){ Id = "rId1" }; chartReference11.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); chartReference11.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); graphicData21.Append(chartReference11); graphic21.Append(graphicData21); graphicFrame21.Append(nonVisualGraphicFrameProperties21); graphicFrame21.Append(transform21); graphicFrame21.Append(graphic21); Xdr.ClientData clientData21 = new Xdr.ClientData(); twoCellAnchor21.Append(fromMarker21); twoCellAnchor21.Append(toMarker21); twoCellAnchor21.Append(graphicFrame21); twoCellAnchor21.Append(clientData21); Xdr.TwoCellAnchor twoCellAnchor22 = new Xdr.TwoCellAnchor(); Xdr.FromMarker fromMarker22 = new Xdr.FromMarker(); Xdr.ColumnId columnId43 = new Xdr.ColumnId(); columnId43.Text = "2"; Xdr.ColumnOffset columnOffset43 = new Xdr.ColumnOffset(); columnOffset43.Text = "200025"; Xdr.RowId rowId43 = new Xdr.RowId(); rowId43.Text = "14"; Xdr.RowOffset rowOffset43 = new Xdr.RowOffset(); rowOffset43.Text = "147637"; fromMarker22.Append(columnId43); fromMarker22.Append(columnOffset43); fromMarker22.Append(rowId43); fromMarker22.Append(rowOffset43); Xdr.ToMarker toMarker22 = new Xdr.ToMarker(); Xdr.ColumnId columnId44 = new Xdr.ColumnId(); columnId44.Text = "7"; Xdr.ColumnOffset columnOffset44 = new Xdr.ColumnOffset(); columnOffset44.Text = "476250"; Xdr.RowId rowId44 = new Xdr.RowId(); rowId44.Text = "29"; Xdr.RowOffset rowOffset44 = new Xdr.RowOffset(); rowOffset44.Text = "33337"; toMarker22.Append(columnId44); toMarker22.Append(columnOffset44); toMarker22.Append(rowId44); toMarker22.Append(rowOffset44); Xdr.GraphicFrame graphicFrame22 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties22 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties32 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)3U, Name = "グラフ 2" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties22 = new Xdr.NonVisualGraphicFrameDrawingProperties(); A.GraphicFrameLocks graphicFrameLocks10 = new A.GraphicFrameLocks(); nonVisualGraphicFrameDrawingProperties22.Append(graphicFrameLocks10); nonVisualGraphicFrameProperties22.Append(nonVisualDrawingProperties32); nonVisualGraphicFrameProperties22.Append(nonVisualGraphicFrameDrawingProperties22); Xdr.Transform transform22 = new Xdr.Transform(); A.Offset offset32 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents32 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform22.Append(offset32); transform22.Append(extents32); A.Graphic graphic22 = new A.Graphic(); A.GraphicData graphicData22 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" }; C.ChartReference chartReference12 = new C.ChartReference(){ Id = "rId2" }; chartReference12.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); chartReference12.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); graphicData22.Append(chartReference12); graphic22.Append(graphicData22); graphicFrame22.Append(nonVisualGraphicFrameProperties22); graphicFrame22.Append(transform22); graphicFrame22.Append(graphic22); Xdr.ClientData clientData22 = new Xdr.ClientData(); twoCellAnchor22.Append(fromMarker22); twoCellAnchor22.Append(toMarker22); twoCellAnchor22.Append(graphicFrame22); twoCellAnchor22.Append(clientData22); Xdr.TwoCellAnchor twoCellAnchor23 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell }; Xdr.FromMarker fromMarker23 = new Xdr.FromMarker(); Xdr.ColumnId columnId45 = new Xdr.ColumnId(); columnId45.Text = "10"; Xdr.ColumnOffset columnOffset45 = new Xdr.ColumnOffset(); columnOffset45.Text = "38100"; Xdr.RowId rowId45 = new Xdr.RowId(); rowId45.Text = "1"; Xdr.RowOffset rowOffset45 = new Xdr.RowOffset(); rowOffset45.Text = "0"; fromMarker23.Append(columnId45); fromMarker23.Append(columnOffset45); fromMarker23.Append(rowId45); fromMarker23.Append(rowOffset45); Xdr.ToMarker toMarker23 = new Xdr.ToMarker(); Xdr.ColumnId columnId46 = new Xdr.ColumnId(); columnId46.Text = "13"; Xdr.ColumnOffset columnOffset46 = new Xdr.ColumnOffset(); columnOffset46.Text = "771525"; Xdr.RowId rowId46 = new Xdr.RowId(); rowId46.Text = "7"; Xdr.RowOffset rowOffset46 = new Xdr.RowOffset(); rowOffset46.Text = "47625"; toMarker23.Append(columnId46); toMarker23.Append(columnOffset46); toMarker23.Append(rowId46); toMarker23.Append(rowOffset46); AlternateContent alternateContent22 = new AlternateContent(); alternateContent22.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); alternateContent22.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main"); AlternateContentChoice alternateContentChoice22 = new AlternateContentChoice(){ Requires = "a15" }; Xdr.GraphicFrame graphicFrame23 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties23 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties33 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)4U, Name = "DeliveryDate 4" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties23 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties23.Append(nonVisualDrawingProperties33); nonVisualGraphicFrameProperties23.Append(nonVisualGraphicFrameDrawingProperties23); Xdr.Transform transform23 = new Xdr.Transform(); A.Offset offset33 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents33 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform23.Append(offset33); transform23.Append(extents33); A.Graphic graphic23 = new A.Graphic(); A.GraphicData graphicData23 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" }; Tsle.TimeSlicer timeSlicer11 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 4" }; timeSlicer11.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer"); graphicData23.Append(timeSlicer11); graphic23.Append(graphicData23); graphicFrame23.Append(nonVisualGraphicFrameProperties23); graphicFrame23.Append(transform23); graphicFrame23.Append(graphic23); alternateContentChoice22.Append(graphicFrame23); AlternateContentFallback alternateContentFallback21 = new AlternateContentFallback(); alternateContentFallback21.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); alternateContentFallback21.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); Xdr.Shape shape11 = new Xdr.Shape(){ Macro = "", TextLink = "" }; Xdr.NonVisualShapeProperties nonVisualShapeProperties11 = new Xdr.NonVisualShapeProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties34 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" }; Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties11 = new Xdr.NonVisualShapeDrawingProperties(); A.ShapeLocks shapeLocks11 = new A.ShapeLocks(){ NoTextEdit = true }; nonVisualShapeDrawingProperties11.Append(shapeLocks11); nonVisualShapeProperties11.Append(nonVisualDrawingProperties34); nonVisualShapeProperties11.Append(nonVisualShapeDrawingProperties11); Xdr.ShapeProperties shapeProperties43 = new Xdr.ShapeProperties(); A.Transform2D transform2D11 = new A.Transform2D(); A.Offset offset34 = new A.Offset(){ X = 8639175L, Y = 190500L }; A.Extents extents34 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L }; transform2D11.Append(offset34); transform2D11.Append(extents34); A.PresetGeometry presetGeometry11 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle }; A.AdjustValueList adjustValueList11 = new A.AdjustValueList(); presetGeometry11.Append(adjustValueList11); A.SolidFill solidFill77 = new A.SolidFill(); A.PresetColor presetColor21 = new A.PresetColor(){ Val = A.PresetColorValues.White }; solidFill77.Append(presetColor21); A.Outline outline63 = new A.Outline(){ Width = 1 }; A.SolidFill solidFill78 = new A.SolidFill(); A.PresetColor presetColor22 = new A.PresetColor(){ Val = A.PresetColorValues.Green }; solidFill78.Append(presetColor22); outline63.Append(solidFill78); shapeProperties43.Append(transform2D11); shapeProperties43.Append(presetGeometry11); shapeProperties43.Append(solidFill77); shapeProperties43.Append(outline63); Xdr.TextBody textBody11 = new Xdr.TextBody(); A.BodyProperties bodyProperties27 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip }; A.ListStyle listStyle27 = new A.ListStyle(); A.Paragraph paragraph27 = new A.Paragraph(); A.Run run11 = new A.Run(); A.RunProperties runProperties11 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 }; A.Text text49 = new A.Text(); text49.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize."; run11.Append(runProperties11); run11.Append(text49); paragraph27.Append(run11); textBody11.Append(bodyProperties27); textBody11.Append(listStyle27); textBody11.Append(paragraph27); shape11.Append(nonVisualShapeProperties11); shape11.Append(shapeProperties43); shape11.Append(textBody11); alternateContentFallback21.Append(shape11); alternateContent22.Append(alternateContentChoice22); alternateContent22.Append(alternateContentFallback21); Xdr.ClientData clientData23 = new Xdr.ClientData(); twoCellAnchor23.Append(fromMarker23); twoCellAnchor23.Append(toMarker23); twoCellAnchor23.Append(alternateContent22); twoCellAnchor23.Append(clientData23); Xdr.TwoCellAnchor twoCellAnchor24 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell }; Xdr.FromMarker fromMarker24 = new Xdr.FromMarker(); Xdr.ColumnId columnId47 = new Xdr.ColumnId(); columnId47.Text = "10"; Xdr.ColumnOffset columnOffset47 = new Xdr.ColumnOffset(); columnOffset47.Text = "47625"; Xdr.RowId rowId47 = new Xdr.RowId(); rowId47.Text = "8"; Xdr.RowOffset rowOffset47 = new Xdr.RowOffset(); rowOffset47.Text = "85725"; fromMarker24.Append(columnId47); fromMarker24.Append(columnOffset47); fromMarker24.Append(rowId47); fromMarker24.Append(rowOffset47); Xdr.ToMarker toMarker24 = new Xdr.ToMarker(); Xdr.ColumnId columnId48 = new Xdr.ColumnId(); columnId48.Text = "13"; Xdr.ColumnOffset columnOffset48 = new Xdr.ColumnOffset(); columnOffset48.Text = "781050"; Xdr.RowId rowId48 = new Xdr.RowId(); rowId48.Text = "14"; Xdr.RowOffset rowOffset48 = new Xdr.RowOffset(); rowOffset48.Text = "133350"; toMarker24.Append(columnId48); toMarker24.Append(columnOffset48); toMarker24.Append(rowId48); toMarker24.Append(rowOffset48); AlternateContent alternateContent23 = new AlternateContent(); alternateContent23.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); alternateContent23.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main"); AlternateContentChoice alternateContentChoice23 = new AlternateContentChoice(){ Requires = "a15" }; Xdr.GraphicFrame graphicFrame24 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties24 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties35 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)5U, Name = "DeliveryDate 5" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties24 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties24.Append(nonVisualDrawingProperties35); nonVisualGraphicFrameProperties24.Append(nonVisualGraphicFrameDrawingProperties24); Xdr.Transform transform24 = new Xdr.Transform(); A.Offset offset35 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents35 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform24.Append(offset35); transform24.Append(extents35); A.Graphic graphic24 = new A.Graphic(); A.GraphicData graphicData24 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" }; Tsle.TimeSlicer timeSlicer12 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 5" }; timeSlicer12.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer"); graphicData24.Append(timeSlicer12); graphic24.Append(graphicData24); graphicFrame24.Append(nonVisualGraphicFrameProperties24); graphicFrame24.Append(transform24); graphicFrame24.Append(graphic24); alternateContentChoice23.Append(graphicFrame24); AlternateContentFallback alternateContentFallback22 = new AlternateContentFallback(); alternateContentFallback22.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); alternateContentFallback22.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); Xdr.Shape shape12 = new Xdr.Shape(){ Macro = "", TextLink = "" }; Xdr.NonVisualShapeProperties nonVisualShapeProperties12 = new Xdr.NonVisualShapeProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties36 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" }; Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties12 = new Xdr.NonVisualShapeDrawingProperties(); A.ShapeLocks shapeLocks12 = new A.ShapeLocks(){ NoTextEdit = true }; nonVisualShapeDrawingProperties12.Append(shapeLocks12); nonVisualShapeProperties12.Append(nonVisualDrawingProperties36); nonVisualShapeProperties12.Append(nonVisualShapeDrawingProperties12); Xdr.ShapeProperties shapeProperties44 = new Xdr.ShapeProperties(); A.Transform2D transform2D12 = new A.Transform2D(); A.Offset offset36 = new A.Offset(){ X = 8648700L, Y = 1609725L }; A.Extents extents36 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L }; transform2D12.Append(offset36); transform2D12.Append(extents36); A.PresetGeometry presetGeometry12 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle }; A.AdjustValueList adjustValueList12 = new A.AdjustValueList(); presetGeometry12.Append(adjustValueList12); A.SolidFill solidFill79 = new A.SolidFill(); A.PresetColor presetColor23 = new A.PresetColor(){ Val = A.PresetColorValues.White }; solidFill79.Append(presetColor23); A.Outline outline64 = new A.Outline(){ Width = 1 }; A.SolidFill solidFill80 = new A.SolidFill(); A.PresetColor presetColor24 = new A.PresetColor(){ Val = A.PresetColorValues.Green }; solidFill80.Append(presetColor24); outline64.Append(solidFill80); shapeProperties44.Append(transform2D12); shapeProperties44.Append(presetGeometry12); shapeProperties44.Append(solidFill79); shapeProperties44.Append(outline64); Xdr.TextBody textBody12 = new Xdr.TextBody(); A.BodyProperties bodyProperties28 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip }; A.ListStyle listStyle28 = new A.ListStyle(); A.Paragraph paragraph28 = new A.Paragraph(); A.Run run12 = new A.Run(); A.RunProperties runProperties12 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 }; A.Text text50 = new A.Text(); text50.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize."; run12.Append(runProperties12); run12.Append(text50); paragraph28.Append(run12); textBody12.Append(bodyProperties28); textBody12.Append(listStyle28); textBody12.Append(paragraph28); shape12.Append(nonVisualShapeProperties12); shape12.Append(shapeProperties44); shape12.Append(textBody12); alternateContentFallback22.Append(shape12); alternateContent23.Append(alternateContentChoice23); alternateContent23.Append(alternateContentFallback22); Xdr.ClientData clientData24 = new Xdr.ClientData(); twoCellAnchor24.Append(fromMarker24); twoCellAnchor24.Append(toMarker24); twoCellAnchor24.Append(alternateContent23); twoCellAnchor24.Append(clientData24); worksheetDrawing6.Append(twoCellAnchor21); worksheetDrawing6.Append(twoCellAnchor22); worksheetDrawing6.Append(twoCellAnchor23); worksheetDrawing6.Append(twoCellAnchor24); drawingsPart6.WorksheetDrawing = worksheetDrawing6; }
// Generates content of drawingsPart5. private void GenerateDrawingsPart5Content(DrawingsPart drawingsPart5) { Xdr.WorksheetDrawing worksheetDrawing5 = new Xdr.WorksheetDrawing(); worksheetDrawing5.AddNamespaceDeclaration("xdr", "http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing"); worksheetDrawing5.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main"); Xdr.TwoCellAnchor twoCellAnchor17 = new Xdr.TwoCellAnchor(); Xdr.FromMarker fromMarker17 = new Xdr.FromMarker(); Xdr.ColumnId columnId33 = new Xdr.ColumnId(); columnId33.Text = "2"; Xdr.ColumnOffset columnOffset33 = new Xdr.ColumnOffset(); columnOffset33.Text = "185737"; Xdr.RowId rowId33 = new Xdr.RowId(); rowId33.Text = "0"; Xdr.RowOffset rowOffset33 = new Xdr.RowOffset(); rowOffset33.Text = "0"; fromMarker17.Append(columnId33); fromMarker17.Append(columnOffset33); fromMarker17.Append(rowId33); fromMarker17.Append(rowOffset33); Xdr.ToMarker toMarker17 = new Xdr.ToMarker(); Xdr.ColumnId columnId34 = new Xdr.ColumnId(); columnId34.Text = "9"; Xdr.ColumnOffset columnOffset34 = new Xdr.ColumnOffset(); columnOffset34.Text = "90487"; Xdr.RowId rowId34 = new Xdr.RowId(); rowId34.Text = "14"; Xdr.RowOffset rowOffset34 = new Xdr.RowOffset(); rowOffset34.Text = "76200"; toMarker17.Append(columnId34); toMarker17.Append(columnOffset34); toMarker17.Append(rowId34); toMarker17.Append(rowOffset34); Xdr.GraphicFrame graphicFrame17 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties17 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties25 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)2U, Name = "Chart 1" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties17 = new Xdr.NonVisualGraphicFrameDrawingProperties(); A.GraphicFrameLocks graphicFrameLocks7 = new A.GraphicFrameLocks(); nonVisualGraphicFrameDrawingProperties17.Append(graphicFrameLocks7); nonVisualGraphicFrameProperties17.Append(nonVisualDrawingProperties25); nonVisualGraphicFrameProperties17.Append(nonVisualGraphicFrameDrawingProperties17); Xdr.Transform transform17 = new Xdr.Transform(); A.Offset offset25 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents25 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform17.Append(offset25); transform17.Append(extents25); A.Graphic graphic17 = new A.Graphic(); A.GraphicData graphicData17 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" }; C.ChartReference chartReference9 = new C.ChartReference(){ Id = "rId1" }; chartReference9.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); chartReference9.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); graphicData17.Append(chartReference9); graphic17.Append(graphicData17); graphicFrame17.Append(nonVisualGraphicFrameProperties17); graphicFrame17.Append(transform17); graphicFrame17.Append(graphic17); Xdr.ClientData clientData17 = new Xdr.ClientData(); twoCellAnchor17.Append(fromMarker17); twoCellAnchor17.Append(toMarker17); twoCellAnchor17.Append(graphicFrame17); twoCellAnchor17.Append(clientData17); Xdr.TwoCellAnchor twoCellAnchor18 = new Xdr.TwoCellAnchor(); Xdr.FromMarker fromMarker18 = new Xdr.FromMarker(); Xdr.ColumnId columnId35 = new Xdr.ColumnId(); columnId35.Text = "2"; Xdr.ColumnOffset columnOffset35 = new Xdr.ColumnOffset(); columnOffset35.Text = "200025"; Xdr.RowId rowId35 = new Xdr.RowId(); rowId35.Text = "14"; Xdr.RowOffset rowOffset35 = new Xdr.RowOffset(); rowOffset35.Text = "147637"; fromMarker18.Append(columnId35); fromMarker18.Append(columnOffset35); fromMarker18.Append(rowId35); fromMarker18.Append(rowOffset35); Xdr.ToMarker toMarker18 = new Xdr.ToMarker(); Xdr.ColumnId columnId36 = new Xdr.ColumnId(); columnId36.Text = "7"; Xdr.ColumnOffset columnOffset36 = new Xdr.ColumnOffset(); columnOffset36.Text = "476250"; Xdr.RowId rowId36 = new Xdr.RowId(); rowId36.Text = "29"; Xdr.RowOffset rowOffset36 = new Xdr.RowOffset(); rowOffset36.Text = "33337"; toMarker18.Append(columnId36); toMarker18.Append(columnOffset36); toMarker18.Append(rowId36); toMarker18.Append(rowOffset36); Xdr.GraphicFrame graphicFrame18 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties18 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties26 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)3U, Name = "グラフ 2" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties18 = new Xdr.NonVisualGraphicFrameDrawingProperties(); A.GraphicFrameLocks graphicFrameLocks8 = new A.GraphicFrameLocks(); nonVisualGraphicFrameDrawingProperties18.Append(graphicFrameLocks8); nonVisualGraphicFrameProperties18.Append(nonVisualDrawingProperties26); nonVisualGraphicFrameProperties18.Append(nonVisualGraphicFrameDrawingProperties18); Xdr.Transform transform18 = new Xdr.Transform(); A.Offset offset26 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents26 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform18.Append(offset26); transform18.Append(extents26); A.Graphic graphic18 = new A.Graphic(); A.GraphicData graphicData18 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" }; C.ChartReference chartReference10 = new C.ChartReference(){ Id = "rId2" }; chartReference10.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); chartReference10.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); graphicData18.Append(chartReference10); graphic18.Append(graphicData18); graphicFrame18.Append(nonVisualGraphicFrameProperties18); graphicFrame18.Append(transform18); graphicFrame18.Append(graphic18); Xdr.ClientData clientData18 = new Xdr.ClientData(); twoCellAnchor18.Append(fromMarker18); twoCellAnchor18.Append(toMarker18); twoCellAnchor18.Append(graphicFrame18); twoCellAnchor18.Append(clientData18); Xdr.TwoCellAnchor twoCellAnchor19 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell }; Xdr.FromMarker fromMarker19 = new Xdr.FromMarker(); Xdr.ColumnId columnId37 = new Xdr.ColumnId(); columnId37.Text = "10"; Xdr.ColumnOffset columnOffset37 = new Xdr.ColumnOffset(); columnOffset37.Text = "19050"; Xdr.RowId rowId37 = new Xdr.RowId(); rowId37.Text = "1"; Xdr.RowOffset rowOffset37 = new Xdr.RowOffset(); rowOffset37.Text = "19050"; fromMarker19.Append(columnId37); fromMarker19.Append(columnOffset37); fromMarker19.Append(rowId37); fromMarker19.Append(rowOffset37); Xdr.ToMarker toMarker19 = new Xdr.ToMarker(); Xdr.ColumnId columnId38 = new Xdr.ColumnId(); columnId38.Text = "13"; Xdr.ColumnOffset columnOffset38 = new Xdr.ColumnOffset(); columnOffset38.Text = "752475"; Xdr.RowId rowId38 = new Xdr.RowId(); rowId38.Text = "7"; Xdr.RowOffset rowOffset38 = new Xdr.RowOffset(); rowOffset38.Text = "66675"; toMarker19.Append(columnId38); toMarker19.Append(columnOffset38); toMarker19.Append(rowId38); toMarker19.Append(rowOffset38); AlternateContent alternateContent18 = new AlternateContent(); alternateContent18.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); alternateContent18.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main"); AlternateContentChoice alternateContentChoice18 = new AlternateContentChoice(){ Requires = "a15" }; Xdr.GraphicFrame graphicFrame19 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties19 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties27 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)4U, Name = "DeliveryDate 16" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties19 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties19.Append(nonVisualDrawingProperties27); nonVisualGraphicFrameProperties19.Append(nonVisualGraphicFrameDrawingProperties19); Xdr.Transform transform19 = new Xdr.Transform(); A.Offset offset27 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents27 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform19.Append(offset27); transform19.Append(extents27); A.Graphic graphic19 = new A.Graphic(); A.GraphicData graphicData19 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" }; Tsle.TimeSlicer timeSlicer9 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 16" }; timeSlicer9.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer"); graphicData19.Append(timeSlicer9); graphic19.Append(graphicData19); graphicFrame19.Append(nonVisualGraphicFrameProperties19); graphicFrame19.Append(transform19); graphicFrame19.Append(graphic19); alternateContentChoice18.Append(graphicFrame19); AlternateContentFallback alternateContentFallback17 = new AlternateContentFallback(); alternateContentFallback17.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); alternateContentFallback17.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); Xdr.Shape shape9 = new Xdr.Shape(){ Macro = "", TextLink = "" }; Xdr.NonVisualShapeProperties nonVisualShapeProperties9 = new Xdr.NonVisualShapeProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties28 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" }; Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties9 = new Xdr.NonVisualShapeDrawingProperties(); A.ShapeLocks shapeLocks9 = new A.ShapeLocks(){ NoTextEdit = true }; nonVisualShapeDrawingProperties9.Append(shapeLocks9); nonVisualShapeProperties9.Append(nonVisualDrawingProperties28); nonVisualShapeProperties9.Append(nonVisualShapeDrawingProperties9); Xdr.ShapeProperties shapeProperties30 = new Xdr.ShapeProperties(); A.Transform2D transform2D9 = new A.Transform2D(); A.Offset offset28 = new A.Offset(){ X = 8620125L, Y = 209550L }; A.Extents extents28 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L }; transform2D9.Append(offset28); transform2D9.Append(extents28); A.PresetGeometry presetGeometry9 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle }; A.AdjustValueList adjustValueList9 = new A.AdjustValueList(); presetGeometry9.Append(adjustValueList9); A.SolidFill solidFill56 = new A.SolidFill(); A.PresetColor presetColor17 = new A.PresetColor(){ Val = A.PresetColorValues.White }; solidFill56.Append(presetColor17); A.Outline outline45 = new A.Outline(){ Width = 1 }; A.SolidFill solidFill57 = new A.SolidFill(); A.PresetColor presetColor18 = new A.PresetColor(){ Val = A.PresetColorValues.Green }; solidFill57.Append(presetColor18); outline45.Append(solidFill57); shapeProperties30.Append(transform2D9); shapeProperties30.Append(presetGeometry9); shapeProperties30.Append(solidFill56); shapeProperties30.Append(outline45); Xdr.TextBody textBody9 = new Xdr.TextBody(); A.BodyProperties bodyProperties21 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip }; A.ListStyle listStyle21 = new A.ListStyle(); A.Paragraph paragraph21 = new A.Paragraph(); A.Run run9 = new A.Run(); A.RunProperties runProperties9 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 }; A.Text text47 = new A.Text(); text47.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize."; run9.Append(runProperties9); run9.Append(text47); paragraph21.Append(run9); textBody9.Append(bodyProperties21); textBody9.Append(listStyle21); textBody9.Append(paragraph21); shape9.Append(nonVisualShapeProperties9); shape9.Append(shapeProperties30); shape9.Append(textBody9); alternateContentFallback17.Append(shape9); alternateContent18.Append(alternateContentChoice18); alternateContent18.Append(alternateContentFallback17); Xdr.ClientData clientData19 = new Xdr.ClientData(); twoCellAnchor19.Append(fromMarker19); twoCellAnchor19.Append(toMarker19); twoCellAnchor19.Append(alternateContent18); twoCellAnchor19.Append(clientData19); Xdr.TwoCellAnchor twoCellAnchor20 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell }; Xdr.FromMarker fromMarker20 = new Xdr.FromMarker(); Xdr.ColumnId columnId39 = new Xdr.ColumnId(); columnId39.Text = "10"; Xdr.ColumnOffset columnOffset39 = new Xdr.ColumnOffset(); columnOffset39.Text = "9525"; Xdr.RowId rowId39 = new Xdr.RowId(); rowId39.Text = "9"; Xdr.RowOffset rowOffset39 = new Xdr.RowOffset(); rowOffset39.Text = "19050"; fromMarker20.Append(columnId39); fromMarker20.Append(columnOffset39); fromMarker20.Append(rowId39); fromMarker20.Append(rowOffset39); Xdr.ToMarker toMarker20 = new Xdr.ToMarker(); Xdr.ColumnId columnId40 = new Xdr.ColumnId(); columnId40.Text = "13"; Xdr.ColumnOffset columnOffset40 = new Xdr.ColumnOffset(); columnOffset40.Text = "742950"; Xdr.RowId rowId40 = new Xdr.RowId(); rowId40.Text = "15"; Xdr.RowOffset rowOffset40 = new Xdr.RowOffset(); rowOffset40.Text = "66675"; toMarker20.Append(columnId40); toMarker20.Append(columnOffset40); toMarker20.Append(rowId40); toMarker20.Append(rowOffset40); AlternateContent alternateContent19 = new AlternateContent(); alternateContent19.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); alternateContent19.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main"); AlternateContentChoice alternateContentChoice19 = new AlternateContentChoice(){ Requires = "a15" }; Xdr.GraphicFrame graphicFrame20 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties20 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties29 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)5U, Name = "DeliveryDate 17" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties20 = new Xdr.NonVisualGraphicFrameDrawingProperties(); nonVisualGraphicFrameProperties20.Append(nonVisualDrawingProperties29); nonVisualGraphicFrameProperties20.Append(nonVisualGraphicFrameDrawingProperties20); Xdr.Transform transform20 = new Xdr.Transform(); A.Offset offset29 = new A.Offset(){ X = 0L, Y = 0L }; A.Extents extents29 = new A.Extents(){ Cx = 0L, Cy = 0L }; transform20.Append(offset29); transform20.Append(extents29); A.Graphic graphic20 = new A.Graphic(); A.GraphicData graphicData20 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" }; Tsle.TimeSlicer timeSlicer10 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 17" }; timeSlicer10.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer"); graphicData20.Append(timeSlicer10); graphic20.Append(graphicData20); graphicFrame20.Append(nonVisualGraphicFrameProperties20); graphicFrame20.Append(transform20); graphicFrame20.Append(graphic20); alternateContentChoice19.Append(graphicFrame20); AlternateContentFallback alternateContentFallback18 = new AlternateContentFallback(); alternateContentFallback18.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); alternateContentFallback18.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); Xdr.Shape shape10 = new Xdr.Shape(){ Macro = "", TextLink = "" }; Xdr.NonVisualShapeProperties nonVisualShapeProperties10 = new Xdr.NonVisualShapeProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties30 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" }; Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties10 = new Xdr.NonVisualShapeDrawingProperties(); A.ShapeLocks shapeLocks10 = new A.ShapeLocks(){ NoTextEdit = true }; nonVisualShapeDrawingProperties10.Append(shapeLocks10); nonVisualShapeProperties10.Append(nonVisualDrawingProperties30); nonVisualShapeProperties10.Append(nonVisualShapeDrawingProperties10); Xdr.ShapeProperties shapeProperties31 = new Xdr.ShapeProperties(); A.Transform2D transform2D10 = new A.Transform2D(); A.Offset offset30 = new A.Offset(){ X = 8610600L, Y = 1733550L }; A.Extents extents30 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L }; transform2D10.Append(offset30); transform2D10.Append(extents30); A.PresetGeometry presetGeometry10 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle }; A.AdjustValueList adjustValueList10 = new A.AdjustValueList(); presetGeometry10.Append(adjustValueList10); A.SolidFill solidFill58 = new A.SolidFill(); A.PresetColor presetColor19 = new A.PresetColor(){ Val = A.PresetColorValues.White }; solidFill58.Append(presetColor19); A.Outline outline46 = new A.Outline(){ Width = 1 }; A.SolidFill solidFill59 = new A.SolidFill(); A.PresetColor presetColor20 = new A.PresetColor(){ Val = A.PresetColorValues.Green }; solidFill59.Append(presetColor20); outline46.Append(solidFill59); shapeProperties31.Append(transform2D10); shapeProperties31.Append(presetGeometry10); shapeProperties31.Append(solidFill58); shapeProperties31.Append(outline46); Xdr.TextBody textBody10 = new Xdr.TextBody(); A.BodyProperties bodyProperties22 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip }; A.ListStyle listStyle22 = new A.ListStyle(); A.Paragraph paragraph22 = new A.Paragraph(); A.Run run10 = new A.Run(); A.RunProperties runProperties10 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 }; A.Text text48 = new A.Text(); text48.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize."; run10.Append(runProperties10); run10.Append(text48); paragraph22.Append(run10); textBody10.Append(bodyProperties22); textBody10.Append(listStyle22); textBody10.Append(paragraph22); shape10.Append(nonVisualShapeProperties10); shape10.Append(shapeProperties31); shape10.Append(textBody10); alternateContentFallback18.Append(shape10); alternateContent19.Append(alternateContentChoice19); alternateContent19.Append(alternateContentFallback18); Xdr.ClientData clientData20 = new Xdr.ClientData(); twoCellAnchor20.Append(fromMarker20); twoCellAnchor20.Append(toMarker20); twoCellAnchor20.Append(alternateContent19); twoCellAnchor20.Append(clientData20); worksheetDrawing5.Append(twoCellAnchor17); worksheetDrawing5.Append(twoCellAnchor18); worksheetDrawing5.Append(twoCellAnchor19); worksheetDrawing5.Append(twoCellAnchor20); drawingsPart5.WorksheetDrawing = worksheetDrawing5; }