Height = 14800 Page Margin, Border, and Shadow getByName ( "PageStyles" )ĭefPage = PageStyles.
The following example sets the page size of the "Default" page style to the DIN A5 landscape format (height 14.8 cm, width 21 cm):ĭim Doc As Object Dim Sheet As Object Dim StyleFamilies As Object Dim PageStyles As Object Dim DefPage As Object PrinterPaperTray (String) name of the printer paper tray that you want to use Height (long) height of page in hundredths of a millimeter Width (long) width of page in hundredths of a millimeter The page format is defined using the following properties of the .PageProperties service: The .PageProperties service defines the following properties of a pages background:īackGraphicURL (String) URL of the background graphics that you want to useīackGraphicFilter (String) name of the filter for interpreting the background graphicsīackGraphicLocation (Enum) position of the background graphics (value according to enumeration)īackTransparent (Boolean) makes the background transparent In Apache OpenOffice, these properties are defined using a page style which in turn is linked to the associated document. VBA : The page properties (page margins, borders, and so on) for a Microsoft Office document are defined by means of a PageSetup object at the Worksheet object (Excel) or Document object (Word) level. The page properties that only apply to spreadsheet documents are defined in the .TablePageStyle service. The page properties that are valid for both types of documents are defined in the .PageProperties service. Many of the styles that are described are also available for text documents. The following sections describe the main formatting options for spreadsheet pages. For example, headers or footers are added to the page style. Whereas cell, paragraph, and character elements can be formatted directly, page formats can also be defined and indirectly applied using page styles. The procedure for defining page formats differs from other forms of formatting. Page properties are the formatting options that position document content on a page as well as visual elements that are repeated page after page. The Format Cells dialog in Apache OpenOffice Calc provides an overview of the different formatting options for cells. addNew (NumberFormatString, LocalSettings ) End If MsgBox NumberFormatId 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.
0 kommentar(er)
