Character and Paragraph Format

OpenOffice.org Developer's Guide

Spreadsheet Documents

< Previous Section

Next Section >

• Example: Adding a New Spreadsheet
• Example: Editing Spreadsheet Cells

• Handling Spreadsheet Documents Files

• Saving Spreadsheet Documents

• Filter Options

• Printing Spreadsheet Documents

• Working With Spreadsheet Documents

• Spreadsheet Services - Overview

• Capabilities of Spreadsheet
• Capabilities of SheetCellRange
• Capabilities of SheetCell
• Capabilities of SheetCellRanges Container
• Capabilities of Columns and Rows

• Spreadsheet
• Cell Ranges

• Properties of Cell Ranges
• Cell and Cell Range Access
• Merging Cell Ranges into a Single Cell
• Column and Row Access
• Data Array
• Absolute Address
• Fill Series
• Operations
• Multiple Operations
• Handling Array Formulas

• Cells

• Properties of SheetCell
• Access to Formulas, Values and Errors
• Access to Text Content
• Absolute Address
• Cell Annotations

• Cell Ranges and Cells Container
• Columns and Rows

• Formatting

• Character and Paragraph Format
• Indentation
• Equally Formatted Cell Ranges
• Table Auto Formats
• Conditional Formats

• Navigating

• Cell Cursor
• Referencing Ranges by Name
• Named Ranges
• Label Ranges
• Querying for Cells with Specific Properties
• Search and Replace

• Sorting
• Database Operations

• Filtering
• Subtotals
• Database Import
• Database Ranges

• Linking External Data

• Sheet Links
• Cell Area Links
• DDE Links

• DataPilot Tables

• Creating a New DataPilot Table
• Modifying a DataPilot Table
• Removing a DataPilot Table

• DataPilot Sources

• Source Object
• Dimensions
• Hierarchies
• Levels
• Members

• Protecting Spreadsheets
• Sheet Outline
• Detective
• Other Table Operations

• Overall Document Features

• Function Handling
• Settings

• Spreadsheet Document Controller

• View Panes
• View Settings
• Range Selection

• Spreadsheet Add-Ins

• Function Descriptions
• Service Names
• Compatibility Names
• Custom Functions
• Variable Results

< Previous Page

Next Page >

The following services of a cell range contain properties for the character style and paragraph format:

• Service com.sun.star.style.ParagraphProperties
• Service com.sun.star.style.CharacterProperties
• Service com.sun.star.style.CharacterPropertiesAsian
• Service com.sun.star.style.CharacterPropertiesComplex

The chapter Formatting contains a description of these properties.

This example formats a given cell range xCellRange:

  // --- Change cell range properties. ---
  com.sun.star.beans.XPropertySet xPropSet = (com.sun.star.beans.XPropertySet)
      UnoRuntime.queryInterface(com.sun.star.beans.XPropertySet.class, xCellRange);
  
  // from com.sun.star.styles.CharacterProperties
  xPropSet.setPropertyValue("CharColor", new Integer(0x003399));
  xPropSet.setPropertyValue("CharHeight", new Float(20.0));
  
  // from com.sun.star.styles.ParagraphProperties
  xPropSet.setPropertyValue("ParaLeftMargin", new Integer(500));
  
  // from com.sun.star.table.CellProperties
  xPropSet.setPropertyValue("IsCellBackgroundTransparent", new Boolean(false));
  xPropSet.setPropertyValue("CellBackColor", new Integer(0x99CCFF));

The code below changes the character and paragraph formatting of a cell. Assume that xCell is a com.sun.star.table.XCell interface of a spreadsheet cell.

  // --- Change cell properties. ---
  com.sun.star.beans.XPropertySet xPropSet = (com.sun.star.beans.XPropertySet)
      UnoRuntime.queryInterface(com.sun.star.beans.XPropertySet.class, xCell);
  
  // from styles.CharacterProperties
  xPropSet.setPropertyValue("CharColor", new Integer(0x003399));
  xPropSet.setPropertyValue("CharHeight", new Float(20.0));
  
  // from styles.ParagraphProperties
  xPropSet.setPropertyValue("ParaLeftMargin", new Integer(500));
  
  // from table.CellProperties
  xPropSet.setPropertyValue("IsCellBackgroundTransparent", new Boolean(false));
  xPropSet.setPropertyValue("CellBackColor", new Integer(0x99CCFF));

Content on this page is licensed under the Public Documentation License (PDL).