<html> <head> <title>Module sheet</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link rel="stylesheet" type="text/css" href="../../../../idl.css"> </head> <body> <div id="adc-idlref"> <a name="_top_"> </a><table class="navimain" border="0" cellpadding="3"> <tr> <td class="navimain"><a href="../module-ix.html" class="navimain">Overview</a></td> <td class="navimainself">Module</td> <td class="navimainnone">Use</td> <td class="navimainnone">Devguide</td> <td class="navimain"><a href="../../../../index-files/index-1.html" class="navimain">Index</a></td> </tr> </table> <table class="navisub" border="0" cellpadding="0"> <tr> <td class="navisub">Nested Modules</td> <td class="navisub"><a href="#Services" class="navisub">Services</a></td> <td class="navisub">Singletons</td> <td class="navisub"><a href="#Interfaces" class="navisub">Interfaces</a></td> <td class="navisub"><a href="#Structs" class="navisub">Structs</a></td> <td class="navisub">Exceptions</td> <td class="navisub"><a href="#Enums" class="navisub">Enums</a></td> <td class="navisub">Typedefs</td> <td class="navisub"><a href="#ConstantGroups" class="navisub">Constant Groups</a></td> </tr> </table> <hr> <table border="0" width="100%" cellpadding="5" cellspacing="3" class="title-table" style="margin-bottom:6pt;"> <tr> <td><p class="namechain"><a href="../../../../module-ix.html" class="namechain">::</a> <a href="../../../module-ix.html" class="namechain">com</a> :: <a href="../../module-ix.html" class="namechain">sun</a> :: <a href="../module-ix.html" class="namechain">star</a> :: </p> </td> </tr> <tr> <td class="title">module sheet</td> </tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>Spreadsheet specific interfaces.</dd> </dl> </td> </tr> </table> <hr> <a name="Services"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Services</td> </tr> <tr> <td class="imsum_left"><a href="AccessibleCell.html">AccessibleCell</a></td> <td class="imsum_right">The accessible view of a spreadsheet document </td> </tr> <tr> <td class="imsum_left"><a href="AccessibleCsvCell.html">AccessibleCsvCell</a></td> <td class="imsum_right">The accessible object of a cell in the CSV import dialog. </td> </tr> <tr> <td class="imsum_left"><a href="AccessibleCsvRuler.html">AccessibleCsvRuler</a></td> <td class="imsum_right">The accessible object of the ruler in the CSV import dialog. </td> </tr> <tr> <td class="imsum_left"><a href="AccessibleCsvTable.html">AccessibleCsvTable</a></td> <td class="imsum_right">The accessible object of the data table in the CSV import dialog. </td> </tr> <tr> <td class="imsum_left"><a href="AccessiblePageHeaderFooterAreasView.html">AccessiblePageHeaderFooterAreasView</a></td> <td class="imsum_right">The accessible view of the Header/Footer in a spreadsheet page preview </td> </tr> <tr> <td class="imsum_left"><a href="AccessibleSpreadsheet.html">AccessibleSpreadsheet</a></td> <td class="imsum_right">The accessible view of a spreadsheet document </td> </tr> <tr> <td class="imsum_left"><a href="AccessibleSpreadsheetDocumentView.html">AccessibleSpreadsheetDocumentView</a></td> <td class="imsum_right">The accessible view of a spreadsheet document </td> </tr> <tr> <td class="imsum_left"><a href="AccessibleSpreadsheetPageView.html">AccessibleSpreadsheetPageView</a></td> <td class="imsum_right">The accessible view of a spreadsheet page preview </td> </tr> <tr> <td class="imsum_left"><a href="AddIn.html">AddIn</a></td> <td class="imsum_right">is the base for AddIn services that supply functions which can be called by other components. </td> </tr> <tr> <td class="imsum_left"><a href="CellAnnotation.html">CellAnnotation</a></td> <td class="imsum_right">represents a cell annotation object attached to a spreadsheet cell. </td> </tr> <tr> <td class="imsum_left"><a href="CellAnnotationShape.html">CellAnnotationShape</a></td> <td class="imsum_right">represents the shape of a cell annotation object attached to a spreadsheet cell. </td> </tr> <tr> <td class="imsum_left"><a href="CellAnnotations.html">CellAnnotations</a></td> <td class="imsum_right">represents a collection of cell annotations. </td> </tr> <tr> <td class="imsum_left"><a href="CellAnnotationsEnumeration.html">CellAnnotationsEnumeration</a></td> <td class="imsum_right">represents an enumeration of cell annotations in a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="CellAreaLink.html">CellAreaLink</a></td> <td class="imsum_right">represents a linked cell range. </td> </tr> <tr> <td class="imsum_left"><a href="CellAreaLinks.html">CellAreaLinks</a></td> <td class="imsum_right">represents a collection of area links. </td> </tr> <tr> <td class="imsum_left"><a href="CellAreaLinksEnumeration.html">CellAreaLinksEnumeration</a></td> <td class="imsum_right">represents an enumeration of cell area links. </td> </tr> <tr> <td class="imsum_left"><a href="CellFormatRanges.html">CellFormatRanges</a></td> <td class="imsum_right">represents a collection of equal-formatted cell ranges. </td> </tr> <tr> <td class="imsum_left"><a href="CellFormatRangesEnumeration.html">CellFormatRangesEnumeration</a></td> <td class="imsum_right">represents an enumeration of equal-formatted cell ranges. </td> </tr> <tr> <td class="imsum_left"><a href="Cells.html">Cells</a></td> <td class="imsum_right">represents a collection of used cells in a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="CellsEnumeration.html">CellsEnumeration</a></td> <td class="imsum_right">represents an enumeration of spreadsheet cells. </td> </tr> <tr> <td class="imsum_left"><a href="ConsolidationDescriptor.html">ConsolidationDescriptor</a></td> <td class="imsum_right">contains all settings of a data consolidation in a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="DDELink.html">DDELink</a></td> <td class="imsum_right">represents a DDE link. </td> </tr> <tr> <td class="imsum_left"><a href="DDELinks.html">DDELinks</a></td> <td class="imsum_right">represents a collection of DDE links. </td> </tr> <tr> <td class="imsum_left"><a href="DDELinksEnumeration.html">DDELinksEnumeration</a></td> <td class="imsum_right">represents an enumeration of DDE links. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotDescriptor.html">DataPilotDescriptor</a></td> <td class="imsum_right">represents the description of the layout of a data pilot table. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotField.html">DataPilotField</a></td> <td class="imsum_right">represents a single field in a data pilot table. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotFieldGroup.html">DataPilotFieldGroup</a></td> <td class="imsum_right">represents a collection of members in a data pilot field group. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotFieldGroupItem.html">DataPilotFieldGroupItem</a></td> <td class="imsum_right">represents the member in a data pilot field group. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotFieldGroups.html">DataPilotFieldGroups</a></td> <td class="imsum_right">represents a collection of groups in a data pilot field. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotFields.html">DataPilotFields</a></td> <td class="imsum_right">represents a collection of fields in a data pilot table. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotFieldsEnumeration.html">DataPilotFieldsEnumeration</a></td> <td class="imsum_right">represents an enumeration of data pilot fields. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotItem.html">DataPilotItem</a></td> <td class="imsum_right">represents a single item in a data pilot field. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotItems.html">DataPilotItems</a></td> <td class="imsum_right">represents a collection of Items in a data pilot field. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotItemsEnumeration.html">DataPilotItemsEnumeration</a></td> <td class="imsum_right">represents an enumeration of data pilot items. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotSource.html">DataPilotSource</a></td> <td class="imsum_right">represents a data pilot source. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotSourceDimension.html">DataPilotSourceDimension</a></td> <td class="imsum_right">represents a dimension in a data pilot source. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotSourceDimensions.html">DataPilotSourceDimensions</a></td> <td class="imsum_right">represents the collection of dimensions in a data pilot source. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotSourceHierarchies.html">DataPilotSourceHierarchies</a></td> <td class="imsum_right">represents the collection of hierarchies in a data pilot source dimension. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotSourceHierarchy.html">DataPilotSourceHierarchy</a></td> <td class="imsum_right">represents a hierarchy in a data pilot source dimension. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotSourceLevel.html">DataPilotSourceLevel</a></td> <td class="imsum_right">represents a level in a data pilot source hierarchy. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotSourceLevels.html">DataPilotSourceLevels</a></td> <td class="imsum_right">represents the collection of levels in a data pilot source hierarchy. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotSourceMember.html">DataPilotSourceMember</a></td> <td class="imsum_right">represents a member in a data pilot source level. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotSourceMembers.html">DataPilotSourceMembers</a></td> <td class="imsum_right">represents the collection of members in a data pilot source level. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotTable.html">DataPilotTable</a></td> <td class="imsum_right">represents a data pilot table on a spreadsheet. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotTables.html">DataPilotTables</a></td> <td class="imsum_right">represents a collection of data pilot tables. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotTablesEnumeration.html">DataPilotTablesEnumeration</a></td> <td class="imsum_right">represents an enumeration of data pilot tables. </td> </tr> <tr> <td class="imsum_left"><a href="DatabaseImportDescriptor.html">DatabaseImportDescriptor</a></td> <td class="imsum_right">represents a description of how data from an external database is imported. </td> </tr> <tr> <td class="imsum_left"><a href="DatabaseRange.html">DatabaseRange</a></td> <td class="imsum_right">represents a database range in a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="DatabaseRanges.html">DatabaseRanges</a></td> <td class="imsum_right">represents a collection of database ranges in a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="DatabaseRangesEnumeration.html">DatabaseRangesEnumeration</a></td> <td class="imsum_right">represents an enumeration of database ranges. </td> </tr> <tr> <td class="imsum_left"><a href="DocumentSettings.html">DocumentSettings</a></td> <td class="imsum_right">describes properties that apply to the whole spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="FormulaOpCodeMapper.html">FormulaOpCodeMapper</a></td> <td class="imsum_right"/></tr> <tr> <td class="imsum_left"><a href="FormulaParser.html">FormulaParser</a></td> <td class="imsum_right"/></tr> <tr> <td class="imsum_left"><a href="FunctionAccess.html">FunctionAccess</a></td> <td class="imsum_right">allows generic access to all spreadsheet functions. </td> </tr> <tr> <td class="imsum_left"><a href="FunctionDescription.html">FunctionDescription</a></td> <td class="imsum_right">collects all properties used to describe a function. </td> </tr> <tr> <td class="imsum_left"><a href="FunctionDescriptionEnumeration.html">FunctionDescriptionEnumeration</a></td> <td class="imsum_right">represents an enumeration of Function Descriptions. </td> </tr> <tr> <td class="imsum_left"><a href="FunctionDescriptions.html">FunctionDescriptions</a></td> <td class="imsum_right">represents a collection of function descriptions for all built-in functions as well as add-in functions available in the spreadsheet application. </td> </tr> <tr> <td class="imsum_left"><a href="GlobalSheetSettings.html">GlobalSheetSettings</a></td> <td class="imsum_right">contributes properties to access the settings for all spreadsheets of a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="HeaderFooterContent.html">HeaderFooterContent</a></td> <td class="imsum_right">represents the contents of a header or footer line in a page style. </td> </tr> <tr> <td class="imsum_left"><a href="LabelRange.html">LabelRange</a></td> <td class="imsum_right">represents a cell area that contains labels and values related to the labels. </td> </tr> <tr> <td class="imsum_left"><a href="LabelRanges.html">LabelRanges</a></td> <td class="imsum_right">represents a collection of label ranges in a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="LabelRangesEnumeration.html">LabelRangesEnumeration</a></td> <td class="imsum_right">represents an enumeration of label ranges. </td> </tr> <tr> <td class="imsum_left"><a href="NamedRange.html">NamedRange</a></td> <td class="imsum_right">represents a named range in a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="NamedRanges.html">NamedRanges</a></td> <td class="imsum_right">represents a collection of named ranges in a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="NamedRangesEnumeration.html">NamedRangesEnumeration</a></td> <td class="imsum_right">represents an enumeration of named ranges. </td> </tr> <tr> <td class="imsum_left"><a href="RangeSelectionArguments.html">RangeSelectionArguments</a></td> <td class="imsum_right">contains the arguments for starting the range selection. </td> </tr> <tr> <td class="imsum_left"><a href="RecentFunctions.html">RecentFunctions</a></td> <td class="imsum_right">contains the list of recently used spreadsheet functions. </td> </tr> <tr> <td class="imsum_left"><a href="Scenario.html">Scenario</a></td> <td class="imsum_right">represents a scenario in a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="Scenarios.html">Scenarios</a></td> <td class="imsum_right">represents a collection of scenarios. </td> </tr> <tr> <td class="imsum_left"><a href="ScenariosEnumeration.html">ScenariosEnumeration</a></td> <td class="imsum_right">represents an enumeration of scenarios. </td> </tr> <tr> <td class="imsum_left"><a href="Shape.html">Shape</a></td> <td class="imsum_right">specifies the service of shapes in a spreadsheet document </td> </tr> <tr> <td class="imsum_left"><a href="SheetCell.html">SheetCell</a></td> <td class="imsum_right">represents a single addressable cell in a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="SheetCellCursor.html">SheetCellCursor</a></td> <td class="imsum_right">represents a cursor in a spreadsheet. </td> </tr> <tr> <td class="imsum_left"><a href="SheetCellRange.html">SheetCellRange</a></td> <td class="imsum_right">represents a rectangular range of cells in a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="SheetCellRanges.html">SheetCellRanges</a></td> <td class="imsum_right">represents a collection of cell ranges in a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="SheetCellRangesEnumeration.html">SheetCellRangesEnumeration</a></td> <td class="imsum_right">represents an enumeration of cell ranges in a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="SheetFilterDescriptor.html">SheetFilterDescriptor</a></td> <td class="imsum_right">represents a description of how a cell range is to be filtered. </td> </tr> <tr> <td class="imsum_left"><a href="SheetLink.html">SheetLink</a></td> <td class="imsum_right">represents a sheet link. </td> </tr> <tr> <td class="imsum_left"><a href="SheetLinks.html">SheetLinks</a></td> <td class="imsum_right">represents a collection of sheet links. </td> </tr> <tr> <td class="imsum_left"><a href="SheetLinksEnumeration.html">SheetLinksEnumeration</a></td> <td class="imsum_right">represents an enumeration of sheet links. </td> </tr> <tr> <td class="imsum_left"><a href="SheetRangesQuery.html">SheetRangesQuery</a></td> <td class="imsum_right">provides interfaces to find cells with specific properties. </td> </tr> <tr> <td class="imsum_left"><a href="SheetSortDescriptor.html">SheetSortDescriptor</a></td> <td class="imsum_right">a description of how a cell range is to be sorted. </td> </tr> <tr> <td class="imsum_left"><a href="SheetSortDescriptor2.html">SheetSortDescriptor2</a></td> <td class="imsum_right">a description of how a cell range is to be sorted. </td> </tr> <tr> <td class="imsum_left"><a href="Spreadsheet.html">Spreadsheet</a></td> <td class="imsum_right">represents a complete spreadsheet in a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="SpreadsheetDocument.html">SpreadsheetDocument</a></td> <td class="imsum_right">represents a model component which consists of some settings and one or more spreadsheets. </td> </tr> <tr> <td class="imsum_left"><a href="SpreadsheetDocumentSettings.html">SpreadsheetDocumentSettings</a></td> <td class="imsum_right">[ DEPRECATED ]<br> contributes properties to control the configuration which is global for all views of a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="SpreadsheetDrawPage.html">SpreadsheetDrawPage</a></td> <td class="imsum_right">This abstract service is implemented by every page of a <a href="SpreadsheetDocument.html">SpreadsheetDocument</a>. </td> </tr> <tr> <td class="imsum_left"><a href="SpreadsheetView.html">SpreadsheetView</a></td> <td class="imsum_right">represents a view of a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="SpreadsheetViewPane.html">SpreadsheetViewPane</a></td> <td class="imsum_right">represents a single pane in a view of a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="SpreadsheetViewPanesEnumeration.html">SpreadsheetViewPanesEnumeration</a></td> <td class="imsum_right">represents an enumeration of spreadsheet view panes. </td> </tr> <tr> <td class="imsum_left"><a href="SpreadsheetViewSettings.html">SpreadsheetViewSettings</a></td> <td class="imsum_right">contains settings which are specific to each view of a spreadsheet </td> </tr> <tr> <td class="imsum_left"><a href="Spreadsheets.html">Spreadsheets</a></td> <td class="imsum_right">represents the collection of spreadsheets in a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="SpreadsheetsEnumeration.html">SpreadsheetsEnumeration</a></td> <td class="imsum_right">represents an enumeration of spreadsheets in a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="SubTotalDescriptor.html">SubTotalDescriptor</a></td> <td class="imsum_right">represents a description of how subtotals are created. </td> </tr> <tr> <td class="imsum_left"><a href="SubTotalField.html">SubTotalField</a></td> <td class="imsum_right">represents a single field in a subtotal descriptor. </td> </tr> <tr> <td class="imsum_left"><a href="SubTotalFieldsEnumeration.html">SubTotalFieldsEnumeration</a></td> <td class="imsum_right">represents an enumeration of sub total fields. </td> </tr> <tr> <td class="imsum_left"><a href="TableAutoFormat.html">TableAutoFormat</a></td> <td class="imsum_right">represents an AutoFormat, containing exactly 16 AutoFormat fields. </td> </tr> <tr> <td class="imsum_left"><a href="TableAutoFormatEnumeration.html">TableAutoFormatEnumeration</a></td> <td class="imsum_right">represents an enumeration of AutoFormat fields in an AutoFormat. </td> </tr> <tr> <td class="imsum_left"><a href="TableAutoFormatField.html">TableAutoFormatField</a></td> <td class="imsum_right">represents a field in an AutoFormat. A field contains all cell properties for a specific position in an AutoFormat. </td> </tr> <tr> <td class="imsum_left"><a href="TableAutoFormats.html">TableAutoFormats</a></td> <td class="imsum_right">represents the collection of AutoFormats. </td> </tr> <tr> <td class="imsum_left"><a href="TableAutoFormatsEnumeration.html">TableAutoFormatsEnumeration</a></td> <td class="imsum_right">represents an enumeration of AutoFormats. </td> </tr> <tr> <td class="imsum_left"><a href="TableCellStyle.html">TableCellStyle</a></td> <td class="imsum_right">contains the properties of a table cell style. </td> </tr> <tr> <td class="imsum_left"><a href="TableConditionalEntry.html">TableConditionalEntry</a></td> <td class="imsum_right">represents a single condition in a conditional format. </td> </tr> <tr> <td class="imsum_left"><a href="TableConditionalEntryEnumeration.html">TableConditionalEntryEnumeration</a></td> <td class="imsum_right">represents an enumeration of conditional entries. </td> </tr> <tr> <td class="imsum_left"><a href="TableConditionalFormat.html">TableConditionalFormat</a></td> <td class="imsum_right">represents a collection of conditional formatting settings for a cell or cell range. </td> </tr> <tr> <td class="imsum_left"><a href="TablePageStyle.html">TablePageStyle</a></td> <td class="imsum_right">represents a page style for a spreadsheet. </td> </tr> <tr> <td class="imsum_left"><a href="TableValidation.html">TableValidation</a></td> <td class="imsum_right">represents the data validation settings for a cell or cell range. </td> </tr> <tr> <td class="imsum_left"><a href="UniqueCellFormatRanges.html">UniqueCellFormatRanges</a></td> <td class="imsum_right">represents a collection of equal-formatted cell range collections. </td> </tr> <tr> <td class="imsum_left"><a href="UniqueCellFormatRangesEnumeration.html">UniqueCellFormatRangesEnumeration</a></td> <td class="imsum_right">represents an enumeration of equal-formatted cell range collections. </td> </tr> <tr> <td class="imsum_left"><a href="VolatileResult.html">VolatileResult</a></td> <td class="imsum_right">represents a volatile function result. </td> </tr> </table> <a name="Interfaces"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Interfaces</td> </tr> <tr> <td class="imsum_left"><a href="XActivationBroadcaster.html">XActivationBroadcaster</a></td> <td class="imsum_right">provides methods to add and remove XActivationEventListener </td> </tr> <tr> <td class="imsum_left"><a href="XActivationEventListener.html">XActivationEventListener</a></td> <td class="imsum_right">makes it possible to receive events when the active spreadsheet changes. </td> </tr> <tr> <td class="imsum_left"><a href="XAddIn.html">XAddIn</a></td> <td class="imsum_right">gives access to function descriptions and user-visible names. </td> </tr> <tr> <td class="imsum_left"><a href="XAreaLink.html">XAreaLink</a></td> <td class="imsum_right">provides methods to change the settings of a linked cell range. </td> </tr> <tr> <td class="imsum_left"><a href="XAreaLinks.html">XAreaLinks</a></td> <td class="imsum_right">provides access via index to a collection of area links and inserting and removing area links. </td> </tr> <tr> <td class="imsum_left"><a href="XArrayFormulaRange.html">XArrayFormulaRange</a></td> <td class="imsum_right">provides handling of array formulas in a cell range. </td> </tr> <tr> <td class="imsum_left"><a href="XArrayFormulaTokens.html">XArrayFormulaTokens</a></td> <td class="imsum_right">gives access to an array formula as token sequence. </td> </tr> <tr> <td class="imsum_left"><a href="XCalculatable.html">XCalculatable</a></td> <td class="imsum_right">represents something that can recalculate. </td> </tr> <tr> <td class="imsum_left"><a href="XCellAddressable.html">XCellAddressable</a></td> <td class="imsum_right">represents a cell which can be addressed with a ::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/CellAddress.html">CellAddress</a>. </td> </tr> <tr> <td class="imsum_left"><a href="XCellFormatRangesSupplier.html">XCellFormatRangesSupplier</a></td> <td class="imsum_right">provides access to a collection of equal-formatted cell ranges. </td> </tr> <tr> <td class="imsum_left"><a href="XCellRangeAddressable.html">XCellRangeAddressable</a></td> <td class="imsum_right">represents a cell which can be addressed with a ::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/CellRangeAddress.html">CellRangeAddress</a>. </td> </tr> <tr> <td class="imsum_left"><a href="XCellRangeData.html">XCellRangeData</a></td> <td class="imsum_right">allows to get and set an array of data from a cell range. </td> </tr> <tr> <td class="imsum_left"><a href="XCellRangeFormula.html">XCellRangeFormula</a></td> <td class="imsum_right">allows to get and set cell contents (values, text or formulas) for a cell range. </td> </tr> <tr> <td class="imsum_left"><a href="XCellRangeMovement.html">XCellRangeMovement</a></td> <td class="imsum_right">provides methods for moving ranges of cells in a sheet. </td> </tr> <tr> <td class="imsum_left"><a href="XCellRangeReferrer.html">XCellRangeReferrer</a></td> <td class="imsum_right">allows direct access to the cells in a named range or to the cells which are visible in a view, without the need to get the document object first. </td> </tr> <tr> <td class="imsum_left"><a href="XCellRangesAccess.html">XCellRangesAccess</a></td> <td class="imsum_right">provides access to the cells or to sub-ranges of all sheets. </td> </tr> <tr> <td class="imsum_left"><a href="XCellRangesQuery.html">XCellRangesQuery</a></td> <td class="imsum_right">provides methods to query for cell ranges with specific contents. </td> </tr> <tr> <td class="imsum_left"><a href="XCellSeries.html">XCellSeries</a></td> <td class="imsum_right">provides methods to fill out a cell range automatically with values based on a start value, step count and fill mode. </td> </tr> <tr> <td class="imsum_left"><a href="XCompatibilityNames.html">XCompatibilityNames</a></td> <td class="imsum_right">gives access to the sequence of compatibility names for an Addin function. </td> </tr> <tr> <td class="imsum_left"><a href="XConsolidatable.html">XConsolidatable</a></td> <td class="imsum_right">[ DEPRECATED ]<br> provides methods to consolidate ranges in a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="XConsolidationDescriptor.html">XConsolidationDescriptor</a></td> <td class="imsum_right">[ DEPRECATED ]<br> provides access to the settings of a consolidation descriptor. </td> </tr> <tr> <td class="imsum_left"><a href="XDDELink.html">XDDELink</a></td> <td class="imsum_right">[ DEPRECATED ]<br> provides methods to change the settings of a DDE link. </td> </tr> <tr> <td class="imsum_left"><a href="XDDELinkResults.html">XDDELinkResults</a></td> <td class="imsum_right">provides access to the DDE link results. </td> </tr> <tr> <td class="imsum_left"><a href="XDDELinks.html">XDDELinks</a></td> <td class="imsum_right">provides a method to add a DDE link to a spreadsheet. </td> </tr> <tr> <td class="imsum_left"><a href="XDataPilotDescriptor.html">XDataPilotDescriptor</a></td> <td class="imsum_right">provides access to the layout settings of a data pilot table. </td> </tr> <tr> <td class="imsum_left"><a href="XDataPilotField.html">XDataPilotField</a></td> <td class="imsum_right">provides methods to control a data pilot field which has already been created. </td> </tr> <tr> <td class="imsum_left"><a href="XDataPilotFieldGrouping.html">XDataPilotFieldGrouping</a></td> <td class="imsum_right">provides methods to control a data pilot field which has already been created. </td> </tr> <tr> <td class="imsum_left"><a href="XDataPilotMemberResults.html">XDataPilotMemberResults</a></td> <td class="imsum_right">provides access to a sequence of results of a data pilot source level. </td> </tr> <tr> <td class="imsum_left"><a href="XDataPilotResults.html">XDataPilotResults</a></td> <td class="imsum_right">provides access to a table of results of a data pilot source. </td> </tr> <tr> <td class="imsum_left"><a href="XDataPilotTable.html">XDataPilotTable</a></td> <td class="imsum_right">provides methods to control a data pilot table which has already been created. </td> </tr> <tr> <td class="imsum_left"><a href="XDataPilotTables.html">XDataPilotTables</a></td> <td class="imsum_right">provides access to the data pilot tables via name and inserting and removing data pilot tables. </td> </tr> <tr> <td class="imsum_left"><a href="XDataPilotTablesSupplier.html">XDataPilotTablesSupplier</a></td> <td class="imsum_right">grants access to a collection of data pilot tables. </td> </tr> <tr> <td class="imsum_left"><a href="XDatabaseRange.html">XDatabaseRange</a></td> <td class="imsum_right">provides access to the settings and options of a database range. </td> </tr> <tr> <td class="imsum_left"><a href="XDatabaseRanges.html">XDatabaseRanges</a></td> <td class="imsum_right">provides functions to manage a collection of database ranges. </td> </tr> <tr> <td class="imsum_left"><a href="XDimensionsSupplier.html">XDimensionsSupplier</a></td> <td class="imsum_right">provides access to the collection of dimensions of a data pilot source. </td> </tr> <tr> <td class="imsum_left"><a href="XDocumentAuditing.html">XDocumentAuditing</a></td> <td class="imsum_right">provides auditing functions of a document. </td> </tr> <tr> <td class="imsum_left"><a href="XEnhancedMouseClickBroadcaster.html">XEnhancedMouseClickBroadcaster</a></td> <td class="imsum_right">provides methods to add and remove EnhancedMouseClickHandler </td> </tr> <tr> <td class="imsum_left"><a href="XExternalSheetName.html">XExternalSheetName</a></td> <td class="imsum_right">provides a method to set an external name at the sheet. </td> </tr> <tr> <td class="imsum_left"><a href="XFillAcrossSheet.html">XFillAcrossSheet</a></td> <td class="imsum_right">[ DEPRECATED ]<br> </td> </tr> <tr> <td class="imsum_left"><a href="XFormulaOpCodeMapper.html">XFormulaOpCodeMapper</a></td> <td class="imsum_right">gives access to spreadsheet compiler token interns. </td> </tr> <tr> <td class="imsum_left"><a href="XFormulaParser.html">XFormulaParser</a></td> <td class="imsum_right">converts between text and token representations of formulas. </td> </tr> <tr> <td class="imsum_left"><a href="XFormulaQuery.html">XFormulaQuery</a></td> <td class="imsum_right">provides methods to query cells for dependencies in formulas. </td> </tr> <tr> <td class="imsum_left"><a href="XFormulaTokens.html">XFormulaTokens</a></td> <td class="imsum_right">gives access to a formula as token sequence. </td> </tr> <tr> <td class="imsum_left"><a href="XFunctionAccess.html">XFunctionAccess</a></td> <td class="imsum_right">allows generic access to all spreadsheet functions. </td> </tr> <tr> <td class="imsum_left"><a href="XFunctionDescriptions.html">XFunctionDescriptions</a></td> <td class="imsum_right">provides access to the property sequence of a function description via function index or identifier. </td> </tr> <tr> <td class="imsum_left"><a href="XGoalSeek.html">XGoalSeek</a></td> <td class="imsum_right">provides seeking a goal value for a cell. </td> </tr> <tr> <td class="imsum_left"><a href="XHeaderFooterContent.html">XHeaderFooterContent</a></td> <td class="imsum_right">provides access to the text contents of a header or footer on a page. </td> </tr> <tr> <td class="imsum_left"><a href="XHierarchiesSupplier.html">XHierarchiesSupplier</a></td> <td class="imsum_right">provides access to the collection of hierarchies of a data pilot source dimension. </td> </tr> <tr> <td class="imsum_left"><a href="XLabelRange.html">XLabelRange</a></td> <td class="imsum_right">provides access to the settings of a label range in a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="XLabelRanges.html">XLabelRanges</a></td> <td class="imsum_right">provides methods to access the members of a label range collection and to insert and remove them. </td> </tr> <tr> <td class="imsum_left"><a href="XLevelsSupplier.html">XLevelsSupplier</a></td> <td class="imsum_right">provides access to the collection of levels of a data pilot source hierarchy. </td> </tr> <tr> <td class="imsum_left"><a href="XMembersSupplier.html">XMembersSupplier</a></td> <td class="imsum_right">provides access to the collection of members of a data pilot source level. </td> </tr> <tr> <td class="imsum_left"><a href="XMultiFormulaTokens.html">XMultiFormulaTokens</a></td> <td class="imsum_right">gives access to multiple sets of formula tokens. A service implementing this interface can internally set an arbitrary number of formula token sequences. The number of allowed formula token sequences must be returned by the <a href="XMultiFormulaTokens.html">XMultiFormulaTokens</a>::<a href="XMultiFormulaTokens.html#getCount">getCount</a> method. When the client code tries to access formula tokens at index that is outside the allowed index range, the implementation shall return an <a href="XMultiFormulaTokens.html#IndexOutOfBoundsException">IndexOutOfBoundsException</a>. </td> </tr> <tr> <td class="imsum_left"><a href="XMultipleOperation.html">XMultipleOperation</a></td> <td class="imsum_right">provides a method to apply a Multiple Operations Table to the cell range. </td> </tr> <tr> <td class="imsum_left"><a href="XNamedRange.html">XNamedRange</a></td> <td class="imsum_right">provides access to the settings of a named range in a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="XNamedRanges.html">XNamedRanges</a></td> <td class="imsum_right">provides access to the members in a collection of named ranges and to insert and remove them. </td> </tr> <tr> <td class="imsum_left"><a href="XPrintAreas.html">XPrintAreas</a></td> <td class="imsum_right">represents a sheet which has print areas. </td> </tr> <tr> <td class="imsum_left"><a href="XRangeSelection.html">XRangeSelection</a></td> <td class="imsum_right">allows to let the user to select a cell range. </td> </tr> <tr> <td class="imsum_left"><a href="XRangeSelectionChangeListener.html">XRangeSelectionChangeListener</a></td> <td class="imsum_right">allows notification when the selected range is changed. </td> </tr> <tr> <td class="imsum_left"><a href="XRangeSelectionListener.html">XRangeSelectionListener</a></td> <td class="imsum_right">allows notification when range selection is completed or aborted. </td> </tr> <tr> <td class="imsum_left"><a href="XRecentFunctions.html">XRecentFunctions</a></td> <td class="imsum_right">provides access to a list of recently used functions. </td> </tr> <tr> <td class="imsum_left"><a href="XResultListener.html">XResultListener</a></td> <td class="imsum_right">allows notification when a new volatile function result is available. </td> </tr> <tr> <td class="imsum_left"><a href="XScenario.html">XScenario</a></td> <td class="imsum_right">provides access to the settings of a scenario sheet. </td> </tr> <tr> <td class="imsum_left"><a href="XScenarioEnhanced.html">XScenarioEnhanced</a></td> <td class="imsum_right">provides enhanced access to the settings of a scenario sheet. </td> </tr> <tr> <td class="imsum_left"><a href="XScenarios.html">XScenarios</a></td> <td class="imsum_right">provides access via name to the scenarios in a collection and inserting and removing scenarios. </td> </tr> <tr> <td class="imsum_left"><a href="XScenariosSupplier.html">XScenariosSupplier</a></td> <td class="imsum_right">provides access to a collection of scenarios. </td> </tr> <tr> <td class="imsum_left"><a href="XSheetAnnotation.html">XSheetAnnotation</a></td> <td class="imsum_right">provides methods to query data of the annotation and to show and hide it. </td> </tr> <tr> <td class="imsum_left"><a href="XSheetAnnotationAnchor.html">XSheetAnnotationAnchor</a></td> <td class="imsum_right">provides access to a cell annotation attached to a spreadsheet cell. </td> </tr> <tr> <td class="imsum_left"><a href="XSheetAnnotationShapeSupplier.html">XSheetAnnotationShapeSupplier</a></td> <td class="imsum_right">provides methods to get the shape of o annotation </td> </tr> <tr> <td class="imsum_left"><a href="XSheetAnnotations.html">XSheetAnnotations</a></td> <td class="imsum_right">provides methods to access cell annotations via index and to insert and remove annotations. </td> </tr> <tr> <td class="imsum_left"><a href="XSheetAnnotationsSupplier.html">XSheetAnnotationsSupplier</a></td> <td class="imsum_right">provides access to a collection of cell annotations. </td> </tr> <tr> <td class="imsum_left"><a href="XSheetAuditing.html">XSheetAuditing</a></td> <td class="imsum_right">provides methods to access auditing (detective) features in a spreadsheet. </td> </tr> <tr> <td class="imsum_left"><a href="XSheetCellCursor.html">XSheetCellCursor</a></td> <td class="imsum_right">provides advanced methods to control the position of a cursor in a spreadsheet. </td> </tr> <tr> <td class="imsum_left"><a href="XSheetCellRange.html">XSheetCellRange</a></td> <td class="imsum_right">provides access to the spreadsheet that contains a cell range. </td> </tr> <tr> <td class="imsum_left"><a href="XSheetCellRangeContainer.html">XSheetCellRangeContainer</a></td> <td class="imsum_right">provides methods to access cell ranges in a collection via index and to add and remove cell ranges. </td> </tr> <tr> <td class="imsum_left"><a href="XSheetCellRanges.html">XSheetCellRanges</a></td> <td class="imsum_right">provides methods to access cell ranges in a collection via index and other helper methods. </td> </tr> <tr> <td class="imsum_left"><a href="XSheetCondition.html">XSheetCondition</a></td> <td class="imsum_right">provides methods to access the settings of a condition in a conditional format or data validation. </td> </tr> <tr> <td class="imsum_left"><a href="XSheetConditionalEntries.html">XSheetConditionalEntries</a></td> <td class="imsum_right">provides methods to add and remove conditions of a conditional format. </td> </tr> <tr> <td class="imsum_left"><a href="XSheetConditionalEntry.html">XSheetConditionalEntry</a></td> <td class="imsum_right">provides methods to access the cell style name for a condition in a conditional format. </td> </tr> <tr> <td class="imsum_left"><a href="XSheetFilterDescriptor.html">XSheetFilterDescriptor</a></td> <td class="imsum_right">provides access to a collection of filter conditions (filter fields). </td> </tr> <tr> <td class="imsum_left"><a href="XSheetFilterable.html">XSheetFilterable</a></td> <td class="imsum_right">represents something that can be filtered using an XSheetFilterDesriptor. </td> </tr> <tr> <td class="imsum_left"><a href="XSheetFilterableEx.html">XSheetFilterableEx</a></td> <td class="imsum_right">represents something from which criteria for filtering can be read. </td> </tr> <tr> <td class="imsum_left"><a href="XSheetLinkable.html">XSheetLinkable</a></td> <td class="imsum_right">[ DEPRECATED ]<br> enables a sheet to refer to another sheet in a different document. </td> </tr> <tr> <td class="imsum_left"><a href="XSheetOperation.html">XSheetOperation</a></td> <td class="imsum_right">provides methods to execute operations on a cell range or ranges. </td> </tr> <tr> <td class="imsum_left"><a href="XSheetOutline.html">XSheetOutline</a></td> <td class="imsum_right">provides methods to access the outlines of a sheet. </td> </tr> <tr> <td class="imsum_left"><a href="XSheetPageBreak.html">XSheetPageBreak</a></td> <td class="imsum_right">[ DEPRECATED ]<br> provides access to page breaks in a sheet. </td> </tr> <tr> <td class="imsum_left"><a href="XSheetPastable.html">XSheetPastable</a></td> <td class="imsum_right">[ DEPRECATED ]<br> represents a sheet into which contents of the clipboard can be pasted. </td> </tr> <tr> <td class="imsum_left"><a href="XSpreadsheet.html">XSpreadsheet</a></td> <td class="imsum_right">provides methods to create a cell range cursor. </td> </tr> <tr> <td class="imsum_left"><a href="XSpreadsheetDocument.html">XSpreadsheetDocument</a></td> <td class="imsum_right">provides access to a collection of spreadsheets. </td> </tr> <tr> <td class="imsum_left"><a href="XSpreadsheetView.html">XSpreadsheetView</a></td> <td class="imsum_right">is the main interface of a <a href="SpreadsheetView.html">SpreadsheetView</a>. It manages the active sheet within this view. </td> </tr> <tr> <td class="imsum_left"><a href="XSpreadsheets.html">XSpreadsheets</a></td> <td class="imsum_right">provides methods to access the spreadsheets by name and to insert, copy, remove and rearrange spreadsheets. </td> </tr> <tr> <td class="imsum_left"><a href="XSubTotalCalculatable.html">XSubTotalCalculatable</a></td> <td class="imsum_right">contains methods to handle a subtotal descriptor. </td> </tr> <tr> <td class="imsum_left"><a href="XSubTotalDescriptor.html">XSubTotalDescriptor</a></td> <td class="imsum_right">provides access to the collection of subtotal fields in a subtotal descriptor. </td> </tr> <tr> <td class="imsum_left"><a href="XSubTotalField.html">XSubTotalField</a></td> <td class="imsum_right">provides access to the settings of a field in a subtotal descriptor. </td> </tr> <tr> <td class="imsum_left"><a href="XUniqueCellFormatRangesSupplier.html">XUniqueCellFormatRangesSupplier</a></td> <td class="imsum_right">provides access to a collection of collections of equal-formatted cell ranges. </td> </tr> <tr> <td class="imsum_left"><a href="XUsedAreaCursor.html">XUsedAreaCursor</a></td> <td class="imsum_right">provides methods to find the used area of the entire sheet. </td> </tr> <tr> <td class="imsum_left"><a href="XViewFreezable.html">XViewFreezable</a></td> <td class="imsum_right">enables a <a href="SpreadsheetView.html">SpreadsheetView</a> to freeze columns and rows of the view. </td> </tr> <tr> <td class="imsum_left"><a href="XViewPane.html">XViewPane</a></td> <td class="imsum_right">represents a pane in a view of a spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="XViewPanesSupplier.html">XViewPanesSupplier</a></td> <td class="imsum_right">[ DEPRECATED ]<br> enables access to the panes in a view. </td> </tr> <tr> <td class="imsum_left"><a href="XViewSplitable.html">XViewSplitable</a></td> <td class="imsum_right">[ DEPRECATED ]<br> enables a <a href="SpreadsheetView.html">SpreadsheetView</a> to split the view. </td> </tr> <tr> <td class="imsum_left"><a href="XVolatileResult.html">XVolatileResult</a></td> <td class="imsum_right">provides methods to handle a volatile function result. </td> </tr> </table> <a name="Structs"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Structs</td> </tr> <tr> <td class="imsum_left"><a href="ActivationEvent.html">ActivationEvent</a></td> <td class="imsum_right">describes a change of the active sheet. The new active sheet is given with this event. </td> </tr> <tr> <td class="imsum_left"><a href="ComplexReference.html">ComplexReference</a></td> <td class="imsum_right">contains a reference to a cell range. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotFieldAutoShowInfo.html">DataPilotFieldAutoShowInfo</a></td> <td class="imsum_right">contains the auto show information of a DataPilotField. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotFieldFilter.html">DataPilotFieldFilter</a></td> <td class="imsum_right"/></tr> <tr> <td class="imsum_left"><a href="DataPilotFieldGroupInfo.html">DataPilotFieldGroupInfo</a></td> <td class="imsum_right">contains the grouping information of a <a href="DataPilotField.html">DataPilotField</a>. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotFieldLayoutInfo.html">DataPilotFieldLayoutInfo</a></td> <td class="imsum_right">contains the layout information of a <a href="DataPilotField.html">DataPilotField</a>. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotFieldReference.html">DataPilotFieldReference</a></td> <td class="imsum_right">controls how a data pilot field's results are shown in relation to a selected reference result. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotFieldSortInfo.html">DataPilotFieldSortInfo</a></td> <td class="imsum_right">describes how to sort a single DataPilotField </td> </tr> <tr> <td class="imsum_left"><a href="DataResult.html">DataResult</a></td> <td class="imsum_right">contains the result of one element in the data pilot data array. </td> </tr> <tr> <td class="imsum_left"><a href="FormulaOpCodeMapEntry.html">FormulaOpCodeMapEntry</a></td> <td class="imsum_right">contains a mapping from a formula name (function name, operator, ...) to the OpCode used by the formula compiler. </td> </tr> <tr> <td class="imsum_left"><a href="FormulaToken.html">FormulaToken</a></td> <td class="imsum_right">contains a single token within a formula. </td> </tr> <tr> <td class="imsum_left"><a href="FunctionArgument.html">FunctionArgument</a></td> <td class="imsum_right">contains the description of a single argument within a spreadsheet function. </td> </tr> <tr> <td class="imsum_left"><a href="GoalResult.html">GoalResult</a></td> <td class="imsum_right">is the result of a goal seek operation. </td> </tr> <tr> <td class="imsum_left"><a href="LocalizedName.html">LocalizedName</a></td> <td class="imsum_right">A name that is valid for a specified locale. </td> </tr> <tr> <td class="imsum_left"><a href="MemberResult.html">MemberResult</a></td> <td class="imsum_right">describes a result of a DataPilot member. </td> </tr> <tr> <td class="imsum_left"><a href="RangeSelectionEvent.html">RangeSelectionEvent</a></td> <td class="imsum_right">specifies an event from range selection. </td> </tr> <tr> <td class="imsum_left"><a href="ResultEvent.html">ResultEvent</a></td> <td class="imsum_right">contains the new value of a volatile function result. </td> </tr> <tr> <td class="imsum_left"><a href="SingleReference.html">SingleReference</a></td> <td class="imsum_right">contains a reference to a single cell. </td> </tr> <tr> <td class="imsum_left"><a href="SubTotalColumn.html">SubTotalColumn</a></td> <td class="imsum_right">describes how a single data column is treated when creating subtotals. </td> </tr> <tr> <td class="imsum_left"><a href="TableFilterField.html">TableFilterField</a></td> <td class="imsum_right">describes a single condition in a filter descriptor. </td> </tr> <tr> <td class="imsum_left"><a href="TablePageBreakData.html">TablePageBreakData</a></td> <td class="imsum_right">describes a page break in a spreadsheet. </td> </tr> </table> <a name="Enums"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Enums</td> </tr> <tr> <td class="imsum_left"><a href="Border.html">Border</a></td> <td class="imsum_right">is used to select one of the four borders of a cell range. </td> </tr> <tr> <td class="imsum_left"><a href="CellDeleteMode.html">CellDeleteMode</a></td> <td class="imsum_right">is used to specify how remaining cells are moved when cells are deleted. </td> </tr> <tr> <td class="imsum_left"><a href="CellInsertMode.html">CellInsertMode</a></td> <td class="imsum_right">is used to specify how cells are moved when new cells are inserted. </td> </tr> <tr> <td class="imsum_left"><a href="ConditionOperator.html">ConditionOperator</a></td> <td class="imsum_right">is used to specify the type of <a href="XSheetCondition.html">XSheetCondition</a>. </td> </tr> <tr> <td class="imsum_left"><a href="DDELinkMode.html">DDELinkMode</a></td> <td class="imsum_right">used to specify how the DDE server application converts its data into numbers. </td> </tr> <tr> <td class="imsum_left"><a href="DataImportMode.html">DataImportMode</a></td> <td class="imsum_right">used to specify which database contents are imported. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotFieldOrientation.html">DataPilotFieldOrientation</a></td> <td class="imsum_right">used to specify where a field in a data pilot table is laid out. </td> </tr> <tr> <td class="imsum_left"><a href="FillDateMode.html">FillDateMode</a></td> <td class="imsum_right">used to specify how an arithmetic date series is calculated. </td> </tr> <tr> <td class="imsum_left"><a href="FillDirection.html">FillDirection</a></td> <td class="imsum_right">used to specify the direction of filling cells, for example, with a series. </td> </tr> <tr> <td class="imsum_left"><a href="FillMode.html">FillMode</a></td> <td class="imsum_right">used to specify the series type used to fill cells. </td> </tr> <tr> <td class="imsum_left"><a href="FilterConnection.html">FilterConnection</a></td> <td class="imsum_right">used to specify how two conditions in a filter descriptor are connected. </td> </tr> <tr> <td class="imsum_left"><a href="FilterOperator.html">FilterOperator</a></td> <td class="imsum_right">specifies the type of a single condition in a filter descriptor. </td> </tr> <tr> <td class="imsum_left"><a href="GeneralFunction.html">GeneralFunction</a></td> <td class="imsum_right">used to specify a function to be calculated from values. </td> </tr> <tr> <td class="imsum_left"><a href="PasteOperation.html">PasteOperation</a></td> <td class="imsum_right">used to specify which operations are carried out when pasting cell values into a cell range. </td> </tr> <tr> <td class="imsum_left"><a href="SheetLinkMode.html">SheetLinkMode</a></td> <td class="imsum_right">used to specify how a sheet is linked to another sheet. </td> </tr> <tr> <td class="imsum_left"><a href="TableOperationMode.html">TableOperationMode</a></td> <td class="imsum_right">used to specify if a table operation is applied to columns, rows, or both columns and rows. </td> </tr> <tr> <td class="imsum_left"><a href="ValidationAlertStyle.html">ValidationAlertStyle</a></td> <td class="imsum_right">used to specify how invalid cell contents are treated. </td> </tr> <tr> <td class="imsum_left"><a href="ValidationType.html">ValidationType</a></td> <td class="imsum_right">used to specify which cell contents are treated as valid. </td> </tr> </table> <a name="ConstantGroups"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Constant Groups</td> </tr> <tr> <td class="imsum_left"><a href="CellFlags.html">CellFlags</a></td> <td class="imsum_right">These constants select different types of cell contents. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotFieldGroupBy.html">DataPilotFieldGroupBy</a></td> <td class="imsum_right">These constants select different types of DataPilotFieldGroups. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotFieldLayoutMode.html">DataPilotFieldLayoutMode</a></td> <td class="imsum_right">describes the layout mode of the data field </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotFieldReferenceItemType.html">DataPilotFieldReferenceItemType</a></td> <td class="imsum_right">is used to select the reference item </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotFieldReferenceType.html">DataPilotFieldReferenceType</a></td> <td class="imsum_right">These constants select different types of References to calculate the data fields. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotFieldShowItemsMode.html">DataPilotFieldShowItemsMode</a></td> <td class="imsum_right">These constants select different types of showing a selection of items. </td> </tr> <tr> <td class="imsum_left"><a href="DataPilotFieldSortMode.html">DataPilotFieldSortMode</a></td> <td class="imsum_right">describes the sort mode of the data field </td> </tr> <tr> <td class="imsum_left"><a href="DataResultFlags.html">DataResultFlags</a></td> <td class="imsum_right">used to specify the result type of one element in the data pilot data array. </td> </tr> <tr> <td class="imsum_left"><a href="FormulaLanguage.html">FormulaLanguage</a></td> <td class="imsum_right">Constants designating the formula language used with <a href="XFormulaOpCodeMapper.html">XFormulaOpCodeMapper</a> methods. </td> </tr> <tr> <td class="imsum_left"><a href="FormulaMapGroup.html">FormulaMapGroup</a></td> <td class="imsum_right">Constants of bit masks used with ::XFormurmulaOpCodeMapper::getAvailableMappings to specify for which group of symbols the mappings are to be obtained. If no bit is set, a sequence of special mappings is returned in the order that is defined by <a href="FormulaMapGroupSpecialOffset.html">FormulaMapGroupSpecialOffset</a>. Note that the special group and other groups are mutual exclusive. </td> </tr> <tr> <td class="imsum_left"><a href="FormulaMapGroupSpecialOffset.html">FormulaMapGroupSpecialOffset</a></td> <td class="imsum_right">Constants designating the offsets within the sequence returned by ::XFormurmulaOpCodeMapper::getAvailableMappings when called for group <a href="FormulaMapGroup.html">FormulaMapGroup</a> SPECIAL. The number of constants may grow in future versions! </td> </tr> <tr> <td class="imsum_left"><a href="FormulaResult.html">FormulaResult</a></td> <td class="imsum_right">used to select different result types of cell formulas. </td> </tr> <tr> <td class="imsum_left"><a href="FunctionCategory.html">FunctionCategory</a></td> <td class="imsum_right">used to specify the category of a spreadsheet function. </td> </tr> <tr> <td class="imsum_left"><a href="MemberResultFlags.html">MemberResultFlags</a></td> <td class="imsum_right">used to give information about elements in data pilot member results. </td> </tr> <tr> <td class="imsum_left"><a href="MoveDirection.html">MoveDirection</a></td> <td class="imsum_right">used to specify the direction of moving the current selection i.e. after a cell has been left with Enter. </td> </tr> <tr> <td class="imsum_left"><a href="NamedRangeFlag.html">NamedRangeFlag</a></td> <td class="imsum_right">used to specify the purpose of a named range. </td> </tr> <tr> <td class="imsum_left"><a href="ReferenceFlags.html">ReferenceFlags</a></td> <td class="imsum_right">defines flags for references. </td> </tr> <tr> <td class="imsum_left"><a href="StatusBarFunction.html">StatusBarFunction</a></td> <td class="imsum_right">used to specify the function used to calculate a result in the spreadsheet's status bar. </td> </tr> <tr> <td class="imsum_left"><a href="TableValidationVisibility.html">TableValidationVisibility</a></td> <td class="imsum_right">These constants specify whether and how a list of possible values of a cell should be shown. </td> </tr> <tr> <td class="imsum_left"><a href="_NamedRange.html">_NamedRange</a></td> <td class="imsum_right">[ DEPRECATED ]<br> </td> </tr> </table> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2008 Sun Microsystems, Inc.</p> </div> <!-- id="adc-idlref" --> </body> </html>