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

...

Description

Excerpt

Returns the cell's

...

DataValidation

...

object

...

if

...

one

...

exists.

...

Otherwise,

...

returns

...

'null'.

...

Signature
C#
C#
 public DataValidation DataValidation{ get; set; }
{signature}{signature:
}
Signature
vb.net
vb.net
Public Property DataValidation() As DataValidation
{signature}
{remarks}
When setting the dataValidation, if the value 
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.

{remarks} {example}{code:csharp|title=C#}

Example
Code Block
csharp
csharp
titleC#

DataValidation dv = cellA1.DataValidation;
{code} {code:
Code Block
vb.net
|title=
vb.net
titlevb.net
}

Dim dv As DataValidation = cellA1.DataValidation
{code} {example} {scrollbar}
Scrollbar