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

Versions Compared

Old Version 6

changes.mady.by.user Wiki Administrator

Saved on

compared with

New Version Current

changes.mady.by.user Wiki Administrator

Saved on

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

Creates a DataValidation object which can be set on a Range, Area, or Cell.

Signature
C#
C#
 public DataValidation CreateDataValidation(ValidationType allowedType, ComparisonType comparison, System.String minimumValue, System.String maximumValue)
{signature}{signature:
}
Signature
vb.net
vb.net
Public Function CreateDataValidation(ByVal allowedType As ValidationType, ByVal comparison As ComparisonType, ByVal minimumValue As String, ByVal maximumValue As String) As DataValidation
{signature}
{parameters}
{param:allowedType}The data type allowed in the cell.{param}
{param:comparison}The comparison used to validate the cell's value.{param}
{param:minimumValue}A formula representing the cell's maximum value.{param}
{param:maximumValue}A formula representing the cell's minimum value.{param}
{returns}A [DataValidation|DataValidation] object.{returns}
{example}{code:csharp|title=C#}
Parameters
Param
allowedType
allowedType

The data type allowed in the cell.

Param
comparison
comparison

The comparison used to validate the cell's value.

Param
minimumValue
minimumValue

A formula representing the cell's maximum value.

Param
maximumValue
maximumValue

A formula representing the cell's minimum value.

Returns

A DataValidation object.

Example
Code Block
csharp
csharp
titleC#


          DataValidation dataValidation =
               wb.createDataValidation(
               DataValidation.ValidationType.WholeNumber,
               DataValidation.ComparisonType.Between, "=1", "=100");
{code} {code:
 Code Block
vb.net
|title=
vb.net
titlevb.net
}


          Dim dataValidation As DataValidation = _
               wb.createDataValidation( _
               DataValidation.ValidationType.WholeNumber, _
               DataValidation.ComparisonType.Between, "=1", "=100")
        
{code}

{example}