[12074] | 1 | using System.Globalization;
|
---|
| 2 | using OfficeOpenXml.Packaging;
|
---|
| 3 | using OfficeOpenXml.Table.PivotTable;
|
---|
| 4 | using System;
|
---|
| 5 | using System.Collections.Generic;
|
---|
| 6 | using System.Linq;
|
---|
| 7 | using System.Text;
|
---|
| 8 | using System.Xml;
|
---|
| 9 |
|
---|
| 10 | namespace OfficeOpenXml.Drawing.Chart
|
---|
| 11 | {
|
---|
| 12 | /// <summary>
|
---|
| 13 | /// Provides access to bubble chart specific properties
|
---|
| 14 | /// </summary>
|
---|
| 15 | public sealed class ExcelBubbleChart : ExcelChart
|
---|
| 16 | {
|
---|
| 17 | internal ExcelBubbleChart(ExcelDrawings drawings, XmlNode node, eChartType type, ExcelChart topChart, ExcelPivotTable PivotTableSource) :
|
---|
| 18 | base(drawings, node, type, topChart, PivotTableSource)
|
---|
| 19 | {
|
---|
| 20 | ShowNegativeBubbles = false;
|
---|
| 21 | BubbleScale = 100;
|
---|
| 22 | _chartSeries = new ExcelBubbleChartSeries(this, drawings.NameSpaceManager, _chartNode, PivotTableSource!=null);
|
---|
| 23 | //SetTypeProperties();
|
---|
| 24 | }
|
---|
| 25 |
|
---|
| 26 | internal ExcelBubbleChart(ExcelDrawings drawings, XmlNode node, eChartType type, bool isPivot) :
|
---|
| 27 | base(drawings, node, type, isPivot)
|
---|
| 28 | {
|
---|
| 29 | _chartSeries = new ExcelBubbleChartSeries(this, drawings.NameSpaceManager, _chartNode, isPivot);
|
---|
| 30 | //SetTypeProperties();
|
---|
| 31 | }
|
---|
| 32 | internal ExcelBubbleChart(ExcelDrawings drawings, XmlNode node, Uri uriChart, ZipPackagePart part, XmlDocument chartXml, XmlNode chartNode) :
|
---|
| 33 | base(drawings, node, uriChart, part, chartXml, chartNode)
|
---|
| 34 | {
|
---|
| 35 | _chartSeries = new ExcelBubbleChartSeries(this, _drawings.NameSpaceManager, _chartNode, false);
|
---|
| 36 | //SetTypeProperties();
|
---|
| 37 | }
|
---|
| 38 | internal ExcelBubbleChart(ExcelChart topChart, XmlNode chartNode) :
|
---|
| 39 | base(topChart, chartNode)
|
---|
| 40 | {
|
---|
| 41 | _chartSeries = new ExcelBubbleChartSeries(this, _drawings.NameSpaceManager, _chartNode, false);
|
---|
| 42 | }
|
---|
| 43 | string BUBBLESCALE_PATH = "c:bubbleScale/@val";
|
---|
| 44 | /// <summary>
|
---|
| 45 | /// Specifies the scale factor for the bubble chart. Can range from 0 to 300, corresponding to a percentage of the default size,
|
---|
| 46 | /// </summary>
|
---|
| 47 | public int BubbleScale
|
---|
| 48 | {
|
---|
| 49 | get
|
---|
| 50 | {
|
---|
| 51 | return _chartXmlHelper.GetXmlNodeInt(BUBBLESCALE_PATH);
|
---|
| 52 | }
|
---|
| 53 | set
|
---|
| 54 | {
|
---|
| 55 | if(value < 0 && value > 300)
|
---|
| 56 | {
|
---|
| 57 | throw(new ArgumentOutOfRangeException("Bubblescale out of range. 0-300 allowed"));
|
---|
| 58 | }
|
---|
| 59 | _chartXmlHelper.SetXmlNodeString(BUBBLESCALE_PATH, value.ToString());
|
---|
| 60 | }
|
---|
| 61 | }
|
---|
| 62 | string SHOWNEGBUBBLES_PATH = "c:showNegBubbles/@val";
|
---|
| 63 | /// <summary>
|
---|
| 64 | /// Specifies the scale factor for the bubble chart. Can range from 0 to 300, corresponding to a percentage of the default size,
|
---|
| 65 | /// </summary>
|
---|
| 66 | public bool ShowNegativeBubbles
|
---|
| 67 | {
|
---|
| 68 | get
|
---|
| 69 | {
|
---|
| 70 | return _chartXmlHelper.GetXmlNodeBool(SHOWNEGBUBBLES_PATH);
|
---|
| 71 | }
|
---|
| 72 | set
|
---|
| 73 | {
|
---|
| 74 | _chartXmlHelper.SetXmlNodeBool(BUBBLESCALE_PATH, value, true);
|
---|
| 75 | }
|
---|
| 76 | }
|
---|
| 77 | string BUBBLE3D_PATH = "c:bubble3D/@val";
|
---|
| 78 | /// <summary>
|
---|
| 79 | /// Specifies if the bubblechart is three dimensional
|
---|
| 80 | /// </summary>
|
---|
| 81 | public bool Bubble3D
|
---|
| 82 | {
|
---|
| 83 | get
|
---|
| 84 | {
|
---|
| 85 | return _chartXmlHelper.GetXmlNodeBool(BUBBLE3D_PATH);
|
---|
| 86 | }
|
---|
| 87 | set
|
---|
| 88 | {
|
---|
| 89 | _chartXmlHelper.SetXmlNodeBool(BUBBLE3D_PATH, value);
|
---|
| 90 | ChartType = value ? eChartType.Bubble3DEffect : eChartType.Bubble;
|
---|
| 91 | }
|
---|
| 92 | }
|
---|
| 93 | string SIZEREPRESENTS_PATH = "c:sizeRepresents/@val";
|
---|
| 94 | /// <summary>
|
---|
| 95 | /// Specifies the scale factor for the bubble chart. Can range from 0 to 300, corresponding to a percentage of the default size,
|
---|
| 96 | /// </summary>
|
---|
| 97 | public eSizeRepresents SizeRepresents
|
---|
| 98 | {
|
---|
| 99 | get
|
---|
| 100 | {
|
---|
| 101 | var v = _chartXmlHelper.GetXmlNodeString(SIZEREPRESENTS_PATH).ToLower(CultureInfo.InvariantCulture);
|
---|
| 102 | if (v == "w")
|
---|
| 103 | {
|
---|
| 104 | return eSizeRepresents.Width;
|
---|
| 105 | }
|
---|
| 106 | else
|
---|
| 107 | {
|
---|
| 108 | return eSizeRepresents.Area;
|
---|
| 109 | }
|
---|
| 110 | }
|
---|
| 111 | set
|
---|
| 112 | {
|
---|
| 113 | _chartXmlHelper.SetXmlNodeString(SIZEREPRESENTS_PATH, value == eSizeRepresents.Width ? "w" : "area");
|
---|
| 114 | }
|
---|
| 115 | }
|
---|
| 116 | public new ExcelBubbleChartSeries Series
|
---|
| 117 | {
|
---|
| 118 | get
|
---|
| 119 | {
|
---|
| 120 |
|
---|
| 121 | return (ExcelBubbleChartSeries)_chartSeries;
|
---|
| 122 | }
|
---|
| 123 | }
|
---|
| 124 | internal override eChartType GetChartType(string name)
|
---|
| 125 | {
|
---|
| 126 | if (Bubble3D)
|
---|
| 127 | {
|
---|
| 128 | return eChartType.Bubble3DEffect;
|
---|
| 129 | }
|
---|
| 130 | else
|
---|
| 131 | {
|
---|
| 132 | return eChartType.Bubble;
|
---|
| 133 | }
|
---|
| 134 | }
|
---|
| 135 | }
|
---|
| 136 | }
|
---|