[]
        
(Showing Draft Content)

GrapeCity.Spreadsheet.DataRestrictions

DataRestrictions Enum

Specifies the reason for an unaccepted expression or value.

Namespace: GrapeCity.Spreadsheet
Assembly: GrapeCity.Spreadsheet.dll
Syntax
public enum DataRestrictions
Public Enum DataRestrictions

Fields

Name Description
ExternalReference

You may not use references to other workbooks.

IntegerOnly

Decimal values cannot be used.

InvalidBetween

The maximum must be greater than or equal to the minimum.

InvalidFormula

Enter a valid formula.

InvalidMultiReference

This type of reference cannot be used in a formula. Change the reference to a single cell, or use the reference with a worksheet function, such as =SUM(A1:E5).

InvalidReference

This type of reference cannot be used in a formula.

InvalidValue

The value (date/time) you entered is invalid.

ListSource

The list source must be a delimited list, or a reference to single row or column.

Missing
MissingBetween

You must enter both a Maximum and a Minimum.

NegativeValue

Negative values cannot be used.

None

Indicates that the expression is valid.

NotFoundNamedRange

A named range you specified cannot be found.

NumericOnly

The value must be a numeric value, numeric expression, or refer to a cell containing a numeric value.

ReferenceOperatorsOrArrayConstants

You may not use reference operators (such as unions, intersections and ranges) or array constants.

RelativeReference

You cannot use relative references.