represents a single addressable cell in a spreadsheet document. More...
import"SheetCell.idl";
Inheritance diagram for SheetCell:
Included Services | |
| service | com::sun::star::table::Cell |
| provides basic cell handling and contributes common cell formatting properties. More... | |
| service | com::sun::star::text::Text |
| provides handling of formatted text cells. More... | |
| service | com::sun::star::style::CharacterProperties |
| contributes properties for character formatting of Western text. More... | |
| service | com::sun::star::style::CharacterPropertiesAsian |
| contributes properties for character formatting of Asian text. More... | |
| service | com::sun::star::style::CharacterPropertiesComplex |
| contributes properties for character formatting of Complex text. More... | |
| service | com::sun::star::style::ParagraphProperties |
| contributes properties for paragraph formatting. More... | |
| service | com::sun::star::style::ParagraphPropertiesAsian |
| contributes properties for paragraph formatting of Asian text. More... | |
| service | com::sun::star::style::ParagraphPropertiesComplex |
| contributes properties for paragraph formatting of Complex text. More... | |
| service | com::sun::star::sheet::SheetRangesQuery |
| provides interfaces to find cells with specific properties. More... | |
 Included Services inherited from Cell | |
| service | com::sun::star::table::CellProperties |
| contains the properties of the table cell. More... | |
Exported Interfaces | |
| interface | com::sun::star::document::XActionLockable |
| provides methods to lock and unlock the update between com::sun::star::table::XCell and com::sun::star::text::XText. More... | |
| interface | com::sun::star::util::XReplaceable |
| provides "Find and Replace" functionality. More... | |
| interface | com::sun::star::util::XIndent |
| provides modifying the cell indentation. More... | |
| interface | com::sun::star::table::XColumnRowRange |
| provides access to the collections of columns and rows. More... | |
| interface | com::sun::star::sheet::XCellAddressable |
| provides access to the cell address of this cell. More... | |
| interface | com::sun::star::sheet::XSheetAnnotationAnchor |
| provides access to the annotation attached to this cell. More... | |
| interface | com::sun::star::text::XTextFieldsSupplier |
| provides access to the text fields used in this cell. More... | |
| interface | com::sun::star::beans::XTolerantMultiPropertySet |
| interface | com::sun::star::util::XModifyBroadcaster |
| Exported Interfaces inherited from Cell | |
| interface | com::sun::star::table::XCell |
| provides access to the cell contents. More... | |
| interface | com::sun::star::text::XText |
| provides access to formatted and unformatted text contents. More... | |
| Exported Interfaces inherited from CellProperties | |
| interface | com::sun::star::beans::XPropertySet |
| published service PropertySet More... | |
| Exported Interfaces inherited from Text | |
| interface | com::sun::star::container::XEnumerationAccess |
| This is the factory for an enumeration of the paragraphs in this text. More... | |
| interface | XText |
| provides a cursor factory and the possibility to insert and remove contents. More... | |
| interface | XTextRangeCompare |
| optional interface to compare positions of TextRange instances within this text. More... | |
| interface | XTextRangeMover |
| makes it possible to change the position of paragraphs. More... | |
| interface | XRelativeTextContentInsert |
| makes it possible to insert a new text content, before or after existing text contents. More... | |
| Exported Interfaces inherited from SheetRangesQuery | |
| interface | com::sun::star::sheet::XCellRangesQuery |
| provides methods to query for cell ranges with specific contents. More... | |
| interface | com::sun::star::sheet::XFormulaQuery |
| provides methods to find dependent cells of formula cells. More... | |
Public Attributes | |
| com::sun::star::awt::Point | Position |
| contains the position of this cell in the sheet (in 1/100 mm). More... | |
| com::sun::star::awt::Size | Size |
| contains the size of this cell (in 1/100 mm). More... | |
| string | FormulaLocal |
| contains the formula string with localized function names. More... | |
| long | FormulaResultType |
| contains the content type of the cell. More... | |
| com::sun::star::sheet::XSheetConditionalEntries | ConditionalFormat |
| contains the conditional formatting settings for this cell. More... | |
| com::sun::star::sheet::XSheetConditionalEntries | ConditionalFormatLocal |
| contains the conditional formatting settings for this cell, using localized formulas. More... | |
| com::sun::star::beans::XPropertySet | Validation |
| contains the data validation settings for this cell. More... | |
| com::sun::star::beans::XPropertySet | ValidationLocal |
| contains the data validation settings for this cell, using localized formulas. More... | |
| string | AbsoluteName |
| Returns the absolute address of the range as string, e.g. More... | |
| com::sun::star::table::CellContentType | CellContentType |
| contains the content type of the cell. More... | |
| long | FormulaResultType2 |
| contains the result type of a formula. More... | |
| Public Attributes inherited from CellProperties | |
| string | CellStyle |
| contains the name of the style of the cell. More... | |
| com::sun::star::util::Color | CellBackColor |
| contains the cell background color. More... | |
| boolean | IsCellBackgroundTransparent |
is TRUE, if the cell background is transparent. More... | |
| com::sun::star::table::CellHoriJustify | HoriJustify |
| contains the horizontal alignment of the cell contents. More... | |
| long | VertJustify |
| contains the vertical alignment of the cell contents. More... | |
| boolean | IsTextWrapped |
is TRUE, if text in the cells will be wrapped automatically at the right border. More... | |
| short | ParaIndent |
| defines the indentation of the cell contents (in 1/100 mm). More... | |
| com::sun::star::table::CellOrientation | Orientation |
| contains the orientation of the cell contents. More... | |
| long | RotateAngle |
| defines how much the content of cells is rotated (in 1/100 degrees). More... | |
| long | RotateReference |
| defines at which edge rotated cells are aligned. More... | |
| boolean | AsianVerticalMode |
| selects Asian character orientation in vertical orientation. More... | |
| com::sun::star::table::TableBorder | TableBorder |
| contains a description of the cell or cell range border. More... | |
| com::sun::star::table::BorderLine | TopBorder |
| contains a description of the top border line of each cell. More... | |
| com::sun::star::table::BorderLine | BottomBorder |
| contains a description of the bottom border line of each cell. More... | |
| com::sun::star::table::BorderLine | LeftBorder |
| contains a description of the left border line of each cell. More... | |
| com::sun::star::table::BorderLine | RightBorder |
| contains a description of the right border line of each cell. More... | |
| long | NumberFormat |
| contains the index of the number format that is used in the cells. More... | |
| com::sun::star::table::ShadowFormat | ShadowFormat |
| contains a description of the shadow. More... | |
| com::sun::star::util::CellProtection | CellProtection |
| contains a description of the cell protection. More... | |
| com::sun::star::container::XNameContainer | UserDefinedAttributes |
| stores additional attributes. More... | |
| com::sun::star::table::BorderLine | DiagonalTLBR |
| contains a description of the top left to bottom right diagonal line of each cell. More... | |
| com::sun::star::table::BorderLine | DiagonalBLTR |
| contains a description of the bottom left to top right diagonal line of each cell. More... | |
| boolean | ShrinkToFit |
is TRUE, if the cell content will be shrunk to fit in the cell. More... | |
| com::sun::star::table::TableBorder2 | TableBorder2 |
| contains a description of the cell or cell range border. More... | |
| com::sun::star::table::BorderLine2 | TopBorder2 |
| contains a description of the top border line of each cell. More... | |
| com::sun::star::table::BorderLine2 | BottomBorder2 |
| contains a description of the bottom border line of each cell. More... | |
| com::sun::star::table::BorderLine2 | LeftBorder2 |
| contains a description of the left border line of each cell. More... | |
| com::sun::star::table::BorderLine2 | RightBorder2 |
| contains a description of the right border line of each cell. More... | |
| com::sun::star::table::BorderLine2 | DiagonalTLBR2 |
| contains a description of the top left to bottom right diagonal line of each cell. More... | |
| com::sun::star::table::BorderLine2 | DiagonalBLTR2 |
| contains a description of the bottom left to top right diagonal line of each cell. More... | |
| Public Attributes inherited from Text | |
| ::com::sun::star::beans::PropertyValues | StartRedline |
| contains the properties of a redline at the start of the document. More... | |
| ::com::sun::star::beans::PropertyValues | EndRedline |
| contains the properties of a redline at the start of the document. More... | |
| Public Attributes inherited from CharacterProperties | |
| string | CharFontName |
| This property specifies the name of the font style. More... | |
| string | CharFontStyleName |
| This property contains the name of the font style. More... | |
| short | CharFontFamily |
| This property contains font family. More... | |
| short | CharFontCharSet |
| This property contains the text encoding of the font. More... | |
| short | CharFontPitch |
| This property contains the font pitch. More... | |
| com::sun::star::util::Color | CharColor |
| This property contains the value of the text color. More... | |
| short | CharEscapement |
| specifies the percentage by which to raise/lower superscript/subscript characters. More... | |
| float | CharHeight |
| This value contains the height of the characters in point. More... | |
| short | CharUnderline |
| This property contains the value for the character underline. More... | |
| float | CharWeight |
| This property contains the value of the font weight. More... | |
| com::sun::star::awt::FontSlant | CharPosture |
| This property contains the value of the posture of the document. More... | |
| boolean | CharAutoKerning |
| This optional property determines whether the kerning tables from the current font are used. More... | |
| com::sun::star::util::Color | CharBackColor |
| This optional property contains the text background color. More... | |
| long | CharShadingValue |
| This optional property contains the text shading value. More... | |
| boolean | CharBackTransparent |
| This property determines if the text background color is set to transparent. More... | |
| short | CharCaseMap |
| This optional property contains the value of the case-mapping of the text for formatting and displaying. More... | |
| boolean | CharCrossedOut |
This property is TRUE if the characters are crossed out. More... | |
| boolean | CharFlash |
If this optional property is TRUE, then the characters are flashing. More... | |
| short | CharStrikeout |
| This property determines the type of the strike out of the character. More... | |
| boolean | CharWordMode |
If this property is TRUE, the underline and strike-through properties are not applied to white spaces. More... | |
| short | CharKerning |
| This optional property contains the value of the kerning of the characters. More... | |
| com::sun::star::lang::Locale | CharLocale |
| This property contains the value of the locale. More... | |
| boolean | CharKeepTogether |
| This optional property marks a range of characters to prevent it from being broken into two lines. More... | |
| boolean | CharNoLineBreak |
| This optional property marks a range of characters to ignore a line break in this area. More... | |
| boolean | CharShadowed |
| This optional property specifies if the characters are formatted and displayed with a shadow effect. More... | |
| short | CharFontType |
| This optional property specifies the fundamental technology of the font. More... | |
| string | CharStyleName |
| This optional property specifies the name of the style of the font. More... | |
| boolean | CharContoured |
| This optional property specifies if the characters are formatted and displayed with a contour effect. More... | |
| boolean | CharCombineIsOn |
| This optional property determines whether text is formatted in two lines. More... | |
| string | CharCombinePrefix |
| This optional property contains the prefix (usually parenthesis) before text that is formatted in two lines. More... | |
| string | CharCombineSuffix |
| This optional property contains the suffix (usually parenthesis) after text that is formatted in two lines. More... | |
| short | CharEmphasis |
| This optional property contains the font emphasis value. More... | |
| short | CharRelief |
| This optional property contains the relief style of the characters. More... | |
| string | RubyText |
| This optional property contains the text that is set as ruby. More... | |
| short | RubyAdjust |
| This optional property determines the adjustment of the ruby . More... | |
| string | RubyCharStyleName |
| This optional property contains the name of the character style that is applied to RubyText. More... | |
| boolean | RubyIsAbove |
| This optional property determines whether the ruby text is printed above/left or below/right of the text. More... | |
| short | CharRotation |
| This optional property determines the rotation of a character in tenths of a degree. More... | |
| boolean | CharRotationIsFitToLine |
| This optional property determines whether the text formatting tries to fit rotated text into the surrounded line height. More... | |
| short | CharScaleWidth |
| This optional property determines the percentage value for scaling the width of characters. More... | |
| string | HyperLinkURL |
| This optional property contains the URL of a hyperlink. More... | |
| string | HyperLinkTarget |
| This optional property contains the name of the target for a hyperlink. More... | |
| string | HyperLinkName |
| This optional property contains the name of the hyperlink. More... | |
| string | VisitedCharStyleName |
| This optional property contains the character style name for visited hyperlinks. More... | |
| string | UnvisitedCharStyleName |
| This optional property contains the character style name for unvisited hyperlinks. More... | |
| byte | CharEscapementHeight |
| This is the relative height used for subscript or superscript characters in units of percent. More... | |
| boolean | CharNoHyphenation |
| This optional property determines if the word can be hyphenated at the character. More... | |
| com::sun::star::util::Color | CharUnderlineColor |
| This property contains the color of the underline for the characters. More... | |
| boolean | CharUnderlineHasColor |
| This property specifies if the property CharUnderlineColor is used for an underline. More... | |
| boolean | CharHidden |
If this optional property is TRUE, then the characters are invisible. More... | |
| com::sun::star::container::XNameContainer | TextUserDefinedAttributes |
| This property stores XML attributes. More... | |
| com::sun::star::table::BorderLine2 | CharLeftBorder |
| This property contains the left border of the object. More... | |
| com::sun::star::table::BorderLine2 | CharRightBorder |
| This property contains the right border of the object. More... | |
| com::sun::star::table::BorderLine2 | CharTopBorder |
| This property contains the top border of the object. More... | |
| com::sun::star::table::BorderLine2 | CharBottomBorder |
| This property contains the bottom border of the object. More... | |
| long | CharBorderDistance |
| This property contains the distance from the border to the object. More... | |
| long | CharLeftBorderDistance |
| This property contains the distance from the left border to the object. More... | |
| long | CharRightBorderDistance |
| This property contains the distance from the right border to the object. More... | |
| long | CharTopBorderDistance |
| This property contains the distance from the top border to the object. More... | |
| long | CharBottomBorderDistance |
| This property contains the distance from the bottom border to the object. More... | |
| com::sun::star::table::ShadowFormat | CharShadowFormat |
| Determines the type, color, and width of the shadow. More... | |
| com::sun::star::util::Color | CharHighlight |
| Determines the color of the highlight. More... | |
| short | RubyPosition |
| This optional property determines the position of the ruby . More... | |
| short | CharTransparence |
| This is the transparency of the character text. More... | |
| short | CharColorTheme |
| If available, keeps the color theme index, so that the character can be re-colored easily based on a theme. More... | |
| short | CharColorTintOrShade |
| Tint or shade of the character color. More... | |
| Public Attributes inherited from CharacterPropertiesAsian | |
| float | CharHeightAsian |
| This value contains the height of the characters in point. More... | |
| float | CharWeightAsian |
| This property contains the value of the font weight. More... | |
| string | CharFontNameAsian |
| This property specifies the name of the font style. More... | |
| string | CharFontStyleNameAsian |
| This property contains the name of the font style. More... | |
| short | CharFontFamilyAsian |
| This property contains font family as specified in com.sun.star.awt.FontFamily . More... | |
| short | CharFontCharSetAsian |
| This property contains the text encoding of the font as specified in com.sun.star.awt.CharSet. More... | |
| short | CharFontPitchAsian |
| This property contains the font pitch as specified in com.sun.star.awt.FontPitch. More... | |
| com::sun::star::awt::FontSlant | CharPostureAsian |
| This property contains the value of the posture of the document. More... | |
| com::sun::star::lang::Locale | CharLocaleAsian |
| contains the value of the locale. More... | |
| Public Attributes inherited from CharacterPropertiesComplex | |
| float | CharHeightComplex |
| This value contains the height of the characters in point. More... | |
| float | CharWeightComplex |
| This property contains the value of the font weight. More... | |
| string | CharFontNameComplex |
| This property specifies the name of the font style. More... | |
| string | CharFontStyleNameComplex |
| This property contains the name of the font style. More... | |
| short | CharFontFamilyComplex |
| This property contains font family as specified in com.sun.star.awt.FontFamily . More... | |
| short | CharFontCharSetComplex |
| This property contains the text encoding of the font as specified in com.sun.star.awt.CharSet. More... | |
| short | CharFontPitchComplex |
| This property contains the font pitch as specified in com.sun.star.awt.FontPitch. More... | |
| com::sun::star::awt::FontSlant | CharPostureComplex |
| This property contains the value of the posture of the document. More... | |
| com::sun::star::lang::Locale | CharLocaleComplex |
| contains the value of the locale. More... | |
| Public Attributes inherited from ParagraphProperties | |
| com::sun::star::style::ParagraphAdjust | ParaAdjust |
| determines the adjustment of a paragraph. More... | |
| com::sun::star::style::LineSpacing | ParaLineSpacing |
| contains the type of the line spacing of a paragraph. More... | |
| com::sun::star::util::Color | ParaBackColor |
| contains the paragraph background color. More... | |
| boolean | ParaBackTransparent |
This value is TRUE if the paragraph background color is set to transparent. More... | |
| string | ParaBackGraphicURL |
| contains the value of a link for the background graphic of a paragraph. More... | |
| string | ParaBackGraphicFilter |
| contains the name of the graphic filter for the background graphic of a paragraph. More... | |
| com::sun::star::style::GraphicLocation | ParaBackGraphicLocation |
| contains the value for the position of a background graphic. More... | |
| short | ParaLastLineAdjust |
| determines the adjustment of the last line. More... | |
| boolean | ParaExpandSingleWord |
| determines if single words are stretched. More... | |
| long | ParaLeftMargin |
| determines the left margin of the paragraph in 100th mm. More... | |
| long | ParaRightMargin |
| determines the right margin of the paragraph in 100th mm. More... | |
| long | ParaTopMargin |
| determines the top margin of the paragraph in 100th mm. More... | |
| long | ParaBottomMargin |
| determines the bottom margin of the paragraph in 100th mm. More... | |
| boolean | ParaContextMargin |
| determines if contextual spacing is used. More... | |
| boolean | ParaLineNumberCount |
| determines if the paragraph is included in the line numbering. More... | |
| long | ParaLineNumberStartValue |
| contains the start value for the line numbering. More... | |
| string | PageDescName |
| If this property is set, it creates a page break before the paragraph it belongs to and assigns the value as the name of the new page style sheet to use. More... | |
| short | PageNumberOffset |
| If a page break property is set at a paragraph, this property contains the new value for the page number. More... | |
| boolean | ParaRegisterModeActive |
| determines if the register mode is applied to a paragraph. More... | |
| string | ParaStyleName |
| contains the name of the current paragraph style. More... | |
| string | PageStyleName |
| contains the name of the current page style. More... | |
| com::sun::star::style::DropCapFormat | DropCapFormat |
| specifies whether the first characters of the paragraph are displayed in capital letters and how they are formatted. More... | |
| boolean | DropCapWholeWord |
| specifies if the property DropCapFormat is applied to the whole first word. More... | |
| boolean | ParaKeepTogether |
Setting this property to TRUE prevents page or column breaks between this and the following paragraph. More... | |
| boolean | ParaSplit |
Setting this property to FALSE prevents the paragraph from getting split into two pages or columns. More... | |
| short | NumberingLevel |
| specifies the numbering level of the paragraph. More... | |
| com::sun::star::container::XIndexReplace | NumberingRules |
| contains the numbering rules applied to this paragraph. More... | |
| short | NumberingStartValue |
| specifies the start value for numbering if a new numbering starts at this paragraph. More... | |
| boolean | ParaIsNumberingRestart |
| determines if the numbering rules restart, counting at the current paragraph. More... | |
| string | NumberingStyleName |
| specifies the name of the style for the numbering. More... | |
| byte | ParaOrphans |
| specifies the minimum number of lines of the paragraph that have to be at bottom of a page if the paragraph is spread over more than one page. More... | |
| byte | ParaWidows |
| specifies the minimum number of lines of the paragraph that have to be at top of a page if the paragraph is spread over more than one page. More... | |
| com::sun::star::table::ShadowFormat | ParaShadowFormat |
| determines the type, color, and size of the shadow. More... | |
| com::sun::star::table::BorderLine | LeftBorder |
| contains the left border of the object. More... | |
| com::sun::star::table::BorderLine | RightBorder |
| contains the right border of the object. More... | |
| com::sun::star::table::BorderLine | TopBorder |
| contains the top border of the object. More... | |
| com::sun::star::table::BorderLine | BottomBorder |
| contains the bottom border of the object. More... | |
| long | BorderDistance |
| contains the distance from the border to the object. More... | |
| long | LeftBorderDistance |
| contains the distance from the left border to the object. More... | |
| long | RightBorderDistance |
| contains the distance from the right border to the object. More... | |
| long | TopBorderDistance |
| contains the distance from the top border to the object. More... | |
| long | BottomBorderDistance |
| contains the distance from the bottom border to the object. More... | |
| com::sun::star::style::BreakType | BreakType |
| determines the type of break that is applied at the beginning of the table. More... | |
| string | DropCapCharStyleName |
| specifies the character style name for drop caps. More... | |
| long | ParaFirstLineIndent |
| specifies the indent for the first line. More... | |
| boolean | ParaIsAutoFirstLineIndent |
| determines if the first line should be indented automatically. More... | |
| boolean | ParaIsHyphenation |
| specifies if automatic hyphenation is applied. More... | |
| short | ParaHyphenationMaxHyphens |
| specifies the maximum number of consecutive hyphens. More... | |
| short | ParaHyphenationMaxLeadingChars |
| specifies the minimum number of characters to remain before the hyphen character (when hyphenation is applied). More... | |
| short | ParaHyphenationMaxTrailingChars |
| specifies the minimum number of characters to remain after the hyphen character (when hyphenation is applied). More... | |
| short | ParaVertAlignment |
| specifies the vertical alignment of a paragraph. More... | |
| com::sun::star::container::XNameContainer | ParaUserDefinedAttributes |
| this property stores xml attributes. More... | |
| boolean | NumberingIsNumber |
returns FALSE if the paragraph is part of a numbering, but has no numbering label. More... | |
| boolean | ParaIsConnectBorder |
| the property determines if borders set at a paragraph are merged with the next paragraph. More... | |
| string | ListId |
| specifies the id of the list to which the paragraph belongs More... | |
| short | OutlineLevel |
| specifies the outline level to which the paragraph belongs More... | |
| com::sun::star::graphic::XGraphic | ParaBackGraphic |
| contains the graphic for the background of a paragraph. More... | |
| boolean | ContinueingPreviousSubTree |
| specifies that a child node of a parent node that is not counted is continuing the numbering of parent's previous node's sub tree. More... | |
| string | ListLabelString |
| allows reading the generated numbering list label. More... | |
| boolean | ParaHyphenationNoCaps |
| Specifies whether words written in CAPS will be hyphenated. More... | |
| boolean | ParaHyphenationNoLastWord |
| Specifies whether last word of paragraph will be hyphenated. More... | |
| short | ParaHyphenationMinWordLength |
| specifies the minimum word length in characters, when hyphenation is applied. More... | |
| long | ParaHyphenationZone |
| specifies the hyphenation zone, i.e. More... | |
Additional Inherited Members | |
| Public Types inherited from CellProperties | |
| typedef sequence< com::sun::star::beans::PropertyValue > | CellInteropGrabBag |
| Grab bag of cell properties, used as a string-any map for interim interop purposes. More... | |
| Public Types inherited from CharacterProperties | |
| typedef sequence< string > | CharStyleNames |
| This optional property specifies the names of the all styles applied to the font. More... | |
| typedef sequence< com::sun::star::beans::PropertyValue > | CharInteropGrabBag |
| Grab bag of character properties, used as a string-any map for interim interop purposes. More... | |
| Public Types inherited from ParagraphProperties | |
| typedef sequence< com::sun::star::beans::PropertyValue > | ParaInteropGrabBag |
| Grab bag of paragraph properties, used as a string-any map for interim interop purposes. More... | |
| typedef sequence< com::sun::star::style::TabStop > | ParaTabStops |
| specifies the positions and kinds of the tab stops within this paragraph. More... | |
| Public Member Functions inherited from XPropertySet | |
| com::sun::star::beans::XPropertySetInfo | getPropertySetInfo () |
| void | setPropertyValue ([in] string aPropertyName, [in] any aValue) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::beans::PropertyVetoException, com::sun::star::lang::IllegalArgumentException, com::sun::star::lang::WrappedTargetException ) |
| sets the value of the property with the specified name. More... | |
| any | getPropertyValue ([in] string PropertyName) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException ) |
| void | addPropertyChangeListener ([in] string aPropertyName, [in] com::sun::star::beans::XPropertyChangeListener xListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException ) |
| adds an XPropertyChangeListener to the specified property. More... | |
| void | removePropertyChangeListener ([in] string aPropertyName, [in] com::sun::star::beans::XPropertyChangeListener aListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException ) |
| removes an XPropertyChangeListener from the listener list. More... | |
| void | addVetoableChangeListener ([in] string PropertyName, [in] com::sun::star::beans::XVetoableChangeListener aListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException ) |
| adds an XVetoableChangeListener to the specified property with the name PropertyName. More... | |
| void | removeVetoableChangeListener ([in] string PropertyName, [in] com::sun::star::beans::XVetoableChangeListener aListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException ) |
| removes an XVetoableChangeListener from the listener list. More... | |
| Public Member Functions inherited from XInterface | |
| any | queryInterface ([in] type aType) |
| queries for a new interface to an existing UNO object. More... | |
| void | acquire () |
| increases the reference counter by one. More... | |
| void | release () |
| decreases the reference counter by one. More... | |
| Public Member Functions inherited from XCell | |
| string | getFormula () |
| returns the formula string of a cell. More... | |
| void | setFormula ([in] string aFormula) |
| sets a formula into the cell. More... | |
| double | getValue () |
| returns the floating point value of the cell. More... | |
| void | setValue ([in] double nValue) |
| sets a floating point value into the cell. More... | |
| com::sun::star::table::CellContentType | getType () |
| returns the type of the cell. More... | |
| long | getError () |
| returns the error value of the cell. More... | |
| Public Member Functions inherited from XText | |
| void | insertTextContent ([in] com::sun::star::text::XTextRange xRange, [in] com::sun::star::text::XTextContent xContent, [in] boolean bAbsorb) raises ( com::sun::star::lang::IllegalArgumentException ) |
| inserts a content, such as a text table, text frame or text field. More... | |
| void | removeTextContent ([in] com::sun::star::text::XTextContent xContent) raises ( com::sun::star::container::NoSuchElementException ) |
| removes the specified content from the text object. More... | |
| Public Member Functions inherited from XSimpleText | |
| com::sun::star::text::XTextCursor | createTextCursor () |
| com::sun::star::text::XTextCursor | createTextCursorByRange ([in] com::sun::star::text::XTextRange aTextPosition) |
| void | insertString ([in] com::sun::star::text::XTextRange xRange, [in] string aString, [in] boolean bAbsorb) |
| inserts a string of characters into the text. More... | |
| void | insertControlCharacter ([in] com::sun::star::text::XTextRange xRange, [in] short nControlCharacter, [in] boolean bAbsorb) raises ( com::sun::star::lang::IllegalArgumentException ) |
| inserts a control character (like a paragraph break or a hard space) into the text. More... | |
| Public Member Functions inherited from XTextRange | |
| XText | getText () |
| XTextRange | getStart () |
| XTextRange | getEnd () |
| string | getString () |
| void | setString ([in] string aString) |
| the whole string of characters of this piece of text is replaced. More... | |
| Public Member Functions inherited from XEnumerationAccess | |
| com::sun::star::container::XEnumeration | createEnumeration () |
| Public Member Functions inherited from XElementAccess | |
| type | getElementType () |
| boolean | hasElements () |
| Public Member Functions inherited from XCellRangesQuery | |
| com::sun::star::sheet::XSheetCellRanges | queryVisibleCells () |
| queries all visible cells. More... | |
| com::sun::star::sheet::XSheetCellRanges | queryEmptyCells () |
| queries all empty cells. More... | |
| com::sun::star::sheet::XSheetCellRanges | queryContentCells ([in] short nContentFlags) |
| queries all cells with the specified content type(s). More... | |
| com::sun::star::sheet::XSheetCellRanges | queryFormulaCells ([in] long nResultFlags) |
| queries all formula cells with the specified result type. More... | |
| com::sun::star::sheet::XSheetCellRanges | queryColumnDifferences ([in] com::sun::star::table::CellAddress aCompare) |
| queries all cells with different values in a specified row. More... | |
| com::sun::star::sheet::XSheetCellRanges | queryRowDifferences ([in] com::sun::star::table::CellAddress aCompare) |
| queries all cells with different values in a specified column. More... | |
| com::sun::star::sheet::XSheetCellRanges | queryIntersection ([in] com::sun::star::table::CellRangeAddress aRange) |
| intersects the current cell range(s) with the specified cell range. More... | |
| Public Member Functions inherited from XFormulaQuery | |
| com::sun::star::sheet::XSheetCellRanges | queryDependents ([in] boolean bRecursive) |
| queries all dependent formula cells. More... | |
| com::sun::star::sheet::XSheetCellRanges | queryPrecedents ([in] boolean bRecursive) |
| queries all precedent cells. More... | |
| Public Member Functions inherited from XActionLockable | |
| boolean | isActionLocked () |
| void | addActionLock () |
| increments the lock count of the object by one. More... | |
| void | removeActionLock () |
| decrements the lock count of the object by one. More... | |
| void | setActionLocks ([in] short nLock) |
| sets the locking level. More... | |
| short | resetActionLocks () |
| resets the locking level. More... | |
| Public Member Functions inherited from XReplaceable | |
| com::sun::star::util::XReplaceDescriptor | createReplaceDescriptor () |
| creates a descriptor which contains properties that specify a search in this container. More... | |
| long | replaceAll ([in] com::sun::star::util::XSearchDescriptor xDesc) |
| searches for all occurrences of whatever is specified. More... | |
| Public Member Functions inherited from XSearchable | |
| com::sun::star::util::XSearchDescriptor | createSearchDescriptor () |
| creates a SearchDescriptor which contains properties that specify a search in this container. More... | |
| com::sun::star::container::XIndexAccess | findAll ([in] com::sun::star::util::XSearchDescriptor xDesc) |
| searches the contained texts for all occurrences of whatever is specified. More... | |
| com::sun::star::uno::XInterface | findFirst ([in] com::sun::star::util::XSearchDescriptor xDesc) |
| searches the contained texts for the next occurrence of whatever is specified. More... | |
| com::sun::star::uno::XInterface | findNext ([in] com::sun::star::uno::XInterface xStartAt, [in] com::sun::star::util::XSearchDescriptor xDesc) |
| searches the contained texts for the next occurrence of whatever is specified. More... | |
| Public Member Functions inherited from XIndent | |
| void | decrementIndent () |
| shifts the indentation by one default step to the left. More... | |
| void | incrementIndent () |
| shifts the indentation by one default step to the right. More... | |
| Public Member Functions inherited from XColumnRowRange | |
| com::sun::star::table::XTableColumns | getColumns () |
| returns the collection of columns in the range. More... | |
| com::sun::star::table::XTableRows | getRows () |
| returns the collection of rows in the range. More... | |
| Public Member Functions inherited from XCellAddressable | |
| com::sun::star::table::CellAddress | getCellAddress () |
| returns the address of the cell in the spreadsheet document. More... | |
| Public Member Functions inherited from XSheetAnnotationAnchor | |
| com::sun::star::sheet::XSheetAnnotation | getAnnotation () |
| returns the annotation at this anchor. More... | |
| Public Member Functions inherited from XTextFieldsSupplier | |
| com::sun::star::container::XEnumerationAccess | getTextFields () |
| com::sun::star::container::XNameAccess | getTextFieldMasters () |
| Protected Member Functions inherited from XTextRangeCompare | |
| short | compareRegionStarts ([in] XTextRange xR1, [in] XTextRange xR2) raises ( com::sun::star::lang::IllegalArgumentException ) |
| short | compareRegionEnds ([in] XTextRange xR1, [in] XTextRange xR2) raises ( com::sun::star::lang::IllegalArgumentException ) |
| Protected Member Functions inherited from XTextRangeMover | |
| void | moveTextRange ([in] com::sun::star::text::XTextRange xRange, [in] short nParagraphs) |
| moves the contents to which xRange refers forward or backward. More... | |
| Protected Member Functions inherited from XRelativeTextContentInsert | |
| void | insertTextContentBefore ([in] XTextContent xNewContent, [in] XTextContent xSuccessor) raises ( com::sun::star::lang::IllegalArgumentException ) |
| inserts text the new text content before of the successor argument. More... | |
| void | insertTextContentAfter ([in] XTextContent xNewContent, [in] XTextContent xPredecessor) raises ( com::sun::star::lang::IllegalArgumentException ) |
| inserts text the new text content after the predecessor argument. More... | |
| Protected Member Functions inherited from XCellRangesQuery | |
| com::sun::star::sheet::XSheetCellRanges | queryVisibleCells () |
| queries all visible cells. More... | |
| com::sun::star::sheet::XSheetCellRanges | queryEmptyCells () |
| queries all empty cells. More... | |
| com::sun::star::sheet::XSheetCellRanges | queryContentCells ([in] short nContentFlags) |
| queries all cells with the specified content type(s). More... | |
| com::sun::star::sheet::XSheetCellRanges | queryFormulaCells ([in] long nResultFlags) |
| queries all formula cells with the specified result type. More... | |
| com::sun::star::sheet::XSheetCellRanges | queryColumnDifferences ([in] com::sun::star::table::CellAddress aCompare) |
| queries all cells with different values in a specified row. More... | |
| com::sun::star::sheet::XSheetCellRanges | queryRowDifferences ([in] com::sun::star::table::CellAddress aCompare) |
| queries all cells with different values in a specified column. More... | |
| com::sun::star::sheet::XSheetCellRanges | queryIntersection ([in] com::sun::star::table::CellRangeAddress aRange) |
| intersects the current cell range(s) with the specified cell range. More... | |
| Protected Member Functions inherited from XFormulaQuery | |
| com::sun::star::sheet::XSheetCellRanges | queryDependents ([in] boolean bRecursive) |
| queries all dependent formula cells. More... | |
| com::sun::star::sheet::XSheetCellRanges | queryPrecedents ([in] boolean bRecursive) |
| queries all precedent cells. More... | |
| Protected Member Functions inherited from XActionLockable | |
| boolean | isActionLocked () |
| void | addActionLock () |
| increments the lock count of the object by one. More... | |
| void | removeActionLock () |
| decrements the lock count of the object by one. More... | |
| void | setActionLocks ([in] short nLock) |
| sets the locking level. More... | |
| short | resetActionLocks () |
| resets the locking level. More... | |
| Protected Member Functions inherited from XReplaceable | |
| com::sun::star::util::XReplaceDescriptor | createReplaceDescriptor () |
| creates a descriptor which contains properties that specify a search in this container. More... | |
| long | replaceAll ([in] com::sun::star::util::XSearchDescriptor xDesc) |
| searches for all occurrences of whatever is specified. More... | |
| Protected Member Functions inherited from XSearchable | |
| com::sun::star::util::XSearchDescriptor | createSearchDescriptor () |
| creates a SearchDescriptor which contains properties that specify a search in this container. More... | |
| com::sun::star::container::XIndexAccess | findAll ([in] com::sun::star::util::XSearchDescriptor xDesc) |
| searches the contained texts for all occurrences of whatever is specified. More... | |
| com::sun::star::uno::XInterface | findFirst ([in] com::sun::star::util::XSearchDescriptor xDesc) |
| searches the contained texts for the next occurrence of whatever is specified. More... | |
| com::sun::star::uno::XInterface | findNext ([in] com::sun::star::uno::XInterface xStartAt, [in] com::sun::star::util::XSearchDescriptor xDesc) |
| searches the contained texts for the next occurrence of whatever is specified. More... | |
| Protected Member Functions inherited from XIndent | |
| void | decrementIndent () |
| shifts the indentation by one default step to the left. More... | |
| void | incrementIndent () |
| shifts the indentation by one default step to the right. More... | |
| Protected Member Functions inherited from XColumnRowRange | |
| com::sun::star::table::XTableColumns | getColumns () |
| returns the collection of columns in the range. More... | |
| com::sun::star::table::XTableRows | getRows () |
| returns the collection of rows in the range. More... | |
| Protected Member Functions inherited from XCellAddressable | |
| com::sun::star::table::CellAddress | getCellAddress () |
| returns the address of the cell in the spreadsheet document. More... | |
| Protected Member Functions inherited from XSheetAnnotationAnchor | |
| com::sun::star::sheet::XSheetAnnotation | getAnnotation () |
| returns the annotation at this anchor. More... | |
| Protected Member Functions inherited from XTextFieldsSupplier | |
| com::sun::star::container::XEnumerationAccess | getTextFields () |
| com::sun::star::container::XNameAccess | getTextFieldMasters () |
| Protected Member Functions inherited from XTolerantMultiPropertySet | |
| sequence< com::sun::star::beans::SetPropertyTolerantFailed > | setPropertyValuesTolerant ([in] sequence< string > aPropertyNames, [in] sequence< any > aValues) raises ( com::sun::star::lang::IllegalArgumentException ) |
| sets the values to the properties with the specified names. More... | |
| sequence< com::sun::star::beans::GetPropertyTolerantResult > | getPropertyValuesTolerant ([in] sequence< string > aPropertyNames) |
| retrieve the values of the specified properties More... | |
| sequence< com::sun::star::beans::GetDirectPropertyTolerantResult > | getDirectPropertyValuesTolerant ([in] sequence< string > aPropertyNames) |
| retrieve only those values of the specified properties which are direct values. More... | |
| Protected Member Functions inherited from XModifyBroadcaster | |
| void | addModifyListener ([in] com::sun::star::util::XModifyListener aListener) |
| adds the specified listener to receive events "modified." More... | |
| void | removeModifyListener ([in] com::sun::star::util::XModifyListener aListener) |
| removes the specified listener. More... | |
| Protected Attributes inherited from ParagraphPropertiesAsian | |
| boolean | ParaIsHangingPunctuation |
| determines if hanging punctuation is allowed. More... | |
| boolean | ParaIsCharacterDistance |
| determines if a distance between Asian text, western text or complex text is set. More... | |
| boolean | ParaIsForbiddenRules |
| determines if the rules for forbidden characters at the start or end of text lines are considered. More... | |
| Protected Attributes inherited from ParagraphPropertiesComplex | |
| short | WritingMode |
| contains the writing direction, as represented by the com::sun::star::text::WritingMode2 constants More... | |
Detailed Description
represents a single addressable cell in a spreadsheet document.
Exported Interfaces
◆ com::sun::star::sheet::SheetRangesQuery
provides interfaces to find cells with specific properties.
◆ com::sun::star::style::CharacterProperties
contributes properties for character formatting of Western text.
◆ com::sun::star::style::CharacterPropertiesAsian
contributes properties for character formatting of Asian text.
◆ com::sun::star::style::CharacterPropertiesComplex
contributes properties for character formatting of Complex text.
◆ com::sun::star::style::ParagraphProperties
contributes properties for paragraph formatting.
◆ com::sun::star::style::ParagraphPropertiesAsian
|
optional |
contributes properties for paragraph formatting of Asian text.
◆ com::sun::star::style::ParagraphPropertiesComplex
|
optional |
contributes properties for paragraph formatting of Complex text.
◆ com::sun::star::table::Cell
| service com::sun::star::table::Cell |
provides basic cell handling and contributes common cell formatting properties.
◆ com::sun::star::text::Text
| service com::sun::star::text::Text |
provides handling of formatted text cells.
Exported Interfaces
◆ com::sun::star::beans::XTolerantMultiPropertySet
|
optional |
◆ com::sun::star::document::XActionLockable
provides methods to lock and unlock the update between com::sun::star::table::XCell and com::sun::star::text::XText.
◆ com::sun::star::sheet::XCellAddressable
| interface com::sun::star::sheet::XCellAddressable |
provides access to the cell address of this cell.
◆ com::sun::star::sheet::XSheetAnnotationAnchor
provides access to the annotation attached to this cell.
◆ com::sun::star::table::XColumnRowRange
| interface com::sun::star::table::XColumnRowRange |
provides access to the collections of columns and rows.
◆ com::sun::star::text::XTextFieldsSupplier
provides access to the text fields used in this cell.
With com::sun::star::text::XTextFieldsSupplier::getTextFieldMasters always returns void since the field master is not supported.
◆ com::sun::star::util::XIndent
| interface com::sun::star::util::XIndent |
provides modifying the cell indentation.
◆ com::sun::star::util::XModifyBroadcaster
|
optional |
- Since
- OOo 2.0
◆ com::sun::star::util::XReplaceable
| interface com::sun::star::util::XReplaceable |
provides "Find and Replace" functionality.
The property com::sun::star::util::SearchDescriptor::SearchWords has a different meaning in spreadsheets: If set to TRUE, the spreadsheet searches for cells containing the search text only.
Member Data Documentation
◆ AbsoluteName
|
optionalpropertyreadonly |
Returns the absolute address of the range as string, e.g.
"$Sheet1.$B$2".
◆ CellContentType
|
optionalpropertyreadonly |
contains the content type of the cell.
- Since
- LibreOffice 6.1
◆ ConditionalFormat
contains the conditional formatting settings for this cell.
After a conditional format has been changed it has to be reinserted into the property set.
◆ ConditionalFormatLocal
|
optionalproperty |
contains the conditional formatting settings for this cell, using localized formulas.
After a conditional format has been changed it has to be reinserted into the property set.
◆ FormulaLocal
|
optionalproperty |
contains the formula string with localized function names.
This property can also be used to set a new localized formula.
◆ FormulaResultType
|
propertyreadonly |
contains the content type of the cell.
This property returns not com::sun::star::sheet::FormulaResult but instead com::sun::star::table::CellContentType. Use FormulaResult2 if the correct property is needed.
◆ FormulaResultType2
|
optionalpropertyreadonly |
contains the result type of a formula.
- Since
- LibreOffice 6.1
◆ Position
|
propertyreadonly |
contains the position of this cell in the sheet (in 1/100 mm).
This property contains the absolute position in the whole sheet, not the position in the visible area.
◆ Size
|
propertyreadonly |
contains the size of this cell (in 1/100 mm).
◆ Validation
|
property |
contains the data validation settings for this cell.
After the data validation settings have been changed the validation has to be reinserted into the property set.
◆ ValidationLocal
|
optionalproperty |
contains the data validation settings for this cell, using localized formulas.
After the data validation settings have been changed the validation has to be reinserted into the property set.
The documentation for this service was generated from the following file:
- com/sun/star/sheet/SheetCell.idl
