spectrumfasad.blogg.se

Openoffice conditional formatting contains letter
Openoffice conditional formatting contains letter







openoffice conditional formatting contains letter

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)

openoffice conditional formatting contains letter

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 conditional formatting contains letter