/******************************************************************************* * 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.Globalization; namespace OfficeOpenXml.Style.XmlAccess { /// /// Xml access class for gradient fillsde /// public sealed class ExcelGradientFillXml : ExcelFillXml { internal ExcelGradientFillXml(XmlNamespaceManager nameSpaceManager) : base(nameSpaceManager) { GradientColor1 = new ExcelColorXml(nameSpaceManager); GradientColor2 = new ExcelColorXml(nameSpaceManager); } internal ExcelGradientFillXml(XmlNamespaceManager nsm, XmlNode topNode) : base(nsm, topNode) { Degree = GetXmlNodeDouble(_degreePath); Type = GetXmlNodeString(_typePath)=="path" ? ExcelFillGradientType.Path : ExcelFillGradientType.Linear; GradientColor1 = new ExcelColorXml(nsm, topNode.SelectSingleNode(_gradientColor1Path, nsm)); GradientColor2 = new ExcelColorXml(nsm, topNode.SelectSingleNode(_gradientColor2Path, nsm)); Top = GetXmlNodeDouble(_topPath); Bottom = GetXmlNodeDouble(_bottomPath); Left = GetXmlNodeDouble(_leftPath); Right = GetXmlNodeDouble(_rightPath); } const string _typePath = "d:gradientFill/@type"; /// /// Type of gradient fill. /// public ExcelFillGradientType Type { get; internal set; } const string _degreePath = "d:gradientFill/@degree"; /// /// Angle of the linear gradient /// public double Degree { get; internal set; } const string _gradientColor1Path = "d:gradientFill/d:stop[@position=\"0\"]/d:color"; /// /// Gradient color 1 /// public ExcelColorXml GradientColor1 { get; private set; } const string _gradientColor2Path = "d:gradientFill/d:stop[@position=\"1\"]/d:color"; /// /// Gradient color 2 /// public ExcelColorXml GradientColor2 { get; private set; } const string _bottomPath = "d:gradientFill/@bottom"; /// /// Percentage format bottom /// public double Bottom { get; internal set; } const string _topPath = "d:gradientFill/@top"; /// /// Percentage format top /// public double Top { get; internal set; } const string _leftPath = "d:gradientFill/@left"; /// /// Percentage format left /// public double Left { get; internal set; } const string _rightPath = "d:gradientFill/@right"; /// /// Percentage format right /// public double Right { get; internal set; } internal override string Id { get { return base.Id + Degree.ToString() + GradientColor1.Id + GradientColor2.Id + Type + Left.ToString() + Right.ToString() + Bottom.ToString() + Top.ToString(); } } #region Public Properties #endregion internal override ExcelFillXml Copy() { ExcelGradientFillXml newFill = new ExcelGradientFillXml(NameSpaceManager); newFill.PatternType = base._fillPatternType; newFill.BackgroundColor = _backgroundColor.Copy(); newFill.PatternColor = _patternColor.Copy(); newFill.GradientColor1 = GradientColor1.Copy(); newFill.GradientColor2 = GradientColor2.Copy(); newFill.Type = Type; newFill.Degree = Degree; newFill.Top = Top; newFill.Bottom = Bottom; newFill.Left = Left; newFill.Right = Right; return newFill; } internal override XmlNode CreateXmlNode(XmlNode topNode) { TopNode = topNode; CreateNode("d:gradientFill"); if(Type==ExcelFillGradientType.Path) SetXmlNodeString(_typePath, "path"); if(!double.IsNaN(Degree)) SetXmlNodeString(_degreePath, Degree.ToString(CultureInfo.InvariantCulture)); if (GradientColor1!=null) { /*** Gradient color node 1***/ var node = TopNode.SelectSingleNode("d:gradientFill", NameSpaceManager); var stopNode = node.OwnerDocument.CreateElement("stop", ExcelPackage.schemaMain); stopNode.SetAttribute("position", "0"); node.AppendChild(stopNode); var colorNode = node.OwnerDocument.CreateElement("color", ExcelPackage.schemaMain); stopNode.AppendChild(colorNode); GradientColor1.CreateXmlNode(colorNode); /*** Gradient color node 2***/ stopNode = node.OwnerDocument.CreateElement("stop", ExcelPackage.schemaMain); stopNode.SetAttribute("position", "1"); node.AppendChild(stopNode); colorNode = node.OwnerDocument.CreateElement("color", ExcelPackage.schemaMain); stopNode.AppendChild(colorNode); GradientColor2.CreateXmlNode(colorNode); } if (!double.IsNaN(Top)) SetXmlNodeString(_topPath, Top.ToString("F5",CultureInfo.InvariantCulture)); if (!double.IsNaN(Bottom)) SetXmlNodeString(_bottomPath, Bottom.ToString("F5", CultureInfo.InvariantCulture)); if (!double.IsNaN(Left)) SetXmlNodeString(_leftPath, Left.ToString("F5", CultureInfo.InvariantCulture)); if (!double.IsNaN(Right)) SetXmlNodeString(_rightPath, Right.ToString("F5", CultureInfo.InvariantCulture)); return topNode; } } }