Enum
ExcelDefinedNameValidationMode
OfficeIMO.Excel
Controls validation behavior for workbook defined names (Named Ranges) and A1 range bounds.
Inheritance
- Enum
- ExcelDefinedNameValidationMode
Usage
Explore 8 API references to this type
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by 2
Accepted by parameters 6
- Method ExcelDocument.NormalizeDefinedName
- Method ExcelDocument.RenameNamedRange
- Method ExcelDocument.SetNamedFormula
- Method ExcelDocument.SetNamedRange
- Method ExcelSheet.SetNamedFormula
- Method ExcelSheet.SetNamedRange
Inherited Methods
ToString 4 overloads
public string ToString(IFormatProvider? provider) #Inherited from Enum
Obsolete("The provider argument is not used. Use ToString() instead.")Parameters
- provider IFormatProvider?
Returns
stringpublic string ToString(string? format, IFormatProvider? provider) #Inherited from Enum
Obsolete("The provider argument is not used. Use ToString(String) instead.")Parameters
- format string?
- provider IFormatProvider?
Returns
stringValues
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