# FarPoint.Excel.ExcelSaveFlags

## Content

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




  <h1 id="FarPoint_Excel_ExcelSaveFlags" data-uid="FarPoint.Excel.ExcelSaveFlags" class="text-break">ExcelSaveFlags Enum
</h1>
  <div class="markdown level0 summary"><p>Specifies what part of the spreadsheet to export to an Excel-compatible file.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="FarPoint.Excel.html">FarPoint.Excel</a></h6>
  <h6><strong>Assembly</strong>: FarPoint.Excel.dll</h6>
  <h5 id="FarPoint_Excel_ExcelSaveFlags_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">[Flags]
public enum ExcelSaveFlags</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">&lt;Flags&gt;
Public Enum ExcelSaveFlags</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="FarPoint_Excel_ExcelSaveFlags_AutoRowHeight">AutoRowHeight</td>
        <td><p>[4096] The default row height is not saved.  Excel will automatically determine row heights based on the largest font that is set in each row.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelSaveFlags_ComboAsDataValidation">ComboAsDataValidation</td>
        <td><p>[16384] Indicates the ComboBoxCellType will be exported as DataValidation.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelSaveFlags_DataOnly">DataOnly</td>
        <td><p>[32] Saves only the data to the Excel-compatible file.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelSaveFlags_DocumentCaching">DocumentCaching</td>
        <td><p>[2048] Keeps Excel data that was previously loaded from the files (e.g. VBA, Macro).</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelSaveFlags_Exchangeable">Exchangeable</td>
        <td><p>Indicates that the extension data will be saved.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelSaveFlags_ExternalReference">ExternalReference</td>
        <td><p>Indicates that the saved file will be used for external references to the spreadsheet.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelSaveFlags_MacroEnabledWorkbook">MacroEnabledWorkbook</td>
        <td><p>Saves the spreadsheet to an XLSM format.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelSaveFlags_NoFlagsSet">NoFlagsSet</td>
        <td><p>[0] Saves the spreadsheet to the Excel-compatible file with no special options.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelSaveFlags_NoFormulas">NoFormulas</td>
        <td><p>[1] Saves the displayed data but not the formulas to the Excel-compatible file.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelSaveFlags_NoNotes">NoNotes</td>
        <td><p>[1024] Saves the displayed data and formatting, but not the notes.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelSaveFlags_PreferTextOnExport">PreferTextOnExport</td>
        <td><p>The cell text will be exported if there is an explicit cell type.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelSaveFlags_SaveAlternatingRowStyles">SaveAlternatingRowStyles</td>
        <td><p>[64] Saves the appearance settings of alternating rows to the Excel-compatible file.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelSaveFlags_SaveAsFiltered">SaveAsFiltered</td>
        <td><p>[8] Saves the results of rows after filtering them to the Excel-compatible file.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelSaveFlags_SaveAsViewed">SaveAsViewed</td>
        <td><p>[136] Saves the spreadsheet as viewed to the Excel-compatible file.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelSaveFlags_SaveBothCustomRowAndColumnHeaders">SaveBothCustomRowAndColumnHeaders</td>
        <td><p>[6] Saves both the custom row headers and the custom column headers to the Excel-compatible file.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelSaveFlags_SaveCustomColumnHeaders">SaveCustomColumnHeaders</td>
        <td><p>[4] Saves the custom column headers to the Excel-compatible file.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelSaveFlags_SaveCustomRowHeaders">SaveCustomRowHeaders</td>
        <td><p>[2] Saves the custom row headers to the Excel-compatible file.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelSaveFlags_UseCustomPaletteForColorApproximations">UseCustomPaletteForColorApproximations</td>
        <td><p>[256] Uses a custom color palette, and uses it for color approximations if there are more than 56 colors set into Spread.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelSaveFlags_UseDefaultColorPalette">UseDefaultColorPalette</td>
        <td><p>[512] Uses the default color palette.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Excel_ExcelSaveFlags_UseOOXMLFormat">UseOOXMLFormat</td>
        <td><p>[16] Saves the spreadsheet to an Excel 2007 (OfficeOpen XML) format.</p>
</td>
      </tr>
    </tbody>
  </table>
</div>