Skip to main content

SpreadsheetDataValidationBehaviorOptions Members

Provides options to restrict an end-user’s capability to manage data validation rules in a document loaded into SpreadsheetControl.

Constructors

Name Description
SpreadsheetDataValidationBehaviorOptions() Initializes a new instance of the SpreadsheetDataValidationBehaviorOptions class with the default settings.

Properties

Name Description
CircleInvalidData Gets or sets the document’s capability to display circles around incorrect values entered into validated cells.
CircleInvalidDataAllowed Gets whether an end-user is allowed to circle invalid data.
ClearValidationCircles Gets or sets the document’s capability to hide data validation circles.
ClearValidationCirclesAllowed Gets whether an end-user is allowed to hide validation circles.
ModifyValidationRules Gets or sets the document’s capability to create, modify or clear data validation rules.
ModifyValidationRulesAllowed Gets whether an end-user is allowed to create or modify data validation rules.

Methods

Name Description
Assign(BaseOptions) Copies all settings from the SpreadsheetDataValidationBehaviorOptions object passed as a parameter.
BeginUpdate() Locks the BaseOptions object by disallowing visual updates until the EndUpdate or CancelUpdate method is called. Inherited from BaseOptions.
CancelUpdate() Unlocks the BaseOptions object after it has been locked by the BeginUpdate method, without causing an immediate visual update. Inherited from BaseOptions.
EndUpdate() Unlocks the BaseOptions object after a call to the BeginUpdate method and causes an immediate visual update. Inherited from BaseOptions.
Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object) Determines whether the specified object is equal to the current object. Inherited from Object.
GetHashCode() Serves as the default hash function. Inherited from Object.
GetType() Gets the Type of the current instance. Inherited from Object.
MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
ToString() Returns a string representing the currently enabled options. Inherited from BaseOptions.
See Also