AppsheetEpplus/ConditionalFormatting/ExcelConditionalFormattingConstants.cs - epplus - Git at Google

 /*******************************************************************************
  * 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
  * ******************************************************************************
  * Eyal Seagull    Conditional Formatting Adaption    2012-04-03
  *******************************************************************************/

 namespace AppsheetEpplus;

 /// <summary>
 /// The conditional formatting constants
 /// </summary>
 internal static class ExcelConditionalFormattingConstants {
   internal class Errors {
     internal const string _commaSeparatedAddresses =
         "Multiple addresses may not be commaseparated, use space instead";
     internal const string _invalidPriority = "Invalid priority number. Must be bigger than zero";
     internal const string _invalidRemoveRuleOperation = "Invalid remove rule operation";
     internal const string _missingCfvoNode = "Missing 'cfvo' node in Conditional Formatting";
     internal const string _missingCfvoParentNode =
         "Missing 'cfvo' parent node in Conditional Formatting";
     internal const string _missingConditionalFormattingNode =
         "Missing 'conditionalFormatting' node in Conditional Formatting";
     internal const string _missingItemRuleList =
         "Missing item with address '{0}' in Conditional Formatting Rule List";
     internal const string _missingPriorityAttribute =
         "Missing 'priority' attribute in Conditional Formatting Rule";
     internal const string _missingRuleType =
         "Missing eExcelConditionalFormattingRuleType Type in Conditional Formatting";
     internal const string _missingSqrefAttribute =
         "Missing 'sqref' attribute in Conditional Formatting";
     internal const string _missingTypeAttribute =
         "Missing 'type' attribute in Conditional Formatting Rule";
     internal const string _missingWorksheetNode = "Missing 'worksheet' node";
     internal const string _nonSupportedRuleType = "Non supported conditionalFormattingType: {0}";
     internal const string _unexistentCfvoTypeAttribute =
         "Unexistent eExcelConditionalFormattingValueObjectType attribute in Conditional Formatting";
     internal const string _unexistentOperatorTypeAttribute =
         "Unexistent eExcelConditionalFormattingOperatorType attribute in Conditional Formatting";
     internal const string _unexistentTimePeriodTypeAttribute =
         "Unexistent eExcelConditionalFormattingTimePeriodType attribute in Conditional Formatting";
     internal const string _unexpectedRuleTypeAttribute =
         "Unexpected eExcelConditionalFormattingRuleType attribute in Conditional Formatting Rule";
     internal const string _wrongNumberCfvoColorNodes =
         "Wrong number of 'cfvo'/'color' nodes in Conditional Formatting Rule";
   }

   internal class Nodes {
     internal const string _worksheet = "worksheet";
     internal const string _conditionalFormatting = "conditionalFormatting";
     internal const string _cfRule = "cfRule";
     internal const string _colorScale = "colorScale";
     internal const string _cfvo = "cfvo";
     internal const string _color = "color";
     internal const string _dataBar = "dataBar";
     internal const string _iconSet = "iconSet";
     internal const string _formula = "formula";
   }

   internal class Attributes {
     internal const string _aboveAverage = "aboveAverage";
     internal const string _bottom = "bottom";
     internal const string _dxfId = "dxfId";
     internal const string _equalAverage = "equalAverage";
     internal const string _iconSet = "iconSet";
     internal const string _operator = "operator";
     internal const string _percent = "percent";
     internal const string _priority = "priority";
     internal const string _rank = "rank";
     internal const string _reverse = "reverse";
     internal const string _rgb = "rgb";
     internal const string _showValue = "showValue";
     internal const string _sqref = "sqref";
     internal const string _stdDev = "stdDev";
     internal const string _stopIfTrue = "stopIfTrue";
     internal const string _text = "text";
     internal const string _theme = "theme";
     internal const string _timePeriod = "timePeriod";
     internal const string _tint = "tint";
     internal const string _type = "type";
     internal const string _val = "val";
   }

   internal class Paths {
     // Main node and attributes
     internal const string _worksheet = "d:" + Nodes._worksheet;

     // <conditionalFormatting> §18.3.1.18 node
     // can appear more than once in a worksheet
     internal const string _conditionalFormatting = "d:" + Nodes._conditionalFormatting;

     // <cfRule> §18.3.1.10 node
     // can appear more than once in a <conditionalFormatting>
     internal const string _cfRule = "d:" + Nodes._cfRule;

     // <colorScale> §18.3.1.16 node
     internal const string _colorScale = "d:" + Nodes._colorScale;

     // <cfvo> §18.3.1.11 node
     internal const string _cfvo = "d:" + Nodes._cfvo;

     // <color> §18.3.1.15 node
     internal const string _color = "d:" + Nodes._color;

     // <dataBar> §18.3.1.28 node
     internal const string _dataBar = "d:" + Nodes._dataBar;

     // <iconSet> §18.3.1.49 node
     internal const string _iconSet = "d:" + Nodes._iconSet;

     // <formula> §18.3.1.43 node
     internal const string _formula = "d:" + Nodes._formula;

     // Attributes (for all the nodes)
     internal const string _aboveAverageAttribute = "@" + Attributes._aboveAverage;
     internal const string _bottomAttribute = "@" + Attributes._bottom;
     internal const string _dxfIdAttribute = "@" + Attributes._dxfId;
     internal const string _equalAverageAttribute = "@" + Attributes._equalAverage;
     internal const string _iconSetAttribute = "@" + Attributes._iconSet;
     internal const string _operatorAttribute = "@" + Attributes._operator;
     internal const string _percentAttribute = "@" + Attributes._percent;
     internal const string _priorityAttribute = "@" + Attributes._priority;
     internal const string _rankAttribute = "@" + Attributes._rank;
     internal const string _reverseAttribute = "@" + Attributes._reverse;
     internal const string _rgbAttribute = "@" + Attributes._rgb;
     internal const string _showValueAttribute = "@" + Attributes._showValue;
     internal const string _sqrefAttribute = "@" + Attributes._sqref;
     internal const string _stdDevAttribute = "@" + Attributes._stdDev;
     internal const string _stopIfTrueAttribute = "@" + Attributes._stopIfTrue;
     internal const string _textAttribute = "@" + Attributes._text;
     internal const string _themeAttribute = "@" + Attributes._theme;
     internal const string _timePeriodAttribute = "@" + Attributes._timePeriod;
     internal const string _tintAttribute = "@" + Attributes._tint;
     internal const string _typeAttribute = "@" + Attributes._type;
     internal const string _valAttribute = "@" + Attributes._val;
   }

   internal class RuleType {
     internal const string _aboveAverage = "aboveAverage";
     internal const string _beginsWith = "beginsWith";
     internal const string _cellIs = "cellIs";
     internal const string _colorScale = "colorScale";
     internal const string _containsBlanks = "containsBlanks";
     internal const string _containsErrors = "containsErrors";
     internal const string _containsText = "containsText";
     internal const string _dataBar = "dataBar";
     internal const string _duplicateValues = "duplicateValues";
     internal const string _endsWith = "endsWith";
     internal const string _expression = "expression";
     internal const string _iconSet = "iconSet";
     internal const string _notContainsBlanks = "notContainsBlanks";
     internal const string _notContainsErrors = "notContainsErrors";
     internal const string _notContainsText = "notContainsText";
     internal const string _timePeriod = "timePeriod";
     internal const string _top10 = "top10";
     internal const string _uniqueValues = "uniqueValues";

     // EPPlus Extended Types
     internal const string _aboveOrEqualAverage = "aboveOrEqualAverage";
     internal const string _aboveStdDev = "aboveStdDev";
     internal const string _belowAverage = "belowAverage";
     internal const string _belowOrEqualAverage = "belowOrEqualAverage";
     internal const string _belowStdDev = "belowStdDev";
     internal const string _between = "between";
     internal const string _bottom = "bottom";
     internal const string _bottomPercent = "bottomPercent";
     internal const string _equal = "equal";
     internal const string _greaterThan = "greaterThan";
     internal const string _greaterThanOrEqual = "greaterThanOrEqual";
     internal const string _iconSet3 = "iconSet3";
     internal const string _iconSet4 = "iconSet4";
     internal const string _iconSet5 = "iconSet5";
     internal const string _last7Days = "last7Days";
     internal const string _lastMonth = "lastMonth";
     internal const string _lastWeek = "lastWeek";
     internal const string _lessThan = "lessThan";
     internal const string _lessThanOrEqual = "lessThanOrEqual";
     internal const string _nextMonth = "nextMonth";
     internal const string _nextWeek = "nextWeek";
     internal const string _notBetween = "notBetween";
     internal const string _notEqual = "notEqual";
     internal const string _thisMonth = "thisMonth";
     internal const string _thisWeek = "thisWeek";
     internal const string _threeColorScale = "threeColorScale";
     internal const string _today = "today";
     internal const string _tomorrow = "tomorrow";
     internal const string _top = "top";
     internal const string _topPercent = "topPercent";
     internal const string _twoColorScale = "twoColorScale";
     internal const string _yesterday = "yesterday";
   }

   internal class CfvoType {
     internal const string _min = "min";
     internal const string _max = "max";
     internal const string _num = "num";
     internal const string _formula = "formula";
     internal const string _percent = "percent";
     internal const string _percentile = "percentile";
   }

   internal class Operators {
     internal const string _beginsWith = "beginsWith";
     internal const string _between = "between";
     internal const string _containsText = "containsText";
     internal const string _endsWith = "endsWith";
     internal const string _equal = "equal";
     internal const string _greaterThan = "greaterThan";
     internal const string _greaterThanOrEqual = "greaterThanOrEqual";
     internal const string _lessThan = "lessThan";
     internal const string _lessThanOrEqual = "lessThanOrEqual";
     internal const string _notBetween = "notBetween";
     internal const string _notContains = "notContains";
     internal const string _notEqual = "notEqual";
   }

   internal class TimePeriods {
     internal const string _last7Days = "last7Days";
     internal const string _lastMonth = "lastMonth";
     internal const string _lastWeek = "lastWeek";
     internal const string _nextMonth = "nextMonth";
     internal const string _nextWeek = "nextWeek";
     internal const string _thisMonth = "thisMonth";
     internal const string _thisWeek = "thisWeek";
     internal const string _today = "today";
     internal const string _tomorrow = "tomorrow";
     internal const string _yesterday = "yesterday";
   }

   internal class Colors {
     internal const string _cfvoLowValue = "#FFF8696B";
     internal const string _cfvoMiddleValue = "#FFFFEB84";
     internal const string _cfvoHighValue = "#FF63BE7B";
   }
 }
	/*******************************************************************************
	* 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
	* ******************************************************************************
	* Eyal Seagull Conditional Formatting Adaption 2012-04-03
	*******************************************************************************/

	namespace AppsheetEpplus;

	/// <summary>
	/// The conditional formatting constants
	/// </summary>
	internal static class ExcelConditionalFormattingConstants {
	internal class Errors {
	internal const string _commaSeparatedAddresses =
	"Multiple addresses may not be commaseparated, use space instead";
	internal const string _invalidPriority = "Invalid priority number. Must be bigger than zero";
	internal const string _invalidRemoveRuleOperation = "Invalid remove rule operation";
	internal const string _missingCfvoNode = "Missing 'cfvo' node in Conditional Formatting";
	internal const string _missingCfvoParentNode =
	"Missing 'cfvo' parent node in Conditional Formatting";
	internal const string _missingConditionalFormattingNode =
	"Missing 'conditionalFormatting' node in Conditional Formatting";
	internal const string _missingItemRuleList =
	"Missing item with address '{0}' in Conditional Formatting Rule List";
	internal const string _missingPriorityAttribute =
	"Missing 'priority' attribute in Conditional Formatting Rule";
	internal const string _missingRuleType =
	"Missing eExcelConditionalFormattingRuleType Type in Conditional Formatting";
	internal const string _missingSqrefAttribute =
	"Missing 'sqref' attribute in Conditional Formatting";
	internal const string _missingTypeAttribute =
	"Missing 'type' attribute in Conditional Formatting Rule";
	internal const string _missingWorksheetNode = "Missing 'worksheet' node";
	internal const string _nonSupportedRuleType = "Non supported conditionalFormattingType: {0}";
	internal const string _unexistentCfvoTypeAttribute =
	"Unexistent eExcelConditionalFormattingValueObjectType attribute in Conditional Formatting";
	internal const string _unexistentOperatorTypeAttribute =
	"Unexistent eExcelConditionalFormattingOperatorType attribute in Conditional Formatting";
	internal const string _unexistentTimePeriodTypeAttribute =
	"Unexistent eExcelConditionalFormattingTimePeriodType attribute in Conditional Formatting";
	internal const string _unexpectedRuleTypeAttribute =
	"Unexpected eExcelConditionalFormattingRuleType attribute in Conditional Formatting Rule";
	internal const string _wrongNumberCfvoColorNodes =
	"Wrong number of 'cfvo'/'color' nodes in Conditional Formatting Rule";
	}

	internal class Nodes {
	internal const string _worksheet = "worksheet";
	internal const string _conditionalFormatting = "conditionalFormatting";
	internal const string _cfRule = "cfRule";
	internal const string _colorScale = "colorScale";
	internal const string _cfvo = "cfvo";
	internal const string _color = "color";
	internal const string _dataBar = "dataBar";
	internal const string _iconSet = "iconSet";
	internal const string _formula = "formula";
	}

	internal class Attributes {
	internal const string _aboveAverage = "aboveAverage";
	internal const string _bottom = "bottom";
	internal const string _dxfId = "dxfId";
	internal const string _equalAverage = "equalAverage";
	internal const string _iconSet = "iconSet";
	internal const string _operator = "operator";
	internal const string _percent = "percent";
	internal const string _priority = "priority";
	internal const string _rank = "rank";
	internal const string _reverse = "reverse";
	internal const string _rgb = "rgb";
	internal const string _showValue = "showValue";
	internal const string _sqref = "sqref";
	internal const string _stdDev = "stdDev";
	internal const string _stopIfTrue = "stopIfTrue";
	internal const string _text = "text";
	internal const string _theme = "theme";
	internal const string _timePeriod = "timePeriod";
	internal const string _tint = "tint";
	internal const string _type = "type";
	internal const string _val = "val";
	}

	internal class Paths {
	// Main node and attributes
	internal const string _worksheet = "d:" + Nodes._worksheet;

	// <conditionalFormatting> §18.3.1.18 node
	// can appear more than once in a worksheet
	internal const string _conditionalFormatting = "d:" + Nodes._conditionalFormatting;

	// <cfRule> §18.3.1.10 node
	// can appear more than once in a <conditionalFormatting>
	internal const string _cfRule = "d:" + Nodes._cfRule;

	// <colorScale> §18.3.1.16 node
	internal const string _colorScale = "d:" + Nodes._colorScale;

	// <cfvo> §18.3.1.11 node
	internal const string _cfvo = "d:" + Nodes._cfvo;

	// <color> §18.3.1.15 node
	internal const string _color = "d:" + Nodes._color;

	// <dataBar> §18.3.1.28 node
	internal const string _dataBar = "d:" + Nodes._dataBar;

	// <iconSet> §18.3.1.49 node
	internal const string _iconSet = "d:" + Nodes._iconSet;

	// <formula> §18.3.1.43 node
	internal const string _formula = "d:" + Nodes._formula;

	// Attributes (for all the nodes)
	internal const string _aboveAverageAttribute = "@" + Attributes._aboveAverage;
	internal const string _bottomAttribute = "@" + Attributes._bottom;
	internal const string _dxfIdAttribute = "@" + Attributes._dxfId;
	internal const string _equalAverageAttribute = "@" + Attributes._equalAverage;
	internal const string _iconSetAttribute = "@" + Attributes._iconSet;
	internal const string _operatorAttribute = "@" + Attributes._operator;
	internal const string _percentAttribute = "@" + Attributes._percent;
	internal const string _priorityAttribute = "@" + Attributes._priority;
	internal const string _rankAttribute = "@" + Attributes._rank;
	internal const string _reverseAttribute = "@" + Attributes._reverse;
	internal const string _rgbAttribute = "@" + Attributes._rgb;
	internal const string _showValueAttribute = "@" + Attributes._showValue;
	internal const string _sqrefAttribute = "@" + Attributes._sqref;
	internal const string _stdDevAttribute = "@" + Attributes._stdDev;
	internal const string _stopIfTrueAttribute = "@" + Attributes._stopIfTrue;
	internal const string _textAttribute = "@" + Attributes._text;
	internal const string _themeAttribute = "@" + Attributes._theme;
	internal const string _timePeriodAttribute = "@" + Attributes._timePeriod;
	internal const string _tintAttribute = "@" + Attributes._tint;
	internal const string _typeAttribute = "@" + Attributes._type;
	internal const string _valAttribute = "@" + Attributes._val;
	}

	internal class RuleType {
	internal const string _aboveAverage = "aboveAverage";
	internal const string _beginsWith = "beginsWith";
	internal const string _cellIs = "cellIs";
	internal const string _colorScale = "colorScale";
	internal const string _containsBlanks = "containsBlanks";
	internal const string _containsErrors = "containsErrors";
	internal const string _containsText = "containsText";
	internal const string _dataBar = "dataBar";
	internal const string _duplicateValues = "duplicateValues";
	internal const string _endsWith = "endsWith";
	internal const string _expression = "expression";
	internal const string _iconSet = "iconSet";
	internal const string _notContainsBlanks = "notContainsBlanks";
	internal const string _notContainsErrors = "notContainsErrors";
	internal const string _notContainsText = "notContainsText";
	internal const string _timePeriod = "timePeriod";
	internal const string _top10 = "top10";
	internal const string _uniqueValues = "uniqueValues";

	// EPPlus Extended Types
	internal const string _aboveOrEqualAverage = "aboveOrEqualAverage";
	internal const string _aboveStdDev = "aboveStdDev";
	internal const string _belowAverage = "belowAverage";
	internal const string _belowOrEqualAverage = "belowOrEqualAverage";
	internal const string _belowStdDev = "belowStdDev";
	internal const string _between = "between";
	internal const string _bottom = "bottom";
	internal const string _bottomPercent = "bottomPercent";
	internal const string _equal = "equal";
	internal const string _greaterThan = "greaterThan";
	internal const string _greaterThanOrEqual = "greaterThanOrEqual";
	internal const string _iconSet3 = "iconSet3";
	internal const string _iconSet4 = "iconSet4";
	internal const string _iconSet5 = "iconSet5";
	internal const string _last7Days = "last7Days";
	internal const string _lastMonth = "lastMonth";
	internal const string _lastWeek = "lastWeek";
	internal const string _lessThan = "lessThan";
	internal const string _lessThanOrEqual = "lessThanOrEqual";
	internal const string _nextMonth = "nextMonth";
	internal const string _nextWeek = "nextWeek";
	internal const string _notBetween = "notBetween";
	internal const string _notEqual = "notEqual";
	internal const string _thisMonth = "thisMonth";
	internal const string _thisWeek = "thisWeek";
	internal const string _threeColorScale = "threeColorScale";
	internal const string _today = "today";
	internal const string _tomorrow = "tomorrow";
	internal const string _top = "top";
	internal const string _topPercent = "topPercent";
	internal const string _twoColorScale = "twoColorScale";
	internal const string _yesterday = "yesterday";
	}

	internal class CfvoType {
	internal const string _min = "min";
	internal const string _max = "max";
	internal const string _num = "num";
	internal const string _formula = "formula";
	internal const string _percent = "percent";
	internal const string _percentile = "percentile";
	}

	internal class Operators {
	internal const string _beginsWith = "beginsWith";
	internal const string _between = "between";
	internal const string _containsText = "containsText";
	internal const string _endsWith = "endsWith";
	internal const string _equal = "equal";
	internal const string _greaterThan = "greaterThan";
	internal const string _greaterThanOrEqual = "greaterThanOrEqual";
	internal const string _lessThan = "lessThan";
	internal const string _lessThanOrEqual = "lessThanOrEqual";
	internal const string _notBetween = "notBetween";
	internal const string _notContains = "notContains";
	internal const string _notEqual = "notEqual";
	}

	internal class TimePeriods {
	internal const string _last7Days = "last7Days";
	internal const string _lastMonth = "lastMonth";
	internal const string _lastWeek = "lastWeek";
	internal const string _nextMonth = "nextMonth";
	internal const string _nextWeek = "nextWeek";
	internal const string _thisMonth = "thisMonth";
	internal const string _thisWeek = "thisWeek";
	internal const string _today = "today";
	internal const string _tomorrow = "tomorrow";
	internal const string _yesterday = "yesterday";
	}

	internal class Colors {
	internal const string _cfvoLowValue = "#FFF8696B";
	internal const string _cfvoMiddleValue = "#FFFFEB84";
	internal const string _cfvoHighValue = "#FF63BE7B";
	}
	}