Spread for ASP.NET 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 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

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