Difference between revisions of "Documentation/DevGuide/Spreadsheets/Capabilities of SheetCell"

Revision as of 09:43, 4 June 2008

A com.sun.star.sheet.SheetCell is the base unit of OpenOffice.org Calc tables. Values, formulas and text required for calculation jobs are all written into sheet cells. The SheetCell includes the following services:

SheetCell

The SheetCell exports the following interfaces:

SheetCell Interfaces

The SheetCell service has the following capabilities:

• It can access the cell content. It can contain numeric values that are used for calculations, formulas that operate on these values, and text supporting full-featured formatting and hyperlink text fields. The access to the cell values and formulas is provided through the SheetCell parent service com.sun.star.table.Cell. The interface com.sun.star.table.XCell is capable of manipulating the values and formulas in a cell. For text, the service com.sun.star.text.Text with the main interface com.sun.star.text.XText is available at a SheetCell. Its text fields are accessed through com.sun.star.text.XTextFieldsSupplier.
• A SheetCell is a special case of a SheetCellRange. As such, it has all capabilities of the com.sun.star.sheet.SheetCellRange described above.
• It can have an annotation: com.sun.star.sheet.XSheetAnnotationAnchor.
• It can provide its unique cell address in the spreadsheet document, that is, its column, row and the sheet it is located in. The com.sun.star.sheet.XCellAddressable:getCellAddress() returns the appropriate com.sun.star.table.CellAddress struct.
• It can be locked temporarily against user interaction with com.sun.star.document.XActionLockable.