Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Excerpt

Returns the cell's DataValidation object if one exists. Otherwise, returns 'null'.

Signature
C#
C#

 public DataValidation DataValidation{ get; set; }
Signature
vb.net
vb.net

Public Property DataValidation() As DataValidation
Remarks

When setting the dataValidation, if the value you're setting it to uses a local reference or area in a formula (i.e. "=A5:B7"), then the cell will adjust those local references accordingly based on the cell's location. The original dataValidation object you assigned the cell to use will remain unaffected.

Signature
C#C#

 public DataValidation DataValidation{ get; set; }
Signature
vb.netvb.net

Public Property DataValidation() As DataValidation
Example
Code Block
csharp
csharp
titleC#
DataValidation dv = cellA1.DataValidation;
Code Block
vb.net
vb.net
titlevb.net
Dim dv As DataValidation = cellA1.DataValidation

...