blob: bf07432fb96740946ae55467f262bfe75525db8c [file] [log] [blame]
/*******************************************************************************
* You may amend and distribute as you like, but don't remove this header!
*
* EPPlus provides server-side generation of Excel 2007/2010 spreadsheets.
* See http://www.codeplex.com/EPPlus for details.
*
* Copyright (C) 2011 Jan Källman
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
* See the GNU Lesser General Public License for more details.
*
* The GNU Lesser General Public License can be viewed at http://www.opensource.org/licenses/lgpl-license.php
* If you unfamiliar with this license or have questions about it, here is an http://www.gnu.org/licenses/gpl-faq.html
*
* All code and executables are provided "as is" with no warranty either express or implied.
* The author accepts no liability for any damage or loss of business that this product may cause.
*
* Code change notes:
*
* Author Change Date
* ******************************************************************************
* Jan Källman Initial Release 2009-10-01
* Jan Källman License changed GPL-->LGPL 2011-12-16
*******************************************************************************/
using System.Drawing;
namespace OfficeOpenXml.Style;
/// <summary>
/// Cell Border style
/// </summary>
public sealed class Border : StyleBase {
internal Border(
ExcelStyles styles,
XmlHelper.ChangedEventHandler changedEvent,
int positionId,
string address,
int index)
: base(styles, changedEvent, positionId, address) {
Index = index;
}
/// <summary>
/// Left border style
/// </summary>
public ExcelBorderItem Left =>
new(_styles, _ChangedEvent, _positionID, _address, eStyleClass.BorderLeft, this);
/// <summary>
/// Right border style
/// </summary>
public ExcelBorderItem Right =>
new(_styles, _ChangedEvent, _positionID, _address, eStyleClass.BorderRight, this);
/// <summary>
/// Top border style
/// </summary>
public ExcelBorderItem Top =>
new(_styles, _ChangedEvent, _positionID, _address, eStyleClass.BorderTop, this);
/// <summary>
/// Bottom border style
/// </summary>
public ExcelBorderItem Bottom =>
new(_styles, _ChangedEvent, _positionID, _address, eStyleClass.BorderBottom, this);
/// <summary>
/// 0Diagonal border style
/// </summary>
public ExcelBorderItem Diagonal =>
new(_styles, _ChangedEvent, _positionID, _address, eStyleClass.BorderDiagonal, this);
/// <summary>
/// A diagonal from the bottom left to top right of the cell
/// </summary>
public bool DiagonalUp {
get {
if (Index >= 0) {
return _styles.Borders[Index].DiagonalUp;
}
return false;
}
set =>
_ChangedEvent(
this,
new(eStyleClass.Border, eStyleProperty.BorderDiagonalUp, value, _positionID, _address));
}
/// <summary>
/// A diagonal from the top left to bottom right of the cell
/// </summary>
public bool DiagonalDown {
get {
if (Index >= 0) {
return _styles.Borders[Index].DiagonalDown;
}
return false;
}
set =>
_ChangedEvent(
this,
new(eStyleClass.Border, eStyleProperty.BorderDiagonalDown, value, _positionID, _address));
}
internal override string Id =>
Top.Id + Bottom.Id + Left.Id + Right.Id + Diagonal.Id + DiagonalUp + DiagonalDown;
/// <summary>
/// Set the border style around the range.
/// </summary>
/// <param name="style">The border style</param>
public void BorderAround(ExcelBorderStyle style) {
var addr = new ExcelAddress(_address);
SetBorderAroundStyle(style, addr);
}
/// <summary>
/// Set the border style around the range.
/// </summary>
/// <param name="style">The border style</param>
/// <param name="color">The color of the border</param>
public void BorderAround(ExcelBorderStyle style, Color color) {
var addr = new ExcelAddress(_address);
SetBorderAroundStyle(style, addr);
_ChangedEvent(
this,
new(
eStyleClass.BorderTop,
eStyleProperty.Color,
color.ToArgb().ToString("X"),
_positionID,
new ExcelAddress(addr._fromRow, addr._fromCol, addr._fromRow, addr._toCol).Address));
_ChangedEvent(
this,
new(
eStyleClass.BorderBottom,
eStyleProperty.Color,
color.ToArgb().ToString("X"),
_positionID,
new ExcelAddress(addr._toRow, addr._fromCol, addr._toRow, addr._toCol).Address));
_ChangedEvent(
this,
new(
eStyleClass.BorderLeft,
eStyleProperty.Color,
color.ToArgb().ToString("X"),
_positionID,
new ExcelAddress(addr._fromRow, addr._fromCol, addr._toRow, addr._fromCol).Address));
_ChangedEvent(
this,
new(
eStyleClass.BorderRight,
eStyleProperty.Color,
color.ToArgb().ToString("X"),
_positionID,
new ExcelAddress(addr._fromRow, addr._toCol, addr._toRow, addr._toCol).Address));
}
private void SetBorderAroundStyle(ExcelBorderStyle style, ExcelAddress addr) {
_ChangedEvent(
this,
new(
eStyleClass.BorderTop,
eStyleProperty.Style,
style,
_positionID,
new ExcelAddress(addr._fromRow, addr._fromCol, addr._fromRow, addr._toCol).Address));
_ChangedEvent(
this,
new(
eStyleClass.BorderBottom,
eStyleProperty.Style,
style,
_positionID,
new ExcelAddress(addr._toRow, addr._fromCol, addr._toRow, addr._toCol).Address));
_ChangedEvent(
this,
new(
eStyleClass.BorderLeft,
eStyleProperty.Style,
style,
_positionID,
new ExcelAddress(addr._fromRow, addr._fromCol, addr._toRow, addr._fromCol).Address));
_ChangedEvent(
this,
new(
eStyleClass.BorderRight,
eStyleProperty.Style,
style,
_positionID,
new ExcelAddress(addr._fromRow, addr._toCol, addr._toRow, addr._toCol).Address));
}
}