Class WorkbookProperties

Represents workbook-level properties and settings.

Inheritance

object

WorkbookProperties

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: DRIT.Spreadsheet

Assembly: DRIT.Spreadsheet.dll

Syntax

public class WorkbookProperties

Remarks

WorkbookProperties controls various workbook behaviors including date/time handling, picture compression, and compatibility settings.

Constructors

WorkbookProperties()

Initializes a new WorkbookProperties for the supplied workbook data.

Declaration

public WorkbookProperties()

Remarks

WorkbookProperties controls various workbook behaviors including date/time handling, picture compression, and compatibility settings.

Properties

AllowRefreshQuery

Gets or sets whether to allow refreshing of query tables.

Declaration

public bool AllowRefreshQuery { get; set; }

Property Value

Type	Description
bool

Remarks

WorkbookProperties controls various workbook behaviors including date/time handling, picture compression, and compatibility settings.

AutoCompressPictures

Gets or sets whether to automatically compress pictures.

Declaration

public bool AutoCompressPictures { get; set; }

Property Value

Type	Description
bool

Remarks

WorkbookProperties controls various workbook behaviors including date/time handling, picture compression, and compatibility settings.

BackupFile

Gets or sets whether to create a backup file when saving.

Declaration

public bool BackupFile { get; set; }

Property Value

Type	Description
bool

Remarks

WorkbookProperties controls various workbook behaviors including date/time handling, picture compression, and compatibility settings.

CheckCompatibility

Gets or sets whether to check compatibility when saving.

Declaration

public bool CheckCompatibility { get; set; }

Property Value

Type	Description
bool

Remarks

WorkbookProperties controls various workbook behaviors including date/time handling, picture compression, and compatibility settings.

CodeName

Specifies the code name for VBA automation.

Declaration

public string CodeName { get; set; }

Property Value

Type	Description
string

Remarks

WorkbookProperties controls various workbook behaviors including date/time handling, picture compression, and compatibility settings.

DateCompatibility

Gets or sets whether to use date compatibility mode.

Declaration

public bool DateCompatibility { get; set; }

Property Value

Type	Description
bool

Remarks

WorkbookProperties controls various workbook behaviors including date/time handling, picture compression, and compatibility settings.

DateTimeOrigin

Specifies the date/time origin for serial date calculations.

Declaration

public DateTimeOrigin DateTimeOrigin { get; set; }

Property Value

Type	Description
DateTimeOrigin

Remarks

WorkbookProperties controls various workbook behaviors including date/time handling, picture compression, and compatibility settings.

DefaultThemeVersion

Specifies the default theme version for the workbook.

Declaration

public int? DefaultThemeVersion { get; set; }

Property Value

Type	Description
int?

Remarks

WorkbookProperties controls various workbook behaviors including date/time handling, picture compression, and compatibility settings.

FilterPrivacy

Gets or sets whether to filter privacy-related information.

Declaration

public bool FilterPrivacy { get; set; }

Property Value

Type	Description
bool

Remarks

WorkbookProperties controls various workbook behaviors including date/time handling, picture compression, and compatibility settings.

HidePivotFieldList

Gets or sets whether to hide the pivot field list.

Declaration

public bool HidePivotFieldList { get; set; }

Property Value

Type	Description
bool

Remarks

WorkbookProperties controls various workbook behaviors including date/time handling, picture compression, and compatibility settings.

IsDateTimeOrigin1904

Gets or sets whether the date/time origin is 1904 (Mac) instead of 1900 (Windows).

Declaration

public bool IsDateTimeOrigin1904 { get; set; }

Property Value

Type	Description
bool

Remarks

WorkbookProperties controls various workbook behaviors including date/time handling, picture compression, and compatibility settings.

PromptedSolutions

Gets or sets whether to prompt for solutions.

Declaration

public bool PromptedSolutions { get; set; }

Property Value

Type	Description
bool

Remarks

WorkbookProperties controls various workbook behaviors including date/time handling, picture compression, and compatibility settings.

PublishItems

Gets or sets whether to publish items for web publishing.

Declaration

public bool PublishItems { get; set; }

Property Value

Type	Description
bool

Remarks

WorkbookProperties controls various workbook behaviors including date/time handling, picture compression, and compatibility settings.

RefreshAllConnections

Gets or sets whether to refresh all connections on open.

Declaration

public bool RefreshAllConnections { get; set; }

Property Value

Type	Description
bool

Remarks

WorkbookProperties controls various workbook behaviors including date/time handling, picture compression, and compatibility settings.

SaveExternalLinkValues

Gets or sets whether to save external link values.

Declaration

public bool SaveExternalLinkValues { get; set; }

Property Value

Type	Description
bool

Remarks

WorkbookProperties controls various workbook behaviors including date/time handling, picture compression, and compatibility settings.

ShowBorderUnselectedTables

Gets or sets whether to show borders for unselected tables.

Declaration

public bool ShowBorderUnselectedTables { get; set; }

Property Value

Type	Description
bool

Remarks

WorkbookProperties controls various workbook behaviors including date/time handling, picture compression, and compatibility settings.

ShowInkAnnotation

Gets or sets whether to show ink annotations.

Declaration

public bool ShowInkAnnotation { get; set; }

Property Value

Type	Description
bool

Remarks

WorkbookProperties controls various workbook behaviors including date/time handling, picture compression, and compatibility settings.

ShowObjects

Specifies the display type for embedded objects.

Declaration

public ObjectDisplayType ShowObjects { get; set; }

Property Value

Type	Description
ObjectDisplayType

Remarks

WorkbookProperties controls various workbook behaviors including date/time handling, picture compression, and compatibility settings.

ShowPivotChartFilter

Gets or sets whether to show pivot chart filter.

Declaration

public bool ShowPivotChartFilter { get; set; }

Property Value

Type	Description
bool

Remarks

WorkbookProperties controls various workbook behaviors including date/time handling, picture compression, and compatibility settings.

UpdateLinks

Gets or sets how external links should be updated.

Declaration

public UpdateLinks UpdateLinks { get; set; }

Property Value

Type	Description
UpdateLinks

Remarks

WorkbookProperties controls various workbook behaviors including date/time handling, picture compression, and compatibility settings.