Class GridFormulaNamedRangesEditHelper.NamedRange
Holds Key and Value for a named range.
Inheritance
Inherited Members
Namespace: Syncfusion.Windows.Forms.Grid
Assembly: Syncfusion.Grid.Windows.dll
Syntax
public class NamedRange
Constructors
NamedRange()
Initializes a new instance of the GridFormulaNamedRangesEditHelper.NamedRange class.
Declaration
public NamedRange()
NamedRange(String, String)
Initializes a new instance of the GridFormulaNamedRangesEditHelper.NamedRange class.
Declaration
public NamedRange(string key, string val)
Parameters
Type | Name | Description |
---|---|---|
System.String | key | Name of the NamedRange. |
System.String | val | Value of the NamedRange. |
Remarks
GridFormulaEngine allows you to write formulas where strings can be substituted for explicit values or cell references. For example, instead of hard coding an interest value as in formula '= .052 * B12', you could write '= InterestRate * B12' where InterestRate is the Name for a NameRange object and .052 is its value. Then later, if the interest rate changes, you only have to modify the value of the InterestRate NamedRange object, and do not have to directly modify values in cells. The NamedRange.Key property holds the name and the NamedRange.Value property holds the value.
Properties
Key
Gets or sets the name used for this named range.
Declaration
public string Key { get; set; }
Property Value
Type |
---|
System.String |
Value
Gets or sets the value for this named range.
Declaration
public string Value { get; set; }
Property Value
Type |
---|
System.String |
Methods
ToString()
Overridden to return the Key property.
Declaration
public override string ToString()
Returns
Type | Description |
---|---|
System.String | The Key property. |