queryKey (NumberFormatString, LocalSettings, True ) If NumberFormatId = - 1 Then The characters are not rotated.Дim Doc As Object Dim Sheet As Object Dim Cell As Object Dim NumberFormats As Object Dim NumberFormatString As String Dim NumberFormatId As Long Dim LocalSettings As New com. The following example shows how you can 'stack' the contents of a cell so that the individual characters are printed one under another in the top left corner of the cell. RotateAngle (Long) angle of rotation of text in hundredths of a degree IsTextWrapped (Boolean) permits automatic line breaks within the cell Orientation (enum) orientation of text (value in accordance with .CellOrientation) VertJustify (enum) vertical justification of the text (value from .CellVertJustify) HoriJustify (enum) horizontal justification of the text (value from .CellHoriJustify) The following properties define the horizontal and vertical justification of a text: ShadowFormat = ShadowFormat JustificationДЄpache OpenOffice provides various functions that allow you to change the justification of a text in a table cell.

The following example writes the number 1000 to the cell B2, changes the background color to red using the CellBackColor property, and then creates a light gray shadow for the cell that is moved 1 mm to the left and down.Дim Doc As Object Dim Sheet As Object Dim Cell As Object Dim ShadowFormat As New com. IsTransparent (Boolean) sets the shadow to transparent ShadowWidth (Short) size of shadow in hundredths of a millimeter Location (enum) position of shadow (value from the .ShadowLocation structure). The .ShadowFormat structure and the detailed specifications for cell shadows have the following structure: ShadowFormat (struct) specifies the shadow for cells (structure in accordance with .ShadowFormat) IsCellBackgroundTransparent (Boolean) sets the background color to transparent The .CellProperties service provides the following properties for defining background colors and shadows:Д¬ellBackColor (Long) background color of the table cell VBAВ : The CellProperties object in the Apache OpenOffice API is comparable with the Interior object from VBA which also defines cell-specific properties.

Openoffice basic documentation