/******************************************************************************* * 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(); } } } }