Difference between revisions of "Documentation/DevGuide/Spreadsheets/Capabilities of SheetCell"
From Apache OpenOffice Wiki
< Documentation | DevGuide
OOoWikiBot (Talk | contribs) m (FINAL VERSION FOR L10N) |
|||
| Line 9: | Line 9: | ||
{{Documentation/DevGuideLanguages|Documentation/DevGuide/Spreadsheets/{{SUBPAGENAME}}}} | {{Documentation/DevGuideLanguages|Documentation/DevGuide/Spreadsheets/{{SUBPAGENAME}}}} | ||
{{DISPLAYTITLE:Capabilities of SheetCell}} | {{DISPLAYTITLE:Capabilities of SheetCell}} | ||
| − | A <idl>com.sun.star.sheet.SheetCell</idl> is the base unit of {{ | + | A <idl>com.sun.star.sheet.SheetCell</idl> is the base unit of {{AOo}} Calc tables. Values, formulas and text required for calculation jobs are all written into sheet cells. The <code>SheetCell</code> includes the following services: |
[[Image:SheetCell.png|none|thumb|400px|SheetCell]] | [[Image:SheetCell.png|none|thumb|400px|SheetCell]] | ||
| Line 22: | Line 22: | ||
* A <code>SheetCell</code> is a special case of a <code>SheetCellRange</code>. As such, it has all capabilities of the <idl>com.sun.star.sheet.SheetCellRange</idl> described above. | * A <code>SheetCell</code> is a special case of a <code>SheetCellRange</code>. As such, it has all capabilities of the <idl>com.sun.star.sheet.SheetCellRange</idl> described above. | ||
* It can have an annotation: <idl>com.sun.star.sheet.XSheetAnnotationAnchor</idl>. | * It can have an annotation: <idl>com.sun.star.sheet.XSheetAnnotationAnchor</idl>. | ||
| − | * It can provide its unique cell address in the spreadsheet document, that is, its column, row and the sheet it is located in. The | + | * It can provide its unique cell address in the spreadsheet document, that is, its column, row and the sheet it is located in. The <idlm>com.sun.star.sheet.XCellAddressable:getCellAddress</idlm>() returns the appropriate <idl>com.sun.star.table.CellAddress</idl> struct. |
* It can be locked temporarily against user interaction with <idl>com.sun.star.document.XActionLockable</idl>. | * It can be locked temporarily against user interaction with <idl>com.sun.star.document.XActionLockable</idl>. | ||
Latest revision as of 15:17, 3 January 2021
A com.sun.star.sheet.SheetCell is the base unit of Apache OpenOffice Calc tables. Values, formulas and text required for calculation jobs are all written into sheet cells. The SheetCell includes the following services:
The SheetCell exports the following 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
SheetCellparent 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 aSheetCell. Its text fields are accessed through com.sun.star.text.XTextFieldsSupplier. - A
SheetCellis a special case of aSheetCellRange. 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 getCellAddress() returns the appropriate com.sun.star.table.CellAddress struct.
- It can be locked temporarily against user interaction with com.sun.star.document.XActionLockable.
| Content on this page is licensed under the Public Documentation License (PDL). |
