/*******************************************************************************
* 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 2012-04-03
*******************************************************************************/
using OfficeOpenXml.ConditionalFormatting.Contracts;
using System.Drawing;
namespace OfficeOpenXml.ConditionalFormatting
{
///
/// Provides functionality for adding Conditional Formatting to a range ().
/// Each method will return a configurable condtional formatting type.
///
public interface IRangeConditionalFormatting
{
///
/// Adds a Above Average rule to the range
///
///
IExcelConditionalFormattingAverageGroup AddAboveAverage();
///
/// Adds a Above Or Equal Average rule to the range
///
///
IExcelConditionalFormattingAverageGroup AddAboveOrEqualAverage();
///
/// Adds a Below Average rule to the range
///
///
IExcelConditionalFormattingAverageGroup AddBelowAverage();
///
/// Adds a Below Or Equal Average rule to the range
///
///
IExcelConditionalFormattingAverageGroup AddBelowOrEqualAverage();
///
/// Adds a Above StdDev rule to the range
///
///
IExcelConditionalFormattingStdDevGroup AddAboveStdDev();
///
/// Adds a Below StdDev rule to the range
///
///
IExcelConditionalFormattingStdDevGroup AddBelowStdDev();
///
/// Adds a Bottom rule to the range
///
///
IExcelConditionalFormattingTopBottomGroup AddBottom();
///
/// Adds a Bottom Percent rule to the range
///
///
IExcelConditionalFormattingTopBottomGroup AddBottomPercent();
///
/// Adds a Top rule to the range
///
///
IExcelConditionalFormattingTopBottomGroup AddTop();
///
/// Adds a Top Percent rule to the range
///
///
IExcelConditionalFormattingTopBottomGroup AddTopPercent();
///
/// Adds a Last 7 Days rule to the range
///
///
IExcelConditionalFormattingTimePeriodGroup AddLast7Days();
///
/// Adds a Last Month rule to the range
///
///
IExcelConditionalFormattingTimePeriodGroup AddLastMonth();
///
/// Adds a Last Week rule to the range
///
///
IExcelConditionalFormattingTimePeriodGroup AddLastWeek();
///
/// Adds a Next Month rule to the range
///
///
IExcelConditionalFormattingTimePeriodGroup AddNextMonth();
///
/// Adds a Next Week rule to the range
///
///
IExcelConditionalFormattingTimePeriodGroup AddNextWeek();
///
/// Adds a This Month rule to the range
///
///
IExcelConditionalFormattingTimePeriodGroup AddThisMonth();
///
/// Adds a This Week rule to the range
///
///
IExcelConditionalFormattingTimePeriodGroup AddThisWeek();
///
/// Adds a Today rule to the range
///
///
IExcelConditionalFormattingTimePeriodGroup AddToday();
///
/// Adds a Tomorrow rule to the range
///
///
IExcelConditionalFormattingTimePeriodGroup AddTomorrow();
///
/// Adds a Yesterday rule to the range
///
///
IExcelConditionalFormattingTimePeriodGroup AddYesterday();
///
/// Adds a Begins With rule to the range
///
///
IExcelConditionalFormattingBeginsWith AddBeginsWith();
///
/// Adds a Between rule to the range
///
///
IExcelConditionalFormattingBetween AddBetween();
///
/// Adds a ContainsBlanks rule to the range
///
///
IExcelConditionalFormattingContainsBlanks AddContainsBlanks();
///
/// Adds a ContainsErrors rule to the range
///
///
IExcelConditionalFormattingContainsErrors AddContainsErrors();
///
/// Adds a ContainsText rule to the range
///
///
IExcelConditionalFormattingContainsText AddContainsText();
///
/// Adds a DuplicateValues rule to the range
///
///
IExcelConditionalFormattingDuplicateValues AddDuplicateValues();
///
/// Adds a EndsWith rule to the range
///
///
IExcelConditionalFormattingEndsWith AddEndsWith();
///
/// Adds a Equal rule to the range
///
///
IExcelConditionalFormattingEqual AddEqual();
///
/// Adds a Expression rule to the range
///
///
IExcelConditionalFormattingExpression AddExpression();
///
/// Adds a GreaterThan rule to the range
///
///
IExcelConditionalFormattingGreaterThan AddGreaterThan();
///
/// Adds a GreaterThanOrEqual rule to the range
///
///
IExcelConditionalFormattingGreaterThanOrEqual AddGreaterThanOrEqual();
///
/// Adds a LessThan rule to the range
///
///
IExcelConditionalFormattingLessThan AddLessThan();
///
/// Adds a LessThanOrEqual rule to the range
///
///
IExcelConditionalFormattingLessThanOrEqual AddLessThanOrEqual();
///
/// Adds a NotBetween rule to the range
///
///
IExcelConditionalFormattingNotBetween AddNotBetween();
///
/// Adds a NotContainsBlanks rule to the range
///
///
IExcelConditionalFormattingNotContainsBlanks AddNotContainsBlanks();
///
/// Adds a NotContainsErrors rule to the range
///
///
IExcelConditionalFormattingNotContainsErrors AddNotContainsErrors();
///
/// Adds a NotContainsText rule to the range
///
///
IExcelConditionalFormattingNotContainsText AddNotContainsText();
///
/// Adds a NotEqual rule to the range
///
///
IExcelConditionalFormattingNotEqual AddNotEqual();
///
/// Adds a UniqueValues rule to the range
///
///
IExcelConditionalFormattingUniqueValues AddUniqueValues();
///
/// Adds a to the range
///
///
IExcelConditionalFormattingThreeColorScale AddThreeColorScale();
///
/// Adds a to the range
///
///
IExcelConditionalFormattingTwoColorScale AddTwoColorScale();
///
/// Adds a to the range
///
///
///
IExcelConditionalFormattingThreeIconSet AddThreeIconSet(eExcelconditionalFormatting3IconsSetType IconSet);
///
/// Adds a to the range
///
///
///
IExcelConditionalFormattingFourIconSet AddFourIconSet(eExcelconditionalFormatting4IconsSetType IconSet);
///
/// Adds a to the range
///
///
///
IExcelConditionalFormattingFiveIconSet AddFiveIconSet(eExcelconditionalFormatting5IconsSetType IconSet);
///
/// Adds a to the range
///
///
///
IExcelConditionalFormattingDataBarGroup AddDatabar(Color color);
}
}