:: com :: sun :: star ::

module sheet
Description
Spreadsheet specific interfaces.

Services
::com::sun::star::sheet::AccessibleCell The accessible view of a spreadsheet document
::com::sun::star::sheet::AccessibleCsvCell The accessible object of a cell in the CSV import dialog.
::com::sun::star::sheet::AccessibleCsvRuler The accessible object of the ruler in the CSV import dialog.
::com::sun::star::sheet::AccessibleCsvTable The accessible object of the data table in the CSV import dialog.
::com::sun::star::sheet::AccessiblePageHeaderFooterAreasView The accessible view of the Header/Footer in a spreadsheet page preview
::com::sun::star::sheet::AccessibleSpreadsheet The accessible view of a spreadsheet document
::com::sun::star::sheet::AccessibleSpreadsheetDocumentView The accessible view of a spreadsheet document
::com::sun::star::sheet::AccessibleSpreadsheetPageView The accessible view of a spreadsheet page preview
::com::sun::star::sheet::AddIn is the base for AddIn services that supply functions which can be called by other components.
::com::sun::star::sheet::CellAnnotation represents a cell annotation object attached to a spreadsheet cell.
::com::sun::star::sheet::CellAnnotationShape represents the shape of a cell annotation object attached to a spreadsheet cell.
::com::sun::star::sheet::CellAnnotations represents a collection of cell annotations.
::com::sun::star::sheet::CellAnnotationsEnumeration represents an enumeration of cell annotations in a spreadsheet document.
::com::sun::star::sheet::CellAreaLink represents a linked cell range.
::com::sun::star::sheet::CellAreaLinks represents a collection of area links.
::com::sun::star::sheet::CellAreaLinksEnumeration represents an enumeration of cell area links.
::com::sun::star::sheet::CellFormatRanges represents a collection of equal-formatted cell ranges.
::com::sun::star::sheet::CellFormatRangesEnumeration represents an enumeration of equal-formatted cell ranges.
::com::sun::star::sheet::Cells represents a collection of used cells in a spreadsheet document.
::com::sun::star::sheet::CellsEnumeration represents an enumeration of spreadsheet cells.
::com::sun::star::sheet::ConsolidationDescriptor contains all settings of a data consolidation in a spreadsheet document.
::com::sun::star::sheet::DDELink represents a DDE link.
::com::sun::star::sheet::DDELinks represents a collection of DDE links.
::com::sun::star::sheet::DDELinksEnumeration represents an enumeration of DDE links.
::com::sun::star::sheet::DataPilotDescriptor represents the description of the layout of a data pilot table.
::com::sun::star::sheet::DataPilotField represents a single field in a data pilot table.
::com::sun::star::sheet::DataPilotFieldGroup represents a collection of members in a data pilot field group.
::com::sun::star::sheet::DataPilotFieldGroupItem represents the member in a data pilot field group.
::com::sun::star::sheet::DataPilotFieldGroups represents a collection of groups in a data pilot field.
::com::sun::star::sheet::DataPilotFields represents a collection of fields in a data pilot table.
::com::sun::star::sheet::DataPilotFieldsEnumeration represents an enumeration of data pilot fields.
::com::sun::star::sheet::DataPilotItem represents a single item in a data pilot field.
::com::sun::star::sheet::DataPilotItems represents a collection of Items in a data pilot field.
::com::sun::star::sheet::DataPilotItemsEnumeration represents an enumeration of data pilot items.
::com::sun::star::sheet::DataPilotSource represents a data pilot source.
::com::sun::star::sheet::DataPilotSourceDimension represents a dimension in a data pilot source.
::com::sun::star::sheet::DataPilotSourceDimensions represents the collection of dimensions in a data pilot source.
::com::sun::star::sheet::DataPilotSourceHierarchies represents the collection of hierarchies in a data pilot source dimension.
::com::sun::star::sheet::DataPilotSourceHierarchy represents a hierarchy in a data pilot source dimension.
::com::sun::star::sheet::DataPilotSourceLevel represents a level in a data pilot source hierarchy.
::com::sun::star::sheet::DataPilotSourceLevels represents the collection of levels in a data pilot source hierarchy.
::com::sun::star::sheet::DataPilotSourceMember represents a member in a data pilot source level.
::com::sun::star::sheet::DataPilotSourceMembers represents the collection of members in a data pilot source level.
::com::sun::star::sheet::DataPilotTable represents a data pilot table on a spreadsheet.
::com::sun::star::sheet::DataPilotTables represents a collection of data pilot tables.
::com::sun::star::sheet::DataPilotTablesEnumeration represents an enumeration of data pilot tables.
::com::sun::star::sheet::DatabaseImportDescriptor represents a description of how data from an external database is imported.
::com::sun::star::sheet::DatabaseRange represents a database range in a spreadsheet document.
::com::sun::star::sheet::DatabaseRanges represents a collection of database ranges in a spreadsheet document.
::com::sun::star::sheet::DatabaseRangesEnumeration represents an enumeration of database ranges.
::com::sun::star::sheet::DocumentSettings describes properties that apply to the whole spreadsheet document.
::com::sun::star::sheet::FunctionAccess allows generic access to all spreadsheet functions.
::com::sun::star::sheet::FunctionDescription collects all properties used to describe a function.
::com::sun::star::sheet::FunctionDescriptionEnumeration represents an enumeration of Function Descriptions.
::com::sun::star::sheet::FunctionDescriptions represents a collection of function descriptions for all built-in functions as well as add-in functions available in the spreadsheet application.
::com::sun::star::sheet::GlobalSheetSettings contributes properties to access the settings for all spreadsheets of a spreadsheet document.
::com::sun::star::sheet::HeaderFooterContent represents the contents of a header or footer line in a page style.
::com::sun::star::sheet::LabelRange represents a cell area that contains labels and values related to the labels.
::com::sun::star::sheet::LabelRanges represents a collection of label ranges in a spreadsheet document.
::com::sun::star::sheet::LabelRangesEnumeration represents an enumeration of label ranges.
::com::sun::star::sheet::NamedRange represents a named range in a spreadsheet document.
::com::sun::star::sheet::NamedRanges represents a collection of named ranges in a spreadsheet document.
::com::sun::star::sheet::NamedRangesEnumeration represents an enumeration of named ranges.
::com::sun::star::sheet::RangeSelectionArguments contains the arguments for starting the range selection.
::com::sun::star::sheet::RecentFunctions contains the list of recently used spreadsheet functions.
::com::sun::star::sheet::Scenario represents a scenario in a spreadsheet document.
::com::sun::star::sheet::Scenarios represents a collection of scenarios.
::com::sun::star::sheet::ScenariosEnumeration represents an enumeration of scenarios.
::com::sun::star::sheet::Shape specifies the service of shapes in a spreadsheet document
::com::sun::star::sheet::SheetCell represents a single addressable cell in a spreadsheet document.
::com::sun::star::sheet::SheetCellCursor represents a cursor in a spreadsheet.
::com::sun::star::sheet::SheetCellRange represents a rectangular range of cells in a spreadsheet document.
::com::sun::star::sheet::SheetCellRanges represents a collection of cell ranges in a spreadsheet document.
::com::sun::star::sheet::SheetCellRangesEnumeration represents an enumeration of cell ranges in a spreadsheet document.
::com::sun::star::sheet::SheetFilterDescriptor represents a description of how a cell range is to be filtered.
::com::sun::star::sheet::SheetLink represents a sheet link.
::com::sun::star::sheet::SheetLinks represents a collection of sheet links.
::com::sun::star::sheet::SheetLinksEnumeration represents an enumeration of sheet links.
::com::sun::star::sheet::SheetRangesQuery provides interfaces to find cells with specific properties.
::com::sun::star::sheet::SheetSortDescriptor a description of how a cell range is to be sorted.
::com::sun::star::sheet::SheetSortDescriptor2 a description of how a cell range is to be sorted.
::com::sun::star::sheet::Spreadsheet represents a complete spreadsheet in a spreadsheet document.
::com::sun::star::sheet::SpreadsheetDocument represents a model component which consists of some settings and one or more spreadsheets.
::com::sun::star::sheet::SpreadsheetDocumentSettings [ DEPRECATED ]
contributes properties to control the configuration which is global for all views of a spreadsheet document.
::com::sun::star::sheet::SpreadsheetDrawPage This abstract service is implemented by every page of a ::com::sun::star::sheet::SpreadsheetDocument .
::com::sun::star::sheet::SpreadsheetView represents a view of a spreadsheet document.
::com::sun::star::sheet::SpreadsheetViewPane represents a single pane in a view of a spreadsheet document.
::com::sun::star::sheet::SpreadsheetViewPanesEnumeration represents an enumeration of spreadsheet view panes.
::com::sun::star::sheet::SpreadsheetViewSettings contains settings which are specific to each view of a spreadsheet
::com::sun::star::sheet::Spreadsheets represents the collection of spreadsheets in a spreadsheet document.
::com::sun::star::sheet::SpreadsheetsEnumeration represents an enumeration of spreadsheets in a spreadsheet document.
::com::sun::star::sheet::SubTotalDescriptor represents a description of how subtotals are created.
::com::sun::star::sheet::SubTotalField represents a single field in a subtotal descriptor.
::com::sun::star::sheet::SubTotalFieldsEnumeration represents an enumeration of sub total fields.
::com::sun::star::sheet::TableAutoFormat represents an AutoFormat, containing exactly 16 AutoFormat fields.
::com::sun::star::sheet::TableAutoFormatEnumeration represents an enumeration of AutoFormat fields in an AutoFormat.
::com::sun::star::sheet::TableAutoFormatField represents a field in an AutoFormat. A field contains all cell properties for a specific position in an AutoFormat.
::com::sun::star::sheet::TableAutoFormats represents the collection of AutoFormats.
::com::sun::star::sheet::TableAutoFormatsEnumeration represents an enumeration of AutoFormats.
::com::sun::star::sheet::TableCellStyle contains the properties of a table cell style.
::com::sun::star::sheet::TableConditionalEntry represents a single condition in a conditional format.
::com::sun::star::sheet::TableConditionalEntryEnumeration represents an enumeration of conditional entries.
::com::sun::star::sheet::TableConditionalFormat represents a collection of conditional formatting settings for a cell or cell range.
::com::sun::star::sheet::TablePageStyle represents a page style for a spreadsheet.
::com::sun::star::sheet::TableValidation represents the data validation settings for a cell or cell range.
::com::sun::star::sheet::UniqueCellFormatRanges represents a collection of equal-formatted cell range collections.
::com::sun::star::sheet::UniqueCellFormatRangesEnumeration represents an enumeration of equal-formatted cell range collections.
::com::sun::star::sheet::VolatileResult represents a volatile function result.
Interfaces
::com::sun::star::sheet::XActivationBroadcaster provides methods to add and remove XActivationEventListener
::com::sun::star::sheet::XActivationEventListener makes it possible to receive events when the active spreadsheet changes.
::com::sun::star::sheet::XAddIn gives access to function descriptions and user-visible names.
::com::sun::star::sheet::XAreaLink provides methods to change the settings of a linked cell range.
::com::sun::star::sheet::XAreaLinks provides access via index to a collection of area links and inserting and removing area links.
::com::sun::star::sheet::XArrayFormulaRange provides handling of array formulas in a cell range.
::com::sun::star::sheet::XCalculatable represents something that can recalculate.
::com::sun::star::sheet::XCellAddressable represents a cell which can be addressed with a ::com::sun::star::table::CellAddress .
::com::sun::star::sheet::XCellFormatRangesSupplier provides access to a collection of equal-formatted cell ranges.
::com::sun::star::sheet::XCellRangeAddressable represents a cell which can be addressed with a ::com::sun::star::table::CellRangeAddress .
::com::sun::star::sheet::XCellRangeData allows to get and set an array of data from a cell range.
::com::sun::star::sheet::XCellRangeFormula allows to get and set cell contents (values, text or formulas) for a cell range.
::com::sun::star::sheet::XCellRangeMovement provides methods for moving ranges of cells in a sheet.
::com::sun::star::sheet::XCellRangeReferrer 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.
::com::sun::star::sheet::XCellRangesQuery provides methods to query for cell ranges with specific contents.
::com::sun::star::sheet::XCellSeries provides methods to fill out a cell range automatically with values based on a start value, step count and fill mode.
::com::sun::star::sheet::XCompatibilityNames gives access to the sequence of compatibility names for an Addin function.
::com::sun::star::sheet::XConsolidatable [ DEPRECATED ]
provides methods to consolidate ranges in a spreadsheet document.
::com::sun::star::sheet::XConsolidationDescriptor [ DEPRECATED ]
provides access to the settings of a consolidation descriptor.
::com::sun::star::sheet::XDDELink [ DEPRECATED ]
provides methods to change the settings of a DDE link.
::com::sun::star::sheet::XDataPilotDescriptor provides access to the layout settings of a data pilot table.
::com::sun::star::sheet::XDataPilotField provides methods to control a data pilot field which has already been created.
::com::sun::star::sheet::XDataPilotFieldGrouping provides methods to control a data pilot field which has already been created.
::com::sun::star::sheet::XDataPilotMemberResults provides access to a sequence of results of a data pilot source level.
::com::sun::star::sheet::XDataPilotResults provides access to a table of results of a data pilot source.
::com::sun::star::sheet::XDataPilotTable provides methods to control a data pilot table which has already been created.
::com::sun::star::sheet::XDataPilotTables provides access to the data pilot tables via name and inserting and removing data pilot tables.
::com::sun::star::sheet::XDataPilotTablesSupplier grants access to a collection of data pilot tables.
::com::sun::star::sheet::XDatabaseRange provides access to the settings and options of a database range.
::com::sun::star::sheet::XDatabaseRanges provides functions to manage a collection of database ranges.
::com::sun::star::sheet::XDimensionsSupplier provides access to the collection of dimensions of a data pilot source.
::com::sun::star::sheet::XDocumentAuditing provides auditing functions of a document.
::com::sun::star::sheet::XEnhancedMouseClickBroadcaster provides methods to add and remove EnhancedMouseClickHandler
::com::sun::star::sheet::XFillAcrossSheet [ DEPRECATED ]
::com::sun::star::sheet::XFormulaQuery provides methods to query cells for dependencies in formulas.
::com::sun::star::sheet::XFunctionAccess allows generic access to all spreadsheet functions.
::com::sun::star::sheet::XFunctionDescriptions provides access to the property sequence of a function description via function index or identifier.
::com::sun::star::sheet::XGoalSeek provides seeking a goal value for a cell.
::com::sun::star::sheet::XHeaderFooterContent provides access to the text contents of a header or footer on a page.
::com::sun::star::sheet::XHierarchiesSupplier provides access to the collection of hierarchies of a data pilot source dimension.
::com::sun::star::sheet::XLabelRange provides access to the settings of a label range in a spreadsheet document.
::com::sun::star::sheet::XLabelRanges provides methods to access the members of a label range collection and to insert and remove them.
::com::sun::star::sheet::XLevelsSupplier provides access to the collection of levels of a data pilot source hierarchy.
::com::sun::star::sheet::XMembersSupplier provides access to the collection of members of a data pilot source level.
::com::sun::star::sheet::XMultipleOperation provides a method to apply a Multiple Operations Table to the cell range.
::com::sun::star::sheet::XNamedRange provides access to the settings of a named range in a spreadsheet document.
::com::sun::star::sheet::XNamedRanges provides access to the members in a collection of named ranges and to insert and remove them.
::com::sun::star::sheet::XPrintAreas represents a sheet which has print areas.
::com::sun::star::sheet::XRangeSelection allows to let the user to select a cell range.
::com::sun::star::sheet::XRangeSelectionChangeListener allows notification when the selected range is changed.
::com::sun::star::sheet::XRangeSelectionListener allows notification when range selection is completed or aborted.
::com::sun::star::sheet::XRecentFunctions provides access to a list of recently used functions.
::com::sun::star::sheet::XResultListener allows notification when a new volatile function result is available.
::com::sun::star::sheet::XScenario provides access to the settings of a scenario sheet.
::com::sun::star::sheet::XScenarioEnhanced provides enhanced access to the settings of a scenario sheet.
::com::sun::star::sheet::XScenarios provides access via name to the scenarios in a collection and inserting and removing scenarios.
::com::sun::star::sheet::XScenariosSupplier provides access to a collection of scenarios.
::com::sun::star::sheet::XSheetAnnotation provides methods to query data of the annotation and to show and hide it.
::com::sun::star::sheet::XSheetAnnotationAnchor provides access to a cell annotation attached to a spreadsheet cell.
::com::sun::star::sheet::XSheetAnnotationShapeSupplier provides methods to get the shape of o annotation
::com::sun::star::sheet::XSheetAnnotations provides methods to access cell annotations via index and to insert and remove annotations.
::com::sun::star::sheet::XSheetAnnotationsSupplier provides access to a collection of cell annotations.
::com::sun::star::sheet::XSheetAuditing provides methods to access auditing (detective) features in a spreadsheet.
::com::sun::star::sheet::XSheetCellCursor provides advanced methods to control the position of a cursor in a spreadsheet.
::com::sun::star::sheet::XSheetCellRange provides access to the spreadsheet that contains a cell range.
::com::sun::star::sheet::XSheetCellRangeContainer provides methods to access cell ranges in a collection via index and to add and remove cell ranges.
::com::sun::star::sheet::XSheetCellRanges provides methods to access cell ranges in a collection via index and other helper methods.
::com::sun::star::sheet::XSheetCondition provides methods to access the settings of a condition in a conditional format or data validation.
::com::sun::star::sheet::XSheetConditionalEntries provides methods to add and remove conditions of a conditional format.
::com::sun::star::sheet::XSheetConditionalEntry provides methods to access the cell style name for a condition in a conditional format.
::com::sun::star::sheet::XSheetFilterDescriptor provides access to a collection of filter conditions (filter fields).
::com::sun::star::sheet::XSheetFilterable represents something that can be filtered using an XSheetFilterDesriptor.
::com::sun::star::sheet::XSheetFilterableEx represents something from which criteria for filtering can be read.
::com::sun::star::sheet::XSheetLinkable [ DEPRECATED ]
enables a sheet to refer to another sheet in a different document.
::com::sun::star::sheet::XSheetOperation provides methods to execute operations on a cell range or ranges.
::com::sun::star::sheet::XSheetOutline provides methods to access the outlines of a sheet.
::com::sun::star::sheet::XSheetPageBreak [ DEPRECATED ]
provides access to page breaks in a sheet.
::com::sun::star::sheet::XSheetPastable [ DEPRECATED ]
represents a sheet into which contents of the clipboard can be pasted.
::com::sun::star::sheet::XSpreadsheet provides methods to create a cell range cursor.
::com::sun::star::sheet::XSpreadsheetDocument provides access to a collection of spreadsheets.
::com::sun::star::sheet::XSpreadsheetView is the main interface of a ::com::sun::star::sheet::SpreadsheetView . It manages the active sheet within this view.
::com::sun::star::sheet::XSpreadsheets provides methods to access the spreadsheets by name and to insert, copy, remove and rearrange spreadsheets.
::com::sun::star::sheet::XSubTotalCalculatable contains methods to handle a subtotal descriptor.
::com::sun::star::sheet::XSubTotalDescriptor provides access to the collection of subtotal fields in a subtotal descriptor.
::com::sun::star::sheet::XSubTotalField provides access to the settings of a field in a subtotal descriptor.
::com::sun::star::sheet::XUniqueCellFormatRangesSupplier provides access to a collection of collections of equal-formatted cell ranges.
::com::sun::star::sheet::XUsedAreaCursor provides methods to find the used area of the entire sheet.
::com::sun::star::sheet::XViewFreezable enables a ::com::sun::star::sheet::SpreadsheetView to freeze columns and rows of the view.
::com::sun::star::sheet::XViewPane represents a pane in a view of a spreadsheet document.
::com::sun::star::sheet::XViewPanesSupplier [ DEPRECATED ]
enables access to the panes in a view.
::com::sun::star::sheet::XViewSplitable [ DEPRECATED ]
enables a ::com::sun::star::sheet::SpreadsheetView to split the view.
::com::sun::star::sheet::XVolatileResult provides methods to handle a volatile function result.
Structs
::com::sun::star::sheet::ActivationEvent describes a change of the active sheet. The new active sheet is given with this event.
::com::sun::star::sheet::DataPilotFieldAutoShowInfo contains the auto show information of a DataPilotField.
::com::sun::star::sheet::DataPilotFieldGroupInfo contains the grouping information of a ::com::sun::star::sheet::DataPilotField .
::com::sun::star::sheet::DataPilotFieldLayoutInfo contains the layout information of a ::com::sun::star::sheet::DataPilotField .
::com::sun::star::sheet::DataPilotFieldReference controls how a data pilot field's results are shown in relation to a selected reference result.
::com::sun::star::sheet::DataPilotFieldSortInfo describes how to sort a single DataPilotField
::com::sun::star::sheet::DataResult contains the result of one element in the data pilot data array.
::com::sun::star::sheet::FunctionArgument contains the description of a single argument within a spreadsheet function.
::com::sun::star::sheet::GoalResult is the result of a goal seek operation.
::com::sun::star::sheet::LocalizedName A name that is valid for a specified locale.
::com::sun::star::sheet::MemberResult describes a result of a DataPilot member.
::com::sun::star::sheet::RangeSelectionEvent specifies an event from range selection.
::com::sun::star::sheet::ResultEvent contains the new value of a volatile function result.
::com::sun::star::sheet::SubTotalColumn describes how a single data column is treated when creating subtotals.
::com::sun::star::sheet::TableFilterField describes a single condition in a filter descriptor.
::com::sun::star::sheet::TablePageBreakData describes a page break in a spreadsheet.
Enums
::com::sun::star::sheet::Border is used to select one of the four borders of a cell range.
::com::sun::star::sheet::CellDeleteMode is used to specify how remaining cells are moved when cells are deleted.
::com::sun::star::sheet::CellInsertMode is used to specify how cells are moved when new cells are inserted.
::com::sun::star::sheet::ConditionOperator is used to specify the type of ::com::sun::star::sheet::XSheetCondition .
::com::sun::star::sheet::DataImportMode used to specify which database contents are imported.
::com::sun::star::sheet::DataPilotFieldOrientation used to specify where a field in a data pilot table is laid out.
::com::sun::star::sheet::FillDateMode used to specify how an arithmetic date series is calculated.
::com::sun::star::sheet::FillDirection used to specify the direction of filling cells, for example, with a series.
::com::sun::star::sheet::FillMode used to specify the series type used to fill cells.
::com::sun::star::sheet::FilterConnection used to specify how two conditions in a filter descriptor are connected.
::com::sun::star::sheet::FilterOperator specifies the type of a single condition in a filter descriptor.
::com::sun::star::sheet::GeneralFunction used to specify a function to be calculated from values.
::com::sun::star::sheet::PasteOperation used to specify which operations are carried out when pasting cell values into a cell range.
::com::sun::star::sheet::SheetLinkMode used to specify how a sheet is linked to another sheet.
::com::sun::star::sheet::TableOperationMode used to specify if a table operation is applied to columns, rows, or both columns and rows.
::com::sun::star::sheet::ValidationAlertStyle used to specify how invalid cell contents are treated.
::com::sun::star::sheet::ValidationType used to specify which cell contents are treated as valid.
Constant Groups
::com::sun::star::sheet::CellFlags These constants select different types of cell contents.
::com::sun::star::sheet::DataPilotFieldGroupBy These constants select different types of DataPilotFieldGroups.
::com::sun::star::sheet::DataPilotFieldLayoutMode describes the layout mode of the data field
::com::sun::star::sheet::DataPilotFieldReferenceItemType is used to select the reference item
::com::sun::star::sheet::DataPilotFieldReferenceType These constants select different types of References to calculate the data fields.
::com::sun::star::sheet::DataPilotFieldShowItemsMode These constants select different types of showing a selection of items.
::com::sun::star::sheet::DataPilotFieldSortMode describes the sort mode of the data field
::com::sun::star::sheet::DataResultFlags used to specify the result type of one element in the data pilot data array.
::com::sun::star::sheet::FormulaResult used to select different result types of cell formulas.
::com::sun::star::sheet::FunctionCategory used to specify the category of a spreadsheet function.
::com::sun::star::sheet::MemberResultFlags used to give information about elements in data pilot member results.
::com::sun::star::sheet::MoveDirection used to specify the direction of moving the current selection i.e. after a cell has been left with Enter.
::com::sun::star::sheet::NamedRangeFlag used to specify the purpose of a named range.
::com::sun::star::sheet::StatusBarFunction used to specify the function used to calculate a result in the spreadsheet's status bar.
::com::sun::star::sheet::TableValidationVisibility These constants specify whether and how a list of possible values of a cell should be shown.
::com::sun::star::sheet::_NamedRange [ DEPRECATED ]
Top of Page