API Reference
Enum
NameValidationMode
Controls validation behavior for workbook defined names (Named Ranges) and A1 range bounds.
Inheritance
- Enum
- NameValidationMode
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