API Reference
Enum
ExcelDefinedNameValidationMode
Controls validation behavior for workbook defined names (Named Ranges) and A1 range bounds.
Inheritance
- Enum
- ExcelDefinedNameValidationMode
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.RenameNamedRange
- Method ExcelDocument.SetNamedRange
- Method ExcelSheet.SetNamedRange
Inherited Methods
public override sealed Int32 CompareTo(Object target) #Returns:
Int32Inherited from Enum
Parameters
- target Object
ToString 4 overloads
public override sealed String ToString(IFormatProvider provider) #Returns:
StringInherited from Enum
Obsolete("The provider argument is not used. Use ToString() instead.")Parameters
- provider IFormatProvider
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
- provider IFormatProvider
Values
public const ExcelDefinedNameValidationMode 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 ExcelDefinedNameValidationMode Strict #Enforce Excel rules strictly: throws when the name is invalid or the A1 range exceeds Excel bounds.
Value:
1