IRangeProvider.ValidateReference(String, ReferenceStyle) Method
In This Article
Validates the cell reference in accordance with the specified cell reference style.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
#Declaration
bool ValidateReference(
string reference,
ReferenceStyle style
)
#Parameters
Name | Type | Description |
---|---|---|
reference | String | A cell reference to be validated. |
style | Reference |
An enumeration member that specifies the cell reference style. |
#Returns
Type | Description |
---|---|
Boolean | true, if the specified cell reference is valid; otherwise, false. |
#Remarks
The example below shows how to use the ValidateReference method to check whether the specified cell references are valid.
worksheet.Range.ValidateReference("A1:C4", ReferenceStyle.A1); // returns true
worksheet.Range.ValidateReference("R[-5]C[4]:R1C[-2]", ReferenceStyle.R1C1); // returns true
worksheet.Range.ValidateReference("A1:B1:C1", ReferenceStyle.A1); // returns false
worksheet.Range.ValidateReference("Sheet1!R12C7", ReferenceStyle.R1C1); // returns false
See Also