API Reference
Enum
NameValidationMode
Controls validation behavior for workbook defined names (Named Ranges) and A1 range bounds.
Inheritance
- Enum
- NameValidationMode
Usage
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by
Accepted by parameters
- Method ExcelDocument.EnsureValidDefinedName
- Method ExcelDocument.SetNamedRange
- Method ExcelSheet.SetNamedRange
Inherited Methods
public override sealed Int32 CompareTo(Object target) #Returns:
Int32Inherited from Enum
Parameters
- target Object
public override sealed String ToString(String format, IFormatProvider provider) #Returns:
StringInherited from Enum
Obsolete("The provider argument is not used. Use ToString(String) instead.")Parameters
- format String
Values
public const NameValidationMode Sanitize #Adjust invalid input into a legal Excel defined name (replace invalid characters with underscore, ensure a valid starting character, trim length). Names that resemble A1/R1C1 cell addresses are prefixed with an underscore. Out-of-bounds A1 ranges are clamped to Excel limits.
Value:
0public const NameValidationMode Strict #Enforce Excel rules strictly: throws when the name is invalid or the A1 range exceeds Excel bounds.
Value:
1