private void CheckRowGrowth(Borders border) { var aliveCellGroupCount = CurrentGeneration.GetConsecutiveHorizontalCellCount(border); if (aliveCellGroupCount >= 1) { AddRow(border); } }
private void CheckColumnGrowth(Borders border) { var aliveCellGroupCount = CurrentGeneration.GetConsecutiveVerticalCellCount(border); if (aliveCellGroupCount >= 1) { AddColumn(border); } }
/// <summary> /// Calculates bottom border width of a cell. /// </summary> /// <param name="cell"> The cell the bottom border of the row that is probed. </param> /// <returns> The calculated border width. </returns> private XUnit CalcBottomBorderWidth(Cell cell) { Borders borders = _mergedCells.GetEffectiveBorders(cell); if (borders != null) { BordersRenderer bordersRenderer = new BordersRenderer(borders, _gfx); return(bordersRenderer.GetWidth(BorderType.Bottom)); } return(0); }
private void RenderBorders(Cell cell, Rectangle innerRect) { XUnit leftPos = innerRect.X; XUnit rightPos = leftPos + innerRect.Width; XUnit topPos = innerRect.Y; XUnit bottomPos = innerRect.Y + innerRect.Height; Borders mergedBorders = _mergedCells.GetEffectiveBorders(cell); BordersRenderer bordersRenderer = new BordersRenderer(mergedBorders, _gfx); XUnit bottomWidth = bordersRenderer.GetWidth(BorderType.Bottom); XUnit leftWidth = bordersRenderer.GetWidth(BorderType.Left); XUnit topWidth = bordersRenderer.GetWidth(BorderType.Top); XUnit rightWidth = bordersRenderer.GetWidth(BorderType.Right); if (cell.RoundedCorner == RoundedCorner.TopLeft) { bordersRenderer.RenderRounded(cell.RoundedCorner, innerRect.X, innerRect.Y, innerRect.Width + rightWidth, innerRect.Height + bottomWidth); } else if (cell.RoundedCorner == RoundedCorner.TopRight) { bordersRenderer.RenderRounded(cell.RoundedCorner, innerRect.X - leftWidth, innerRect.Y, innerRect.Width + leftWidth, innerRect.Height + bottomWidth); } else if (cell.RoundedCorner == RoundedCorner.BottomLeft) { bordersRenderer.RenderRounded(cell.RoundedCorner, innerRect.X, innerRect.Y - topWidth, innerRect.Width + rightWidth, innerRect.Height + topWidth); } else if (cell.RoundedCorner == RoundedCorner.BottomRight) { bordersRenderer.RenderRounded(cell.RoundedCorner, innerRect.X - leftWidth, innerRect.Y - topWidth, innerRect.Width + leftWidth, innerRect.Height + topWidth); } // Render horizontal and vertical borders only if touching no rounded corner. if (cell.RoundedCorner != RoundedCorner.TopRight && cell.RoundedCorner != RoundedCorner.BottomRight) { bordersRenderer.RenderVertically(BorderType.Right, rightPos, topPos, bottomPos + bottomWidth - topPos); } if (cell.RoundedCorner != RoundedCorner.TopLeft && cell.RoundedCorner != RoundedCorner.BottomLeft) { bordersRenderer.RenderVertically(BorderType.Left, leftPos - leftWidth, topPos, bottomPos + bottomWidth - topPos); } if (cell.RoundedCorner != RoundedCorner.BottomLeft && cell.RoundedCorner != RoundedCorner.BottomRight) { bordersRenderer.RenderHorizontally(BorderType.Bottom, leftPos - leftWidth, bottomPos, rightPos + rightWidth + leftWidth - leftPos); } if (cell.RoundedCorner != RoundedCorner.TopLeft && cell.RoundedCorner != RoundedCorner.TopRight) { bordersRenderer.RenderHorizontally(BorderType.Top, leftPos - leftWidth, topPos - topWidth, rightPos + rightWidth + leftWidth - leftPos); } RenderDiagonalBorders(mergedBorders, innerRect); }
protected void method_28(object A_0) { Borders borders = (Borders)A_0; if (!borders.IsDefault) { this.method_27(SprmCode.PBrcLeft, borders.Left, 8f); this.method_27(SprmCode.PBrcTop, borders.Top, 8f); this.method_27(SprmCode.PBrcBottom, borders.Bottom, 8f); this.method_27(SprmCode.PBrcRight, borders.Right, 8f); } }
public static Borders GetTopMediumBorder() { var borders = new Borders() { Top = new Border() { Style = "SOLID_MEDIUM" } }; return(borders); }
public static Borders GetTopBorder() { var borders = new Borders() { Top = new Border() { Style = "SOLID" } }; return(borders); }
public static Borders GetBottomMediumBorder() { var borders = new Borders() { Bottom = new Border() { Style = "SOLID_MEDIUM" } }; return(borders); }
/// <summary> /// Returns the trimmed line at which the borders of the two rects collides /// </summary> /// <param name="secondRect"></param> /// <returns></returns> public Line2?BorderIntersection(AxisAlignedRectangle secondRect) { if (IntersectsWith(secondRect)) { throw new ArgumentException("Rects are overlapping"); } return (Borders.SelectMany(a => secondRect.Borders.Select(b => new { A = a, B = b })) .Select(pair => pair.A.GetIntersectionLine(pair.B)) .Where(line => line.HasValue && !line.Value.IsPoint) .FirstOrDefault(line => line.HasValue)); }
public static Borders GetBottomBorder() { var borders = new Borders() { Bottom = new Border() { Style = "SOLID" } }; return(borders); }
public void dibujar_reporte(Range rango) { //rango.EntireColumn.AutoFit(); rango.Interior.ColorIndex = 15; rango.Font.Bold = true; Borders borde = rango.Borders; borde[XlBordersIndex.xlEdgeTop].LineStyle = XlLineStyle.xlContinuous; borde[XlBordersIndex.xlEdgeRight].LineStyle = XlLineStyle.xlContinuous; borde[XlBordersIndex.xlEdgeBottom].LineStyle = XlLineStyle.xlContinuous; borde[XlBordersIndex.xlEdgeLeft].LineStyle = XlLineStyle.xlContinuous; }
/// <summary> /// Sets borders of AreaCalculator equally to borders of the Viewport. The borders are written into the borders parameter. /// </summary> /// <param name="cam">The camera which is used to set the borders.</param> /// <param name="borders"></param> private void InitializeBordersFromCamera(Camera cam) { borders = new Borders { bottomLeft = cam.ViewportToWorldPoint(new Vector3(0, 0, cam.nearClipPlane)), topLeft = cam.ViewportToWorldPoint(new Vector3(0, 1, cam.nearClipPlane)), topRight = cam.ViewportToWorldPoint(new Vector3(1, 1, cam.nearClipPlane)), bottomRight = cam.ViewportToWorldPoint(new Vector3(1, 0, cam.nearClipPlane)) }; //if (debugMode) DebugBorders(); }
public void AddRow(Borders border) { switch (border) { case Borders.Top: Rows.Insert(0, Factory.Instance.GetNewRow(ColumnCount)); break; case Borders.Bottom: Rows.Add(Factory.Instance.GetNewRow(ColumnCount)); break; } }
private void CalculateBorders(HeapCell aCell, long aAddress, Size aDimensions) { long remainingBoxes = (aCell.EndAddress - aAddress) / SymbianUtils.RawItems.RawItem.KSizeOfOneRawItemInBytes; // Start with no borders Borders.Reset(); // How many boxes are left to render on this row int remainingBoxesForThisLine = (aDimensions.Width - BoxCoordinates.X); // Its the first line if we are drawing the first row, or if we're drawing the // second row and there weren't any boxes from this heap cell directly above us // in the grid. bool firstLine = (CellRowIndex == 0); if (CellRowIndex == 1) { int numberOfBoxesDrawnOnPreviousLine = (CellBoxIndex - BoxCoordinates.X); int xPosOfFirstBox = aDimensions.Width - numberOfBoxesDrawnOnPreviousLine; firstLine = (BoxCoordinates.X < xPosOfFirstBox); } Borders.SetBorder(THeapCellBorderType.ETop, firstLine); // Its the last line if we are drawing the last row, or then if we're drawing // the last-but-one row and there weren't any boxes from this heap cell directly // below us in the grid. bool lastLine = (RemainingBoxes <= remainingBoxesForThisLine); if (RemainingRows > 0 && BoxCoordinates.Y == aDimensions.Height - 1) { lastLine = true; } else if (RemainingRows == 1) { // Now we need to work out how many boxes of the next row will be // required to finish rendering it fully. lastLine = (BoxCoordinates.X >= RemainingBoxesAfterThisRow); } Borders.SetBorder(THeapCellBorderType.EBottom, lastLine); // Its the first box if it is the absolute first box we have rendered for a given // cell, or then it is the first box in a new row. bool firstBox = (CellBoxIndex == 0) || (BoxCoordinates.X == 0); Borders.SetBorder(THeapCellBorderType.ELeft, firstBox); // Its the last box if it is the absolute last box we have rendered for a given // cell, or then it is the last box in a new row. bool lastBox = (CellBoxIndex == CellBoxCount - 1) || (remainingBoxes == 0) || (BoxCoordinates.X == aDimensions.Width - 1); Borders.SetBorder(THeapCellBorderType.ERight, lastBox); }
public CustomStylesheet() { // blank font list var fonts = new Fonts(); fonts.AppendChild(new Font()); fonts.Count = 1; Append(fonts); // create fills var fills = new Fills(); // create a solid blue fill var solidBlue = new PatternFill() { PatternType = PatternValues.Solid }; solidBlue.ForegroundColor = new ForegroundColor { Rgb = HexBinaryValue.FromString("397FDB") }; // blue fill solidBlue.BackgroundColor = new BackgroundColor { Indexed = 64 }; fills.AppendChild(new Fill { PatternFill = new PatternFill { PatternType = PatternValues.None } }); // required, reserved by Excel fills.AppendChild(new Fill { PatternFill = new PatternFill { PatternType = PatternValues.Gray125 } }); // required, reserved by Excel fills.AppendChild(new Fill { PatternFill = solidBlue }); fills.Count = 3; Append(fills); // blank border list var borders = new Borders(); borders.AppendChild(new Border()); borders.AppendChild(new Border() { TopBorder = new TopBorder() { Style = BorderStyleValues.Thin }, RightBorder = new RightBorder() { Style = BorderStyleValues.Thin }, BottomBorder = new BottomBorder() { Style = BorderStyleValues.Thin }, LeftBorder = new LeftBorder() { Style = BorderStyleValues.Thin } }); borders.Count = 2; Append(borders); // blank cell format list var cellStyleFormats = new CellStyleFormats(); cellStyleFormats.AppendChild(new CellFormat()); cellStyleFormats.Count = 1; Append(cellStyleFormats); // cell format list var cellFormats = new CellFormats(); // empty one for index 0, seems to be required cellFormats.AppendChild(new CellFormat()); // cell format default with border cellFormats.AppendChild(new CellFormat() { FormatId = 0, FontId = 0, BorderId = 1, FillId = 0 }).AppendChild(new Alignment() { WrapText = true }); // cell format for header (blue with border) cellFormats.AppendChild(new CellFormat { FormatId = 0, FontId = 0, BorderId = 1, FillId = 2, ApplyFill = true }).AppendChild(new Alignment { Horizontal = HorizontalAlignmentValues.Center }); cellFormats.Count = 2; Append(cellFormats); }
private static void ClearRange(Range rangeToClean) { Borders bordersToClean = rangeToClean.Borders; bordersToClean[XlBordersIndex.xlEdgeLeft].LineStyle = XlLineStyle.xlContinuous; bordersToClean[XlBordersIndex.xlEdgeRight].LineStyle = XlLineStyle.xlContinuous; bordersToClean[XlBordersIndex.xlEdgeTop].LineStyle = XlLineStyle.xlContinuous; bordersToClean[XlBordersIndex.xlEdgeBottom].LineStyle = XlLineStyle.xlContinuous; bordersToClean.Color = XlRgbColor.rgbBlack; rangeToClean.Formula = string.Empty; rangeToClean.Font.Color = XlRgbColor.rgbBlack; rangeToClean.Interior.Pattern = XlPattern.xlPatternNone; }
private void TestAddColumn(Borders border) { const int expectedOldColumnCount = 3; const int expectedNewColumnCount = 4; var board = Factory.Instance.GetNewBoard(3, 3); var oldColumnCount = board.ColumnCount; board.AddColumn(border); var newColumnCount = board.ColumnCount; Assert.True(expectedOldColumnCount.Equals(oldColumnCount) && expectedNewColumnCount.Equals(newColumnCount)); }
public void ShowDialogAndSetWindowSize(Process p, bool topMost) { this.TopMost = topMost; this.process = p; this.oldRectangle = Borders.GetWindowRectangle(p); textBoxX.Text = oldRectangle.X.ToString(); textBoxY.Text = oldRectangle.Y.ToString(); textBoxHeight.Text = (oldRectangle.Height - oldRectangle.Y).ToString(); textBoxWidth.Text = (oldRectangle.Width - oldRectangle.X).ToString(); this.ShowDialog(); }
public void ClassifyEdge() { var compatiblity = new List <int>(); foreach (var tile in _tiles) { var tilesThatCanBeAdjacent = _tiles.Where(t => t.Id != tile.Id && tile.CouldBeAdjacentOf(t)).ToList(); var emptyBorder = 4 - tilesThatCanBeAdjacent.Count; if (Width == 1 || Height == 1) { if (emptyBorder == 3) { Corners.Add(tile); } else { if (emptyBorder == 2) { Borders.Add(tile); } else { if (Width == 1 && Height == 1) { Corners.Add(tile); } } } } else { if (emptyBorder == 2) { Corners.Add(tile); tile.MarkAsCorner(tilesThatCanBeAdjacent); } else { if (emptyBorder == 1) { Borders.Add(tile); tile.MarkAsBorder(tilesThatCanBeAdjacent); } else { tile.MarkAsInsidePiece(tilesThatCanBeAdjacent); } } } } }
/// <summary> Creates the stylesheet. </summary> /// /// <returns> The new stylesheet. </returns> private static Stylesheet CreateStylesheet() { Stylesheet stylesheet = new Stylesheet(); Font font0 = new Font(); // Default font Font font1 = new Font(); // Bold font Bold bold = new Bold(); font1.Append(bold); Fonts fonts = new Fonts(); // <APENDING Fonts> fonts.Append(font0); fonts.Append(font1); // <Fills> Fill fill0 = new Fill(); // Default fill Fills fills = new Fills(); // <APENDING Fills> fills.Append(fill0); // <Borders> Border border0 = new Border(); // Defualt border Borders borders = new Borders(); // <APENDING Borders> borders.Append(border0); CellFormat cellformat0 = new CellFormat() { FontId = 0, FillId = 0, BorderId = 0 }; // Default style : Mandatory | Style ID =0 CellFormat cellformat1 = new CellFormat() { FontId = 1 }; CellFormats cellformats = new CellFormats(); cellformats.Append(cellformat0); cellformats.Append(cellformat1); stylesheet.Append(fonts); stylesheet.Append(fills); stylesheet.Append(borders); stylesheet.Append(cellformats); return(stylesheet); }
public void SetBorderBetween(Borders border) { CT_PBdr ctpBrd = this.GetCTPBrd(true); CT_Border ctBorder = ctpBrd.IsSetBetween() ? ctpBrd.between : ctpBrd.AddNewBetween(); if (border == Borders.NONE) { ctpBrd.UnsetBetween(); } else { ctBorder.val = EnumConverter.ValueOf <ST_Border, Borders>(border); } }
private float method_164(int A_0, int A_1, int A_2, int A_3) { Borders borders = this.tableCell_0.CellFormat.Borders; Borders borders2 = this.tableCell_0.OwnerRow.OwnerTable.TableFormat.Borders; float num = borders.Bottom.LineWidth / 2f; if (this.tableCell_0.OwnerRow.OwnerTable.TableFormat.CellSpacingEx > 0f) { return(((borders.Bottom.BorderType != BorderStyle.None) ? borders.Bottom.LineWidth : borders2.Horizontal.LineWidth) / 2f); } int num2 = this.method_170(A_0, A_2, A_3); if (A_2 >= A_3) { return(((borders.Bottom.BorderType != BorderStyle.None) ? borders.Bottom.LineWidth : borders2.Bottom.LineWidth) / 2f); } int num3 = this.method_168(this.tableCell_0, A_0, num2); TableCell cell = this.method_166(num2); if ((borders.Bottom.BorderType != BorderStyle.None) && cell.CellFormat.Borders.Top.IsBorderDefined) { this.method_137(this.method_167(borders.Bottom.LineWidth, cell.CellFormat.Borders.Top.LineWidth, false, ref num)); } else if (borders.Bottom.BorderType != BorderStyle.None) { this.method_137(this.method_167(borders.Bottom.LineWidth, borders2.Horizontal.LineWidth, false, ref num)); } else if (cell.CellFormat.Borders.Top.IsBorderDefined) { this.method_137(this.method_167(borders2.Horizontal.LineWidth, cell.CellFormat.Borders.Top.LineWidth, false, ref num)); } else if ((borders.Bottom.BorderType == BorderStyle.None) && borders.Bottom.HasNoneStyle) { this.method_137(true); num = 0f; } else { num = borders2.Horizontal.LineWidth / 2f; } if (borders.Bottom.BorderType != BorderStyle.None) { this.method_137(borders.Bottom.BorderType == BorderStyle.Cleared); } if ((this.method_136() && (this.tableCell_0.OwnerRow.OwnerTable.Rows[num2].Cells[num3].Width < this.tableCell_0.Width)) && (borders.Bottom.BorderType != BorderStyle.None)) { this.method_137(false); } return(num); }
public void SetBorderTop(Borders border) { CT_PBdr ctpBrd = this.GetCTPBrd(true); CT_Border ctBorder = ctpBrd == null || !ctpBrd.IsSetTop() ? ctpBrd.AddNewTop() : ctpBrd.top; if (border == Borders.NONE) { ctpBrd.UnsetTop(); } else { ctBorder.val = EnumConverter.ValueOf <ST_Border, Borders>(border); } }
public void border(Excel.Application myExcelApp) { Range currentSelection = myExcelApp.ActiveWindow.RangeSelection; Borders border = currentSelection.Borders; if (border.LineStyle == 1) //Excel.XlLineStyle.xlContinuous { border.LineStyle = Excel.XlLineStyle.xlLineStyleNone; } else { border.LineStyle = Excel.XlLineStyle.xlContinuous; } }
public bool checkEqualBorders(Borders border1, Borders border2) { ABIW_Borders aBIW_Borders1 = new ABIW_Borders(border1); ABIW_Borders aBIW_Borders2 = new ABIW_Borders(border2); if (aBIW_Borders1.Compare(aBIW_Borders2).Result == ComparisonResultIndicate.equal) { return(true); } else { return(false); } }
/// <summary> /// Displays executable data in a box to the right of a screen /// </summary> /// <param name="executable">The executable to be displayed</param> public void DisplayExecutableSettings(ExecutableData executable) { Location boxLocation = new Location(40, 4); int height = 5; int rightPadding = 3; List <Tuple <string, string, int> > boxLines = new List <Tuple <string, string, int> >() { new Tuple <string, string, int>("Executable path: ", executable.ExecutablePath, 1), new Tuple <string, string, int>("Shortcut name: ", executable.ShortcutName, height - 1), new Tuple <string, string, int>("Create desktop shortcut: ", executable.OnDesktop.ToString(), height) }; Borders borders = new Borders(true) { TopStyle = "*", LeftStyle = "-|", RightStyle = "|-", BottomStyle = "*" }; Location bottomRightOfBox = new Location(Console.WindowWidth - rightPadding, boxLocation.Y + height + borders.TopStyle.Length + borders.BottomStyle.Length + 1); FormattedWriteSettings writeSettings = new FormattedWriteSettings { MaximumWidth = bottomRightOfBox.X - boxLocation.X, InnerPadding = new Padding(0, borders.LeftStyle.Length + 1, borders.RightStyle.Length + 1, 0), ResetCursorPosition = true, NewLine = false }; ConsoleUtils.CreateBox(boxLocation, bottomRightOfBox, borders); for (int i = 0; i < boxLines.Count; ++i) { writeSettings.Location = new Location(boxLocation.X, boxLocation.Y + boxLines[i].Item3); if (i < boxLines.Count - 1) { writeSettings.MaximumHeight = boxLines[i + 1].Item3 - boxLines[i].Item3; } else { writeSettings.MaximumHeight = height - boxLines[i].Item3 + 1; } ConsoleUtils.FormattedWrite(boxLines[i].Item1, writeSettings); writeSettings.Location.X += boxLines[i].Item1.Length; writeSettings.MaximumWidth -= boxLines[i].Item1.Length; ConsoleUtils.FormattedWrite(boxLines[i].Item2, writeSettings); writeSettings.MaximumWidth += boxLines[i].Item1.Length; } }
/// <summary> /// Returns the border of the given borders-object of the specified type (top, bottom, ...). /// If that border doesn't exist, it returns a new border object that inherits all properties from the given borders object /// </summary> private Border GetBorderFromBorders(Borders borders, BorderType type) { Border returnBorder = borders.GetValue(type.ToString(), GV.ReadOnly) as Border; if (returnBorder == null) { returnBorder = new Border(); returnBorder.style = borders.style; returnBorder.width = borders.width; returnBorder.color = borders.color; returnBorder.visible = borders.visible; } return(returnBorder); }
private void ButtonApply_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(textBoxHeight.Text) || string.IsNullOrWhiteSpace(textBoxWidth.Text) || string.IsNullOrWhiteSpace(textBoxX.Text) || string.IsNullOrWhiteSpace(textBoxY.Text)) { MessageBox.Show(LocalizedMessageProvider.GetMessage("SET_HEIGHT_WIDTH"), LocalizedMessageProvider.GetMessage("ERROR"), MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } Borders.EditWindow(process, int.Parse(textBoxX.Text), int.Parse(textBoxY.Text), int.Parse(textBoxHeight.Text), int.Parse(textBoxWidth.Text)); Close(); }
/// <summary> /// Returns the border of the given borders-object of the specified type (top, bottom, ...). /// If that border doesn't exist, it returns a new border object that inherits all properties from the given borders object /// </summary> private static Border GetBorderFromBorders(Borders borders, BorderType type) { Border returnBorder = borders.GetBorderReadOnly(type); if (returnBorder == null) { returnBorder = new Border(); returnBorder._style = borders._style; returnBorder._width = borders._width; returnBorder._color = borders._color; returnBorder._visible = borders._visible; } return(returnBorder); }
//Hàm kẻ khung cho Excel private void BorderAround(Range range) { Borders borders = range.Borders; borders[XlBordersIndex.xlEdgeLeft].LineStyle = XlLineStyle.xlContinuous; borders[XlBordersIndex.xlEdgeTop].LineStyle = XlLineStyle.xlContinuous; borders[XlBordersIndex.xlEdgeBottom].LineStyle = XlLineStyle.xlContinuous; borders[XlBordersIndex.xlEdgeRight].LineStyle = XlLineStyle.xlContinuous; borders.Color = Color.Black; borders[XlBordersIndex.xlInsideVertical].LineStyle = XlLineStyle.xlContinuous; borders[XlBordersIndex.xlInsideHorizontal].LineStyle = XlLineStyle.xlContinuous; borders[XlBordersIndex.xlDiagonalUp].LineStyle = XlLineStyle.xlLineStyleNone; borders[XlBordersIndex.xlDiagonalDown].LineStyle = XlLineStyle.xlLineStyleNone; }
private void DrawAllSolidBorders(Range range, int colour) { Borders borders = range.Borders; borders.Color = colour; borders[XlBordersIndex.xlDiagonalDown].LineStyle = XlLineStyle.xlLineStyleNone; borders[XlBordersIndex.xlDiagonalUp].LineStyle = XlLineStyle.xlLineStyleNone; borders[XlBordersIndex.xlEdgeLeft].LineStyle = XlLineStyle.xlContinuous; borders[XlBordersIndex.xlEdgeTop].LineStyle = XlLineStyle.xlContinuous; borders[XlBordersIndex.xlEdgeBottom].LineStyle = XlLineStyle.xlContinuous; borders[XlBordersIndex.xlEdgeRight].LineStyle = XlLineStyle.xlContinuous; borders[XlBordersIndex.xlInsideVertical].LineStyle = XlLineStyle.xlContinuous; borders[XlBordersIndex.xlInsideHorizontal].LineStyle = XlLineStyle.xlContinuous; }
private void Button_Click(object sender, RoutedEventArgs e) { // 每次点击此按钮会将当前呈现的图片移除视觉树,再将其Source属性设置为null。 // 然后新建一个Image控件,并将其Source属性设置为RenderTargetBitmap对象,再呈现出来。 // 再次过程中,RenderTargetBitmap对象从来不会被回收,造成内存泄露。 // 可以从资源管理其中观察到程序的内存持续上涨的现象。 // Remove the current Image control from the visual tree and set source is null when click button. // Then new a image control and add source to the RenderTargetBitmap object and show it. // You can see the gc never delete the RenderTargetBitmap object that make memory leak. var oldBorder = RootGrid.Children.OfType <Border>().LastOrDefault(); if (oldBorder != null) { var oldImage = (Image)oldBorder.Child; // 如果在Image控件移除视觉树之前将其Source属性设为null,并调用UpdateLayout方法。 // 则RenderTargetBitmap对象可被回收,不会导致内存泄露。 // 取消注释下面的代码可以观察到上述现象。 // In order to solve it , you should set the image.Source is null and use UpdateLayout. // The below code can solve it. // oldImage.Source = null; // oldImage.UpdateLayout(); // 将当前的Image控件移除视觉树。 // Remove the current Image control from the visual tree. RootGrid.Children.Remove(oldBorder); oldImage.Source = null; Borders.Add(oldBorder); } var bitmap = new RenderTargetBitmap(1024, 1024, 96, 96, PixelFormats.Default); var image = new Image { Source = bitmap }; var border = new Border { Child = image }; RootGrid.Children.Add(border); // 为了便于观察内存的变化,每次操作后都会进行垃圾回收。 // In order to facilitate changes in memory, after each operation will be garbage collection GC.Collect(); }
private static Borders CreateBorders() { var borders = new Borders(); // boarder index 0 borders.AppendChild(new Border { LeftBorder = new LeftBorder(), RightBorder = new RightBorder(), TopBorder = new TopBorder(), BottomBorder = new BottomBorder(), DiagonalBorder = new DiagonalBorder() }); // boarder Index 1 borders.AppendChild(new Border { LeftBorder = new LeftBorder { Style = BorderStyleValues.Thin }, RightBorder = new RightBorder { Style = BorderStyleValues.Thin }, TopBorder = new TopBorder { Style = BorderStyleValues.Thin }, BottomBorder = new BottomBorder { Style = BorderStyleValues.Thin }, DiagonalBorder = new DiagonalBorder() }); // boarder Index 2 borders.AppendChild(new Border { LeftBorder = new LeftBorder(), RightBorder = new RightBorder(), TopBorder = new TopBorder { Style = BorderStyleValues.Thin }, BottomBorder = new BottomBorder { Style = BorderStyleValues.Thin }, DiagonalBorder = new DiagonalBorder() }); borders.Count = UInt32Value.FromUInt32((uint)borders.ChildElements.Count); return(borders); }
public void AddColumn(Borders border) { foreach (var cells in Rows.Where(row => null != row).Select(row => row.Cells).Where(cells => null != cells)) { switch (border) { case Borders.Left: cells.Insert(0, Factory.Instance.GetNewCell()); break; case Borders.Right: cells.Add(Factory.Instance.GetNewCell()); break; } } }
public int GetConsecutiveVerticalCellCount(Borders border) { if (null == Rows || 0 == Rows.Count) return 0; var lookUpIndex = GetLookUpIndex(border); if (lookUpIndex == -1) return 0; var count = 0; var rowCount = Rows.Count; for (var i = 0; i < rowCount - 2; ++i) { if (!ValidColumnCells(i)) continue; if (this[i, lookUpIndex].IsAlive && this[i + 1, lookUpIndex].IsAlive && this[i + 2, lookUpIndex].IsAlive) count++; } return count; }
public int GetConsecutiveHorizontalCellCount(Borders border) { if (null == Rows || Rows.Count == 0 || null == Rows[0]) return 0; var columnCount = Rows[0].ColumnCount; if (columnCount < 3) return 0; var lookUpIndex = GetLookUpIndex(border); if (lookUpIndex == -1) return 0; var count = 0; for (var i = 0; i < columnCount - 2; ++i) { if (this[lookUpIndex, i].IsAlive && this[lookUpIndex, i + 1].IsAlive && this[lookUpIndex, i + 2].IsAlive) count++; } return count; }
public static ShapeDescription DrawRectangularOutline(Vector3 position, Size size, int borderSize, Color4[] colors, BorderStyle borderStyle, Borders borders) { ShapeDescription vBorderTop = default(ShapeDescription); ShapeDescription vBorderSideL = default(ShapeDescription); ShapeDescription vBorderSideR = default(ShapeDescription); ShapeDescription vBorderBottom = default(ShapeDescription); Vector3 innerPositionTopLeft = new Vector3( position.X + borderSize, position.Y - borderSize, position.Z); Vector3 borderPositionTopRight = new Vector3( position.X + size.Width - borderSize, position.Y, position.Z); Vector3 borderPositionBottomLeft = new Vector3( position.X, position.Y - size.Height + borderSize, position.Z); Size borderTop = new Size(size.Width, borderSize); Size borderSide = new Size(borderSize, size.Height); Color4 cLeft = colors[0]; Color4 cTop = colors[1]; Color4 cBottom = colors[2]; Color4 cRight = colors[3]; if ((borders & Borders.Top) != 0) vBorderTop = DrawRectangle(position, borderTop, cTop); if ((borders & Borders.Left) != 0) vBorderSideL = DrawRectangle(position, borderSide, cLeft); if ((borders & Borders.Right) != 0) vBorderSideR = DrawRectangle(borderPositionTopRight, borderSide, cRight); if ((borders & Borders.Bottom) != 0) vBorderBottom = DrawRectangle(borderPositionBottomLeft, borderTop, cBottom); switch (borderStyle) { case BorderStyle.Flat: case BorderStyle.Raised: return ShapeDescription.Join(vBorderSideL, vBorderTop, vBorderSideR, vBorderBottom); case BorderStyle.Sunken: return ShapeDescription.Join(vBorderSideL, vBorderSideR, vBorderTop, vBorderBottom); default: throw Error.WrongCase("borderStyle", "DrawRectangularOutline", borderStyle); } }
public GetDataButton(Borders border, double opacity = 0) { BackgroundColor = Color.Transparent; TextColor = Color.White; FontSize = 18; Opacity = opacity; FontFamily = Device.OnPlatform( iOS: "Segoe-UI", Android: "Droid Sans Mono", WinPhone: "Comic Sans MS" ); switch(border){ case Borders.None: break; case Borders.Thin: BorderRadius = 3; BorderColor = MyColors.Turqoise; BorderWidth = 1; break; } }
internal LoginButton(Borders border, double opacity = 0) { BackgroundColor = Color.Transparent; TextColor = Color.White; FontSize = 18; Opacity = opacity; FontFamily = Device.OnPlatform( iOS: "AppleSDGothicNeo-Light", Android: "Droid Sans Mono", WinPhone: "Comic Sans MS" ); switch (border) { case Borders.None: break; case Borders.Thin: BorderRadius = 3; BorderColor = Color.White; BorderWidth = 1; break; } }
public static Borders GetBorderWidth (CreateParams cp) { Borders border_size = new Borders (); Size windowborder = ThemeEngine.Current.BorderSize; /*new Size (1, 1);*/ // This is the only one that can be changed from the display properties in windows. Size border = ThemeEngine.Current.BorderStaticSize; /*new Size (1, 1);*/ Size clientedge = ThemeEngine.Current.Border3DSize; /*new Size (2, 2);*/ Size thickframe = new Size (2 + windowborder.Width, 2 + windowborder.Height); Size dialogframe = ThemeEngine.Current.BorderSizableSize; /* new Size (3, 3);*/ if (cp.IsSet (WindowStyles.WS_CAPTION)) { border_size.Inflate (dialogframe); } else if (cp.IsSet (WindowStyles.WS_BORDER)) { if (cp.IsSet (WindowExStyles.WS_EX_DLGMODALFRAME)) { if (cp.IsSet (WindowStyles.WS_THICKFRAME) && (cp.IsSet (WindowExStyles.WS_EX_STATICEDGE) || cp.IsSet (WindowExStyles.WS_EX_CLIENTEDGE))) { border_size.Inflate (border); } } else { border_size.Inflate (border); } } else if (cp.IsSet (WindowStyles.WS_DLGFRAME)) { border_size.Inflate (dialogframe); } if (cp.IsSet (WindowStyles.WS_THICKFRAME)) { if (cp.IsSet (WindowStyles.WS_DLGFRAME)) { border_size.Inflate (border); } else { border_size.Inflate (thickframe); } } bool only_small_border; Size small_border = Size.Empty; only_small_border = cp.IsSet (WindowStyles.WS_THICKFRAME) || cp.IsSet (WindowStyles.WS_DLGFRAME); if (only_small_border && cp.IsSet (WindowStyles.WS_THICKFRAME) && !cp.IsSet (WindowStyles.WS_BORDER) && !cp.IsSet (WindowStyles.WS_DLGFRAME)) { small_border = border; } if (cp.IsSet (WindowExStyles.WS_EX_CLIENTEDGE | WindowExStyles.WS_EX_DLGMODALFRAME)) { border_size.Inflate (clientedge + (only_small_border ? small_border : dialogframe)); } else if (cp.IsSet (WindowExStyles.WS_EX_STATICEDGE | WindowExStyles.WS_EX_DLGMODALFRAME)) { border_size.Inflate (only_small_border ? small_border : dialogframe); } else if (cp.IsSet (WindowExStyles.WS_EX_STATICEDGE | WindowExStyles.WS_EX_CLIENTEDGE)) { border_size.Inflate (border + (only_small_border ? Size.Empty : clientedge)); } else { if (cp.IsSet (WindowExStyles.WS_EX_CLIENTEDGE)) { border_size.Inflate (clientedge); } if (cp.IsSet (WindowExStyles.WS_EX_DLGMODALFRAME) && !cp.IsSet (WindowStyles.WS_DLGFRAME)) { border_size.Inflate (cp.IsSet (WindowStyles.WS_THICKFRAME) ? border : dialogframe); } if (cp.IsSet (WindowExStyles.WS_EX_STATICEDGE)) { if (cp.IsSet (WindowStyles.WS_THICKFRAME) || cp.IsSet (WindowStyles.WS_DLGFRAME)) { border_size.Inflate (new Size (-border.Width, -border.Height)); } else { border_size.Inflate (border); } } } return border_size; }
// Generates content of workbookStylesPart1. private void GenerateWorkbookStylesPart1Content(WorkbookStylesPart workbookStylesPart1) { Stylesheet stylesheet1 = new Stylesheet(); NumberingFormats numberingFormats1 = new NumberingFormats() { Count = (UInt32Value)2U }; NumberingFormat numberingFormat1 = new NumberingFormat() { NumberFormatId = (UInt32Value)44U, FormatCode = "_ \"$\"\\ * #,##0.00_ ;_ \"$\"\\ * \\-#,##0.00_ ;_ \"$\"\\ * \"-\"??_ ;_ @_ " }; NumberingFormat numberingFormat2 = new NumberingFormat() { NumberFormatId = (UInt32Value)165U, FormatCode = "mmmm/yyyy" }; numberingFormats1.Append(numberingFormat1); numberingFormats1.Append(numberingFormat2); Fonts fonts1 = new Fonts() { Count = (UInt32Value)10U }; Font font1 = new Font(); FontSize fontSize1 = new FontSize() { Val = 10D }; FontName fontName1 = new FontName() { Val = "Arial" }; font1.Append(fontSize1); font1.Append(fontName1); Font font2 = new Font(); FontSize fontSize2 = new FontSize() { Val = 10D }; FontName fontName2 = new FontName() { Val = "Arial" }; font2.Append(fontSize2); font2.Append(fontName2); Font font3 = new Font(); Bold bold1 = new Bold(); FontSize fontSize3 = new FontSize() { Val = 10D }; FontName fontName3 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering1 = new FontFamilyNumbering() { Val = 2 }; font3.Append(bold1); font3.Append(fontSize3); font3.Append(fontName3); font3.Append(fontFamilyNumbering1); Font font4 = new Font(); Bold bold2 = new Bold(); FontSize fontSize4 = new FontSize() { Val = 10D }; Color color1 = new Color() { Indexed = (UInt32Value)9U }; FontName fontName4 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering2 = new FontFamilyNumbering() { Val = 2 }; font4.Append(bold2); font4.Append(fontSize4); font4.Append(color1); font4.Append(fontName4); font4.Append(fontFamilyNumbering2); Font font5 = new Font(); FontSize fontSize5 = new FontSize() { Val = 8D }; FontName fontName5 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering3 = new FontFamilyNumbering() { Val = 2 }; font5.Append(fontSize5); font5.Append(fontName5); font5.Append(fontFamilyNumbering3); Font font6 = new Font(); Bold bold3 = new Bold(); FontSize fontSize6 = new FontSize() { Val = 8D }; FontName fontName6 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering4 = new FontFamilyNumbering() { Val = 2 }; font6.Append(bold3); font6.Append(fontSize6); font6.Append(fontName6); font6.Append(fontFamilyNumbering4); Font font7 = new Font(); Bold bold4 = new Bold(); FontSize fontSize7 = new FontSize() { Val = 15D }; FontName fontName7 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering5 = new FontFamilyNumbering() { Val = 2 }; font7.Append(bold4); font7.Append(fontSize7); font7.Append(fontName7); font7.Append(fontFamilyNumbering5); Font font8 = new Font(); FontSize fontSize8 = new FontSize() { Val = 10D }; FontName fontName8 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering6 = new FontFamilyNumbering() { Val = 2 }; font8.Append(fontSize8); font8.Append(fontName8); font8.Append(fontFamilyNumbering6); Font font9 = new Font(); FontSize fontSize9 = new FontSize() { Val = 8D }; FontName fontName9 = new FontName() { Val = "Arial" }; font9.Append(fontSize9); font9.Append(fontName9); Font font10 = new Font(); Bold bold5 = new Bold(); FontSize fontSize10 = new FontSize() { Val = 10D }; Color color2 = new Color() { Indexed = (UInt32Value)12U }; FontName fontName10 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering7 = new FontFamilyNumbering() { Val = 2 }; font10.Append(bold5); font10.Append(fontSize10); font10.Append(color2); font10.Append(fontName10); font10.Append(fontFamilyNumbering7); fonts1.Append(font1); fonts1.Append(font2); fonts1.Append(font3); fonts1.Append(font4); fonts1.Append(font5); fonts1.Append(font6); fonts1.Append(font7); fonts1.Append(font8); fonts1.Append(font9); fonts1.Append(font10); Fills fills1 = new Fills() { Count = (UInt32Value)6U }; Fill fill1 = new Fill(); PatternFill patternFill1 = new PatternFill() { PatternType = PatternValues.None }; fill1.Append(patternFill1); Fill fill2 = new Fill(); PatternFill patternFill2 = new PatternFill() { PatternType = PatternValues.Gray125 }; fill2.Append(patternFill2); Fill fill3 = new Fill(); PatternFill patternFill3 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor1 = new ForegroundColor() { Indexed = (UInt32Value)23U }; BackgroundColor backgroundColor1 = new BackgroundColor() { Indexed = (UInt32Value)64U }; patternFill3.Append(foregroundColor1); patternFill3.Append(backgroundColor1); fill3.Append(patternFill3); Fill fill4 = new Fill(); PatternFill patternFill4 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor2 = new ForegroundColor() { Indexed = (UInt32Value)9U }; BackgroundColor backgroundColor2 = new BackgroundColor() { Indexed = (UInt32Value)64U }; patternFill4.Append(foregroundColor2); patternFill4.Append(backgroundColor2); fill4.Append(patternFill4); Fill fill5 = new Fill(); PatternFill patternFill5 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor3 = new ForegroundColor() { Indexed = (UInt32Value)10U }; BackgroundColor backgroundColor3 = new BackgroundColor() { Indexed = (UInt32Value)26U }; patternFill5.Append(foregroundColor3); patternFill5.Append(backgroundColor3); fill5.Append(patternFill5); Fill fill6 = new Fill(); PatternFill patternFill6 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor4 = new ForegroundColor() { Indexed = (UInt32Value)10U }; BackgroundColor backgroundColor4 = new BackgroundColor() { Indexed = (UInt32Value)64U }; patternFill6.Append(foregroundColor4); patternFill6.Append(backgroundColor4); fill6.Append(patternFill6); fills1.Append(fill1); fills1.Append(fill2); fills1.Append(fill3); fills1.Append(fill4); fills1.Append(fill5); fills1.Append(fill6); Borders borders1 = new Borders() { Count = (UInt32Value)11U }; Border border1 = new Border(); LeftBorder leftBorder1 = new LeftBorder(); RightBorder rightBorder1 = new RightBorder(); TopBorder topBorder1 = new TopBorder(); BottomBorder bottomBorder1 = new BottomBorder(); DiagonalBorder diagonalBorder1 = new DiagonalBorder(); border1.Append(leftBorder1); border1.Append(rightBorder1); border1.Append(topBorder1); border1.Append(bottomBorder1); border1.Append(diagonalBorder1); Border border2 = new Border(); LeftBorder leftBorder2 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color3 = new Color() { Indexed = (UInt32Value)64U }; leftBorder2.Append(color3); RightBorder rightBorder2 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color4 = new Color() { Indexed = (UInt32Value)64U }; rightBorder2.Append(color4); TopBorder topBorder2 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color5 = new Color() { Indexed = (UInt32Value)64U }; topBorder2.Append(color5); BottomBorder bottomBorder2 = new BottomBorder(); DiagonalBorder diagonalBorder2 = new DiagonalBorder(); border2.Append(leftBorder2); border2.Append(rightBorder2); border2.Append(topBorder2); border2.Append(bottomBorder2); border2.Append(diagonalBorder2); Border border3 = new Border(); LeftBorder leftBorder3 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color6 = new Color() { Indexed = (UInt32Value)64U }; leftBorder3.Append(color6); RightBorder rightBorder3 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color7 = new Color() { Indexed = (UInt32Value)64U }; rightBorder3.Append(color7); TopBorder topBorder3 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color8 = new Color() { Indexed = (UInt32Value)64U }; topBorder3.Append(color8); BottomBorder bottomBorder3 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color9 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder3.Append(color9); DiagonalBorder diagonalBorder3 = new DiagonalBorder(); border3.Append(leftBorder3); border3.Append(rightBorder3); border3.Append(topBorder3); border3.Append(bottomBorder3); border3.Append(diagonalBorder3); Border border4 = new Border(); LeftBorder leftBorder4 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color10 = new Color() { Indexed = (UInt32Value)64U }; leftBorder4.Append(color10); RightBorder rightBorder4 = new RightBorder(); TopBorder topBorder4 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color11 = new Color() { Indexed = (UInt32Value)64U }; topBorder4.Append(color11); BottomBorder bottomBorder4 = new BottomBorder(); DiagonalBorder diagonalBorder4 = new DiagonalBorder(); border4.Append(leftBorder4); border4.Append(rightBorder4); border4.Append(topBorder4); border4.Append(bottomBorder4); border4.Append(diagonalBorder4); Border border5 = new Border(); LeftBorder leftBorder5 = new LeftBorder(); RightBorder rightBorder5 = new RightBorder(); TopBorder topBorder5 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color12 = new Color() { Indexed = (UInt32Value)64U }; topBorder5.Append(color12); BottomBorder bottomBorder5 = new BottomBorder(); DiagonalBorder diagonalBorder5 = new DiagonalBorder(); border5.Append(leftBorder5); border5.Append(rightBorder5); border5.Append(topBorder5); border5.Append(bottomBorder5); border5.Append(diagonalBorder5); Border border6 = new Border(); LeftBorder leftBorder6 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color13 = new Color() { Indexed = (UInt32Value)64U }; leftBorder6.Append(color13); RightBorder rightBorder6 = new RightBorder(); TopBorder topBorder6 = new TopBorder(); BottomBorder bottomBorder6 = new BottomBorder(); DiagonalBorder diagonalBorder6 = new DiagonalBorder(); border6.Append(leftBorder6); border6.Append(rightBorder6); border6.Append(topBorder6); border6.Append(bottomBorder6); border6.Append(diagonalBorder6); Border border7 = new Border(); LeftBorder leftBorder7 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color14 = new Color() { Indexed = (UInt32Value)64U }; leftBorder7.Append(color14); RightBorder rightBorder7 = new RightBorder(); TopBorder topBorder7 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color15 = new Color() { Indexed = (UInt32Value)64U }; topBorder7.Append(color15); BottomBorder bottomBorder7 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color16 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder7.Append(color16); DiagonalBorder diagonalBorder7 = new DiagonalBorder(); border7.Append(leftBorder7); border7.Append(rightBorder7); border7.Append(topBorder7); border7.Append(bottomBorder7); border7.Append(diagonalBorder7); Border border8 = new Border(); LeftBorder leftBorder8 = new LeftBorder(); RightBorder rightBorder8 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color17 = new Color() { Indexed = (UInt32Value)64U }; rightBorder8.Append(color17); TopBorder topBorder8 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color18 = new Color() { Indexed = (UInt32Value)64U }; topBorder8.Append(color18); BottomBorder bottomBorder8 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color19 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder8.Append(color19); DiagonalBorder diagonalBorder8 = new DiagonalBorder(); border8.Append(leftBorder8); border8.Append(rightBorder8); border8.Append(topBorder8); border8.Append(bottomBorder8); border8.Append(diagonalBorder8); Border border9 = new Border(); LeftBorder leftBorder9 = new LeftBorder(); RightBorder rightBorder9 = new RightBorder(); TopBorder topBorder9 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color20 = new Color() { Indexed = (UInt32Value)64U }; topBorder9.Append(color20); BottomBorder bottomBorder9 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color21 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder9.Append(color21); DiagonalBorder diagonalBorder9 = new DiagonalBorder(); border9.Append(leftBorder9); border9.Append(rightBorder9); border9.Append(topBorder9); border9.Append(bottomBorder9); border9.Append(diagonalBorder9); Border border10 = new Border(); LeftBorder leftBorder10 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color22 = new Color() { Indexed = (UInt32Value)64U }; leftBorder10.Append(color22); RightBorder rightBorder10 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color23 = new Color() { Indexed = (UInt32Value)64U }; rightBorder10.Append(color23); TopBorder topBorder10 = new TopBorder(); BottomBorder bottomBorder10 = new BottomBorder(); DiagonalBorder diagonalBorder10 = new DiagonalBorder(); border10.Append(leftBorder10); border10.Append(rightBorder10); border10.Append(topBorder10); border10.Append(bottomBorder10); border10.Append(diagonalBorder10); Border border11 = new Border(); LeftBorder leftBorder11 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color24 = new Color() { Indexed = (UInt32Value)64U }; leftBorder11.Append(color24); RightBorder rightBorder11 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color25 = new Color() { Indexed = (UInt32Value)64U }; rightBorder11.Append(color25); TopBorder topBorder11 = new TopBorder(); BottomBorder bottomBorder11 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color26 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder11.Append(color26); DiagonalBorder diagonalBorder11 = new DiagonalBorder(); border11.Append(leftBorder11); border11.Append(rightBorder11); border11.Append(topBorder11); border11.Append(bottomBorder11); border11.Append(diagonalBorder11); borders1.Append(border1); borders1.Append(border2); borders1.Append(border3); borders1.Append(border4); borders1.Append(border5); borders1.Append(border6); borders1.Append(border7); borders1.Append(border8); borders1.Append(border9); borders1.Append(border10); borders1.Append(border11); CellStyleFormats cellStyleFormats1 = new CellStyleFormats() { Count = (UInt32Value)2U }; CellFormat cellFormat1 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U }; CellFormat cellFormat2 = new CellFormat() { NumberFormatId = (UInt32Value)44U, FontId = (UInt32Value)1U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, ApplyFont = false, ApplyFill = false, ApplyBorder = false, ApplyAlignment = false, ApplyProtection = false }; cellStyleFormats1.Append(cellFormat1); cellStyleFormats1.Append(cellFormat2); CellFormats cellFormats1 = new CellFormats() { Count = (UInt32Value)64U }; CellFormat cellFormat3 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U }; CellFormat cellFormat4 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFill = true }; CellFormat cellFormat5 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true }; CellFormat cellFormat6 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true }; CellFormat cellFormat7 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)4U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true }; CellFormat cellFormat8 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)4U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true }; CellFormat cellFormat9 = new CellFormat() { NumberFormatId = (UInt32Value)49U, FontId = (UInt32Value)4U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true }; CellFormat cellFormat10 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)4U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment1 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat10.Append(alignment1); CellFormat cellFormat11 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment2 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat11.Append(alignment2); CellFormat cellFormat12 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment3 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat12.Append(alignment3); CellFormat cellFormat13 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)3U, FormatId = (UInt32Value)0U, ApplyBorder = true }; CellFormat cellFormat14 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true }; CellFormat cellFormat15 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)4U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)5U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true }; CellFormat cellFormat16 = new CellFormat() { NumberFormatId = (UInt32Value)49U, FontId = (UInt32Value)4U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment4 = new Alignment() { Horizontal = HorizontalAlignmentValues.Left }; cellFormat16.Append(alignment4); CellFormat cellFormat17 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)4U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment5 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right }; cellFormat17.Append(alignment5); CellFormat cellFormat18 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)6U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true }; CellFormat cellFormat19 = new CellFormat() { NumberFormatId = (UInt32Value)49U, FontId = (UInt32Value)4U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment6 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right }; cellFormat19.Append(alignment6); CellFormat cellFormat20 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)5U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true }; CellFormat cellFormat21 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true }; CellFormat cellFormat22 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)7U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)6U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment7 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right }; cellFormat22.Append(alignment7); CellFormat cellFormat23 = new CellFormat() { NumberFormatId = (UInt32Value)1U, FontId = (UInt32Value)2U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)7U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment8 = new Alignment() { Horizontal = HorizontalAlignmentValues.Left }; cellFormat23.Append(alignment8); CellFormat cellFormat24 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)8U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)8U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true }; CellFormat cellFormat25 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)4U, BorderId = (UInt32Value)9U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment9 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat25.Append(alignment9); CellFormat cellFormat26 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)5U, BorderId = (UInt32Value)10U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment10 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat26.Append(alignment10); CellFormat cellFormat27 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)2U, FillId = (UInt32Value)4U, BorderId = (UInt32Value)10U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true }; CellFormat cellFormat28 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)2U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment11 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat28.Append(alignment11); CellFormat cellFormat29 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)5U, BorderId = (UInt32Value)9U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment12 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat29.Append(alignment12); CellFormat cellFormat30 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)2U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true }; CellFormat cellFormat31 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)1U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment13 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat31.Append(alignment13); CellFormat cellFormat32 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)3U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)1U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment14 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat32.Append(alignment14); CellFormat cellFormat33 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFill = true, ApplyBorder = true }; CellFormat cellFormat34 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)2U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)1U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment15 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat34.Append(alignment15); CellFormat cellFormat35 = new CellFormat() { NumberFormatId = (UInt32Value)49U, FontId = (UInt32Value)2U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment16 = new Alignment() { Horizontal = HorizontalAlignmentValues.Left, Vertical = VerticalAlignmentValues.Top }; cellFormat35.Append(alignment16); CellFormat cellFormat36 = new CellFormat() { NumberFormatId = (UInt32Value)49U, FontId = (UInt32Value)9U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment17 = new Alignment() { Horizontal = HorizontalAlignmentValues.Left, Vertical = VerticalAlignmentValues.Top }; cellFormat36.Append(alignment17); CellFormat cellFormat37 = new CellFormat() { NumberFormatId = (UInt32Value)165U, FontId = (UInt32Value)2U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment18 = new Alignment() { Horizontal = HorizontalAlignmentValues.Left, Vertical = VerticalAlignmentValues.Top }; cellFormat37.Append(alignment18); CellFormat cellFormat38 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)2U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment19 = new Alignment() { Horizontal = HorizontalAlignmentValues.Left, Vertical = VerticalAlignmentValues.Top }; cellFormat38.Append(alignment19); CellFormat cellFormat39 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)5U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment20 = new Alignment() { Horizontal = HorizontalAlignmentValues.Left, Vertical = VerticalAlignmentValues.Top }; cellFormat39.Append(alignment20); CellFormat cellFormat40 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment21 = new Alignment() { Horizontal = HorizontalAlignmentValues.Left, Vertical = VerticalAlignmentValues.Top }; cellFormat40.Append(alignment21); CellFormat cellFormat41 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFill = true, ApplyBorder = true }; CellFormat cellFormat42 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)4U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true }; CellFormat cellFormat43 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)3U, FillId = (UInt32Value)5U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment22 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center, WrapText = true }; cellFormat43.Append(alignment22); CellFormat cellFormat44 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true }; CellFormat cellFormat45 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)1U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true }; CellFormat cellFormat46 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)4U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)1U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true }; CellFormat cellFormat47 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)1U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true }; CellFormat cellFormat48 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)8U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)7U, FormatId = (UInt32Value)1U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true }; CellFormat cellFormat49 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)3U, FillId = (UInt32Value)5U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)1U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment23 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat49.Append(alignment23); CellFormat cellFormat50 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)3U, FillId = (UInt32Value)5U, BorderId = (UInt32Value)9U, FormatId = (UInt32Value)1U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment24 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat50.Append(alignment24); CellFormat cellFormat51 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)2U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment25 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat51.Append(alignment25); CellFormat cellFormat52 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)0U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)1U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyAlignment = true }; Alignment alignment26 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat52.Append(alignment26); CellFormat cellFormat53 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)0U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)1U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true }; CellFormat cellFormat54 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)1U, ApplyNumberFormat = true, ApplyFont = true }; CellFormat cellFormat55 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFill = true, ApplyBorder = true }; CellFormat cellFormat56 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)4U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true }; CellFormat cellFormat57 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFill = true, ApplyBorder = true }; CellFormat cellFormat58 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)8U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)8U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true }; CellFormat cellFormat59 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)5U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment27 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat59.Append(alignment27); CellFormat cellFormat60 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)5U, BorderId = (UInt32Value)9U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment28 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat60.Append(alignment28); CellFormat cellFormat61 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment29 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat61.Append(alignment29); CellFormat cellFormat62 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)1U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment30 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat62.Append(alignment30); CellFormat cellFormat63 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)2U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment31 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat63.Append(alignment31); CellFormat cellFormat64 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFill = true }; CellFormat cellFormat65 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true }; CellFormat cellFormat66 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)5U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment32 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center, WrapText = true }; cellFormat66.Append(alignment32); cellFormats1.Append(cellFormat3); cellFormats1.Append(cellFormat4); cellFormats1.Append(cellFormat5); cellFormats1.Append(cellFormat6); cellFormats1.Append(cellFormat7); cellFormats1.Append(cellFormat8); cellFormats1.Append(cellFormat9); cellFormats1.Append(cellFormat10); cellFormats1.Append(cellFormat11); cellFormats1.Append(cellFormat12); cellFormats1.Append(cellFormat13); cellFormats1.Append(cellFormat14); cellFormats1.Append(cellFormat15); cellFormats1.Append(cellFormat16); cellFormats1.Append(cellFormat17); cellFormats1.Append(cellFormat18); cellFormats1.Append(cellFormat19); cellFormats1.Append(cellFormat20); cellFormats1.Append(cellFormat21); cellFormats1.Append(cellFormat22); cellFormats1.Append(cellFormat23); cellFormats1.Append(cellFormat24); cellFormats1.Append(cellFormat25); cellFormats1.Append(cellFormat26); cellFormats1.Append(cellFormat27); cellFormats1.Append(cellFormat28); cellFormats1.Append(cellFormat29); cellFormats1.Append(cellFormat30); cellFormats1.Append(cellFormat31); cellFormats1.Append(cellFormat32); cellFormats1.Append(cellFormat33); cellFormats1.Append(cellFormat34); cellFormats1.Append(cellFormat35); cellFormats1.Append(cellFormat36); cellFormats1.Append(cellFormat37); cellFormats1.Append(cellFormat38); cellFormats1.Append(cellFormat39); cellFormats1.Append(cellFormat40); cellFormats1.Append(cellFormat41); cellFormats1.Append(cellFormat42); cellFormats1.Append(cellFormat43); cellFormats1.Append(cellFormat44); cellFormats1.Append(cellFormat45); cellFormats1.Append(cellFormat46); cellFormats1.Append(cellFormat47); cellFormats1.Append(cellFormat48); cellFormats1.Append(cellFormat49); cellFormats1.Append(cellFormat50); cellFormats1.Append(cellFormat51); cellFormats1.Append(cellFormat52); cellFormats1.Append(cellFormat53); cellFormats1.Append(cellFormat54); cellFormats1.Append(cellFormat55); cellFormats1.Append(cellFormat56); cellFormats1.Append(cellFormat57); cellFormats1.Append(cellFormat58); cellFormats1.Append(cellFormat59); cellFormats1.Append(cellFormat60); cellFormats1.Append(cellFormat61); cellFormats1.Append(cellFormat62); cellFormats1.Append(cellFormat63); cellFormats1.Append(cellFormat64); cellFormats1.Append(cellFormat65); cellFormats1.Append(cellFormat66); CellStyles cellStyles1 = new CellStyles() { Count = (UInt32Value)2U }; CellStyle cellStyle1 = new CellStyle() { Name = "Moneda", FormatId = (UInt32Value)1U, BuiltinId = (UInt32Value)4U }; CellStyle cellStyle2 = new CellStyle() { Name = "Normal", FormatId = (UInt32Value)0U, BuiltinId = (UInt32Value)0U }; cellStyles1.Append(cellStyle1); cellStyles1.Append(cellStyle2); DifferentialFormats differentialFormats1 = new DifferentialFormats() { Count = (UInt32Value)0U }; TableStyles tableStyles1 = new TableStyles() { Count = (UInt32Value)0U, DefaultTableStyle = "TableStyleMedium9", DefaultPivotStyle = "PivotStyleLight16" }; stylesheet1.Append(numberingFormats1); stylesheet1.Append(fonts1); stylesheet1.Append(fills1); stylesheet1.Append(borders1); stylesheet1.Append(cellStyleFormats1); stylesheet1.Append(cellFormats1); stylesheet1.Append(cellStyles1); stylesheet1.Append(differentialFormats1); stylesheet1.Append(tableStyles1); workbookStylesPart1.Stylesheet = stylesheet1; }
// Generates content of workbookStylesPart1. private void GenerateWorkbookStylesPart1Content(WorkbookStylesPart workbookStylesPart1) { Stylesheet stylesheet1 = new Stylesheet(); Fonts fonts1 = new Fonts() { Count = (UInt32Value)1U }; Font font1 = new Font(); FontSize fontSize1 = new FontSize() { Val = 11D }; Color color1 = new Color() { Theme = (UInt32Value)1U }; FontName fontName1 = new FontName() { Val = "Calibri" }; FontFamilyNumbering fontFamilyNumbering1 = new FontFamilyNumbering() { Val = 2 }; FontScheme fontScheme1 = new FontScheme() { Val = FontSchemeValues.Minor }; font1.Append(fontSize1); font1.Append(color1); font1.Append(fontName1); font1.Append(fontFamilyNumbering1); font1.Append(fontScheme1); fonts1.Append(font1); Fills fills1 = new Fills() { Count = (UInt32Value)2U }; Fill fill1 = new Fill(); PatternFill patternFill1 = new PatternFill() { PatternType = PatternValues.None }; fill1.Append(patternFill1); Fill fill2 = new Fill(); PatternFill patternFill2 = new PatternFill() { PatternType = PatternValues.Gray125 }; fill2.Append(patternFill2); fills1.Append(fill1); fills1.Append(fill2); Borders borders1 = new Borders() { Count = (UInt32Value)1U }; Border border1 = new Border(); LeftBorder leftBorder1 = new LeftBorder(); RightBorder rightBorder1 = new RightBorder(); TopBorder topBorder1 = new TopBorder(); BottomBorder bottomBorder1 = new BottomBorder(); DiagonalBorder diagonalBorder1 = new DiagonalBorder(); border1.Append(leftBorder1); border1.Append(rightBorder1); border1.Append(topBorder1); border1.Append(bottomBorder1); border1.Append(diagonalBorder1); borders1.Append(border1); CellStyleFormats cellStyleFormats1 = new CellStyleFormats() { Count = (UInt32Value)1U }; CellFormat cellFormat1 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U }; cellStyleFormats1.Append(cellFormat1); CellFormats cellFormats1 = new CellFormats() { Count = (UInt32Value)1U }; CellFormat cellFormat2 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U }; cellFormats1.Append(cellFormat2); CellStyles cellStyles1 = new CellStyles() { Count = (UInt32Value)1U }; CellStyle cellStyle1 = new CellStyle() { Name = "Normal", FormatId = (UInt32Value)0U, BuiltinId = (UInt32Value)0U }; cellStyles1.Append(cellStyle1); DifferentialFormats differentialFormats1 = new DifferentialFormats() { Count = (UInt32Value)3U }; DifferentialFormat differentialFormat1 = new DifferentialFormat(); Font font2 = new Font(); Condense condense1 = new Condense() { Val = false }; Extend extend1 = new Extend() { Val = false }; Color color2 = new Color() { Rgb = "FF9C0006" }; font2.Append(condense1); font2.Append(extend1); font2.Append(color2); Fill fill3 = new Fill(); PatternFill patternFill3 = new PatternFill(); BackgroundColor backgroundColor1 = new BackgroundColor() { Rgb = "FFFFC7CE" }; patternFill3.Append(backgroundColor1); fill3.Append(patternFill3); differentialFormat1.Append(font2); differentialFormat1.Append(fill3); DifferentialFormat differentialFormat2 = new DifferentialFormat(); Font font3 = new Font(); Condense condense2 = new Condense() { Val = false }; Extend extend2 = new Extend() { Val = false }; Color color3 = new Color() { Rgb = "FF006100" }; font3.Append(condense2); font3.Append(extend2); font3.Append(color3); Fill fill4 = new Fill(); PatternFill patternFill4 = new PatternFill(); BackgroundColor backgroundColor2 = new BackgroundColor() { Rgb = "FFC6EFCE" }; patternFill4.Append(backgroundColor2); fill4.Append(patternFill4); differentialFormat2.Append(font3); differentialFormat2.Append(fill4); DifferentialFormat differentialFormat3 = new DifferentialFormat(); Font font4 = new Font(); Condense condense3 = new Condense() { Val = false }; Extend extend3 = new Extend() { Val = false }; Color color4 = new Color() { Rgb = "FF006100" }; font4.Append(condense3); font4.Append(extend3); font4.Append(color4); Fill fill5 = new Fill(); PatternFill patternFill5 = new PatternFill(); BackgroundColor backgroundColor3 = new BackgroundColor() { Rgb = "FFC6EFCE" }; patternFill5.Append(backgroundColor3); fill5.Append(patternFill5); differentialFormat3.Append(font4); differentialFormat3.Append(fill5); differentialFormats1.Append(differentialFormat1); differentialFormats1.Append(differentialFormat2); differentialFormats1.Append(differentialFormat3); TableStyles tableStyles1 = new TableStyles() { Count = (UInt32Value)0U, DefaultTableStyle = "TableStyleMedium9", DefaultPivotStyle = "PivotStyleLight16" }; stylesheet1.Append(fonts1); stylesheet1.Append(fills1); stylesheet1.Append(borders1); stylesheet1.Append(cellStyleFormats1); stylesheet1.Append(cellFormats1); stylesheet1.Append(cellStyles1); stylesheet1.Append(differentialFormats1); stylesheet1.Append(tableStyles1); workbookStylesPart1.Stylesheet = stylesheet1; }
public static Stylesheet CreateStylesheet() { var ss = new Stylesheet(); var fts = new Fonts(); var ftn = new FontName { Val = "Arial" }; var ftsz = new FontSize { Val = 11 }; var ft = new DocumentFormat.OpenXml.Spreadsheet.Font { FontName = ftn, FontSize = ftsz }; fts.Append(ft); fts.Count = (uint)fts.ChildElements.Count; var fills = new Fills(); var fill = new Fill(); var patternFill = new PatternFill { PatternType = PatternValues.None }; fill.PatternFill = patternFill; fills.Append(fill); fill = new Fill(); patternFill = new PatternFill { PatternType = PatternValues.Gray125 }; fill.PatternFill = patternFill; fills.Append(fill); fills.Count = (uint)fills.ChildElements.Count; var borders = new Borders(); var border = new Border { LeftBorder = new LeftBorder(), RightBorder = new RightBorder(), TopBorder = new TopBorder(), BottomBorder = new BottomBorder(), DiagonalBorder = new DiagonalBorder() }; borders.Append(border); borders.Count = (uint)borders.ChildElements.Count; var csfs = new CellStyleFormats(); var cf = new CellFormat { NumberFormatId = 0, FontId = 0, FillId = 0, BorderId = 0 }; csfs.Append(cf); csfs.Count = (uint)csfs.ChildElements.Count; // dd/mm/yyyy is also Excel style index 14 uint iExcelIndex = 164; var nfs = new NumberingFormats(); var cfs = new CellFormats(); cf = new CellFormat { NumberFormatId = 0, FontId = 0, FillId = 0, BorderId = 0, FormatId = 0 }; cfs.Append(cf); var nf = new NumberingFormat { NumberFormatId = iExcelIndex, FormatCode = "dd/mm/yyyy hh:mm:ss" }; nfs.Append(nf); cf = new CellFormat { NumberFormatId = nf.NumberFormatId, FontId = 0, FillId = 0, BorderId = 0, FormatId = 0, ApplyNumberFormat = true }; cfs.Append(cf); iExcelIndex = 165; nfs = new NumberingFormats(); cfs = new CellFormats(); cf = new CellFormat { NumberFormatId = 0, FontId = 0, FillId = 0, BorderId = 0, FormatId = 0 }; cfs.Append(cf); nf = new NumberingFormat { NumberFormatId = iExcelIndex, FormatCode = "MMM yyyy" }; nfs.Append(nf); cf = new CellFormat { NumberFormatId = nf.NumberFormatId, FontId = 0, FillId = 0, BorderId = 0, FormatId = 0, ApplyNumberFormat = true }; cfs.Append(cf); iExcelIndex = 170; nf = new NumberingFormat { NumberFormatId = iExcelIndex, FormatCode = "#,##0.0000" }; nfs.Append(nf); cf = new CellFormat { NumberFormatId = nf.NumberFormatId, FontId = 0, FillId = 0, BorderId = 0, FormatId = 0, ApplyNumberFormat = true }; cfs.Append(cf); // #,##0.00 is also Excel style index 4 iExcelIndex = 171; nf = new NumberingFormat { NumberFormatId = iExcelIndex, FormatCode = "#,##0.00" }; nfs.Append(nf); cf = new CellFormat { NumberFormatId = nf.NumberFormatId, FontId = 0, FillId = 0, BorderId = 0, FormatId = 0, ApplyNumberFormat = true }; cfs.Append(cf); // @ is also Excel style index 49 iExcelIndex = 172; nf = new NumberingFormat { NumberFormatId = iExcelIndex, FormatCode = "@" }; nfs.Append(nf); cf = new CellFormat { NumberFormatId = nf.NumberFormatId, FontId = 0, FillId = 0, BorderId = 0, FormatId = 0, ApplyNumberFormat = true }; cfs.Append(cf); nfs.Count = (uint)nfs.ChildElements.Count; cfs.Count = (uint)cfs.ChildElements.Count; ss.Append(nfs); ss.Append(fts); ss.Append(fills); ss.Append(borders); ss.Append(csfs); ss.Append(cfs); var css = new CellStyles(); var cs = new CellStyle { Name = "Normal", FormatId = 0, BuiltinId = 0 }; css.Append(cs); css.Count = (uint)css.ChildElements.Count; ss.Append(css); var dfs = new DifferentialFormats { Count = 0 }; ss.Append(dfs); var tss = new TableStyles { Count = 0, DefaultTableStyle = "TableStyleMedium9", DefaultPivotStyle = "PivotStyleLight16" }; ss.Append(tss); return ss; }
public static bool IsPointInside(OrthoRectangle bounds, Borders edge, Vector2D p) { switch (edge) { case Borders.Left: return !(p.X <= bounds.Left); case Borders.Right: return !(p.X >= bounds.Right); case Borders.Top: return !(p.Y >= bounds.Top); case Borders.Bottom: return !(p.Y <= bounds.Bottom); default: throw Error.WrongCase("edge", "IsPointInside", edge); } }
public static Border CreateBorder( Borders borders, BorderProperties left = null, BorderProperties right = null, BorderProperties top = null, BorderProperties bottom = null, BorderProperties diagonal = null) { var border = new Border(); var leftBorder = new LeftBorder(); if (left != null) { if (left.BorderStyle.HasValue) { leftBorder.Style = left.BorderStyle.Value; } if (left.Color != null) { leftBorder.Append(new Color { Indexed = left.Color }); } } border.Append(leftBorder); var rightBorder = new RightBorder(); if (right != null) { if (right.BorderStyle.HasValue) { rightBorder.Style = right.BorderStyle.Value; } if (right.Color != null) { rightBorder.Append(new Color { Indexed = right.Color }); } } border.Append(rightBorder); var topBorder = new TopBorder(); if (top != null) { if (top.BorderStyle.HasValue) { topBorder.Style = top.BorderStyle.Value; } if (top.Color != null) { topBorder.Append(new Color { Indexed = top.Color }); } } border.Append(topBorder); var bottomBorder = new BottomBorder(); if (bottom != null) { if (bottom.BorderStyle.HasValue) { bottomBorder.Style = bottom.BorderStyle.Value; } if (bottom.Color != null) { bottomBorder.Append(new Color { Indexed = bottom.Color }); } } border.Append(bottomBorder); var diagonalBorder = new DiagonalBorder(); if (diagonal != null) { if (diagonal.BorderStyle.HasValue) { diagonalBorder.Style = diagonal.BorderStyle.Value; } if (diagonal.Color != null) { diagonalBorder.Append(new Color { Indexed = diagonal.Color }); } } border.Append(diagonalBorder); borders.Append(border); return border; }
protected void FlattenBorders(Borders borders, Borders refBorders) { if (borders._visible.IsNull) borders._visible = refBorders._visible; if (borders._width.IsNull) borders._width = refBorders._width; if (borders._style.IsNull) borders._style = refBorders._style; if (borders._color.IsNull) borders._color = refBorders._color; if (borders._distanceFromBottom.IsNull) borders._distanceFromBottom = refBorders._distanceFromBottom; if (borders._distanceFromRight.IsNull) borders._distanceFromRight = refBorders._distanceFromRight; if (borders._distanceFromLeft.IsNull) borders._distanceFromLeft = refBorders._distanceFromLeft; if (borders._distanceFromTop.IsNull) borders._distanceFromTop = refBorders._distanceFromTop; if (refBorders._left != null) { FlattenBorder(borders.Left, refBorders._left); FlattenedBorderFromBorders(borders._left, borders); } if (refBorders._right != null) { FlattenBorder(borders.Right, refBorders._right); FlattenedBorderFromBorders(borders._right, borders); } if (refBorders._top != null) { FlattenBorder(borders.Top, refBorders._top); FlattenedBorderFromBorders(borders._top, borders); } if (refBorders._bottom != null) { FlattenBorder(borders.Bottom, refBorders._bottom); FlattenedBorderFromBorders(borders._bottom, borders); } }
protected Border FlattenedBorderFromBorders(Border border, Borders parentBorders) { if (border == null) border = new Border(parentBorders); if (border._visible.IsNull) border._visible = parentBorders._visible; if (border._style.IsNull) border._style = parentBorders._style; if (border._width.IsNull) border._width = parentBorders._width; if (border._color.IsNull) border._color = parentBorders._color; return border; }
/// <summary> /// Create an stylesheet to use in excel files /// </summary> /// <returns></returns> private static Stylesheet VocStyleSheet() { Stylesheet styleSheet = new Stylesheet(); Fonts fonts = new Fonts(); // 0 - normal fonts DocumentFormat.OpenXml.Spreadsheet.Font myFont = new DocumentFormat.OpenXml.Spreadsheet.Font() { FontSize = new FontSize() { Val = 11 }, Color = new DocumentFormat.OpenXml.Spreadsheet.Color() { Rgb = new HexBinaryValue() { Value = "000000" } }, FontName = new FontName() { Val = "Calibri" } }; fonts.Append(myFont); //1 - font bold myFont = new DocumentFormat.OpenXml.Spreadsheet.Font() { Bold = new Bold(), FontSize = new FontSize() { Val = 11 }, Color = new DocumentFormat.OpenXml.Spreadsheet.Color() { Rgb = new HexBinaryValue() { Value = "000000" } }, FontName = new FontName() { Val = "Calibri" } }; fonts.Append(myFont); //2 - font title myFont = new DocumentFormat.OpenXml.Spreadsheet.Font() { Bold = new Bold(), FontSize = new FontSize() { Val = 20 }, Color = new DocumentFormat.OpenXml.Spreadsheet.Color() { Rgb = new HexBinaryValue() { Value = "FFFFFF" } }, FontName = new FontName() { Val = "Verdana" } }; fonts.Append(myFont); //3 - font bold myFont = new DocumentFormat.OpenXml.Spreadsheet.Font() { Bold = new Bold(), FontSize = new FontSize() { Val = 16 }, Color = new DocumentFormat.OpenXml.Spreadsheet.Color() { Rgb = new HexBinaryValue() { Value = "000000" } }, FontName = new FontName() { Val = "Calibri" } }; fonts.Append(myFont); //4 - small font white myFont = new DocumentFormat.OpenXml.Spreadsheet.Font() { FontSize = new FontSize() { Val = 11 }, Color = new DocumentFormat.OpenXml.Spreadsheet.Color() { Rgb = new HexBinaryValue() { Value = "FFFFFF" } }, FontName = new FontName() { Val = "Calibri" } }; fonts.Append(myFont); Fills fills = new Fills(); //default fill Fill fill = new Fill() { PatternFill = new PatternFill() { PatternType = PatternValues.None } }; fills.Append(fill); //default fill fill = new Fill() { PatternFill = new PatternFill() { PatternType = PatternValues.Gray125 } }; fills.Append(fill); //title fill fill = new Fill() { PatternFill = new PatternFill() { ForegroundColor = new ForegroundColor() { Rgb = new HexBinaryValue() { Value = "499EB1" } }, PatternType = PatternValues.Solid } }; fills.Append(fill); Borders borders = new Borders(); //normal borders Border border = new Border() { LeftBorder = new LeftBorder(), RightBorder = new RightBorder(), TopBorder = new TopBorder(), BottomBorder = new BottomBorder(), DiagonalBorder = new DiagonalBorder() }; borders.Append(border); //borders applied border = new Border() { LeftBorder = new LeftBorder() { Color = new DocumentFormat.OpenXml.Spreadsheet.Color() { Auto = true }, Style = BorderStyleValues.Thin }, RightBorder = new RightBorder() { Color = new DocumentFormat.OpenXml.Spreadsheet.Color() { Auto = true }, Style = BorderStyleValues.Thin }, TopBorder = new TopBorder() { Color = new DocumentFormat.OpenXml.Spreadsheet.Color() { Auto = true }, Style = BorderStyleValues.Thin }, BottomBorder = new BottomBorder() { Color = new DocumentFormat.OpenXml.Spreadsheet.Color() { Auto = true }, Style = BorderStyleValues.Thin }, DiagonalBorder = new DiagonalBorder() }; borders.Append(border); CellFormats cellFormats = new CellFormats(); //0- normal CellFormat cellFormat = new CellFormat() { FontId = 0, FillId = 0, BorderId = 0, ApplyFill = true }; cellFormats.Append(cellFormat); //1 - border cellFormat = new CellFormat() { FontId = 0, FillId = 0, BorderId = 1, Alignment = new Alignment() { WrapText = true }, ApplyFill = true }; cellFormats.Append(cellFormat); //2 - border and bold cellFormat = new CellFormat() { FontId = 1, FillId = 0, BorderId = 1, Alignment = new Alignment() { WrapText = true }, ApplyFill = true }; cellFormats.Append(cellFormat); //3 -title cellFormat = new CellFormat() { FontId = 0, FillId = 2, BorderId = 0, ApplyFill = true }; cellFormats.Append(cellFormat); //4 - title cellFormat = new CellFormat() { FontId = 2, FillId = 2, BorderId = 0, Alignment = new Alignment() { Horizontal = HorizontalAlignmentValues.Left, Vertical = VerticalAlignmentValues.Center }, ApplyFill = true }; cellFormats.Append(cellFormat); //5 - title cellFormat = new CellFormat() { FontId = 2, FillId = 2, BorderId = 0, Alignment = new Alignment() { Horizontal = HorizontalAlignmentValues.CenterContinuous, Vertical = VerticalAlignmentValues.Center }, ApplyFill = true }; cellFormats.Append(cellFormat); //6 - section title cellFormat = new CellFormat() { FontId = 3, FillId = 0, BorderId = 1, ApplyFill = true }; cellFormats.Append(cellFormat); //7 - section title filter values cellFormat = new CellFormat() { FontId = 4, FillId = 2, BorderId = 0, Alignment = new Alignment() { WrapText = false, Horizontal = HorizontalAlignmentValues.Left, Vertical = VerticalAlignmentValues.Center }, ApplyFill = true }; cellFormats.Append(cellFormat); styleSheet.Append(fonts); styleSheet.Append(fills); styleSheet.Append(borders); styleSheet.Append(cellFormats); return styleSheet; }
public static Borders GetBorders (CreateParams cp, Menu menu) { Borders borders = new Borders (); if (menu != null) { int menu_height = menu.Rect.Height; if (menu_height == 0) menu_height = ThemeEngine.Current.CalcMenuBarSize (GraphicsContext, menu, cp.Width); borders.top += menu_height; } if (cp.IsSet (WindowStyles.WS_CAPTION)) { int caption_height; if (cp.IsSet (WindowExStyles.WS_EX_TOOLWINDOW)) { caption_height = ThemeEngine.Current.ToolWindowCaptionHeight; } else { caption_height = ThemeEngine.Current.CaptionHeight; } borders.top += caption_height; } Borders border_width = GetBorderWidth (cp); borders.left += border_width.left; borders.right += border_width.right; borders.top += border_width.top; borders.bottom += border_width.bottom; return borders; }
/** * Specifies the border which shall be displayed above a Set of paragraphs * which have the same Set of paragraph border Settings. * <p> * <p> * To determine if any two adjoining paragraphs shall have an individual top * and bottom border or a between border, the Set of borders on the two * adjoining paragraphs are Compared. If the border information on those two * paragraphs is identical for all possible paragraphs borders, then the * between border is displayed. Otherwise, the paragraph shall use its * bottom border and the following paragraph shall use its top border, * respectively. If this border specifies a space attribute, that value * determines the space above the text (ignoring any spacing above) which * should be left before this border is Drawn, specified in points. * </p> * <p> * If this element is omitted on a given paragraph, its value is determined * by the Setting previously Set at any level of the style hierarchy (i.e. * that previous Setting remains unChanged). If this Setting is never * specified in the style hierarchy, then no between border shall be applied * above identical paragraphs. * </p> * <b>This border can only be a line border.</b> * * @param border * @see Borders for a list of all types of borders */ public void SetBorderTop(Borders border) { CT_PBdr ct = GetCTPBrd(true); CT_Border pr = (ct != null && ct.IsSetTop()) ? ct.top : ct.AddNewTop(); if (border == Borders.NONE) ct.UnsetTop(); else pr.val = EnumConverter.ValueOf<ST_Border, Borders>(border); }
public CustomStylesheet() { var fonts = new Fonts(); var font = new DocumentFormat.OpenXml.Spreadsheet.Font(); var fontName = new FontName { Val = StringValue.FromString("Arial") }; var fontSize = new FontSize { Val = DoubleValue.FromDouble(11) }; font.FontName = fontName; font.FontSize = fontSize; fonts.Append(font); //Font Index 1 font = new DocumentFormat.OpenXml.Spreadsheet.Font(); fontName = new FontName { Val = StringValue.FromString("Arial") }; fontSize = new FontSize { Val = DoubleValue.FromDouble(12) }; font.FontName = fontName; font.FontSize = fontSize; font.Bold = new Bold(); fonts.Append(font); fonts.Count = UInt32Value.FromUInt32((uint)fonts.ChildElements.Count); var fills = new Fills(); var fill = new Fill(); var patternFill = new PatternFill { PatternType = PatternValues.None }; fill.PatternFill = patternFill; fills.Append(fill); fill = new Fill(); patternFill = new PatternFill { PatternType = PatternValues.Gray125 }; fill.PatternFill = patternFill; fills.Append(fill); //Fill index 2 fill = new Fill(); patternFill = new PatternFill { PatternType = PatternValues.Solid, ForegroundColor = new ForegroundColor() }; patternFill.ForegroundColor = TranslateForeground(System.Drawing.Color.LightBlue); patternFill.BackgroundColor = new BackgroundColor { Rgb = patternFill.ForegroundColor.Rgb }; fill.PatternFill = patternFill; fills.Append(fill); //Fill index 3 fill = new Fill(); patternFill = new PatternFill { PatternType = PatternValues.Solid, ForegroundColor = new ForegroundColor() }; patternFill.ForegroundColor = TranslateForeground(System.Drawing.Color.DodgerBlue); patternFill.BackgroundColor = new BackgroundColor { Rgb = patternFill.ForegroundColor.Rgb }; fill.PatternFill = patternFill; fills.Append(fill); fills.Count = UInt32Value.FromUInt32((uint)fills.ChildElements.Count); var borders = new Borders(); var border = new Border { LeftBorder = new LeftBorder(), RightBorder = new RightBorder(), TopBorder = new TopBorder(), BottomBorder = new BottomBorder(), DiagonalBorder = new DiagonalBorder() }; borders.Append(border); //All Boarder Index 1 border = new Border { LeftBorder = new LeftBorder { Style = BorderStyleValues.Thin }, RightBorder = new RightBorder { Style = BorderStyleValues.Thin }, TopBorder = new TopBorder { Style = BorderStyleValues.Thin }, BottomBorder = new BottomBorder { Style = BorderStyleValues.Thin }, DiagonalBorder = new DiagonalBorder() }; borders.Append(border); //Top and Bottom Boarder Index 2 border = new Border { LeftBorder = new LeftBorder(), RightBorder = new RightBorder(), TopBorder = new TopBorder { Style = BorderStyleValues.Thin }, BottomBorder = new BottomBorder { Style = BorderStyleValues.Thin }, DiagonalBorder = new DiagonalBorder() }; borders.Append(border); borders.Count = UInt32Value.FromUInt32((uint)borders.ChildElements.Count); var cellStyleFormats = new CellStyleFormats(); var cellFormat = new CellFormat { NumberFormatId = 0, FontId = 0, FillId = 0, BorderId = 0 }; cellStyleFormats.Append(cellFormat); cellStyleFormats.Count = UInt32Value.FromUInt32((uint)cellStyleFormats.ChildElements.Count); uint iExcelIndex = 164; var numberingFormats = new NumberingFormats(); var cellFormats = new CellFormats(); cellFormat = new CellFormat { NumberFormatId = 0, FontId = 0, FillId = 0, BorderId = 0, FormatId = 0 }; cellFormats.Append(cellFormat); var nformatDateTime = new NumberingFormat { NumberFormatId = UInt32Value.FromUInt32(iExcelIndex++), FormatCode = StringValue.FromString("dd/mm/yyyy hh:mm:ss") }; numberingFormats.Append(nformatDateTime); var nformat4Decimal = new NumberingFormat { NumberFormatId = UInt32Value.FromUInt32(iExcelIndex++), FormatCode = StringValue.FromString("#,##0.0000") }; numberingFormats.Append(nformat4Decimal); var nformat2Decimal = new NumberingFormat { NumberFormatId = UInt32Value.FromUInt32(iExcelIndex++), FormatCode = StringValue.FromString("#,##0.00") }; numberingFormats.Append(nformat2Decimal); var nformatForcedText = new NumberingFormat { NumberFormatId = UInt32Value.FromUInt32(iExcelIndex), FormatCode = StringValue.FromString("@") }; numberingFormats.Append(nformatForcedText); // index 1 // Cell Standard Date format cellFormat = new CellFormat { NumberFormatId = 14, FontId = 0, FillId = 0, BorderId = 0, FormatId = 0, ApplyNumberFormat = BooleanValue.FromBoolean(true) }; cellFormats.Append(cellFormat); // Index 2 // Cell Standard Number format with 2 decimal placing cellFormat = new CellFormat { NumberFormatId = 4, FontId = 0, FillId = 0, BorderId = 0, FormatId = 0, ApplyNumberFormat = BooleanValue.FromBoolean(true) }; cellFormats.Append(cellFormat); // Index 3 // Cell Date time custom format cellFormat = new CellFormat { NumberFormatId = nformatDateTime.NumberFormatId, FontId = 0, FillId = 0, BorderId = 0, FormatId = 0, ApplyNumberFormat = BooleanValue.FromBoolean(true) }; cellFormats.Append(cellFormat); // Index 4 // Cell 4 decimal custom format cellFormat = new CellFormat { NumberFormatId = nformat4Decimal.NumberFormatId, FontId = 0, FillId = 0, BorderId = 0, FormatId = 0, ApplyNumberFormat = BooleanValue.FromBoolean(true) }; cellFormats.Append(cellFormat); // Index 5 // Cell 2 decimal custom format cellFormat = new CellFormat { NumberFormatId = nformat2Decimal.NumberFormatId, FontId = 0, FillId = 0, BorderId = 0, FormatId = 0, ApplyNumberFormat = BooleanValue.FromBoolean(true) }; cellFormats.Append(cellFormat); // Index 6 // Cell forced number text custom format cellFormat = new CellFormat { NumberFormatId = nformatForcedText.NumberFormatId, FontId = 0, FillId = 0, BorderId = 0, FormatId = 0, ApplyNumberFormat = BooleanValue.FromBoolean(true) }; cellFormats.Append(cellFormat); // Index 7 // Cell text with font 12 cellFormat = new CellFormat { NumberFormatId = nformatForcedText.NumberFormatId, FontId = 1, FillId = 0, BorderId = 0, FormatId = 0, ApplyNumberFormat = BooleanValue.FromBoolean(true) }; cellFormats.Append(cellFormat); // Index 8 // Cell text cellFormat = new CellFormat { NumberFormatId = nformatForcedText.NumberFormatId, FontId = 0, FillId = 0, BorderId = 1, FormatId = 0, ApplyNumberFormat = BooleanValue.FromBoolean(true) }; cellFormats.Append(cellFormat); // Index 9 // Coloured 2 decimal cell text cellFormat = new CellFormat { NumberFormatId = nformat2Decimal.NumberFormatId, FontId = 0, FillId = 2, BorderId = 2, FormatId = 0, ApplyNumberFormat = BooleanValue.FromBoolean(true) }; cellFormats.Append(cellFormat); // Index 10 // Coloured cell text cellFormat = new CellFormat { NumberFormatId = nformatForcedText.NumberFormatId, FontId = 0, FillId = 2, BorderId = 2, FormatId = 0, ApplyNumberFormat = BooleanValue.FromBoolean(true) }; cellFormats.Append(cellFormat); // Index 11 // Coloured cell text cellFormat = new CellFormat { NumberFormatId = nformatForcedText.NumberFormatId, FontId = 1, FillId = 3, BorderId = 2, FormatId = 0, ApplyNumberFormat = BooleanValue.FromBoolean(true) }; cellFormats.Append(cellFormat); numberingFormats.Count = UInt32Value.FromUInt32((uint)numberingFormats.ChildElements.Count); cellFormats.Count = UInt32Value.FromUInt32((uint)cellFormats.ChildElements.Count); this.Append(numberingFormats); this.Append(fonts); this.Append(fills); this.Append(borders); this.Append(cellStyleFormats); this.Append(cellFormats); var css = new CellStyles(); var cs = new CellStyle { Name = StringValue.FromString("Normal"), FormatId = 0, BuiltinId = 0 }; css.Append(cs); css.Count = UInt32Value.FromUInt32((uint)css.ChildElements.Count); this.Append(css); var dfs = new DifferentialFormats { Count = 0 }; this.Append(dfs); var tss = new TableStyles { Count = 0, DefaultTableStyle = StringValue.FromString("TableStyleMedium9"), DefaultPivotStyle = StringValue.FromString("PivotStyleLight16") }; this.Append(tss); }
public static Borders CreateBordersCollection(Stylesheet stylesheet, UInt32Value capacity) { var borders = new Borders { Count = capacity }; stylesheet.Append(borders); return borders; }
// Generates content of workbookStylesPart1. private void GenerateWorkbookStylesPart1Content(WorkbookStylesPart workbookStylesPart1) { Stylesheet stylesheet1 = new Stylesheet(); Fonts fonts1 = new Fonts() { Count = (UInt32Value)1U, KnownFonts = true }; Font font1 = new Font(); FontSize fontSize1 = new FontSize() { Val = 11D }; Color color1 = new Color() { Theme = (UInt32Value)1U }; FontName fontName1 = new FontName() { Val = "Calibri" }; FontFamilyNumbering fontFamilyNumbering1 = new FontFamilyNumbering() { Val = 2 }; FontScheme fontScheme1 = new FontScheme() { Val = FontSchemeValues.Minor }; font1.Append(fontSize1); font1.Append(color1); font1.Append(fontName1); font1.Append(fontFamilyNumbering1); font1.Append(fontScheme1); fonts1.Append(font1); Fills fills1 = new Fills() { Count = (UInt32Value)2U }; Fill fill1 = new Fill(); PatternFill patternFill1 = new PatternFill() { PatternType = PatternValues.None }; fill1.Append(patternFill1); Fill fill2 = new Fill(); PatternFill patternFill2 = new PatternFill() { PatternType = PatternValues.Gray125 }; fill2.Append(patternFill2); fills1.Append(fill1); fills1.Append(fill2); Borders borders1 = new Borders() { Count = (UInt32Value)1U }; Border border1 = new Border(); LeftBorder leftBorder1 = new LeftBorder(); RightBorder rightBorder1 = new RightBorder(); TopBorder topBorder1 = new TopBorder(); BottomBorder bottomBorder1 = new BottomBorder(); DiagonalBorder diagonalBorder1 = new DiagonalBorder(); border1.Append(leftBorder1); border1.Append(rightBorder1); border1.Append(topBorder1); border1.Append(bottomBorder1); border1.Append(diagonalBorder1); borders1.Append(border1); CellStyleFormats cellStyleFormats1 = new CellStyleFormats() { Count = (UInt32Value)1U }; CellFormat cellFormat1 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U }; cellStyleFormats1.Append(cellFormat1); CellFormats cellFormats1 = new CellFormats() { Count = (UInt32Value)4U }; CellFormat cellFormat2 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U }; CellFormat cellFormat3 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true }; CellFormat cellFormat4 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, PivotButton = true }; CellFormat cellFormat5 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyAlignment = true }; cellFormats1.Append(cellFormat2); cellFormats1.Append(cellFormat3); cellFormats1.Append(cellFormat4); cellFormats1.Append(cellFormat5); CellStyles cellStyles1 = new CellStyles() { Count = (UInt32Value)1U }; CellStyle cellStyle1 = new CellStyle() { Name = "Normal", FormatId = (UInt32Value)0U, BuiltinId = (UInt32Value)0U }; cellStyles1.Append(cellStyle1); DifferentialFormats differentialFormats1 = new DifferentialFormats() { Count = (UInt32Value)0U }; stylesheet1.Append(fonts1); stylesheet1.Append(fills1); stylesheet1.Append(borders1); stylesheet1.Append(cellStyleFormats1); stylesheet1.Append(cellFormats1); stylesheet1.Append(cellStyles1); stylesheet1.Append(differentialFormats1); workbookStylesPart1.Stylesheet = stylesheet1; }
private void CloneHelper(ref Borders borders, Borders source) { if (source != null) { borders = source.Clone(); borders._parent = source._parent; } }
public CustomStylesheet() { NumberStyles = new Dictionary<NumberStyle, NumberingFormat>(); CellFormatStyles = new Dictionary<CellFormatId, uint>(); Borders = new Borders(); BorderStyles = new Dictionary<string, uint>(); Fonts = new Fonts(); FontStyles = new Dictionary<string, uint>(); RegisterBorder("None"); RegisterFont("Default", new Font { FontName = new FontName { Val = StringValue.FromString("Calibri") }, FontSize = new FontSize { Val = DoubleValue.FromDouble(10) } }); var fills = CreateFills(); var numberingFormats = CreateNumberFormats(); MyCellFormats = new DocumentFormat.OpenXml.Spreadsheet.CellFormats(); MyCellFormats.Append(new CellFormat { NumberFormatId = 0, FontId = 0, FillId = 0, BorderId = 0, FormatId = 0 }); //BuildCellFormat(BorderStyle.All, NumberStyle.ForcedText); var cellStyleFormats = new CellStyleFormats(); var cellFormat = new CellFormat { Alignment = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }, NumberFormatId = 0, FontId = 0, FillId = 0, BorderId = 0 }; cellStyleFormats.Append(cellFormat); cellStyleFormats.Count = UInt32Value.FromUInt32((uint)cellStyleFormats.ChildElements.Count); //var cellFormats = CreateCellFormats(); this.Append(numberingFormats); this.Append(Fonts); // OK this.Append(fills); this.Append(Borders); // OK this.Append(cellStyleFormats); this.Append(MyCellFormats); var css = new CellStyles(); var cs = new CellStyle { Name = StringValue.FromString("Normal"), FormatId = 0, BuiltinId = 0 }; css.Append(cs); css.Count = UInt32Value.FromUInt32((uint)css.ChildElements.Count); this.Append(css); var dfs = new DifferentialFormats { Count = 0 }; this.Append(dfs); var tss = new TableStyles { Count = 0, DefaultTableStyle = StringValue.FromString("TableStyleMedium9"), DefaultPivotStyle = StringValue.FromString("PivotStyleLight16") }; this.Append(tss); }
// Generates content of workbookStylesPart1. private void GenerateWorkbookStylesPart1Content(WorkbookStylesPart workbookStylesPart1) { Stylesheet stylesheet1 = new Stylesheet(); NumberingFormats numberingFormats1 = new NumberingFormats() { Count = (UInt32Value)2U }; NumberingFormat numberingFormat1 = new NumberingFormat() { NumberFormatId = (UInt32Value)166U, FormatCode = "_(* #,##0_);_(* \\(#,##0\\);_(* \"-\"??_);_(@_)" }; NumberingFormat numberingFormat2 = new NumberingFormat() { NumberFormatId = (UInt32Value)167U, FormatCode = "_-* #,##0\\ _€_-;\\-* #,##0\\ _€_-;_-* \"-\"??\\ _€_-;_-@_-" }; numberingFormats1.Append(numberingFormat1); numberingFormats1.Append(numberingFormat2); Fonts fonts1 = new Fonts() { Count = (UInt32Value)14U }; Font font1 = new Font(); FontSize fontSize1 = new FontSize() { Val = 10D }; FontName fontName1 = new FontName() { Val = "Arial" }; font1.Append(fontSize1); font1.Append(fontName1); Font font2 = new Font(); Bold bold1 = new Bold(); FontSize fontSize2 = new FontSize() { Val = 10D }; FontName fontName2 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering1 = new FontFamilyNumbering() { Val = 2 }; font2.Append(bold1); font2.Append(fontSize2); font2.Append(fontName2); font2.Append(fontFamilyNumbering1); Font font3 = new Font(); Bold bold2 = new Bold(); Italic italic1 = new Italic(); FontSize fontSize3 = new FontSize() { Val = 10D }; FontName fontName3 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering2 = new FontFamilyNumbering() { Val = 2 }; font3.Append(bold2); font3.Append(italic1); font3.Append(fontSize3); font3.Append(fontName3); font3.Append(fontFamilyNumbering2); Font font4 = new Font(); Bold bold3 = new Bold(); FontSize fontSize4 = new FontSize() { Val = 10D }; Color color1 = new Color() { Indexed = (UInt32Value)9U }; FontName fontName4 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering3 = new FontFamilyNumbering() { Val = 2 }; font4.Append(bold3); font4.Append(fontSize4); font4.Append(color1); font4.Append(fontName4); font4.Append(fontFamilyNumbering3); Font font5 = new Font(); FontSize fontSize5 = new FontSize() { Val = 10D }; Color color2 = new Color() { Indexed = (UInt32Value)9U }; FontName fontName5 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering4 = new FontFamilyNumbering() { Val = 2 }; font5.Append(fontSize5); font5.Append(color2); font5.Append(fontName5); font5.Append(fontFamilyNumbering4); Font font6 = new Font(); Bold bold4 = new Bold(); FontSize fontSize6 = new FontSize() { Val = 10D }; Color color3 = new Color() { Indexed = (UInt32Value)12U }; FontName fontName6 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering5 = new FontFamilyNumbering() { Val = 2 }; font6.Append(bold4); font6.Append(fontSize6); font6.Append(color3); font6.Append(fontName6); font6.Append(fontFamilyNumbering5); Font font7 = new Font(); FontSize fontSize7 = new FontSize() { Val = 12D }; Color color4 = new Color() { Indexed = (UInt32Value)12U }; FontName fontName7 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering6 = new FontFamilyNumbering() { Val = 2 }; font7.Append(fontSize7); font7.Append(color4); font7.Append(fontName7); font7.Append(fontFamilyNumbering6); Font font8 = new Font(); Bold bold5 = new Bold(); FontSize fontSize8 = new FontSize() { Val = 9D }; FontName fontName8 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering7 = new FontFamilyNumbering() { Val = 2 }; font8.Append(bold5); font8.Append(fontSize8); font8.Append(fontName8); font8.Append(fontFamilyNumbering7); Font font9 = new Font(); Bold bold6 = new Bold(); FontSize fontSize9 = new FontSize() { Val = 8D }; Color color5 = new Color() { Indexed = (UInt32Value)9U }; FontName fontName9 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering8 = new FontFamilyNumbering() { Val = 2 }; font9.Append(bold6); font9.Append(fontSize9); font9.Append(color5); font9.Append(fontName9); font9.Append(fontFamilyNumbering8); Font font10 = new Font(); FontSize fontSize10 = new FontSize() { Val = 12D }; FontName fontName10 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering9 = new FontFamilyNumbering() { Val = 2 }; font10.Append(fontSize10); font10.Append(fontName10); font10.Append(fontFamilyNumbering9); Font font11 = new Font(); Bold bold7 = new Bold(); FontSize fontSize11 = new FontSize() { Val = 12D }; FontName fontName11 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering10 = new FontFamilyNumbering() { Val = 2 }; font11.Append(bold7); font11.Append(fontSize11); font11.Append(fontName11); font11.Append(fontFamilyNumbering10); Font font12 = new Font(); Bold bold8 = new Bold(); FontSize fontSize12 = new FontSize() { Val = 11D }; FontName fontName12 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering11 = new FontFamilyNumbering() { Val = 2 }; font12.Append(bold8); font12.Append(fontSize12); font12.Append(fontName12); font12.Append(fontFamilyNumbering11); Font font13 = new Font(); FontSize fontSize13 = new FontSize() { Val = 11D }; FontName fontName13 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering12 = new FontFamilyNumbering() { Val = 2 }; font13.Append(fontSize13); font13.Append(fontName13); font13.Append(fontFamilyNumbering12); Font font14 = new Font(); Underline underline1 = new Underline(); FontSize fontSize14 = new FontSize() { Val = 12D }; Color color6 = new Color() { Indexed = (UInt32Value)12U }; FontName fontName14 = new FontName() { Val = "Arial" }; font14.Append(underline1); font14.Append(fontSize14); font14.Append(color6); font14.Append(fontName14); fonts1.Append(font1); fonts1.Append(font2); fonts1.Append(font3); fonts1.Append(font4); fonts1.Append(font5); fonts1.Append(font6); fonts1.Append(font7); fonts1.Append(font8); fonts1.Append(font9); fonts1.Append(font10); fonts1.Append(font11); fonts1.Append(font12); fonts1.Append(font13); fonts1.Append(font14); Fills fills1 = new Fills() { Count = (UInt32Value)13U }; Fill fill1 = new Fill(); PatternFill patternFill1 = new PatternFill() { PatternType = PatternValues.None }; fill1.Append(patternFill1); Fill fill2 = new Fill(); PatternFill patternFill2 = new PatternFill() { PatternType = PatternValues.Gray125 }; fill2.Append(patternFill2); Fill fill3 = new Fill(); PatternFill patternFill3 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor1 = new ForegroundColor() { Indexed = (UInt32Value)9U }; BackgroundColor backgroundColor1 = new BackgroundColor() { Indexed = (UInt32Value)64U }; patternFill3.Append(foregroundColor1); patternFill3.Append(backgroundColor1); fill3.Append(patternFill3); Fill fill4 = new Fill(); PatternFill patternFill4 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor2 = new ForegroundColor() { Indexed = (UInt32Value)10U }; BackgroundColor backgroundColor2 = new BackgroundColor() { Indexed = (UInt32Value)64U }; patternFill4.Append(foregroundColor2); patternFill4.Append(backgroundColor2); fill4.Append(patternFill4); Fill fill5 = new Fill(); PatternFill patternFill5 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor3 = new ForegroundColor() { Indexed = (UInt32Value)23U }; BackgroundColor backgroundColor3 = new BackgroundColor() { Indexed = (UInt32Value)64U }; patternFill5.Append(foregroundColor3); patternFill5.Append(backgroundColor3); fill5.Append(patternFill5); Fill fill6 = new Fill(); PatternFill patternFill6 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor4 = new ForegroundColor() { Indexed = (UInt32Value)43U }; BackgroundColor backgroundColor4 = new BackgroundColor() { Indexed = (UInt32Value)64U }; patternFill6.Append(foregroundColor4); patternFill6.Append(backgroundColor4); fill6.Append(patternFill6); Fill fill7 = new Fill(); PatternFill patternFill7 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor5 = new ForegroundColor() { Indexed = (UInt32Value)42U }; BackgroundColor backgroundColor5 = new BackgroundColor() { Indexed = (UInt32Value)64U }; patternFill7.Append(foregroundColor5); patternFill7.Append(backgroundColor5); fill7.Append(patternFill7); Fill fill8 = new Fill(); PatternFill patternFill8 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor6 = new ForegroundColor() { Indexed = (UInt32Value)55U }; BackgroundColor backgroundColor6 = new BackgroundColor() { Indexed = (UInt32Value)64U }; patternFill8.Append(foregroundColor6); patternFill8.Append(backgroundColor6); fill8.Append(patternFill8); Fill fill9 = new Fill(); PatternFill patternFill9 = new PatternFill() { PatternType = PatternValues.None }; ForegroundColor foregroundColor7 = new ForegroundColor() { Indexed = (UInt32Value)9U }; BackgroundColor backgroundColor7 = new BackgroundColor() { Indexed = (UInt32Value)64U }; patternFill9.Append(foregroundColor7); patternFill9.Append(backgroundColor7); fill9.Append(patternFill9); Fill fill10 = new Fill(); PatternFill patternFill10 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor8 = new ForegroundColor() { Theme = (UInt32Value)0U }; BackgroundColor backgroundColor8 = new BackgroundColor() { Indexed = (UInt32Value)64U }; patternFill10.Append(foregroundColor8); patternFill10.Append(backgroundColor8); fill10.Append(patternFill10); Fill fill11 = new Fill(); PatternFill patternFill11 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor9 = new ForegroundColor() { Rgb = "FFFFE699" }; BackgroundColor backgroundColor9 = new BackgroundColor() { Rgb = "FF000000" }; patternFill11.Append(foregroundColor9); patternFill11.Append(backgroundColor9); fill11.Append(patternFill11); Fill fill12 = new Fill(); PatternFill patternFill12 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor10 = new ForegroundColor() { Rgb = "FFCCFFCC" }; BackgroundColor backgroundColor10 = new BackgroundColor() { Rgb = "FF000000" }; patternFill12.Append(foregroundColor10); patternFill12.Append(backgroundColor10); fill12.Append(patternFill12); Fill fill13 = new Fill(); PatternFill patternFill13 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor11 = new ForegroundColor() { Rgb = "FF969696" }; BackgroundColor backgroundColor11 = new BackgroundColor() { Rgb = "FF000000" }; patternFill13.Append(foregroundColor11); patternFill13.Append(backgroundColor11); fill13.Append(patternFill13); fills1.Append(fill1); fills1.Append(fill2); fills1.Append(fill3); fills1.Append(fill4); fills1.Append(fill5); fills1.Append(fill6); fills1.Append(fill7); fills1.Append(fill8); fills1.Append(fill9); fills1.Append(fill10); fills1.Append(fill11); fills1.Append(fill12); fills1.Append(fill13); Borders borders1 = new Borders() { Count = (UInt32Value)27U }; Border border1 = new Border(); LeftBorder leftBorder1 = new LeftBorder(); RightBorder rightBorder1 = new RightBorder(); TopBorder topBorder1 = new TopBorder(); BottomBorder bottomBorder1 = new BottomBorder(); DiagonalBorder diagonalBorder1 = new DiagonalBorder(); border1.Append(leftBorder1); border1.Append(rightBorder1); border1.Append(topBorder1); border1.Append(bottomBorder1); border1.Append(diagonalBorder1); Border border2 = new Border(); LeftBorder leftBorder2 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color7 = new Color() { Indexed = (UInt32Value)64U }; leftBorder2.Append(color7); RightBorder rightBorder2 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color8 = new Color() { Indexed = (UInt32Value)64U }; rightBorder2.Append(color8); TopBorder topBorder2 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color9 = new Color() { Indexed = (UInt32Value)64U }; topBorder2.Append(color9); BottomBorder bottomBorder2 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color10 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder2.Append(color10); DiagonalBorder diagonalBorder2 = new DiagonalBorder(); border2.Append(leftBorder2); border2.Append(rightBorder2); border2.Append(topBorder2); border2.Append(bottomBorder2); border2.Append(diagonalBorder2); Border border3 = new Border(); LeftBorder leftBorder3 = new LeftBorder(); RightBorder rightBorder3 = new RightBorder(); TopBorder topBorder3 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color11 = new Color() { Indexed = (UInt32Value)64U }; topBorder3.Append(color11); BottomBorder bottomBorder3 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color12 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder3.Append(color12); DiagonalBorder diagonalBorder3 = new DiagonalBorder(); border3.Append(leftBorder3); border3.Append(rightBorder3); border3.Append(topBorder3); border3.Append(bottomBorder3); border3.Append(diagonalBorder3); Border border4 = new Border(); LeftBorder leftBorder4 = new LeftBorder(); RightBorder rightBorder4 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color13 = new Color() { Indexed = (UInt32Value)64U }; rightBorder4.Append(color13); TopBorder topBorder4 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color14 = new Color() { Indexed = (UInt32Value)64U }; topBorder4.Append(color14); BottomBorder bottomBorder4 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color15 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder4.Append(color15); DiagonalBorder diagonalBorder4 = new DiagonalBorder(); border4.Append(leftBorder4); border4.Append(rightBorder4); border4.Append(topBorder4); border4.Append(bottomBorder4); border4.Append(diagonalBorder4); Border border5 = new Border(); LeftBorder leftBorder5 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color16 = new Color() { Indexed = (UInt32Value)64U }; leftBorder5.Append(color16); RightBorder rightBorder5 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color17 = new Color() { Indexed = (UInt32Value)64U }; rightBorder5.Append(color17); TopBorder topBorder5 = new TopBorder(); BottomBorder bottomBorder5 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color18 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder5.Append(color18); DiagonalBorder diagonalBorder5 = new DiagonalBorder(); border5.Append(leftBorder5); border5.Append(rightBorder5); border5.Append(topBorder5); border5.Append(bottomBorder5); border5.Append(diagonalBorder5); Border border6 = new Border(); LeftBorder leftBorder6 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color19 = new Color() { Indexed = (UInt32Value)64U }; leftBorder6.Append(color19); RightBorder rightBorder6 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color20 = new Color() { Indexed = (UInt32Value)64U }; rightBorder6.Append(color20); TopBorder topBorder6 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color21 = new Color() { Indexed = (UInt32Value)64U }; topBorder6.Append(color21); BottomBorder bottomBorder6 = new BottomBorder(); DiagonalBorder diagonalBorder6 = new DiagonalBorder(); border6.Append(leftBorder6); border6.Append(rightBorder6); border6.Append(topBorder6); border6.Append(bottomBorder6); border6.Append(diagonalBorder6); Border border7 = new Border(); LeftBorder leftBorder7 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color22 = new Color() { Indexed = (UInt32Value)64U }; leftBorder7.Append(color22); RightBorder rightBorder7 = new RightBorder(); TopBorder topBorder7 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color23 = new Color() { Indexed = (UInt32Value)64U }; topBorder7.Append(color23); BottomBorder bottomBorder7 = new BottomBorder(); DiagonalBorder diagonalBorder7 = new DiagonalBorder(); border7.Append(leftBorder7); border7.Append(rightBorder7); border7.Append(topBorder7); border7.Append(bottomBorder7); border7.Append(diagonalBorder7); Border border8 = new Border(); LeftBorder leftBorder8 = new LeftBorder(); RightBorder rightBorder8 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color24 = new Color() { Indexed = (UInt32Value)64U }; rightBorder8.Append(color24); TopBorder topBorder8 = new TopBorder(); BottomBorder bottomBorder8 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color25 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder8.Append(color25); DiagonalBorder diagonalBorder8 = new DiagonalBorder(); border8.Append(leftBorder8); border8.Append(rightBorder8); border8.Append(topBorder8); border8.Append(bottomBorder8); border8.Append(diagonalBorder8); Border border9 = new Border(); LeftBorder leftBorder9 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color26 = new Color() { Indexed = (UInt32Value)64U }; leftBorder9.Append(color26); RightBorder rightBorder9 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color27 = new Color() { Indexed = (UInt32Value)64U }; rightBorder9.Append(color27); TopBorder topBorder9 = new TopBorder(); BottomBorder bottomBorder9 = new BottomBorder(); DiagonalBorder diagonalBorder9 = new DiagonalBorder(); border9.Append(leftBorder9); border9.Append(rightBorder9); border9.Append(topBorder9); border9.Append(bottomBorder9); border9.Append(diagonalBorder9); Border border10 = new Border(); LeftBorder leftBorder10 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color28 = new Color() { Indexed = (UInt32Value)64U }; leftBorder10.Append(color28); RightBorder rightBorder10 = new RightBorder(); TopBorder topBorder10 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color29 = new Color() { Indexed = (UInt32Value)64U }; topBorder10.Append(color29); BottomBorder bottomBorder10 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color30 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder10.Append(color30); DiagonalBorder diagonalBorder10 = new DiagonalBorder(); border10.Append(leftBorder10); border10.Append(rightBorder10); border10.Append(topBorder10); border10.Append(bottomBorder10); border10.Append(diagonalBorder10); Border border11 = new Border(); LeftBorder leftBorder11 = new LeftBorder(); RightBorder rightBorder11 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color31 = new Color() { Indexed = (UInt32Value)64U }; rightBorder11.Append(color31); TopBorder topBorder11 = new TopBorder(); BottomBorder bottomBorder11 = new BottomBorder(); DiagonalBorder diagonalBorder11 = new DiagonalBorder(); border11.Append(leftBorder11); border11.Append(rightBorder11); border11.Append(topBorder11); border11.Append(bottomBorder11); border11.Append(diagonalBorder11); Border border12 = new Border(); LeftBorder leftBorder12 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color32 = new Color() { Indexed = (UInt32Value)64U }; leftBorder12.Append(color32); RightBorder rightBorder12 = new RightBorder(); TopBorder topBorder12 = new TopBorder(); BottomBorder bottomBorder12 = new BottomBorder(); DiagonalBorder diagonalBorder12 = new DiagonalBorder(); border12.Append(leftBorder12); border12.Append(rightBorder12); border12.Append(topBorder12); border12.Append(bottomBorder12); border12.Append(diagonalBorder12); Border border13 = new Border(); LeftBorder leftBorder13 = new LeftBorder() { Style = BorderStyleValues.Medium }; Color color33 = new Color() { Indexed = (UInt32Value)64U }; leftBorder13.Append(color33); RightBorder rightBorder13 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color34 = new Color() { Indexed = (UInt32Value)64U }; rightBorder13.Append(color34); TopBorder topBorder13 = new TopBorder() { Style = BorderStyleValues.Medium }; Color color35 = new Color() { Indexed = (UInt32Value)64U }; topBorder13.Append(color35); BottomBorder bottomBorder13 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color36 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder13.Append(color36); DiagonalBorder diagonalBorder13 = new DiagonalBorder(); border13.Append(leftBorder13); border13.Append(rightBorder13); border13.Append(topBorder13); border13.Append(bottomBorder13); border13.Append(diagonalBorder13); Border border14 = new Border(); LeftBorder leftBorder14 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color37 = new Color() { Indexed = (UInt32Value)64U }; leftBorder14.Append(color37); RightBorder rightBorder14 = new RightBorder() { Style = BorderStyleValues.Medium }; Color color38 = new Color() { Indexed = (UInt32Value)64U }; rightBorder14.Append(color38); TopBorder topBorder14 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color39 = new Color() { Indexed = (UInt32Value)64U }; topBorder14.Append(color39); BottomBorder bottomBorder14 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color40 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder14.Append(color40); DiagonalBorder diagonalBorder14 = new DiagonalBorder(); border14.Append(leftBorder14); border14.Append(rightBorder14); border14.Append(topBorder14); border14.Append(bottomBorder14); border14.Append(diagonalBorder14); Border border15 = new Border(); LeftBorder leftBorder15 = new LeftBorder() { Style = BorderStyleValues.Medium }; Color color41 = new Color() { Indexed = (UInt32Value)64U }; leftBorder15.Append(color41); RightBorder rightBorder15 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color42 = new Color() { Indexed = (UInt32Value)64U }; rightBorder15.Append(color42); TopBorder topBorder15 = new TopBorder(); BottomBorder bottomBorder15 = new BottomBorder() { Style = BorderStyleValues.Medium }; Color color43 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder15.Append(color43); DiagonalBorder diagonalBorder15 = new DiagonalBorder(); border15.Append(leftBorder15); border15.Append(rightBorder15); border15.Append(topBorder15); border15.Append(bottomBorder15); border15.Append(diagonalBorder15); Border border16 = new Border(); LeftBorder leftBorder16 = new LeftBorder(); RightBorder rightBorder16 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color44 = new Color() { Indexed = (UInt32Value)64U }; rightBorder16.Append(color44); TopBorder topBorder16 = new TopBorder(); BottomBorder bottomBorder16 = new BottomBorder() { Style = BorderStyleValues.Medium }; Color color45 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder16.Append(color45); DiagonalBorder diagonalBorder16 = new DiagonalBorder(); border16.Append(leftBorder16); border16.Append(rightBorder16); border16.Append(topBorder16); border16.Append(bottomBorder16); border16.Append(diagonalBorder16); Border border17 = new Border(); LeftBorder leftBorder17 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color46 = new Color() { Indexed = (UInt32Value)64U }; leftBorder17.Append(color46); RightBorder rightBorder17 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color47 = new Color() { Indexed = (UInt32Value)64U }; rightBorder17.Append(color47); TopBorder topBorder17 = new TopBorder(); BottomBorder bottomBorder17 = new BottomBorder() { Style = BorderStyleValues.Medium }; Color color48 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder17.Append(color48); DiagonalBorder diagonalBorder17 = new DiagonalBorder(); border17.Append(leftBorder17); border17.Append(rightBorder17); border17.Append(topBorder17); border17.Append(bottomBorder17); border17.Append(diagonalBorder17); Border border18 = new Border(); LeftBorder leftBorder18 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color49 = new Color() { Indexed = (UInt32Value)64U }; leftBorder18.Append(color49); RightBorder rightBorder18 = new RightBorder() { Style = BorderStyleValues.Medium }; Color color50 = new Color() { Indexed = (UInt32Value)64U }; rightBorder18.Append(color50); TopBorder topBorder18 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color51 = new Color() { Indexed = (UInt32Value)64U }; topBorder18.Append(color51); BottomBorder bottomBorder18 = new BottomBorder() { Style = BorderStyleValues.Medium }; Color color52 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder18.Append(color52); DiagonalBorder diagonalBorder18 = new DiagonalBorder(); border18.Append(leftBorder18); border18.Append(rightBorder18); border18.Append(topBorder18); border18.Append(bottomBorder18); border18.Append(diagonalBorder18); Border border19 = new Border(); LeftBorder leftBorder19 = new LeftBorder(); RightBorder rightBorder19 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color53 = new Color() { Indexed = (UInt32Value)64U }; rightBorder19.Append(color53); TopBorder topBorder19 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color54 = new Color() { Indexed = (UInt32Value)64U }; topBorder19.Append(color54); BottomBorder bottomBorder19 = new BottomBorder(); DiagonalBorder diagonalBorder19 = new DiagonalBorder(); border19.Append(leftBorder19); border19.Append(rightBorder19); border19.Append(topBorder19); border19.Append(bottomBorder19); border19.Append(diagonalBorder19); Border border20 = new Border(); LeftBorder leftBorder20 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color55 = new Color() { Indexed = (UInt32Value)64U }; leftBorder20.Append(color55); RightBorder rightBorder20 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color56 = new Color() { Indexed = (UInt32Value)64U }; rightBorder20.Append(color56); TopBorder topBorder20 = new TopBorder() { Style = BorderStyleValues.Medium }; Color color57 = new Color() { Indexed = (UInt32Value)64U }; topBorder20.Append(color57); BottomBorder bottomBorder20 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color58 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder20.Append(color58); DiagonalBorder diagonalBorder20 = new DiagonalBorder(); border20.Append(leftBorder20); border20.Append(rightBorder20); border20.Append(topBorder20); border20.Append(bottomBorder20); border20.Append(diagonalBorder20); Border border21 = new Border(); LeftBorder leftBorder21 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color59 = new Color() { Indexed = (UInt32Value)64U }; leftBorder21.Append(color59); RightBorder rightBorder21 = new RightBorder() { Style = BorderStyleValues.Medium }; Color color60 = new Color() { Indexed = (UInt32Value)64U }; rightBorder21.Append(color60); TopBorder topBorder21 = new TopBorder() { Style = BorderStyleValues.Medium }; Color color61 = new Color() { Indexed = (UInt32Value)64U }; topBorder21.Append(color61); BottomBorder bottomBorder21 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color62 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder21.Append(color62); DiagonalBorder diagonalBorder21 = new DiagonalBorder(); border21.Append(leftBorder21); border21.Append(rightBorder21); border21.Append(topBorder21); border21.Append(bottomBorder21); border21.Append(diagonalBorder21); Border border22 = new Border(); LeftBorder leftBorder22 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color63 = new Color() { Indexed = (UInt32Value)64U }; leftBorder22.Append(color63); RightBorder rightBorder22 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color64 = new Color() { Indexed = (UInt32Value)64U }; rightBorder22.Append(color64); TopBorder topBorder22 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color65 = new Color() { Indexed = (UInt32Value)64U }; topBorder22.Append(color65); BottomBorder bottomBorder22 = new BottomBorder() { Style = BorderStyleValues.Medium }; Color color66 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder22.Append(color66); DiagonalBorder diagonalBorder22 = new DiagonalBorder(); border22.Append(leftBorder22); border22.Append(rightBorder22); border22.Append(topBorder22); border22.Append(bottomBorder22); border22.Append(diagonalBorder22); Border border23 = new Border(); LeftBorder leftBorder23 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color67 = new Color() { Indexed = (UInt32Value)64U }; leftBorder23.Append(color67); RightBorder rightBorder23 = new RightBorder() { Style = BorderStyleValues.Medium }; Color color68 = new Color() { Indexed = (UInt32Value)64U }; rightBorder23.Append(color68); TopBorder topBorder23 = new TopBorder(); BottomBorder bottomBorder23 = new BottomBorder() { Style = BorderStyleValues.Medium }; Color color69 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder23.Append(color69); DiagonalBorder diagonalBorder23 = new DiagonalBorder(); border23.Append(leftBorder23); border23.Append(rightBorder23); border23.Append(topBorder23); border23.Append(bottomBorder23); border23.Append(diagonalBorder23); Border border24 = new Border(); LeftBorder leftBorder24 = new LeftBorder() { Style = BorderStyleValues.Medium }; Color color70 = new Color() { Indexed = (UInt32Value)64U }; leftBorder24.Append(color70); RightBorder rightBorder24 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color71 = new Color() { Indexed = (UInt32Value)64U }; rightBorder24.Append(color71); TopBorder topBorder24 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color72 = new Color() { Indexed = (UInt32Value)64U }; topBorder24.Append(color72); BottomBorder bottomBorder24 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color73 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder24.Append(color73); DiagonalBorder diagonalBorder24 = new DiagonalBorder(); border24.Append(leftBorder24); border24.Append(rightBorder24); border24.Append(topBorder24); border24.Append(bottomBorder24); border24.Append(diagonalBorder24); Border border25 = new Border(); LeftBorder leftBorder25 = new LeftBorder() { Style = BorderStyleValues.Medium }; Color color74 = new Color() { Indexed = (UInt32Value)64U }; leftBorder25.Append(color74); RightBorder rightBorder25 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color75 = new Color() { Indexed = (UInt32Value)64U }; rightBorder25.Append(color75); TopBorder topBorder25 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color76 = new Color() { Indexed = (UInt32Value)64U }; topBorder25.Append(color76); BottomBorder bottomBorder25 = new BottomBorder() { Style = BorderStyleValues.Medium }; Color color77 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder25.Append(color77); DiagonalBorder diagonalBorder25 = new DiagonalBorder(); border25.Append(leftBorder25); border25.Append(rightBorder25); border25.Append(topBorder25); border25.Append(bottomBorder25); border25.Append(diagonalBorder25); Border border26 = new Border(); LeftBorder leftBorder26 = new LeftBorder() { Style = BorderStyleValues.Medium }; Color color78 = new Color() { Indexed = (UInt32Value)64U }; leftBorder26.Append(color78); RightBorder rightBorder26 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color79 = new Color() { Indexed = (UInt32Value)64U }; rightBorder26.Append(color79); TopBorder topBorder26 = new TopBorder() { Style = BorderStyleValues.Medium }; Color color80 = new Color() { Indexed = (UInt32Value)64U }; topBorder26.Append(color80); BottomBorder bottomBorder26 = new BottomBorder() { Style = BorderStyleValues.Medium }; Color color81 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder26.Append(color81); DiagonalBorder diagonalBorder26 = new DiagonalBorder(); border26.Append(leftBorder26); border26.Append(rightBorder26); border26.Append(topBorder26); border26.Append(bottomBorder26); border26.Append(diagonalBorder26); Border border27 = new Border(); LeftBorder leftBorder27 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color82 = new Color() { Indexed = (UInt32Value)64U }; leftBorder27.Append(color82); RightBorder rightBorder27 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color83 = new Color() { Indexed = (UInt32Value)64U }; rightBorder27.Append(color83); TopBorder topBorder27 = new TopBorder() { Style = BorderStyleValues.Medium }; Color color84 = new Color() { Indexed = (UInt32Value)64U }; topBorder27.Append(color84); BottomBorder bottomBorder27 = new BottomBorder() { Style = BorderStyleValues.Medium }; Color color85 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder27.Append(color85); DiagonalBorder diagonalBorder27 = new DiagonalBorder(); border27.Append(leftBorder27); border27.Append(rightBorder27); border27.Append(topBorder27); border27.Append(bottomBorder27); border27.Append(diagonalBorder27); borders1.Append(border1); borders1.Append(border2); borders1.Append(border3); borders1.Append(border4); borders1.Append(border5); borders1.Append(border6); borders1.Append(border7); borders1.Append(border8); borders1.Append(border9); borders1.Append(border10); borders1.Append(border11); borders1.Append(border12); borders1.Append(border13); borders1.Append(border14); borders1.Append(border15); borders1.Append(border16); borders1.Append(border17); borders1.Append(border18); borders1.Append(border19); borders1.Append(border20); borders1.Append(border21); borders1.Append(border22); borders1.Append(border23); borders1.Append(border24); borders1.Append(border25); borders1.Append(border26); borders1.Append(border27); CellStyleFormats cellStyleFormats1 = new CellStyleFormats() { Count = (UInt32Value)1U }; CellFormat cellFormat1 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U }; cellStyleFormats1.Append(cellFormat1); CellFormats cellFormats1 = new CellFormats() { Count = (UInt32Value)95U }; CellFormat cellFormat2 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U }; CellFormat cellFormat3 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)9U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment1 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat3.Append(alignment1); CellFormat cellFormat4 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)9U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyProtection = true }; CellFormat cellFormat5 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyProtection = true }; CellFormat cellFormat6 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyProtection = true }; CellFormat cellFormat7 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment2 = new Alignment() { Horizontal = HorizontalAlignmentValues.CenterContinuous }; cellFormat7.Append(alignment2); CellFormat cellFormat8 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment3 = new Alignment() { Horizontal = HorizontalAlignmentValues.CenterContinuous }; cellFormat8.Append(alignment3); CellFormat cellFormat9 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)2U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyProtection = true }; CellFormat cellFormat10 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment4 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right }; cellFormat10.Append(alignment4); CellFormat cellFormat11 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyProtection = true }; CellFormat cellFormat12 = new CellFormat() { NumberFormatId = (UInt32Value)17U, FontId = (UInt32Value)5U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment5 = new Alignment() { Horizontal = HorizontalAlignmentValues.Left }; cellFormat12.Append(alignment5); CellFormat cellFormat13 = new CellFormat() { NumberFormatId = (UInt32Value)166U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment6 = new Alignment() { Horizontal = HorizontalAlignmentValues.Left }; cellFormat13.Append(alignment6); CellFormat cellFormat14 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment7 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat14.Append(alignment7); CellFormat cellFormat15 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment8 = new Alignment() { Horizontal = HorizontalAlignmentValues.Left }; cellFormat15.Append(alignment8); CellFormat cellFormat16 = new CellFormat() { NumberFormatId = (UInt32Value)17U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment9 = new Alignment() { Horizontal = HorizontalAlignmentValues.Left }; cellFormat16.Append(alignment9); CellFormat cellFormat17 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)13U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyProtection = true }; CellFormat cellFormat18 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)6U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyProtection = true }; CellFormat cellFormat19 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)9U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment10 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center }; cellFormat19.Append(alignment10); CellFormat cellFormat20 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)5U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment11 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat20.Append(alignment11); CellFormat cellFormat21 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)6U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment12 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat21.Append(alignment12); CellFormat cellFormat22 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)3U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment13 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat22.Append(alignment13); CellFormat cellFormat23 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment14 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat23.Append(alignment14); CellFormat cellFormat24 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)8U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment15 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat24.Append(alignment15); CellFormat cellFormat25 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)10U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment16 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat25.Append(alignment16); CellFormat cellFormat26 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)4U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)8U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment17 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat26.Append(alignment17); CellFormat cellFormat27 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)4U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)11U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment18 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat27.Append(alignment18); CellFormat cellFormat28 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)4U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)18U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment19 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat28.Append(alignment19); CellFormat cellFormat29 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment20 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat29.Append(alignment20); CellFormat cellFormat30 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)7U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment21 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat30.Append(alignment21); CellFormat cellFormat31 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)11U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyProtection = true }; CellFormat cellFormat32 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)12U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyProtection = true }; CellFormat cellFormat33 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)19U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment22 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat33.Append(alignment22); CellFormat cellFormat34 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)20U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment23 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat34.Append(alignment23); CellFormat cellFormat35 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)8U, BorderId = (UInt32Value)7U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment24 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat35.Append(alignment24); CellFormat cellFormat36 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)8U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment25 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat36.Append(alignment25); CellFormat cellFormat37 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)8U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment26 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat37.Append(alignment26); CellFormat cellFormat38 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment27 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat38.Append(alignment27); CellFormat cellFormat39 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)11U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment28 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat39.Append(alignment28); CellFormat cellFormat40 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)13U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment29 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat40.Append(alignment29); CellFormat cellFormat41 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)17U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment30 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat41.Append(alignment30); CellFormat cellFormat42 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)8U, BorderId = (UInt32Value)7U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment31 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat42.Append(alignment31); CellFormat cellFormat43 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)11U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment32 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center, WrapText = true }; cellFormat43.Append(alignment32); CellFormat cellFormat44 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)14U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment33 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right }; cellFormat44.Append(alignment33); CellFormat cellFormat45 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)15U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment34 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right }; cellFormat45.Append(alignment34); CellFormat cellFormat46 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment35 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat46.Append(alignment35); CellFormat cellFormat47 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)10U, FillId = (UInt32Value)5U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyProtection = true }; CellFormat cellFormat48 = new CellFormat() { NumberFormatId = (UInt32Value)49U, FontId = (UInt32Value)10U, FillId = (UInt32Value)5U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyProtection = true }; CellFormat cellFormat49 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)9U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment36 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat49.Append(alignment36); CellFormat cellFormat50 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)7U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)3U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment37 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right }; cellFormat50.Append(alignment37); CellFormat cellFormat51 = new CellFormat() { NumberFormatId = (UInt32Value)167U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)3U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment38 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right }; cellFormat51.Append(alignment38); CellFormat cellFormat52 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)10U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyProtection = true }; CellFormat cellFormat53 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)9U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyProtection = true }; CellFormat cellFormat54 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)4U, BorderId = (UInt32Value)9U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment39 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat54.Append(alignment39); CellFormat cellFormat55 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)8U, FillId = (UInt32Value)4U, BorderId = (UInt32Value)3U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment40 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right }; cellFormat55.Append(alignment40); CellFormat cellFormat56 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)11U, FillId = (UInt32Value)5U, BorderId = (UInt32Value)5U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment41 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center, WrapText = true }; cellFormat56.Append(alignment41); CellFormat cellFormat57 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)12U, FillId = (UInt32Value)6U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment42 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right, Vertical = VerticalAlignmentValues.Center }; cellFormat57.Append(alignment42); CellFormat cellFormat58 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)11U, FillId = (UInt32Value)6U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment43 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat58.Append(alignment43); CellFormat cellFormat59 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)12U, FillId = (UInt32Value)6U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment44 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right, Vertical = VerticalAlignmentValues.Center }; cellFormat59.Append(alignment44); CellFormat cellFormat60 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)11U, FillId = (UInt32Value)6U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment45 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat60.Append(alignment45); CellFormat cellFormat61 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)7U, FillId = (UInt32Value)7U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyProtection = true }; CellFormat cellFormat62 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)7U, FillId = (UInt32Value)7U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment46 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat62.Append(alignment46); CellFormat cellFormat63 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment47 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat63.Append(alignment47); CellFormat cellFormat64 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)16U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment48 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat64.Append(alignment48); CellFormat cellFormat65 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)22U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment49 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat65.Append(alignment49); CellFormat cellFormat66 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)23U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyProtection = true }; CellFormat cellFormat67 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)24U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment50 = new Alignment() { Horizontal = HorizontalAlignmentValues.Left }; cellFormat67.Append(alignment50); CellFormat cellFormat68 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)21U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment51 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat68.Append(alignment51); CellFormat cellFormat69 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)8U, BorderId = (UInt32Value)10U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment52 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat69.Append(alignment52); CellFormat cellFormat70 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)8U, BorderId = (UInt32Value)8U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment53 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat70.Append(alignment53); CellFormat cellFormat71 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)8U, BorderId = (UInt32Value)8U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment54 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat71.Append(alignment54); CellFormat cellFormat72 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)8U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment55 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat72.Append(alignment55); CellFormat cellFormat73 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)25U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment56 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat73.Append(alignment56); CellFormat cellFormat74 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)26U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment57 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat74.Append(alignment57); CellFormat cellFormat75 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)11U, FillId = (UInt32Value)11U, BorderId = (UInt32Value)9U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment58 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat75.Append(alignment58); CellFormat cellFormat76 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)11U, FillId = (UInt32Value)11U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment59 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat76.Append(alignment59); CellFormat cellFormat77 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)11U, FillId = (UInt32Value)11U, BorderId = (UInt32Value)3U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment60 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat77.Append(alignment60); CellFormat cellFormat78 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)7U, FillId = (UInt32Value)12U, BorderId = (UInt32Value)9U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment61 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat78.Append(alignment61); CellFormat cellFormat79 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)7U, FillId = (UInt32Value)12U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment62 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat79.Append(alignment62); CellFormat cellFormat80 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)7U, FillId = (UInt32Value)12U, BorderId = (UInt32Value)3U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment63 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat80.Append(alignment63); CellFormat cellFormat81 = new CellFormat() { NumberFormatId = (UInt32Value)17U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)9U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment64 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center }; cellFormat81.Append(alignment64); CellFormat cellFormat82 = new CellFormat() { NumberFormatId = (UInt32Value)17U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment65 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center }; cellFormat82.Append(alignment65); CellFormat cellFormat83 = new CellFormat() { NumberFormatId = (UInt32Value)17U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)3U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment66 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center }; cellFormat83.Append(alignment66); CellFormat cellFormat84 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)10U, BorderId = (UInt32Value)9U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment67 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center }; cellFormat84.Append(alignment67); CellFormat cellFormat85 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)10U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment68 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center }; cellFormat85.Append(alignment68); CellFormat cellFormat86 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)10U, BorderId = (UInt32Value)3U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment69 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center }; cellFormat86.Append(alignment69); CellFormat cellFormat87 = new CellFormat() { NumberFormatId = (UInt32Value)2U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)8U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment70 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right }; cellFormat87.Append(alignment70); CellFormat cellFormat88 = new CellFormat() { NumberFormatId = (UInt32Value)2U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment71 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right }; cellFormat88.Append(alignment71); CellFormat cellFormat89 = new CellFormat() { NumberFormatId = (UInt32Value)2U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment72 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right }; cellFormat89.Append(alignment72); CellFormat cellFormat90 = new CellFormat() { NumberFormatId = (UInt32Value)2U, FontId = (UInt32Value)3U, FillId = (UInt32Value)4U, BorderId = (UInt32Value)7U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment73 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right }; cellFormat90.Append(alignment73); CellFormat cellFormat91 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment74 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat91.Append(alignment74); CellFormat cellFormat92 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)5U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment75 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat92.Append(alignment75); CellFormat cellFormat93 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)26U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment76 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat93.Append(alignment76); CellFormat cellFormat94 = new CellFormat() { NumberFormatId = (UInt32Value)2U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment77 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat94.Append(alignment77); CellFormat cellFormat95 = new CellFormat() { NumberFormatId = (UInt32Value)2U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)5U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment78 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat95.Append(alignment78); CellFormat cellFormat96 = new CellFormat() { NumberFormatId = (UInt32Value)2U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)26U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment79 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat96.Append(alignment79); cellFormats1.Append(cellFormat2); cellFormats1.Append(cellFormat3); cellFormats1.Append(cellFormat4); cellFormats1.Append(cellFormat5); cellFormats1.Append(cellFormat6); cellFormats1.Append(cellFormat7); cellFormats1.Append(cellFormat8); cellFormats1.Append(cellFormat9); cellFormats1.Append(cellFormat10); cellFormats1.Append(cellFormat11); cellFormats1.Append(cellFormat12); cellFormats1.Append(cellFormat13); cellFormats1.Append(cellFormat14); cellFormats1.Append(cellFormat15); cellFormats1.Append(cellFormat16); cellFormats1.Append(cellFormat17); cellFormats1.Append(cellFormat18); cellFormats1.Append(cellFormat19); cellFormats1.Append(cellFormat20); cellFormats1.Append(cellFormat21); cellFormats1.Append(cellFormat22); cellFormats1.Append(cellFormat23); cellFormats1.Append(cellFormat24); cellFormats1.Append(cellFormat25); cellFormats1.Append(cellFormat26); cellFormats1.Append(cellFormat27); cellFormats1.Append(cellFormat28); cellFormats1.Append(cellFormat29); cellFormats1.Append(cellFormat30); cellFormats1.Append(cellFormat31); cellFormats1.Append(cellFormat32); cellFormats1.Append(cellFormat33); cellFormats1.Append(cellFormat34); cellFormats1.Append(cellFormat35); cellFormats1.Append(cellFormat36); cellFormats1.Append(cellFormat37); cellFormats1.Append(cellFormat38); cellFormats1.Append(cellFormat39); cellFormats1.Append(cellFormat40); cellFormats1.Append(cellFormat41); cellFormats1.Append(cellFormat42); cellFormats1.Append(cellFormat43); cellFormats1.Append(cellFormat44); cellFormats1.Append(cellFormat45); cellFormats1.Append(cellFormat46); cellFormats1.Append(cellFormat47); cellFormats1.Append(cellFormat48); cellFormats1.Append(cellFormat49); cellFormats1.Append(cellFormat50); cellFormats1.Append(cellFormat51); cellFormats1.Append(cellFormat52); cellFormats1.Append(cellFormat53); cellFormats1.Append(cellFormat54); cellFormats1.Append(cellFormat55); cellFormats1.Append(cellFormat56); cellFormats1.Append(cellFormat57); cellFormats1.Append(cellFormat58); cellFormats1.Append(cellFormat59); cellFormats1.Append(cellFormat60); cellFormats1.Append(cellFormat61); cellFormats1.Append(cellFormat62); cellFormats1.Append(cellFormat63); cellFormats1.Append(cellFormat64); cellFormats1.Append(cellFormat65); cellFormats1.Append(cellFormat66); cellFormats1.Append(cellFormat67); cellFormats1.Append(cellFormat68); cellFormats1.Append(cellFormat69); cellFormats1.Append(cellFormat70); cellFormats1.Append(cellFormat71); cellFormats1.Append(cellFormat72); cellFormats1.Append(cellFormat73); cellFormats1.Append(cellFormat74); cellFormats1.Append(cellFormat75); cellFormats1.Append(cellFormat76); cellFormats1.Append(cellFormat77); cellFormats1.Append(cellFormat78); cellFormats1.Append(cellFormat79); cellFormats1.Append(cellFormat80); cellFormats1.Append(cellFormat81); cellFormats1.Append(cellFormat82); cellFormats1.Append(cellFormat83); cellFormats1.Append(cellFormat84); cellFormats1.Append(cellFormat85); cellFormats1.Append(cellFormat86); cellFormats1.Append(cellFormat87); cellFormats1.Append(cellFormat88); cellFormats1.Append(cellFormat89); cellFormats1.Append(cellFormat90); cellFormats1.Append(cellFormat91); cellFormats1.Append(cellFormat92); cellFormats1.Append(cellFormat93); cellFormats1.Append(cellFormat94); cellFormats1.Append(cellFormat95); cellFormats1.Append(cellFormat96); CellStyles cellStyles1 = new CellStyles() { Count = (UInt32Value)1U }; CellStyle cellStyle1 = new CellStyle() { Name = "Normal", FormatId = (UInt32Value)0U, BuiltinId = (UInt32Value)0U }; cellStyles1.Append(cellStyle1); DifferentialFormats differentialFormats1 = new DifferentialFormats() { Count = (UInt32Value)1U }; DifferentialFormat differentialFormat1 = new DifferentialFormat(); Fill fill14 = new Fill(); PatternFill patternFill14 = new PatternFill() { PatternType = PatternValues.Solid }; BackgroundColor backgroundColor12 = new BackgroundColor() { Indexed = (UInt32Value)9U }; patternFill14.Append(backgroundColor12); fill14.Append(patternFill14); differentialFormat1.Append(fill14); differentialFormats1.Append(differentialFormat1); TableStyles tableStyles1 = new TableStyles() { Count = (UInt32Value)0U, DefaultTableStyle = "TableStyleMedium9", DefaultPivotStyle = "PivotStyleLight16" }; Colors colors1 = new Colors(); IndexedColors indexedColors1 = new IndexedColors(); RgbColor rgbColor1 = new RgbColor() { Rgb = "00000000" }; RgbColor rgbColor2 = new RgbColor() { Rgb = "00FFFFFF" }; RgbColor rgbColor3 = new RgbColor() { Rgb = "00FF0000" }; RgbColor rgbColor4 = new RgbColor() { Rgb = "0000FF00" }; RgbColor rgbColor5 = new RgbColor() { Rgb = "000000FF" }; RgbColor rgbColor6 = new RgbColor() { Rgb = "00FFFF00" }; RgbColor rgbColor7 = new RgbColor() { Rgb = "00FF00FF" }; RgbColor rgbColor8 = new RgbColor() { Rgb = "0000FFFF" }; RgbColor rgbColor9 = new RgbColor() { Rgb = "00000000" }; RgbColor rgbColor10 = new RgbColor() { Rgb = "00FFFFFF" }; RgbColor rgbColor11 = new RgbColor() { Rgb = "00FF0000" }; RgbColor rgbColor12 = new RgbColor() { Rgb = "0000FF00" }; RgbColor rgbColor13 = new RgbColor() { Rgb = "000000FF" }; RgbColor rgbColor14 = new RgbColor() { Rgb = "00FFFF00" }; RgbColor rgbColor15 = new RgbColor() { Rgb = "00FF00FF" }; RgbColor rgbColor16 = new RgbColor() { Rgb = "0000FFFF" }; RgbColor rgbColor17 = new RgbColor() { Rgb = "00800000" }; RgbColor rgbColor18 = new RgbColor() { Rgb = "00008000" }; RgbColor rgbColor19 = new RgbColor() { Rgb = "00000080" }; RgbColor rgbColor20 = new RgbColor() { Rgb = "00808000" }; RgbColor rgbColor21 = new RgbColor() { Rgb = "00800080" }; RgbColor rgbColor22 = new RgbColor() { Rgb = "00008080" }; RgbColor rgbColor23 = new RgbColor() { Rgb = "00C0C0C0" }; RgbColor rgbColor24 = new RgbColor() { Rgb = "00808080" }; RgbColor rgbColor25 = new RgbColor() { Rgb = "008080FF" }; RgbColor rgbColor26 = new RgbColor() { Rgb = "00802060" }; RgbColor rgbColor27 = new RgbColor() { Rgb = "00FFFFC0" }; RgbColor rgbColor28 = new RgbColor() { Rgb = "00A0E0E0" }; RgbColor rgbColor29 = new RgbColor() { Rgb = "00600080" }; RgbColor rgbColor30 = new RgbColor() { Rgb = "00FF8080" }; RgbColor rgbColor31 = new RgbColor() { Rgb = "000080C0" }; RgbColor rgbColor32 = new RgbColor() { Rgb = "00C0C0FF" }; RgbColor rgbColor33 = new RgbColor() { Rgb = "00000080" }; RgbColor rgbColor34 = new RgbColor() { Rgb = "00FF00FF" }; RgbColor rgbColor35 = new RgbColor() { Rgb = "00FFFF00" }; RgbColor rgbColor36 = new RgbColor() { Rgb = "0000FFFF" }; RgbColor rgbColor37 = new RgbColor() { Rgb = "00800080" }; RgbColor rgbColor38 = new RgbColor() { Rgb = "00800000" }; RgbColor rgbColor39 = new RgbColor() { Rgb = "00008080" }; RgbColor rgbColor40 = new RgbColor() { Rgb = "000000FF" }; RgbColor rgbColor41 = new RgbColor() { Rgb = "0000CCFF" }; RgbColor rgbColor42 = new RgbColor() { Rgb = "0069FFFF" }; RgbColor rgbColor43 = new RgbColor() { Rgb = "00CCFFCC" }; RgbColor rgbColor44 = new RgbColor() { Rgb = "00FFFF99" }; RgbColor rgbColor45 = new RgbColor() { Rgb = "00A6CAF0" }; RgbColor rgbColor46 = new RgbColor() { Rgb = "00CC9CCC" }; RgbColor rgbColor47 = new RgbColor() { Rgb = "00CC99FF" }; RgbColor rgbColor48 = new RgbColor() { Rgb = "00E3E3E3" }; RgbColor rgbColor49 = new RgbColor() { Rgb = "003366FF" }; RgbColor rgbColor50 = new RgbColor() { Rgb = "0033CCCC" }; RgbColor rgbColor51 = new RgbColor() { Rgb = "00339933" }; RgbColor rgbColor52 = new RgbColor() { Rgb = "00999933" }; RgbColor rgbColor53 = new RgbColor() { Rgb = "00996633" }; RgbColor rgbColor54 = new RgbColor() { Rgb = "00996666" }; RgbColor rgbColor55 = new RgbColor() { Rgb = "00666699" }; RgbColor rgbColor56 = new RgbColor() { Rgb = "00969696" }; RgbColor rgbColor57 = new RgbColor() { Rgb = "003333CC" }; RgbColor rgbColor58 = new RgbColor() { Rgb = "00336666" }; RgbColor rgbColor59 = new RgbColor() { Rgb = "00003300" }; RgbColor rgbColor60 = new RgbColor() { Rgb = "00333300" }; RgbColor rgbColor61 = new RgbColor() { Rgb = "00663300" }; RgbColor rgbColor62 = new RgbColor() { Rgb = "00993366" }; RgbColor rgbColor63 = new RgbColor() { Rgb = "00333399" }; RgbColor rgbColor64 = new RgbColor() { Rgb = "00424242" }; indexedColors1.Append(rgbColor1); indexedColors1.Append(rgbColor2); indexedColors1.Append(rgbColor3); indexedColors1.Append(rgbColor4); indexedColors1.Append(rgbColor5); indexedColors1.Append(rgbColor6); indexedColors1.Append(rgbColor7); indexedColors1.Append(rgbColor8); indexedColors1.Append(rgbColor9); indexedColors1.Append(rgbColor10); indexedColors1.Append(rgbColor11); indexedColors1.Append(rgbColor12); indexedColors1.Append(rgbColor13); indexedColors1.Append(rgbColor14); indexedColors1.Append(rgbColor15); indexedColors1.Append(rgbColor16); indexedColors1.Append(rgbColor17); indexedColors1.Append(rgbColor18); indexedColors1.Append(rgbColor19); indexedColors1.Append(rgbColor20); indexedColors1.Append(rgbColor21); indexedColors1.Append(rgbColor22); indexedColors1.Append(rgbColor23); indexedColors1.Append(rgbColor24); indexedColors1.Append(rgbColor25); indexedColors1.Append(rgbColor26); indexedColors1.Append(rgbColor27); indexedColors1.Append(rgbColor28); indexedColors1.Append(rgbColor29); indexedColors1.Append(rgbColor30); indexedColors1.Append(rgbColor31); indexedColors1.Append(rgbColor32); indexedColors1.Append(rgbColor33); indexedColors1.Append(rgbColor34); indexedColors1.Append(rgbColor35); indexedColors1.Append(rgbColor36); indexedColors1.Append(rgbColor37); indexedColors1.Append(rgbColor38); indexedColors1.Append(rgbColor39); indexedColors1.Append(rgbColor40); indexedColors1.Append(rgbColor41); indexedColors1.Append(rgbColor42); indexedColors1.Append(rgbColor43); indexedColors1.Append(rgbColor44); indexedColors1.Append(rgbColor45); indexedColors1.Append(rgbColor46); indexedColors1.Append(rgbColor47); indexedColors1.Append(rgbColor48); indexedColors1.Append(rgbColor49); indexedColors1.Append(rgbColor50); indexedColors1.Append(rgbColor51); indexedColors1.Append(rgbColor52); indexedColors1.Append(rgbColor53); indexedColors1.Append(rgbColor54); indexedColors1.Append(rgbColor55); indexedColors1.Append(rgbColor56); indexedColors1.Append(rgbColor57); indexedColors1.Append(rgbColor58); indexedColors1.Append(rgbColor59); indexedColors1.Append(rgbColor60); indexedColors1.Append(rgbColor61); indexedColors1.Append(rgbColor62); indexedColors1.Append(rgbColor63); indexedColors1.Append(rgbColor64); colors1.Append(indexedColors1); stylesheet1.Append(numberingFormats1); stylesheet1.Append(fonts1); stylesheet1.Append(fills1); stylesheet1.Append(borders1); stylesheet1.Append(cellStyleFormats1); stylesheet1.Append(cellFormats1); stylesheet1.Append(cellStyles1); stylesheet1.Append(differentialFormats1); stylesheet1.Append(tableStyles1); stylesheet1.Append(colors1); workbookStylesPart1.Stylesheet = stylesheet1; }
/** * Specifies the border which shall be displayed between each paragraph in a * Set of paragraphs which have the same Set of paragraph border Settings. * <p> * To determine if any two adjoining paragraphs should have a between border * or an individual top and bottom border, the Set of borders on the two * adjoining paragraphs are Compared. If the border information on those two * paragraphs is identical for all possible paragraphs borders, then the * between border is displayed. Otherwise, each paragraph shall use its * bottom and top border, respectively. If this border specifies a space * attribute, that value is ignored - this border is always located at the * bottom of each paragraph with an identical following paragraph, taking * into account any space After the line pitch. * </p> * <p> * If this element is omitted on a given paragraph, its value is determined * by the Setting previously Set at any level of the style hierarchy (i.e. * that previous Setting remains unChanged). If this Setting is never * specified in the style hierarchy, then no between border shall be applied * between identical paragraphs. * </p> * <b>This border can only be a line border.</b> * * @param border * @see Borders for a list of all possible borders */ public void SetBorderBetween(Borders border) { CT_PBdr ct = GetCTPBrd(true); CT_Border pr = ct.IsSetBetween() ? ct.between : ct.AddNewBetween(); if (border == Borders.NONE) ct.UnsetBetween(); else pr.val = EnumConverter.ValueOf<ST_Border, Borders>(border); }
private void SetupStyles() { bordersStyle = new Borders(new Pen(new Color(117, 117, 117), (float)0.5, DashStyle.Solid)); fontStyle = new Font("Arial Unicode MS", 9); headerFont = new Font("Arial Unicode MS", 11, 0); }