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