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

Versions Compared

Old Version 7

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 value)
Signature
vb.net
vb.net
Public Function CreateDataValidation(ByVal allowedType As ValidationType, ByVal comparison As ComparisonType, ByVal value 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
value
value

A formula representing the constraint for the data validation.

Returns

A DataValidation object.

Example
Code Block
csharp
csharp
titleC#

          DataValidation dataValidation =
               wb.createDataValidation(
               DataValidation.ValidationType.WholeNumber,
               DataValidation.ComparisonType.LessThan, "=1");
Code Block
vb.net
vb.net
titlevb.net

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