Class ExcelConditionalFormatFormulaAttribute

Namespace

BigExcelCreator.ClassAttributes

Assembly

BigExcelCreator.dll

Adds a conditional formatting rule based on a formula

[AttributeUsage(AttributeTargets.Property, AllowMultiple = false)]
public sealed class ExcelConditionalFormatFormulaAttribute : Attribute

Inheritance

object

Attribute

ExcelConditionalFormatFormulaAttribute

Inherited Members

Attribute.Equals(object)

Attribute.GetCustomAttribute(Assembly, Type)

Attribute.GetCustomAttribute(Assembly, Type, bool)

Attribute.GetCustomAttribute(MemberInfo, Type)

Attribute.GetCustomAttribute(MemberInfo, Type, bool)

Attribute.GetCustomAttribute(Module, Type)

Attribute.GetCustomAttribute(Module, Type, bool)

Attribute.GetCustomAttribute(ParameterInfo, Type)

Attribute.GetCustomAttribute(ParameterInfo, Type, bool)

Attribute.GetCustomAttributes(Assembly)

Attribute.GetCustomAttributes(Assembly, bool)

Attribute.GetCustomAttributes(Assembly, Type)

Attribute.GetCustomAttributes(Assembly, Type, bool)

Attribute.GetCustomAttributes(MemberInfo)

Attribute.GetCustomAttributes(MemberInfo, bool)

Attribute.GetCustomAttributes(MemberInfo, Type)

Attribute.GetCustomAttributes(MemberInfo, Type, bool)

Attribute.GetCustomAttributes(Module)

Attribute.GetCustomAttributes(Module, bool)

Attribute.GetCustomAttributes(Module, Type)

Attribute.GetCustomAttributes(Module, Type, bool)

Attribute.GetCustomAttributes(ParameterInfo)

Attribute.GetCustomAttributes(ParameterInfo, bool)

Attribute.GetCustomAttributes(ParameterInfo, Type)

Attribute.GetCustomAttributes(ParameterInfo, Type, bool)

Attribute.GetHashCode()

Attribute.IsDefaultAttribute()

Attribute.IsDefined(Assembly, Type)

Attribute.IsDefined(Assembly, Type, bool)

Attribute.IsDefined(MemberInfo, Type)

Attribute.IsDefined(MemberInfo, Type, bool)

Attribute.IsDefined(Module, Type)

Attribute.IsDefined(Module, Type, bool)

Attribute.IsDefined(ParameterInfo, Type)

Attribute.IsDefined(ParameterInfo, Type, bool)

Attribute.Match(object)

Attribute.TypeId

object.Equals(object, object)

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Constructors

ExcelConditionalFormatFormulaAttribute(int, string)

Adds a conditional formatting rule based on a formula

public ExcelConditionalFormatFormulaAttribute(int format, string formula)

Parameters

format int

The format ID of the differential format in styleSheet to apply when the condition is met. See GetIndexDifferentialByName(string).

formula string

The formula that determines the conditional formatting rule.

ExcelConditionalFormatFormulaAttribute(string, string)

Adds a conditional formatting rule based on a formula

public ExcelConditionalFormatFormulaAttribute(string styleName, string formula)

Parameters

styleName string

The differential style name to apply to the cell.

formula string

The formula that determines the conditional formatting rule.

Properties

Format

The format ID of the differential format in styleSheet to apply when the condition is met. See GetIndexDifferentialByName(string).

public int Format { get; }

Property Value

int

Formula

The formula that determines the conditional formatting rule.

public string Formula { get; }

Property Value

string

StyleName

The differential style name to apply to the cell.

public string StyleName { get; }

Property Value

string