| /******************************************************************************* |
| * 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.Text; |
| using System.Xml; |
| using OfficeOpenXml.Table.PivotTable; |
| |
| namespace OfficeOpenXml.Drawing.Chart |
| { |
| /// <summary> |
| /// Bar chart |
| /// </summary> |
| public sealed class ExcelBarChart : ExcelChart |
| { |
| #region "Constructors" |
| //internal ExcelBarChart(ExcelDrawings drawings, XmlNode node) : |
| // base(drawings, node/*, 1*/) |
| //{ |
| // SetChartNodeText(""); |
| //} |
| //internal ExcelBarChart(ExcelDrawings drawings, XmlNode node, eChartType type) : |
| // base(drawings, node, type) |
| //{ |
| // SetChartNodeText(""); |
| |
| // SetTypeProperties(drawings, type); |
| //} |
| internal ExcelBarChart(ExcelDrawings drawings, XmlNode node, eChartType type, ExcelChart topChart, ExcelPivotTable PivotTableSource) : |
| base(drawings, node, type, topChart, PivotTableSource) |
| { |
| SetChartNodeText(""); |
| |
| SetTypeProperties(drawings, type); |
| } |
| |
| internal ExcelBarChart(ExcelDrawings drawings, XmlNode node, Uri uriChart, Packaging.ZipPackagePart part, XmlDocument chartXml, XmlNode chartNode) : |
| base(drawings, node, uriChart, part, chartXml, chartNode) |
| { |
| SetChartNodeText(chartNode.Name); |
| } |
| |
| internal ExcelBarChart(ExcelChart topChart, XmlNode chartNode) : |
| base(topChart, chartNode) |
| { |
| SetChartNodeText(chartNode.Name); |
| } |
| #endregion |
| #region "Private functions" |
| //string _chartTopPath="c:chartSpace/c:chart/c:plotArea/{0}"; |
| private void SetChartNodeText(string chartNodeText) |
| { |
| if(string.IsNullOrEmpty(chartNodeText)) |
| { |
| chartNodeText = GetChartNodeText(); |
| } |
| //_chartTopPath = string.Format(_chartTopPath, chartNodeText); |
| //_directionPath = string.Format(_directionPath, _chartTopPath); |
| //_shapePath = string.Format(_shapePath, _chartTopPath); |
| } |
| private void SetTypeProperties(ExcelDrawings drawings, eChartType type) |
| { |
| /******* Bar direction *******/ |
| if (type == eChartType.BarClustered || |
| type == eChartType.BarStacked || |
| type == eChartType.BarStacked100 || |
| type == eChartType.BarClustered3D || |
| type == eChartType.BarStacked3D || |
| type == eChartType.BarStacked1003D || |
| type == eChartType.ConeBarClustered || |
| type == eChartType.ConeBarStacked || |
| type == eChartType.ConeBarStacked100 || |
| type == eChartType.CylinderBarClustered || |
| type == eChartType.CylinderBarStacked || |
| type == eChartType.CylinderBarStacked100 || |
| type == eChartType.PyramidBarClustered || |
| type == eChartType.PyramidBarStacked || |
| type == eChartType.PyramidBarStacked100) |
| { |
| Direction = eDirection.Bar; |
| } |
| else if ( |
| type == eChartType.ColumnClustered || |
| type == eChartType.ColumnStacked || |
| type == eChartType.ColumnStacked100 || |
| type == eChartType.Column3D || |
| type == eChartType.ColumnClustered3D || |
| type == eChartType.ColumnStacked3D || |
| type == eChartType.ColumnStacked1003D || |
| type == eChartType.ConeCol || |
| type == eChartType.ConeColClustered || |
| type == eChartType.ConeColStacked || |
| type == eChartType.ConeColStacked100 || |
| type == eChartType.CylinderCol || |
| type == eChartType.CylinderColClustered || |
| type == eChartType.CylinderColStacked || |
| type == eChartType.CylinderColStacked100 || |
| type == eChartType.PyramidCol || |
| type == eChartType.PyramidColClustered || |
| type == eChartType.PyramidColStacked || |
| type == eChartType.PyramidColStacked100) |
| { |
| Direction = eDirection.Column; |
| } |
| |
| /****** Shape ******/ |
| if (/*type == eChartType.ColumnClustered || |
| type == eChartType.ColumnStacked || |
| type == eChartType.ColumnStacked100 ||*/ |
| type == eChartType.Column3D || |
| type == eChartType.ColumnClustered3D || |
| type == eChartType.ColumnStacked3D || |
| type == eChartType.ColumnStacked1003D || |
| /*type == eChartType.BarClustered || |
| type == eChartType.BarStacked || |
| type == eChartType.BarStacked100 ||*/ |
| type == eChartType.BarClustered3D || |
| type == eChartType.BarStacked3D || |
| type == eChartType.BarStacked1003D) |
| { |
| Shape = eShape.Box; |
| } |
| else if ( |
| type == eChartType.CylinderBarClustered || |
| type == eChartType.CylinderBarStacked || |
| type == eChartType.CylinderBarStacked100 || |
| type == eChartType.CylinderCol || |
| type == eChartType.CylinderColClustered || |
| type == eChartType.CylinderColStacked || |
| type == eChartType.CylinderColStacked100) |
| { |
| Shape = eShape.Cylinder; |
| } |
| else if ( |
| type == eChartType.ConeBarClustered || |
| type == eChartType.ConeBarStacked || |
| type == eChartType.ConeBarStacked100 || |
| type == eChartType.ConeCol || |
| type == eChartType.ConeColClustered || |
| type == eChartType.ConeColStacked || |
| type == eChartType.ConeColStacked100) |
| { |
| Shape = eShape.Cone; |
| } |
| else if ( |
| type == eChartType.PyramidBarClustered || |
| type == eChartType.PyramidBarStacked || |
| type == eChartType.PyramidBarStacked100 || |
| type == eChartType.PyramidCol || |
| type == eChartType.PyramidColClustered || |
| type == eChartType.PyramidColStacked || |
| type == eChartType.PyramidColStacked100) |
| { |
| Shape = eShape.Pyramid; |
| } |
| } |
| #endregion |
| #region "Properties" |
| string _directionPath = "c:barDir/@val"; |
| /// <summary> |
| /// Direction, Bar or columns |
| /// </summary> |
| public eDirection Direction |
| { |
| get |
| { |
| return GetDirectionEnum(_chartXmlHelper.GetXmlNodeString(_directionPath)); |
| } |
| internal set |
| { |
| _chartXmlHelper.SetXmlNodeString(_directionPath, GetDirectionText(value)); |
| } |
| } |
| string _shapePath = "c:shape/@val"; |
| /// <summary> |
| /// The shape of the bar/columns |
| /// </summary> |
| public eShape Shape |
| { |
| get |
| { |
| return GetShapeEnum(_chartXmlHelper.GetXmlNodeString(_shapePath)); |
| } |
| internal set |
| { |
| _chartXmlHelper.SetXmlNodeString(_shapePath, GetShapeText(value)); |
| } |
| } |
| ExcelChartDataLabel _DataLabel = null; |
| /// <summary> |
| /// Access to datalabel properties |
| /// </summary> |
| public ExcelChartDataLabel DataLabel |
| { |
| get |
| { |
| if (_DataLabel == null) |
| { |
| _DataLabel = new ExcelChartDataLabel(NameSpaceManager, ChartNode); |
| } |
| return _DataLabel; |
| } |
| } |
| #endregion |
| #region "Direction Enum Traslation" |
| private string GetDirectionText(eDirection direction) |
| { |
| switch (direction) |
| { |
| case eDirection.Bar: |
| return "bar"; |
| default: |
| return "col"; |
| } |
| } |
| |
| private eDirection GetDirectionEnum(string direction) |
| { |
| switch (direction) |
| { |
| case "bar": |
| return eDirection.Bar; |
| default: |
| return eDirection.Column; |
| } |
| } |
| #endregion |
| #region "Shape Enum Translation" |
| private string GetShapeText(eShape Shape) |
| { |
| switch (Shape) |
| { |
| case eShape.Box: |
| return "box"; |
| case eShape.Cone: |
| return "cone"; |
| case eShape.ConeToMax: |
| return "coneToMax"; |
| case eShape.Cylinder: |
| return "cylinder"; |
| case eShape.Pyramid: |
| return "pyramid"; |
| case eShape.PyramidToMax: |
| return "pyramidToMax"; |
| default: |
| return "box"; |
| } |
| } |
| |
| private eShape GetShapeEnum(string text) |
| { |
| switch (text) |
| { |
| case "box": |
| return eShape.Box; |
| case "cone": |
| return eShape.Cone; |
| case "coneToMax": |
| return eShape.ConeToMax; |
| case "cylinder": |
| return eShape.Cylinder; |
| case "pyramid": |
| return eShape.Pyramid; |
| case "pyramidToMax": |
| return eShape.PyramidToMax; |
| default: |
| return eShape.Box; |
| } |
| } |
| #endregion |
| internal override eChartType GetChartType(string name) |
| { |
| if (name == "barChart") |
| { |
| if (this.Direction == eDirection.Bar) |
| { |
| if (Grouping == eGrouping.Stacked) |
| { |
| return eChartType.BarStacked; |
| } |
| else if (Grouping == eGrouping.PercentStacked) |
| { |
| return eChartType.BarStacked100; |
| } |
| else |
| { |
| return eChartType.BarClustered; |
| } |
| } |
| else |
| { |
| if (Grouping == eGrouping.Stacked) |
| { |
| return eChartType.ColumnStacked; |
| } |
| else if (Grouping == eGrouping.PercentStacked) |
| { |
| return eChartType.ColumnStacked100; |
| } |
| else |
| { |
| return eChartType.ColumnClustered; |
| } |
| } |
| } |
| if (name == "bar3DChart") |
| { |
| #region "Bar Shape" |
| if (this.Shape==eShape.Box) |
| { |
| if (this.Direction == eDirection.Bar) |
| { |
| if (Grouping == eGrouping.Stacked) |
| { |
| return eChartType.BarStacked3D; |
| } |
| else if (Grouping == eGrouping.PercentStacked) |
| { |
| return eChartType.BarStacked1003D; |
| } |
| else |
| { |
| return eChartType.BarClustered3D; |
| } |
| } |
| else |
| { |
| if (Grouping == eGrouping.Stacked) |
| { |
| return eChartType.ColumnStacked3D; |
| } |
| else if (Grouping == eGrouping.PercentStacked) |
| { |
| return eChartType.ColumnStacked1003D; |
| } |
| else |
| { |
| return eChartType.ColumnClustered3D; |
| } |
| } |
| } |
| #endregion |
| #region "Cone Shape" |
| if (this.Shape == eShape.Cone || this.Shape == eShape.ConeToMax) |
| { |
| if (this.Direction == eDirection.Bar) |
| { |
| if (Grouping == eGrouping.Stacked) |
| { |
| return eChartType.ConeBarStacked; |
| } |
| else if (Grouping == eGrouping.PercentStacked) |
| { |
| return eChartType.ConeBarStacked100; |
| } |
| else if (Grouping == eGrouping.Clustered) |
| { |
| return eChartType.ConeBarClustered; |
| } |
| } |
| else |
| { |
| if (Grouping == eGrouping.Stacked) |
| { |
| return eChartType.ConeColStacked; |
| } |
| else if (Grouping == eGrouping.PercentStacked) |
| { |
| return eChartType.ConeColStacked100; |
| } |
| else if (Grouping == eGrouping.Clustered) |
| { |
| return eChartType.ConeColClustered; |
| } |
| else |
| { |
| return eChartType.ConeCol; |
| } |
| } |
| } |
| #endregion |
| #region "Cylinder Shape" |
| if (this.Shape == eShape.Cylinder) |
| { |
| if (this.Direction == eDirection.Bar) |
| { |
| if (Grouping == eGrouping.Stacked) |
| { |
| return eChartType.CylinderBarStacked; |
| } |
| else if (Grouping == eGrouping.PercentStacked) |
| { |
| return eChartType.CylinderBarStacked100; |
| } |
| else if (Grouping == eGrouping.Clustered) |
| { |
| return eChartType.CylinderBarClustered; |
| } |
| } |
| else |
| { |
| if (Grouping == eGrouping.Stacked) |
| { |
| return eChartType.CylinderColStacked; |
| } |
| else if (Grouping == eGrouping.PercentStacked) |
| { |
| return eChartType.CylinderColStacked100; |
| } |
| else if (Grouping == eGrouping.Clustered) |
| { |
| return eChartType.CylinderColClustered; |
| } |
| else |
| { |
| return eChartType.CylinderCol; |
| } |
| } |
| } |
| #endregion |
| #region "Pyramide Shape" |
| if (this.Shape == eShape.Pyramid || this.Shape == eShape.PyramidToMax) |
| { |
| if (this.Direction == eDirection.Bar) |
| { |
| if (Grouping == eGrouping.Stacked) |
| { |
| return eChartType.PyramidBarStacked; |
| } |
| else if (Grouping == eGrouping.PercentStacked) |
| { |
| return eChartType.PyramidBarStacked100; |
| } |
| else if (Grouping == eGrouping.Clustered) |
| { |
| return eChartType.PyramidBarClustered; |
| } |
| } |
| else |
| { |
| if (Grouping == eGrouping.Stacked) |
| { |
| return eChartType.PyramidColStacked; |
| } |
| else if (Grouping == eGrouping.PercentStacked) |
| { |
| return eChartType.PyramidColStacked100; |
| } |
| else if (Grouping == eGrouping.Clustered) |
| { |
| return eChartType.PyramidColClustered; |
| } |
| else |
| { |
| return eChartType.PyramidCol; |
| } |
| } |
| } |
| #endregion |
| } |
| return base.GetChartType(name); |
| } |
| } |
| } |
