Free cookie consent management tool by TermsFeed Policy Generator

source: branches/3026_IntegrationIntoSymSpace/HeuristicLab.ExtLibs/HeuristicLab.EPPlus/4.0.3/EPPlus-4.0.3/ConditionalFormatting/Rules/ExcelConditionalFormattingFiveIconSet.cs

Last change on this file was 12074, checked in by sraggl, 10 years ago

#2341: Added EPPlus-4.0.3 to ExtLibs

File size: 6.4 KB
Line 
1/*******************************************************************************
2 * You may amend and distribute as you like, but don't remove this header!
3 *
4 * EPPlus provides server-side generation of Excel 2007/2010 spreadsheets.
5 * See http://www.codeplex.com/EPPlus for details.
6 *
7 * Copyright (C) 2011  Jan Källman
8 *
9 * This library is free software; you can redistribute it and/or
10 * modify it under the terms of the GNU Lesser General Public
11 * License as published by the Free Software Foundation; either
12 * version 2.1 of the License, or (at your option) any later version.
13
14 * This library is distributed in the hope that it will be useful,
15 * but WITHOUT ANY WARRANTY; without even the implied warranty of
16 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. 
17 * See the GNU Lesser General Public License for more details.
18 *
19 * The GNU Lesser General Public License can be viewed at http://www.opensource.org/licenses/lgpl-license.php
20 * If you unfamiliar with this license or have questions about it, here is an http://www.gnu.org/licenses/gpl-faq.html
21 *
22 * All code and executables are provided "as is" with no warranty either express or implied.
23 * The author accepts no liability for any damage or loss of business that this product may cause.
24 *
25 * Code change notes:
26 *
27 * Author             Change            Date
28 * ******************************************************************************
29 * Eyal Seagull        Added            2012-04-03
30 *******************************************************************************/
31using System;
32using System.Collections.Generic;
33using System.Linq;
34using System.Text;
35using System.Drawing;
36using System.Xml;
37using OfficeOpenXml.ConditionalFormatting.Contracts;
38
39namespace OfficeOpenXml.ConditionalFormatting
40{
41  /// <summary>
42  /// ExcelConditionalFormattingThreeIconSet
43  /// </summary>
44  public class ExcelConditionalFormattingFiveIconSet
45    : ExcelConditionalFormattingIconSetBase<eExcelconditionalFormatting5IconsSetType>, IExcelConditionalFormattingFiveIconSet
46  {
47    /****************************************************************************************/
48
49    #region Private Properties
50
51    #endregion Private Properties
52
53    /****************************************************************************************/
54
55    #region Constructors
56    /// <summary>
57    ///
58    /// </summary>
59    /// <param name="priority"></param>
60    /// <param name="address"></param>
61    /// <param name="worksheet"></param>
62    /// <param name="itemElementNode"></param>
63    /// <param name="namespaceManager"></param>
64    internal ExcelConditionalFormattingFiveIconSet(
65      ExcelAddress address,
66      int priority,
67      ExcelWorksheet worksheet,
68      XmlNode itemElementNode,
69      XmlNamespaceManager namespaceManager)
70      : base(
71        eExcelConditionalFormattingRuleType.FiveIconSet,
72        address,
73        priority,
74        worksheet,
75        itemElementNode,
76        (namespaceManager == null) ? worksheet.NameSpaceManager : namespaceManager)
77    {
78        if (itemElementNode != null && itemElementNode.HasChildNodes)
79        {
80            XmlNode iconNode4 = TopNode.SelectSingleNode("d:iconSet/d:cfvo[position()=4]", NameSpaceManager);
81            Icon4 = new ExcelConditionalFormattingIconDataBarValue(
82                    eExcelConditionalFormattingRuleType.FiveIconSet,
83                    address,
84                    worksheet,
85                    iconNode4,
86                    namespaceManager);
87           
88            XmlNode iconNode5 = TopNode.SelectSingleNode("d:iconSet/d:cfvo[position()=5]", NameSpaceManager);
89            Icon5 = new ExcelConditionalFormattingIconDataBarValue(
90                    eExcelConditionalFormattingRuleType.FiveIconSet,
91                    address,
92                    worksheet,
93                    iconNode5,
94                    namespaceManager);
95        }
96        else
97        {
98            XmlNode iconSetNode = TopNode.SelectSingleNode("d:iconSet", NameSpaceManager);
99            var iconNode4 = iconSetNode.OwnerDocument.CreateElement(ExcelConditionalFormattingConstants.Paths.Cfvo, ExcelPackage.schemaMain);
100            iconSetNode.AppendChild(iconNode4);
101
102            Icon4 = new ExcelConditionalFormattingIconDataBarValue(eExcelConditionalFormattingValueObjectType.Percent,
103                    60,
104                    "",
105                    eExcelConditionalFormattingRuleType.ThreeIconSet,
106                    address,
107                    priority,
108                    worksheet,
109                    iconNode4,
110                    namespaceManager);
111
112            var iconNode5 = iconSetNode.OwnerDocument.CreateElement(ExcelConditionalFormattingConstants.Paths.Cfvo, ExcelPackage.schemaMain);
113            iconSetNode.AppendChild(iconNode5);
114
115            Icon5 = new ExcelConditionalFormattingIconDataBarValue(eExcelConditionalFormattingValueObjectType.Percent,
116                    80,
117                    "",
118                    eExcelConditionalFormattingRuleType.ThreeIconSet,
119                    address,
120                    priority,
121                    worksheet,
122                    iconNode5,
123                    namespaceManager);
124        }
125    }
126
127    /// <summary>
128    ///
129    /// </summary>
130    /// <param name="priority"></param>
131    /// <param name="address"></param>
132    /// <param name="worksheet"></param>
133    /// <param name="itemElementNode"></param>
134    internal ExcelConditionalFormattingFiveIconSet(
135      ExcelAddress address,
136      int priority,
137      ExcelWorksheet worksheet,
138      XmlNode itemElementNode)
139      : this(
140        address,
141        priority,
142        worksheet,
143        itemElementNode,
144        null)
145    {
146    }
147
148    /// <summary>
149    ///
150    /// </summary>
151    /// <param name="priority"></param>
152    /// <param name="address"></param>
153    /// <param name="worksheet"></param>
154    internal ExcelConditionalFormattingFiveIconSet(
155      ExcelAddress address,
156      int priority,
157      ExcelWorksheet worksheet)
158      : this(
159        address,
160        priority,
161        worksheet,
162        null,
163        null)
164    {
165    }
166    #endregion Constructors
167
168    public ExcelConditionalFormattingIconDataBarValue Icon5
169    {
170        get;
171        internal set;
172    }
173
174    public ExcelConditionalFormattingIconDataBarValue Icon4
175    {
176        get;
177        internal set;
178    }
179  }
180  }
Note: See TracBrowser for help on using the repository browser.