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 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;
}
}
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);
}
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 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);
}
