/******************************************************************************* * 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.Xml; using System.Drawing; namespace OfficeOpenXml.Style { /// /// Collection of Richtext objects /// public class ExcelRichTextCollection : XmlHelper, IEnumerable { List _list = new List(); ExcelRangeBase _cells=null; internal ExcelRichTextCollection(XmlNamespaceManager ns, XmlNode topNode) : base(ns, topNode) { var nl = topNode.SelectNodes("d:r", NameSpaceManager); if (nl != null) { foreach (XmlNode n in nl) { _list.Add(new ExcelRichText(ns, n)); } } } internal ExcelRichTextCollection(XmlNamespaceManager ns, XmlNode topNode, ExcelRangeBase cells) : this(ns, topNode) { _cells = cells; } /// /// Collection containing the richtext objects /// /// /// public ExcelRichText this[int Index] { get { var item=_list[Index]; if(_cells!=null) item.SetCallback(UpdateCells); return item; } } /// /// Items in the list /// public int Count { get { return _list.Count; } } /// /// Add a rich text string /// /// The text to add /// public ExcelRichText Add(string Text) { XmlDocument doc; if (TopNode is XmlDocument) { doc = TopNode as XmlDocument; } else { doc = TopNode.OwnerDocument; } var node = doc.CreateElement("d", "r", ExcelPackage.schemaMain); TopNode.AppendChild(node); var rt = new ExcelRichText(NameSpaceManager, node); if (_list.Count > 0) { ExcelRichText prevItem = _list[_list.Count - 1]; rt.FontName = prevItem.FontName; rt.Size = prevItem.Size; if (prevItem.Color.IsEmpty) { rt.Color = Color.Black; } else { rt.Color = prevItem.Color; } rt.PreserveSpace = rt.PreserveSpace; rt.Bold = prevItem.Bold; rt.Italic = prevItem.Italic; rt.UnderLine = prevItem.UnderLine; } else if (_cells == null) { rt.FontName = "Calibri"; rt.Size = 11; } else { var style = _cells.Offset(0, 0).Style; rt.FontName = style.Font.Name; rt.Size = style.Font.Size; rt.Bold = style.Font.Bold; rt.Italic = style.Font.Italic; _cells.IsRichText = true; } rt.Text = Text; rt.PreserveSpace = true; if(_cells!=null) { rt.SetCallback(UpdateCells); UpdateCells(); } _list.Add(rt); return rt; } internal void UpdateCells() { _cells.SetValueRichText(TopNode.InnerXml); } /// /// Clear the collection /// public void Clear() { _list.Clear(); TopNode.RemoveAll(); if (_cells != null) _cells.IsRichText = false; } /// /// Removes an item at the specific index /// /// public void RemoveAt(int Index) { TopNode.RemoveChild(_list[Index].TopNode); _list.RemoveAt(Index); if (_cells != null && _list.Count==0) _cells.IsRichText = false; } /// /// Removes an item /// /// public void Remove(ExcelRichText Item) { TopNode.RemoveChild(Item.TopNode); _list.Remove(Item); if (_cells != null && _list.Count == 0) _cells.IsRichText = false; } //public void Insert(int index, string Text) //{ // _list.Insert(index, item); //} /// /// The text /// public string Text { get { StringBuilder sb=new StringBuilder(); foreach (var item in _list) { sb.Append(item.Text); } return sb.ToString(); } set { if (Count == 0) { Add(value); } else { this[0].Text = value; for (int ix = 1; ix < Count; ix++) { RemoveAt(ix); } } } } #region IEnumerable Members IEnumerator IEnumerable.GetEnumerator() { return _list.GetEnumerator(); } #endregion #region IEnumerable Members System.Collections.IEnumerator System.Collections.IEnumerable.GetEnumerator() { return _list.GetEnumerator(); } #endregion } }