/******************************************************************************* * 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 Added 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; using OfficeOpenXml.Style; namespace OfficeOpenXml.Drawing.Chart { /// /// Position of the legend /// public enum eLegendPosition { Top, Left, Right, Bottom, TopRight } /// /// Chart ledger /// public class ExcelChartLegend : XmlHelper { ExcelChart _chart; internal ExcelChartLegend(XmlNamespaceManager ns, XmlNode node, ExcelChart chart) : base(ns,node) { _chart=chart; SchemaNodeOrder = new string[] { "legendPos", "layout","overlay", "txPr", "bodyPr", "lstStyle", "spPr" }; } const string POSITION_PATH = "c:legendPos/@val"; /// /// Position of the Legend /// public eLegendPosition Position { get { switch(GetXmlNodeString(POSITION_PATH).ToLower(CultureInfo.InvariantCulture)) { case "t": return eLegendPosition.Top; case "b": return eLegendPosition.Bottom; case "l": return eLegendPosition.Left; case "tr": return eLegendPosition.TopRight; default: return eLegendPosition.Right; } } set { if (TopNode == null) throw(new Exception("Can't set position. Chart has no legend")); switch (value) { case eLegendPosition.Top: SetXmlNodeString(POSITION_PATH, "t"); break; case eLegendPosition.Bottom: SetXmlNodeString(POSITION_PATH, "b"); break; case eLegendPosition.Left: SetXmlNodeString(POSITION_PATH, "l"); break; case eLegendPosition.TopRight: SetXmlNodeString(POSITION_PATH, "tr"); break; default: SetXmlNodeString(POSITION_PATH, "r"); break; } } } const string OVERLAY_PATH = "c:overlay/@val"; /// /// If the legend overlays other objects /// public bool Overlay { get { return GetXmlNodeBool(OVERLAY_PATH); } set { if (TopNode == null) throw (new Exception("Can't set overlay. Chart has no legend")); SetXmlNodeBool(OVERLAY_PATH, value); } } ExcelDrawingFill _fill = null; /// /// Fill style /// public ExcelDrawingFill Fill { get { if (_fill == null) { _fill = new ExcelDrawingFill(NameSpaceManager, TopNode, "c:spPr"); } return _fill; } } ExcelDrawingBorder _border = null; /// /// Border style /// public ExcelDrawingBorder Border { get { if (_border == null) { _border = new ExcelDrawingBorder(NameSpaceManager, TopNode, "c:spPr/a:ln"); } return _border; } } ExcelTextFont _font = null; /// /// Font properties /// public ExcelTextFont Font { get { if (_font == null) { if (TopNode.SelectSingleNode("c:txPr",NameSpaceManager) == null) { CreateNode("c:txPr/a:bodyPr"); CreateNode("c:txPr/a:lstStyle"); } _font = new ExcelTextFont(NameSpaceManager, TopNode, "c:txPr/a:p/a:pPr/a:defRPr", new string[] { "legendPos", "layout", "pPr", "defRPr", "solidFill", "uFill", "latin", "cs", "r", "rPr", "t" }); } return _font; } } /// /// Remove the legend /// public void Remove() { if (TopNode == null) return; TopNode.ParentNode.RemoveChild(TopNode); TopNode = null; } /// /// Add a legend to the chart /// public void Add() { if(TopNode!=null) return; //XmlHelper xml = new XmlHelper(NameSpaceManager, _chart.ChartXml); XmlHelper xml = XmlHelperFactory.Create(NameSpaceManager, _chart.ChartXml); xml.SchemaNodeOrder=_chart.SchemaNodeOrder; xml.CreateNode("c:chartSpace/c:chart/c:legend"); TopNode = _chart.ChartXml.SelectSingleNode("c:chartSpace/c:chart/c:legend", NameSpaceManager); TopNode.InnerXml=""; } } }