Language:

The Free and Open Productivity Suite
Apache OpenOffice 4.1.4 released

Developer's Guide

API

SDK

Tips 'n' Tricks

Miscellaneous


:: com :: sun :: star :: sheet ::

interface XSheetConditionalEntries
Base Interfaces
XSheetConditionalEntries
┗ ::com::sun::star::container::XIndexAccess
   ┗ ::com::sun::star::container::XElementAccess

::com::sun::star::container::XIndexAccess
(referenced interface's summary:)
provides access to the elements of a collection through an index.
Description
provides methods to add and remove conditions of a conditional format.
See also
TableConditionalFormat, TableConditionalEntry
Developers Guide
Spreadsheets - 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_BETWEEN operations).
::com::sun::star::table::CellAddress SourcePosition
contains the base address for relative cell references in formulas.
string StyleName
contains the name of the cell style used by this condition.
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

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache and the Apache feather logo are trademarks of The Apache Software Foundation. OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.