| /******************************************************************************* | 
 |  * 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.Drawing; | 
 | using System.Globalization; | 
 | using System.Xml; | 
 |  | 
 | namespace OfficeOpenXml.Style.XmlAccess; | 
 |  | 
 | /// <summary> | 
 | /// Xml access class for fonts | 
 | /// </summary> | 
 | public sealed class ExcelFontXml : StyleXmlHelper { | 
 |   internal ExcelFontXml(XmlNamespaceManager nameSpaceManager) | 
 |       : base(nameSpaceManager) { | 
 |     _name = ""; | 
 |     _size = 0; | 
 |     _family = int.MinValue; | 
 |     _scheme = ""; | 
 |     _color = _color = new(NameSpaceManager); | 
 |     _bold = false; | 
 |     _italic = false; | 
 |     _strike = false; | 
 |     _underlineType = ExcelUnderLineType.None; | 
 |     _verticalAlign = ""; | 
 |   } | 
 |  | 
 |   internal ExcelFontXml(XmlNamespaceManager nsm, XmlNode topNode) | 
 |       : base(nsm, topNode) { | 
 |     _name = GetXmlNodeString(_namePath); | 
 |     _size = (float)GetXmlNodeDecimal(_sizePath); | 
 |     _family = GetXmlNodeIntNull(_familyPath) ?? int.MinValue; | 
 |     _scheme = GetXmlNodeString(_schemePath); | 
 |     _color = new(nsm, topNode.SelectSingleNode(_colorPath, nsm)); | 
 |     _bold = GetBoolValue(topNode, _boldPath); | 
 |     _italic = GetBoolValue(topNode, _italicPath); | 
 |     _strike = GetBoolValue(topNode, _strikePath); | 
 |     _verticalAlign = GetXmlNodeString(_verticalAlignPath); | 
 |     if (topNode.SelectSingleNode(_underLinedPath, NameSpaceManager) != null) { | 
 |       string ut = GetXmlNodeString(_underLinedPath + "/@val"); | 
 |       if (ut == "") { | 
 |         _underlineType = ExcelUnderLineType.Single; | 
 |       } else { | 
 |         _underlineType = (ExcelUnderLineType)Enum.Parse(typeof(ExcelUnderLineType), ut, true); | 
 |       } | 
 |     } else { | 
 |       _underlineType = ExcelUnderLineType.None; | 
 |     } | 
 |   } | 
 |  | 
 |   internal override string Id => | 
 |     Name | 
 |         + "|" | 
 |         + Size | 
 |         + "|" | 
 |         + Family | 
 |         + "|" | 
 |         + Color.Id | 
 |         + "|" | 
 |         + Scheme | 
 |         + "|" | 
 |         + Bold | 
 |         + "|" | 
 |         + Italic | 
 |         + "|" | 
 |         + Strike | 
 |         + "|" | 
 |         + VerticalAlign | 
 |         + "|" | 
 |         + UnderLineType; | 
 |  | 
 |   private const string _namePath = "d:name/@val"; | 
 |   private string _name; | 
 |  | 
 |   /// <summary> | 
 |   /// The name of the font | 
 |   /// </summary> | 
 |   public string Name { | 
 |     get { return _name; } | 
 |     set { | 
 |       Scheme = ""; //Reset schema to avoid corrupt file if unsupported font is selected. | 
 |       _name = value; | 
 |     } | 
 |   } | 
 |  | 
 |   private const string _sizePath = "d:sz/@val"; | 
 |   private float _size; | 
 |  | 
 |   /// <summary> | 
 |   /// Font size | 
 |   /// </summary> | 
 |   public float Size { | 
 |     get { return _size; } | 
 |     set { _size = value; } | 
 |   } | 
 |  | 
 |   private const string _familyPath = "d:family/@val"; | 
 |   private int _family; | 
 |  | 
 |   /// <summary> | 
 |   /// Font family | 
 |   /// </summary> | 
 |   public int Family { | 
 |     get { | 
 |       return (_family == int.MinValue ? 0 : _family); | 
 |       ; | 
 |     } | 
 |     set { _family = value; } | 
 |   } | 
 |  | 
 |   private ExcelColorXml _color; | 
 |   private const string _colorPath = "d:color"; | 
 |  | 
 |   /// <summary> | 
 |   /// Text color | 
 |   /// </summary> | 
 |   public ExcelColorXml Color { | 
 |     get { return _color; } | 
 |     internal set { _color = value; } | 
 |   } | 
 |  | 
 |   private const string _schemePath = "d:scheme/@val"; | 
 |   private string _scheme = ""; | 
 |  | 
 |   /// <summary> | 
 |   /// Font Scheme | 
 |   /// </summary> | 
 |   public string Scheme { | 
 |     get { return _scheme; } | 
 |     private set { _scheme = value; } | 
 |   } | 
 |  | 
 |   private const string _boldPath = "d:b"; | 
 |   private bool _bold; | 
 |  | 
 |   /// <summary> | 
 |   /// If the font is bold | 
 |   /// </summary> | 
 |   public bool Bold { | 
 |     get { return _bold; } | 
 |     set { _bold = value; } | 
 |   } | 
 |  | 
 |   private const string _italicPath = "d:i"; | 
 |   private bool _italic; | 
 |  | 
 |   /// <summary> | 
 |   /// If the font is italic | 
 |   /// </summary> | 
 |   public bool Italic { | 
 |     get { return _italic; } | 
 |     set { _italic = value; } | 
 |   } | 
 |  | 
 |   private const string _strikePath = "d:strike"; | 
 |   private bool _strike; | 
 |  | 
 |   /// <summary> | 
 |   /// If the font is striked out | 
 |   /// </summary> | 
 |   public bool Strike { | 
 |     get { return _strike; } | 
 |     set { _strike = value; } | 
 |   } | 
 |  | 
 |   private const string _underLinedPath = "d:u"; | 
 |  | 
 |   /// <summary> | 
 |   /// If the font is underlined. | 
 |   /// When set to true a the text is underlined with a single line | 
 |   /// </summary> | 
 |   public bool UnderLine { | 
 |     get { return UnderLineType != ExcelUnderLineType.None; } | 
 |     set { _underlineType = value ? ExcelUnderLineType.Single : ExcelUnderLineType.None; } | 
 |   } | 
 |  | 
 |   private ExcelUnderLineType _underlineType; | 
 |  | 
 |   /// <summary> | 
 |   /// If the font is underlined | 
 |   /// </summary> | 
 |   public ExcelUnderLineType UnderLineType { | 
 |     get { return _underlineType; } | 
 |     set { _underlineType = value; } | 
 |   } | 
 |  | 
 |   private const string _verticalAlignPath = "d:vertAlign/@val"; | 
 |   private string _verticalAlign; | 
 |  | 
 |   /// <summary> | 
 |   /// Vertical aligned | 
 |   /// </summary> | 
 |   public string VerticalAlign { | 
 |     get { return _verticalAlign; } | 
 |     set { _verticalAlign = value; } | 
 |   } | 
 |  | 
 |   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 ExcelFontXml Copy() { | 
 |     ExcelFontXml newFont = new ExcelFontXml(NameSpaceManager); | 
 |     newFont.Name = _name; | 
 |     newFont.Size = _size; | 
 |     newFont.Family = _family; | 
 |     newFont.Scheme = _scheme; | 
 |     newFont.Bold = _bold; | 
 |     newFont.Italic = _italic; | 
 |     newFont.UnderLineType = _underlineType; | 
 |     newFont.Strike = _strike; | 
 |     newFont.VerticalAlign = _verticalAlign; | 
 |     newFont.Color = Color.Copy(); | 
 |     return newFont; | 
 |   } | 
 |  | 
 |   internal override XmlNode CreateXmlNode(XmlNode topElement) { | 
 |     TopNode = topElement; | 
 |  | 
 |     if (_bold) { | 
 |       CreateNode(_boldPath); | 
 |     } else { | 
 |       DeleteAllNode(_boldPath); | 
 |     } | 
 |     if (_italic) { | 
 |       CreateNode(_italicPath); | 
 |     } else { | 
 |       DeleteAllNode(_italicPath); | 
 |     } | 
 |     if (_strike) { | 
 |       CreateNode(_strikePath); | 
 |     } else { | 
 |       DeleteAllNode(_strikePath); | 
 |     } | 
 |  | 
 |     if (_underlineType == ExcelUnderLineType.None) { | 
 |       DeleteAllNode(_underLinedPath); | 
 |     } else if (_underlineType == ExcelUnderLineType.Single) { | 
 |       CreateNode(_underLinedPath); | 
 |     } else { | 
 |       var v = _underlineType.ToString(); | 
 |       SetXmlNodeString( | 
 |           _underLinedPath + "/@val", | 
 |           v.Substring(0, 1).ToLower(CultureInfo.InvariantCulture) + v.Substring(1)); | 
 |     } | 
 |  | 
 |     if (_verticalAlign != "") { | 
 |       SetXmlNodeString(_verticalAlignPath, _verticalAlign); | 
 |     } | 
 |     if (_size > 0) { | 
 |       SetXmlNodeString(_sizePath, _size.ToString(CultureInfo.InvariantCulture)); | 
 |     } | 
 |     if (_color.Exists) { | 
 |       CreateNode(_colorPath); | 
 |       TopNode.AppendChild( | 
 |           _color.CreateXmlNode(TopNode.SelectSingleNode(_colorPath, NameSpaceManager))); | 
 |     } | 
 |     if (!string.IsNullOrEmpty(_name)) { | 
 |       SetXmlNodeString(_namePath, _name); | 
 |     } | 
 |     if (_family > int.MinValue) { | 
 |       SetXmlNodeString(_familyPath, _family.ToString()); | 
 |     } | 
 |     if (_scheme != "") { | 
 |       SetXmlNodeString(_schemePath, _scheme); | 
 |     } | 
 |  | 
 |     return TopNode; | 
 |   } | 
 | } |