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, System.String formula)
Signature
vb.net
vb.net
Public Function CreateDataValidation(ByVal allowedType As ValidationType, ByVal formula As String) As DataValidation
Parameters
Param
allowedType
allowedType

The data type allowed in the cell.

Param
formula
formula

For 'Custom' allowed type: the formula used to validate the cell's data. For 'List' allowed type: the formula referencing a range in the worksheet.

Returns

A DataValidation object.

Example
Code Block
csharp
csharp
titleC#

          DataValidation dataValidation =
               wb.createDataValidation(
               DataValidation.ValidationType.List,
               "C10:C18");
Code Block
vb.net
vb.net
titlevb.net

          Dim dataValidation As DataValidation = _
               wb.createDataValidation( _
               DataValidation.ValidationType.List, _
               "C10:C18")