OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 2

changes.mady.by.user Unknown User (georges)

Saved on

compared with

New Version 3

changes.mady.by.user Unknown User (georges)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0
Description

...

Wiki Markup
{description}
{excerpt}Assigns a data validation rule to all cells in the Area. If the [DataValidation] object uses a local reference or area in a formula (i.e. "=A5:B7"), then the area will adjust those local references accordingly based on the area's location. The original {{DataValidation}} object will not be affected.

...

Signature
C#C#
{excerpt}
{signature:C#}
 public void SetDataValidation(DataValidation dataValidation)
Signature
{signature}{signature:vb.net
vb.net
}
Public Sub SetDataValidation(ByVal dataValidation As DataValidation)
Parameters
{signature}
{parameters}
{param:dataValidation}A [DataValidation|DataValidation] object
        representing the data validation rule to assign to the Area.{param}
{example}{code:csharp|title=C#}
area.SetDataValidation(myDataValidation);
{code}
{code:vb.net
|title=vb.net
}
area.SetDataValidation(myDataValidation)
Param
dataValidationdataValidation

A DataValidation object
representing the data validation rule to assign to the Area.

Example
Code Block
csharpcsharp
titleC#
Code Block
vb.nettitle

...

{code}

{example}
{scrollbar}