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

Versions Compared

Old Version 1

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
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
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 Block
vb.net
vb.net
titlevb.net

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