Spire.XLS API
Spire.XLS namespace
Spire.Xls.Core.Spreadsheet.Collections
XlsRangesCollection Class
XlsRangesCollection Properties
BooleanValue Property
Borders Property
BuiltInStyle Property
CellList Property
Cells Property
CellsCount Property
CellStyleName Property
Column Property
ColumnGroupLevel Property
Columns Property
ColumnWidth Property
Comment Property
ConditionalFormats Property
DataValidation Property
DateTimeValue Property
EndCell Property
EntireColumn Property
EntireRow Property
EnvalutedValue Property
ErrorValue Property
Formula Property
FormulaArray Property
FormulaArrayR1C1 Property
FormulaBoolValue Property
FormulaDateTime Property
FormulaErrorValue Property
FormulaNumberValue Property
FormulaR1C1 Property
FormulaStringValue Property
HasBoolean Property
HasDataValidation Property
HasDateTime Property
HasError Property
HasExternalFormula Property
HasFormula Property
HasFormulaArray Property
HasFormulaBoolValue Property
HasFormulaDateTime Property
HasFormulaErrorValue Property
HasFormulaNumberValue Property
HasFormulaStringValue Property
HasMerged Property
HasNumber Property
HasRichText Property
HasString Property
HasStyle Property
HorizontalAlignment Property
HtmlString Property
Hyperlinks Property
IgnoreErrorOptions Property
IndentLevel Property
IsBlank Property
IsFormulaHidden Property
IsGroupedByColumn Property
IsGroupedByRow Property
IsInitialized Property
IsStringsPreserved Property
IsWrapText Property
Item Property
LastColumn Property
LastRow Property
MergeArea Property
NumberFormat Property
NumberText Property
NumberValue Property
RangeAddress Property
RangeAddressLocal Property
RangeGlobalAddress Property
RangeGlobalAddress2007 Property
RangeR1C1Address Property
RangeR1C1AddressLocal Property
RichText Property
Row Property
RowGroupLevel Property
RowHeight Property
Rows Property
Style Property
Text Property
TimeSpanValue Property
Value Property
Value2 Property
VerticalAlignment Property
Worksheet Property
WorksheetName Property
Click or drag to resize

XlsRangesCollection HasDataValidation Property

Indicates whether specified range object has data validation. If Range is not single cell, then returns true only if all cells have data validation. Read-only.

Namespace: Spire.Xls.Core.Spreadsheet.Collections
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public bool HasDataValidation { get; }

Property Value

Type: Boolean

Implements

IXLSRange HasDataValidation
See Also