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