|  | /******************************************************************************* | 
|  | * 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 | 
|  | { | 
|  | /// <summary> | 
|  | /// Position of the legend | 
|  | /// </summary> | 
|  | public enum eLegendPosition | 
|  | { | 
|  | Top, | 
|  | Left, | 
|  | Right, | 
|  | Bottom, | 
|  | TopRight | 
|  | } | 
|  | /// <summary> | 
|  | /// Chart ledger | 
|  | /// </summary> | 
|  | 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"; | 
|  | /// <summary> | 
|  | /// Position of the Legend | 
|  | /// </summary> | 
|  | 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"; | 
|  | /// <summary> | 
|  | /// If the legend overlays other objects | 
|  | /// </summary> | 
|  | 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; | 
|  | /// <summary> | 
|  | /// Fill style | 
|  | /// </summary> | 
|  | public ExcelDrawingFill Fill | 
|  | { | 
|  | get | 
|  | { | 
|  | if (_fill == null) | 
|  | { | 
|  | _fill = new ExcelDrawingFill(NameSpaceManager, TopNode, "c:spPr"); | 
|  | } | 
|  | return _fill; | 
|  | } | 
|  | } | 
|  | ExcelDrawingBorder _border = null; | 
|  | /// <summary> | 
|  | /// Border style | 
|  | /// </summary> | 
|  | public ExcelDrawingBorder Border | 
|  | { | 
|  | get | 
|  | { | 
|  | if (_border == null) | 
|  | { | 
|  | _border = new ExcelDrawingBorder(NameSpaceManager, TopNode, "c:spPr/a:ln"); | 
|  | } | 
|  | return _border; | 
|  | } | 
|  | } | 
|  | ExcelTextFont _font = null; | 
|  | /// <summary> | 
|  | /// Font properties | 
|  | /// </summary> | 
|  | 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; | 
|  | } | 
|  | } | 
|  | /// <summary> | 
|  | /// Remove the legend | 
|  | /// </summary> | 
|  | public void Remove() | 
|  | { | 
|  | if (TopNode == null) return; | 
|  | TopNode.ParentNode.RemoveChild(TopNode); | 
|  | TopNode = null; | 
|  | } | 
|  | /// <summary> | 
|  | /// Add a legend to the chart | 
|  | /// </summary> | 
|  | 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="<c:legendPos val=\"r\" /><c:layout />"; | 
|  | } | 
|  | } | 
|  | } |