Gets the formula which defines the named reference. Syntax Property Value The formula which defines the named reference.
Gets the value indicating whether the Formula is a simple formula referring to a single cell, a single region, or multiple regions in the same workbook as the named reference. Syntax Remarks If the reference is surrounded by parentheses or whitespace or the named reference has some other complex formula this will ...
Gets the WorksheetCell referenced by the Formula. Syntax Remarks If named reference is a reference to one or more regions, this will return null.
Gets the WorksheetRegion referenced by the Formula. Syntax Remarks If the named reference is a reference to a single cell or multiple regions, this will return null.
Gets the array of WorksheetRegion instances referenced by the Formula. Syntax Remarks If the named reference is a reference to a single cell or region, this will return null.
Sets the formula for a named reference. Syntax Parameters formula The string containing the formula value. Exceptions Exception Description System.ArgumentNullException formula is null or empty. System.ArgumentException formula is not a valid formula. The inner exception will contain the FormulaParseException desc...
Sets the formula for a named reference. Syntax Parameters formula The string containing the formula value.cellReferenceMode The mode used to interpret cell references in the formula. Exceptions Exception Description System.ArgumentNullException formula is null or empty. System.ComponentModel.InvalidEnumArgumentExc...
Sets the formula for a named reference. Syntax Parameters formula The string containing the formula value.cellReferenceMode The mode used to interpret cell references in the formula.culture The culture used to parse the formula. Exceptions Exception Description System.ArgumentNullException formula is null or empty...
Sets the formula for a named reference. Overload List
Gets the string representation of the named reference. Syntax Return Value The string representation of the named reference.