Skip to content

Class EpplusFormulaTableColumnAttribute

Namespace: OfficeOpenXml.Attributes
Assembly: EPPlus.dll

Use this attribute on a class or an interface to insert a column with a formula

[AttributeUsage(AttributeTargets.Class|AttributeTargets.Interface, AllowMultiple = true)]
public class EpplusFormulaTableColumnAttribute : EpplusTableColumnAttributeBase

Inheritance

object ← Attribute ← EpplusTableColumnAttributeBase ← EpplusFormulaTableColumnAttribute

Inherited Members

Attribute.Equals(object?)
Attribute.GetCustomAttribute(Assembly, Type, bool)
Attribute.GetCustomAttribute(Assembly, Type)
Attribute.GetCustomAttribute(MemberInfo, Type, bool)
Attribute.GetCustomAttribute(MemberInfo, Type)
Attribute.GetCustomAttribute(Module, Type, bool)
Attribute.GetCustomAttribute(Module, Type)
Attribute.GetCustomAttribute(ParameterInfo, Type, bool)
Attribute.GetCustomAttribute(ParameterInfo, Type)
Attribute.GetCustomAttributes(Assembly, bool)
Attribute.GetCustomAttributes(Assembly, Type, bool)
Attribute.GetCustomAttributes(Assembly, Type)
Attribute.GetCustomAttributes(Assembly)
Attribute.GetCustomAttributes(MemberInfo, bool)
Attribute.GetCustomAttributes(MemberInfo, Type, bool)
Attribute.GetCustomAttributes(MemberInfo, Type)
Attribute.GetCustomAttributes(MemberInfo)
Attribute.GetCustomAttributes(Module, bool)
Attribute.GetCustomAttributes(Module, Type, bool)
Attribute.GetCustomAttributes(Module, Type)
Attribute.GetCustomAttributes(Module)
Attribute.GetCustomAttributes(ParameterInfo, bool)
Attribute.GetCustomAttributes(ParameterInfo, Type, bool)
Attribute.GetCustomAttributes(ParameterInfo, Type)
Attribute.GetCustomAttributes(ParameterInfo)
Attribute.GetHashCode()
Attribute.IsDefaultAttribute()
Attribute.IsDefined(Assembly, Type, bool)
Attribute.IsDefined(Assembly, Type)
Attribute.IsDefined(MemberInfo, Type, bool)
Attribute.IsDefined(MemberInfo, Type)
Attribute.IsDefined(Module, Type, bool)
Attribute.IsDefined(Module, Type)
Attribute.IsDefined(ParameterInfo, Type, bool)
Attribute.IsDefined(ParameterInfo, Type)
Attribute.Match(object?)
Attribute.TypeId
EpplusTableColumnAttributeBase.Header
EpplusTableColumnAttributeBase.Hidden
EpplusTableColumnAttributeBase.NumberFormat
EpplusTableColumnAttributeBase.Order
EpplusTableColumnAttributeBase.TotalsRowFormula
EpplusTableColumnAttributeBase.TotalsRowFunction
EpplusTableColumnAttributeBase.TotalsRowLabel
EpplusTableColumnAttributeBase.TotalsRowNumberFormat
EpplusTableColumnAttributeBase.UseBuiltInHyperlinkStyle
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Constructors

EpplusFormulaTableColumnAttribute()

public EpplusFormulaTableColumnAttribute()

Properties

Formula

The spreadsheet formula (don't include the leading '='). If you use the {row} placeholder in the formula it will be replaced with the actual row of each cell in the column.

public string Formula { get; set; }

Property Value

string

FormulaR1C1

The spreadsheet formula (don't include the leading '=') in R1C1 format.

public string FormulaR1C1 { get; set; }

Property Value

string