Overview | Module | Use | Devguide | Index

Methods' Summary | Methods' Details | Attributes' Summary | Attributes' Details

:: com :: sun :: star :: sheet ::
interface XSheetConditionalEntries
  Base Hierarchy
      ::com::sun::star::uno::XInterface
       |
       +-::com::sun::star::container::XElementAccess
          |
          +-::com::sun::star::container::XIndexAccess
             |
             +-XSheetConditionalEntries
Description provides methods to add and remove conditions of a conditional format. See also TableConditionalFormat See also TableConditionalEntry Developers Guide 8.3.2 Spreadsheet Documents - Working with Spreadsheet Documents - Formatting - Conditional Formats

Methods' Summary
addNew | adds a conditional entry to the format.
removeByIndex | removes a conditional entry from the format.
clear | clears all condition entries.

Methods' Details
addNew
void addNew( | [in] sequence< ::com::sun::star::beans::PropertyValue > | aConditionalEntry );
Description adds a conditional entry to the format. Supported properties are: ConditionOperator Operator contains the operation to perform for this condition. `string` Formula1 contains the value or formula for the operation. `string` Formula2 contains the second value or formula for the operation (used with ConditionOperator::BETWEEN or ConditionOperator::NOT_BERWEEN operations). ::com::sun::star::table::CellAddress SourcePosition contains the base address for relative cell references in formulas. See also TableConditionalFormat
removeByIndex
void removeByIndex( | [in] long | nIndex );
Description removes a conditional entry from the format.
clear
void clear(); |  |
Description clears all condition entries.

Top of Page

Copyright © 2003 Sun Microsystems, Inc.