| /******************************************************************************* | |
| * 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.Globalization; | |
| using System.Text; | |
| 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 ExcelColorXml(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 ExcelColorXml(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 | |
| { | |
| get | |
| { | |
| return Name + "|" + Size + "|" + Family + "|" + Color.Id + "|" + Scheme + "|" + Bold.ToString() + "|" + Italic.ToString() + "|" + Strike.ToString() + "|" + VerticalAlign + "|" + UnderLineType.ToString(); | |
| } | |
| } | |
| const string namePath = "d:name/@val"; | |
| 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; | |
| } | |
| } | |
| const string sizePath = "d:sz/@val"; | |
| float _size; | |
| /// <summary> | |
| /// Font size | |
| /// </summary> | |
| public float Size | |
| { | |
| get | |
| { | |
| return _size; | |
| } | |
| set | |
| { | |
| _size = value; | |
| } | |
| } | |
| const string familyPath = "d:family/@val"; | |
| int _family; | |
| /// <summary> | |
| /// Font family | |
| /// </summary> | |
| public int Family | |
| { | |
| get | |
| { | |
| return (_family == int.MinValue ? 0 : _family); ; | |
| } | |
| set | |
| { | |
| _family=value; | |
| } | |
| } | |
| ExcelColorXml _color = null; | |
| const string _colorPath = "d:color"; | |
| /// <summary> | |
| /// Text color | |
| /// </summary> | |
| public ExcelColorXml Color | |
| { | |
| get | |
| { | |
| return _color; | |
| } | |
| internal set | |
| { | |
| _color=value; | |
| } | |
| } | |
| const string schemePath = "d:scheme/@val"; | |
| string _scheme=""; | |
| /// <summary> | |
| /// Font Scheme | |
| /// </summary> | |
| public string Scheme | |
| { | |
| get | |
| { | |
| return _scheme; | |
| } | |
| private set | |
| { | |
| _scheme=value; | |
| } | |
| } | |
| const string boldPath = "d:b"; | |
| bool _bold; | |
| /// <summary> | |
| /// If the font is bold | |
| /// </summary> | |
| public bool Bold | |
| { | |
| get | |
| { | |
| return _bold; | |
| } | |
| set | |
| { | |
| _bold=value; | |
| } | |
| } | |
| const string italicPath = "d:i"; | |
| bool _italic; | |
| /// <summary> | |
| /// If the font is italic | |
| /// </summary> | |
| public bool Italic | |
| { | |
| get | |
| { | |
| return _italic; | |
| } | |
| set | |
| { | |
| _italic=value; | |
| } | |
| } | |
| const string strikePath = "d:strike"; | |
| bool _strike; | |
| /// <summary> | |
| /// If the font is striked out | |
| /// </summary> | |
| public bool Strike | |
| { | |
| get | |
| { | |
| return _strike; | |
| } | |
| set | |
| { | |
| _strike=value; | |
| } | |
| } | |
| 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; | |
| } | |
| } | |
| ExcelUnderLineType _underlineType; | |
| /// <summary> | |
| /// If the font is underlined | |
| /// </summary> | |
| public ExcelUnderLineType UnderLineType | |
| { | |
| get | |
| { | |
| return _underlineType; | |
| } | |
| set | |
| { | |
| _underlineType = value; | |
| } | |
| } | |
| const string verticalAlignPath = "d:vertAlign/@val"; | |
| string _verticalAlign; | |
| /// <summary> | |
| /// Vertical aligned | |
| /// </summary> | |
| public string VerticalAlign | |
| { | |
| get | |
| { | |
| return _verticalAlign; | |
| } | |
| set | |
| { | |
| _verticalAlign=value; | |
| } | |
| } | |
| public void SetFromFont(System.Drawing.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.ToString()); | |
| if(_size>0) SetXmlNodeString(sizePath, _size.ToString(System.Globalization.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.ToString()); | |
| return TopNode; | |
| } | |
| } | |
| } |