| /******************************************************************************* | |
| * 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 | |
| * Richard Tallent Fix inadvertent removal of XML node 2012-10-31 | |
| * Richard Tallent Remove VertAlign node if no alignment specified 2012-10-31 | |
| *******************************************************************************/ | |
| using System; | |
| using System.Collections.Generic; | |
| using System.Text; | |
| using System.Xml; | |
| using System.Drawing; | |
| using System.Globalization; | |
| namespace OfficeOpenXml.Style | |
| { | |
| /// <summary> | |
| /// A richtext part | |
| /// </summary> | |
| public class ExcelRichText : XmlHelper | |
| { | |
| internal ExcelRichText(XmlNamespaceManager ns, XmlNode topNode, ExcelRichTextCollection collection) : | |
| base(ns, topNode) | |
| { | |
| SchemaNodeOrder=new string[] {"rPr", "t", "b", "i","strike", "u", "vertAlign" , "sz", "color", "rFont", "family", "scheme", "charset"}; | |
| _collection = collection; | |
| } | |
| internal delegate void CallbackDelegate(); | |
| CallbackDelegate _callback; | |
| internal void SetCallback(CallbackDelegate callback) | |
| { | |
| _callback=callback; | |
| } | |
| const string TEXT_PATH="d:t"; | |
| /// <summary> | |
| /// The text | |
| /// </summary> | |
| public string Text | |
| { | |
| get | |
| { | |
| // Bug 15151 | |
| if (TopNode.Name == "t") | |
| return TopNode.InnerText; | |
| else | |
| return GetXmlNodeString(TEXT_PATH); | |
| } | |
| set | |
| { | |
| _collection.ConvertRichtext(); | |
| // Don't remove if blank -- setting a blank rich text value on a node is common, | |
| // for example when applying both bold and italic to text. | |
| SetXmlNodeString(TEXT_PATH, value, false); | |
| if (PreserveSpace) | |
| { | |
| XmlElement elem = TopNode.SelectSingleNode(TEXT_PATH, NameSpaceManager) as XmlElement; | |
| elem.SetAttribute("xml:space", "preserve"); | |
| } | |
| if (_callback != null) _callback(); | |
| } | |
| } | |
| /// <summary> | |
| /// Preserves whitespace. Default true | |
| /// </summary> | |
| public bool PreserveSpace | |
| { | |
| get | |
| { | |
| XmlElement elem = TopNode.SelectSingleNode(TEXT_PATH, NameSpaceManager) as XmlElement; | |
| if (elem != null) | |
| { | |
| return elem.GetAttribute("xml:space")=="preserve"; | |
| } | |
| return false; | |
| } | |
| set | |
| { | |
| _collection.ConvertRichtext(); | |
| XmlElement elem = TopNode.SelectSingleNode(TEXT_PATH, NameSpaceManager) as XmlElement; | |
| if (elem != null) | |
| { | |
| if (value) | |
| { | |
| elem.SetAttribute("xml:space", "preserve"); | |
| } | |
| else | |
| { | |
| elem.RemoveAttribute("xml:space"); | |
| } | |
| } | |
| if (_callback != null) _callback(); | |
| } | |
| } | |
| const string BOLD_PATH = "d:rPr/d:b"; | |
| /// <summary> | |
| /// Bold text | |
| /// </summary> | |
| public bool Bold | |
| { | |
| get | |
| { | |
| return ExistNode(BOLD_PATH); | |
| } | |
| set | |
| { | |
| _collection.ConvertRichtext(); | |
| if (value) | |
| { | |
| CreateNode(BOLD_PATH); | |
| } | |
| else | |
| { | |
| DeleteNode(BOLD_PATH); | |
| } | |
| if(_callback!=null) _callback(); | |
| } | |
| } | |
| const string ITALIC_PATH = "d:rPr/d:i"; | |
| /// <summary> | |
| /// Italic text | |
| /// </summary> | |
| public bool Italic | |
| { | |
| get | |
| { | |
| //return GetXmlNodeBool(ITALIC_PATH, false); | |
| return ExistNode(ITALIC_PATH); | |
| } | |
| set | |
| { | |
| _collection.ConvertRichtext(); | |
| if (value) | |
| { | |
| CreateNode(ITALIC_PATH); | |
| } | |
| else | |
| { | |
| DeleteNode(ITALIC_PATH); | |
| } | |
| if (_callback != null) _callback(); | |
| } | |
| } | |
| const string STRIKE_PATH = "d:rPr/d:strike"; | |
| /// <summary> | |
| /// Strike-out text | |
| /// </summary> | |
| public bool Strike | |
| { | |
| get | |
| { | |
| return ExistNode(STRIKE_PATH); | |
| } | |
| set | |
| { | |
| _collection.ConvertRichtext(); | |
| if (value) | |
| { | |
| CreateNode(STRIKE_PATH); | |
| } | |
| else | |
| { | |
| DeleteNode(STRIKE_PATH); | |
| } | |
| if (_callback != null) _callback(); | |
| } | |
| } | |
| const string UNDERLINE_PATH = "d:rPr/d:u"; | |
| /// <summary> | |
| /// Underlined text | |
| /// </summary> | |
| public bool UnderLine | |
| { | |
| get | |
| { | |
| return ExistNode(UNDERLINE_PATH); | |
| } | |
| set | |
| { | |
| _collection.ConvertRichtext(); | |
| if (value) | |
| { | |
| CreateNode(UNDERLINE_PATH); | |
| } | |
| else | |
| { | |
| DeleteNode(UNDERLINE_PATH); | |
| } | |
| if (_callback != null) _callback(); | |
| } | |
| } | |
| const string VERT_ALIGN_PATH = "d:rPr/d:vertAlign/@val"; | |
| /// <summary> | |
| /// Vertical Alignment | |
| /// </summary> | |
| public ExcelVerticalAlignmentFont VerticalAlign | |
| { | |
| get | |
| { | |
| string v=GetXmlNodeString(VERT_ALIGN_PATH); | |
| if(v=="") | |
| { | |
| return ExcelVerticalAlignmentFont.None; | |
| } | |
| else | |
| { | |
| try | |
| { | |
| return (ExcelVerticalAlignmentFont)Enum.Parse(typeof(ExcelVerticalAlignmentFont), v, true); | |
| } | |
| catch | |
| { | |
| return ExcelVerticalAlignmentFont.None; | |
| } | |
| } | |
| } | |
| set | |
| { | |
| _collection.ConvertRichtext(); | |
| if (value == ExcelVerticalAlignmentFont.None) | |
| { | |
| // If Excel 2010 encounters a vertical align value of blank, it will not load | |
| // the spreadsheet. So if None is specified, delete the node, it will be | |
| // recreated if a new value is applied later. | |
| DeleteNode(VERT_ALIGN_PATH); | |
| } else { | |
| SetXmlNodeString(VERT_ALIGN_PATH, value.ToString().ToLowerInvariant()); | |
| } | |
| if (_callback != null) _callback(); | |
| } | |
| } | |
| const string SIZE_PATH = "d:rPr/d:sz/@val"; | |
| /// <summary> | |
| /// Font size | |
| /// </summary> | |
| public float Size | |
| { | |
| get | |
| { | |
| return Convert.ToSingle(GetXmlNodeDecimal(SIZE_PATH)); | |
| } | |
| set | |
| { | |
| _collection.ConvertRichtext(); | |
| SetXmlNodeString(SIZE_PATH, value.ToString(CultureInfo.InvariantCulture)); | |
| if (_callback != null) _callback(); | |
| } | |
| } | |
| const string FONT_PATH = "d:rPr/d:rFont/@val"; | |
| /// <summary> | |
| /// Name of the font | |
| /// </summary> | |
| public string FontName | |
| { | |
| get | |
| { | |
| return GetXmlNodeString(FONT_PATH); | |
| } | |
| set | |
| { | |
| _collection.ConvertRichtext(); | |
| SetXmlNodeString(FONT_PATH, value); | |
| if (_callback != null) _callback(); | |
| } | |
| } | |
| const string COLOR_PATH = "d:rPr/d:color/@rgb"; | |
| /// <summary> | |
| /// Text color | |
| /// </summary> | |
| public Color Color | |
| { | |
| get | |
| { | |
| string col = GetXmlNodeString(COLOR_PATH); | |
| if (col == "") | |
| { | |
| return Color.Empty; | |
| } | |
| else | |
| { | |
| return Color.FromArgb(int.Parse(col, System.Globalization.NumberStyles.AllowHexSpecifier)); | |
| } | |
| } | |
| set | |
| { | |
| _collection.ConvertRichtext(); | |
| SetXmlNodeString(COLOR_PATH, value.ToArgb().ToString("X")/*.Substring(2, 6)*/); | |
| if (_callback != null) _callback(); | |
| } | |
| } | |
| public ExcelRichTextCollection _collection { get; set; } | |
| } | |
| } |