public IXLCFDataBarMin DataBar(XLColor color, Boolean showBarOnly = false)
{
Colors.Initialize(color);
ShowBarOnly = showBarOnly;
ConditionalFormatType = XLConditionalFormatType.DataBar;
return(new XLCFDataBarMin(this));
}
public IXLCFColorScaleMid Minimum(XLCFContentType type, String value, XLColor color)
{
_conditionalFormat.Values.Initialize(new XLFormula { Value = value });
_conditionalFormat.Colors.Initialize(color);
_conditionalFormat.ContentTypes.Initialize(type);
return new XLCFColorScaleMid(_conditionalFormat);
}
private XLFontValue(XLFontKey key)
{
Key = key;
var fontColorKey = Key.FontColor;
FontColor = XLColor.FromKey(ref fontColorKey);
}
public IXLCFColorScaleMid LowestValue(XLColor color)
{
_conditionalFormat.Values.Initialize(null);
_conditionalFormat.Colors.Initialize(color);
_conditionalFormat.ContentTypes.Initialize(XLCFContentType.Minimum);
return(new XLCFColorScaleMid(_conditionalFormat));
}
public XLFont(IXLStylized container, IXLFontBase defaultFont, Boolean useDefaultModify = true)
{
_container = container;
if (defaultFont == null) return;
_bold = defaultFont.Bold;
_italic = defaultFont.Italic;
_underline = defaultFont.Underline;
_strikethrough = defaultFont.Strikethrough;
_verticalAlignment = defaultFont.VerticalAlignment;
_shadow = defaultFont.Shadow;
_fontSize = defaultFont.FontSize;
_fontColor = defaultFont.FontColor;
_fontName = defaultFont.FontName;
_fontFamilyNumbering = defaultFont.FontFamilyNumbering;
if (useDefaultModify)
{
var d = defaultFont as XLFont;
if (d == null) return;
BoldModified = d.BoldModified;
ItalicModified = d.ItalicModified;
UnderlineModified = d.UnderlineModified;
StrikethroughModified = d.StrikethroughModified;
VerticalAlignmentModified = d.VerticalAlignmentModified;
ShadowModified = d.ShadowModified;
FontSizeModified = d.FontSizeModified;
FontColorModified = d.FontColorModified;
FontNameModified = d.FontNameModified;
FontFamilyNumberingModified = d.FontFamilyNumberingModified;
}
}
public IXLCFColorScaleMax Midpoint(XLCFContentType type, String value, XLColor color)
{
_conditionalFormat.Values.Add(new XLFormula { Value = value });
_conditionalFormat.Colors.Add(color);
_conditionalFormat.ContentTypes.Add(type);
return new XLCFColorScaleMax(_conditionalFormat);
}
public void Maximum(XLCFContentType type, String value, XLColor color)
{
_conditionalFormat.Values.Add(new XLFormula {
Value = value
});
_conditionalFormat.Colors.Add(color);
_conditionalFormat.ContentTypes.Add(type);
}
public XLDrawingFont(IXLDrawingStyle style)
{
_style = style;
FontName = "Tahoma";
FontSize = 9;
Underline = XLFontUnderlineValues.None;
FontColor = XLColor.FromIndex(64);
}
private XLFillValue(XLFillKey key)
{
Key = key;
var backgroundColorKey = Key.BackgroundColor;
var patternColorKey = Key.PatternColor;
BackgroundColor = XLColor.FromKey(ref backgroundColorKey);
PatternColor = XLColor.FromKey(ref patternColorKey);
}
public IXLCFColorScaleMid Minimum(XLCFContentType type, String value, XLColor color)
{
_conditionalFormat.Values.Initialize(new XLFormula {
Value = value
});
_conditionalFormat.Colors.Initialize(color);
_conditionalFormat.ContentTypes.Initialize(type);
return(new XLCFColorScaleMid(_conditionalFormat));
}
public IXLCFColorScaleMax Midpoint(XLCFContentType type, String value, XLColor color)
{
_conditionalFormat.Values.Add(new XLFormula {
Value = value
});
_conditionalFormat.Colors.Add(color);
_conditionalFormat.ContentTypes.Add(type);
return(new XLCFColorScaleMax(_conditionalFormat));
}
private XLBorderValue(XLBorderKey key)
{
Key = key;
LeftBorderColor = XLColor.FromKey(Key.LeftBorderColor);
RightBorderColor = XLColor.FromKey(Key.RightBorderColor);
TopBorderColor = XLColor.FromKey(Key.TopBorderColor);
BottomBorderColor = XLColor.FromKey(Key.BottomBorderColor);
DiagonalBorderColor = XLColor.FromKey(Key.DiagonalBorderColor);
}
private void Initialize(XLCell cell)
{
Author = cell.Worksheet.Author;
Container = this;
Anchor = XLDrawingAnchor.MoveAndSizeWithCells;
Style = new XLDrawingStyle();
Int32 pRow = cell.Address.RowNumber;
Double pRowOffset = 0;
if (pRow > 1)
{
pRow--;
double prevHeight = cell.CellAbove().WorksheetRow().Height;
if (prevHeight > 7)
{
pRowOffset = prevHeight - 7;
}
}
Position = new XLDrawingPosition
{
Column = cell.Address.ColumnNumber + 1,
ColumnOffset = 2,
Row = pRow,
RowOffset = pRowOffset
};
ZOrder = cell.Worksheet.ZOrder++;
Style
.Margins.SetLeft(0.1)
.Margins.SetRight(0.1)
.Margins.SetTop(0.05)
.Margins.SetBottom(0.05)
.Margins.SetAutomatic()
.Size.SetHeight(59.25)
.Size.SetWidth(19.2)
.ColorsAndLines.SetLineColor(XLColor.Black)
.ColorsAndLines.SetFillColor(XLColor.FromArgb(255, 255, 225))
.ColorsAndLines.SetLineDash(XLDashStyle.Solid)
.ColorsAndLines.SetLineStyle(XLLineStyle.Single)
.ColorsAndLines.SetLineWeight(0.75)
.ColorsAndLines.SetFillTransparency(1)
.ColorsAndLines.SetLineTransparency(1)
.Alignment.SetHorizontal(XLDrawingHorizontalAlignment.Left)
.Alignment.SetVertical(XLDrawingVerticalAlignment.Top)
.Alignment.SetDirection(XLDrawingTextDirection.Context)
.Alignment.SetOrientation(XLDrawingTextOrientation.LeftToRight)
.Properties.SetPositioning(XLDrawingAnchor.Absolute)
.Protection.SetLocked()
.Protection.SetLockText();
_cell = cell;
ShapeId = cell.Worksheet.Workbook.ShapeIdManager.GetNext();
}
public void Delete()
{
if (Cell == null)
{
return;
}
Worksheet.Hyperlinks.Delete(Cell.Address);
if (Cell.Style.Font.FontColor.Equals(XLColor.FromTheme(XLThemeColor.Hyperlink)))
{
Cell.Style.Font.FontColor = Worksheet.Style.Font.FontColor;
}
Cell.Style.Font.Underline = Worksheet.Style.Font.Underline;
}
private XLBorderValue(XLBorderKey key)
{
Key = key;
var leftBorderColor = Key.LeftBorderColor;
var rightBorderColor = Key.RightBorderColor;
var topBorderColor = Key.TopBorderColor;
var bottomBorderColor = Key.BottomBorderColor;
var diagonalBorderColor = Key.DiagonalBorderColor;
LeftBorderColor = XLColor.FromKey(ref leftBorderColor);
RightBorderColor = XLColor.FromKey(ref rightBorderColor);
TopBorderColor = XLColor.FromKey(ref topBorderColor);
BottomBorderColor = XLColor.FromKey(ref bottomBorderColor);
DiagonalBorderColor = XLColor.FromKey(ref diagonalBorderColor);
}
public void Dispose()
{
_topBorders.ForEach(kp => _range.FirstRow().Cell(kp.Key).Style
.Border.SetTopBorder(kp.Value.TopBorder)
.Border.SetTopBorderColor(XLColor.FromKey(kp.Value.TopBorderColor)));
_bottomBorders.ForEach(kp => _range.LastRow().Cell(kp.Key).Style
.Border.SetBottomBorder(kp.Value.BottomBorder)
.Border.SetBottomBorderColor(XLColor.FromKey(kp.Value.BottomBorderColor)));
_leftBorders.ForEach(kp => _range.FirstColumn().Cell(kp.Key).Style
.Border.SetLeftBorder(kp.Value.LeftBorder)
.Border.SetLeftBorderColor(XLColor.FromKey(kp.Value.LeftBorderColor)));
_rightBorders.ForEach(kp => _range.LastColumn().Cell(kp.Key).Style
.Border.SetRightBorder(kp.Value.RightBorder)
.Border.SetRightBorderColor(XLColor.FromKey(kp.Value.RightBorderColor)));
}
public XLFill(IXLStylized container, IXLFill defaultFill = null, Boolean useDefaultModify = true)
{
_container = container;
if (defaultFill == null)
{
return;
}
_patternType = defaultFill.PatternType;
_backgroundColor = defaultFill.BackgroundColor;
_patternColor = defaultFill.PatternColor;
if (useDefaultModify)
{
var d = defaultFill as XLFill;
}
}
public XLWorksheet(String sheetName, XLWorkbook workbook)
: base(
new XLRangeAddress(
new XLAddress(null, XLHelper.MinRowNumber, XLHelper.MinColumnNumber, false, false),
new XLAddress(null, XLHelper.MaxRowNumber, XLHelper.MaxColumnNumber, false, false)))
{
EventTrackingEnabled = workbook.EventTracking == XLEventTracking.Enabled;
RangeAddress.Worksheet = this;
RangeAddress.FirstAddress.Worksheet = this;
RangeAddress.LastAddress.Worksheet = this;
NamedRanges = new XLNamedRanges(workbook);
SheetView = new XLSheetView();
Tables = new XLTables();
Hyperlinks = new XLHyperlinks();
DataValidations = new XLDataValidations();
PivotTables = new XLPivotTables();
Protection = new XLSheetProtection();
AutoFilter = new XLAutoFilter();
ConditionalFormats = new XLConditionalFormats();
Workbook = workbook;
SetStyle(workbook.Style);
Internals = new XLWorksheetInternals(new XLCellsCollection(), new XLColumnsCollection(),
new XLRowsCollection(), new XLRanges());
PageSetup = new XLPageSetup((XLPageSetup)workbook.PageOptions, this);
Outline = new XLOutline(workbook.Outline);
_columnWidth = workbook.ColumnWidth;
_rowHeight = workbook.RowHeight;
RowHeightChanged = Math.Abs(workbook.RowHeight - XLWorkbook.DefaultRowHeight) > XLHelper.Epsilon;
Name = sheetName;
SubscribeToShiftedRows(WorksheetRangeShiftedRows);
SubscribeToShiftedColumns(WorksheetRangeShiftedColumns);
Charts = new XLCharts();
ShowFormulas = workbook.ShowFormulas;
ShowGridLines = workbook.ShowGridLines;
ShowOutlineSymbols = workbook.ShowOutlineSymbols;
ShowRowColHeaders = workbook.ShowRowColHeaders;
ShowRuler = workbook.ShowRuler;
ShowWhiteSpace = workbook.ShowWhiteSpace;
ShowZeros = workbook.ShowZeros;
RightToLeft = workbook.RightToLeft;
TabColor = new XLColor();
SelectedRanges = new XLRanges();
Author = workbook.Author;
}
private void InitializeTheme()
{
Theme = new XLTheme
{
Text1 = XLColor.FromHtml("#FF000000"),
Background1 = XLColor.FromHtml("#FFFFFFFF"),
Text2 = XLColor.FromHtml("#FF1F497D"),
Background2 = XLColor.FromHtml("#FFEEECE1"),
Accent1 = XLColor.FromHtml("#FF4F81BD"),
Accent2 = XLColor.FromHtml("#FFC0504D"),
Accent3 = XLColor.FromHtml("#FF9BBB59"),
Accent4 = XLColor.FromHtml("#FF8064A2"),
Accent5 = XLColor.FromHtml("#FF4BACC6"),
Accent6 = XLColor.FromHtml("#FFF79646"),
Hyperlink = XLColor.FromHtml("#FF0000FF"),
FollowedHyperlink = XLColor.FromHtml("#FF800080")
};
}
internal XLColor(XLColor defaultColor)
{
var dColor = defaultColor;
if (dColor._colorType == XLColorType.Color)
_color = dColor._color;
else if (dColor._colorType == XLColorType.Theme)
{
_themeColor = dColor._themeColor;
_themeTint = dColor._themeTint;
}
else
{
_indexed = dColor._indexed;
}
HasValue = true;
_hashCode = dColor._hashCode;
_colorType = dColor._colorType;
}
public XLFill(IXLStylized container, IXLFill defaultFill = null, Boolean useDefaultModify = true)
{
_container = container;
if (defaultFill == null)
{
return;
}
_patternType = defaultFill.PatternType;
_patternColor = new XLColor(defaultFill.PatternColor);
_patternBackgroundColor = new XLColor(defaultFill.PatternBackgroundColor);
if (useDefaultModify)
{
var d = defaultFill as XLFill;
PatternBackgroundColorModified = d.PatternBackgroundColorModified;
PatternColorModified = d.PatternColorModified;
PatternTypeModified = d.PatternTypeModified;
}
}
public XLFont(IXLStylized container, IXLFontBase defaultFont, Boolean useDefaultModify = true)
{
_container = container;
if (defaultFont == null)
{
return;
}
_bold = defaultFont.Bold;
_italic = defaultFont.Italic;
_underline = defaultFont.Underline;
_strikethrough = defaultFont.Strikethrough;
_verticalAlignment = defaultFont.VerticalAlignment;
_shadow = defaultFont.Shadow;
_fontSize = defaultFont.FontSize;
_fontColor = defaultFont.FontColor;
_fontName = defaultFont.FontName;
_fontFamilyNumbering = defaultFont.FontFamilyNumbering;
_fontCharSet = defaultFont.FontCharSet;
if (useDefaultModify)
{
var d = defaultFont as XLFont;
if (d == null)
{
return;
}
BoldModified = d.BoldModified;
ItalicModified = d.ItalicModified;
UnderlineModified = d.UnderlineModified;
StrikethroughModified = d.StrikethroughModified;
VerticalAlignmentModified = d.VerticalAlignmentModified;
ShadowModified = d.ShadowModified;
FontSizeModified = d.FontSizeModified;
FontColorModified = d.FontColorModified;
FontNameModified = d.FontNameModified;
FontFamilyNumberingModified = d.FontFamilyNumberingModified;
FontCharSetModified = d.FontCharSetModified;
}
}
private XLColor(XLColor defaultColor)
{
var dColor = defaultColor;
if (dColor._colorType == XLColorType.Color)
{
_color = dColor._color;
}
else if (dColor._colorType == XLColorType.Theme)
{
_themeColor = dColor._themeColor;
_themeTint = dColor._themeTint;
}
else
{
_indexed = dColor._indexed;
}
HasValue = true;
_hashCode = dColor._hashCode;
_colorType = dColor._colorType;
}
public XLBorder(IXLStylized container, IXLBorder defaultBorder, Boolean useDefaultModify = true)
{
_container = container;
if (defaultBorder == null)
{
return;
}
_leftBorder = defaultBorder.LeftBorder;
_leftBorderColor = new XLColor(defaultBorder.LeftBorderColor);
_rightBorder = defaultBorder.RightBorder;
_rightBorderColor = new XLColor(defaultBorder.RightBorderColor);
_topBorder = defaultBorder.TopBorder;
_topBorderColor = new XLColor(defaultBorder.TopBorderColor);
_bottomBorder = defaultBorder.BottomBorder;
_bottomBorderColor = new XLColor(defaultBorder.BottomBorderColor);
_diagonalBorder = defaultBorder.DiagonalBorder;
_diagonalBorderColor = new XLColor(defaultBorder.DiagonalBorderColor);
_diagonalUp = defaultBorder.DiagonalUp;
_diagonalDown = defaultBorder.DiagonalDown;
if (useDefaultModify)
{
var d = defaultBorder as XLBorder;
BottomBorderColorModified = d.BottomBorderColorModified;
BottomBorderModified = d.BottomBorderModified;
DiagonalBorderColorModified = d.DiagonalBorderColorModified;
DiagonalBorderModified = d.DiagonalBorderModified;
DiagonalDownModified = d.DiagonalDownModified;
DiagonalUpModified = d.DiagonalUpModified;
LeftBorderColorModified = d.LeftBorderColorModified;
LeftBorderModified = d.LeftBorderModified;
RightBorderColorModified = d.RightBorderColorModified;
RightBorderModified = d.RightBorderModified;
TopBorderColorModified = d.TopBorderColorModified;
TopBorderModified = d.TopBorderModified;
}
}
public IXLStyle SetTopBorderColor(XLColor value)
{
TopBorderColor = value;
return _container.Style;
}
private bool HasNoFill()
{
return(PatternType == XLFillPatternValues.None ||
(PatternType == XLFillPatternValues.Solid && XLColor.IsTransparent(BackgroundColor)));
}
public IXLStyle SetDiagonalBorderColor(XLColor value)
{
DiagonalBorderColor = value;
return(_container.Style);
}
public IXLStyle SetBottomBorderColor(XLColor value)
{
BottomBorderColor = value;
return(_container.Style);
}
public Row Color(XLColor color)
{
_row.Style.Font.FontColor = color;
return this;
}
private void addRightBottomBorder(IXLCell cell, XLBorderStyleValues border = XLBorderStyleValues.Thick, XLColor color = null)
{
if (color == null)
{
color = XLColor.Black;
}
addBottomBorder(cell, border, color);
addRightBorder(cell, border, color);
}
private static TabColor GetTabColor(XLColor xlColor)
{
var color = new TabColor();
if (xlColor.ColorType == XLColorType.Color)
color.Rgb = xlColor.Color.ToHex();
else if (xlColor.ColorType == XLColorType.Indexed)
color.Indexed = (UInt32)xlColor.Indexed;
else
{
color.Theme = (UInt32)xlColor.ThemeColor;
if (xlColor.ThemeTint != 1)
color.Tint = xlColor.ThemeTint;
}
return color;
}
public IXLCFColorScaleMax Midpoint(XLCFContentType type, Double value, XLColor color)
{
return Midpoint(type, value.ToString(), color);
}
public XLColor LineColor { get; set; } public IXLDrawingStyle SetLineColor(XLColor value) { LineColor = value; return _style; }
public Row BgColor(XLColor color)
{
_row.Style.Fill.BackgroundColor = color;
return this;
}
public XLColor FillColor { get; set; } public IXLDrawingStyle SetFillColor(XLColor value) { FillColor = value; return _style; }
public IXLStyle SetBottomBorderColor(XLColor value)
{
BottomBorderColor = value;
return _container.Style;
}
private static void CreateDbStylesheet(Competition c, XLWorkbook xLWorkbook)
{
IXLWorksheet iXLWorksheet = xLWorkbook.Worksheets.Add("DB");
iXLWorksheet.ColumnWidth = 2;
iXLWorksheet.Style.Font.SetFontSize(8);
Dictionary<string, string> ranges = new Dictionary<string, string>();
ranges.Add("B", "K");
ranges.Add("M", "V");
ranges.Add("X", "AG");
ranges.Add("AI", "AR");
ranges.Add("AT", "BC");
ranges.Add("BE", "BN");
string[] headers = new string[] { "UU", "GU", "AU", "MU", "MPG", "0", "GU", "AU", "GU", "AU" };
XLColor[][] colormatrix = new XLColor[10][];
colormatrix[0] = new XLColor[] {
XLColor.FromArgb(255, 192, 0), XLColor.FromArgb(255, 192, 0), XLColor.FromArgb(255, 192, 0), XLColor.FromArgb(255, 192, 0), XLColor.FromArgb(255, 192, 0),
XLColor.FromArgb(255, 192, 0), XLColor.FromArgb(255, 192, 0), XLColor.FromArgb(255, 192, 0), XLColor.FromArgb(255, 192, 0), XLColor.FromArgb(255, 192, 0) };
colormatrix[1] = new XLColor[] {
XLColor.FromArgb(0, 176, 80), XLColor.FromArgb(146, 208, 80), XLColor.FromArgb(146, 208, 80), XLColor.FromArgb(146, 208, 80), XLColor.FromArgb(146, 208, 80),
XLColor.FromArgb(0, 176, 80), XLColor.FromArgb(169, 208, 142), XLColor.FromArgb(169, 208, 142), XLColor.FromArgb(137, 207, 240), XLColor.FromArgb(137, 207, 240) };
colormatrix[2] = new XLColor[] {
XLColor.FromArgb(0, 176, 80), XLColor.FromArgb(255, 201, 105), XLColor.FromArgb(255, 201, 105), XLColor.FromArgb(255, 201, 105), XLColor.FromArgb(255, 201, 105),
XLColor.FromArgb(0, 176, 80), XLColor.FromArgb(255, 255, 255), XLColor.FromArgb(255, 255, 255), XLColor.FromArgb(144, 238, 144), XLColor.FromArgb(144, 238, 144) };
colormatrix[3] = new XLColor[] {
XLColor.FromArgb(137, 207, 240), XLColor.FromArgb(191, 143, 0), XLColor.FromArgb(191, 143, 0), XLColor.FromArgb(191, 143, 0), XLColor.FromArgb(191, 143, 0),
XLColor.FromArgb(0, 176, 80), XLColor.FromArgb(255, 255, 255), XLColor.FromArgb(255, 255, 255), XLColor.FromArgb(137, 207, 240), XLColor.FromArgb(137, 207, 240) };
colormatrix[4] = new XLColor[] {
XLColor.FromArgb(144, 238, 144), XLColor.FromArgb(255, 255, 255), XLColor.FromArgb(255, 255, 255), XLColor.FromArgb(255, 255, 255), XLColor.FromArgb(255, 255, 255),
XLColor.FromArgb(0, 176, 80), XLColor.FromArgb(255, 255, 255), XLColor.FromArgb(255, 255, 255), XLColor.FromArgb(255, 201, 105), XLColor.FromArgb(255, 201, 105) };
colormatrix[5] = new XLColor[] {
XLColor.FromArgb(255, 201, 105), XLColor.FromArgb(255, 255, 255), XLColor.FromArgb(255, 255, 255), XLColor.FromArgb(255, 255, 255), XLColor.FromArgb(255, 255, 255),
XLColor.FromArgb(169, 208, 142), XLColor.FromArgb(255, 201, 105), XLColor.FromArgb(191, 143, 0), XLColor.FromArgb(137, 207, 240), XLColor.FromArgb(137, 207, 240) };
colormatrix[6] = new XLColor[] {
XLColor.FromArgb(169, 208, 142), XLColor.FromArgb(169, 208, 142), XLColor.FromArgb(169, 208, 142), XLColor.FromArgb(169, 208, 142), XLColor.FromArgb(255, 255, 255),
XLColor.FromArgb(189, 146, 222), XLColor.FromArgb(255, 255, 255), XLColor.FromArgb(255, 255, 255), XLColor.FromArgb(191, 143, 0), XLColor.FromArgb(191, 143, 0) };
int numberOfRows = ranges.Count;
IXLCell scr = null;
for (int i = 0; i < c.Teams.Count; i++)
{
int row = i / 6;
int column = i % 6;
KeyValuePair<string, string> kvp = ranges.ElementAt(column);
iXLWorksheet.Range(kvp.Key + (1 + row * 8).ToString(), kvp.Value + (1 + row * 8).ToString()).Merge().Value = c.Teams[i].TeamName;
iXLWorksheet.Range(kvp.Key + (1 + row * 8).ToString(), kvp.Value + (1 + row * 8).ToString()).Style.Alignment.Vertical = XLAlignmentVerticalValues.Center;
iXLWorksheet.Row(1 + row * 8).Height = 24.75 * 0.75;
iXLWorksheet.Cell(kvp.Key + (1 + row * 8).ToString()).Hyperlink = new XLHyperlink(c.Teams[i].Url);// URL??
iXLWorksheet.Cell(kvp.Key + (1 + row * 8).ToString()).Style.Font.SetFontSize(12);
iXLWorksheet.Range(kvp.Key + (1 + row * 8).ToString(), kvp.Value + (1 + row * 8).ToString()).Style.Font.Bold = true;
iXLWorksheet.Range(kvp.Key + (1 + row * 8).ToString(), kvp.Value + (1 + row * 8).ToString()).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
iXLWorksheet.Range(kvp.Key + (1 + row * 8).ToString(), kvp.Value + (1 + row * 8).ToString()).Style.Fill.BackgroundColor = XLColor.FromArgb(255, 255, 0);
var sc = iXLWorksheet.Cell(kvp.Key + (1 + row * 8).ToString());
scr = sc.CellBelow();
sc = sc.CellBelow();
for (int l = 0; l < headers.Length; l++)
{
scr.Value = headers[l];
scr.Style.Fill.BackgroundColor = colormatrix[0][l];
scr = scr.CellRight();
}
for (int j = 0; j < 6; j++)
{
scr = sc.CellBelow();
sc = sc.CellBelow();
for (int k = 0; k < 10; k++)
{
scr.Style.Fill.BackgroundColor = colormatrix[j + 1][k];
scr.Style.Border.SetBottomBorder(XLBorderStyleValues.Thin);
scr.Style.Border.OutsideBorder = XLBorderStyleValues.Thin;
scr.Value = 0;
scr.FormulaA1 = "'" + Application.StartupPath + Helper.GetCompetitionArchiveDirectoryName(c) + "\\[" + c.Teams[i].TeamName.NormalizeString() + ".xlsx]" + c.Teams[i].TeamName.NormalizeString().Left(31) + "'!" + iXLWorksheet.Cell(237 + j, 8 + k).Address.ToString();
scr = scr.CellRight();
}
}
}
}
public IXLStyle SetFontColor(XLColor value)
{
FontColor = value;
return _container.Style;
}
public void Maximum(XLCFContentType type, String value, XLColor color)
{
Midpoint(type, value, color);
}
public IXLStyle SetOutsideBorderColor(XLColor value)
{
OutsideBorderColor = value;
return _container.Style;
}
public IXLStyle SetDiagonalBorderColor(XLColor value)
{
DiagonalBorderColor = value;
return _container.Style;
}
public IXLCFColorScaleMid LowestValue(XLColor color)
{
return(Minimum(XLCFContentType.Minimum, "0", color));
}
public IXLStyle SetTopBorderColor(XLColor value)
{
TopBorderColor = value;
return(_container.Style);
}
private void addBottomBorder(IXLCell cell, XLBorderStyleValues border = XLBorderStyleValues.Thick, XLColor color = null)
{
if (color == null)
{
color = XLColor.Black;
}
cell.Style.Border.BottomBorder = XLBorderStyleValues.Thick;
cell.Style.Border.BottomBorderColor = XLColor.Black;
}
public Row BorderLeft(XLBorderStyleValues style, XLColor color)
{
_row.Style
.Border.SetLeftBorder(style)
.Border.SetLeftBorderColor(color);
return this;
}
public IXLWorksheet SetTabColor(XLColor color)
{
TabColor = color;
return this;
}
public IXLStyle SetRightBorderColor(XLColor value)
{
RightBorderColor = value;
return _container.Style;
}
public void Maximum(XLCFContentType type, Double value, XLColor color)
{
Maximum(type, value.ToString(), color);
}
public void HighestValue(XLColor color)
{
Maximum(XLCFContentType.Maximum, "0", color);
}
public void HighestValue(XLColor color)
{
Midpoint(XLCFContentType.Maximum, "0", color);
}
public void Maximum(XLCFContentType type, String value, XLColor color)
{
_conditionalFormat.Values.Add(new XLFormula { Value = value });
_conditionalFormat.Colors.Add(color);
_conditionalFormat.ContentTypes.Add(type);
}
public void Maximum(XLCFContentType type, String value, XLColor color)
{
Midpoint(type, value, color);
}
public void Maximum(XLCFContentType type, Double value, XLColor color)
{
Maximum(type, value.ToInvariantString(), color);
}
public XLFill(IXLStylized container, IXLFill defaultFill = null, Boolean useDefaultModify = true)
{
_container = container;
if (defaultFill == null) return;
_patternType = defaultFill.PatternType;
_patternColor = new XLColor(defaultFill.PatternColor);
_patternBackgroundColor = new XLColor(defaultFill.PatternBackgroundColor);
if (useDefaultModify)
{
var d = defaultFill as XLFill;
PatternBackgroundColorModified = d.PatternBackgroundColorModified;
PatternColorModified = d.PatternColorModified;
PatternTypeModified = d.PatternTypeModified;
}
}
public IXLCFColorScaleMax Midpoint(XLCFContentType type, Double value, XLColor color)
{
return(Midpoint(type, value.ToInvariantString(), color));
}
public IXLPhonetics SetFontColor(XLColor value)
{
FontColor = value; return(this);
}
public IXLDrawingStyle SetFontColor(XLColor value)
{
FontColor = value;
return _style;
}
public IXLStyle SetFontColor(XLColor value)
{
FontColor = value;
return(_container.Style);
}
public IXLPhonetics SetFontColor(XLColor value) { FontColor = value; return this; }
public XLBorder(IXLStylized container, IXLBorder defaultBorder, Boolean useDefaultModify = true)
{
_container = container;
if (defaultBorder == null) return;
_leftBorder = defaultBorder.LeftBorder;
_leftBorderColor = defaultBorder.LeftBorderColor;
_rightBorder = defaultBorder.RightBorder;
_rightBorderColor = defaultBorder.RightBorderColor;
_topBorder = defaultBorder.TopBorder;
_topBorderColor = defaultBorder.TopBorderColor;
_bottomBorder = defaultBorder.BottomBorder;
_bottomBorderColor = defaultBorder.BottomBorderColor;
_diagonalBorder = defaultBorder.DiagonalBorder;
_diagonalBorderColor = defaultBorder.DiagonalBorderColor;
_diagonalUp = defaultBorder.DiagonalUp;
_diagonalDown = defaultBorder.DiagonalDown;
if (useDefaultModify)
{
var d = defaultBorder as XLBorder;
BottomBorderColorModified = d.BottomBorderColorModified;
BottomBorderModified = d.BottomBorderModified;
DiagonalBorderColorModified = d.DiagonalBorderColorModified;
DiagonalBorderModified = d.DiagonalBorderModified;
DiagonalDownModified = d.DiagonalDownModified;
DiagonalUpModified = d.DiagonalUpModified;
LeftBorderColorModified = d.LeftBorderColorModified;
LeftBorderModified = d.LeftBorderModified;
RightBorderColorModified = d.RightBorderColorModified;
RightBorderModified = d.RightBorderModified;
TopBorderColorModified = d.TopBorderColorModified;
TopBorderModified = d.TopBorderModified;
}
}
