/*******************************************************************************
* 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;
using System.Collections.Generic;
using System.Text;
using OfficeOpenXml.Style.XmlAccess;
namespace OfficeOpenXml.Style
{
///
/// Toplevel class for cell styling
///
public sealed class ExcelStyle : StyleBase
{
internal ExcelStyle(ExcelStyles styles, OfficeOpenXml.XmlHelper.ChangedEventHandler ChangedEvent, int positionID, string Address, int xfsId) :
base(styles, ChangedEvent, positionID, Address)
{
Index = xfsId;
ExcelXfs xfs;
if (positionID > -1)
{
xfs = _styles.CellXfs[xfsId];
}
else
{
xfs = _styles.CellStyleXfs[xfsId];
}
Styles = styles;
PositionID = positionID;
Numberformat = new ExcelNumberFormat(styles, ChangedEvent, PositionID, Address, xfs.NumberFormatId);
Font = new ExcelFont(styles, ChangedEvent, PositionID, Address, xfs.FontId);
Fill = new ExcelFill(styles, ChangedEvent, PositionID, Address, xfs.FillId);
Border = new Border(styles, ChangedEvent, PositionID, Address, xfs.BorderId);
}
///
/// Numberformat
///
public ExcelNumberFormat Numberformat { get; set; }
///
/// Font styling
///
public ExcelFont Font { get; set; }
///
/// Fill Styling
///
public ExcelFill Fill { get; set; }
///
/// Border
///
public Border Border { get; set; }
///
/// The horizontal alignment in the cell
///
public ExcelHorizontalAlignment HorizontalAlignment
{
get
{
return _styles.CellXfs[Index].HorizontalAlignment;
}
set
{
_ChangedEvent(this, new StyleChangeEventArgs(eStyleClass.Style, eStyleProperty.HorizontalAlign, value, _positionID, _address));
}
}
///
/// The vertical alignment in the cell
///
public ExcelVerticalAlignment VerticalAlignment
{
get
{
return _styles.CellXfs[Index].VerticalAlignment;
}
set
{
_ChangedEvent(this, new StyleChangeEventArgs(eStyleClass.Style, eStyleProperty.VerticalAlign, value, _positionID, _address));
}
}
///
/// Wrap the text
///
public bool WrapText
{
get
{
return _styles.CellXfs[Index].WrapText;
}
set
{
_ChangedEvent(this, new StyleChangeEventArgs(eStyleClass.Style, eStyleProperty.WrapText, value, _positionID, _address));
}
}
///
/// Readingorder
///
public ExcelReadingOrder ReadingOrder
{
get
{
return _styles.CellXfs[Index].ReadingOrder;
}
set
{
_ChangedEvent(this, new StyleChangeEventArgs(eStyleClass.Style, eStyleProperty.ReadingOrder, value, _positionID, _address));
}
}
///
/// Shrink the text to fit
///
public bool ShrinkToFit
{
get
{
return _styles.CellXfs[Index].ShrinkToFit;
}
set
{
_ChangedEvent(this, new StyleChangeEventArgs(eStyleClass.Style, eStyleProperty.ShrinkToFit, value, _positionID, _address));
}
}
///
/// The margin between the border and the text
///
public int Indent
{
get
{
return _styles.CellXfs[Index].Indent;
}
set
{
if (value <0 || value > 250)
{
throw(new ArgumentOutOfRangeException("Indent must be between 0 and 250"));
}
_ChangedEvent(this, new StyleChangeEventArgs(eStyleClass.Style, eStyleProperty.Indent, value, _positionID, _address));
}
}
///
/// Text orientation in degrees. Values range from 0 to 180.
///
public int TextRotation
{
get
{
return _styles.CellXfs[Index].TextRotation;
}
set
{
if (value < 0 || value > 180)
{
throw new ArgumentOutOfRangeException("TextRotation out of range.");
}
_ChangedEvent(this, new StyleChangeEventArgs(eStyleClass.Style, eStyleProperty.TextRotation, value, _positionID, _address));
}
}
///
/// If true the cell is locked for editing when the sheet is protected
///
///
public bool Locked
{
get
{
return _styles.CellXfs[Index].Locked;
}
set
{
_ChangedEvent(this, new StyleChangeEventArgs(eStyleClass.Style, eStyleProperty.Locked, value, _positionID, _address));
}
}
///
/// If true the formula is hidden when the sheet is protected.
///
///
public bool Hidden
{
get
{
return _styles.CellXfs[Index].Hidden;
}
set
{
_ChangedEvent(this, new StyleChangeEventArgs(eStyleClass.Style, eStyleProperty.Hidden, value, _positionID, _address));
}
}
const string xfIdPath = "@xfId";
///
/// The index in the style collection
///
public int XfId
{
get
{
return _styles.CellXfs[Index].XfId;
}
set
{
_ChangedEvent(this, new StyleChangeEventArgs(eStyleClass.Style, eStyleProperty.XfId, value, _positionID, _address));
}
}
internal int PositionID
{
get;
set;
}
internal ExcelStyles Styles
{
get;
set;
}
internal override string Id
{
get
{
return Numberformat.Id + "|" + Font.Id + "|" + Fill.Id + "|" + Border.Id + "|" + VerticalAlignment + "|" + HorizontalAlignment + "|" + WrapText.ToString() + "|" + ReadingOrder.ToString() + "|" + XfId.ToString();
}
}
}
}