# GrapeCity.Spreadsheet.DataRestrictions

## Content

<div class="doc-site-dotnet-api-container">




  <h1 id="GrapeCity_Spreadsheet_DataRestrictions" data-uid="GrapeCity.Spreadsheet.DataRestrictions" class="text-break">DataRestrictions Enum
</h1>
  <div class="markdown level0 summary"><p>Specifies the reason for an unaccepted expression or value.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="GrapeCity.Spreadsheet.html">GrapeCity.Spreadsheet</a></h6>
  <h6><strong>Assembly</strong>: GrapeCity.Spreadsheet.dll</h6>
  <h5 id="GrapeCity_Spreadsheet_DataRestrictions_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public enum DataRestrictions</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Enum DataRestrictions</code></pre>
  </div>
  <h3 id="fields">Fields
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    <thead>
    </thead></thead><tbody>
      <tr>
        <td id="GrapeCity_Spreadsheet_DataRestrictions_ExternalReference">ExternalReference</td>
        <td><p>You may not use references to other workbooks.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_DataRestrictions_IntegerOnly">IntegerOnly</td>
        <td><p>Decimal values cannot be used.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_DataRestrictions_InvalidBetween">InvalidBetween</td>
        <td><p>The maximum must be greater than or equal to the minimum.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_DataRestrictions_InvalidFormula">InvalidFormula</td>
        <td><p>Enter a valid formula.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_DataRestrictions_InvalidMultiReference">InvalidMultiReference</td>
        <td><p>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).</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_DataRestrictions_InvalidReference">InvalidReference</td>
        <td><p>This type of reference cannot be used in a formula.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_DataRestrictions_InvalidValue">InvalidValue</td>
        <td><p>The value (date/time) you entered is invalid.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_DataRestrictions_ListSource">ListSource</td>
        <td><p>The list source must be a delimited list, or a reference to single row or column.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_DataRestrictions_Missing">Missing</td>
        <td><p>Indicates that the formula is empty.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_DataRestrictions_MissingBetween">MissingBetween</td>
        <td><p>You must enter both a Maximum and a Minimum.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_DataRestrictions_NegativeValue">NegativeValue</td>
        <td><p>Negative values cannot be used.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_DataRestrictions_None">None</td>
        <td><p>Indicates that the expression is valid.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_DataRestrictions_NotFoundNamedRange">NotFoundNamedRange</td>
        <td><p>A named range you specified cannot be found.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_DataRestrictions_NumericOnly">NumericOnly</td>
        <td><p>The value must be a numeric value, numeric expression, or refer to a cell containing a numeric value.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_DataRestrictions_ReferenceOperatorsOrArrayConstants">ReferenceOperatorsOrArrayConstants</td>
        <td><p>You may not use reference operators (such as unions, intersections and ranges) or array constants.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_DataRestrictions_RelativeReference">RelativeReference</td>
        <td><p>You cannot use relative references.</p>
</td>
      </tr>
    </tbody>
  </table>
</div>