OdsLoadOptions Class

Namespace:
GemBox.Spreadsheet
Assembly:
GemBox.Spreadsheet.dll

Represents options for loading from OpenDocument Spreadsheet file format.

public sealed class OdsLoadOptions : LoadOptions
Public NotInheritable Class OdsLoadOptions
    Inherits LoadOptions
Inheritance:
System.Object
OdsLoadOptions

Constructors

OdsLoadOptions()

Initializes a new instance of the OdsLoadOptions class.

public OdsLoadOptions()
Public Sub New

Properties

PreserveUnsupportedFeatures

Gets or sets a value indicating whether to preserve ODS file format features that are not directly supported through GemBox.Spreadsheet object model.

public bool PreserveUnsupportedFeatures { get; set; }
Public Property PreserveUnsupportedFeatures As Boolean
Property Value
System.Boolean

true to preserve ODS file format features that are not directly supported through GemBox.Spreadsheet object model; otherwise, false.

Remarks

Default value is set to true.

ReadDisplayValues

Read display values instead of stored values.

public bool ReadDisplayValues { get; set; }
Public Property ReadDisplayValues As Boolean
Property Value
System.Boolean

true to read display values; otherwise, false.

Remarks

Values in ODS are stored as value - display string pairs. Normally stored value is read but that looses number formatting. If you want to read value as formatted display string (for example, date as "Wednesday, May 5th, 2009" string), set this property to true.

Default value is set to false.

Inherited Properties

CsvDefault

Gets the default options for loading from Character Separated Values file format.

(Inherited from LoadOptions)

HtmlDefault

Gets the default options for loading from HyperText Markup Language File (HTML) format.

(Inherited from LoadOptions)

OdsDefault

Gets the default options for loading from OpenDocument Spreadsheet file format.

(Inherited from LoadOptions)

TxtDefault

Gets the default options for loading from Tab delimited file format.

(Inherited from LoadOptions)

XlsDefault

Gets the default options for loading from XLS file format (Microsoft Excel Spreadsheet format; Excel 2003 and prior versions) .

(Inherited from LoadOptions)

XlsbDefault

Gets the default options for loading from XLSX file format (Microsoft Excel Binary File Format).

(Inherited from LoadOptions)

XlsxDefault

Gets the default options for loading from XLSX file format (Microsoft Excel Open XML Spreadsheet; Excel 2007 and later).

(Inherited from LoadOptions)

XmlDefault

Gets the default options for loading from XML file format (XML Spreadsheet 2003).

(Inherited from LoadOptions)

Examples