# GrapeCity.Spreadsheet.FormatOptions

## Content

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




  <h1 id="GrapeCity_Spreadsheet_FormatOptions" data-uid="GrapeCity.Spreadsheet.FormatOptions" class="text-break">FormatOptions Enum
</h1>
  <div class="markdown level0 summary"><p>Represents advanced options for formatting value to text.</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_FormatOptions_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">[Flags]
public enum FormatOptions : byte</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">&lt;Flags&gt;
Public Enum FormatOptions As Byte</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_FormatOptions_Date1904">Date1904</td>
        <td><p>Indicates that the date system used to convert a date from/to a serial value starts since 1/1/1904.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_FormatOptions_Editing">Editing</td>
        <td><p>Indicates that the value is formatted for editing.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_FormatOptions_ExcelCompatible">ExcelCompatible</td>
        <td><p>Indicates that formatting serial numeric value as date will be compatible with Excel.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_FormatOptions_None">None</td>
        <td><p>Indicates that no additional options should be used when formatting a value.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_FormatOptions_RepeatChar">RepeatChar</td>
        <td><p>Indicates that the repeat character information will be included</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_FormatOptions_Space">Space</td>
        <td><p>Indicates that the space details information, which is created by '_' symbol, will be returned.</p>
</td>
      </tr>
    </tbody>
  </table>
</div>