Spread Windows Forms 7.0 Product Documentation
ExcelSaveFlags Enumeration
See Also  Support Options
FarPoint.Excel Assembly > FarPoint.Excel Namespace : ExcelSaveFlags Enumeration


Glossary Item Box

Specifies what part of the spreadsheet to export to an Excel-compatible file.

Syntax

Visual Basic (Declaration) 
Public Enum ExcelSaveFlags 
   Inherits System.Enum
Visual Basic (Usage)Copy Code
Dim instance As ExcelSaveFlags
C# 
public enum ExcelSaveFlags : System.Enum 

Members

MemberDescription
AutoRowHeight[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.
ComboDataOnly[8192] Saves the displayed data in the combobox celltype, does not save the items in the combo box.
DataOnly[32] Saves only the data to the Excel-compatible file.
DocumentCaching[2048] Keeps Excel data that was previously loaded from the files (e.g. VBA, Macro).
NoFlagsSet[0] Saves the spreadsheet to the Excel-compatible file with no special options.
NoFormulas[1] Saves the displayed data but not the formulas to the Excel-compatible file.
NoNotes[1024] Saves the displayed data and formatting, but not the notes.
SaveAlternatingRowStyles[64] Saves the appearance settings of alternating rows to the Excel-compatible file.
SaveAsFiltered[8] Saves the results of rows after filtering them to the Excel-compatible file.
SaveAsViewed[136] Saves the spreadsheet as viewed to the Excel-compatible file.
SaveBothCustomRowAndColumnHeaders[6] Saves both the custom row headers and the custom column headers to the Excel-compatible file.
SaveCustomColumnHeaders[4] Saves the custom column headers to the Excel-compatible file.
SaveCustomRowHeaders[2] Saves the custom row headers to the Excel-compatible file.
UseCustomPaletteForColorApproximations[256] Uses a custom color palette, and uses it for color approximations if there are more than 56 colors set into Spread.
UseDefaultColorPalette[512] Uses the default color palette.
UseOOXMLFormat[16] Saves the spreadsheet to an Excel 2007 (OfficeOpen XML) format.

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Excel.ExcelSaveFlags

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.