/******************************************************************************* * 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 System.Drawing; namespace OfficeOpenXml.Style { /// /// Cell style Font /// public sealed class ExcelFont : StyleBase { internal ExcelFont(ExcelStyles styles, OfficeOpenXml.XmlHelper.ChangedEventHandler ChangedEvent, int PositionID, string address, int index) : base(styles, ChangedEvent, PositionID, address) { Index = index; } /// /// The name of the font /// public string Name { get { return _styles.Fonts[Index].Name; } set { _ChangedEvent(this, new StyleChangeEventArgs(eStyleClass.Font, eStyleProperty.Name, value, _positionID, _address)); } } /// /// The Size of the font /// public float Size { get { return _styles.Fonts[Index].Size; } set { _ChangedEvent(this, new StyleChangeEventArgs(eStyleClass.Font, eStyleProperty.Size, value, _positionID, _address)); } } /// /// Font family /// public int Family { get { return _styles.Fonts[Index].Family; } set { _ChangedEvent(this, new StyleChangeEventArgs(eStyleClass.Font, eStyleProperty.Family, value, _positionID, _address)); } } /// /// Cell color /// public ExcelColor Color { get { return new ExcelColor(_styles, _ChangedEvent, _positionID, _address, eStyleClass.Font, this); } } /// /// Scheme /// public string Scheme { get { return _styles.Fonts[Index].Scheme; } set { _ChangedEvent(this, new StyleChangeEventArgs(eStyleClass.Font, eStyleProperty.Scheme, value, _positionID, _address)); } } /// /// Font-bold /// public bool Bold { get { return _styles.Fonts[Index].Bold; } set { _ChangedEvent(this, new StyleChangeEventArgs(eStyleClass.Font, eStyleProperty.Bold, value, _positionID, _address)); } } /// /// Font-italic /// public bool Italic { get { return _styles.Fonts[Index].Italic; } set { _ChangedEvent(this, new StyleChangeEventArgs(eStyleClass.Font, eStyleProperty.Italic, value, _positionID, _address)); } } /// /// Font-Strikeout /// public bool Strike { get { return _styles.Fonts[Index].Strike; } set { _ChangedEvent(this, new StyleChangeEventArgs(eStyleClass.Font, eStyleProperty.Strike, value, _positionID, _address)); } } /// /// Font-Underline /// public bool UnderLine { get { return _styles.Fonts[Index].UnderLine; } set { if (value) { UnderLineType = ExcelUnderLineType.Single; } else { UnderLineType = ExcelUnderLineType.None; } //_ChangedEvent(this, new StyleChangeEventArgs(eStyleClass.Font, eStyleProperty.UnderlineType, value, _positionID, _address)); } } public ExcelUnderLineType UnderLineType { get { return _styles.Fonts[Index].UnderLineType; } set { _ChangedEvent(this, new StyleChangeEventArgs(eStyleClass.Font, eStyleProperty.UnderlineType, value, _positionID, _address)); } } /// /// Font-Vertical Align /// public ExcelVerticalAlignmentFont VerticalAlign { get { if (_styles.Fonts[Index].VerticalAlign == "") { return ExcelVerticalAlignmentFont.None; } else { return (ExcelVerticalAlignmentFont)Enum.Parse(typeof(ExcelVerticalAlignmentFont), _styles.Fonts[Index].VerticalAlign, true); } } set { _ChangedEvent(this, new StyleChangeEventArgs(eStyleClass.Font, eStyleProperty.VerticalAlign, value, _positionID, _address)); } } /// /// Set the font from a Font object /// /// public void SetFromFont(Font Font) { Name = Font.Name; //Family=fnt.FontFamily.; Size = (int)Font.Size; Strike = Font.Strikeout; Bold = Font.Bold; UnderLine = Font.Underline; Italic = Font.Italic; } internal override string Id { get { return Name + Size.ToString() + Family.ToString() + Scheme.ToString() + Bold.ToString()[0] + Italic.ToString()[0] + Strike.ToString()[0] + UnderLine.ToString()[0] + VerticalAlign; } } } }