DevExpress.Spreadsheet Namespace
Contains classes and interfaces that implement basic spreadsheet functionality.
Assemblies: DevExpress.Docs.v24.2.dll, DevExpress.Spreadsheet.v24.2.Core.dll
NuGet Packages: DevExpress.Document.Processor, DevExpress.Spreadsheet.Core
#Classes
Name | Description |
---|---|
Active |
Provides data for the Spreadsheet |
Active |
Base class for classes that provides data for the Active |
Active |
Provides data for the Spreadsheet |
Before |
Provides data for the Spreadsheet |
Cell |
Contains extension methods for the Cell |
Cell |
A data value contained in a cell. |
Chart |
Defines extension methods for the Chart You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use these methods in production code. |
Clipboard |
Provides data for the Spreadsheet |
Clipboard |
Provides data for the Spreadsheet |
Columns |
Provides data for the Spreadsheet |
Columns |
Provides data for the Spreadsheet |
Column |
Provides data for the Spreadsheet |
Comment |
Provides data for the Spreadsheet |
Comment |
Provides data for the Spreadsheet |
Comment |
Provides data for the Spreadsheet |
Copied |
Provides data for the Spreadsheet |
Copied |
Provides data for the Spreadsheet |
Data |
Provides data for the Worksheet |
Data |
Contains properties which allow you to specify whether the imported data are treated as formulas, the cell reference style in use, the culture-specific decimal and list separators and a custom value converter. |
Data |
Allows you to specify data source fields to import. |
Data |
Serves as the base for the External |
Date |
A criterion for date values. |
Defined |
Provides data for the Defined |
Document |
Provides access to workbook options. |
Edit |
Contains security information required for applying user-level security to a Protected |
Encrypted |
Provides data for the Encrypted |
Encrypted |
Provides data for the Encrypted |
Encrypted |
Provides data for the Encrypted |
Encryption |
Base implementation of the Encryption |
External |
Contains options for data retrieval from an external data source when establishing a data binding. |
Fill |
Specifies a fill field to sort by and the comparer used for sorting. |
Filter |
A value or values used in a filter criterion. |
Font |
Specifies a font color field to sort by and the font color used for sorting. |
Header |
Contains format codes used in headers and footers. |
Panes |
Provides data for the Spreadsheet |
Panes |
Provides data for the Spreadsheet |
Pivot |
Contains data used to specify starting and ending values for the range grouping. |
Pivot |
Represents a reference to a specific item in a pivot table. |
Range |
Provides data for the Spreadsheet |
Range |
Provides data for the Spreadsheet |
Range |
Contains various options for a data source created from a cell range. |
Range |
Defines extension methods for the Cell |
Range |
Contains options used to export a cell range to an image. |
Rich |
Contains font attributes for a rich text run. |
Rich |
Rich formatted text in a cell. |
Row |
Provides data for the Spreadsheet |
Rows |
Provides data for the Spreadsheet |
Rows |
Provides data for the Spreadsheet |
Rows |
Serves as the base for classes which provide data for the events which occur on inserting or removing rows and columns via the Spreadsheet |
Scroll |
Provides data for the Spreadsheet |
Search |
Contains options affecting search in a document. |
Shape |
Provides data for the Spreadsheet |
Shape |
Provides data for the Spreadsheet |
Shapes |
Provides data for the Spreadsheet |
Sheet |
Provides data for the Spreadsheet |
Sheet |
Provides data for the Spreadsheet |
Sheet |
Provides data for the Spreadsheet |
Sheet |
Provides data for the Spreadsheet |
Sheet |
Provides data for the Spreadsheet |
Sheet |
Contains options used to generate a thumbnail from a worksheet or chart sheet. |
Sort |
Combines the column index and the specification of the direction in which column values should be sorted. |
Sort |
Specifies the field by which to sort, and the comparer used for sorting. |
Sort |
Base class for sort fields. |
Spreadsheet |
Provides data for the ISpreadsheet |
Spreadsheet |
Provides data for the ISpreadsheet |
Spreadsheet |
Provides data for the Spreadsheet |
Spreadsheet |
An object that provides an image for the spreadsheet. |
Spreadsheet |
Provides data for the ISpreadsheet |
Spreadsheet |
Provides data for the Spreadsheet |
Theme |
Specifies document theme colors. |
Value |
An object that can be used to specify a value associated with a custom cell in-place editor or to create a criterion for data validation. |
Workbook | A non-visual component that allows you to generate and modify spreadsheet documents. |
Workbook |
Defines extension methods for objects exposing the IWorkbook interface. |
Workbook |
Obsolete. Provides options used to specify how to merge multiple workbooks into a single document. |
Workbook |
Contains workbook options. |
Worksheet |
Allows you to define copy options when you copy data from one worksheet to another. |
Worksheet |
Defines extension methods for the Worksheet interface. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use these methods in production code. |
Worksheet |
Contains options used to generate a thumbnail from a worksheet. |
#Interfaces
Name | Description |
---|---|
Alignment | Provides access to the cell content alignment settings. |
Areas |
A collection of worksheet Cell |
Array |
Contains a legacy array formula and the range to which the formula is applied. |
Array |
A collection of Array |
Arrow |
Contains arrowhead settings for a connector. |
Auto |
Base interface for objects which implement filtering functionality in a worksheet and tables. |
Auto |
Provides filtering functionality for a column. |
Auto |
A collection of Auto |
Average |
Represents the "above or below average" conditional formatting rule. |
Border | Provides access to the line characteristics of a cell border. |
Borders | Provides access to cell borders. |
Button |
A button form control. |
Calculation |
Contains options used for calculation of formulas contained in the worksheet cells. |
Cell | A single cell in a worksheet. |
Cell |
A collection of all cells in a worksheet. |
Cell |
Defines a range of cells and serves as the base for the Cell, Cell |
Chart |
A separate sheet in a workbook that contains only a chart. |
Chart |
A collection of Chart |
Chart |
Contains options used for printing a chart sheet. |
Chart |
Contains display and print settings for a chart sheet. |
Check |
A check box form control. |
Color |
Represents a two-color scale conditional formatting rule. |
Color |
Represents a three-color scale conditional formatting rule. |
Column | A single column in a worksheet. |
Column |
A collection of all columns in a worksheet. |
Combo |
A combo box form control. |
Comment | A simple note (legacy comment) added to a cell. |
Comment |
A collection of simple notes (legacy comments) contained in a worksheet. |
Comment |
A note text region with its own set of font characteristics. |
Comment |
A collection of note text regions, each formatted with its own font. |
Conditional |
A conditional format applied to a range of cells. |
Conditional |
A collection of all conditional formatting rules on a worksheet. |
Conditional |
Obsolete. Represents a minimum or maximum threshold for a conditional formatting rule. |
Conditional |
Obsolete. Represents a threshold value for an icon set conditional formatting rule. |
Conditional |
Represents a threshold value for an icon set conditional formatting rule. |
Conditional |
Obsolete. Represents a threshold value for a conditional formatting rule. |
Conditional |
Represents a minimum or maximum threshold for a conditional formatting rule. |
Connector |
Contains connector settings. |
Custom |
Represents a custom cell in-place editor assigned to a cell or cell range in a worksheet. |
Custom |
Represents a collection of the custom cell in-place editors assigned to worksheet cells. |
Custom |
Contains the settings of a custom filter. |
Custom |
A collection of custom XML parts in a workbook. |
Data |
Represents a data bar conditional formatting rule. |
Data |
Exposes members for form controls used to select data: list box and combo box. |
Data |
Provides access to a data validation rule defined for a worksheet range. |
Data |
A collection of Data |
Defined |
A defined name that refers to a cell, range of cells, formula or constant value. |
Defined |
A collection of defined names stored in a worksheet or workbook. |
Document |
Contains custom document properties associated with a workbook. |
Document |
Contains basic document properties associated with a workbook. |
Document |
Contains workbook options related to formula calculation. |
Dynamic |
Contains a dynamic array formula and the range to which the formula is applied. |
Dynamic |
A collection of dynamic array formulas. |
Encryption |
Contains the workbook encryption options. |
Error |
Contains information about an error that occurred in a cell. |
Expression |
Represents a conditional formatting rule that uses a relational operator to determine which cells to format. |
External |
A defined name that is contained in the external workbook or in the external worksheet. |
External |
An external workbook. |
External |
A collection of external workbooks. |
External |
A worksheet contained in an external workbook. |
Fill | Contains the cell background attributes. |
Filter |
Provides information on multiple values and groups of dates by which to filter. |
Floating |
A base interface for floating objects in a worksheet (pictures, charts and comments). |
Formatting | Provides access to cell format characteristics. |
Form |
Exposes basic members for all form control types. |
Form |
A collection of form controls. |
Formula |
Represents a conditional formatting rule that uses a formula as a formatting criteria. |
Gradient |
Contains characteristics required to create a gradient fill. |
Gradient |
A color stop that constitutes a gradient fill. |
Gradient |
A collection of color stops which constitutes a linear gradient. |
Group |
Group box form control. |
Header |
A picture embedded in a worksheet header or footer. |
Hyperlink | A hyperlink contained in a cell or cell range. |
Hyperlink |
Serves as the base for the Hyperlink and Shape |
Hyperlink |
A collection of hyperlinks contained in worksheet cells. |
IBinding |
An interface that allows you to convert cell values to custom objects and back. |
ICell |
A converter that converts custom objects to cell values and vice versa. |
IClipboard |
Allows you to write data to the system clipboard. |
Icon |
Represents an icon set conditional formatting rule. |
ICustom |
A custom XML part embedded in a workbook. |
IData |
Provides the capability to identify the name and type of each column in a data source created from a cell range. |
IData |
An interface that allows you to modify data being imported before insertion in a worksheet. |
Ignored |
Specifies a worksheet range and a type of the formula error which will be ignored in that range. |
Ignored |
A collection of Ignored |
Image |
Exposes members used to specify information about an image placed in a cell. |
IRange |
Provides properties and methods to get cell ranges. |
ISpreadsheet |
Exposes the basic functionality to manage workbooks. |
ISupports |
Contains format characteristics that are applied to cells when the condition of the conditional formatting rule is true. |
IUsed |
A set of table and defined names existing in the destination document into which a formula or worksheet containing a conflict name is pasted. |
IWorkbook |
A workbook loaded into the Spreadsheet control (for Win |
IWorkbook |
Obsolete. Contains a result of merging multiple workbooks. |
Label |
Label form control. |
Linked |
Exposes members for form controls that can be linked to a cell: combo box, list box, checkbox, radio button, scroll bar, and spinner. |
List |
List box form control. |
Margins | Provides access to page margins used when a worksheet is printed. |
Page |
A collection of page breaks in a worksheet. |
Parameter | A single query parameter. |
Parameters |
A collection of parameters for queries used in Mail Merge. |
Picture | An image embedded in a worksheet. |
Picture |
A collection of Picture objects. |
Pivot |
Contains options that allow you to restrict specific operations in the Pivot |
Pivot |
Represents the data cache for a Pivot |
Pivot |
Represents the collection of data caches from the Pivot |
Pivot |
A collection of calculated fields in a Pivot |
Pivot |
Represents a collection of calculated items in a Pivot |
Pivot |
Represents a reference to a Pivot |
Pivot |
Represents a collection of fields located in the data area of a Pivot |
Pivot |
Represents a field in a Pivot |
Pivot |
Contains options that allow you to restrict an end-user’s ability to move or remove a Pivot |
Pivot |
Represents the collection of all fields in a Pivot |
Pivot |
Provides access to range grouping characteristics. |
Pivot |
Contains layout settings for a Pivot |
Pivot |
Represents a reference to a Pivot |
Pivot |
Represents a base interface for the Pivot |
Pivot |
Represents the collection of row or column fields in the Pivot |
Pivot |
Contains sort options for a Pivot |
Pivot |
Represents a filter applied to a Pivot |
Pivot |
A collection of filters applied to the Pivot |
Pivot |
Represents an item in a Pivot |
Pivot |
Represents a collection of Pivot |
Pivot |
Contains various options used to adjust the layout of the Pivot |
Pivot |
Contains information about the location of a pivot table and its areas. |
Pivot |
Represents a reference to a Pivot |
Pivot |
Represents a collection of fields located in the report filter area of a pivot table. |
Pivot |
Represents a Pivot |
Pivot |
A collection of all Pivot |
Pivot |
Contains display settings for a pivot table. |
Protected |
An association of a worksheet range and credentials required to unlock it for editing. |
Protected |
A collection of items which associate worksheet ranges and security information required to unlock them for editing. |
Protection | Contains various options in effect when the worksheet is protected. |
Radio |
Radio button form control. |
Range |
Represents a conditional formatting rule that formats cells which are between or not between two values. |
Range |
The base interface for form controls that use a value range: spinner and scroll bar. |
Rank |
Represents a "top/bottom N" conditional formatting rule. |
Read |
Stores custom document properties associated with a workbook. |
Read |
Stores document properties retrieved from a workbook by the Workbook. |
Real |
Defines a real-time data object for use with the Real Time Data (RTD) function. |
Replied |
A comment reply. |
Replied |
A collection of comment replies. |
Rich |
A range of characters within a cell’s rich text. |
Rich |
A region of the cell text with its own set of font characteristics. |
Row | A row in a worksheet. |
Row |
A collection of all rows in a worksheet. |
Scrollbar |
Scrollbar form control. |
Shaded |
Exposes members for shaded form controls: spinner, scrollbar, radio button, list box, group box, combo box, and checkbox. |
Shape | A common interface for drawing objects in a worksheet. |
Shape |
A collection of drawing objects (shapes, pictures, and charts). |
Shape |
Contains properties used to format drawing objects (shapes, pictures, and charts). |
Shape |
Contains the shape geometry information. |
Shape |
A hyperlink associated with a drawing object. |
Shape |
Provides access to a shape’s text format settings. |
Shape |
Contains paragraph settings for a shape text range. |
Shape |
Represents a text range within a shape. |
Sheet |
An individual sheet in a workbook and a base interface for Worksheet and Chart |
Sheet |
An object implementing the filtering functionality for the specified worksheet. |
Sheet |
A collection of all sheets (worksheets and chart sheets) contained in a workbook. |
Sheet |
Contains display and print settings for a sheet. |
Sort |
Contains sort conditions and allows you to perform sorting. |
Sparkline | Represents a single sparkline in the sparkline group. |
Sparkline |
A collection that stores the Sparkline objects for the specified sparkline group. |
Sparkline |
Contains display options for the horizontal axis and data markers of a sparkline group. |
Sparkline |
Represents a sparkline group on a worksheet. |
Sparkline |
A collection of the Sparkline |
Sparkline |
Contains settings for the horizontal axis of a sparkline group. |
Sparkline |
Contains marker options for data points on the sparklines in a sparkline group. |
Sparkline |
Contains scaling options for the vertical axis of a sparkline group. |
Special |
Represents a conditional formatting rule that formats cells with specific values. |
Spinner |
Spinner form control. |
Spreadsheet |
Contains the cell font attributes. |
Spreadsheet |
Contains font attributes for a range of characters within the cell text. |
Spreadsheet |
A history of operations performed in a workbook. |
Spreadsheet |
Contains the mail merge options. |
Style | A named cell style. |
Style |
A collection of cell styles in the workbook. |
Style |
A style flag that controls formatting options to be applied. |
Table | A table in a worksheet. |
Table |
An object implementing the filtering functionality for the specified table. |
Table |
A collection of tables contained in a worksheet. |
Table |
A single column in a table. |
Table |
A collection of columns in a table. |
Table |
A named table or pivot table style. |
Table |
A collection of table and Pivot |
Table |
A table style element. |
Table |
A collection of table style elements. |
Text |
Represents a conditional formatting rule that formats cells that contain or do not contain the given text. |
Text |
Exposes members for form controls that contain text: button, check box, group box, label, and radio button. |
Threaded |
A threaded comment. |
Threaded |
Contains information about the author of the comment. |
Threaded |
A collection of threaded comments. |
Time |
Represents a "date occurring…" conditional formatting rule. |
Workbook |
A color palette for a workbook. |
Workbook |
A document theme. |
Worksheet | A worksheet in a workbook. |
Worksheet |
A collection of worksheets in a workbook. |
Worksheet |
Contains information about a cell range bound to an external data source or used to create a data source. |
Worksheet |
A collection of data bindings specified in a worksheet. |
Worksheet |
A worksheet header or footer. |
Worksheet |
Allows you to specify headers and footers for a worksheet or chart sheet. |
Worksheet |
Contains options used to specify the summary rows and columns location. |
Worksheet |
Contains options that affect page numbering when printing worksheets in a workbook. |
Worksheet |
Contains options used for printing a worksheet. |
Worksheet |
Represents the object that specifies rows and columns to be repeated on every printed page. |
Worksheet |
Contains information about a Table bound to an external data source or used to create a data source. |
Worksheet |
Contains display and print settings for a worksheet. |
Write |
Contains write-protection options for a workbook. |
#Structs
Name | Description |
---|---|
Cell |
A cell’s unique identifier within a workbook. |
Conditional |
Provides access to the particular icon in the icon set. |
Document |
A document format. |
#Delegates
Name | Description |
---|---|
Active |
A method that will handle the Spreadsheet |
Active |
A method that will handle the Spreadsheet |
Before |
A method that will handle the ISpreadsheet |
Before |
A method that will handle the ISpreadsheet |
Before |
A method that will handle the Before |
Clipboard |
A method that will handle the ISpreadsheet |
Clipboard |
A method that will handle the Spreadsheet |
Clipboard |
A method that will handle the ISpreadsheet |
Columns |
A method that will handle the Spreadsheet |
Columns |
A method that will handle the Spreadsheet |
Column |
A method that handles the Spreadsheet |
Comment |
A method that will handle the Spreadsheet |
Comment |
A method that will handle the Spreadsheet |
Comment |
A method that will handle the Spreadsheet |
Copied |
A method that will handle the ISpreadsheet |
Copied |
A method that will handle the ISpreadsheet |
Data |
A method that will handle the Worksheet |
Defined |
A method that will handle the Defined |
Encrypted |
A method that will handle the Encrypted |
Encrypted |
Represents a method that will handle the Encrypted |
Encrypted |
A method that will handle the Encrypted |
Invalid |
A method that will handle the Invalid |
Panes |
A method that will handle the Spreadsheet |
Panes |
A method that will handle the Spreadsheet |
Range |
A method that will handle the ISpreadsheet |
Range |
A method that will handle the ISpreadsheet |
Row |
A method that handles the Spreadsheet |
Rows |
A method that will handle the Rows |
Rows |
A method that will handle the Rows |
Shapes |
A method that will handle the ISpreadsheet |
Sheet |
A method that will handle the Sheet |
Sheet |
A method that will handle the Sheet |
Sheet |
A method that will handle the Sheet |
Sheet |
A method that will handle the Sheet |
Sheet |
A method that will handle the Sheet |
Spreadsheet |
A method that will handle the Spreadsheet |
Spreadsheet |
A method that will handle the Spreadsheet |
#Enums
Name | Description |
---|---|
Arrowhead |
Lists values used to specify an arrowhead’s width and length. |
Arrowhead |
Lists values that specify the type of a connector’s arrowhead. |
Border |
Lists line styles for cell borders. |
Built |
Lists built-in cell styles. |
Built |
Lists built-in styles similar to Excel’s built-in table styles. |
Calculation |
Lists types of computational models used for spreadsheet calculations. |
Calculation |
Lists modes that specify when to calculate formulas in the document. |
Cell |
Lists the data types of cell values. |
Chart |
Lists values used to specify chart sheet elements to which protection is applied. |
Column |
Lists values that specify how to format inserted columns. |
Comments |
Lists the values to specify how cell comments are printed. |
Conditional |
Lists values that specify the type of the conditional format operator in an "above or below average" conditional formatting rule. |
Conditional |
Lists values that specify the axis position between negative and positive bars when the data bar conditional format is applied. |
Conditional |
Lists values that specify the direction of data bars when the data bar conditional format is applied. |
Conditional |
Lists values that specify the type of the relational operator in a conditional formatting rule. |
Conditional |
Lists values that specify the type of the conditional format operator in a conditional formatting rule. |
Conditional |
Lists values that specify the type of the conditional format operator in a "top/bottom N" conditional formatting rule. |
Conditional |
Lists values that specify the type of the conditional format operator in a conditional formatting rule. |
Conditional |
Lists values that specify the type of the conditional format operator in a conditional formatting rule. |
Conditional |
Lists applicable time periods in a "date occurring…" conditional formatting rule. |
Conditional |
Lists values that specify the relational operator type for the icon set conditional format. |
Conditional |
Lists values that specify the type of the threshold value to be used in conditional formatting rules. |
Connector |
Lists connector types. |
Custom |
Lists types of the custom in-place editors that can be assigned to cells in a worksheet. |
Data |
Indicates whose value is being updated during binding. |
Data |
Lists possible error causes relevant to cell range data binding. |
Data |
Lists the editing options which can be applied to the data source originated from cell range. |
Data |
Lists the styles of data validation error alert. |
Data |
Lists values that specify how the IME (input method editor) mode is controlled by data validation. |
Data |
Lists comparison operators used in criteria for certain validation types. |
Data |
Lists data validation types. |
Date |
Lists grouping types used to specify filter criteria for Date |
Defined |
Lists values used to specify the defined name scope. |
Delete |
Specifies how to delete cells from a worksheet. |
Diagonal |
Lists the types of cell diagonal borders. |
Document |
Lists the security levels of the document. |
Dynamic |
Lists the types of dynamic filter, i. |
Encryption |
Lists available encryption types for a workbook. |
Errors |
Lists the values to specify how cell errors are printed. |
Error |
Lists errors that can occur in cells. |
Fill |
Lists fill types. |
Filter |
Lists comparison operators used in a custom filter. |
Filter |
Lists types of filters available for the Auto |
Font |
Lists values used to specify the font scheme. |
Form |
Indicates available states for the checkbox form control. |
Form |
Indicates the scrollbar form control orientation. |
Form |
Lists values that indicate selection modes available for the list box form control. |
Form |
Indicates the form control type. |
Formula |
Specifies how to replace copied formulas if they contain references to worksheets that do not exist in the destination workbook. |
Gradient |
Lists the types of gradient fill. |
Header |
Lists document header and footer sections. |
Icon |
Lists values that specify the icon set type for an icon set conditional format. |
Ignored |
Lists types of errors that can occur in cell formulas. Use the Worksheet. |
Image |
Lists image formats you can use to save a cell range as an image. |
Image |
Specifies how to insert a new image when you replace an existing worksheet image with a different image. |
Insert |
Specifies how to insert new cells into a worksheet. |
Merge |
Lists available modes to merge cells. |
Page |
Contains the values to specify the order in which worksheet pages are numbered and printed when the worksheet data does not fit onto one page. |
Page |
Lists values used to specify the page orientation applied when a worksheet is being printed. |
Paste |
Specifies the part of data to paste from copied cells into target cells. |
Pattern |
Lists patterns to apply to a cell. |
Pivot |
Lists values used to specify areas in the Pivot |
Pivot |
Lists types of base items that can be used by the “Show Values As” calculation options. |
Pivot |
Lists values that specify the cache type of the Pivot |
Pivot |
Lists aggregation functions to apply to data fields in a Pivot |
Pivot |
Lists values that specify how items of a row or column field are grouped. |
Pivot |
Lists values that specify the sort order for a Pivot |
Pivot |
Lists values used to specify what items should be included in the “Top 10” filtering results. |
Pivot |
Lists values that specify the type of filter to be applied to a Pivot |
Pivot |
Lists values used to specify the orientation of multiple page fields in the Pivot |
Pivot |
Lists values used to specify the type of the Pivot |
Pivot |
Lists options that specify how summary values are displayed within a data field. |
Pivot |
Lists functions used to calculate subtotals for the Pivot |
Pivot |
Lists values that specify how subtotals are calculated for a Pivot |
Placement | Lists the ways the object is attached to the cells below it. |
Reference |
Contains values to specify the type of a cell reference to be obtained. |
Reference |
Specifies the cell reference style. |
Row |
Lists values that specify how to format inserted rows. |
Script |
Contains the values used to make the text in a cell superscript or subscript. |
Search |
Lists values that specify the direction of the search. |
Search |
Lists values that specify what to examine in each cell while searching. |
Shape |
Lists values that specify the shape geometry type. |
Shape |
Lists values used to specify the auto-size mode for shape text. |
Shape |
Lists values used to specify the shape text’s horizontal alignment. |
Shape |
Lists values used to specify how to display text that overflows the shape horizontally. |
Shape |
Lists values used to specify the type of a shape text’s orientation. |
Shape |
Lists values used to specify the paragraph alignment for a shape text range. |
Shape |
Lists values used to specify the reading order of a shape’s text. |
Shape |
Lists values used to specify the shape text’s vertical alignment. |
Shape |
Lists values used to specify how to display text that overflows the shape vertically. |
Shape |
Lists warp types for shape text. |
Shape |
Lists types of graphical objects a worksheet can contain. |
Sheet |
Lists values used to specify the sheet type. |
Sort |
Lists values used to indicate the sort type. |
Sparkline |
Lists values used to specify how to calculate the minimum and maximum values for the vertical axis of a sparkline group. |
Sparkline |
Lists sparkline group types. |
Spreadsheet |
Lists the cell font styles. |
Spreadsheet |
Specifies horizontal alignment of cell content. |
Spreadsheet |
Lists the values used to specify vertical alignment of data within a cell. |
Table |
Lists table and pivot table style elements. |
Theme |
Lists predefined document themes for a workbook. |
Top10Type | Lists criteria types used in the top ten filter. |
Total |
Lists functions to calculate the totals of table columns. |
Underline |
Lists underline styles. |
Update |
Specifies how to update external links to other workbooks when a document is opened. |
Workbook |
Lists values used to specify when data should be recalculated in a non-visual Workbook or the Spreadsheet control. |
Worksheet |
Lists possible options for the starting number used in pagination when printing worksheets in a workbook. |
Worksheet |
Lists end-user actions allowed for the protected worksheet. |
Worksheet |
Lists view types that can be used to display worksheets. |
Worksheet |
Contains the values that specify worksheet visibility. |
Worksheet |
Lists values used to specify a zoom mode for a worksheet. |