A class encapsulating the default options (font, row height, column width) for a newly created workbook.
Inheritance Hierarchy
Winnovative.ExcelLibExcelWorkbookDefaultSettings
Namespace: Winnovative.ExcelLib
Assembly: wnvxls (in wnvxls.dll) Version: 10.0.0.0 (10.0.0.0)
Syntax
The ExcelWorkbookDefaultSettings type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
 | ExcelWorkbookDefaultSettings | Initializes a new instance of the ExcelWorkbookDefaultSettings class |
Properties
| Name | Description | |
|---|---|---|
 | AutoTrustLevel |
Gets or sets a flag indication if the library should automatically determine the trust level in an ASP.NET
environment in order to offer the best performance. Default value is true. When this property is false
the trust level is given by the FullTrustAllowed property.
|
| DefaultColumnWidthChars |
Gets or sets default column width in characters for the newly created worksheets.
|
| DefaultFontName |
Gets or sets default font name for the newly created worksheets.
|
| DefaultFontSize |
Gets or sets default font size in points for the newly created worksheets.
|
| DefaultRowHeightPoints |
Gets or sets default row height in points for the newly created worksheets.
|
| FormulaNumberFormat |
Gets or sets the number format in formula used when parsing formulas. Set this propery before assigning
a formula expression to a cell. The default value is the number format for the current culture.
|
| FormulaParamsSeparator |
Gets or sets the separator between formula parameters used when parsing formulas. Set this propery before assigning
a formula expression to a cell. The defaulr value is ','.
|
| FormulaRowsSeparator |
Gets or sets the rows separator used when parsing arrays in formulas. Set this propery before assigning
a formula expression to a cell. The default value is ';'
|
| FullTrustAllowed |
Gets or sets a global flag indicating if the ASP.NET Full Trust level can be granted to the library at runtime.
This property has effect only if AutoTrustLevel is false.
The default value is true and therefore the library assumes it can run in full trust mode. In full trust mode
the library can run some speed optimizations to deliver the best performance.
Full Trust level is the default level assigned by ASP.NET to the web applications.
|
| ParseCSVStrings |
Gets or sets a flag indicating if the strings from a CSV file are parsed to produce cells containing numbers,
dates or booleans. Default value is true.
|
| SerializeDefaultColumnWidth |
A flag indicating if the DefaultRowHeightPoints property should be serialized or not when the the format is Xls_2007.
|
| SerializeDefaultRowHeight |
A flag indicating if the DefaultRowHeightPoints property should be serialized or not when the the format is Xlsx_2007.
|
Methods
| Name | Description | |
|---|---|---|
| Equals | (Inherited from Object.) |
 | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
See Also